APPLICANT – Applicant

System: Personnel (PA)
Prefix: APL
Primary key: COMPANY, APPLICANT
Fields: 188
Updated by: 26 programs
Referenced by: 114 programs

APPLICANT is the Applicant table in Lawson Personnel (prefix APL). It is indexed by COMPANY, APPLICANT (APLSET1); alternate indexes: APLSET2, APLSET3, APLSET4 and APLSET5. It is related 1:1 to EMSTATUS, CUCODES, PRSYSTEM, INSTCTRYCD, PCODES, EMPLOYEE, JOBCODE, PAEMPAPP and 1 more and 1:M to PACOMMENTS, EMPCODES, HRCORRESP, APPJOBHIST, HRCTRYCODE, HISTERR, HRHISTORY, INTERVIEW and 10 more. It is updated by HR21.1, HR90.1, LT101, LT111, PA100, PA120, PA20.1, PA21.1 and 18 more and referenced by BN305, HAP2.1, HAP3.1, HAPL.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1 and 106 more. The table has 188 fields, 5 indexes and 60 documented relations.

About APPLICANT

The Applicant file contains information on applicants.

Fields (188)

Column = COBOL field name without the APL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`APL-COMPANY` PK COMPANY	Numeric 4	Contains the company number which represents an established company.	LT101, LT111, PA100, PA28.1, PA31.1, PA39.1, PA40.1, PA52.4 +1 more
`APL-APPLICANT` PK APPLICANT	Numeric 9	Contains the applicant's number. The number correlates all information about the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA39.1, PA40.1, PA52.4 +1 more
`APL-LAST-NAME` LAST_NAME	Alpha 30 (Lower Case)	Contains the applicant's last name.	LT101, LT111, PA100, PA28.1, PA31.1, PA43.1, PA52.4, PA531
`APL-FIRST-NAME` FIRST_NAME	Alpha 15 (Lower Case)	Contains the applicant's first name.	LT101, LT111, PA100, PA28.1, PA31.1, PA43.1, PA52.4, PA531
`APL-MIDDLE-NAME` MIDDLE_NAME	Alpha 15 (Lower Case)	Contains the applicant's middle name.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-MIDDLE-INIT` MIDDLE_INIT	Alpha 1	Contains the applicant's middle initial.	LT101, LT111, PA100, PA28.1, PA31.1, PA43.1, PA52.4, PA531
`APL-NICK-NAME` NICK_NAME	Alpha 30 (Lower Case)	Contains the applicant's nickname.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-ADDR1` ADDR1	Alpha 30 (Lower Case)	Contains the first line of the applicant's address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-ADDR2` ADDR2	Alpha 30 (Lower Case)	Contains the second line of the applicant's address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-ADDR3` ADDR3	Alpha 30 (Lower Case)	Contains the third line of the applicant's address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-ADDR4` ADDR4	Alpha 30 (Lower Case)	Contains the fourth line of the applicant's address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-CITY` CITY	Alpha 58 (Lower Case)	Contains the city of the applicant's address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-STATE` STATE	Alpha 2	Contains the state of the applicant's address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-ZIP` ZIP	Alpha 10	Contains the postal code of the applicant's address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-HM-PHONE-CNTRY` HM_PHONE_CNTRY	Alpha 6	Contains the prefix of the applicant's home telephone.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-HM-PHONE-NBR` HM_PHONE_NBR	Alpha 15	Contains the applicant's home telephone number.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-WK-PHONE-CNTRY` WK_PHONE_CNTRY	Alpha 6	Contains the prefix of the applicant's work telephone number.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-WK-PHONE-NBR` WK_PHONE_NBR	Alpha 15	Contains the applicant's work telephone number.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-WK-PHONE-EXT` WK_PHONE_EXT	Alpha 5	Contains the extension of the applicant's work telephone number.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-FAX-COUNTRY` FAX_COUNTRY	Alpha 6	Contains the prefix of the fax number. For example, the country or city code.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-FAX-NBR` FAX_NBR	Alpha 15	Contains the applicant's fax telephone number.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-FAX-EXT` FAX_EXT	Alpha 5	This field contains the telephone extension number.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-DATE-HIRED` DATE_HIRED	Numeric 8 (yyyymmdd)	Contains the date the applicant was hired.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-APP-STATUS` APP_STATUS	Alpha 2	Contains the applicant's status.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-FICA-NBR` FICA_NBR	Alpha 20	Contains the applicant's Social Security number.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-DATE-APPLIED` DATE_APPLIED	Numeric 8 (yyyymmdd)	Contains the date the applicant applied.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-HIRE-SOURCE` HIRE_SOURCE	Alpha 10	Indicates how the applicant found out about job. This must be valid in the Human Resource Codes file.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-REF-LST-NAME` REF_LST_NAME	Alpha 30 (Lower Case)	Contains the last name of the employee who referred the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-REF-FST-NAME` REF_FST_NAME	Alpha 15 (Lower Case)	Contains the first name of the employee who referred the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-REF-MID-INIT` REF_MID_INIT	Alpha 1	Contains the middle initial of the employee who referred the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-FINDERS-FEE` FINDERS_FEE	Numeric 10	Contains the finders fee.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-APPLY` PREV_APPLY	Alpha 1	Indicates whether the applicant previously applied with company. `N` No `Y` Yes	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-LOCATION` PREV_LOCATION	Alpha 30 (Lower Case)	Contains the location to which the applicant previously applied.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-DATE` PREV_DATE	Numeric 8 (yyyymmdd)	Contains the date the applicant previously applied.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-EMPLOY` PREV_EMPLOY	Alpha 1	Indicates whether the applicant previously worked for the company. `N` No `Y` Yes	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-EMP-NBR` PREV_EMP_NBR	Numeric 9	Contains the applicant's previous employee number.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-LOC-WORK` PREV_LOC_WORK	Alpha 30 (Lower Case)	Contains the applicant's previous work location.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-BEG-DATE` PREV_BEG_DATE	Numeric 8 (yyyymmdd)	Contains the beginning date of the applicant's previous employment.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-END-DATE` PREV_END_DATE	Numeric 8 (yyyymmdd)	Contains the ending date of the applicant's previous employment.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-RATING` RATING	Alpha 10	Contains applicant rating codes.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-FORMER-LST-NM` FORMER_LST_NM	Alpha 30 (Lower Case)	Contains the former last name of the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-FORMER-FST-NM` FORMER_FST_NM	Alpha 15 (Lower Case)	Contains the former first name of the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-FORMER-MI` FORMER_MI	Alpha 1	Contains the former middle initial of the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-ADDR1` PREV_ADDR1	Alpha 30 (Lower Case)	Contains the first line of the applicant's previous address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-ADDR2` PREV_ADDR2	Alpha 30 (Lower Case)	Contains the second line of the applicant's previous address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-ADDR3` PREV_ADDR3	Alpha 30 (Lower Case)	Contains the third line of the applicant's previous address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-ADDR4` PREV_ADDR4	Alpha 30 (Lower Case)	Contains the fourth line of the applicant's previous address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-CITY` PREV_CITY	Alpha 58 (Lower Case)	Contains the city of the applicant's previous address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-STATE` PREV_STATE	Alpha 2	Contains the state of the applicant's previous address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-ZIP` PREV_ZIP	Alpha 10	Contains the postal code of the applicant's previous address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PREV-CNTRY-CD` PREV_CNTRY_CD	Alpha 2	Contains the country code for the applicant's previous address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-EEO-CLASS` EEO_CLASS	Alpha 4 (Lower Case)	Contains the applicant's EEO-class.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-SEX` SEX	Alpha 1	Contains the applicant's sex. `F` Female `M` Male `X` Not Disclosed	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-AGE-FLAG` AGE_FLAG	Alpha 1	Indicates whether the applicant is between the ages of 18 and 70. `Y` Yes `N` No	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-HANDICAP-ID` HANDICAP_ID	Alpha 1	Indicates whether the applicant is disabled. `Y` Yes `N` No `X` Not Disclosed	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-JOB1` JOB1	Alpha 9	Contains the job code of the applicant's first job choice.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-JOB2` JOB2	Alpha 9	Contains the job code of the applicant's second job choice.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-JOB3` JOB3	Alpha 9	Contains the job code of the applicant's third job choice.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-BEG-PAY` BEG_PAY	Signed 11.2	Contains the minimum expected pay.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-END-PAY` END_PAY	Signed 11.2	Contains the maximum expected pay.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-DATE-AVAIL` DATE_AVAIL	Numeric 8 (yyyymmdd)	Contains the date the applicant is available to begin work.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-VETERAN` VETERAN	Alpha 4	Indicates whether the applicant is a veteran.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-DRAFT-STATUS` DRAFT_STATUS	Alpha 3	Contains the user-defined draft status.	LT101, LT111, PA100, PA28.1, PA31.1, PA39.1, PA52.4, PA531
`APL-FINAL-RANK` FINAL_RANK	Alpha 3	Contains the applicant's final military rank.	LT101, LT111, PA100, PA28.1, PA31.1, PA39.1, PA52.4, PA531
`APL-CUR-STATUS` CUR_STATUS	Alpha 2	Indicates the applicant's current military status. `NG` National Guard `RE` Reserves	LT101, LT111, PA100, PA28.1, PA31.1, PA39.1, PA52.4, PA531
`APL-LAST-PHYSICAL` LAST_PHYSICAL	Numeric 8 (yyyymmdd)	Contains the date of the last physical examination.	LT101, LT111, PA100, PA28.1, PA31.1, PA40.1, PA52.4, PA531
`APL-WK-RST-CODE1` WK_RST_CODE1	Alpha 10	Contains the first work restriction code for the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA40.1, PA52.4, PA531
`APL-WK-RST-CODE2` WK_RST_CODE2	Alpha 10	Contains the second work restriction code for the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA40.1, PA52.4, PA531
`APL-WK-RST-CODE3` WK_RST_CODE3	Alpha 10	Contains the third work restriction code for the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA40.1, PA52.4, PA531
`APL-WK-RST-CODE4` WK_RST_CODE4	Alpha 10	Contains the fourth work restriction code for the applicant.	LT101, LT111, PA100, PA28.1, PA31.1, PA40.1, PA52.4, PA531
`APL-RESUME` RESUME	Alpha 1	Indicates whether the applicant's resume has been received. `Y` Yes `N` No	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-LAST-COM-SEQ` LAST_COM_SEQ	Numeric 4	Contains the last sequence number used for the Personnel Comments file.	HR90.1, LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-LAST-REF-SEQ` LAST_REF_SEQ	Numeric 4	Contains the last sequence number used for references.	LT101, LT111, PA100, PA28.1, PA31.1, PA32.1, PA52.4, PA531
`APL-LAST-INT-SEQ` LAST_INT_SEQ	Numeric 4	Contains the last sequence number used for interviews.	LT101, LT111, PA100, PA28.1, PA31.1, PA41.1, PA52.4, PA531
`APL-LAST-MIL-SEQ` LAST_MIL_SEQ	Numeric 4	Contains the last sequence number used for military service record.	LT101, LT111, PA100, PA28.1, PA31.1, PA39.1, PA52.4, PA531
`APL-LAST-EPC-SEQ` LAST_EPC_SEQ	Numeric 4	Contains the last sequence number used for employee codes.	LT101, LT111, PA100, PA20.1, PA21.1, PA22.1, PA24.1, PA27.1 +11 more
`APL-POSITION1` POSITION1	Alpha 12	Contains the first position in which the applicant is interested.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-POSITION2` POSITION2	Alpha 12	Contains the second position in which the applicant is interested.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-POSITION3` POSITION3	Alpha 12	Contains the third position in which the applicant is interested.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	Contains the process level the applicant is associated with.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-EMP-STATUS` EMP_STATUS	Alpha 2	Contains the employee status that indicates whether the applicant wants to work full-time, part-time, seasonal, temporary, and so on.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-WORK-SCHED` WORK_SCHED	Alpha 10	Contains the work schedule that indicates when the applicant wants to work.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-SEC-LVL` SEC_LVL	Numeric 1	This field is not used. It is for future security enhancements.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-SEC-LOCATION` SEC_LOCATION	Alpha 10	This field is not used. It is for future security enhancements.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-NBR-FTE` NBR_FTE	Signed 7.6	Contains the FTE (Full-Time Equivalency) factor that indicates the percent of annual hours the applicant wants to work. For example, if the applicant wants to work full-time, this field is 1.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-PIN` PIN	Alpha 10 (Lower Case)	Contains the applicant personal ID number. This is used for Employee Self-Service.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-ELIG-WORK` ELIG_WORK	Alpha 1	Indicates whether the applicant is eligible to work in the United States. `Y` Yes `N` No	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-TRAV-AVAIL` TRAV_AVAIL	Alpha 1	Indicates whether the applicant is available for travel. `Y` Yes `N` No	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-TRAV-PCT` TRAV_PCT	Numeric 3	Indicates the percentage the applicant is available for travel.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-RELOC-AVAIL` RELOC_AVAIL	Alpha 1	Indicates whether the applicant is available for relocation. `Y` Yes `N` No	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-OT-AVAIL` OT_AVAIL	Alpha 1	Indicates whether the applicant is available for overtime. `Y` Yes `N` No	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-EMAIL-ADDRESS` EMAIL_ADDRESS	Alpha 60 (Lower Case)	Contains the applicant's email address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-EMPLOYEE` EMPLOYEE	Numeric 9	Contains the name of the employee to contact when the applicant is hired.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Contains the currency in which the pay is recorded.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	Contains the country of the applicant's address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-BIRTHDATE` BIRTHDATE	Numeric 8 (yyyymmdd)	Contains the applicant's birth date.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-LANGUAGE-CODE` LANGUAGE_CODE	Alpha 10	Contains the applicant's language, if other than the company's default language.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-NAME-PREFIX` NAME_PREFIX	Alpha 4 (Lower Case)	Contains the applicant's title.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-NAME-SUFFIX` NAME_SUFFIX	Alpha 4 (Lower Case)	Contains the applicant's name suffix.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-DISABILITY` DISABILITY	Alpha 10	Indicates the type of disability the applicant has.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-BASE-BEG-PAY` BASE_BEG_PAY	Signed 11.2	Contains the applicant's beginning pay (of the previous job) in the company's base currency.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-BASE-END-PAY` BASE_END_PAY	Signed 11.2	Contains the applicant's ending pay (of previous job) in the company's base currency.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-BASE-CURRENCY` BASE_CURRENCY	Alpha 5	Contains the company base currency.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-BASE-FEE` BASE_FEE	Numeric 10	Contains the finder's fee in the company's base currency.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-CURR-CODE-2` CURR_CODE_2	Alpha 5	Contains the currency in which the finder's fee is recorded.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-CURR-CODE-ND-2` CURR_CODE_ND_2	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-RELIGION` RELIGION	Alpha 10	Contains the applicant's religion.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-LAST-NAME-PRE` LAST_NAME_PRE	Alpha 30 (Lower Case)	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-CONSENT` CONSENT	Alpha 1	" " = No `N` No `Y` Yes	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-LAST-PRE` LAST_PRE	Derived	—	—
`APL-LAST-SUF` LAST_SUF	Derived	—	—
`APL-LAST-PRE-SUF` LAST_PRE_SUF	Derived	—	—
`APL-LAST-NAME-EXP` LAST_NAME_EXP	Derived	—	—
`APL-FIRST-MI` FIRST_MI	Derived	—	—
`APL-FIRST-MI-EXP` FIRST_MI_EXP	Derived	—	—
`APL-LABEL-NAME` LABEL_NAME	Derived	Contains the applicant's name, as it should appear on labels.	—
`APL-FULL-NAME` FULL_NAME	Derived	Contains the applicant's full name.	—
`APL-SHORT-NAME` SHORT_NAME	Derived	Contains the applicant's short name.	—
`APL-COUNTY` COUNTY	Alpha 25 (Lower Case)	The county for the company address.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-LABEL-NAME-1` LABEL_NAME_1	Derived	—	—
`APL-SUPP-ADDR1` SUPP_ADDR1	Alpha 30 (Lower Case)	—	—
`APL-SUPP-ADDR2` SUPP_ADDR2	Alpha 30 (Lower Case)	—	—
`APL-SUPP-ADDR3` SUPP_ADDR3	Alpha 30 (Lower Case)	—	—
`APL-SUPP-ADDR4` SUPP_ADDR4	Alpha 30 (Lower Case)	—	—
`APL-SUPP-CITY` SUPP_CITY	Alpha 58 (Lower Case)	—	—
`APL-SUPP-STATE` SUPP_STATE	Alpha 2	—	—
`APL-SUPP-ZIP` SUPP_ZIP	Alpha 10	—	—
`APL-SUPP-CNTRY-CD` SUPP_CNTRY_CD	Alpha 2	—	—
`APL-SUPP-PHONE-CNT` SUPP_PHONE_CNT	Alpha 6	—	—
`APL-SUPP-PHONE-NBR` SUPP_PHONE_NBR	Alpha 15	—	—
`APL-REQ-FILLED` REQ_FILLED	Numeric 9	—	—
`APL-POS-FILLED` POS_FILLED	Alpha 12	—	—
`APL-JOB-FILLED` JOB_FILLED	Alpha 9	—	—
`APL-HIRED-PAY-RATE` HIRED_PAY_RATE	Signed 13.4	—	—
`APL-SUPERVISOR` SUPERVISOR	Alpha 10	—	—
`APL-NBR-FTE-HIRED` NBR_FTE_HIRED	Signed 7.6	—	—
`APL-BIRTH-CITY` BIRTH_CITY	Alpha 58 (Lower Case)	—	—
`APL-BIRTH-STATE` BIRTH_STATE	Alpha 2	—	—
`APL-BIRTH-CNTRY-CD` BIRTH_CNTRY_CD	Alpha 2	—	—
`APL-VISIBLE-MIN` VISIBLE_MIN	Alpha 1	— `N` No `Y` Yes	—
`APL-ABORIGINAL` ABORIGINAL	Alpha 1	— `N` No `Y` Yes	—
`APL-DEPARTMENT` DEPARTMENT	Alpha 5	Contains the department.	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-UNION-CODE` UNION_CODE	Alpha 10	—	—
`APL-BARGAIN-UNIT` BARGAIN_UNIT	Alpha 10	—	—
`APL-SUPERVISOR-IND` SUPERVISOR_IND	Alpha 10	—	—
`APL-I9-STATUS` I9_STATUS	Alpha 10	—	—
`APL-I9-ALIEN-NBR` I9_ALIEN_NBR	Alpha 11	—	—
`APL-I9-STA-EXP-DT` I9_STA_EXP_DT	Numeric 8 (yyyymmdd)	—	—
`APL-I9-ADMIT-NBR` I9_ADMIT_NBR	Alpha 13	—	—
`APL-I9-AUTHORIZE` I9_AUTHORIZE	Alpha 30 (Lower Case)	—	—
`APL-I9-DOC-TYPE` I9_DOC_TYPE	Alpha 10 Occurs 2 Times ×2	—	—
`APL-I9-DOC-DESCR` I9_DOC_DESCR	Alpha 10 Occurs 2 Times ×2	—	—
`APL-I9-DOC-NBR` I9_DOC_NBR	Alpha 20 Occurs 2 Times ×2	—	—
`APL-I9-DOC-EXP-DT` I9_DOC_EXP_DT	Numeric 8 (yyyymmdd) Occurs 2 Times ×2	—	—
`APL-SALARY-CLASS` SALARY_CLASS	Alpha 1	— `H` Hourly `S` Salaried	—
`APL-PAY-FREQUENCY` PAY_FREQUENCY	Numeric 1	— `1` Weekly `2` Biweekly `3` Semimonthly `4` Monthly `5` UK Four-Weekly	—
`APL-EXEMPT-EMP` EXEMPT_EMP	Alpha 1	— `N` No `Y` Yes	—
`APL-OT-PLAN-CODE` OT_PLAN_CODE	Alpha 4	Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).	—
`APL-SCHEDULE` SCHEDULE	Alpha 9	—	—
`APL-PAY-GRADE` PAY_GRADE	Alpha 3	—	—
`APL-PAY-STEP` PAY_STEP	Numeric 2	—	—
`APL-ANNUAL-HOURS` ANNUAL_HOURS	Signed 8.4	—	—
`APL-LOCAT-CODE` LOCAT_CODE	Alpha 10	—	—
`APL-HM-DIST-CO` HM_DIST_CO	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	—
`APL-HM-ACCT-UNIT` HM_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	—
`APL-HM-ACCOUNT` HM_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	—
`APL-HM-SUB-ACCT` HM_SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	—
`APL-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	—
`APL-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	—
`APL-SUPP-COUNTY` SUPP_COUNTY	Alpha 25 (Lower Case)	The county for the company address.	—
`APL-L-HIRE-DATE` L_HIRE_DATE	Numeric 8 (yyyymmdd)	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-ADJ-HIRE-DT` L_ADJ_HIRE_DT	Numeric 8 (yyyymmdd)	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-ANNIVR-DATE` L_ANNIVR_DATE	Numeric 8 (yyyymmdd)	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-SENIOR-DATE` L_SENIOR_DATE	Numeric 8 (yyyymmdd)	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-TRUE-MAR-ST` L_TRUE_MAR_ST	Alpha 1	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-FIRST-DAY-WK` L_FIRST_DAY_WK	Numeric 8 (yyyymmdd)	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-WRK-SCH-HIRE` L_WRK_SCH_HIRE	Alpha 10	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-SHIFT-HIRED` L_SHIFT_HIRED	Numeric 1	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-ORG-UNIT` L_ORG_UNIT	Numeric 6	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-CANDIDATE-ID` L_CANDIDATE_ID	Numeric 10	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-JOB-APP` L_JOB_APP	Numeric 4	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-L-JOB-REQ` L_JOB_REQ	Numeric 9	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APL-SURVEY-DATE` SURVEY_DATE	Numeric 8 (yyyymmdd)	—	LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`APLSET1`	`COMPANY`, `APPLICANT`	Primary		BN305, HAP3.1, HAPL.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1, HPQC.1 +22 more (list truncated in source)
`APLSET2`	`COMPANY`, `LAST-NAME`, `FIRST-NAME`, `MIDDLE-INIT`, `APPLICANT`	KeyChange		HAP2.1, PA231
`APLSET3`	`COMPANY`, `FICA-NBR`, `APPLICANT`	KeyChange		HAP3.1, LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`APLSET4`	`COMPANY`, `EMPLOYEE`, `APPLICANT`	KeyChange, Subset	Where EMPLOYEE != Zeroes	PA534
`APLSET5`	`SURVEY-DATE`, `COMPANY`, `APPLICANT`	KeyChange		—

