Lawson Insight Technical Documentation |
|
APPJOBHIST
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
BN305 HAP3.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
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 BN305 HAP3.1
Element: Applicant Contains the applicant's number. The HEP4.1 HPOS.1
number correlates all information about HPQC.1 HPRS.1
the applicant. 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
AJH-SEQ-NBR Numeric 4 BN305 HAP3.1
Element: Seq Nbr Contains a sequence number that keeps HEP4.1 HPOS.1
records unique. It is automatically HPQC.1 HPRS.1
assigned when records are created. 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
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: Addr1 Contains first line of the previous PA533
employer's address.
AJH-ADDR2 Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Addr1 Contains the second line of the PA533
previous employer's address.
AJH-ADDR3 Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Addr1 Contains the third line of the previous PA533
employer's address.
AJH-ADDR4 Alpha 30 (Lower Case) PA19.1 PA33.1
Element: Addr1 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 Contains the state of the previous PA533
employer's address.
AJH-ZIP Alpha 10 PA19.1 PA33.1
Element: Zip 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: Sup Name Contains the name of the applicant's PA533
previous supervisor.
AJH-WK-PHONE-CNTRY Alpha 6 PA19.1 PA33.1
Element: Wk Phone CntryContains the prefix of the applicant's PA533
previous work telephone number.
AJH-WK-PHONE-NBR Alpha 15 PA19.1 PA33.1
Element: Wk Phone Nbr Contains the applicant's previous work PA533
telephone number.
AJH-WK-PHONE-EXT Alpha 5 PA19.1 PA33.1
Element: Wk Phone Ext Contains the extension of the PA533
applicant's previous work telephone
number.
AJH-BEG-DATE Numeric 8 (yyyymmdd) PA19.1 PA33.1
Element: Beg Date Contains the beginning employment date PA533
from the applicant's previous
employment.
AJH-END-DATE Numeric 8 (yyyymmdd) PA19.1 PA33.1
Element: End 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: Cur Empr Flag 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
Element: Contact Flag 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 Flag Indicates whether the previous employer PA533
can be contacted.
N = Do Not Contact
Y = Can Be Contacted
AJH-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number. Each HEP4.1 HPOS.1
person employed by the company is HPQC.1 HPRS.1
assigned a unique number. The system HR11.1 HR11.2
uses the employee number to correlate HR511 HR54.1
all of the information related to that HRS1.1 HRSC.1
person. 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
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
Element: Acct Nd Contains the number of decimals for the PA533
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
Element: Base Nd The number of decimal positions defined PA533
for the company base currency.
APPJOBHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AJHSET1 COMPANY BN305 HAP3.1
APPLICANT HEP4.1 HPOS.1
EMPLOYEE HPQC.1 HPRS.1
SEQ-NBR 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 PA52.4
...
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
|