PAJOBINTRS FILE
UPDATED BY
HS50.5 HR00.1 HR01.1 HR11.1 PA115 PA120
PBIP.1 PR197 HR06.1 HR506 PA02.1 PA302
PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PJI-COMPANY Numeric 4 HS50.5
Company The company number represents an
established company and is entered on
all function codes.
PJI-EMP-APP Numeric 1 HS50.5
Type Indicates whether the person is an
external or internal applicant.
An external applicant is a person
applying from outside the company; an
internal applicant is an employee
applying from inside the company.
PJI-EMPLOYEE Numeric 9 HS50.5
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PJI-JOB-CODE Alpha 9 HS50.5
Job Code Contains a user-defined code that
represents a type of job.
PJI-POSITION Alpha 12 HS50.5
Position Contains the user-defined code that
represents a position in the company.
PJI-DATE-STAMP Numeric 8 (yyyymmdd) HS50.5
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PJI-TIME-STAMP Numeric 6 (hhmmss) HS50.5
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PJI-USER-ID Alpha 10 (Lower Case) HS50.5
User ID Name Contains the user ID of the person who
last changed this record.
PAJOBINTRS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PJISET1 COMPANY HR00.1 HR01.1
EMP-APP HR11.1 HS50.5
EMPLOYEE PA115 PA120
JOB-CODE PBIP.1 PR197
POSITION
PJISET2 COMPANY HR06.1 HR506
JOB-CODE PA02.1 PA302
POSITION PA502
EMP-APP
EMPLOYEE
PAJOBINTRS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When PJI-EMP-APP = 1
PJI-COMPANY -> APL-COMPANY
PJI-EMPLOYEE -> APL-APPLICANT
Employee EMPLOYEE Required
When PJI-EMP-APP = Zeroes
PJI-COMPANY -> EMP-COMPANY
PJI-EMPLOYEE -> EMP-EMPLOYEE
Job Code JOBCODE Required
When PJI-JOB-CODE != Spaces
PJI-COMPANY -> JBC-COMPANY
PJI-JOB-CODE -> JBC-JOB-CODE
PAJOBINTRS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Job Requis PAJOBREQ
Valid When PJI-JOB-CODE != Spaces
PJI-COMPANY -> PJR-COMPANY
PJI-JOB-CODE -> PJR-JOB-CODE
PJR-REQUISITION
Pos Requis PAJOBREQ
Valid When PJI-POSITION != Spaces
PJI-COMPANY -> PJR-COMPANY
PJI-POSITION -> PJR-POSITION
PJR-REQUISITION
Position PAPOSITION
Valid When PJI-POSITION != Spaces
PJI-COMPANY -> POS-COMPANY
PJI-POSITION -> POS-POSITION
POS-EFFECT-DATE
|
