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 TR21.1
TR22.1 TR500 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ETR-COMPANY Numeric 4 TR113 TR114
Element: Company Contains the company number. TR13.1 TR13.2
TR15.1
ETR-EMPLOYEE Numeric 9 TR113 TR114
Element: 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
Element: 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
Element: Track or CoursContains the track or course code. TR13.1 TR13.2
TR15.1
ETR-START-DATE Numeric 8 (yyyymmdd) TR113 TR114
Element: Effective DateContains the date the track or course TR13.1 TR13.2
is assigned to the employee. TR15.1
ETR-TRACK-STATUS Alpha 1 TR113 TR114
Element: Status Indicates whether the employee has TR13.1 TR13.2
completed the track. TR15.1 TR21.1
C = Complete TR22.1 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
Element: End Date Contains the date the employee TR15.1 TR21.1
completed the course or track. TR22.1 TR500
PAEMPTRACK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETRSET1 COMPANY HR11.1 PA115
EMPLOYEE TR113 TR114
TYPE TR120 TR121
TRACK 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
Paemployee PAEMPLOYEE Required
ETR-COMPANY -> PEM-COMPANY
ETR-EMPLOYEE -> PEM-EMPLOYEE
PAEMPTRACK FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE
Valid When (ETR-TYPE = "CS" )
ETR-TRACK -> CRS-COURSE
CRS-EFFECTIVE-DATE
Track PATRACK
Valid When (ETR-TYPE = "TR" )
ETR-TRACK -> TRA-TRACK
TRA-EFFECTIVE-DATE
|
