PATRNHIST FILE
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
AC551 TR120 TR121 TR20.1 TR20.2 TR20.3
TR222 TR04.1 TR26.1
UPDATED BY
TR21.1 TR22.1 TR500 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRH-COMPANY Numeric 4 TR21.1 TR22.1
Company Contains the company number. TR500
TRH-EMPLOYEE Numeric 9 TR21.1 TR22.1
Employee Contains the employee number. TR500
TRH-COURSE Alpha 10 TR21.1 TR22.1
Course Code Contains the course code. TR500
TRH-DATE-COMPLETED Numeric 8 (yyyymmdd) TR21.1 TR22.1
Completed Contains the date the employee TR500
completed the course.
TRH-COMPLETE-STATS Alpha 1 TR21.1 TR22.1
Completion Status Contains the completion status. TR500
F = Complete With Competencies
N = Complete With No Competencies
S = Partial With Competencies
P = Partial With No Competencies
TRH-CEU-AWARDED Signed 5.2 TR21.1 TR22.1
CEU Contains the number of CEUs awarded TR500
when the employee completes the course.
TRH-RATING Alpha 10 TR21.1 TR22.1
Proficiency Contains the proficiency level achieved TR500
from the course.
TRH-OBJ-ID Numeric 12 TR21.1 TR22.1
Object This is the object identifier. It is
Identification 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.
PATRNHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRHSET1 COMPANY AC551 HR11.1
EMPLOYEE PA115 TR120
COURSE TR121 TR20.1
DATE-COMPLETED TR20.2 TR20.3
TR21.1 TR22.1
TR222 TR500
TRHSET2 COURSE
COMPANY
EMPLOYEE
DATE-COMPLETED
TRHSET3 OBJ-ID Subset TR04.1 TR26.1
COMPANY Where OBJ-ID != Zeroes
EMPLOYEE
PATRNHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TRH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
TRH-COMPANY -> EMP-COMPANY
TRH-EMPLOYEE -> EMP-EMPLOYEE
Session PASESSION Required
When (TRH-OBJ-ID != Zeroes )
TRH-OBJ-ID -> SES-OBJ-ID
PATRNHIST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Competency EMPCODES Delete Cascades
Valid When (TRH-OBJ-ID != Zeroes )
TRH-OBJ-ID -> EPC-OBJ-ID
TRH-COMPANY -> EPC-COMPANY
Zeroes -> EPC-EMP-APP
TRH-EMPLOYEE -> EPC-EMPLOYEE
EPC-TYPE
EPC-CODE
Cost PAEMPCOSTS
TRH-COMPANY -> EMC-COMPANY
TRH-EMPLOYEE -> EMC-EMPLOYEE
TRH-COURSE -> EMC-COURSE
EMC-DATE
EMC-COST-TYPE
EMC-COST-CAT
Course PACOURSE
TRH-COURSE -> CRS-COURSE
CRS-EFFECTIVE-DATE
Trackcourses PATRACKDTL
TRH-COURSE -> TKD-COURSE
TKD-TRACK
|
