 |
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
BN231 BN232 BN238 BN240 BN245 BN246
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 HR07.1 HR13.1 HR15.1
HR155 HR170 HR200 HR204 HR211 HR213
HR217 HR220 HR30.1 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 PA07.1 PA08.1 PA08.2
PA08.3 PA111 PA120 PA149 PA16.1 PA17.1
PA172 PA18.1 PA202 PA207 PA208 PA211
PA212 PA214 PA215 PA216 PA217 PA218
PA220 PA221 PA222 PA224 PA225 PA231
PA234 PA235 PA236 PA238 PA241 PA242
PA248 PA249 PA25.1 PA259 PA26.1 PA262
PA263 PA272 PA290 PA294 PA296 PA300
PA305 PA31.1 PA310 PA311 PA315 PA32.1
PA320 PA325 PA330 PA335 PA345 PA350
PA355 PA360 PA370 PA372 PA391 PA40.1
PA41.1 PA42.1 PA43.1 PA43.2 PA44.1 PA45.1
PA48.1 PA49.1 PA49.2 PA49.3 PA490 PA502
PA513 PA53.1 PA531 PA532 PA54.1 PA549
PA570 PA59.1 PA59.2 PA590 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.4 PA94.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
TR210 TR22.1 TR500 PR03.1 PR128 PR13.1
PR13.5 PR13.6 PR13.7 PR13.8 PR131 PR132
PR134 PR136 PR139 PR212 PR214 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 PR530 PR82.1 UK102
TA175 TA260 TA265 UK120 UK60.1 UK70.1
PA96.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
AB = Ability HR80.6 HR80.7
AC = Accommodation HR80.8 HR80.9
AP = Travel Doc Application Status HR81.1 HR81.2
AR = Applicant Rating HR81.3 HR81.4
AS = Association HR81.5 HR81.6
BD = Budget Reason HR81.7 HR81.8
BN = Benefit HR81.9 HR82.1
BO = Bilingual Office HR82.2 HR82.3
BP = Body Part HR82.4 HR82.5
BR = Bilingual Region HR82.6 HR82.7
BU = Bargaining Unit HR82.8 HR82.9
CA = CMA Code - Canada HR83.1 HR83.2
CC = Course Category HR83.3 HR83.4
CE = Certification HR83.5 HR83.6
CM = Communication Method HR83.7 HR83.8
CN = Contract Type HR83.9 HR84.1
CO = Requisition Cost HR84.2 HR84.3
CP = Company Property HR84.4 HR84.5
CQ = Change Request HR84.6 HR84.7
CR = Change Reason HR84.8 HR84.9
CS = CEU Source HR85.1 HR85.2
CT = Course Type HR85.3 HR85.4
DI = Disability HR85.5 HR85.6
DO = Work Eligibility Document HR85.7 HR85.8
DP = Dependent Relationship HR86.1 HR86.2
DR = Data Requested ...
DT = Work Eligibility Document Type
EC = Environmental Conditions
ED = Education Degree
EI = Education Institution
EM = Emergency Medical
EO = Equipment Operated
ER = Extension Reason
ES = Education Subject
ET = Estabishment
FA = Follow Up Category
FC = Facility
FO = Follow Up Outcome
FS = Follow Up Status
FT = Follow Up Type
GA = Griev Disc Action Step Cat
GC = Griev Disc Category
GO = Griev Disc Outcome
GP = Griev Disc Action Step Type
GS = Griev Disc Status
GT = Griev Disc Action Step Outcome
HS = Hire Source
HO = Incident Hospital
IC = Incident Category
IE = Incident Severity
IL = Illness
IN = Incident
IO = Incident Outcome
IR = Interview Rating
IS = Incident Status
I2 = Incident User 2
I3 = Incident User 3
KN = Knowledge
LO = Location
MC = Cost Category
MG = Mail Group
MR = Mental Requirements
MT = Cost Type
NC = NOC - Canada
ND = Industry Class - Canada
NT = Contact Number Type
OA = Other Attributes
OC = Incident Cost Category
OT = Incident Cost Type
PC = Primary Care Physician
PF = Proficiency Level
PH = Physical Requirements
PL = Parking Lot
PO = Position Reason
PR = Performance Rating
PY = Physician
RA = Personnel Action Reason
RC = Reason for Cancellation
RE = Religion
RL = Relocation
RP = Report Province
RQ = Requisition Status
RS = Reason
RT = Review Type
SC = Internal Security
SK = Skill
SR = Supervisor Received
SS = Competency/Cert Source
SU = Supervisor
S1 = Supervisor User Field 1
S2 = Supervisor User Field 2
S3 = Supervisor User Field 3
S4 = Supervisor User Field 4
S5 = Supervisor User Field 5
TA = Test Reason
TD = Travel Document
TE = Test Override Reason
TF = Test Refusal Reason
TL = Test Letter
TN = Test Notify Type
TO = Test Location
TR = Travel
TS = Test Source
TT = Test Type
T2 = Test User 2
T3 = Test User 3
UL = User-defined Level
UN = Union
WE = Work Eligibility Status
WR = Work Restriction
WS = Work Schedule
01 = User Field
99 = User Field
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
BN231 BN232
BN238 BN240
BN245 BN246
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 HR04.2
HR04.3 HR04.4
...
PCOSET2 CODE HPCO.1 HR204
TYPE PA96.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
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
|