PATRNHIST

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


UPDATED BY
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.
TR21.1 TR22.1
TR500
TRH-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
TR21.1 TR22.1
TR500
TRH-COURSE
Element: Course Code
Alpha 10
Contains the course code.
TR21.1 TR22.1
TR500
TRH-DATE-COMPLETED
Element: Completed
Numeric 8 (yyyymmdd)
Contains the date the employee completed the course.
TR21.1 TR22.1
TR500
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
TR21.1 TR22.1
TR500
TRH-CEU-AWARDED
Element: CEU
Signed 5.2
Contains the number of CEUs awarded when the employee completes the course.
TR21.1 TR22.1
TR500
TRH-RATING
Element: Proficiency
Alpha 10
Contains the proficiency level achieved from the course.
TR21.1 TR22.1
TR500
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.
TR21.1 TR22.1


PATRNHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRHSET1 COMPANY
EMPLOYEE
COURSE
DATE-COMPLETED
HR11.1 PA115
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR201 TR21.1
TR22.1 TR222
TR500
TRHSET2 COURSE
COMPANY
EMPLOYEE
DATE-COMPLETED
TR201
TRHSET3 OBJ-ID
COMPANY
EMPLOYEE
Subset
WhereOBJ-ID !=Zeroes
TR04.1 TR26.1
TRHSET4 COMPANY
EMPLOYEE
DATE-COMPLETED*
COURSE
TRHSET5 COMPANY
EMPLOYEE
COURSE
DATE-COMPLETED*


PATRNHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
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
NAME
RELATED 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


File created: Thu Jun 09 02:25:08 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.