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 HR511 HR54.1 HRS1.1
HRSC.1 PA02.1 PA100 PA102 PA115 PA120
PA13.1 PA13.2 PA19.1 PA33.1 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA533 PA54.1
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 HR170 HR70.1 PA233 PA241
PA231 PA219 PA311

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 HR511
HR54.1 HRS1.1
HRSC.1 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 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
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 HR511
HR54.1 HRS1.1
HRSC.1 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 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
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 HR511
HR54.1 HRS1.1
HRSC.1 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 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
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
HR511 HR54.1
HR70.1 HR90.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA19.1 PA233
PA241 PA33.1
PA502 PA513
PA52.1 PA52.3
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: Wed Jun 08 20:50:19 2016

Home
Contact Us



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