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.

Field / column	Type	Description & values	Updated by
`TRB-COURSE` PK COURSE	Alpha 10	Contains the course code.	TR03.1
`TRB-TYPE` PK TYPE	Alpha 2	Indicates the type of attribute. `SK` Skill `CE` Certificate `AB` Abilities `KN` Knowledge `OA` Other Attributes	TR03.1
`TRB-CODE` PK CODE	Alpha 10	Contains the skill or attribute acquired when an employee completes the course.	TR03.1
`TRB-SKILL-SOURCE` 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).	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 10	Contains the level of skill proficiency acquired by taking the course.	TR03.1
`TRB-VALID-PERIOD` VALID_PERIOD	Numeric 3	Entered in conjunction with Unit Type. Indicates length of time before certificate must be renewed.	TR03.1
`TRB-UNIT-TYPE` UNIT_TYPE	Alpha 1	The 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`TRBSET1`	`COURSE`, `TYPE`, `CODE`	Primary		TR01.1, TR03.1, TR05.1, TR06.1, TR201, TR205, TR21.1, TR22.1 +2 more
`TRBSET2`	`TYPE`, `CODE`, `COURSE`			HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Certification	PCODES	Required	When TRB-TYPE = "CE"	`"CE"` → `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"	`"SK"` → `PCO-TYPE`, `TRB-CODE` → `PCO-CODE`
Skillsource	PCODES	Not Required	Valid When (TRB-SKILL-SOURCE != Spaces)	`"SS"` → `PCO-TYPE`, `TRB-SKILL-SOURCE` → `PCO-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Course	PACOURSE			`TRB-COURSE` → `CRS-COURSE`, → `CRS-EFFECTIVE-DATE`

Programs

Updated by (1)

TR03.1 Course Certifications and Competencies

Referenced by (142)

HR04.2 Human Resource Codes
HR04.3 Human Resource Codes
HR04.7 User Fields Value List
HR04.8 Human Resource Codes
HR80.1 Job Occupation Type
HR80.2 Union
HR80.3 Bargaining Unit
HR80.4 Badge Code
HR80.5 Mail Group
HR80.6 Hire Source
HR80.7 User Level
HR80.8 Relationship
HR80.9 Primary Care Physician
HR81.1 Education Degree
HR81.2 Education Subject
HR81.3 Education Institution
HR81.4 Competency
HR81.5 Competency and Certification Source
HR81.6 Certification
HR81.7 Company Property
HR81.8 Emergency Medical
HR81.9 Work Restriction
HR82.1 Working Condition
HR82.2 Work Requirement
HR82.3 Parking Lot
HR82.4 Relocation
HR82.5 Benefit
HR82.6 Qualification
HR82.7 Proficiency
HR82.8 User Field
HR82.9 Association
HR83.1 Review Type
HR83.2 Performance Rating
HR83.3 Applicant Rating
HR83.4 Interview Rating
HR83.5 Personnel Action Reason
HR83.6 Review Type
HR83.7 Benefit Reason Code
HR83.8 Requisition Status
HR83.9 Reason Code
HR84.1 Position Reason Code
HR84.2 Budget Reason Code
HR84.3 Requisition Cost
HR84.4 Supervisor User Field 1
HR84.5 Supervisor User Field 2
HR84.6 Supervisor User Field 3
HR84.7 Supervisor User Field 4
HR84.8 Supervisor User Field 5
HR84.9 Incident Status
HR85.1 Incident Outcome
HR85.2 Incident Category
HR85.3 Incident
HR85.4 Illness
HR85.5 Body Part
HR85.6 Incident Cost Category
HR85.7 Incident Cost Type
HR85.8 Accommodations
HR86.1 Incident Follow Up Category
HR86.2 Incident Follow Up Type
HR86.3 Incident Follow Up Outcome
HR86.4 Test Type
HR86.5 Test Correspondence
HR86.6 Test Source
HR86.7 Test User Field 2
HR86.8 Test User Field 3
HR86.9 Test Eligibility Override Reason
HR87.1 Test Reason
HR87.2 Test Notification Type
HR87.3 Test Refusal Reason
HR87.4 Incident Severity
HR87.5 Incident User 2
HR87.6 Incident User 3
HR87.7 Grievance and Disciplinary Action Category
HR87.8 Grievance and Disciplinary Action Status
HR87.9 Grievance and Disciplinary Action Outcome
HR88.1 Grievance and Disciplinary Action Step Category
HR88.2 Grievance and Disciplinary Action Step Type
HR88.3 Grievance and Disciplinary Action Step Outcome
HR88.4 Human Resource Codes - Disability
HR88.5 Human Resource Codes - Religion
HR88.6 Contract Type
HR88.7 Census Metropolitan Area
HR89.1 HR Codes - Work Eligibility Document Type
HR89.2 HR Codes - Work Eligibility Document Description
HR89.3 Human Resource Codes - Work Eligibility Status
HR89.4 Human Resource Codes - Travel Doc Application Status
HR89.5 Human Resource Codes - Travel Document
HR89.6 Human Resource Codes - Contact Number Type
HR89.7 HR Codes - Official Languages - Bilingual Region
HR89.8 Sharp Device
HR89.9 Brand of Device
HR91.7 Objective Status
HR92.1 Day Codes
HR92.2 Leave Status
HR92.3 Leave Reason
HS11.1 Web Competency Profile
HS11.2 Web Competency Profile
HS12.1 Web Expired Competencies
HS12.2 Web Expired Competencies
HS13.1 Web Competency Compliance Rpt
HS13.2 Web Competency Compliance Rpt
HS50.1 Employee Qualification Search
HS50.2 Employee Qualification Search
HS50.3 Training Courses
HS50.4 Training Courses
HS51.1 Employee Qualification Search
HS51.2 Employee Qualification Search
HS52.1 Employee Qualification Search
HS52.2 Employee Qualification Search
PA20.1 Education
PA21.1 Competencies
PA22.1 Certifications
PA24.1 Relocation
PA262 Qualified Employees Listing
PA263 Qualified Applicants Listing
PA27.1 Contracts
PA34.1 Applicant Education
PA35.1 Applicant Competencies
PA36.1 Applicant Certification
PA38.1 Applicant Relocation
PA520 Employee and Applicant Code Conversion
PA62.1 Employee Qualification Search
PA63.1 Applicant Qualification Search
PA64.1 Employee Job Qualification
PA64.2 Employee Position Qualification
PA65.1 Applicant Job Qualification
PA65.2 Applicant Position Qualification
TR01.1 Course
TR05.1 Track
TR06.1 Track Courses
TR120 Group Session Registration
TR121 Job Code Session Registration
TR20.1 Session Registration
TR20.2 Mass Registration
TR20.3 Session Registration Override
TR20.4 Employee Session Registration
TR201 Course Profile
TR205 Track Listing
TR21.1 Employee Training History
TR22.1 Session Completion
TR26.1 Employee Training Competency Maintenance
TR500 Training Conversion