EMPCODES – Emp/App Personnel Codes

System
Personnel (PA)
Prefix
EPC
Primary key
COMPANY, TYPE, EMP-APP, EMPLOYEE, CODE, SUBJECT, SEQ-NBR
Fields
36
Updated by
60 programs
Referenced by
151 programs

EMPCODES is the Emp/App Personnel Codes table in Lawson Personnel (prefix EPC). It is indexed by COMPANY, TYPE, EMP-APP, EMPLOYEE, CODE, SUBJECT, SEQ-NBR (EPCSET1); alternate indexes: EPCSET2, EPCSET3, EPCSET4, EPCSET5, EPCSET6 and EPCSET7. It is related 1:1 to APPLICANT, CUCODES, PRSYSTEM, PCODES, EMPLOYEE and PAEMPLOYEE and 1:M to PACOMMENTS, PAATTRIB and PATRACK. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 52 more and referenced by HR04.2, HR04.3, HR04.7, HR04.8, HR15.1, HR155, HR156, HR170 and 143 more. The table has 36 fields, 7 indexes and 19 documented relations.

About EMPCODES

The Emp/App Personnel Codes file is a multi-purpose file containing the following records. Employee and applicant certification Employee company property Employee and applicant education Employee benefits Employee and applicant relocation Employee and applicant skill Records in this file are differentiated by the values in the EPC-TYPE and EPC-EMP-APP fields as described below. Many of the fields in this file have different meanings depending on the type of record. This file is maintained by the Personnel system.

Fields (36)

Column = COBOL field name without the EPC- 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
#EPC-COMPANY PK
COMPANY		Numeric 4Contains the company number represents an established company.PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA25.1, PA27.1, PA34.1 +8 more
#EPC-TYPE PK
TYPE		Alpha 2This field indicates the kind of information stored in the record.
  • BN Benefit Codes
  • CE Certifications
  • CN Contracts
  • CP Company Property
  • ED Education
  • RL Relocation
  • SK Skills
  • AB Ability
  • KN Knowledge
  • OA Other Attributes
  • LC License
PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA25.1, PA27.1, PA34.1 +8 more
#EPC-EMP-APP PK
EMP_APP		Numeric 1This field contains the employee applicant indicator.
  • 0 Employee
  • 1 Applicant
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#EPC-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee NumberBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
#EPC-CODE PK
CODE		Alpha 10This is the name of the code being described. All codes must be valid in PCODES. Valid values are:
  • ED Education Degree.
  • CP Property.
  • SK Skill.
  • CE Certification.
  • RL Relocation.
  • BN Benefit.
PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA25.1, PA27.1, PA34.1 +8 more
#EPC-SUBJECT PK
SUBJECT		Alpha 10This field is only filled on "ED" (education records) and contains the subject for the degree. The subject code must be valid in PCODES.PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-SEQ-NBR PK
SEQ_NBR		Numeric 4This field is filled for "CP" (property), "ED" (education Degree), and "SK" (skill) records only and is automatically assigned.BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +49 more
#EPC-DATE-ACQUIRED SET7
DATE_ACQUIRED		Numeric 8 (yyyymmdd)Contains the following: - the date the certificate was acquired, - the date skill was acquired, or - the date property was issued. This field is used only for CE (Certifications), CP (Company Property), and SK (Skill).PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1 +7 more
#EPC-RENEW-DATE SET5
RENEW_DATE		Numeric 8 (yyyymmdd)This field contains the following information:
  • CE Certificate renewal date.
  • CP Anticipated return date.
  • ED Degree completion date.
  • BN Zeroes.
  • RL Zeroes.
  • SK Date skill was last used.
PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1 +7 more
#EPC-PER-RATING
PER_RATING		Signed 5.2This is a user-defined field and is only filled for types "ED" (education degree) and "SK" (skill).PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-INSTRUCTOR
INSTRUCTOR		Alpha 10This field contains the following information:
  • CE Spaces.
  • CP Spaces.
  • ED Education Institution.
  • BN Spaces.
  • RL Spaces.
  • SK Skill Instructor.
PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-CO-SPONSORED
CO_SPONSORED		Alpha 1This field is filled for types "CE" (certification), "ED" (education degree), and "SK" (skill).
  • Y Yes
  • N No
PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-IN-PRO-FLAG
IN_PRO_FLAG		Alpha 1This field can contain the following information: (R - Requests transfer W - Will transfer N - Will not transfer)
  • CE Spaces.
  • CP Spaces.
  • ED Education in process.
  • BN Dependent coverage.
  • RL Relocation status.
  • SK Space.
  • Y Yes
  • N No
PA20.1, PA21.1, PA22.1, PA24.1, PA25.1, PA27.1, PA34.1, PA35.1 +7 more
#EPC-LIC-NUMBER
LIC_NUMBER		Alpha 20This field is filled only for "CE" (certification) and contains the certification license number.PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-COST
COST		Signed 11.2This field is filled only for "CE" (certification) and contains the cost of obtaining the certification.PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-RENEWAL-CODE
RENEWAL_CODE		Alpha 2This field is only filled for "CE" (certification).
  • 2Y 2 Years
  • 3Y 3 Years
  • 4Y 4 Years
  • 5Y 5 Years
  • 6Y 6 Years
  • 7Y 7 Years
  • 8Y 8 Years
  • 9Y 9 Years
  • AN Annual
  • QT Quarterly
  • SA Semi-annual
PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +4 more
#EPC-COMPONENT
COMPONENT		Numeric 4This field is only filled for "CP" (certification) and gives the component number of the property issued.PA16.1, TR21.1, TR22.1, TR26.1, TR500
#EPC-PROP-VALUE
PROP_VALUE		Signed 15.2This field is only filled for "CP" (property) and gives the value of the company property.PA16.1, TR21.1, TR22.1, TR26.1, TR500
#EPC-PA-ASSET-NBR
PA_ASSET_NBR		Alpha 9 (Lower Case)Contains the asset number of the property issued.PA16.1, TR21.1, TR22.1, TR26.1, TR500
#EPC-DATE-RETURNED
DATE_RETURNED		Numeric 8 (yyyymmdd)This field is only filled for "CP" (property) and is the date the company property was returned.PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1 +7 more
#EPC-VERIFIED-FLAG
VERIFIED_FLAG		Alpha 1This field is only filled for "ED" (education degree) for an applicant's record. It indicates if an applicant's education degree has been verified.
  • N No
  • Y Yes
PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-PRIORITY-CODE
PRIORITY_CODE		Numeric 1This field is only filled for "RL" (relocation) and with the statuses of "R" (requests transfer) or "W" (will transfer).PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-SKILL-SOURCE
SKILL_SOURCE		Alpha 10This field is only filled for "SK" (Skill). The skill source must be valid in PCODES.PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-PROFIC-LEVEL
PROFIC_LEVEL		Alpha 10Contains the proficiency level of the skill.PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-OBJ-ID SET6
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the cost is recorded.PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1 +7 more
#EPC-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1 +7 more
#EPC-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the amount in the company's base currency.PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1 +7 more
#EPC-BASE-CURRENCY
BASE_CURRENCY		Alpha 5The company base currency.PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1 +7 more
#EPC-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1 +7 more
#EPC-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA25.1, PA27.1, PA34.1 +8 more
#EPC-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA25.1, PA27.1, PA34.1 +8 more
#EPC-USER-ID
USER_ID		Alpha 10 (Lower Case)—PA16.1, PA20.1, PA21.1, PA22.1, PA24.1, PA25.1, PA27.1, PA34.1 +8 more
#EPC-STATE
STATE		Alpha 2This field contains the two-character state code of the address.PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +6 more
#EPC-WF-VERIFY
WF_VERIFY		DerivedThis is a derived field.—

Indexes (7)

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
EPCSET1
  1. COMPANY
  2. TYPE
  3. EMP-APP
  4. EMPLOYEE
  5. CODE
  6. SUBJECT
  7. SEQ-NBR
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
EPCSET2
  1. COMPANY
  2. TYPE
  3. EMP-APP
  4. CODE
  5. EMPLOYEE
  6. SUBJECT
  7. SEQ-NBR
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)
EPCSET3
  1. COMPANY
  2. EMP-APP
  3. EMPLOYEE
  4. TYPE
  5. CODE
  6. SUBJECT
  7. SEQ-NBR ↓
SubsetWhere (TYPE = "AB") Or (TYPE = "KN") Or (TYPE = "OA") Or (TYPE = "SK")HR170, HR70.1, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1 +7 more
EPCSET4
  1. COMPANY
  2. TYPE
  3. EMP-APP
  4. EMPLOYEE
  5. SUBJECT
  6. CODE
  7. SEQ-NBR
SubsetWhere TYPE = "ED"BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
EPCSET5
  1. COMPANY
  2. TYPE
  3. EMP-APP
  4. EMPLOYEE
  5. RENEW-DATE
  6. CODE
  7. SUBJECT
  8. SEQ-NBR
KeyChange, SubsetWhere TYPE = "ED"PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +4 more
EPCSET6
  1. OBJ-ID
  2. COMPANY
  3. EMP-APP
  4. EMPLOYEE
  5. TYPE
  6. CODE
SubsetWhere (OBJ-ID != Zeroes)TR21.1, TR26.1
EPCSET7
  1. COMPANY
  2. EMP-APP
  3. EMPLOYEE
  4. TYPE
  5. CODE
  6. DATE-ACQUIRED ↓
  7. SUBJECT
  8. SEQ-NBR
KeyChange, SubsetWhere ((TYPE != "BN") And (TYPE != "RL"))HS11.1, HS11.2, HS12.1, HS12.2, HS13.1, HS13.2, HS50.1, HS50.2 +22 more (list truncated in source)

Relations

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

