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 BN305 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN320 BN331 BN335
BN47.1 BN53.1 BN531 BN532 BN547 BN70.1
BN71.1 BN72.1 BS03.1 BS03.2 BS03.3 BS32.1
ET530 ET700 ETI2.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 LP01.1
LP100 LP101 LP130 LP140 LP145 LP188
LP197 LP201 LP231 LP240 LP251 LP260
LP262 LP264 LP51.1 HS00.1 HS11.1 HS11.2
HS12.1 HS12.2 HS13.1 HS13.2 HS14.1 HS50.1
HS50.2 HS50.3 HS50.4 HS51.1 HS51.2 HS52.1
HS52.2 HS701 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 PA490 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 PR139 PR189 PR212 PR214
PR252 PR29.1 PR297 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
PR80.1 PR82.1 PR84.1 PR89.1 UK102 UK560
TA147 TA175 TA260 TA265 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 HR91.7
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: Active Flag 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: Educ Level Contains 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 Flag This field determines whether you are HR04.7 HR04.8
using a Process Flow application for HR80.1 HR80.2
approving 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
43 = Change of Location ...
PCO-RECRUIT-AVAIL Alpha 1
Element: Recruit Avail 1 = Not available for use
2 = Available for use
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 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN335
...
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
|