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 |
TR20.4 | TR21.1 | TR22.1 | TR222 | TR500 | TR01.1 |
TR03.1 | TR201 | TR205 |
TR06.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
TKD-TRACK Element: Track | Alpha 10 Contains the track code. |
|
||
TKD-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||
TKD-EFFECTIVE-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the date a course is included in the track. |
|
||
TKD-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the last date the course is included in the track. |
|
||
TKD-EST-CMP-TIME Element: Time to Complete | Numeric 3 Contains an estimate of the amount of time it takes to complete the course. |
|
||
TKD-UNIT-TYPE Time to Complete/Unit of Time | Alpha 1 Indicates the unit by which the time to complete is measured. Y = Years M = Months D = Days |
|
||
TKD-REQUIRED-FLAG Element: Required | Alpha 1 Indicates whether the course is required for track completion. Y = Yes N = No |
|
||
TKD-SEQ Element: Seq | Numeric 3 This field contains the record sequence number. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TKDSET1 |
TRACK COURSE |
|
| ||||||||||||||||||
TKDSET2 |
COURSE TRACK |
|
| ||||||||||||||||||
TKDSET3 |
TRACK SEQ COURSE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Attributes | PAATTRIB |
| ||||||||||||
Course | PACOURSE |
| ||||||||||||
Track | PATRACK |
| ||||||||||||
Training | PATRNHIST |
|
All trademarks and registered trademarks are the property of their
respective owners.