Course Attributes
Contains the skill and proficiency acquired by completing a course. Attribute records are linked to a course by the course name, not the course date. After a completion status is entered in TR22.1 (Session Completion), the skill and proficiency fields update PA22.1 (Skills). TR03.1 (Course Attributes) is the primary program that updates this file.
REFERENCED BY
TR03.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
TRB-COURSE Element: Course | Alpha 10 Contains the course code. |
|
||
TRB-TYPE Element: Type | Alpha 2 Indicates the type of attribute. SK = Skill CE = Certificate AB = Abilities KN = Knowledge OA = Other Attributes |
|
||
TRB-CODE Element: Skill | Alpha 10 Contains the skill or attribute acquired when an employee completes the course. |
|
||
TRB-SKILL-SOURCE Element: Skill Source | Alpha 10 Contains the attribute source. If a skill source was entered in TR00.1 (Training Options), that source defaults. This field updates PA21.1 (Attributes) after a completion status is selected in TR20.1 (Session Registration). |
|
||
TRB-EFFECTIVE-DATE Element: Effective Date | Numeric 8 (yyyymmdd) Contains the date the skill becomes effective. The course start date defaults. |
|
||
TRB-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the ending date for the skill. |
|
||
TRB-PROFIC-LEVEL Element: Proficiency | Alpha 10 Contains the level of skill proficiency acquired by taking the course. |
|
||
TRB-VALID-PERIOD Element: Valid Period | Numeric 3 Entered in conjunction with Unit Type. Indicates length of time before certificate must be renewed. |
|
||
TRB-UNIT-TYPE Element: Unit Type | Alpha 1 The type of period. Either Days, Months, or Years. 1 = Days 2 = Months 3 = Years |
|
||
TRB-VERIFIED-FLAG Element: Verified Flag | Alpha 1 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TRBSET1 |
COURSE TYPE CODE |
|
| ||||||||||||||||
TRBSET2 |
TYPE CODE COURSE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Certification | PCODES |
Required
| ||||||||||||||||||||||||||||||
Competency | PCODES |
Required
| ||||||||||||||||||||||||||||||
Proficiency | PCODES |
Not Required
| ||||||||||||||||||||||||||||||
Skillcode | PCODES |
Required
| ||||||||||||||||||||||||||||||
Skillsource | PCODES |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Course | PACOURSE |
|
All trademarks and registered trademarks are the property of their
respective owners.