EMPCODES FILE
Emp/App Personnel Codes
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.
REFERENCED BY
HR15.1 HR155 HR170 HR511 HR55.2 HR70.1
HS11.1 HS12.1 HS13.1 HS14.1 PA02.1 PA13.1
PA13.2 PA216 PA220 PA221 PA222 PA224
PA225 PA231 PA234 PA235 PA236 PA238
PA262 PA263 PA311 PA502 PA513 PA62.1
PA63.1 PA64.1 PA64.2 PA65.1 PA65.2 TR120
TR121 TR20.1 TR20.2 TR20.3 PR13.1
UPDATED BY
HR54.1 HR700 HRS1.1 HRSC.1 PA100 PA102
PA115 PA120 PA16.1 PA20.1 PA21.1 PA22.1
PA24.1 PA25.1 PA34.1 PA35.1 PA36.1 PA38.1
PA52.1 PA52.3 PA52.4 PA52.5 PA520 PA54.1
TR21.1 TR22.1 TR26.1 TR500 HR11.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EPC-COMPANY Numeric 4 PA16.1 PA20.1
Company Contains the company number represents PA21.1 PA22.1
an established company. PA24.1 PA25.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-TYPE Alpha 2 PA16.1 PA20.1
Type This field indicates the kind of PA21.1 PA22.1
information stored in the record. PA24.1 PA25.1
BN = Benefit Codes PA34.1 PA35.1
CE = Certifications PA36.1 PA38.1
CP = Company Property PA520 TR21.1
ED = Education TR22.1 TR26.1
RL = Relocation TR500
SK = Skills
EPC-EMP-APP Numeric 1 HR54.1 HR700
Type This field contains the employee HRS1.1 HRSC.1
applicant indicator. PA100 PA102
0 = Employee PA20.1 PA21.1
1 = Applicant PA22.1 PA24.1
PA34.1 PA35.1
PA36.1 PA38.1
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
TR21.1 TR22.1
TR26.1 TR500
EPC-EMPLOYEE Numeric 9 HR54.1 HR700
Employee Contains the employee Number HRS1.1 HRSC.1
PA100 PA102
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA25.1
PA34.1 PA35.1
PA36.1 PA38.1
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
TR21.1 TR22.1
TR26.1 TR500
EPC-CODE Alpha 10 PA16.1 PA20.1
Code This is the name of the code being PA21.1 PA22.1
described. All codes must be valid in PA24.1 PA25.1
PCODES. Valid values are: PA34.1 PA35.1
PA36.1 PA38.1
ED = Education Degree. PA520 TR21.1
CP = Property. TR22.1 TR26.1
SK = Skill. TR500
CE = Certification.
RL = Relocation.
BN = Benefit.
EPC-SUBJECT Alpha 10 PA20.1 PA21.1
Subject This field is only filled on "ED" PA22.1 PA24.1
(education records) and contains the PA34.1 PA35.1
subject for the degree. The subject PA36.1 PA38.1
code must be valid in PCODES. PA520 TR21.1
TR22.1 TR500
EPC-SEQ-NBR Numeric 4 HR54.1 HR700
Sequence Number This field is filled for "CP" HRS1.1 HRSC.1
(property), "ED" (education Degree), and PA100 PA102
"SK" (skill) records only and is PA16.1 PA20.1
automatically assigned. PA21.1 PA22.1
PA24.1 PA34.1
PA35.1 PA36.1
PA38.1 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 TR21.1
TR22.1 TR500
EPC-DATE-ACQUIRED Numeric 8 (yyyymmdd) PA16.1 PA20.1
Date Acquired Contains the following: PA21.1 PA22.1
PA24.1 PA34.1
- the date the certificate was acquired, PA35.1 PA36.1
- the date skill was acquired, or PA38.1 PA520
- the date property was issued. TR21.1 TR22.1
TR500
This field is used only for CE
(Certifications), CP (Company Property),
and SK (Skill).
EPC-RENEW-DATE Numeric 8 (yyyymmdd) PA16.1 PA20.1
License Renewal Date This field contains the following PA21.1 PA22.1
information: PA24.1 PA34.1
PA35.1 PA36.1
CE = Certificate renewal date. PA38.1 PA520
CP = Anticipated return date. TR21.1 TR22.1
ED = Degree completion date. TR500
BN = Zeroes.
RL = Zeroes.
SK = Date skill was last used.
EPC-PER-RATING Signed 5.2 PA20.1 PA21.1
Performance Rating This is a user-defined field and is PA22.1 PA24.1
only filled for types "ED" (education PA34.1 PA35.1
degree) and "SK" (skill). PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-INSTRUCTOR Alpha 10 PA20.1 PA21.1
Instructor This field contains the following PA22.1 PA24.1
information: PA34.1 PA35.1
PA36.1 PA38.1
CE = Spaces. PA520 TR21.1
CP = Spaces. TR22.1 TR500
ED = Education Institution.
BN = Spaces.
RL = Spaces.
SK = Skill Instructor.
EPC-CO-SPONSORED Alpha 1 PA20.1 PA21.1
Company Sponsored This field is filled for types "CE" PA22.1 PA24.1
(certification), "ED" (education PA34.1 PA35.1
degree), and "SK" (skill). PA36.1 PA38.1
N = No PA520 TR21.1
N = No TR22.1 TR500
EPC-IN-PRO-FLAG Alpha 1 PA20.1 PA21.1
In Process Flag This field can contain the following PA22.1 PA24.1
information: PA25.1 PA34.1
PA35.1 PA36.1
CE = Spaces. PA38.1 PA520
CP = Spaces. TR21.1 TR22.1
ED = Education in process. TR500
BN = Dependent coverage.
RL = Relocation status.
SK = Space.
(R - Requests transfer
W - Will transfer
N - Will not transfer)
EPC-LIC-NUMBER Alpha 20 PA20.1 PA21.1
License Number This field is filled only for "CE" PA22.1 PA24.1
(certification) and contains the PA34.1 PA35.1
certification license number. PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR500
EPC-COST Signed 11.2 PA20.1 PA21.1
Cost This field is filled only for "CE" PA22.1 PA24.1
(certification) and contains the cost of PA34.1 PA35.1
obtaining the certification. PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR500
EPC-RENEWAL-CODE Alpha 2 PA20.1 PA21.1
Renewal Cycle This field is only filled for "CE" PA22.1 PA24.1
(certification) and "SK" (Skills). PA34.1 PA35.1
2Y = 2 Years PA36.1 PA38.1
3Y = 3 Years PA520 TR21.1
4Y = 4 Years TR22.1 TR500
5Y = 5 Years
6Y = 6 Years
7Y = 7 Years
8Y = 8 Years
9Y = 9 Years
AN = Annual
QT = Quarterly
SA = Semi-annual
EPC-COMPONENT Numeric 4 PA16.1 TR21.1
Component This field is only filled for "CP" TR22.1 TR500
(certification) and gives the component
number of the property issued.
EPC-PROP-VALUE Signed 7.2 PA16.1 TR21.1
Property Value This field is only filled for "CP" TR22.1 TR500
(property) and gives the value of the
company property.
EPC-PA-ASSET-NBR Alpha 9 (Lower Case) PA16.1 TR21.1
Pa Asset Nbr Contains the asset number of the TR22.1 TR500
property issued.
EPC-DATE-RETURNED Numeric 8 (yyyymmdd) PA16.1 PA20.1
Date Returned This field is filled for: PA21.1 PA22.1
- CP (property) and is the date the PA24.1 PA34.1
company property was returned. PA35.1 PA36.1
- SK (skills) and indicates the date by PA38.1 PA520
which the skill should be renewed. TR21.1 TR22.1
TR500
EPC-VERIFIED-FLAG Alpha 1 PA20.1 PA21.1
Verified Flag This field is only filled for "ED" PA22.1 PA24.1
(education degree) for an applicant's PA34.1 PA35.1
record. It indicates if an applicant's PA36.1 PA38.1
education degree has been verified. PA520 TR21.1
N = No TR22.1 TR500
Y = Yes
EPC-PRIORITY-CODE Numeric 1 PA20.1 PA21.1
Priority Code This field is only filled for "RL" PA22.1 PA24.1
(relocation) and with the statuses of PA34.1 PA35.1
"R" (requests transfer) or "W" (will PA36.1 PA38.1
transfer). PA520 TR21.1
TR22.1 TR500
EPC-SKILL-SOURCE Alpha 10 PA20.1 PA21.1
Skill Source This field is only filled for "SK" PA22.1 PA24.1
(Skill). The skill source must be valid PA34.1 PA35.1
in PCODES. PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR500
EPC-PROFIC-LEVEL Alpha 10 PA20.1 PA21.1
Profic Level Contains the proficiency level of the PA22.1 PA24.1
skill. PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-OBJ-ID Numeric 12 PA20.1 PA21.1
Object This is the object identifier. It is PA22.1 PA24.1
Identification used to relate commitments or posted PA34.1 PA35.1
transactions back to the originating PA36.1 PA38.1
subsystems. Each subsystem record that PA520 TR21.1
is updated as a commitment or posted TR22.1 TR26.1
transaction is assigned an object TR500
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.
EPC-CURRENCY-CODE Alpha 5 HR700 PA16.1
Currency Code Contains the currency in which the cost PA20.1 PA21.1
is recorded. PA22.1 PA24.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520
EPC-CURR-ND Numeric 1 HR700 PA16.1
Currency Number of Represents the number of decimals PA20.1 PA21.1
Decimals defined for the currency of the object. PA22.1 PA24.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520
EPC-BASE-AMOUNT Signed 15.2 HR700 PA16.1
Base Amount Contains the amount in the company's PA20.1 PA21.1
base currency. PA22.1 PA24.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520
EPC-BASE-CURRENCY Alpha 5 HR700 PA16.1
Base Currency The company base currency. PA20.1 PA21.1
PA22.1 PA24.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520
EPC-BASE-ND Numeric 1 HR700 PA16.1
Base Number Of The number of decimal positions defined PA20.1 PA21.1
Decimals for the company base currency. PA22.1 PA24.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520
EPC-DATE-STAMP Numeric 8 (yyyymmdd) PA16.1 PA20.1
Date Stamp Contains the server date (month, date, PA21.1 PA22.1
and year) of the last change to this PA24.1 PA25.1
record. PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-TIME-STAMP Numeric 6 (hhmmss) PA16.1 PA20.1
Time Stamp Contains the server time (hour, minute, PA21.1 PA22.1
and second) when the record was last PA24.1 PA25.1
changed. PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-USER-ID Alpha 10 (Lower Case) PA16.1 PA20.1
User ID Name Contains the user ID of the person who PA21.1 PA22.1
last changed this record. PA24.1 PA25.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-STATE Alpha 2 PA20.1 PA21.1
State or Province This field contains the two-character PA22.1 PA24.1
state code of the address. PA34.1 PA35.1
PA36.1 PA38.1
PA520
EMPCODES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EPCSET1 COMPANY HR11.1 HR15.1
TYPE HR155 HR170
EMP-APP HR511 HR54.1
EMPLOYEE HR55.2 HR70.1
CODE HR700 HRS1.1
SUBJECT HRSC.1 HS11.1
SEQ-NBR HS12.1 HS13.1
HS14.1 PA02.1
PA100 PA102
PA115 PA120
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA216
PA22.1 PA220
PA221 PA222
...
EPCSET2 COMPANY
TYPE
EMP-APP
CODE
EMPLOYEE
SUBJECT
SEQ-NBR
EPCSET3 COMPANY Subset
TYPE Where TYPE = "ED"
EMP-APP
SUBJECT
EMPLOYEE
CODE
SEQ-NBR
EPCSET4 COMPANY Subset HR11.1 HR15.1
TYPE Where TYPE = "ED" HR155 HR511
EMP-APP HR54.1 HR55.2
EMPLOYEE HR700 HRS1.1
SUBJECT HRSC.1 PA02.1
CODE PA100 PA102
SEQ-NBR PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA262
PA263 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
...
EPCSET5 COMPANY KeyChange, Subset PA20.1 PA34.1
TYPE Where TYPE = "ED"
EMP-APP
EMPLOYEE
RENEW-DATE
CODE
SUBJECT
SEQ-NBR
EPCSET6 OBJ-ID Subset TR26.1
TYPE Where TYPE = "SK"
COMPANY And OBJ-ID != Zeroes
EMP-APP
EMPLOYEE
CODE
EMPCODES FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When EPC-EMP-APP = 1
EPC-COMPANY -> APL-COMPANY
EPC-EMPLOYEE -> APL-APPLICANT
Base Currency CUCODES Required
When (EPC-CURRENCY-CODE != Spaces )
EPC-BASE-CURRENCY -> CUC-CURRENCY-CODE
Company PRSYSTEM Required
EPC-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
When (EPC-CURRENCY-CODE != Spaces )
EPC-CURRENCY-CODE -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
When EPC-EMP-APP = Zeroes
EPC-COMPANY -> EMP-COMPANY
EPC-EMPLOYEE -> EMP-EMPLOYEE
Hr Code PCODES Required
EPC-TYPE -> PCO-TYPE
EPC-CODE -> PCO-CODE
Institution PCODES Required
When EPC-TYPE = "ED"
And EPC-INSTRUCTOR != Spaces
"EI" -> PCO-TYPE
EPC-INSTRUCTOR -> PCO-CODE
Skill Source PCODES Required
When EPC-SKILL-SOURCE != Spaces
"SS" -> PCO-TYPE
EPC-SKILL-SOURCE -> PCO-CODE
Subject PCODES Required
When EPC-SUBJECT != Spaces
"ES" -> PCO-TYPE
EPC-SUBJECT -> PCO-CODE
EMPCODES FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Course Skills PAATTRIB
Valid When EPC-TYPE = "SK"
EPC-TYPE -> TRB-TYPE
EPC-CODE -> TRB-CODE
TRB-COURSE
|