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
UPDATED BY
TR22.1 TR500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRH-COMPANY Numeric 4 TR22.1 TR500
Company Contains the company number.
TRH-EMPLOYEE Numeric 9 TR22.1 TR500
Employee Contains the employee number.
TRH-COURSE Alpha 10 TR22.1 TR500
Course Code Contains the course code.
TRH-DATE-COMPLETED Numeric 8 (yyyymmdd) TR22.1 TR500
Completed Contains the date the employee
completed the course.
TRH-COMPLETE-STATS Alpha 1 TR22.1 TR500
Completion Status 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 Signed 5.2 TR22.1 TR500
CEU Contains the number of CEUs awarded
when the employee completes the course.
TRH-RATING Alpha 10 TR22.1 TR500
Proficiency Contains the proficiency level achieved
from the course.
TRH-OBJ-ID Numeric 12 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 TR120
EMPLOYEE TR121 TR20.1
COURSE TR20.2 TR20.3
DATE-COMPLETED TR22.1 TR222
TR500
TRHSET2 COURSE
COMPANY
EMPLOYEE
DATE-COMPLETED
TRHSET3 OBJ-ID Subset
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 (PRSSET1)
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
|
