PCODES – Human Resource Code

System
Human Resources (HR)
Prefix
PCO
Primary key
TYPE, CODE
Fields
14
Updated by
100 programs
Referenced by
390 programs

PCODES is the Human Resource Code table in Lawson Human Resources (prefix PCO). It is indexed by TYPE, CODE (PCOSET1); alternate indexes: PCOSET2. It is related 1:1 to PCODESDTL and PCODESTYPE and 1:M to PATHFIND, PACOMPPROF, PAATTRIB and PATRACK. It is updated by BN100, HR04.2, HR04.3, HR04.4, HR04.5, HR04.6, HR04.7, HR04.8 and 92 more and referenced by BN101, BN102, BN103, BN105, BN106, BN145, BN150, BN16.2 and 382 more. The table has 14 fields, 2 indexes and 11 documented relations.

About PCODES

Contains the values defined for HR codes and for user fields that have valid values.

Fields (14)

Column = COBOL field name without the PCO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PCO-TYPE PK
TYPE
Alpha 2Contains the code types with which valid values are used. Values of 1-99 are numbers assigned to user fields that have valid values associated with them.HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
PCO-CODE PK
CODE
Alpha 10Contains the valid values for each code type.HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
PCO-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)Contains the HR Code or user field description.HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
PCO-ACTIVE-FLAG
ACTIVE_FLAG
Alpha 1Indicates if the code is active or inactive.
  • A Active
  • I Inactive
HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
PCO-EDUC-LEVEL
EDUC_LEVEL
Numeric 3Contains the level associated with ED (Education) type codes.HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
PCO-COUNT
COUNT
Numeric 1
  • 1 Excluded
  • 2 Active
HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
PCO-WEB-AVAILABLE
WEB_AVAILABLE
Alpha 1Indicates if employee can view/update the skill/cert/education code on the Web.
  • 1 Not Available
  • 2 Display Only
  • 3 Update
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)
PCO-WEB-AVAIL-SUPV
WEB_AVAIL_SUPV
Alpha 1Indicates if supervisor can view/update the skill/cert/ education code on the Web.
  • 1 Not Available
  • 2 Display Only
  • 3 Update
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)
PCO-WORKFLOW-FLAG
WORKFLOW_FLAG
Alpha 1This field determines whether you are using a Process Flow application for approving entries.
  • N No
  • Y Yes
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)
PCO-HIPAA-REL-CODE
HIPAA_REL_CODE
Numeric 2
  • 01 Spouse
  • 03 Parent
  • 04 Grandparent
  • 05 Grandchild
  • 06 Uncle or Aunt
  • 07 Nephew or Niece
  • 08 Cousin
  • 09 Adopted Child
  • 10 Foster Child
  • 11 Son- or Daughter-in-law
  • 12 Brither- or Sister-in-law
  • 13 Mother- or Father-in-law
  • 14 Brother or Sister
  • 15 Ward
  • 17 Stepchild
  • 18 Self
  • 19 Child
  • 23 Sponsored Dep
  • 24 Dependent of a Minor Dep
  • 25 Ex-Spouse
  • 26 Guardian
  • 31 Court Appt Guardian
  • 32 Mother
  • 33 Father
  • 38 Collateral Dependent
  • 48 Stepfather
  • 49 Stepmother
  • 53 Life Partner
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)
PCO-HIPAA-REASON
HIPAA_REASON
Alpha 2
  • 01 Divorce
  • 02 Birth
  • 03 Death
  • 04 Retirement
  • 05 Adoption
  • 06 Strike
  • 07 Term Benefits
  • 08 Term Employment
  • 09 COBRA
  • 10 COBRA Premium
  • 11 Survive Spouse
  • 14 Vol Withdrawal
  • 16 Quit
  • 17 Fired
  • 18 Suspended
  • 21 Disability
  • 22 Plan Change
  • 26 Decline Cov
  • 27 Pre-Enrollment
  • 28 Init Enrollment
  • 29 Benefit Selection
  • 31 Legal Separation
  • 32 Marriage
  • 37 LOA w/Benefits
  • 38 LOA w/o Ben
  • 39 Layoff w/Ben
  • 40 Layoff w/o Ben
  • 41 Re-enrollment
  • AI No reason given
  • 43 Change of Location
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)
PCO-RECRUIT-AVAIL
RECRUIT_AVAIL
Alpha 1
  • 1 Not available for use
  • 2 Available for use
