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 HR515 HR55.2 HR70.1
LP100 LP101 HS11.1 HS11.2 HS12.1 HS12.2
HS13.1 HS13.2 HS14.1 HS50.1 HS50.2 HS50.3
HS50.4 HS51.1 HS51.2 HS52.1 HS52.2 PA216
PA220 PA221 PA222 PA224 PA225 PA227
PA231 PA234 PA235 PA236 PA238 PA262
PA263 PA311 PA534 PA62.1 PA63.1 PA64.1
PA64.2 PA65.1 PA65.2 TR120 TR121 TR20.1
TR20.2 TR20.3 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 HR89.8 HR89.9 HR91.7 PA594
UPDATED BY
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR511 HR54.1 HRS1.1 HRSC.1
PA02.1 PA100 PA102 PA115 PA120 PA13.1
PA13.2 PA16.1 PA20.1 PA21.1 PA22.1 PA24.1
PA25.1 PA27.1 PA34.1 PA35.1 PA36.1 PA38.1
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PA520 PA54.1 TR21.1 TR22.1 TR26.1 TR500
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EPC-COMPANY Numeric 4 PA16.1 PA20.1
Element: Company Hr 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 BN305 HAP3.1
Element: Emp App This field contains the employee HEP4.1 HPOS.1
applicant indicator. HPQC.1 HPRS.1
0 = Employee HR11.1 HR11.2
1 = Applicant HR511 HR54.1
HRS1.1 HRSC.1
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS51.1 HS51.2
HS52.1 HS52.2
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA20.1 PA21.1
PA22.1 PA24.1
PA262 PA263
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PA62.1
PA63.1 PA64.1
PA64.2 PA65.1
PA65.2 PR110
PR113 PR120
PR13.1 PR13.5
...
EPC-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee Number HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR511 HR54.1
HRS1.1 HRSC.1
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS51.1 HS51.2
HS52.1 HS52.2
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA25.1
PA262 PA263
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PA54.1 PA62.1
PA63.1 PA64.1
PA64.2 PA65.1
PA65.2 PR110
PR113 PR120
...
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 BN305 HAP3.1
Element: Seq Nbr This field is filled for "CP" HEP4.1 HPOS.1
(property), "ED" (education Degree), and HPQC.1 HPRS.1
"SK" (skill) records only and is HR11.1 HR11.2
automatically assigned. HR511 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 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: Renew Date This 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: Per Rating This 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: Co Sponsored This 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 Pro Flag This 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: Lic Number This 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 Code 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: Prop Value This 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
Element: Obj Id This is the object identifier. It is PA22.1 PA24.1
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
Element: Acct Nd The number of decimals assigned to a PA21.1 PA22.1
particular account as determined by the PA24.1 PA27.1
account currency. 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: Base 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
Element: Base Currency The company base currency. PA21.1 PA22.1
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
Element: Base Nd The number of decimal positions defined PA21.1 PA22.1
for the company base currency. 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 This 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 BN305 HAP3.1
TYPE HEP4.1 HPOS.1
EMP-APP HPQC.1 HPRS.1
EMPLOYEE HR11.1 HR11.2
CODE HR15.1 HR155
SUBJECT HR170 HR511
SEQ-NBR HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
LP100 LP101
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS14.1 HS50.1
HS50.2 HS50.3
...
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" ) PA20.1 PA21.1
EMPLOYEE Or (TYPE = "KN" ) PA22.1 PA24.1
TYPE Or (TYPE = "OA" ) PA27.1 PA34.1
CODE Or (TYPE = "SK" ) PA35.1 PA36.1
SUBJECT PA38.1 PA520
SEQ-NBR* PA534 TR21.1
TR26.1
EPCSET4 COMPANY Subset BN305 HAP3.1
TYPE Where TYPE = "ED" HEP4.1 HPOS.1
EMP-APP HPQC.1 HPRS.1
EMPLOYEE HR11.1 HR11.2
SUBJECT HR15.1 HR155
CODE HR511 HR515
SEQ-NBR HR54.1 HR55.2
HRS1.1 HRSC.1
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
...
EPCSET5 COMPANY KeyChange, Subset PA20.1 PA21.1
TYPE Where TYPE = "ED" PA22.1 PA24.1
EMP-APP PA27.1 PA34.1
EMPLOYEE PA35.1 PA36.1
RENEW-DATE PA38.1 PA520
CODE TR21.1 TR26.1
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 HS11.1 HS11.2
EMP-APP Where((TYPE != "BN" ) HS12.1 HS12.2
EMPLOYEE And (TYPE != "RL" )) HS13.1 HS13.2
TYPE HS50.1 HS50.2
CODE HS51.1 HS51.2
DATE-ACQUIRED* HS52.1 HS52.2
SUBJECT PA20.1 PA21.1
SEQ-NBR PA22.1 PA227
PA24.1 PA262
PA263 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 PA534
PA594 PA62.1
PA63.1 PA64.1
...
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" )
"CN" -> 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
Paemployee PAEMPLOYEE Required
When EPC-EMP-APP = Zeroes
EPC-COMPANY -> PEM-COMPANY
EPC-EMPLOYEE -> PEM-EMPLOYEE
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
Bn Comments PACOMMENTS Delete Cascades
Valid 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
Ce Comments PACOMMENTS Delete Cascades
Valid 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
Course Skills PAATTRIB
Valid 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 Comments PACOMMENTS Delete Cascades
Valid 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
Ed Comments PACOMMENTS Delete Cascades
Valid 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
Rl Comments PACOMMENTS Delete Cascades
Valid 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
Sk Comments PACOMMENTS Delete Cascades
Valid 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
Track Cert PATRACK
Valid When EPC-TYPE = "CE"
EPC-CODE -> TRA-CERT-ACHIEVED
TRA-TRACK
TRA-EFFECTIVE-DATE
|