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


UPDATED BY
HR00.1 HR01.1 HR04.2 HR04.3 HR04.7 HR04.8
HR06.1 HR506 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 LT101 ZH230 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 PA149 PA208 PA248 PA262
PA263 PA302 PA48.3 PA48.4 PA48.1 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 ZE531 ZE533
ZE534 ZE540

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 ZE533
ZE534
JBR-JOB-CODE
Element: Job Code		Alpha 9
Contains the job code.
PA08.1 PA08.2
PA08.3 PA48.3
PA48.4 ZE533
ZE534
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 ZE533
ZE534
JBR-PERS-CODE
Element: Pers Code		Alpha 10
Contains certification, education and skill codes.
PA08.1 PA08.2
PA08.3 PA48.3
PA48.4 ZE533
ZE534
JBR-SUBJECT-CODE
Element: Subject		Alpha 10
Contains subject codes for ED (education) records.
PA08.1 PA48.3
PA48.4 ZE533
ZE534
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 ZE533
ZE534
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 ZE533
ZE534
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 ZE533
ZE534
JBR-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
PA08.1 ZE533
ZE534
JBR-PROFIC-LEVEL
Element: Profic Level		Alpha 10
PA08.1 ZE533
ZE534
JBR-WGHT
Element: Wght		Signed 5.2
PA08.1 ZE533
ZE534


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
LT101 ZH230
ZH500 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
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: Thu Jun 09 11:22:04 2016

Home
Contact Us



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