|
|
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
HGLM.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 Contains the company number which PA533
represents an established company.
AJH-APPLICANT Numeric 9 HGLM.1 HPOS.1
Element: Applicant Contains the applicant's number. The HPQC.1 HPRS.1
number correlates all information about HR54.1 HRS1.1
the applicant. 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 HGLM.1 HPOS.1
Element: Sequence NumbeContains a sequence number that keeps HPQC.1 HPRS.1
records unique. It is automatically HR54.1 HRS1.1
assigned when records are created. 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: Date Contains the beginning employment date PA533
from the applicant's previous
employment.
AJH-END-DATE Numeric 8 (yyyymmdd) PA19.1 PA33.1
Element: Date Contains the ending employment date PA533
from the applicant's previous
employment.
AJH-BEG-PAY Signed 11.2 PA19.1 PA33.1
Element: Beginning Pay Contains the applicant's beginning PA533
salary from the previous employment.
AJH-END-PAY Signed 11.2 PA19.1 PA33.1
Element: Ending Pay 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 HGLM.1 HPOS.1
Element: Employee Contains the employee number. Each HPQC.1 HPRS.1
person employed by the company is HR54.1 HRS1.1
assigned a unique number. The system HRSC.1 PA100
uses the employee number to correlate PA102 PA19.1
all of the information related to that PA33.1 PA52.1
person. 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 PA533
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: Base Beg Pay The applicant's beginning base pay. PA533
AJH-BASE-END-PAY Signed 11.2 PA19.1 PA33.1
Element: Base End Pay Contains the applicant's ending base PA533
pay.
AJH-BASE-CURRENCY Alpha 5 PA19.1 PA33.1
To Company Base PA533
Currency
AJH-BASE-ND Numeric 1 PA19.1 PA33.1
Account Currency PA533
Code
APPJOBHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AJHSET1 COMPANY HGLM.1 HPOS.1
APPLICANT HPQC.1 HPRS.1
EMPLOYEE HR170 HR54.1
SEQ-NBR 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
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
|