Relations

One to one (23) — lookups and parents

Relation	Table	Rules	Condition	Field map
App Status	EMSTATUS	Required	When APL-APP-STATUS != Spaces	`APL-COMPANY` → `EMS-COMPANY`, `APL-APP-STATUS` → `EMS-EMP-STATUS`
Base Currency	CUCODES	Required	When (APL-CURRENCY-CODE != Spaces)	`APL-BASE-CURRENCY` → `CUC-CURRENCY-CODE`
Company	PRSYSTEM	Required		`APL-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Country	INSTCTRYCD	Required	When (APL-COUNTRY-CODE != Spaces)	`APL-COUNTRY-CODE` → `INT-COUNTRY-CODE`
Currency	CUCODES	Required	When (APL-CURRENCY-CODE != Spaces)	`APL-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Currency2	CUCODES	Required	When APL-CURR-CODE-2 != Spaces	`APL-CURR-CODE-2` → `CUC-CURRENCY-CODE`
Disability	PCODES	Required	When APL-DISABILITY != Spaces	`"DI"` → `PCO-TYPE`, `APL-DISABILITY` → `PCO-CODE`
Emp Status	EMSTATUS	Required	When APL-EMP-STATUS != Spaces	`APL-COMPANY` → `EMS-COMPANY`, `APL-EMP-STATUS` → `EMS-EMP-STATUS`
Employee	EMPLOYEE	Required	When APL-EMPLOYEE != Zeroes	`APL-COMPANY` → `EMP-COMPANY`, `APL-EMPLOYEE` → `EMP-EMPLOYEE`
Hire Source	PCODES	Required	When APL-HIRE-SOURCE != Spaces	`"HS"` → `PCO-TYPE`, `APL-HIRE-SOURCE` → `PCO-CODE`
Job1	JOBCODE	Required	When APL-JOB1 != Spaces	`APL-COMPANY` → `JBC-COMPANY`, `APL-JOB1` → `JBC-JOB-CODE`
Job2	JOBCODE	Required	When APL-JOB2 != Spaces	`APL-COMPANY` → `JBC-COMPANY`, `APL-JOB2` → `JBC-JOB-CODE`
Job3	JOBCODE	Required	When APL-JOB3 != Spaces	`APL-COMPANY` → `JBC-COMPANY`, `APL-JOB3` → `JBC-JOB-CODE`
Paempapp	PAEMPAPP	Required		`APL-COMPANY` → `PPP-COMPANY`, `APL-APPLICANT` → `PPP-APPLICANT`, `Zeroes` → `PPP-EMPLOYEE`
Paemployee	PAEMPLOYEE	Required	When APL-EMPLOYEE != Zeroes	`APL-COMPANY` → `PEM-COMPANY`, `APL-EMPLOYEE` → `PEM-EMPLOYEE`
Prev Country	INSTCTRYCD	Required	When (APL-PREV-CNTRY-CD != Spaces)	`APL-PREV-CNTRY-CD` → `INT-COUNTRY-CODE`
Process Level	PRSYSTEM	Required	When APL-PROCESS-LEVEL != Spaces	`APL-COMPANY` → `PRS-COMPANY`, `APL-PROCESS-LEVEL` → `PRS-PROCESS-LEVEL`
Rating	PCODES	Required	When APL-RATING != Spaces	`"AR"` → `PCO-TYPE`, `APL-RATING` → `PCO-CODE`
Religion	PCODES	Not Required	Valid When APL-RELIGION != Spaces	`"RE"` → `PCO-TYPE`, `APL-RELIGION` → `PCO-CODE`
Wk Rst Code1	PCODES	Required	When APL-WK-RST-CODE1 != Spaces	`"WR"` → `PCO-TYPE`, `APL-WK-RST-CODE1` → `PCO-CODE`
Wk Rst Code2	PCODES	Required	When APL-WK-RST-CODE2 != Spaces	`"WR"` → `PCO-TYPE`, `APL-WK-RST-CODE2` → `PCO-CODE`
Wk Rst Code3	PCODES	Required	When APL-WK-RST-CODE3 != Spaces	`"WR"` → `PCO-TYPE`, `APL-WK-RST-CODE3` → `PCO-CODE`
Wk Rst Code4	PCODES	Required	When APL-WK-RST-CODE4 != Spaces	`"WR"` → `PCO-TYPE`, `APL-WK-RST-CODE4` → `PCO-CODE`

