APPJOBHIST

Applicant Job History

The Applicant Job History file contains information about an applicant's previous job experience and history.

REFERENCED BY
HR90.1


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR170 HR28.1 HR511
HR54.1 HR70.1 HRS1.1 HRSC.1 LT101 ZH510
PA02.1 PA100 PA102 PA115 PA120 PA13.1
PA13.2 PA19.1 PA219 PA231 PA233 PA241
PA311 PA33.1 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PA533 PA54.1 PR110 PR113
PR12.6 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AJH-COMPANY
Element: Company Hr		Numeric 4
Contains the company number which represents an established company.
PA19.1 PA33.1
PA533
AJH-APPLICANT
Element: Applicant		Numeric 9
Contains the applicant's number. The number correlates all information about the applicant.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA19.1
PA33.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA533
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
AJH-SEQ-NBR
Element: Seq Nbr		Numeric 4
Contains a sequence number that keeps records unique. It is automatically assigned when records are created.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA19.1
PA33.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA533
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
AJH-EMPLOYER-NAME
Element: Employer Name		Alpha 30 (Lower Case)
Contains the employer's name.
PA19.1 PA33.1
PA533
AJH-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
Contains first line of the previous employer's address.
PA19.1 PA33.1
PA533
AJH-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
Contains the second line of the previous employer's address.
PA19.1 PA33.1
PA533
AJH-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
Contains the third line of the previous employer's address.
PA19.1 PA33.1
PA533
AJH-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
Contains the fourth line of the previous employer's address.
PA19.1 PA33.1
PA533
AJH-CITY
Element: City		Alpha 18 (Lower Case)
Contains the city of the previous employer's address.
PA19.1 PA33.1
PA533
AJH-STATE
Element: State		Alpha 2
Contains the state of the previous employer's address.
PA19.1 PA33.1
PA533
AJH-ZIP
Element: Zip		Alpha 10
Contains the postal code of the previous employer's address.
PA19.1 PA33.1
PA533
AJH-TITLE
Element: Title		Alpha 30 (Lower Case)
Contains the supervisor's title at the applicant's previous job.
PA19.1 PA33.1
PA533
AJH-SUP-NAME
Element: Sup Name		Alpha 30 (Lower Case)
Contains the name of the applicant's previous supervisor.
PA19.1 PA33.1
PA533
AJH-WK-PHONE-CNTRY
Element: Wk Phone Cntry		Alpha 6
Contains the prefix of the applicant's previous work telephone number.
PA19.1 PA33.1
PA533
AJH-WK-PHONE-NBR
Element: Wk Phone Nbr		Alpha 15
Contains the applicant's previous work telephone number.
PA19.1 PA33.1
PA533
AJH-WK-PHONE-EXT
Element: Wk Phone Ext		Alpha 5
Contains the extension of the applicant's previous work telephone number.
PA19.1 PA33.1
PA533
AJH-BEG-DATE
Element: Beg Date		Numeric 8 (yyyymmdd)
Contains the beginning employment date from the applicant's previous employment.
PA19.1 PA33.1
PA533
AJH-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
Contains the ending employment date from the applicant's previous employment.
PA19.1 PA33.1
PA533
AJH-BEG-PAY
Element: Salary		Signed 11.2
Contains the applicant's beginning salary from the previous employment.
PA19.1 PA33.1
PA533
AJH-END-PAY
Element: Salary		Signed 11.2
Contains the applicant's ending salary from the previous employment.
PA19.1 PA33.1
PA533
AJH-JOB-CODE
Element: Job Code		Alpha 9
Contains the job code in this company that most closely resembles the employee's previous job.
PA19.1 PA33.1
PA533
AJH-CUR-EMPR-FLAG
Element: Cur Empr Flag		Alpha 1
Indicates whether the employer is the applicant's current employer.
N = Not Current Employer
Y = Current Employer
PA19.1 PA33.1
PA533
AJH-CONTACT-FLAG
Element: Contact Flag		Alpha 1
Indicates whether the previous employer has been contacted.
N = Not Contacted
Y = Contacted
PA19.1 PA33.1
PA533
AJH-CAN-CALL-FLAG
Element: Can Call Flag		Alpha 1
Indicates whether the previous employer can be contacted.
N = Do Not Contact
Y = Can Be Contacted
PA19.1 PA33.1
PA533
AJH-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.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA19.1
PA33.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA533
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
AJH-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.
PA19.1 PA33.1
PA533
AJH-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA19.1 PA33.1
PA533
AJH-USER-ID
Element: User		Alpha 10 (Lower Case)
PA19.1 PA33.1
PA533
AJH-CURRENCY-CODE
Element: Currency Code		Alpha 5
Contains the currency in which the applicant pay was recorded.
PA19.1 PA33.1
PA533
AJH-CURR-ND
Element: Acct Nd		Numeric 1
Contains the number of decimals for the currency.
PA19.1 PA33.1
PA533
AJH-COUNTRY-CODE
Element: Country Code		Alpha 2
Contains the country of the applicant's address.
PA19.1 PA33.1
PA533
AJH-BASE-BEG-PAY
Element: Salary		Signed 11.2
The applicant's beginning base pay.
PA19.1 PA33.1
PA533
AJH-BASE-END-PAY
Element: Salary		Signed 11.2
Contains the applicant's ending base pay.
PA19.1 PA33.1
PA533
AJH-BASE-CURRENCY
Element: Base Currency		Alpha 5
The company base currency.
PA19.1 PA33.1
PA533
AJH-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
PA19.1 PA33.1
PA533


APPJOBHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AJHSET1 COMPANY
APPLICANT
EMPLOYEE
SEQ-NBR
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR170
HR28.1 HR511
HR54.1 HR70.1
HR90.1 HRS1.1
HRSC.1 LT101
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA19.1
PA233 PA241
PA33.1 PA502
AJHSET2 COMPANY
APPLICANT
EMPLOYEE
EMPLOYER-NAME
SEQ-NBR
KeyChange
PA120 PA231
AJHSET3 COMPANY
EMPLOYEE
SEQ-NBR
APPLICANT
Subset
WhereEMPLOYEE !=Zeroes
HR11.1 HR90.1
PA115 PA19.1
PA219 PA311


APPJOBHIST FILE RELATIONS


ONE TO ONE RELATIONS

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

File created: Thu Jun 09 11:21:52 2016

Home
Contact Us



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