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 HS11.1 HS12.1 HS13.1 HS14.1 PA208
PA262 PA263 PA62.1 PA63.1 PA64.1 PA64.2
PA65.1 PA65.2 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 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBR-COMPANY Numeric 4 PA08.1 PA08.2
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
Job Code Contains the job code. PA08.3 PA48.3
PA48.4
JBR-TYPE Alpha 2 PA08.1 PA08.2
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
JBR-PERS-CODE Alpha 10 PA08.1 PA08.2
Personnel Code Contains certification, education and PA08.3 PA48.3
skill codes. PA48.4
JBR-SUBJECT-CODE Alpha 10 PA08.1 PA48.3
Subject Contains subject codes for ED PA48.4
(education) records.
JBR-REQUIRED-FLAG Alpha 1 PA08.1 PA08.2
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
Percent of Time Contains 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
Position Contains the user-defined code that PA08.3 PA48.3
represents a position in the company. PA48.4
JOBRELATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBRSET1 COMPANY HR00.1 HR01.1
JOB-CODE HR06.1 HS11.1
POSITION HS12.1 HS13.1
TYPE HS14.1 PA02.1
PERS-CODE PA08.1 PA08.2
SUBJECT-CODE PA08.3 PA208
PA262 PA263
PA302 PA48.4
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
PBIP.1
JBRSET2 COMPANY PA149 PA248
TYPE PA249 PA48.1
PERS-CODE PA48.3 PA49.1
SUBJECT-CODE PA49.3 PA549
JOB-CODE
POSITION
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
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
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"
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"
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
|