 |
Lawson Insight Technical Documentation |
|
PCODES FILE
Human Resource Code
Contains the values defined for HR codes and for user fields that have valid
values.
REFERENCED BY
AC541 AC542 AC550 AC551 BN145 BN150
BN230 BN231 BN232 BN238 BN240 BN242
BN245 BN246 BN320 BN331 BN335 BN70.1
HC02.3 HCEM.1 HCLO.1 HCOP.1 HCOP.2 HCRV.1
HCUF.1 HCUL.1 HCUN.1 HHCN.1 HPCO.1 HR00.1
HR06.1 HR07.1 HR11.1 HR11.2 HR13.1 HR15.1
HR155 HR170 HR20.1 HR200 HR204 HR211
HR213 HR217 HR220 HR30.1 HR506 HR507
HR511 HR513 HR515 HR54.1 HR55.2 HR55.3
HR650 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
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
PA211 PA212 PA214 PA215 PA216 PA217
PA218 PA22.1 PA220 PA221 PA222 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 PA294 PA296 PA300 PA305
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
PA43.1 PA43.2 PA44.1 PA45.1 PA48.1 PA49.1
PA49.2 PA49.3 PA490 PA496 PA502 PA513
PA52.1 PA52.2 PA52.3 PA52.4 PA52.5 PA520
PA53.1 PA531 PA532 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 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 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 PR36.1
PR37.1 PR45.1 PR529 PR530 PR560 PR80.1
PR82.1 PR84.1 PR89.1 PRSC.1 UK102 TA147
TA175 TA260 TA265 UK120 UK60.1 UK70.1
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCO-TYPE Alpha 2 HR04.2 HR04.3
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
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
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
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
Educational 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
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
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
Web Avail Supv Indicates 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
Workflow This field determines whether you are
using a Workflow system for approving
entries.
N = No
Y = Yes
PCODES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCOSET1 TYPE AC541 AC542
CODE AC550 AC551
BN145 BN150
BN230 BN231
BN232 BN238
BN240 BN242
BN245 BN246
BN320 BN331
BN335 BN70.1
HC02.3 HCEM.1
HCLO.1 HCOP.1
HCOP.2 HCRV.1
HCUF.1 HCUL.1
HCUN.1 HHCN.1
HPCO.1 HR00.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
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
|