|
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
TR120 TR121 TR20.1 TR20.2 TR20.3 TR201
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
Element: Company Contains the company number. TR500
TRH-EMPLOYEE Numeric 9 TR21.1 TR22.1
Element: Employee Contains the employee number. TR500
TRH-COURSE Alpha 10 TR21.1 TR22.1
Element: Course Code Contains the course code. TR500
TRH-DATE-COMPLETED Numeric 8 (yyyymmdd) TR21.1 TR22.1
Element: Completed Contains the date the employee TR500
completed the course.
TRH-COMPLETE-STATS Alpha 1 TR21.1 TR22.1
Element: Completion StaContains 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
Element: CEU Contains the number of CEUs awarded TR500
when the employee completes the course.
TRH-RATING Alpha 10 TR21.1 TR22.1
Element: Proficiency Contains the proficiency level achieved TR500
from the course.
TRH-OBJ-ID Numeric 12 TR21.1 TR22.1
Element: Obj Id 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.
PATRNHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRHSET1 COMPANY HR11.1 PA115
EMPLOYEE TR120 TR121
COURSE TR20.1 TR20.2
DATE-COMPLETED TR20.3 TR201
TR21.1 TR22.1
TR222 TR500
TRHSET2 COURSE TR201
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
Paemployee PAEMPLOYEE Required
TRH-COMPANY -> PEM-COMPANY
TRH-EMPLOYEE -> PEM-EMPLOYEE
Rating PCODES Required
When (TRH-RATING != Spaces )
"PF" -> PCO-TYPE
TRH-RATING -> PCO-CODE
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
|