|
|
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 TR222
UPDATED BY
PA115 TR21.1 TR22.1 TR26.1 TR500 HR11.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRH-COMPANY Numeric 4 TR21.1 TR22.1
Company Contains the company number. TR26.1 TR500
TRH-EMPLOYEE Numeric 9 TR21.1 TR22.1
Employee Contains the employee number. TR26.1 TR500
TRH-COURSE Alpha 10 TR21.1 TR22.1
Course Code Contains the course code. TR26.1 TR500
TRH-DATE-COMPLETED Numeric 8 (yyyymmdd) TR21.1 TR22.1
Completed Contains the date the employee TR26.1 TR500
completed the course.
TRH-COMPLETE-STATS Alpha 1 TR22.1 TR500
Completion Status Contains the completion status.
F = Fully Completed
N = Completd WO Skills Proficiency
S = Partial with Skill Proficiency
P = Partial WO skiils Proficiency
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 TR22.1 TR26.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 HR11.1 PA115
EMPLOYEE TR120 TR121
COURSE TR20.1 TR20.2
DATE-COMPLETED TR20.3 TR21.1
TR22.1 TR222
TR26.1 TR500
TRHSET2 COURSE
COMPANY
EMPLOYEE
DATE-COMPLETED
TRHSET3 OBJ-ID Subset 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
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
Skill EMPCODES
Valid When (TRH-OBJ-ID != Zeroes )
TRH-OBJ-ID -> EPC-OBJ-ID
"SK" -> EPC-TYPE
TRH-COMPANY -> EPC-COMPANY
Zeroes -> EPC-EMP-APP
TRH-EMPLOYEE -> EPC-EMPLOYEE
EPC-CODE
Trackcourses PATRACKDTL
TRH-COURSE -> TKD-COURSE
TKD-TRACK
|