|
|
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 HR700 HRS1.1 HRSC.1 PA100 PA102
PA115 PA120 PA19.1 PA33.1 PA52.1 PA52.3
PA52.4 PA52.5 PA533 PA54.1 HR11.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 HR700
Applicant Contains the applicant's number. The HRS1.1 HRSC.1
number correlates all information about PA100 PA102
the applicant. PA19.1 PA33.1
PA52.1 PA52.3
PA52.4 PA52.5
PA533 PA54.1
AJH-SEQ-NBR Numeric 4 HR54.1 HR700
Sequence Number Contains a sequence number that keeps HRS1.1 HRSC.1
records unique. It is automatically PA100 PA102
assigned when records are created. PA19.1 PA33.1
PA52.1 PA52.3
PA52.4 PA52.5
PA533 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-COUNTRY Alpha 30 (Lower Case)
Country or Other This field contains the country of the
address, or it can be used for
additional information such as an
attention name.
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 HR700
Employee Contains the employee number. Each HRS1.1 HRSC.1
person employed by the company is PA100 PA102
assigned a unique number. The system PA19.1 PA33.1
uses the employee number to correlate PA52.1 PA52.3
all of the information related to that PA52.4 PA52.5
person. PA533 PA54.1
AJH-DATE-STAMP Numeric 8 (yyyymmdd) PA19.1 PA33.1
Date Stamp Contains the server date (month, date, PA533
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 HR700 PA19.1
Currency Code Contains the currency in which the PA33.1 PA533
applicant pay was recorded.
AJH-CURR-ND Numeric 1 HR700 PA19.1
Currency Number of Contains the number of decimals for the PA33.1 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 HR700 PA19.1
Base Beg Pay The applicant's beginning base pay. PA33.1 PA533
AJH-BASE-END-PAY Signed 11.2 HR700 PA19.1
Base End Pay Contains the applicant's ending base PA33.1 PA533
pay.
AJH-BASE-CURRENCY Alpha 5 HR700 PA19.1
Base Currency The company base currency. PA33.1 PA533
AJH-BASE-ND Numeric 1 HR700 PA19.1
Base Number Of The number of decimal positions defined PA33.1 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 HR700
EMPLOYEE HR90.1 HRS1.1
SEQ-NBR HRSC.1 PA100
PA102 PA19.1
PA233 PA241
PA33.1 PA52.1
PA52.3 PA52.4
PA52.5 PA533
PA54.1
AJHSET2 COMPANY KeyChange PA120 PA231
APPLICANT
EMPLOYEE
EMPLOYER-NAME
SEQ-NBR
AJHSET3 COMPANY Subset HR11.1 HR90.1
EMPLOYEE Where EMPLOYEE != Zeroes PA115 PA19.1
SEQ-NBR PA219 PA311
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
|