JOBRELATE

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
PA249 PA49.1 PA49.3 PA549


UPDATED BY
PA08.1 PA08.2 PA08.3 PA48.3 PA48.4 PA48.1
HR00.1 HR01.1 HR06.1 HR506 HS11.1 HS11.2
HS12.1 HS12.2 HS13.1 HS13.2 HS50.1 HS50.2
HS51.1 HS51.2 HS52.1 HS52.2 PA02.1 PA208
PA262 PA263 PA302 PA502 PA62.1 PA63.1
PA64.1 PA64.2 PA65.1 PA65.2 TR120 TR121
TR20.1 TR20.2 TR20.3 TR20.4 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
PA149 PA248

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBR-COMPANY
Element: Company		Numeric 4
Contains the company number which represents an established company.
PA08.1 PA08.2
PA08.3 PA48.3
PA48.4
JBR-JOB-CODE
Element: Job Code		Alpha 9
Contains the job code.
PA08.1 PA08.2
PA08.3 PA48.3
PA48.4
JBR-TYPE
Element: Type		Alpha 2
Contains the relationship type.
CE = Certification
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
PA08.1 PA08.2
PA08.3 PA48.3
PA48.4
JBR-PERS-CODE
Element: Pers Code		Alpha 10
Contains certification, education and skill codes.
PA08.1 PA08.2
PA08.3 PA48.3
PA48.4
JBR-SUBJECT-CODE
Element: Subject		Alpha 10
Contains subject codes for ED (education) records.
PA08.1 PA48.3
PA48.4
JBR-REQUIRED-FLAG
Element: Essential		Alpha 1
Indicates whether certain qualifications are required for a job or position.
Y = Yes
N = No
PA08.1 PA08.2
PA08.3 PA48.3
PA48.4
JBR-PCT-OF-TIME
Element: Percent of Time		Signed 5.2
Contains the percent of the time the employee will spend on this essential function.
PA08.1 PA08.2
PA08.3 PA48.3
PA48.4
JBR-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
PA08.1 PA08.2
PA08.3 PA48.3
PA48.4
JBR-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
PA08.1
JBR-PROFIC-LEVEL
Element: Profic Level		Alpha 10
PA08.1
JBR-WGHT
Element: Wght		Signed 5.2
PA08.1


JOBRELATE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBRSET1 COMPANY
PROCESS-LEVEL
JOB-CODE
POSITION
TYPE
PERS-CODE
SUBJECT-CODE
...
HR00.1 HR01.1
HR06.1 HR506
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS51.1 HS51.2
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
JBRSET2 COMPANY
PROCESS-LEVEL
TYPE
PERS-CODE
SUBJECT-CODE
JOB-CODE
POSITION
...
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


JOBRELATE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:50:21 2016

Home
Contact Us



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