PCO-PAY-WORK-FLAG
PAY_WORK_FLAG
Numeric 1This determines whether the day is eligible for pay or not and is assigned to a Day Type Code that is associated with the HRWRKDTL record.
  • 1 NN (Not Paid/Not Worked)
  • 2 PW (Paid/Worked)
  • 3 PN (Paid/Not Worked)
  • 4 NW (Not Paid/Worked
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)
PCO-DP-REL-TYPE
DP_REL_TYPE
Numeric 1Used for the DP (Dependent) type codes to designate whether a Relationship Code applies to a Dependent, Beneficiary, or Both.
  • 0 Both Dependent and Beneficiary
  • 1 Dependent Only
  • 2 Beneficiary Only
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCOSET1TYPE, CODEPrimaryBN100, BN101, BN102, BN103, BN105, BN106, BN145, BN150 +22 more (list truncated in source)
PCOSET2CODE, TYPEHPCO.1, HR204, PA20.1, PA207, PA21.1, PA22.1, PA24.1, PA27.1 +8 more

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
PcodesdtlPCODESDTLNot RequiredPCO-TYPEPDD-TYPE, PCO-CODEPDD-CODE
PcodestypePCODESTYPENot RequiredPCO-TYPEPCS-TYPE

One to many (9) — child tables

RelationTableRulesConditionField map
Bargain EmpsPATHFINDValid When PCO-TYPE = "BU"22PTF-FLD-NBR, PCO-CODEPTF-FLD-VALUE, PTF-COMPANY, PTF-EMPLOYEE, PTF-POS-LEVEL
Comp ProficPACOMPPROFDelete CascadesValid When (PCO-TYPE = "AB") Or (PCO-TYPE = "KN") Or (PCO-TYPE = "OA") Or (PCO-TYPE = "SK")PCO-CODEPCM-CODE, PCO-TYPEPCM-TYPE, PCM-COMPANY, PCM-PROCESS-LEVEL, PCM-SEQ, PCM-PROFIC-LEVEL
Course CompetPAATTRIBDelete CascadesValid When (PCO-TYPE = "AB") Or (PCO-TYPE = "KN") Or (PCO-TYPE = "OA") Or (PCO-TYPE = "SK")PCO-TYPETRB-TYPE, PCO-CODETRB-CODE, TRB-COURSE
Course SkillsPAATTRIBDelete CascadesValid When (PCO-TYPE = "SK")PCO-TYPETRB-TYPE, PCO-CODETRB-CODE, TRB-COURSE
Location EmpsPATHFINDValid When PCO-TYPE = "LO"17PTF-FLD-NBR, PCO-CODEPTF-FLD-VALUE, PTF-COMPANY, PTF-EMPLOYEE, PTF-POS-LEVEL
ProficiencyPACOMPPROFDelete CascadesValid When (PCO-TYPE = "PF")PCO-CODEPCM-PROFIC-LEVEL, PCM-COMPANY, PCM-PROCESS-LEVEL, PCM-TYPE, PCM-CODE
Track CertPATRACKValid When PCO-TYPE = "CE"PCO-CODETRA-CERT-ACHIEVED, TRA-TRACK, TRA-EFFECTIVE-DATE
Union EmpsPATHFINDValid When PCO-TYPE = "UN"21PTF-FLD-NBR, PCO-CODEPTF-FLD-VALUE, PTF-COMPANY, PTF-EMPLOYEE, PTF-POS-LEVEL
User Lev EmpsPATHFINDValid When PCO-TYPE = "UL"16PTF-FLD-NBR, PCO-CODEPTF-FLD-VALUE, PTF-COMPANY, PTF-EMPLOYEE, PTF-POS-LEVEL

Programs

Updated by (100)

Referenced by (390)