Lawson Insight Technical Documentation |
|
PCODES
PCODES FILE
Human Resource Code
Contains the values defined for HR codes and for user fields that have valid
values.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN106
BN145 BN150 BN16.2 BN16.3 BN16.4 BN216
BN230 BN231 BN232 BN234 BN238 BN240
BN242 BN245 BN246 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN320 BN331 BN335 BN53.1
BN531 BN532 BN70.1 BN71.1 BN72.1 BS03.1
BS03.2 BS03.3 BS32.1 HC02.5 HCDL.1 HCEM.1
HCHP.1 HCRV.1 HAP3.1 HEP4.1 HHCN.1 HPCO.1
HPOS.1 HPQC.1 HPRS.1 HR00.1 HR07.1 HR11.1
HR11.2 HR13.1 HR13.2 HR13.3 HR13.4 HR15.1
HR155 HR170 HR20.1 HR200 HR204 HR206
HR211 HR213 HR217 HR22.1 HR220 HR222
HR30.1 HR507 HR511 HR513 HR515 HR54.1
HR55.2 HR55.3 HR70.1 HRS1.1 HRSC.1 HS00.1
HS11.1 HS12.1 HS13.1 HS14.1 HS50.1 HS50.2
HS50.3 HS50.4 HS51.1 HS51.2 HS52.1 HS52.2
PA02.1 PA07.1 PA08.1 PA08.2 PA08.3 PA100
PA102 PA103 PA111 PA113 PA115 PA120
PA13.1 PA13.2 PA149 PA15.1 PA15.2 PA16.1
PA17.1 PA172 PA18.1 PA20.1 PA202 PA207
PA208 PA21.1 PA210 PA211 PA212 PA214
PA215 PA216 PA217 PA218 PA22.1 PA220
PA221 PA222 PA223 PA224 PA225 PA227
PA231 PA234 PA235 PA236 PA238 PA24.1
PA241 PA242 PA248 PA249 PA25.1 PA259
PA26.1 PA262 PA263 PA27.1 PA272 PA290
PA292 PA294 PA296 PA31.1 PA310 PA311
PA315 PA32.1 PA320 PA325 PA330 PA335
PA34.1 PA345 PA35.1 PA350 PA355 PA36.1
PA360 PA370 PA372 PA38.1 PA390 PA391
PA40.1 PA41.1 PA42.1 PA42.3 PA43.1 PA43.2
PA44.1 PA45.1 PA48.1 PA49.1 PA49.2 PA49.3
PA495 PA496 PA502 PA513 PA52.1 PA52.2
PA52.3 PA52.4 PA52.5 PA520 PA53.1 PA531
PA532 PA534 PA535 PA54.1 PA549 PA570
PA59.1 PA59.2 PA590 PA594 PA62.1 PA63.1
PA64.1 PA64.2 PA65.1 PA65.2 PA66.2 PA66.3
PA66.4 PA70.1 PA71.1 PA72.1 PA73.1 PA90.1
PA90.2 PA90.3 PA91.1 PA92.2 PA93.2 PA93.4
PA94.1 PA96.1 TR00.1 TR01.1 TR02.1 TR03.1
TR04.1 TR05.1 TR10.1 TR11.1 TR12.1 TR120
TR121 TR20.1 TR20.2 TR20.3 TR200 TR201
TR202 TR204 TR205 TR21.1 TR210 TR22.1
TR26.1 TR500 PR03.1 PR110 PR113 PR120
PR128 PR13.1 PR13.5 PR13.6 PR13.7 PR13.8
PR130 PR131 PR132 PR134 PR136 PR212
PR214 PR29.1 PR30.1 PR313 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR37.1 PR45.1 PR529 PR530 PR560 PR82.1
PR84.1 PRSC.1 UK102 TA147 TA175 TA260
TA265 TP135 PR282
UPDATED BY
HR04.2 HR04.3 HR04.7 HR04.8 HR04.9 HR04.4
HR04.5 HR04.6 HR80.1 HR80.2 HR80.3 HR80.4
HR80.5 HR80.6 HR80.7 HR80.8 HR80.9 HR81.1
HR81.2 HR81.3 HR81.4 HR81.5 HR81.6 HR81.7
HR81.8 HR81.9 HR82.1 HR82.2 HR82.3 HR82.4
HR82.5 HR82.6 HR82.7 HR82.8 HR82.9 HR83.1
HR83.2 HR83.3 HR83.4 HR83.5 HR83.6 HR83.7
HR83.8 HR83.9 HR84.1 HR84.2 HR84.3 HR84.4
HR84.5 HR84.6 HR84.7 HR84.8 HR84.9 HR85.1
HR85.2 HR85.3 HR85.4 HR85.5 HR85.6 HR85.7
HR85.8 HR86.1 HR86.2 HR86.3 HR86.4 HR86.5
HR86.6 HR86.7 HR86.8 HR86.9 HR87.1 HR87.2
HR87.3 HR87.4 HR87.5 HR87.6 HR87.7 HR87.8
HR87.9 HR88.1 HR88.2 HR88.3 HR88.4 HR88.5
HR88.6 HR88.7 HR89.1 HR89.2 HR89.3 HR89.4
HR89.5 HR89.6 HR89.7 HR89.8 HR89.9
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCO-TYPE Alpha 2 HR04.2 HR04.3
Element: Type Contains the code types with which HR04.7 HR04.8
valid values are used. Values of 1-99 HR04.9 HR80.1
are numbers assigned to user fields that HR80.2 HR80.3
have valid values associated with them. HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PCO-CODE Alpha 10 HR04.2 HR04.3
Element: Code Contains the valid values for each code HR04.7 HR04.8
type. HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PCO-DESCRIPTION Alpha 30 (Lower Case) HR04.2 HR04.3
Element: Description Contains the HR Code or user field HR04.7 HR04.8
description. HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PCO-ACTIVE-FLAG Alpha 1 HR04.2 HR04.3
Element: Status Indicates if the code is active or HR04.7 HR04.8
inactive. HR04.9 HR80.1
A = Active HR80.2 HR80.3
I = Inactive HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PCO-EDUC-LEVEL Numeric 3 HR04.2 HR04.3
Element: Educational LeContains the level associated with ED HR04.7 HR04.8
(Education) type codes. HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PCO-COUNT Numeric 1 HR04.2 HR04.3
Element: Count 1 = Excluded HR04.7 HR04.8
2 = Active HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
...
PCO-WEB-AVAILABLE Alpha 1 HR04.2 HR04.3
Element: Web Available Indicates if employee can view/update HR04.7 HR04.8
the skill/cert/education code on the HR80.1 HR80.2
Web. HR80.3 HR80.4
1 = Not Available HR80.5 HR80.6
2 = Display Only HR80.7 HR80.8
3 = Update HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
...
PCO-WEB-AVAIL-SUPV Alpha 1 HR04.2 HR04.3
Element: Web Avail SupvIndicates if supervisor can view/update HR04.7 HR04.8
the skill/cert/ education code on the HR80.1 HR80.2
Web. HR80.3 HR80.4
1 = Not Available HR80.5 HR80.6
2 = Display Only HR80.7 HR80.8
3 = Update HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
...
PCO-WORKFLOW-FLAG Alpha 1 HR04.2 HR04.3
Element: Workflow This field determines whether you are HR04.7 HR04.8
using a Workflow system for approving HR80.1 HR80.2
entries. HR80.3 HR80.4
N = No HR80.5 HR80.6
Y = Yes HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
...
PCO-HIPAA-REL-CODE Numeric 2 HR04.2 HR04.3
Element: Hipaa Rel Code01 = Spouse HR04.7 HR04.8
03 = Parent HR80.1 HR80.2
04 = Grandparent HR80.3 HR80.4
05 = Grandchild HR80.5 HR80.6
06 = Uncle or Aunt HR80.7 HR80.8
07 = Nephew or Niece HR80.9 HR81.1
08 = Cousin HR81.2 HR81.3
09 = Adopted Child HR81.4 HR81.5
10 = Foster Child HR81.6 HR81.7
11 = Son- or Daughter-in-law HR81.8 HR81.9
12 = Brither- or Sister-in-law HR82.1 HR82.2
13 = Mother- or Father-in-law HR82.3 HR82.4
14 = Brother or Sister HR82.5 HR82.6
15 = Ward HR82.7 HR82.8
17 = Stepchild HR82.9 HR83.1
18 = Self HR83.2 HR83.3
19 = Child HR83.4 HR83.5
23 = Sponsored Dep HR83.6 HR83.7
24 = Dependent of a Minor Dep HR83.8 HR83.9
25 = Ex-Spouse HR84.1 HR84.2
26 = Guardian HR84.3 HR84.4
31 = Court Appt Guardian HR84.5 HR84.6
32 = Mother HR84.7 HR84.8
33 = Father HR84.9 HR85.1
38 = Collateral Dependent HR85.2 HR85.3
48 = Stepfather HR85.4 HR85.5
49 = Stepmother HR85.6 HR85.7
53 = Life Partner HR85.8 HR86.1
HR86.2 HR86.3
...
PCO-HIPAA-REASON Alpha 2 HR04.2 HR04.3
Element: Hipaa Reason 01 = Divorce HR04.7 HR04.8
02 = Birth HR80.1 HR80.2
03 = Death HR80.3 HR80.4
04 = Retirement HR80.5 HR80.6
05 = Adoption HR80.7 HR80.8
06 = Strike HR80.9 HR81.1
07 = Term Benefits HR81.2 HR81.3
08 = Term Employment HR81.4 HR81.5
09 = COBRA HR81.6 HR81.7
10 = COBRA Premium HR81.8 HR81.9
11 = Survive Spouse HR82.1 HR82.2
14 = Vol Withdrawal HR82.3 HR82.4
16 = Quit HR82.5 HR82.6
17 = Fired HR82.7 HR82.8
18 = Suspended HR82.9 HR83.1
21 = Disability HR83.2 HR83.3
22 = Plan Change HR83.4 HR83.5
26 = Decline Cov HR83.6 HR83.7
27 = Pre-Enrollment HR83.8 HR83.9
28 = Init Enrollment HR84.1 HR84.2
29 = Benefit Selection HR84.3 HR84.4
31 = Legal Separation HR84.5 HR84.6
32 = Marriage HR84.7 HR84.8
37 = LOA w/Benefits HR84.9 HR85.1
38 = LOA w/o Ben HR85.2 HR85.3
39 = Layoff w/Ben HR85.4 HR85.5
40 = Layoff w/o Ben HR85.6 HR85.7
41 = Re-enrollment HR85.8 HR86.1
AI = No reason given HR86.2 HR86.3
...
PCODES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCOSET1 TYPE BN100 BN101
CODE BN102 BN103
BN105 BN106
BN145 BN150
BN16.2 BN16.3
BN16.4 BN216
BN230 BN231
BN232 BN234
BN238 BN240
BN242 BN245
BN246 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN320 BN331
BN335 BN53.1
...
PCOSET2 CODE HPCO.1 HR204
TYPE PA20.1 PA207
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 PA96.1
TR21.1 TR26.1
PR282
PCODES FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pcodesdtl PCODESDTL Not Required
PCO-TYPE -> PDD-TYPE
PCO-CODE -> PDD-CODE
Pcodestype PCODESTYPE Not Required
PCO-TYPE -> PCS-TYPE
PCODES FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bargain Emps PATHFIND
Valid When PCO-TYPE = "BU"
22 -> PTF-FLD-NBR
PCO-CODE -> PTF-FLD-VALUE
PTF-COMPANY
PTF-EMPLOYEE
PTF-POS-LEVEL
Comp Profic PACOMPPROF Delete Cascades
Valid When (PCO-TYPE = "AB" )
Or (PCO-TYPE = "KN" )
Or (PCO-TYPE = "OA" )
Or (PCO-TYPE = "SK" )
PCO-CODE -> PCM-CODE
PCO-TYPE -> PCM-TYPE
PCM-COMPANY
PCM-PROCESS-LEVEL
PCM-SEQ
PCM-PROFIC-LEVEL
Course Compet PAATTRIB Delete Cascades
Valid When (PCO-TYPE = "AB" )
Or (PCO-TYPE = "KN" )
Or (PCO-TYPE = "OA" )
Or (PCO-TYPE = "SK" )
PCO-TYPE -> TRB-TYPE
PCO-CODE -> TRB-CODE
TRB-COURSE
Course Skills PAATTRIB Delete Cascades
Valid When (PCO-TYPE = "SK" )
PCO-TYPE -> TRB-TYPE
PCO-CODE -> TRB-CODE
TRB-COURSE
Location Emps PATHFIND
Valid When PCO-TYPE = "LO"
17 -> PTF-FLD-NBR
PCO-CODE -> PTF-FLD-VALUE
PTF-COMPANY
PTF-EMPLOYEE
PTF-POS-LEVEL
Proficiency PACOMPPROF Delete Cascades
Valid When (PCO-TYPE = "PF" )
PCO-CODE -> PCM-PROFIC-LEVEL
PCM-COMPANY
PCM-PROCESS-LEVEL
PCM-TYPE
PCM-CODE
Track Cert PATRACK
Valid When PCO-TYPE = "CE"
PCO-CODE -> TRA-CERT-ACHIEVED
TRA-TRACK
TRA-EFFECTIVE-DATE
Union Emps PATHFIND
Valid When PCO-TYPE = "UN"
21 -> PTF-FLD-NBR
PCO-CODE -> PTF-FLD-VALUE
PTF-COMPANY
PTF-EMPLOYEE
PTF-POS-LEVEL
User Lev Emps PATHFIND
Valid When PCO-TYPE = "UL"
16 -> PTF-FLD-NBR
PCO-CODE -> PTF-FLD-VALUE
PTF-COMPANY
PTF-EMPLOYEE
PTF-POS-LEVEL
|