PATRACKDTL

Track Courses

Contains the courses defined for each track. TR06.1 is the primary program that updates this file.

REFERENCED BY
TR120 TR121 TR20.1 TR20.2 TR20.3 TR20.4
TR01.1 TR205


UPDATED BY
TR03.1 TR05.1 TR06.1 TR201 TR21.1 TR22.1
TR222 TR500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TKD-TRACK
Element: Track
Alpha 10
Contains the track code.
TR06.1
TKD-COURSE
Element: Course Code
Alpha 10
Contains the course code.
TR06.1
TKD-EFFECTIVE-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Contains the date a course is included in the track.
TR06.1
TKD-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
Contains the last date the course is included in the track.
TR06.1
TKD-EST-CMP-TIME
Element: Time to Complete
Numeric 3
Contains an estimate of the amount of time it takes to complete the course.
TR06.1
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
TR06.1
TKD-REQUIRED-FLAG
Element: Required
Alpha 1
Indicates whether the course is required for track completion. Y = Yes N = No
TR06.1
TKD-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
TR06.1


PATRACKDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TKDSET1 TRACK
COURSE
TR05.1 TR06.1
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR21.1 TR22.1
TR222 TR500
TKDSET2 COURSE
TRACK
TR01.1 TR03.1
TR201
TKDSET3 TRACK
SEQ
COURSE
KeyChange
TR06.1 TR205


PATRACKDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:22:23 2016

Home
Contact Us



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