|
|
PATRACK FILE
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.
REFERENCED BY
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 TR03.1
UPDATED BY
TR05.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRA-TRACK Alpha 10 TR05.1
Element: Track Contains the track name.
TRA-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR05.1
Element: Effective DateContains the date the track becomes
effective.
TRA-DESC Alpha 30 (Lower Case) TR05.1 TR201
Element: Track DescriptContains the track description.
TRA-END-DATE Numeric 8 (yyyymmdd) TR05.1
Element: End Date Contains the ending date for the track.
TRA-EST-CMP-TIME Numeric 3 TR05.1
Time to Complete Contains the approximate time it should
Length take to complete the track.
TRA-UNIT-VALUE Alpha 1 TR05.1
Element: Length/Unit ofIndicates the unit of time upon which
the estimated completion time is based.
D = Days
M = Months
Y = Years
TRA-CERT-ACHIEVED Alpha 10 TR05.1
Element: Certificate AcContains the certificate earned when
the track is completed.
TRA-VALID-PERIOD Numeric 3 TR05.1
Validation Period Contains the length of time for which
Length the certificate is valid.
TRA-UNIT-TYPE Alpha 1 TR05.1
Element: Length/Unit ofIndicates the unit in which the
certificate validation is measured.
Y = Years
M = Months
D = Days
TRA-CERT-SOURCE Alpha 10
Element: Cert Source 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 TR05.1 TR06.1
EFFECTIVE-DATE TR201 TR205
TR26.1
TRASET2 TRACK PA115 TR05.1
EFFECTIVE-DATE* TR06.1 TR113
TR114 TR13.1
TR13.2 TR15.1
TR21.1 TR22.1
TR222 TR500
TRASET3 CERT-ACHIEVED KeyChange, Subset HR04.2 HR04.3
TRACK Where CERT-ACHIEVED != Spaces HR04.7 HR04.8
EFFECTIVE-DATE* 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 RELATED
NAME 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 RELATED
NAME 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
|
