|
|
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 HR89.8 HR89.9 HR91.7 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
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: 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"
"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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE
TRB-COURSE -> CRS-COURSE
CRS-EFFECTIVE-DATE
|
