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 TR113 TR114 TR13.1
TR13.2 TR15.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 TR03.1
UPDATED BY
TR05.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRA-TRACK Alpha 10 TR05.1
Track Contains the track name.
TRA-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR05.1
Effective Date Contains the date the track becomes
effective.
TRA-DESC Alpha 30 (Lower Case) TR05.1 TR201
Track Description Contains the track description.
TRA-END-DATE Numeric 8 (yyyymmdd) TR05.1
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
Length/Unit of Time Indicates 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
Certificate Achieved Contains 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
Length/Unit of Time Indicates the unit in which the
certificate validation is measured.
Y = Years
M = Months
D = Days
TRA-CERT-SOURCE Alpha 10
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
TRASET2 TRACK TR05.1 TR06.1
EFFECTIVE-DATE* TR113 TR114
TR13.1 TR13.2
TR15.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 Not Required
Valid 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
"T" -> ETR-TYPE
TRA-TRACK -> ETR-TRACK
ETR-COMPANY
ETR-EMPLOYEE
|
