|
JOBRELATE FILE
Job Code Relationship
The Job Code Relationship file contains information about the certification,
education, and skills which are desired or required qualifications for a job
or a position.
REFERENCED BY
HR06.1 HR506 HS11.1 HS12.1 HS13.1 HS14.1
HS50.1 HS50.2 HS51.1 HS51.2 HS52.1 HS52.2
PA208 PA262 PA263 PA62.1 PA63.1 PA64.1
PA64.2 PA65.1 PA65.2 TR120 TR121 TR20.1
TR20.2 TR20.3 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 PA149 PA248 PA249 PA49.1 PA49.3
PA549
UPDATED BY
PA08.1 PA08.2 PA08.3 PA48.3 PA48.4 PA48.1
HR00.1 HR01.1 PA02.1 PA302 PA502 PBIP.1
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBR-COMPANY Numeric 4 PA08.1 PA08.2
Element: Company Contains the company number which PA08.3 PA48.3
represents an established company. PA48.4
JBR-JOB-CODE Alpha 9 PA08.1 PA08.2
Element: Job Code Contains the job code. PA08.3 PA48.3
PA48.4
JBR-TYPE Alpha 2 PA08.1 PA08.2
Element: Type Contains the relationship type. PA08.3 PA48.3
CE = Certification PA48.4
ED = Education Degree
SK = Skill
SR = Supervision Received
EO = Equipment Operated
TR = Travel
EC = Environmental Conditions
PH = Physical Requirements
MR = Mental Requirements
TS = Test
PF = Proficiency
AB = Ability
KN = Knowledge
OA = Other Attributes
JBR-PERS-CODE Alpha 10 PA08.1 PA08.2
Element: Personnel CodeContains certification, education and PA08.3 PA48.3
skill codes. PA48.4
JBR-SUBJECT-CODE Alpha 10 PA08.1 PA48.3
Element: Subject Contains subject codes for ED PA48.4
(education) records.
JBR-REQUIRED-FLAG Alpha 1 PA08.1 PA08.2
Element: Essential Indicates whether certain PA08.3 PA48.3
qualifications are required for a job or PA48.4
position.
Y = Yes
N = No
JBR-PCT-OF-TIME Signed 5.2 PA08.1 PA08.2
Element: Percent of TimContains the percent of the time the PA08.3 PA48.3
employee will spend on this essential PA48.4
function.
JBR-POSITION Alpha 12 PA08.1 PA08.2
Element: Position Contains the user-defined code that PA08.3 PA48.3
represents a position in the company. PA48.4
JBR-PROCESS-LEVEL Alpha 5 PA08.1
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
JBR-PROFIC-LEVEL Alpha 10 PA08.1
Element: Profic Level
JBR-WGHT Signed 5.2 PA08.1
Element: Weight
JOBRELATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBRSET1 COMPANY HR00.1 HR01.1
PROCESS-LEVEL HR06.1 HR506
JOB-CODE HS11.1 HS12.1
POSITION HS13.1 HS14.1
TYPE HS50.1 HS50.2
PERS-CODE HS51.1 HS51.2
SUBJECT-CODE HS52.1 HS52.2
PA02.1 PA08.1
PA08.2 PA08.3
PA208 PA262
PA263 PA302
PA48.4 PA502
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
...
JBRSET2 COMPANY HR04.2 HR04.3
PROCESS-LEVEL HR04.7 HR04.8
TYPE HR80.1 HR80.2
PERS-CODE HR80.3 HR80.4
SUBJECT-CODE HR80.5 HR80.6
JOB-CODE HR80.7 HR80.8
POSITION 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
...
JOBRELATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
JBR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Compet Profic PACOMPPROF Not Required
Valid When ((JBR-TYPE = "AB" )
Or (JBR-TYPE = "KN" )
Or (JBR-TYPE = "OA" )
Or (JBR-TYPE = "SK" ))
And (JBR-PROFIC-LEVEL != Spaces )
JBR-COMPANY -> PCM-COMPANY
Spaces -> PCM-PROCESS-LEVEL
JBR-TYPE -> PCM-TYPE
JBR-PERS-CODE -> PCM-CODE
JBR-PROFIC-LEVEL -> PCM-PROFIC-LEVEL
Job Code JOBCODE Required
When (JBR-JOB-CODE != Spaces )
JBR-COMPANY -> JBC-COMPANY
JBR-JOB-CODE -> JBC-JOB-CODE
Pers Code PCODES Required
JBR-TYPE -> PCO-TYPE
JBR-PERS-CODE -> PCO-CODE
Process Level PRSYSTEM Required
When (JBR-PROCESS-LEVEL != Spaces )
JBR-COMPANY -> PRS-COMPANY
JBR-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Profic Level PCODES Required
When (JBR-PROFIC-LEVEL != Spaces )
"PF" -> PCO-TYPE
JBR-PROFIC-LEVEL -> PCO-CODE
Subject PCODES Required
When JBR-SUBJECT-CODE != Spaces
"ES" -> PCO-TYPE
JBR-SUBJECT-CODE -> PCO-CODE
Test Require PATSTSETUP Required
When (JBR-TYPE = "TS" )
JBR-COMPANY -> PAP-COMPANY
JBR-PERS-CODE -> PAP-TEST
JOBRELATE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Empcodes Apps EMPCODES
Valid When (JBR-TYPE = "CE" )
Or (JBR-TYPE = "ED" )
Or (JBR-TYPE = "SK" )
Or (JBR-TYPE = "AB" )
Or (JBR-TYPE = "KN" )
Or (JBR-TYPE = "OA" )
JBR-COMPANY -> EPC-COMPANY
JBR-TYPE -> EPC-TYPE
1 -> EPC-EMP-APP
JBR-PERS-CODE -> EPC-CODE
EPC-EMPLOYEE
EPC-SUBJECT
EPC-SEQ-NBR
Empcodes Emps EMPCODES
Valid When (JBR-TYPE = "CE" )
Or (JBR-TYPE = "ED" )
Or (JBR-TYPE = "SK" )
Or (JBR-TYPE = "AB" )
Or (JBR-TYPE = "KN" )
Or (JBR-TYPE = "OA" )
JBR-COMPANY -> EPC-COMPANY
JBR-TYPE -> EPC-TYPE
Zeroes -> EPC-EMP-APP
JBR-PERS-CODE -> EPC-CODE
EPC-EMPLOYEE
EPC-SUBJECT
EPC-SEQ-NBR
Position PAPOSITION Required
When (JBR-POSITION != Spaces )
JBR-COMPANY -> POS-COMPANY
JBR-POSITION -> POS-POSITION
POS-EFFECT-DATE
Proficiency PACOMPPROF
Valid When (JBR-TYPE = "AB" )
Or (JBR-TYPE = "KN" )
Or (JBR-TYPE = "OA" )
Or (JBR-TYPE = "SK" )
JBR-COMPANY -> PCM-COMPANY
Spaces -> PCM-PROCESS-LEVEL
JBR-TYPE -> PCM-TYPE
JBR-PERS-CODE -> PCM-CODE
PCM-PROFIC-LEVEL
|