PAATTRIB – Course Attributes

System
Personnel (PA)
Prefix
TRB
Primary key
COURSE, TYPE, CODE
Fields
10
Updated by
1 program
Referenced by
142 programs

PAATTRIB is the Course Attributes table in Lawson Personnel (prefix TRB). It is indexed by COURSE, TYPE, CODE (TRBSET1); alternate indexes: TRBSET2. It is related 1:1 to PCODES and 1:M to PACOURSE. It is updated by TR03.1 and referenced by HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 and 134 more. The table has 10 fields, 2 indexes and 6 documented relations.

About PAATTRIB

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.

Fields (10)

Column = COBOL field name without the TRB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#TRB-COURSE PK
COURSE		Alpha 10Contains the course code.TR03.1
#TRB-TYPE PK
TYPE		Alpha 2Indicates the type of attribute.
  • SK Skill
  • CE Certificate
  • AB Abilities
  • KN Knowledge
  • OA Other Attributes
TR03.1
#TRB-CODE PK
CODE		Alpha 10Contains the skill or attribute acquired when an employee completes the course.TR03.1
#TRB-SKILL-SOURCE
SKILL_SOURCE		Alpha 10Contains 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).TR03.1
#TRB-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)Contains the date the skill becomes effective. The course start date defaults.TR03.1
#TRB-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the ending date for the skill.TR03.1
#TRB-PROFIC-LEVEL
PROFIC_LEVEL		Alpha 10Contains the level of skill proficiency acquired by taking the course.TR03.1
#TRB-VALID-PERIOD
VALID_PERIOD		Numeric 3Entered in conjunction with Unit Type. Indicates length of time before certificate must be renewed.TR03.1
#TRB-UNIT-TYPE
UNIT_TYPE		Alpha 1The type of period. Either Days, Months, or Years.
  • 1 Days
  • 2 Months
  • 3 Years
TR03.1
#TRB-VERIFIED-FLAG
VERIFIED_FLAG		Alpha 1—TR03.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TRBSET1
  1. COURSE
  2. TYPE
  3. CODE
PrimaryTR01.1, TR03.1, TR05.1, TR06.1, TR201, TR205, TR21.1, TR22.1 +2 more
TRBSET2
  1. TYPE
  2. CODE
  3. COURSE
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PCODESPACOURSEPAATTRIB

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CertificationPCODESRequiredWhen TRB-TYPE = "CE"
"CE"→PCO-TYPE
TRB-CODE→PCO-CODE
CompetencyPCODESRequiredWhen (TRB-TYPE = "AB") Or (TRB-TYPE = "KN") Or (TRB-TYPE = "OA") Or (TRB-TYPE = "SK")
TRB-TYPE→PCO-TYPE
TRB-CODE→PCO-CODE
ProficiencyPCODESNot RequiredValid When (TRB-PROFIC-LEVEL != Spaces)
"PF"→PCO-TYPE
TRB-PROFIC-LEVEL→PCO-CODE
SkillcodePCODESRequiredWhen TRB-TYPE = "SK"
"SK"→PCO-TYPE
TRB-CODE→PCO-CODE
SkillsourcePCODESNot RequiredValid When (TRB-SKILL-SOURCE != Spaces)
"SS"→PCO-TYPE
TRB-SKILL-SOURCE→PCO-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
CoursePACOURSE
TRB-COURSE→CRS-COURSE
—→CRS-EFFECTIVE-DATE

Programs

Updated by (1)

Referenced by (142)