EMPCODES

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
HS14.1


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR04.2 HR04.3 HR04.7 HR04.8 HR11.1
HR11.2 HR15.1 HR155 HR156 HR170 HR28.1
HR511 HR515 HR54.1 HR55.2 HR70.1 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 HR92.1 HR92.2 HRS1.1
HRSC.1 LT101 ZH156 ZH230 ZH500 ZH510
LP100 LP101 HS11.1 HS11.2 HS12.1 HS12.2
HS13.1 HS13.2 HS50.1 HS50.2 HS50.3 HS50.4
HS51.1 HS51.2 HS52.1 HS52.2 HS704 PA02.1
PA100 PA102 PA115 PA120 PA13.1 PA13.2
PA16.1 PA20.1 PA21.1 PA216 PA22.1 PA220
PA221 PA222 PA224 PA225 PA227 PA231
PA234 PA235 PA236 PA238 PA24.1 PA25.1
PA262 PA263 PA27.1 PA311 PA34.1 PA35.1
PA36.1 PA38.1 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PA520 PA534 PA54.1 PA594
PA62.1 PA63.1 PA64.1 PA64.2 PA65.1 PA65.2
TR120 TR121 TR20.1 TR20.2 TR20.3 TR20.4
TR21.1 TR22.1 TR26.1 TR500 ZE521 ZE531
ZE540 PR110 PR113 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EPC-COMPANY
Element: Company Hr
Numeric 4
Contains the company number represents an established company.
PA16.1 PA20.1
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
ZE521 ZE531
ZE540
EPC-TYPE
Element: Type
Alpha 2
This 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
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-EMP-APP
Element: Emp App
Numeric 1
This 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
HR11.2 HR28.1
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
LT101 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
EPC-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee Number
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
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
LT101 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
EPC-CODE
Element: Code
Alpha 10
This 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
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-SUBJECT
Element: Subject
Alpha 10
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-SEQ-NBR
Element: Seq Nbr
Numeric 4
This 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
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
ZH510
EPC-DATE-ACQUIRED
Element: 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
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
EPC-RENEW-DATE
Element: 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
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
EPC-PER-RATING
Element: Per Rating
Signed 5.2
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-INSTRUCTOR
Element: Instructor
Alpha 10
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-CO-SPONSORED
Element: Co Sponsored
Alpha 1
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-IN-PRO-FLAG
Element: In Pro Flag
Alpha 1
This field can contain the following 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
PA20.1 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 ZE521
ZE531 ZE540
EPC-LIC-NUMBER
Element: Lic Number
Alpha 20
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-COST
Element: Cost
Signed 11.2
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-RENEWAL-CODE
Element: Renewal Code
Alpha 2
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
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR26.1
ZE521 ZE531
ZE540
EPC-COMPONENT
Element: Component
Numeric 4
This 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
Element: Prop Value
Signed 15.2
This 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
Element: 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
Element: 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
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
EPC-VERIFIED-FLAG
Element: Verified Flag
Alpha 1
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
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-PRIORITY-CODE
Element: Priority Code
Numeric 1
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-SKILL-SOURCE
Element: Skill Source
Alpha 10
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-PROFIC-LEVEL
Element: Profic Level
Alpha 10
Contains the proficiency level of the skill.
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-OBJ-ID
Element: Obj Id
Numeric 12
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency in which the cost is recorded.
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
EPC-CURR-ND
Element: Acct Nd
Numeric 1
The 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
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
EPC-BASE-AMOUNT
Element: Base Amt
Signed 15.2
Contains the amount in the company's base currency.
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
EPC-BASE-CURRENCY
Element: Base Currency
Alpha 5
The company base currency.
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
EPC-BASE-ND
Element: Base Nd
Numeric 1
The 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
PA36.1 PA38.1
PA520 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
EPC-DATE-STAMP
Element: 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
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-TIME-STAMP
Element: 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
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-USER-ID
Element: User
Alpha 10 (Lower Case)
PA16.1 PA20.1
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
ZE521 ZE531
ZE540
EPC-STATE
Element: State
Alpha 2
This 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-DESCRIPTION
Element: 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
PA38.1 PA520
TR21.1 TR22.1
TR26.1 TR500
ZE521 ZE531
ZE540
EPC-WF-VERIFY
Element: Wf Verify
Derived
This is a derived field.


EMPCODES FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EPCSET1 COMPANY
TYPE
EMP-APP
EMPLOYEE
CODE
SUBJECT
SEQ-NBR
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR170 HR28.1
HR511 HR515
HR54.1 HR55.2
HR70.1 HRS1.1
HRSC.1 LT101
ZH156 ZH230
ZH500 ZH510
LP100 LP101
HS11.1 HS11.2
EPCSET2 COMPANY
TYPE
EMP-APP
CODE
EMPLOYEE
SUBJECT
SEQ-NBR
...
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
EPCSET3 COMPANY
EMP-APP
EMPLOYEE
TYPE
CODE
SUBJECT
SEQ-NBR*
Subset
Where(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
PA35.1 PA36.1
PA38.1 PA520
PA534 TR21.1
TR26.1 ZE521
ZE531 ZE540
EPCSET4 COMPANY
TYPE
EMP-APP
EMPLOYEE
SUBJECT
CODE
SEQ-NBR
Subset
WhereTYPE ="ED"
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR155 HR156
HR28.1 HR511
HR515 HR54.1
HR55.2 HRS1.1
HRSC.1 LT101
ZH156 ZH510
LP100 LP101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
EPCSET5 COMPANY
TYPE
EMP-APP
EMPLOYEE
RENEW-DATE
CODE
SUBJECT
SEQ-NBR
KeyChange, Subset
WhereTYPE ="ED"
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA520
TR21.1 TR26.1
ZE521 ZE531
ZE540
EPCSET6 OBJ-ID
COMPANY
EMP-APP
EMPLOYEE
TYPE
CODE
Subset
Where(OBJ-ID !=Zeroes)
TR21.1 TR26.1
EPCSET7 COMPANY
EMP-APP
EMPLOYEE
TYPE
CODE
DATE-ACQUIRED*
SUBJECT
SEQ-NBR
KeyChange, Subset
Where((TYPE !="BN")
And(TYPE !="RL"))
...
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS51.1 HS51.2
HS52.1 HS52.2
PA20.1 PA21.1
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
NAME
RELATED 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"
AndEPC-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
NAME
RELATED 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


File created: Thu Jun 09 11:22:02 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.