One to one (11) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen EPC-EMP-APP = 1
EPC-COMPANY→APL-COMPANY
EPC-EMPLOYEE→APL-APPLICANT
Base CurrencyCUCODESRequiredWhen (EPC-CURRENCY-CODE != Spaces)
EPC-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
EPC-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
ContractPCODESRequiredWhen (EPC-TYPE = "CN")
"CN"→PCO-TYPE
EPC-CODE→PCO-CODE
CurrencyCUCODESRequiredWhen (EPC-CURRENCY-CODE != Spaces)
EPC-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredWhen EPC-EMP-APP = Zeroes
EPC-COMPANY→EMP-COMPANY
EPC-EMPLOYEE→EMP-EMPLOYEE
Hr CodePCODESRequired
EPC-TYPE→PCO-TYPE
EPC-CODE→PCO-CODE
InstitutionPCODESRequiredWhen EPC-TYPE = "ED" And EPC-INSTRUCTOR != Spaces
"EI"→PCO-TYPE
EPC-INSTRUCTOR→PCO-CODE
PaemployeePAEMPLOYEERequiredWhen EPC-EMP-APP = Zeroes
EPC-COMPANY→PEM-COMPANY
EPC-EMPLOYEE→PEM-EMPLOYEE
Skill SourcePCODESRequiredWhen EPC-SKILL-SOURCE != Spaces
"SS"→PCO-TYPE
EPC-SKILL-SOURCE→PCO-CODE
SubjectPCODESRequiredWhen EPC-SUBJECT != Spaces
"ES"→PCO-TYPE
EPC-SUBJECT→PCO-CODE

One to many (8) — child tables

RelationTableRulesConditionField map
Bn CommentsPACOMMENTSDelete CascadesValid When EPC-TYPE = "BN"
EPC-COMPANY→PAC-COMPANY
Zeroes→PAC-EMP-APP
"BN"→PAC-CMT-TYPE
EPC-EMPLOYEE→PAC-EMPLOYEE
Spaces→PAC-JOB-CODE
Spaces→PAC-ACTION-CODE
Zeroes→PAC-LN-NBR
—→PAC-SEQ-NBR
—→PAC-DATE
Ce CommentsPACOMMENTSDelete CascadesValid When EPC-TYPE = "CE"
EPC-COMPANY→PAC-COMPANY
Zeroes→PAC-EMP-APP
"CE"→PAC-CMT-TYPE
EPC-EMPLOYEE→PAC-EMPLOYEE
Spaces→PAC-JOB-CODE
Spaces→PAC-ACTION-CODE
Zeroes→PAC-LN-NBR
—→PAC-SEQ-NBR
—→PAC-DATE
Course SkillsPAATTRIBValid When (EPC-TYPE = "AB") Or (EPC-TYPE = "SK") Or (EPC-TYPE = "KN") Or (EPC-TYPE = "OA") Or (EPC-TYPE = "CE")
EPC-TYPE→TRB-TYPE
EPC-CODE→TRB-CODE
—→TRB-COURSE
Cp CommentsPACOMMENTSDelete CascadesValid When EPC-TYPE = "CP"
EPC-COMPANY→PAC-COMPANY
Zeroes→PAC-EMP-APP
"CP"→PAC-CMT-TYPE
EPC-EMPLOYEE→PAC-EMPLOYEE
Spaces→PAC-JOB-CODE
Spaces→PAC-ACTION-CODE
Zeroes→PAC-LN-NBR
—→PAC-SEQ-NBR
—→PAC-DATE
Ed CommentsPACOMMENTSDelete CascadesValid When EPC-TYPE = "ED"
EPC-COMPANY→PAC-COMPANY
Zeroes→PAC-EMP-APP
"ED"→PAC-CMT-TYPE
EPC-EMPLOYEE→PAC-EMPLOYEE
Spaces→PAC-JOB-CODE
Spaces→PAC-ACTION-CODE
Zeroes→PAC-LN-NBR
—→PAC-SEQ-NBR
—→PAC-DATE
Rl CommentsPACOMMENTSDelete CascadesValid When EPC-TYPE = "RL"
EPC-COMPANY→PAC-COMPANY
Zeroes→PAC-EMP-APP
"RL"→PAC-CMT-TYPE
EPC-EMPLOYEE→PAC-EMPLOYEE
Spaces→PAC-JOB-CODE
Spaces→PAC-ACTION-CODE
Zeroes→PAC-LN-NBR
—→PAC-SEQ-NBR
—→PAC-DATE
Sk CommentsPACOMMENTSDelete CascadesValid When (EPC-TYPE = "AB") Or (EPC-TYPE = "KN") Or (EPC-TYPE = "OA") Or (EPC-TYPE = "SK")
EPC-COMPANY→PAC-COMPANY
Zeroes→PAC-EMP-APP
"SK"→PAC-CMT-TYPE
EPC-EMPLOYEE→PAC-EMPLOYEE
Spaces→PAC-JOB-CODE
Spaces→PAC-ACTION-CODE
Zeroes→PAC-LN-NBR
—→PAC-SEQ-NBR
—→PAC-DATE
Track CertPATRACKValid When EPC-TYPE = "CE"
EPC-CODE→TRA-CERT-ACHIEVED
—→TRA-TRACK
—→TRA-EFFECTIVE-DATE

Programs

Updated by (60)

Referenced by (151)