Ì i 2
pp.appl.main (main)
[applicant]
*JA.Y[jay]
Field Name Len Dat Typ J DPM Offset/Local/VAL
applicant 42 URN L jay
cd.scr1 15 FREE L MIS.SCREEN
cd.screen 0 FREE L
co.text.editor 0 FREE L VAL=""
co.text.number 8 PINT R PP.TEXT *JA.Y[jay]C
co.text.view 0 FREE L VAL=%Z.view.text(^@Root(@PP.TEXT.lines[@co.text.number
VAL=]),5,23,92,Q(@Z.color.labels1,@Z.color.data1),"",5
VAL=-1)&""
employee 42 URN L PP.PER *JA.Y[jay]|1
id 42 URN L PP.APPL VAL=%["PP.APPL.display.id"](applicant)
name 26 FREE L VAL=IF{@PP.APPL.employee @PP.APPL.employee's.name;@PP.
VAL=APPL.per.name}
number 8 PINT R *JA.Y[jay]|0
per.address1 30 FREE L *JA.Y[jay]JY["0"]|0
per.address2 30 FREE L *JA.Y[jay]JY["0"]|1
per.city 18 FREE L *JA.Y[jay]JY["0"]|2
per.date.of.birth 8 BDATE L *JA.Y[jay]JY|11
per.disability 1 YN L *JA.Y[jay]JY["M1"]|0
per.eeoc 18 CHOICE L *JA.Y[jay]JY|13
per.email.address 40 FREE L *JA.Y[jay]JYEM|0
per.emergency.phone 18 PHONE L *JA.Y[jay]JY|10
per.home.phone 18 PHONE L *JA.Y[jay]JY|9
per.id 42 URN L PP.PER VAL=@PP.PER.number_" "_@PP.PER.name'=" "
per.name 26 NAME L *JA.Y[jay]JY|2
per.other.country 10 FREE L *JA.Y[jay]JY["0"]|6
per.other.country.choice 6 CHOICE L *JA.Y[jay]JY["0"]|5
per.pop.grp 8 FREE L PP.POPUL *JA.Y[jay]JY["M1"]|1
per.postal.code 10 FREE L *JA.Y[jay]JY["0"]|4
per.sex 1 CHOICE L *JA.Y[jay]JY|12
per.si.number 12 FREE L *JA.Y[jay]JY|1
per.sort.name 26 NAME L *JA.Y[jay]JY|3
per.ss.number 12 FREE L *JA.Y[jay]JY|1
per.state 2 FREE L *JA.Y[jay]JY["0"]|3
per.t4.country 10 FREE L *JA.Y[jay]JY["6"]|3
per.t4.country.choice 5 CHOICE L *JA.Y[jay]JY["6"]|2
Ì € i 2
pp.appl.customer.def.queries (customer.def.queries)
[applicant, cd.query]
*JA.Y[jay]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cd.query 10 FREE L MIS.QUERY ggv
cd.response 75 QRY.RESP L *JA.Y[jay]CD[ggv]|0
Ì € i 2
pp.appl.cust.def.mult.queries (customer.def.mult.queries)
[applicant,cd.query, cdm.seq.no]
*JA.Y[jay]CD[ggv]M[ggvN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cdm.seq.no 3 PINT R ggvN
cdm.response 75 QRY.RESP L *JA.Y[jay]CD[ggv]M[ggvN]|0
Ì € i 2
pp.appl.education (education)
[applicant, ed.q]
*JA.Y[jay]E[jayE]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ed.q 2 INT R jayE
ed.degree 8 FREE L PP.DEGREE *JA.Y[jay]E[jayE]|4
ed.degree.yr 4 YEAR L *JA.Y[jay]E[jayE]|5
ed.from.yr 4 YEAR L *JA.Y[jay]E[jayE]|2
ed.institution 40 FREE L *JA.Y[jay]E[jayE]|0
ed.major 8 FREE L PP.MAJOR *JA.Y[jay]E[jayE]|1
ed.thru.yr 4 YEAR L *JA.Y[jay]E[jayE]|3
Ì € i 2
pp.appl.applications (openings)
[applicant, op.q]
*JA.Y[jay]P[jayP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
op.q 2 PINT R jayP
op.appl.date 8 DATE L *JA.Y[jay]P[jayP]|0
op.job 10 FREE L PP.JOB *JA.Y[jay]P[jayP]|8
op.job.25 25 FREE L VAL=IF{L(IF{@PP.JOB.description[@op.job];@PP.JOB.descr
VAL=iption[@PP.POS.job.code[@op.position]];@PP.JOB.des
VAL=cription[@PP.POS.job.code[@PP.OPENING.position[@op
VAL=.opening]]]}^XXX)'>25 XXX;XXX$22_"..."}
op.opening 8 PINT R PP.OPENING *JA.Y[jay]P[jayP]|6
op.pay.desired 10 MONEY R *JA.Y[jay]P[jayP]|11
op.pay.period 5 CHOICE L *JA.Y[jay]P[jayP]|12
op.position 18 FREE L PP.POS *JA.Y[jay]P[jayP]|7
op.position.25 25 FREE L VAL=IF{L(IF{@PP.POS.title[@op.position];@PP.POS.title[
VAL=@PP.OPENING.position[@op.opening]]}^XXX)'>25 XX
VAL=X;XXX$22_"..."}
op.recruiter 10 FREE L MIS.USER *JA.Y[jay]P[jayP]|9
op.recruiter.access 1 YN L *JA.Y[jay]P[jayP]|10
op.ref.source 8 URN L PP.REF.SOURCE *JA.Y[jay]P[jayP]|5
op.ref.type 8 FREE L PP.REF.TYPE *JA.Y[jay]P[jayP]|4
op.status 8 CHOICE L *JA.Y[jay]P[jayP]|1
op.status.date 8 DATE L *JA.Y[jay]P[jayP]|2
op.status.reason 10 FREE L PP.REASON *JA.Y[jay]P[jayP]|3
op.text.editor 0 FREE L VAL=%PP.TEXT.editor(^@op.comments,12,23,84,0,"D"),""
op.text.editor.view 0 FREE L VAL=%PP.APPL.vw.text.editor("val")
op.text.number 8 PINT R PP.TEXT *JA.Y[jay]P[jayP]C
Ì € i 2
pp.appl.interviews (interviews)
[applicant,op.q, iv.q]
*JA.Y[jay]P[jayP]V[jayV]
Field Name Len Dat Typ J DPM Offset/Local/VAL
iv.q 2 PINT R jayV
iv.date 8 DATE L *JA.Y[jay]P[jayP]V[jayV]|3
iv.dept 15 FREE L MIS.GL.DEPT *JA.Y[jay]P[jayP]V[jayV]|8
iv.status 9 CHOICE L *JA.Y[jay]P[jayP]V[jayV]|0
iv.status.date 8 DATE L *JA.Y[jay]P[jayP]V[jayV]|1
iv.status.reason 10 FREE L PP.REASON *JA.Y[jay]P[jayP]V[jayV]|2
iv.text.editor 0 FREE L
iv.text.editor.view 0 FREE L
iv.text.number 8 PINT R PP.TEXT *JA.Y[jay]P[jayP]V[jayV]C
iv.time.from 4 TIME L *JA.Y[jay]P[jayP]V[jayV]|4
iv.time.thru 4 TIME L *JA.Y[jay]P[jayP]V[jayV]|5
iv.user 10 FREE L MIS.USER *JA.Y[jay]P[jayP]V[jayV]|6
iv.user.access 1 YN L *JA.Y[jay]P[jayP]V[jayV]|7
Ì € i 2
pp.appl.routing (routing)
[applicant,op.q, ro.q]
*JA.Y[jay]P[jayP]R[jayR]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ro.q 2 PINT R jayR
ro.dept 15 FREE L MIS.GL.DEPT *JA.Y[jay]P[jayP]R[jayR]|7
ro.return.date 8 DATE L *JA.Y[jay]P[jayP]R[jayR]|4
ro.send.date 8 DATE L *JA.Y[jay]P[jayP]R[jayR]|3
ro.status 10 CHOICE L *JA.Y[jay]P[jayP]R[jayR]|0
ro.status.date 8 DATE L *JA.Y[jay]P[jayP]R[jayR]|1
ro.status.reason 10 FREE L PP.REASON *JA.Y[jay]P[jayP]R[jayR]|2
ro.text.editor 0 FREE L VAL=%PP.TEXT.editor(^@ro.comments,14,18,84,0,"D"),""
ro.text.editor.view 0 FREE L VAL=%PP.APPL.vw.text.editor("val")
ro.text.number 8 PINT R PP.TEXT *JA.Y[jay]P[jayP]R[jayR]C
ro.user 10 FREE L MIS.USER *JA.Y[jay]P[jayP]R[jayR]|5
ro.user.access 1 YN L *JA.Y[jay]P[jayP]R[jayR]|6
Ì € i 2
pp.appl.employee.skills (per.skills)
[applicant, per.skill]
*JA.Y[jay]JY["4",jk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
per.skill 10 FREE L PP.SKILL jk
Ì € i 2
pp.appl.phone.numbers (phone.numbers)
[applicant, ph.q]
*JA.Y[jay]H[jyaH]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ph.q 2 PINT R jyaH
ph.comment 30 FREE L *JA.Y[jay]H[jyaH]|1
ph.empl.home.or.emer 1 CHOICE L *JA.Y[jay]H[jyaH]|2
ph.number 18 PHONE L *JA.Y[jay]H[jyaH]|0
Ì € i 2
pp.appl.work.experience (work.experience)
[applicant, we.q]
*JA.Y[jay]W[jayW]
Field Name Len Dat Typ J DPM Offset/Local/VAL
we.q 2 INT R jayW
we.addr1 35 FREE L *JA.Y[jay]W[jayW]|1
we.addr2 35 FREE L *JA.Y[jay]W[jayW]|2
we.email 40 FREE L *JA.Y[jay]W[jayW]|13
we.from.date 8 DATE L *JA.Y[jay]W[jayW]|4
we.job 10 FREE L PP.WORK *JA.Y[jay]W[jayW]|10
we.more 1 FREE L VAL=%PP.APPL.we.more(^@work.experience)
we.name 35 FREE L *JA.Y[jay]W[jayW]|0
we.phone 18 PHONE L *JA.Y[jay]W[jayW]|3
we.reason.left 10 FREE L PP.REASON *JA.Y[jay]W[jayW]|12
we.salary.final 10 MONEY R *JA.Y[jay]W[jayW]|8
we.salary.initial 10 MONEY R *JA.Y[jay]W[jayW]|7
we.salary.period 5 CHOICE L *JA.Y[jay]W[jayW]|9
we.supervisor 20 FREE L *JA.Y[jay]W[jayW]|11
we.text.editor 0 FREE L VAL=%PP.TEXT.editor(^@we.comments,12,22,84,0,"D"),""
we.text.number 8 PINT R PP.TEXT *JA.Y[jay]W[jayW]C
we.text.view 0 FREE L VAL=%Z.view.text(^@Root(@PP.TEXT.lines[@we.text.number
VAL=]),12,11,84,Q(@Z.color.labels.2nd,@Z.color.data.2n
VAL=d),"",12-1)&""
we.thru.date 8 DATE L *JA.Y[jay]W[jayW]|5
we.years 2 INT R *JA.Y[jay]W[jayW]|6
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
pp.appl.app.dt.letter.x [applicant,print.date,letter,printing]
app.dt.letter.x *JA.YAL[jay,letPD,let,letID]
pp.appl.employee.x [employee] = applicant
employee.x ?JA.YE[jy]
pp.appl.id.x [per.id,applicant]
id.x ?JA.YI[jyI,jay]
pp.appl.interviewer.index [iv.user,applicant,op.q,iv.q]
interviewer.x ?JA.YV[gu,jay,jayP,jayV]
pp.appl.name.x [per.sort.name,applicant]
name.x ?JA.YN[jySN,jay]
pp.appl.opening.index [op.opening,applicant] = op.q
opening.x ?JA.YA[jaa,jay]
pp.appl.recruiter.index [op.recruiter,applicant,op.q]
recruiter.x ?JA.YT[gu,jay,jayP]
pp.appl.ref.source.x [op.ref.source,applicant,op.q]
ref.source.x ?JA.YS[jas,jay,jayP]
pp.appl.ro.user.index [ro.user,applicant,op.q,ro.q]
ro.user.x ?JA.YU[gu,jay,jayP,jayR]
|
|
| | | | | | | | |