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
TR05.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
TRA-TRACK Element: Track | Alpha 10 Contains the track name. |
|
||
TRA-EFFECTIVE-DATE Element: Effective Date | Numeric 8 (yyyymmdd) Contains the date the track becomes effective. |
|
||
TRA-DESC Element: Track Description | Alpha 30 (Lower Case) Contains the track description. |
|
||
TRA-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the ending date for the track. |
|
||
TRA-EST-CMP-TIME Time to Complete Length | Numeric 3 Contains the approximate time it should take to complete the track. |
|
||
TRA-UNIT-VALUE Element: Length/Unit of Time | Alpha 1 Indicates the unit of time upon which the estimated completion time is based. D = Days M = Months Y = Years |
|
||
TRA-CERT-ACHIEVED Element: Certificate Achieved | Alpha 10 Contains the certificate earned when the track is completed. |
|
||
TRA-VALID-PERIOD Validation Period Length | Numeric 3 Contains the length of time for which the certificate is valid. |
|
||
TRA-UNIT-TYPE Element: Length/Unit of Time | Alpha 1 Indicates the unit in which the certificate validation is measured. Y = Years M = Months D = Days |
|
||
TRA-CERT-SOURCE Element: Cert Source | Alpha 10 Indicates the certification source which should be recorded on the employee record (when the track is completed). |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TRASET1 |
TRACK EFFECTIVE-DATE |
|
| ||||||||||||||||||
TRASET2 |
TRACK EFFECTIVE-DATE* |
|
| ||||||||||||||||||
TRASET3 |
CERT-ACHIEVED TRACK EFFECTIVE-DATE* |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cert Source | PCODES |
Required
| ||||||||||||
Certificate | PCODES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Detail | PATRACKDTL |
| ||||||||||||
Employee | PAEMPTRACK |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.