PAATTRIB FILE

                           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

TR01.1    TR201     TR205     TR21.1    TR22.1    TR500

UPDATED BY

TR03.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TRB-COURSE           Alpha 10                                    TR03.1
Course               Contains the course code.

TRB-TYPE             Alpha 2                                     TR03.1
Type                 Indicates the type of attribute.
                     SK = Skill

TRB-CODE             Alpha 10                                    TR03.1
Skill                Contains the skill or attribute
                     acquired when an employee completes the
                     course.


TRB-SKILL-SOURCE     Alpha 10                                    TR03.1
Skill Source         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   Numeric 8  (yyyymmdd)                       TR03.1
Effective Date       Contains the date the skill becomes
                     effective. The course start date
                     defaults.

TRB-END-DATE         Numeric 8  (yyyymmdd)                       TR03.1
End Date             Contains the ending date for the skill.

TRB-PROFIC-LEVEL     Alpha 10                                    TR03.1
Proficiency          Contains the level of skill proficiency
                     acquired by taking the course.

                         PAATTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRBSET1   COURSE                                                 TR01.1  TR03.1
          TYPE                                                   TR201   TR205
          CODE                                                   TR21.1  TR22.1
                                                                 TR500

TRBSET2   TYPE
          CODE
          COURSE

                         PAATTRIB FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Proficiency    PCODES       Not Required

                            "PF"                -> PCO-TYPE  (PCOSET1)
                            TRB-PROFIC-LEVEL    -> PCO-CODE

Skillcode      PCODES       Required

                            "S"                 -> PCO-TYPE
                            TRB-CODE            -> PCO-CODE

Skillsource    PCODES       Not Required

                            "SS"                -> PCO-TYPE
                            TRB-SKILL-SOURCE    -> PCO-CODE

                         PAATTRIB FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course         PACOURSE

                            TRB-COURSE          -> CRS-COURSE
                                                   CRS-EFFECTIVE-DATE