Lawson Insight Technical Documentation |
|
EMPCODES
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 HR515 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 PA02.1 PA13.1 PA13.2 PA216
PA220 PA221 PA222 PA224 PA225 PA227
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 PR110 PR113 PR120
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 PA594
UPDATED BY
HGLM.1 HPOS.1 HPQC.1 HPRS.1 HR54.1 HRS1.1
HRSC.1 PA100 PA102 PA120 PA16.1 PA20.1
PA21.1 PA22.1 PA24.1 PA25.1 PA27.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 PRSC.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EPC-COMPANY Numeric 4 PA16.1 PA20.1
Element: Company Contains the company number represents PA21.1 PA22.1
an established company. PA24.1 PA25.1
PA27.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
Element: Type This field indicates the kind of PA21.1 PA22.1
information stored in the record. PA24.1 PA25.1
BN = Benefit Codes PA27.1 PA34.1
CE = Certifications PA35.1 PA36.1
CN = Contracts PA38.1 PA520
CP = Company Property TR21.1 TR22.1
ED = Education TR26.1 TR500
RL = Relocation
SK = Skills
AB = Ability
KN = Knowledge
OA = Other Attributes
EPC-EMP-APP Numeric 1 HGLM.1 HPOS.1
Element: Type This field contains the employee HPQC.1 HPRS.1
applicant indicator. HR54.1 HRS1.1
0 = Employee HRSC.1 HS50.1
1 = Applicant HS50.2 HS51.1
HS51.2 HS52.1
HS52.2 PA100
PA102 PA20.1
PA21.1 PA22.1
PA24.1 PA262
PA263 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
PRSC.1 TR120
TR121 TR20.1
TR20.2 TR20.3
TR21.1 TR22.1
TR26.1 TR500
EPC-EMPLOYEE Numeric 9 HGLM.1 HPOS.1
Element: Employee Contains the employee Number HPQC.1 HPRS.1
HR54.1 HRS1.1
HRSC.1 HS50.1
HS50.2 HS51.1
HS51.2 HS52.1
HS52.2 PA100
PA102 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA25.1 PA262
PA263 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
PRSC.1 TR120
TR121 TR20.1
TR20.2 TR20.3
TR21.1 TR22.1
TR26.1 TR500
EPC-CODE Alpha 10 PA16.1 PA20.1
Element: 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: PA27.1 PA34.1
PA35.1 PA36.1
ED = Education Degree. PA38.1 PA520
CP = Property. TR21.1 TR22.1
SK = Skill. TR26.1 TR500
CE = Certification.
RL = Relocation.
BN = Benefit.
EPC-SUBJECT Alpha 10 PA20.1 PA21.1
Element: Subject This field is only filled on "ED" PA22.1 PA24.1
(education records) and contains the PA27.1 PA34.1
subject for the degree. The subject PA35.1 PA36.1
code must be valid in PCODES. PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
EPC-SEQ-NBR Numeric 4 HGLM.1 HPOS.1
Element: Sequence NumbeThis field is filled for "CP" HPQC.1 HPRS.1
(property), "ED" (education Degree), and HR54.1 HRS1.1
"SK" (skill) records only and is HRSC.1 PA100
automatically assigned. PA102 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PRSC.1
TR21.1 TR22.1
TR26.1 TR500
EPC-DATE-ACQUIRED Numeric 8 (yyyymmdd) PA16.1 PA20.1
Element: Date Acquired Contains the following: PA21.1 PA22.1
PA24.1 PA27.1
- the date the certificate was acquired, PA34.1 PA35.1
- the date skill was acquired, or PA36.1 PA38.1
- the date property was issued. PA520 TR21.1
TR22.1 TR26.1
This field is used only for CE TR500
(Certifications), CP (Company Property),
and SK (Skill).
EPC-RENEW-DATE Numeric 8 (yyyymmdd) PA16.1 PA20.1
Element: License RenewaThis field contains the following PA21.1 PA22.1
information: PA24.1 PA27.1
PA34.1 PA35.1
CE = Certificate renewal date. PA36.1 PA38.1
CP = Anticipated return date. PA520 TR21.1
ED = Degree completion date. TR22.1 TR26.1
BN = Zeroes. TR500
RL = Zeroes.
SK = Date skill was last used.
EPC-PER-RATING Signed 5.2 PA20.1 PA21.1
Element: Performance RaThis is a user-defined field and is PA22.1 PA24.1
only filled for types "ED" (education PA27.1 PA34.1
degree) and "SK" (skill). PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
EPC-INSTRUCTOR Alpha 10 PA20.1 PA21.1
Element: Instructor This field contains the following PA22.1 PA24.1
information: PA27.1 PA34.1
PA35.1 PA36.1
CE = Spaces. PA38.1 PA520
CP = Spaces. TR21.1 TR22.1
ED = Education Institution. TR26.1 TR500
BN = Spaces.
RL = Spaces.
SK = Skill Instructor.
EPC-CO-SPONSORED Alpha 1 PA20.1 PA21.1
Element: Company SponsoThis field is filled for types "CE" PA22.1 PA24.1
(certification), "ED" (education PA27.1 PA34.1
degree), and "SK" (skill). PA35.1 PA36.1
Y = Yes PA38.1 PA520
N = No TR21.1 TR22.1
TR26.1 TR500
EPC-IN-PRO-FLAG Alpha 1 PA20.1 PA21.1
Element: In Process FlaThis field can contain the following PA22.1 PA24.1
information: PA25.1 PA27.1
PA34.1 PA35.1
CE = Spaces. PA36.1 PA38.1
CP = Spaces. PA520 TR21.1
ED = Education in process. TR22.1 TR26.1
BN = Dependent coverage. TR500
RL = Relocation status.
SK = Space.
(R - Requests transfer
W - Will transfer
N - Will not transfer)
Y = Yes
N = No
EPC-LIC-NUMBER Alpha 20 PA20.1 PA21.1
Element: License NumberThis field is filled only for "CE" PA22.1 PA24.1
(certification) and contains the PA27.1 PA34.1
certification license number. PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
EPC-COST Signed 11.2 PA20.1 PA21.1
Element: Cost This field is filled only for "CE" PA22.1 PA24.1
(certification) and contains the cost of PA27.1 PA34.1
obtaining the certification. PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
EPC-RENEWAL-CODE Alpha 2 PA20.1 PA21.1
Element: Renewal Cycle This field is only filled for "CE" PA22.1 PA24.1
(certification). PA27.1 PA34.1
2Y = 2 Years PA35.1 PA36.1
3Y = 3 Years PA38.1 PA520
4Y = 4 Years TR21.1 TR26.1
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
Element: Component This field is only filled for "CP" TR22.1 TR26.1
(certification) and gives the component TR500
number of the property issued.
EPC-PROP-VALUE Signed 7.2 PA16.1 TR21.1
Element: Property ValueThis field is only filled for "CP" TR22.1 TR26.1
(property) and gives the value of the TR500
company property.
EPC-PA-ASSET-NBR Alpha 9 (Lower Case) PA16.1 TR21.1
Element: Pa Asset Nbr Contains the asset number of the TR22.1 TR26.1
property issued. TR500
EPC-DATE-RETURNED Numeric 8 (yyyymmdd) PA16.1 PA20.1
Element: Date Returned This field is only filled for "CP" PA21.1 PA22.1
(property) and is the date the company PA24.1 PA27.1
property was returned. PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-VERIFIED-FLAG Alpha 1 PA20.1 PA21.1
Element: Verified Flag This field is only filled for "ED" PA22.1 PA24.1
(education degree) for an applicant's PA27.1 PA34.1
record. It indicates if an applicant's PA35.1 PA36.1
education degree has been verified. PA38.1 PA520
N = No TR21.1 TR22.1
Y = Yes TR26.1 TR500
EPC-PRIORITY-CODE Numeric 1 PA20.1 PA21.1
Element: Priority Code This field is only filled for "RL" PA22.1 PA24.1
(relocation) and with the statuses of PA27.1 PA34.1
"R" (requests transfer) or "W" (will PA35.1 PA36.1
transfer). PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
EPC-SKILL-SOURCE Alpha 10 PA20.1 PA21.1
Element: Skill Source This field is only filled for "SK" PA22.1 PA24.1
(Skill). The skill source must be valid PA27.1 PA34.1
in PCODES. PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
EPC-PROFIC-LEVEL Alpha 10 PA20.1 PA21.1
Element: Profic Level Contains the proficiency level of the PA22.1 PA24.1
skill. PA27.1 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 PA27.1 PA34.1
transactions back to the originating PA35.1 PA36.1
subsystems. Each subsystem record that PA38.1 PA520
is updated as a commitment or posted TR21.1 TR22.1
transaction is assigned an object TR26.1 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 PA16.1 PA20.1
Element: Currency Code Contains the currency in which the cost PA21.1 PA22.1
is recorded. PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-CURR-ND Numeric 1 PA16.1 PA20.1
Account Currency PA21.1 PA22.1
Code PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-BASE-AMOUNT Signed 15.2 PA16.1 PA20.1
Element: Adj Amt Contains the amount in the company's PA21.1 PA22.1
base currency. PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-BASE-CURRENCY Alpha 5 PA16.1 PA20.1
To Company Base PA21.1 PA22.1
Currency PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-BASE-ND Numeric 1 PA16.1 PA20.1
Account Currency PA21.1 PA22.1
Code PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500
EPC-DATE-STAMP Numeric 8 (yyyymmdd) PA16.1 PA20.1
Element: Date Stamp This field contains the server date PA21.1 PA22.1
(month, date, and year) of the last PA24.1 PA25.1
change to this record. PA27.1 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
Element: Time Stamp Contains the server time (hour, minute, PA21.1 PA22.1
and second) when the record was last PA24.1 PA25.1
changed. PA27.1 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
Element: User PA21.1 PA22.1
PA24.1 PA25.1
PA27.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
Element: State or ProviThis field contains the two-character PA22.1 PA24.1
state code of the address. PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
EPC-DESCRIPTION Alpha 30 (Lower Case) PA20.1 PA21.1
Element: Description This field displays the description. PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
EPC-WF-VERIFY Derived
Element: Wf Verify This is a derived field.
EMPCODES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EPCSET1 COMPANY HGLM.1 HPOS.1
TYPE HPQC.1 HPRS.1
EMP-APP HR11.1 HR11.2
EMPLOYEE HR15.1 HR155
CODE HR170 HR511
SUBJECT HR515 HR54.1
SEQ-NBR HR55.2 HR650
HR70.1 HRS1.1
HRSC.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 PA02.1
...
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" ) TR21.1
EMPLOYEE Or (TYPE = "KN" )
TYPE Or (TYPE = "OA" )
CODE Or (TYPE = "SK" )
SUBJECT
SEQ-NBR*
EPCSET4 COMPANY Subset HGLM.1 HPOS.1
TYPE Where TYPE = "ED" HPQC.1 HPRS.1
EMP-APP HR11.1 HR11.2
EMPLOYEE HR15.1 HR155
SUBJECT HR511 HR515
CODE HR54.1 HR55.2
SEQ-NBR HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
...
EPCSET5 COMPANY KeyChange, Subset PA20.1 PA22.1
TYPE Where TYPE = "ED" PA34.1 PA36.1
EMP-APP
EMPLOYEE
RENEW-DATE
CODE
SUBJECT
SEQ-NBR
EPCSET6 OBJ-ID Subset TR21.1 TR26.1
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 PA20.1 PA21.1
CODE PA22.1 PA227
DATE-ACQUIRED* PA24.1 PA262
SUBJECT PA263 PA27.1
SEQ-NBR PA34.1 PA35.1
PA36.1 PA38.1
PA520 PA594
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
TR120 TR121
TR20.1 TR20.2
...
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
|