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 HR650
HR70.1 HS11.1 HS12.1 HS13.1 HS14.1 HS50.1
HS50.2 HS50.3 HS50.4 HS51.1 HS51.2 HS52.1
HS52.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 PR13.5
PR13.6 PR13.8 HR04.2 HR04.3 HR04.7 HR04.8
HR80.1 HR80.2 HR80.3 HR80.4 HR80.5 HR80.6
HR80.7 HR80.8 HR80.9 HR81.1 HR81.2 HR81.3
HR81.4 HR81.5 HR81.6 HR81.7 HR81.8 HR81.9
HR82.1 HR82.2 HR82.3 HR82.4 HR82.5 HR82.6
HR82.7 HR82.8 HR82.9 HR83.1 HR83.2 HR83.3
HR83.4 HR83.5 HR83.6 HR83.7 HR83.8 HR83.9
HR84.1 HR84.2 HR84.3 HR84.4 HR84.5 HR84.6
HR84.7 HR84.8 HR84.9 HR85.1 HR85.2 HR85.3
HR85.4 HR85.5 HR85.6 HR85.7 HR85.8 HR86.1
HR86.2 HR86.3 HR86.4 HR86.5 HR86.6 HR86.7
HR86.8 HR86.9 HR87.1 HR87.2 HR87.3 HR87.4
HR87.5 HR87.6 HR87.7 HR87.8 HR87.9 HR88.1
HR88.2 HR88.3 HR88.4 HR88.5 HR88.6 HR88.7
HR89.1 HR89.2 HR89.3 HR89.4 HR89.5 HR89.6
HR89.7
UPDATED BY
HR54.1 HRS1.1 HRSC.1 PA120 PA16.1 PA25.1
PA54.1 TR22.1 TR500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EPC-COMPANY Numeric 4 PA16.1 PA25.1
Company Contains the company number represents TR22.1 TR500
an established company.
EPC-TYPE Alpha 2 PA16.1 PA25.1
Type This field indicates the kind of TR22.1 TR500
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
EPC-EMP-APP Numeric 1 HR54.1 HRS1.1
Type This field contains the employee HRSC.1 HS50.1
applicant indicator. HS50.2 HS51.1
0 = Employee HS51.2 HS52.1
1 = Applicant HS52.2 PA54.1
TR120 TR121
TR20.1 TR20.2
TR20.3 TR22.1
TR500
EPC-EMPLOYEE Numeric 9 HR54.1 HRS1.1
Employee Contains the employee Number HRSC.1 HS50.1
HS50.2 HS51.1
HS51.2 HS52.1
HS52.2 PA16.1
PA25.1 PA54.1
TR120 TR121
TR20.1 TR20.2
TR20.3 TR22.1
TR500
EPC-CODE Alpha 10 PA16.1 PA25.1
Code This is the name of the code being TR22.1 TR500
described. All codes must be valid in
PCODES. Valid values are:
ED = Education Degree.
CP = Property.
SK = Skill.
CE = Certification.
RL = Relocation.
BN = Benefit.
EPC-SUBJECT Alpha 10 TR22.1 TR500
Subject This field is only filled on "ED"
(education records) and contains the
subject for the degree. The subject
code must be valid in PCODES.
EPC-SEQ-NBR Numeric 4 HR54.1 HRS1.1
Sequence Number This field is filled for "CP" HRSC.1 PA16.1
(property), "ED" (education Degree), and PA54.1 TR22.1
"SK" (skill) records only and is TR500
automatically assigned.
EPC-DATE-ACQUIRED Numeric 8 (yyyymmdd) PA16.1 TR22.1
Date Acquired Contains the following: TR500
- 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).
EPC-RENEW-DATE Numeric 8 (yyyymmdd) PA16.1 TR22.1
License Renewal Date This field contains the following TR500
information:
CE = Certificate renewal date.
CP = Anticipated return date.
ED = Degree completion date.
BN = Zeroes.
RL = Zeroes.
SK = Date skill was last used.
EPC-PER-RATING Signed 5.2 TR22.1 TR500
Performance Rating This is a user-defined field and is
only filled for types "ED" (education
degree) and "SK" (skill).
EPC-INSTRUCTOR Alpha 10 TR22.1 TR500
Instructor This field contains the following
information:
CE = Spaces.
CP = Spaces.
ED = Education Institution.
BN = Spaces.
RL = Spaces.
SK = Skill Instructor.
EPC-CO-SPONSORED Alpha 1 TR22.1 TR500
Company Sponsored This field is filled for types "CE"
(certification), "ED" (education
degree), and "SK" (skill).
Y = Yes
N = No
EPC-IN-PRO-FLAG Alpha 1 PA25.1 TR22.1
In Process Flag This field can contain the following TR500
information:
CE = Spaces.
CP = Spaces.
ED = Education in process.
BN = Dependent coverage.
RL = Relocation status.
SK = Space.
(R - Requests transfer
W - Will transfer
N - Will not transfer)
Y = Yes
N = No
EPC-LIC-NUMBER Alpha 20 TR22.1 TR500
License Number This field is filled only for "CE"
(certification) and contains the
certification license number.
EPC-COST Signed 11.2 TR22.1 TR500
Cost This field is filled only for "CE"
(certification) and contains the cost of
obtaining the certification.
EPC-RENEWAL-CODE Alpha 2
Renewal Cycle This 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
EPC-COMPONENT Numeric 4 PA16.1 TR22.1
Component This field is only filled for "CP" TR500
(certification) and gives the component
number of the property issued.
EPC-PROP-VALUE Signed 7.2 PA16.1 TR22.1
Property Value This field is only filled for "CP" TR500
(property) and gives the value of the
company property.
EPC-PA-ASSET-NBR Alpha 9 (Lower Case) PA16.1 TR22.1
Pa Asset Nbr Contains the asset number of the TR500
property issued.
EPC-DATE-RETURNED Numeric 8 (yyyymmdd) PA16.1 TR22.1
Date Returned This field is only filled for "CP" TR500
(property) and is the date the company
property was returned.
EPC-VERIFIED-FLAG Alpha 1 TR22.1 TR500
Verified Flag This 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
EPC-PRIORITY-CODE Numeric 1 TR22.1 TR500
Priority Code This field is only filled for "RL"
(relocation) and with the statuses of
"R" (requests transfer) or "W" (will
transfer).
EPC-SKILL-SOURCE Alpha 10 TR22.1 TR500
Skill Source This field is only filled for "SK"
(Skill). The skill source must be valid
in PCODES.
EPC-PROFIC-LEVEL Alpha 10 TR22.1 TR500
Profic Level Contains the proficiency level of the
skill.
EPC-OBJ-ID Numeric 12 TR22.1 TR500
Object This is the object identifier. It is
Identification 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.
EPC-CURRENCY-CODE Alpha 5 PA16.1 TR22.1
Currency Code Contains the currency in which the cost TR500
is recorded.
EPC-CURR-ND Numeric 1 PA16.1 TR22.1
Currency Number of Represents the number of decimals TR500
Decimals defined for the currency of the object.
EPC-BASE-AMOUNT Signed 15.2 PA16.1 TR22.1
Base Amount Contains the amount in the company's TR500
base currency.
EPC-BASE-CURRENCY Alpha 5 PA16.1 TR22.1
Base Currency The company base currency. TR500
EPC-BASE-ND Numeric 1 PA16.1 TR22.1
Base Number Of The number of decimal positions defined TR500
Decimals for the company base currency.
EPC-DATE-STAMP Numeric 8 (yyyymmdd) PA16.1 PA25.1
Date Stamp This field contains the server date TR22.1 TR500
(month, date, and year) of the last
change to this record.
EPC-TIME-STAMP Numeric 6 (hhmmss) PA16.1 PA25.1
Time Stamp Contains the server time (hour, minute, TR22.1 TR500
and second) when the record was last
changed.
EPC-USER-ID Alpha 10 (Lower Case) PA16.1 PA25.1
User ID Name Contains the user ID of the person who TR22.1 TR500
last changed this record.
EPC-STATE Alpha 2 TR22.1 TR500
State or Province This field contains the two-character
state code of the address.
EPC-DESCRIPTION Alpha 30 (Lower Case) TR22.1 TR500
Description This field displays the description.
EPC-WF-VERIFY Derived
Wf Verify This is a derived field.
EMPCODES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EPCSET1 COMPANY HR15.1 HR155
TYPE HR170 HR511
EMP-APP HR54.1 HR55.2
EMPLOYEE HR650 HR70.1
CODE HRS1.1 HRSC.1
SUBJECT HS11.1 HS12.1
SEQ-NBR HS13.1 HS14.1
HS50.1 HS50.2
HS50.3 HS50.4
HS51.1 HS51.2
HS52.1 HS52.2
PA120 PA16.1
PA216 PA220
PA221 PA222
PA224 PA225
...
EPCSET2 COMPANY HR04.2 HR04.3
TYPE HR04.7 HR04.8
EMP-APP HR80.1 HR80.2
CODE HR80.3 HR80.4
EMPLOYEE HR80.5 HR80.6
SUBJECT HR80.7 HR80.8
SEQ-NBR HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
...
EPCSET3 COMPANY Subset HR170 HR70.1
EMP-APP Where (TYPE = "AB" )
EMPLOYEE Or (TYPE = "KN" )
TYPE Or (TYPE = "OA" )
CODE Or (TYPE = "SK" )
SUBJECT
SEQ-NBR*
EPCSET4 COMPANY Subset HR15.1 HR155
TYPE Where TYPE = "ED" HR511 HR54.1
EMP-APP HR55.2 HR650
EMPLOYEE HRS1.1 HRSC.1
SUBJECT PA16.1 PA262
CODE PA263 PA502
SEQ-NBR PA513 PA54.1
PA62.1 PA63.1
TR22.1 TR500
PR13.1 PR13.5
PR13.6 PR13.8
EPCSET5 COMPANY KeyChange, Subset
TYPE Where TYPE = "ED"
EMP-APP
EMPLOYEE
RENEW-DATE
CODE
SUBJECT
SEQ-NBR
EPCSET6 OBJ-ID Subset
COMPANY Where (OBJ-ID != Zeroes )
EMP-APP
EMPLOYEE
TYPE
CODE
EPCSET7 COMPANY KeyChange, Subset HS50.1 HS50.2
EMP-APP Where((TYPE != "BN" ) HS51.1 HS51.2
EMPLOYEE And (TYPE != "RL" )) HS52.1 HS52.2
TYPE TR120 TR121
CODE TR20.1 TR20.2
DATE-ACQUIRED* TR20.3 TR22.1
SUBJECT TR500
SEQ-NBR
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
Contract PCODES Required
When (EPC-TYPE = "CN" )
"C" -> PCO-TYPE
EPC-CODE -> PCO-CODE
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
Track Cert PATRACK
Valid When EPC-TYPE = "CE"
EPC-CODE -> TRA-CERT-ACHIEVED
TRA-TRACK
TRA-EFFECTIVE-DATE
|
