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
HR06.1 HR506 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 PA208 PA262 PA263
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 HR92.3 PA149 PA248 PA249
PA49.1 PA49.3 PA549


UPDATED BY
PA08.1 PA08.2 PA08.3 PA48.3 PA48.4 PA48.1
ZE533 ZE534 HR00.1 HR01.1 LT101 LT111
ZH500 PA02.1 PA302 PA502

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 LT111
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
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 02:24:48 2016

Home
Contact Us



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