PATRACK

Tracks

Contains track definition information such as the name, description, effective dates, and certificates earned upon completion. TA05.1 (Track) is the primary program that updates this file.
UPDATED BY
TR05.1 TR06.1 TR201 TR205 TR26.1 PA115
TR113 TR114 TR13.1 TR13.2 TR15.1 TR21.1
TR22.1 TR222 TR500 HR04.2 HR04.3 HR04.7
HR04.8 HR80.1 HR80.2 HR80.3 HR80.4 HR80.5
HR80.6 HR80.7 HR80.8 HR80.9 HR81.1 HR81.2
HR81.3 HR81.4 HR81.5 HR81.6 HR81.7 HR81.8
HR81.9 HR82.1 HR82.2 HR82.3 HR82.4 HR82.5
HR82.6 HR82.7 HR82.8 HR82.9 HR83.1 HR83.2
HR83.3 HR83.4 HR83.5 HR83.6 HR83.7 HR83.8
HR83.9 HR84.1 HR84.2 HR84.3 HR84.4 HR84.5
HR84.6 HR84.7 HR84.8 HR84.9 HR85.1 HR85.2
HR85.3 HR85.4 HR85.5 HR85.6 HR85.7 HR85.8
HR86.1 HR86.2 HR86.3 HR86.4 HR86.5 HR86.6
HR86.7 HR86.8 HR86.9 HR87.1 HR87.2 HR87.3
HR87.4 HR87.5 HR87.6 HR87.7 HR87.8 HR87.9
HR88.1 HR88.2 HR88.3 HR88.4 HR88.5 HR88.6
HR88.7 HR89.1 HR89.2 HR89.3 HR89.4 HR89.5
HR89.6 HR89.7 HR89.8 HR89.9 HR91.7 HR92.1
HR92.2 TR03.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRA-TRACK
Element: Track		Alpha 10
Contains the track name.
TR05.1
TRA-EFFECTIVE-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
Contains the date the track becomes effective.
TR05.1
TRA-DESC
Element: Track Description		Alpha 30 (Lower Case)
Contains the track description.
TR05.1 TR201
TRA-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
Contains the ending date for the track.
TR05.1
TRA-EST-CMP-TIME
Time to Complete
Length		Numeric 3
Contains the approximate time it should take to complete the track.
TR05.1
TRA-UNIT-VALUE
Element: Length/Unit of Time		Alpha 1
Indicates the unit of time upon which the estimated completion time is based. D = Days M = Months Y = Years
TR05.1
TRA-CERT-ACHIEVED
Element: Certificate Achieved		Alpha 10
Contains the certificate earned when the track is completed.
TR05.1
TRA-VALID-PERIOD
Validation Period
Length		Numeric 3
Contains the length of time for which the certificate is valid.
TR05.1
TRA-UNIT-TYPE
Element: Length/Unit of Time		Alpha 1
Indicates the unit in which the certificate validation is measured.
Y = Years
M = Months
D = Days
TR05.1
TRA-CERT-SOURCE
Element: Cert Source		Alpha 10
Indicates the certification source which should be recorded on the employee record (when the track is completed).


PATRACK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRASET1 TRACK
EFFECTIVE-DATE
TR05.1 TR06.1
TR201 TR205
TR26.1
TRASET2 TRACK
EFFECTIVE-DATE*
PA115 TR05.1
TR06.1 TR113
TR114 TR13.1
TR13.2 TR15.1
TR21.1 TR22.1
TR222 TR500
TRASET3 CERT-ACHIEVED
TRACK
EFFECTIVE-DATE*
KeyChange, Subset
WhereCERT-ACHIEVED !=Spaces
...
HR04.2 HR04.3
HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8


PATRACK FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Cert Source PCODES Required
When TRA-CERT-SOURCE !=Spaces
"CU"->PCO-TYPE
TRA-CERT-SOURCE->PCO-CODE
Certificate PCODES Required
When TRA-CERT-ACHIEVED !=Spaces
"CE"->PCO-TYPE
TRA-CERT-ACHIEVED->PCO-CODE


PATRACK FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Detail PATRACKDTL
TRA-TRACK->TKD-TRACK
  TKD-COURSE
Employee PAEMPTRACK Delete Restricted
"TR"->ETR-TYPE
TRA-TRACK->ETR-TRACK
  ETR-COMPANY
  ETR-EMPLOYEE

File created: Wed Jun 08 20:50:26 2016

Home
Contact Us



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