Training History
Contains the dates, CEUs, status, and attributes of the courses each employee completes. This information is updated by the Registration Information file after one of the following status is selected in TR22.1 (Session Completion): - Fully Complete - Complte-No Skills - Part Complte-No Skl - Part Complte-Skills TR21.1 (Employee Training History) is the primary program that accesses this file.
REFERENCED BY
TR120 | TR121 | TR20.1 | TR20.2 | TR20.3 | TR20.4 |
TR201 | TR222 | TR04.1 | TR26.1 |
TR21.1 | TR22.1 | TR500 | HR11.1 | PA115 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
TRH-COMPANY Element: Company | Numeric 4 Contains the company number. |
|
||||
TRH-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. |
|
||||
TRH-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||||
TRH-DATE-COMPLETED Element: Completed | Numeric 8 (yyyymmdd) Contains the date the employee completed the course. |
|
||||
TRH-COMPLETE-STATS Element: Completion Status | Alpha 1 Contains the completion status. F = Complete With Competencies N = Complete With No Competencies S = Partial With Competencies P = Partial With No Competencies |
|
||||
TRH-CEU-AWARDED Element: CEU | Signed 5.2 Contains the number of CEUs awarded when the employee completes the course. |
|
||||
TRH-RATING Element: Proficiency | Alpha 10 Contains the proficiency level achieved from the course. |
|
||||
TRH-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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TRHSET1 |
COMPANY EMPLOYEE COURSE DATE-COMPLETED |
|
| ||||||||||||||||||||
TRHSET2 |
COURSE COMPANY EMPLOYEE DATE-COMPLETED |
|
| ||||||||||||||||||||
TRHSET3 |
OBJ-ID COMPANY EMPLOYEE |
|
| ||||||||||||||||||||
TRHSET4 |
COMPANY EMPLOYEE DATE-COMPLETED* COURSE |
|
|||||||||||||||||||||
TRHSET5 |
COMPANY EMPLOYEE COURSE DATE-COMPLETED* |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Paemployee | PAEMPLOYEE |
Required
| ||||||||||||
Rating | PCODES |
Required
| ||||||||||||
Session | PASESSION |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Competency | EMPCODES |
Delete Cascades
| ||||||||||||||||||||||||
Cost | PAEMPCOSTS |
| ||||||||||||||||||||||||
Course | PACOURSE |
| ||||||||||||||||||||||||
Trackcourses | PATRACKDTL |
|
All trademarks and registered trademarks are the property of their
respective owners.