PATRACKDTL FILE
Track Courses
Contains the courses defined for each track.
TR06.1 is the primary program that updates this file.
REFERENCED BY
TR05.1 TR120 TR121 TR20.1 TR20.2 TR20.3
TR21.1 TR22.1 TR222 TR500 TR01.1 TR03.1
TR201 TR205
UPDATED BY
TR06.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TKD-TRACK Alpha 10 TR06.1
Element: Track Contains the track code.
TKD-COURSE Alpha 10 TR06.1
Element: Course Code Contains the course code.
TKD-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR06.1
Element: Start Date Contains the date a course is included
in the track.
TKD-END-DATE Numeric 8 (yyyymmdd) TR06.1
Element: End Date Contains the last date the course is
included in the track.
TKD-EST-CMP-TIME Numeric 3 TR06.1
Element: Time to CompleContains an estimate of the amount of
time it takes to complete the course.
TKD-UNIT-TYPE Alpha 1 TR06.1
Time to Indicates the unit by which the time to
Complete/Unit of Time complete is measured.
Y = Years
M = Months
D = Days
TKD-REQUIRED-FLAG Alpha 1 TR06.1
Element: Required Indicates whether the course is
required for track completion.
Y = Yes
N = No
TKD-SEQ Numeric 3 TR06.1
Element: Sequence NumbeThis field contains the record sequence
number.
PATRACKDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TKDSET1 TRACK TR05.1 TR06.1
COURSE TR120 TR121
TR20.1 TR20.2
TR20.3 TR21.1
TR22.1 TR222
TR500
TKDSET2 COURSE TR01.1 TR03.1
TRACK TR201
TKDSET3 TRACK KeyChange TR06.1 TR205
SEQ
COURSE
PATRACKDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Attributes PAATTRIB
TKD-COURSE -> TRB-COURSE
TRB-TYPE
TRB-CODE
Course PACOURSE
TKD-COURSE -> CRS-COURSE
CRS-EFFECTIVE-DATE
Track PATRACK
TKD-TRACK -> TRA-TRACK
TRA-EFFECTIVE-DATE
Training PATRNHIST
TKD-COURSE -> TRH-COURSE
TRH-COMPANY
TRH-EMPLOYEE
TRH-DATE-COMPLETED
|