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.

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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
EPCSET1COMPANY, TYPE, EMP-APP, EMPLOYEE, CODE, SUBJECT, SEQ-NBRPrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
EPCSET2COMPANY, TYPE, EMP-APP, CODE, EMPLOYEE, SUBJECT, SEQ-NBRHR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)
EPCSET3COMPANY, EMP-APP, EMPLOYEE, TYPE, CODE, SUBJECT, 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
EPCSET4COMPANY, TYPE, EMP-APP, EMPLOYEE, SUBJECT, CODE, SEQ-NBRSubsetWhere TYPE = "ED"BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
EPCSET5COMPANY, TYPE, EMP-APP, EMPLOYEE, RENEW-DATE, CODE, SUBJECT, SEQ-NBRKeyChange, SubsetWhere TYPE = "ED"PA20.1, PA21.1, PA22.1, PA24.1, PA27.1, PA34.1, PA35.1, PA36.1 +4 more
EPCSET6OBJ-ID, COMPANY, EMP-APP, EMPLOYEE, TYPE, CODESubsetWhere (OBJ-ID != Zeroes)TR21.1, TR26.1
EPCSET7COMPANY, EMP-APP, EMPLOYEE, TYPE, CODE, DATE-ACQUIRED*, SUBJECT, SEQ-NBRKeyChange, 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

One to one (11) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen EPC-EMP-APP = 1EPC-COMPANY → APL-COMPANY, EPC-EMPLOYEE → APL-APPLICANT
Base CurrencyCUCODESRequiredWhen (EPC-CURRENCY-CODE != Spaces)EPC-BASE-CURRENCY → CUC-CURRENCY-CODE
CompanyPRSYSTEMRequiredEPC-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 = ZeroesEPC-COMPANY → EMP-COMPANY, EPC-EMPLOYEE → EMP-EMPLOYEE
Hr CodePCODESRequiredEPC-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 = ZeroesEPC-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)