One to many (37) — child tables

Relation	Table	Rules	Condition	Field map
Ce Comments	PACOMMENTS	Delete Cascades		`APL-COMPANY` → `PAC-COMPANY`, `1` → `PAC-EMP-APP`, `"CE"` → `PAC-CMT-TYPE`, `APL-APPLICANT` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `Spaces` → `PAC-ACTION-CODE`, `Zeroes` → `PAC-LN-NBR`, → `PAC-SEQ-NBR`, → `PAC-DATE`
Certificates	EMPCODES	Delete Cascades		`APL-COMPANY` → `EPC-COMPANY`, `"CE"` → `EPC-TYPE`, `1` → `EPC-EMP-APP`, `APL-APPLICANT` → `EPC-EMPLOYEE`, → `EPC-CODE`, → `EPC-SUBJECT`, → `EPC-SEQ-NBR`
Competency	EMPCODES	Delete Cascades		`APL-COMPANY` → `EPC-COMPANY`, `1` → `EPC-EMP-APP`, `APL-APPLICANT` → `EPC-EMPLOYEE`, → `EPC-TYPE`, → `EPC-CODE`, → `EPC-SUBJECT`, → `EPC-SEQ-NBR`
Correspondence	HRCORRESP			`APL-COMPANY` → `HCP-COMPANY`, `"2"` → `HCP-REQ-TYPE`, `APL-APPLICANT` → `HCP-ID-NBR`, `Zeroes` → `HCP-DEPENDENT`, → `HCP-SEQ-NBR`
Ed Comments	PACOMMENTS	Delete Cascades		`APL-COMPANY` → `PAC-COMPANY`, `1` → `PAC-EMP-APP`, `"ED"` → `PAC-CMT-TYPE`, `APL-APPLICANT` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `Spaces` → `PAC-ACTION-CODE`, `Zeroes` → `PAC-LN-NBR`, → `PAC-SEQ-NBR`, → `PAC-DATE`
Education	EMPCODES	Delete Cascades		`APL-COMPANY` → `EPC-COMPANY`, `"ED"` → `EPC-TYPE`, `1` → `EPC-EMP-APP`, `APL-APPLICANT` → `EPC-EMPLOYEE`, → `EPC-CODE`, → `EPC-SUBJECT`, → `EPC-SEQ-NBR`
Employers	APPJOBHIST	Delete Cascades		`APL-COMPANY` → `AJH-COMPANY`, `APL-APPLICANT` → `AJH-APPLICANT`, → `AJH-EMPLOYEE`, → `AJH-EMPLOYER-NAME`, → `AJH-SEQ-NBR`
Ethnicity	HRCTRYCODE		Valid When APL-EEO-CLASS != Spaces	`"ET"` → `CTC-TYPE`, `APL-EEO-CLASS` → `CTC-HRCTRY-CODE`, → `CTC-COUNTRY-CODE`
Ge Comments	PACOMMENTS	Delete Cascades		`APL-COMPANY` → `PAC-COMPANY`, `1` → `PAC-EMP-APP`, `"GE"` → `PAC-CMT-TYPE`, `APL-APPLICANT` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `Spaces` → `PAC-ACTION-CODE`, `Zeroes` → `PAC-LN-NBR`, → `PAC-SEQ-NBR`, → `PAC-DATE`
Hist Err	HISTERR	Delete Cascades		`APL-COMPANY` → `HER-COMPANY`, `APL-APPLICANT` → `HER-EMPLOYEE`, → `HER-OBJ-ID`, → `HER-EFFECT-DATE`, → `HER-ACTION-CODE`, → `HER-ACTION-NBR`, → `HER-FLD-NBR`, → `HER-SEQ-NBR`
Hrhistory	HRHISTORY	Delete Cascades		`APL-COMPANY` → `HRH-COMPANY`, `APL-APPLICANT` → `HRH-EMPLOYEE`, `Zeroes` → `HRH-OBJ-ID`, `99` → `HRH-POS-LEVEL`, → `HRH-BEG-DATE`, → `HRH-FLD-NBR`, → `HRH-SEQ-NBR`
Interview Date	INTERVIEW	Delete Cascades		`APL-COMPANY` → `ITV-COMPANY`, `1` → `ITV-EMP-APP`, `APL-APPLICANT` → `ITV-APPLICANT`, → `ITV-IV-DATE`, → `ITV-SEQ-NBR`
Interviews	INTERVIEW	Delete Cascades		`APL-COMPANY` → `ITV-COMPANY`, `1` → `ITV-EMP-APP`, `APL-APPLICANT` → `ITV-APPLICANT`, → `ITV-SEQ-NBR`
Iv Comments	PACOMMENTS	Delete Cascades		`APL-COMPANY` → `PAC-COMPANY`, `1` → `PAC-EMP-APP`, `"IV"` → `PAC-CMT-TYPE`, `APL-APPLICANT` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `Spaces` → `PAC-ACTION-CODE`, → `PAC-LN-NBR`, → `PAC-SEQ-NBR`, → `PAC-DATE`
Jh Comments	PACOMMENTS	Delete Cascades		`APL-COMPANY` → `PAC-COMPANY`, `1` → `PAC-EMP-APP`, `"JH"` → `PAC-CMT-TYPE`, `APL-APPLICANT` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `Spaces` → `PAC-ACTION-CODE`, → `PAC-LN-NBR`, → `PAC-SEQ-NBR`, → `PAC-DATE`
Job History	APPJOBHIST	Delete Cascades		`APL-COMPANY` → `AJH-COMPANY`, `APL-APPLICANT` → `AJH-APPLICANT`, `Zeroes` → `AJH-EMPLOYEE`, → `AJH-SEQ-NBR`
Job Interest	PAJOBINTRS	Delete Cascades		`APL-COMPANY` → `PJI-COMPANY`, `1` → `PJI-EMP-APP`, `APL-APPLICANT` → `PJI-EMPLOYEE`, → `PJI-JOB-CODE`, → `PJI-POSITION`
Jobauth	JOBAUTH	Delete Cascades		`APL-COMPANY` → `JBA-COMPANY`, `1` → `JBA-EMP-APP`, `APL-APPLICANT` → `JBA-EMPLOYEE`, → `JBA-JOB-CODE`, → `JBA-POSITION`
Md Comments	PACOMMENTS	Delete Cascades		`APL-COMPANY` → `PAC-COMPANY`, `1` → `PAC-EMP-APP`, `"MD"` → `PAC-CMT-TYPE`, `APL-APPLICANT` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `Spaces` → `PAC-ACTION-CODE`, `Zeroes` → `PAC-LN-NBR`, → `PAC-SEQ-NBR`, → `PAC-DATE`
Mi Comments	PACOMMENTS	Delete Cascades		`APL-COMPANY` → `PAC-COMPANY`, `1` → `PAC-EMP-APP`, `"MI"` → `PAC-CMT-TYPE`, `APL-APPLICANT` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `Spaces` → `PAC-ACTION-CODE`, `Zeroes` → `PAC-LN-NBR`, → `PAC-SEQ-NBR`, → `PAC-DATE`
Military	MILITARY	Delete Cascades		`APL-COMPANY` → `MIL-COMPANY`, `1` → `MIL-EMP-APP`, `APL-APPLICANT` → `MIL-EMPLOYEE`, → `MIL-BR-SERVICE`, → `MIL-SEQ-NBR`
Name Prefix	HRCTRYCODE		Valid When APL-NAME-PREFIX != Spaces	`"PR"` → `CTC-TYPE`, `APL-NAME-PREFIX` → `CTC-HRCTRY-CODE`, → `CTC-COUNTRY-CODE`
Name Suffix	HRCTRYCODE		Valid When APL-NAME-SUFFIX != Spaces	`"SU"` → `CTC-TYPE`, `APL-NAME-SUFFIX` → `CTC-HRCTRY-CODE`, → `CTC-COUNTRY-CODE`
Position1	PAPOSITION	Required	When APL-POSITION1 != Spaces	`APL-COMPANY` → `POS-COMPANY`, `APL-POSITION1` → `POS-POSITION`, → `POS-EFFECT-DATE`
Position2	PAPOSITION	Required	When APL-POSITION2 != Spaces	`APL-COMPANY` → `POS-COMPANY`, `APL-POSITION2` → `POS-POSITION`, → `POS-EFFECT-DATE`
Position3	PAPOSITION	Required	When APL-POSITION3 != Spaces	`APL-COMPANY` → `POS-COMPANY`, `APL-POSITION3` → `POS-POSITION`, → `POS-EFFECT-DATE`
Race	PAAEEORACE			`APL-COMPANY` → `AEO-COMPANY`, `APL-APPLICANT` → `AEO-APPLICANT`, → `AEO-RACE`
Ref Name	REFERENC	Delete Cascades		`APL-COMPANY` → `REF-COMPANY`, `APL-APPLICANT` → `REF-APPLICANT`, → `REF-LAST-NAME`, → `REF-FIRST-NAME`, → `REF-MIDDLE-INIT`, → `REF-SEQ-NBR`
References	REFERENC	Delete Cascades		`APL-COMPANY` → `REF-COMPANY`, `APL-APPLICANT` → `REF-APPLICANT`, → `REF-SEQ-NBR`
Relocation	EMPCODES	Delete Cascades		`APL-COMPANY` → `EPC-COMPANY`, `"RL"` → `EPC-TYPE`, `1` → `EPC-EMP-APP`, `APL-APPLICANT` → `EPC-EMPLOYEE`, → `EPC-CODE`, → `EPC-SUBJECT`, → `EPC-SEQ-NBR`
Requis Log	PAREQLOG	Delete Cascades		`APL-COMPANY` → `PQL-COMPANY`, `1` → `PQL-EMP-APP`, `APL-APPLICANT` → `PQL-APPLICANT`, → `PQL-REQUISITION`, → `PQL-DATE`, → `PQL-SEQ-NBR`
Requisitions	PAREQAPP	Delete Cascades		`APL-COMPANY` → `PRA-COMPANY`, `1` → `PRA-EMP-APP`, `APL-APPLICANT` → `PRA-APPLICANT`, → `PRA-REQUISITION`
Rl Comments	PACOMMENTS	Delete Cascades		`APL-COMPANY` → `PAC-COMPANY`, `1` → `PAC-EMP-APP`, `"RL"` → `PAC-CMT-TYPE`, `APL-APPLICANT` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `Spaces` → `PAC-ACTION-CODE`, `Zeroes` → `PAC-LN-NBR`, → `PAC-SEQ-NBR`, → `PAC-DATE`
Sk Comments	PACOMMENTS	Delete Cascades		`APL-COMPANY` → `PAC-COMPANY`, `1` → `PAC-EMP-APP`, `"SK"` → `PAC-CMT-TYPE`, `APL-APPLICANT` → `PAC-EMPLOYEE`, `Spaces` → `PAC-JOB-CODE`, `Spaces` → `PAC-ACTION-CODE`, `Zeroes` → `PAC-LN-NBR`, → `PAC-SEQ-NBR`, → `PAC-DATE`
User Fields	HREMPUSF	Delete Cascades		`APL-COMPANY` → `HEU-COMPANY`, `1` → `HEU-EMP-APP`, `APL-APPLICANT` → `HEU-EMPLOYEE`, → `HEU-FIELD-KEY`
Veteran	HRCTRYCODE		Valid When APL-VETERAN != Spaces	`"VS"` → `CTC-TYPE`, `APL-VETERAN` → `CTC-HRCTRY-CODE`, → `CTC-COUNTRY-CODE`
Work Schedule	HRWRKSCHD		Valid When APL-WORK-SCHED != Spaces	`APL-COMPANY` → `WSC-COMPANY`, `APL-WORK-SCHED` → `WSC-WORK-SCHED`, → `WSC-EFFECT-DATE`, → `WSC-CONTRACT-YEAR`

