|
|
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
HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR54.1
HRS1.1 HRSC.1 PA100 PA102 PA120 PA19.1
PA33.1 PA52.1 PA52.3 PA52.4 PA52.5 PA533
PA54.1 PRSC.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AJH-COMPANY Numeric 4 PA19.1 PA33.1
Element: Company Hr Contains the company number which PA533
represents an established company.
AJH-APPLICANT Numeric 9 HAP3.1 HEP4.1
Element: Applicant Contains the applicant's number. The HPOS.1 HPQC.1
number correlates all information about HPRS.1 HR54.1
the applicant. HRS1.1 HRSC.1
PA100 PA102
PA19.1 PA33.1
PA52.1 PA52.3
PA52.4 PA52.5
PA533 PA54.1
PRSC.1
AJH-SEQ-NBR Numeric 4 HAP3.1 HEP4.1
Element: Sequence NumbeContains a sequence number that keeps HPOS.1 HPQC.1
records unique. It is automatically HPRS.1 HR54.1
assigned when records are created. HRS1.1 HRSC.1
PA100 PA102
PA19.1 PA33.1
PA52.1 PA52.3
PA52.4 PA52.5
PA533 PA54.1
PRSC.1
AJH-EMPLOYER-NAME Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Employer Name Contains the employer's name. PA533
AJH-ADDR1 Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Address 1 Contains first line of the previous PA533
employer's address.
AJH-ADDR2 Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Address 1 Contains the second line of the PA533
previous employer's address.
AJH-ADDR3 Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Address 1 Contains the third line of the previous PA533
employer's address.
AJH-ADDR4 Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Address 1 Contains the fourth line of the PA533
previous employer's address.
AJH-CITY Alpha 18 (Lower Case) PA19.1 PA33.1
Element: City Contains the city of the previous PA533
employer's address.
AJH-STATE Alpha 2 PA19.1 PA33.1
Element: State or ProviContains the state of the previous PA533
employer's address.
AJH-ZIP Alpha 10 PA19.1 PA33.1
Element: Postal Code Contains the postal code of the PA533
previous employer's address.
AJH-TITLE Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Title Contains the supervisor's title at the PA533
applicant's previous job.
AJH-SUP-NAME Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Supervisor's NContains 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
Element: Work TelephoneContains 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
Element: Beginning DateContains the beginning employment date PA533
from the applicant's previous
employment.
AJH-END-DATE Numeric 8 (yyyymmdd) PA19.1 PA33.1
Element: Ending Date Contains the ending employment date PA533
from the applicant's previous
employment.
AJH-BEG-PAY Signed 11.2 PA19.1 PA33.1
Element: Salary Contains the applicant's beginning PA533
salary from the previous employment.
AJH-END-PAY Signed 11.2 PA19.1 PA33.1
Element: Salary Contains the applicant's ending salary PA533
from the previous employment.
AJH-JOB-CODE Alpha 9 PA19.1 PA33.1
Element: 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
Element: Current EmployIndicates 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
Element: 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
Element: Can Call Indicates whether the previous employer PA533
can be contacted.
N = Do Not Contact
Y = Can Be Contacted
AJH-EMPLOYEE Numeric 9 HAP3.1 HEP4.1
Element: Employee Contains the employee number. Each HPOS.1 HPQC.1
person employed by the company is HPRS.1 HR54.1
assigned a unique number. The system HRS1.1 HRSC.1
uses the employee number to correlate PA100 PA102
all of the information related to that PA19.1 PA33.1
person. PA52.1 PA52.3
PA52.4 PA52.5
PA533 PA54.1
PRSC.1
AJH-DATE-STAMP Numeric 8 (yyyymmdd) PA19.1 PA33.1
Element: 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
Element: 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
Element: User Contains the user ID of the person who PA533
last changed this record.
AJH-CURRENCY-CODE Alpha 5 PA19.1 PA33.1
Element: Currency Code Contains the currency in which the PA533
applicant pay was recorded.
AJH-CURR-ND Numeric 1 PA19.1 PA33.1
Account Currency Contains the number of decimals for the PA533
Code currency.
AJH-COUNTRY-CODE Alpha 2 PA19.1 PA33.1
Element: Country Code Contains the country of the applicant's PA533
address.
AJH-BASE-BEG-PAY Signed 11.2 PA19.1 PA33.1
Element: Salary The applicant's beginning base pay. PA533
AJH-BASE-END-PAY Signed 11.2 PA19.1 PA33.1
Element: Salary Contains the applicant's ending base PA533
pay.
AJH-BASE-CURRENCY Alpha 5 PA19.1 PA33.1
Element: 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 HAP3.1 HEP4.1
APPLICANT HPOS.1 HPQC.1
EMPLOYEE HPRS.1 HR170
SEQ-NBR HR54.1 HR70.1
HR90.1 HRS1.1
HRSC.1 PA100
PA102 PA19.1
PA233 PA241
PA33.1 PA52.1
PA52.3 PA52.4
PA52.5 PA533
PA54.1 PRSC.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
Paemployee PAEMPLOYEE Required
When AJH-EMPLOYEE != Zeroes
AJH-COMPANY -> PEM-COMPANY
AJH-EMPLOYEE -> PEM-EMPLOYEE
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
|
