PAJOBINTRS

Employee Job Interest
UPDATED BY
HS50.5 HR00.1 HR01.1 HR11.1 PA115 PA120
HR06.1 HR506 LT101 LT111 PA02.1 PA302
PA502

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PJI-COMPANY
Element: Company Hr
Numeric 4
HS50.5
PJI-EMP-APP
Element: Emp App
Numeric 1
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.
HS50.5
PJI-EMPLOYEE
Element: Employee
Numeric 9
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.
HS50.5
PJI-JOB-CODE
Element: Job Code
Alpha 9
Contains a user-defined code that represents a type of job.
HS50.5
PJI-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
HS50.5
PJI-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
HS50.5
PJI-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HS50.5
PJI-USER-ID
Element: User
Alpha 10 (Lower Case)
HS50.5


PAJOBINTRS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PJISET1 COMPANY
EMP-APP
EMPLOYEE
JOB-CODE
POSITION
HR00.1 HR01.1
HR11.1 HS50.5
PA115 PA120
PJISET2 COMPANY
JOB-CODE
POSITION
EMP-APP
EMPLOYEE
HR06.1 HR506
LT101 LT111
PA02.1 PA302
PA502


PAJOBINTRS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Paemployee PAEMPLOYEE Required
PJI-COMPANY->PEM-COMPANY
PJI-EMPLOYEE->PEM-EMPLOYEE


PAJOBINTRS FILE RELATIONS


ONE TO MANY RELATIONS

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


File created: Thu Jun 09 02:24:59 2016

Home
Contact Us



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