Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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