Programs

Updated by (26)

HR21.1 Work Schedule
HR90.1 Comments
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA100 Action Update
PA120 Applicant Purge
PA20.1 Education
PA21.1 Competencies
PA22.1 Certifications
PA24.1 Relocation
PA27.1 Contracts
PA28.1 Applicant Ethnicity
PA31.1 Applicant
PA32.1 Applicant Reference
PA34.1 Applicant Education
PA35.1 Applicant Competencies
PA36.1 Applicant Certification
PA38.1 Applicant Relocation
PA39.1 Applicant Military Service
PA40.1 Applicant Medical
PA41.1 Interviews
PA52.4 Hire an Applicant
PA520 Employee and Applicant Code Conversion
PA531 Applicant Conversion
TR21.1 Employee Training History
TR26.1 Employee Training Competency Maintenance

Referenced by (114)

BN305 Highly Compensated Employees
HAP2.1 Applicant Option 2 Selection Invoke
HAP3.1 Applicant Option 4 Selection Invoke
HAPL.1 Applicant Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HLTM.1 Lawson Talent Management Feed
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR00.1 Company
HR01.1 Process Level
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR15.1 User Fields
HR170 Human Resource Writer Report Request
HR28.1 Employee Ethnicity
HR30.1 Correspondence Tracking
HR51.2 Employee Interface Data
HR51.8 WFM Interface Data
HR511 Employee Conversion
HR515 User Field Conversion
HR52.2 Talent Management Interface Data
HR54.1 Employee History Correction
HR70.1 Human Resource Writer Inquiry
HR93.3 Applicant Audit Inquiry
HREF.1 Reference Selection Invoke
HRS1.1 Select Control
HRSC.1 Select Control
HS11.1 Web Competency Profile
HS11.2 Web Competency Profile
HS12.1 Web Expired Competencies
HS12.2 Web Expired Competencies
HS13.1 Web Competency Compliance Rpt
HS13.2 Web Competency Compliance Rpt
HS50.1 Employee Qualification Search
HS50.2 Employee Qualification Search
HS50.5 Employee Job Interest
HS51.1 Employee Qualification Search
HS51.2 Employee Qualification Search
HS52.1 Employee Qualification Search
HS52.2 Employee Qualification Search
PA02.1 Position
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA135 Applicant Comments Purge
PA149 Update Scheduled Tests
PA19.1 Prior Work History
PA228 Applicant Ethnicity Listing
PA231 Applicant Profile
PA232 Applicant Reference Listing
PA233 Applicant Job History Listing
PA234 Applicant Education Listing
PA235 Applicant Competency Listing
PA236 Applicant Certification Listing
PA238 Applicant Relocation Listing
PA239 Applicant Military Service Listing
PA240 Applicant Medical Listing
PA241 Interview Listing
PA242 Requisition Listing
PA243 Requisition Log
PA244 Applicant History
PA248 Test Listing
PA249 Employee and Applicant Test Listing
PA258 Report of Actions on Hold
PA262 Qualified Employees Listing
PA263 Qualified Applicants Listing
PA272 Budget and Assigned Resource Listing
PA33.1 Applicant Job History
PA349 Employee and Applicant Test Purge
PA37.1 Applicant Qualification Override
PA43.1 Requisition Applicants
PA43.2 Applicant Requisitions
PA44.1 Requisition Costs
PA45.1 Requisition Offers
PA49.1 Employee Tests
PA49.3 Applicant Tests
PA502 Position Conversion
PA513 Position and Job Conversion
PA53.1 Personnel Action Workflow Override
PA533 Job History Conversion
PA534 e-Recruiting Employee Export
PA54.1 Personnel Action History Correction
PA549 Employee and Applicant Test Conversion
PA58.1 Personnel Actions On Hold
PA62.1 Employee Qualification Search
PA63.1 Applicant Qualification Search
PA64.1 Employee Job Qualification
PA64.2 Employee Position Qualification
PA65.1 Applicant Job Qualification
PA65.2 Applicant Position Qualification
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
TR120 Group Session Registration
TR121 Job Code Session Registration
TR20.1 Session Registration
TR20.2 Mass Registration
TR20.3 Session Registration Override
TR20.4 Employee Session Registration
TR22.1 Session Completion
TR500 Training Conversion
ZH510 Update PCP from ZPENDPCP