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
TR113 TR114 TR13.1 TR13.2 TR15.1 TR22.1
TR500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ETR-COMPANY Numeric 4 TR113 TR114
Company Contains the company number. TR13.1 TR13.2
TR15.1
ETR-EMPLOYEE Numeric 9 TR113 TR114
Employee Contains the employee number. Each TR13.1 TR13.2
person employed by the company is 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 TR113 TR114
Type Indicates whether the required training TR13.1 TR13.2
is a course or a track. TR15.1
CS = Course
TR = Track
ETR-TRACK Alpha 10 TR113 TR114
Track or Course Code Contains the track or course code. TR13.1 TR13.2
TR15.1
ETR-START-DATE Numeric 8 (yyyymmdd) TR113 TR114
Effective Date Contains the date the track or course TR13.1 TR13.2
is assigned to the employee. TR15.1
ETR-TRACK-STATUS Alpha 1 TR113 TR114
Status Indicates whether the employee has TR13.1 TR13.2
completed the track. TR15.1 TR22.1
C = Complete TR500
I = Incomplete; Default value
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) TR113 TR114
Estimated Contains the estimated date for TR13.1 TR13.2
Completion Date completing the course or track. TR15.1
ETR-END-DATE Numeric 8 (yyyymmdd) TR13.1 TR13.2
End Date Contains the date the employee TR15.1 TR22.1
completed the course or track. TR500
PAEMPTRACK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETRSET1 COMPANY TR113 TR114
EMPLOYEE TR120 TR121
TYPE TR13.2 TR15.1
TRACK TR20.1 TR20.2
TR20.3 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
|
