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 | TR20.4 |
TR201 | TR222 | TR05.1 |
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 Element: Company | Numeric 4 Contains the company number. |
|
||||||||
ETR-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person. |
|
||||||||
ETR-TYPE Element: Type | Alpha 2 Indicates whether the required training is a course or a track. CS = Course TR = Track |
|
||||||||
ETR-TRACK Element: Track or Course Code | Alpha 10 Contains the track or course code. |
|
||||||||
ETR-START-DATE Element: Effective Date | Numeric 8 (yyyymmdd) Contains the date the track or course is assigned to the employee. |
|
||||||||
ETR-TRACK-STATUS Element: Status | Alpha 1 Indicates whether the employee has completed the track. C = Complete 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 Estimated Completion Date | Numeric 8 (yyyymmdd) Contains the estimated date for completing the course or track. |
|
||||||||
ETR-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the date the employee completed the course or track. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ETRSET1 |
COMPANY EMPLOYEE TYPE TRACK |
|
| ||||||||||||||||||||||||
ETRSET3 |
TYPE TRACK COMPANY EMPLOYEE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||
Employee | EMPLOYEE |
Required
| ||||||
Paemployee | PAEMPLOYEE |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Course | PACOURSE |
| ||||||||||||
Track | PATRACK |
|
All trademarks and registered trademarks are the property of their
respective owners.