PAEMPTRACK FILE
Required Training
Contains information about tracks and courses that employees are required to
take.
TR13.1 (Required Training by Track & Course) and TR13.2 (Required Training by
Employee - Track or Course) are the primary programs that update this file.
REFERENCED BY
TR120 TR121 TR20.1 TR20.2 TR20.3 TR222
TR05.1
UPDATED BY
DA113 TR113 TR114 TR13.1 TR13.2 TR15.1
TR21.1 TR22.1 TR500 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ETR-COMPANY Numeric 4 DA113 TR113
Company Contains the company number. TR114 TR13.1
TR13.2 TR15.1
ETR-EMPLOYEE Numeric 9 DA113 TR113
Employee Contains the employee number. Each TR114 TR13.1
person employed by the company is TR13.2 TR15.1
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
ETR-TYPE Alpha 2 DA113 TR113
Type Indicates whether the required training TR114 TR13.1
is a course or a track. TR13.2 TR15.1
CS = Course
TR = Track
ETR-TRACK Alpha 10 DA113 TR113
Track or Course Code Contains the track or course code. TR114 TR13.1
TR13.2 TR15.1
ETR-START-DATE Numeric 8 (yyyymmdd) DA113 TR113
Effective Date Contains the date the track or course TR114 TR13.1
is assigned to the employee. TR13.2 TR15.1
ETR-TRACK-STATUS Alpha 1 DA113 TR113
Status Indicates whether the employee has TR114 TR13.1
completed the track. TR13.2 TR15.1
C = Complete TR21.1 TR22.1
I = Incomplete; Default value TR500
F = Fully completed
N = Completed without skills prof
S = Partially completed with skill
P = Partially completed - no skill
ETR-EXP-CMPLT-DATE Numeric 8 (yyyymmdd) DA113 TR113
Estimated Contains the estimated date for TR114 TR13.1
Completion Date completing the course or track. TR13.2 TR15.1
ETR-END-DATE Numeric 8 (yyyymmdd) DA113 TR13.1
End Date Contains the date the employee TR13.2 TR15.1
completed the course or track. TR21.1 TR22.1
TR500
PAEMPTRACK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETRSET1 COMPANY DA113 HR11.1
EMPLOYEE PA115 TR113
TYPE TR114 TR120
TRACK TR121 TR13.2
TR15.1 TR20.1
TR20.2 TR20.3
TR21.1 TR22.1
TR222 TR500
ETRSET3 TYPE TR05.1 TR13.1
TRACK TR13.2 TR15.1
COMPANY
EMPLOYEE
PAEMPTRACK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
ETR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
ETR-COMPANY -> EMP-COMPANY
ETR-EMPLOYEE -> EMP-EMPLOYEE
PAEMPTRACK FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Track PATRACK
ETR-TRACK -> TRA-TRACK
TRA-EFFECTIVE-DATE
|