Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAATTRIB


                             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    TR05.1    TR06.1    TR201     TR205     TR21.1
TR22.1    TR26.1    TR500     HR04.2    HR04.3    HR04.7
HR04.8    HR80.1    HR80.2    HR80.3    HR80.4    HR80.5
HR80.6    HR80.7    HR80.8    HR80.9    HR81.1    HR81.2
HR81.3    HR81.4    HR81.5    HR81.6    HR81.7    HR81.8
HR81.9    HR82.1    HR82.2    HR82.3    HR82.4    HR82.5
HR82.6    HR82.7    HR82.8    HR82.9    HR83.1    HR83.2
HR83.3    HR83.4    HR83.5    HR83.6    HR83.7    HR83.8
HR83.9    HR84.1    HR84.2    HR84.3    HR84.4    HR84.5
HR84.6    HR84.7    HR84.8    HR84.9    HR85.1    HR85.2
HR85.3    HR85.4    HR85.5    HR85.6    HR85.7    HR85.8
HR86.1    HR86.2    HR86.3    HR86.4    HR86.5    HR86.6
HR86.7    HR86.8    HR86.9    HR87.1    HR87.2    HR87.3
HR87.4    HR87.5    HR87.6    HR87.7    HR87.8    HR87.9
HR88.1    HR88.2    HR88.3    HR88.4    HR88.5    HR88.6
HR88.7    HR89.1    HR89.2    HR89.3    HR89.4    HR89.5
HR89.6    HR89.7    HS50.1    HS50.2    HS50.3    HS50.4
HS51.1    HS51.2    HS52.1    HS52.2    PA20.1    PA21.1
PA22.1    PA24.1    PA262     PA263     PA27.1    PA34.1
PA35.1    PA36.1    PA38.1    PA520     PA62.1    PA63.1
PA64.1    PA64.2    PA65.1    PA65.2    TR120     TR121
TR20.1    TR20.2    TR20.3

UPDATED BY

TR03.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

TRB-TYPE               Alpha 2                                   TR03.1
Element: Type          Indicates the type of attribute.
                       SK = Skill
                       CE = Certificate
                       AB = Abilities
                       KN = Knowledge
                       OA = Other Attributes

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


TRB-SKILL-SOURCE       Alpha 10                                  TR03.1
Element: 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
Element: Effective DateContains the date the skill becomes
                       effective. The course start date
                       defaults.

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

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

TRB-VALID-PERIOD       Numeric 3                                 TR03.1
Element: Valid Period  Entered in conjunction with Unit Type.
                       Indicates length of time before
                       certificate must be renewed.

TRB-UNIT-TYPE          Alpha 1                                   TR03.1
Element: EEO Unit Type The type of period. Either Days, Months,
                       or Years.
                       1 = Days
                       2 = Months
                       3 = Years

                         PAATTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

TRBSET2   TYPE                                                   HR04.2  HR04.3
          CODE                                                   HR04.7  HR04.8
          COURSE                                                 HR80.1  HR80.2
                                                                 HR80.3  HR80.4
                                                                 HR80.5  HR80.6
                                                                 HR80.7  HR80.8
                                                                 HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 ...

                         PAATTRIB FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Certification  PCODES       Required
                            When TRB-TYPE = "CE"

                            "C"                 -> PCO-TYPE
                            TRB-CODE            -> PCO-CODE

Competency     PCODES       Required
                            When (TRB-TYPE = "AB" )
                            Or   (TRB-TYPE = "KN" )
                            Or   (TRB-TYPE = "OA" )
                            Or   (TRB-TYPE = "SK" )

                            TRB-TYPE            -> PCO-TYPE
                            TRB-CODE            -> PCO-CODE

Proficiency    PCODES       Not Required
                            Valid When (TRB-PROFIC-LEVEL != Spaces )

                            "PF"                -> PCO-TYPE
                            TRB-PROFIC-LEVEL    -> PCO-CODE

Skillcode      PCODES       Required
                            When TRB-TYPE = "SK"

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

Skillsource    PCODES       Not Required
                            Valid When (TRB-SKILL-SOURCE != Spaces )

                            "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