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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCOSET1
  1. TYPE
  2. CODE
PrimaryBN100, BN101, BN102, BN103, BN105, BN106, BN145, BN150 +22 more (list truncated in source)
PCOSET2
  1. CODE
  2. TYPE
HPCO.1, HR204, PA20.1, PA207, PA21.1, PA22.1, PA24.1, PA27.1 +8 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PCODESDTLPCODESTYPEPATHFINDPACOMPPROFPAATTRIBPATRACKPCODES

One to one (2) — lookups and parents

RelationTableRulesConditionField map
PcodesdtlPCODESDTLNot Required
PCO-TYPE→PDD-TYPE
PCO-CODE→PDD-CODE
PcodestypePCODESTYPENot Required
PCO-TYPE→PCS-TYPE

One to many (9) — child tables

RelationTableRulesConditionField map
Bargain EmpsPATHFINDValid When PCO-TYPE = "BU"
22→PTF-FLD-NBR
PCO-CODE→PTF-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-CODE→PCM-CODE
PCO-TYPE→PCM-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-TYPE→TRB-TYPE
PCO-CODE→TRB-CODE
—→TRB-COURSE
Course SkillsPAATTRIBDelete CascadesValid When (PCO-TYPE = "SK")
PCO-TYPE→TRB-TYPE
PCO-CODE→TRB-CODE
—→TRB-COURSE
Location EmpsPATHFINDValid When PCO-TYPE = "LO"
17→PTF-FLD-NBR
PCO-CODE→PTF-FLD-VALUE
—→PTF-COMPANY
—→PTF-EMPLOYEE
—→PTF-POS-LEVEL
ProficiencyPACOMPPROFDelete CascadesValid When (PCO-TYPE = "PF")
PCO-CODE→PCM-PROFIC-LEVEL
—→PCM-COMPANY
—→PCM-PROCESS-LEVEL
—→PCM-TYPE
—→PCM-CODE
Track CertPATRACKValid When PCO-TYPE = "CE"
PCO-CODE→TRA-CERT-ACHIEVED
—→TRA-TRACK
—→TRA-EFFECTIVE-DATE
Union EmpsPATHFINDValid When PCO-TYPE = "UN"
21→PTF-FLD-NBR
PCO-CODE→PTF-FLD-VALUE
—→PTF-COMPANY
—→PTF-EMPLOYEE
—→PTF-POS-LEVEL
User Lev EmpsPATHFINDValid When PCO-TYPE = "UL"
16→PTF-FLD-NBR
PCO-CODE→PTF-FLD-VALUE
—→PTF-COMPANY
—→PTF-EMPLOYEE
—→PTF-POS-LEVEL

Programs

Updated by (100)

Referenced by (390)