APPJOBHIST FILE
Applicant Job History
The Applicant Job History file contains information about an applicant's
previous job experience and history.
REFERENCED BY
HR170 HR70.1 HR90.1 PA233 PA241 PA231
PA219 PA311
UPDATED BY
HR54.1 HRS1.1 HRSC.1 PA120 PA19.1 PA33.1
PA533 PA54.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AJH-COMPANY Numeric 4 PA19.1 PA33.1
Company Contains the company number which PA533
represents an established company.
AJH-APPLICANT Numeric 9 HR54.1 HRS1.1
Applicant Contains the applicant's number. The HRSC.1 PA19.1
number correlates all information about PA33.1 PA533
the applicant. PA54.1
AJH-SEQ-NBR Numeric 4 HR54.1 HRS1.1
Sequence Number Contains a sequence number that keeps HRSC.1 PA19.1
records unique. It is automatically PA33.1 PA533
assigned when records are created. PA54.1
AJH-EMPLOYER-NAME Alpha 30 (Lower Case) PA19.1 PA33.1
Employer Name Contains the employer's name. PA533
AJH-ADDR1 Alpha 30 (Lower Case) PA19.1 PA33.1
Address 1 Contains first line of the previous PA533
employer's address.
AJH-ADDR2 Alpha 30 (Lower Case) PA19.1 PA33.1
Address 2 Contains the second line of the PA533
previous employer's address.
AJH-ADDR3 Alpha 30 (Lower Case) PA19.1 PA33.1
Address 3 Contains the third line of the previous PA533
employer's address.
AJH-ADDR4 Alpha 30 (Lower Case) PA19.1 PA33.1
Address 4 Contains the fourth line of the PA533
previous employer's address.
AJH-CITY Alpha 18 (Lower Case) PA19.1 PA33.1
City Contains the city of the previous PA533
employer's address.
AJH-STATE Alpha 2 PA19.1 PA33.1
State or Province Contains the state of the previous PA533
employer's address.
AJH-ZIP Alpha 10 PA19.1 PA33.1
Postal Code Contains the postal code of the PA533
previous employer's address.
AJH-TITLE Alpha 30 (Lower Case) PA19.1 PA33.1
Title Contains the supervisor's title at the PA533
applicant's previous job.
AJH-SUP-NAME Alpha 30 (Lower Case) PA19.1 PA33.1
Supervisor's Name Contains the name of the applicant's PA533
previous supervisor.
AJH-WK-PHONE-CNTRY Alpha 6 PA19.1 PA33.1
Work Telephone Contains the prefix of the applicant's PA533
Country previous work telephone number.
AJH-WK-PHONE-NBR Alpha 15 PA19.1 PA33.1
Work Telephone Contains the applicant's previous work PA533
telephone number.
AJH-WK-PHONE-EXT Alpha 5 PA19.1 PA33.1
Work Telephone Contains the extension of the PA533
Extension applicant's previous work telephone
number.
AJH-BEG-DATE Numeric 8 (yyyymmdd) PA19.1 PA33.1
Beginning Date Contains the beginning employment date PA533
from the applicant's previous
employment.
AJH-END-DATE Numeric 8 (yyyymmdd) PA19.1 PA33.1
Ending Date Contains the ending employment date PA533
from the applicant's previous
employment.
AJH-BEG-PAY Signed 11.2 PA19.1 PA33.1
Beginning Pay Contains the applicant's beginning PA533
salary from the previous employment.
AJH-END-PAY Signed 11.2 PA19.1 PA33.1
Ending Pay Contains the applicant's ending salary PA533
from the previous employment.
AJH-JOB-CODE Alpha 9 PA19.1 PA33.1
Job Code Contains the job code in this company PA533
that most closely resembles the
employee's previous job.
AJH-CUR-EMPR-FLAG Alpha 1 PA19.1 PA33.1
Current Employer Indicates whether the employer is the PA533
applicant's current employer.
N = Not Current Employer
Y = Current Employer
AJH-CONTACT-FLAG Alpha 1 PA19.1 PA33.1
Contacted Indicates whether the previous employer PA533
has been contacted.
N = Not Contacted
Y = Contacted
AJH-CAN-CALL-FLAG Alpha 1 PA19.1 PA33.1
Can Call Indicates whether the previous employer PA533
can be contacted.
N = Do Not Contact
Y = Can Be Contacted
AJH-EMPLOYEE Numeric 9 HR54.1 HRS1.1
Employee Contains the employee number. Each HRSC.1 PA19.1
person employed by the company is PA33.1 PA533
assigned a unique number. The system PA54.1
uses the employee number to correlate
all of the information related to that
person.
AJH-DATE-STAMP Numeric 8 (yyyymmdd) PA19.1 PA33.1
Date Stamp This field contains the server date PA533
(month, date, and year) of the last
change to this record.
AJH-TIME-STAMP Numeric 6 (hhmmss) PA19.1 PA33.1
Time Stamp Contains the server time (hour, minute, PA533
and second) when the record was last
changed.
AJH-USER-ID Alpha 10 (Lower Case) PA19.1 PA33.1
User ID Name Contains the user ID of the person who PA533
last changed this record.
AJH-CURRENCY-CODE Alpha 5 PA19.1 PA33.1
Currency Code Contains the currency in which the PA533
applicant pay was recorded.
AJH-CURR-ND Numeric 1 PA19.1 PA33.1
Currency Number of Contains the number of decimals for the PA533
Decimals currency.
AJH-COUNTRY-CODE Alpha 2 PA19.1 PA33.1
Country Code Contains the country of the applicant's PA533
address.
AJH-BASE-BEG-PAY Signed 11.2 PA19.1 PA33.1
Base Beg Pay The applicant's beginning base pay. PA533
AJH-BASE-END-PAY Signed 11.2 PA19.1 PA33.1
Base End Pay Contains the applicant's ending base PA533
pay.
AJH-BASE-CURRENCY Alpha 5 PA19.1 PA33.1
Base Currency The company base currency. PA533
AJH-BASE-ND Numeric 1 PA19.1 PA33.1
Base Number Of The number of decimal positions defined PA533
Decimals for the company base currency.
APPJOBHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AJHSET1 COMPANY HR170 HR54.1
APPLICANT HR70.1 HR90.1
EMPLOYEE HRS1.1 HRSC.1
SEQ-NBR PA19.1 PA233
PA241 PA33.1
PA533 PA54.1
AJHSET2 COMPANY KeyChange PA120 PA231
APPLICANT
EMPLOYEE
EMPLOYER-NAME
SEQ-NBR
AJHSET3 COMPANY Subset HR90.1 PA19.1
EMPLOYEE Where EMPLOYEE != Zeroes PA219 PA311
SEQ-NBR
APPLICANT
APPJOBHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When AJH-APPLICANT != Zeroes
AJH-COMPANY -> APL-COMPANY
AJH-APPLICANT -> APL-APPLICANT
Base Currency CUCODES Required
When (AJH-CURRENCY-CODE != Spaces )
AJH-BASE-CURRENCY -> CUC-CURRENCY-CODE
Company PRSYSTEM Required
AJH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (AJH-COUNTRY-CODE != Spaces )
AJH-COUNTRY-CODE -> INT-COUNTRY-CODE
Currency CUCODES Required
When (AJH-CURRENCY-CODE != Spaces )
AJH-CURRENCY-CODE -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
When AJH-EMPLOYEE != Zeroes
AJH-COMPANY -> EMP-COMPANY
AJH-EMPLOYEE -> EMP-EMPLOYEE
Job Code JOBCODE Required
When AJH-JOB-CODE != Spaces
AJH-COMPANY -> JBC-COMPANY
AJH-JOB-CODE -> JBC-JOB-CODE
APPJOBHIST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Comments PACOMMENTS Delete Cascades
Valid When AJH-APPLICANT != Zeroes
AJH-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"JH" -> PAC-CMT-TYPE
AJH-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
AJH-SEQ-NBR -> PAC-LN-NBR
PAC-SEQ-NBR
Emp Comments PACOMMENTS Delete Cascades
Valid When AJH-EMPLOYEE != Zeroes
AJH-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"JH" -> PAC-CMT-TYPE
AJH-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
AJH-SEQ-NBR -> PAC-LN-NBR
PAC-SEQ-NBR
|
