APPJOBHIST – Applicant Job History

System: Personnel (PA)
Prefix: AJH
Primary key: COMPANY, APPLICANT, EMPLOYEE, SEQ-NBR
Fields: 35
Updated by: 46 programs
Referenced by: 8 programs

APPJOBHIST is the Applicant Job History table in Lawson Personnel (prefix AJH). It is indexed by COMPANY, APPLICANT, EMPLOYEE, SEQ-NBR (AJHSET1); alternate indexes: AJHSET2 and AJHSET3. It is related 1:1 to APPLICANT, CUCODES, PRSYSTEM, INSTCTRYCD, EMPLOYEE, JOBCODE and PAEMPLOYEE and 1:M to PACOMMENTS. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 38 more and referenced by HR170, HR70.1, HR90.1, PA219, PA231, PA233, PA241 and PA311. The table has 35 fields, 3 indexes and 10 documented relations.

About APPJOBHIST

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

Fields (35)

Column = COBOL field name without the AJH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`AJH-COMPANY` PK COMPANY	Numeric 4	Contains the company number which represents an established company.	PA19.1, PA33.1, PA533
#`AJH-APPLICANT` PK 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 +37 more
#`AJH-SEQ-NBR` PK 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 +37 more
#`AJH-EMPLOYER-NAME` SET2 EMPLOYER_NAME	Alpha 30 (Lower Case)	Contains the employer's name.	PA19.1, PA33.1, PA533
#`AJH-ADDR1` ADDR1	Alpha 30 (Lower Case)	Contains first line of the previous employer's address.	PA19.1, PA33.1, PA533
#`AJH-ADDR2` ADDR2	Alpha 30 (Lower Case)	Contains the second line of the previous employer's address.	PA19.1, PA33.1, PA533
#`AJH-ADDR3` ADDR3	Alpha 30 (Lower Case)	Contains the third line of the previous employer's address.	PA19.1, PA33.1, PA533
#`AJH-ADDR4` ADDR4	Alpha 30 (Lower Case)	Contains the fourth line of the previous employer's address.	PA19.1, PA33.1, PA533
#`AJH-CITY` CITY	Alpha 58 (Lower Case)	Contains the city of the previous employer's address.	PA19.1, PA33.1, PA533
#`AJH-STATE` STATE	Alpha 2	Contains the state of the previous employer's address.	PA19.1, PA33.1, PA533
#`AJH-ZIP` ZIP	Alpha 10	Contains the postal code of the previous employer's address.	PA19.1, PA33.1, PA533
#`AJH-TITLE` TITLE	Alpha 30 (Lower Case)	Contains the supervisor's title at the applicant's previous job.	PA19.1, PA33.1, PA533
#`AJH-SUP-NAME` SUP_NAME	Alpha 30 (Lower Case)	Contains the name of the applicant's previous supervisor.	PA19.1, PA33.1, PA533
#`AJH-WK-PHONE-CNTRY` 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` WK_PHONE_NBR	Alpha 15	Contains the applicant's previous work telephone number.	PA19.1, PA33.1, PA533
#`AJH-WK-PHONE-EXT` WK_PHONE_EXT	Alpha 5	Contains the extension of the applicant's previous work telephone number.	PA19.1, PA33.1, PA533
#`AJH-BEG-DATE` BEG_DATE	Numeric 8 (yyyymmdd)	Contains the beginning employment date from the applicant's previous employment.	PA19.1, PA33.1, PA533
#`AJH-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	Contains the ending employment date from the applicant's previous employment.	PA19.1, PA33.1, PA533
#`AJH-BEG-PAY` BEG_PAY	Signed 11.2	Contains the applicant's beginning salary from the previous employment.	PA19.1, PA33.1, PA533
#`AJH-END-PAY` END_PAY	Signed 11.2	Contains the applicant's ending salary from the previous employment.	PA19.1, PA33.1, PA533
#`AJH-JOB-CODE` 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` 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` 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` 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` PK 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 +37 more
#`AJH-DATE-STAMP` 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` 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` USER_ID	Alpha 10 (Lower Case)	—	PA19.1, PA33.1, PA533
#`AJH-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Contains the currency in which the applicant pay was recorded.	PA19.1, PA33.1, PA533
#`AJH-CURR-ND` CURR_ND	Numeric 1	Contains the number of decimals for the currency.	PA19.1, PA33.1, PA533
#`AJH-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	Contains the country of the applicant's address.	PA19.1, PA33.1, PA533
#`AJH-BASE-BEG-PAY` BASE_BEG_PAY	Signed 11.2	The applicant's beginning base pay.	PA19.1, PA33.1, PA533
#`AJH-BASE-END-PAY` BASE_END_PAY	Signed 11.2	Contains the applicant's ending base pay.	PA19.1, PA33.1, PA533
#`AJH-BASE-CURRENCY` BASE_CURRENCY	Alpha 5	The company base currency.	PA19.1, PA33.1, PA533
#`AJH-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	PA19.1, PA33.1, PA533

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`AJHSET1`	`COMPANY` `APPLICANT` `EMPLOYEE` `SEQ-NBR`	Primary		BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
`AJHSET2`	`COMPANY` `APPLICANT` `EMPLOYEE` `EMPLOYER-NAME` `SEQ-NBR`	KeyChange		PA120, PA231
`AJHSET3`	`COMPANY` `EMPLOYEE` `SEQ-NBR` `APPLICANT`	Subset	Where EMPLOYEE != Zeroes	HR11.1, HR90.1, PA115, PA19.1, PA219, PA311

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (8) — lookups and parents

Relation Table Rules Condition Field map

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`

One to many (2) — child tables

Relation Table Rules Condition Field map

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`
—	→	`PAC-DATE`

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`
—	→	`PAC-DATE`

Programs

Updated by (46)

BN305 Highly Compensated Employees
HAP3.1 Applicant Option 4 Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR54.1 Employee History Correction
HRS1.1 Select Control
HRSC.1 Select Control
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA120 Applicant Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA19.1 Prior Work History
PA33.1 Applicant Job History
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA533 Job History Conversion
PA54.1 Personnel Action History Correction
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP

Referenced by (8)

HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
HR90.1 Comments
PA219 Prior Work History Listing
PA231 Applicant Profile
PA233 Applicant Job History Listing
PA241 Interview Listing
PA311 Employee Profile

APPJOBHIST – Applicant Job History

About APPJOBHIST

Fields (35) Copy as SQL

Indexes (3)

Relations

One to one (8) — lookups and parents

One to many (2) — child tables

Programs

Updated by (46)

Referenced by (8)

Fields (35)