PAATTRIB

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 HR89.8 HR89.9 HR91.7 HR92.1
HR92.2 HR92.3 HS11.1 HS11.2 HS12.1 HS12.2
HS13.1 HS13.2 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 TR20.4


UPDATED BY
TR03.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRB-COURSE
Element: Course
Alpha 10
Contains the course code.
TR03.1
TRB-TYPE
Element: Type
Alpha 2
Indicates the type of attribute. SK = Skill CE = Certificate
AB = Abilities
KN = Knowledge
OA = Other Attributes
TR03.1
TRB-CODE
Element: Skill
Alpha 10
Contains the skill or attribute acquired when an employee completes the course.
TR03.1
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).
TR03.1
TRB-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
Contains the date the skill becomes effective. The course start date defaults.
TR03.1
TRB-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
Contains the ending date for the skill.
TR03.1
TRB-PROFIC-LEVEL
Element: Proficiency
Alpha 10
Contains the level of skill proficiency acquired by taking the course.
TR03.1
TRB-VALID-PERIOD
Element: Valid Period
Numeric 3
Entered in conjunction with Unit Type. Indicates length of time before certificate must be renewed.
TR03.1
TRB-UNIT-TYPE
Element: Unit Type
Alpha 1
The type of period. Either Days, Months, or Years.
1 = Days
2 = Months
3 = Years
TR03.1
TRB-VERIFIED-FLAG
Element: Verified Flag
Alpha 1
TR03.1


PAATTRIB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRBSET1 COURSE
TYPE
CODE
TR01.1 TR03.1
TR05.1 TR06.1
TR201 TR205
TR21.1 TR22.1
TR26.1 TR500
TRBSET2 TYPE
CODE
COURSE
...
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


PAATTRIB FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


PAATTRIB FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE
TRB-COURSE->CRS-COURSE
  CRS-EFFECTIVE-DATE


File created: Thu Jun 09 02:24:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.