Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PCODES


                              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    DA15.1    HGLM.1    HHCN.1
HPCO.1    HPOS.1    HPQC.1    HPRS.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    ZR651     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     UK560
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
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
Element: All Flag      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  DA15.1
                                                                 HGLM.1  HHCN.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