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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#APL-COMPANY PK
COMPANY		Numeric 4Contains 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 9Contains 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 SET2
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 SET2
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 SET2
MIDDLE_INIT		Alpha 1Contains 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 2Contains the state of the applicant's address.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-ZIP
ZIP		Alpha 10Contains 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 6Contains 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 15Contains the applicant's home telephone number.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-WK-PHONE-CNTRY
WK_PHONE_CNTRY		Alpha 6Contains 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 15Contains the applicant's work telephone number.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5Contains 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 6Contains 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 15Contains the applicant's fax telephone number.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-FAX-EXT
FAX_EXT		Alpha 5This 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 2Contains the applicant's status.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-FICA-NBR SET3
FICA_NBR		Alpha 20Contains 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 10Indicates 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 1Contains 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 10Contains the finders fee.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-PREV-APPLY
PREV_APPLY		Alpha 1Indicates 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 1Indicates 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 9Contains 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 10Contains 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 1Contains 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 2Contains the state of the applicant's previous address.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-PREV-ZIP
PREV_ZIP		Alpha 10Contains 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 2Contains 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 1Contains 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 1Indicates 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 1Indicates 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 9Contains the job code of the applicant's first job choice.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-JOB2
JOB2		Alpha 9Contains the job code of the applicant's second job choice.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-JOB3
JOB3		Alpha 9Contains 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.2Contains the minimum expected pay.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-END-PAY
END_PAY		Signed 11.2Contains 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 4Indicates whether the applicant is a veteran.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-DRAFT-STATUS
DRAFT_STATUS		Alpha 3Contains the user-defined draft status.LT101, LT111, PA100, PA28.1, PA31.1, PA39.1, PA52.4, PA531
#APL-FINAL-RANK
FINAL_RANK		Alpha 3Contains the applicant's final military rank.LT101, LT111, PA100, PA28.1, PA31.1, PA39.1, PA52.4, PA531
#APL-CUR-STATUS
CUR_STATUS		Alpha 2Indicates 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 10Contains 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 10Contains 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 10Contains 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 10Contains the fourth work restriction code for the applicant.LT101, LT111, PA100, PA28.1, PA31.1, PA40.1, PA52.4, PA531
#APL-RESUME
RESUME		Alpha 1Indicates 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 4Contains 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 4Contains 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 4Contains 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 4Contains 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 4Contains 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 12Contains the first position in which the applicant is interested.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-POSITION2
POSITION2		Alpha 12Contains the second position in which the applicant is interested.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-POSITION3
POSITION3		Alpha 12Contains 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 5Contains the process level the applicant is associated with.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-EMP-STATUS
EMP_STATUS		Alpha 2Contains 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 10Contains 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 1This 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 10This 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.6Contains 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 1Indicates 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 1Indicates 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 3Indicates the percentage the applicant is available for travel.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-RELOC-AVAIL
RELOC_AVAIL		Alpha 1Indicates 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 1Indicates 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 SET4
EMPLOYEE		Numeric 9Contains 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 5Contains the currency in which the pay is recorded.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-CURR-ND
CURR_ND		Numeric 1The 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 2Contains 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 10Contains 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 10Indicates 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.2Contains 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.2Contains 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 5Contains the company base currency.LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
#APL-BASE-ND
BASE_ND		Numeric 1The 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 10Contains 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 5Contains 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 1The 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 10Contains 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-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		DerivedContains the applicant's name, as it should appear on labels.—
#APL-FULL-NAME
FULL_NAME		DerivedContains the applicant's full name.—
#APL-SHORT-NAME
SHORT_NAME		DerivedContains 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 5Contains 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 4Identifies 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 4Identifies 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 15The 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 6This 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 4This 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 15Activities 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 5Account 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 SET5
SURVEY_DATE		Numeric 8 (yyyymmdd)—LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531

Indexes (5)

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.

IndexKeysFlagsConditionUsed in
APLSET1
  1. COMPANY
  2. APPLICANT
PrimaryBN305, HAP3.1, HAPL.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1, HPQC.1 +22 more (list truncated in source)
APLSET2
  1. COMPANY
  2. LAST-NAME
  3. FIRST-NAME
  4. MIDDLE-INIT
  5. APPLICANT
KeyChangeHAP2.1, PA231
APLSET3
  1. COMPANY
  2. FICA-NBR
  3. APPLICANT
KeyChangeHAP3.1, LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
APLSET4
  1. COMPANY
  2. EMPLOYEE
  3. APPLICANT
KeyChange, SubsetWhere EMPLOYEE != ZeroesPA534
APLSET5
  1. SURVEY-DATE
  2. COMPANY
  3. APPLICANT
KeyChange—

Relations

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

One to one (23) — lookups and parents

RelationTableRulesConditionField map
App StatusEMSTATUSRequiredWhen APL-APP-STATUS != Spaces
APL-COMPANY→EMS-COMPANY
APL-APP-STATUS→EMS-EMP-STATUS
Base CurrencyCUCODESRequiredWhen (APL-CURRENCY-CODE != Spaces)
APL-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
APL-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredWhen (APL-COUNTRY-CODE != Spaces)
APL-COUNTRY-CODE→INT-COUNTRY-CODE
CurrencyCUCODESRequiredWhen (APL-CURRENCY-CODE != Spaces)
APL-CURRENCY-CODE→CUC-CURRENCY-CODE
Currency2CUCODESRequiredWhen APL-CURR-CODE-2 != Spaces
APL-CURR-CODE-2→CUC-CURRENCY-CODE
DisabilityPCODESRequiredWhen APL-DISABILITY != Spaces
"DI"→PCO-TYPE
APL-DISABILITY→PCO-CODE
Emp StatusEMSTATUSRequiredWhen APL-EMP-STATUS != Spaces
APL-COMPANY→EMS-COMPANY
APL-EMP-STATUS→EMS-EMP-STATUS
EmployeeEMPLOYEERequiredWhen APL-EMPLOYEE != Zeroes
APL-COMPANY→EMP-COMPANY
APL-EMPLOYEE→EMP-EMPLOYEE
Hire SourcePCODESRequiredWhen APL-HIRE-SOURCE != Spaces
"HS"→PCO-TYPE
APL-HIRE-SOURCE→PCO-CODE
Job1JOBCODERequiredWhen APL-JOB1 != Spaces
APL-COMPANY→JBC-COMPANY
APL-JOB1→JBC-JOB-CODE
Job2JOBCODERequiredWhen APL-JOB2 != Spaces
APL-COMPANY→JBC-COMPANY
APL-JOB2→JBC-JOB-CODE
Job3JOBCODERequiredWhen APL-JOB3 != Spaces
APL-COMPANY→JBC-COMPANY
APL-JOB3→JBC-JOB-CODE
PaempappPAEMPAPPRequired
APL-COMPANY→PPP-COMPANY
APL-APPLICANT→PPP-APPLICANT
Zeroes→PPP-EMPLOYEE
PaemployeePAEMPLOYEERequiredWhen APL-EMPLOYEE != Zeroes
APL-COMPANY→PEM-COMPANY
APL-EMPLOYEE→PEM-EMPLOYEE
Prev CountryINSTCTRYCDRequiredWhen (APL-PREV-CNTRY-CD != Spaces)
APL-PREV-CNTRY-CD→INT-COUNTRY-CODE
Process LevelPRSYSTEMRequiredWhen APL-PROCESS-LEVEL != Spaces
APL-COMPANY→PRS-COMPANY
APL-PROCESS-LEVEL→PRS-PROCESS-LEVEL
RatingPCODESRequiredWhen APL-RATING != Spaces
"AR"→PCO-TYPE
APL-RATING→PCO-CODE
ReligionPCODESNot RequiredValid When APL-RELIGION != Spaces
"RE"→PCO-TYPE
APL-RELIGION→PCO-CODE
Wk Rst Code1PCODESRequiredWhen APL-WK-RST-CODE1 != Spaces
"WR"→PCO-TYPE
APL-WK-RST-CODE1→PCO-CODE
Wk Rst Code2PCODESRequiredWhen APL-WK-RST-CODE2 != Spaces
"WR"→PCO-TYPE
APL-WK-RST-CODE2→PCO-CODE
Wk Rst Code3PCODESRequiredWhen APL-WK-RST-CODE3 != Spaces
"WR"→PCO-TYPE
APL-WK-RST-CODE3→PCO-CODE
Wk Rst Code4PCODESRequiredWhen APL-WK-RST-CODE4 != Spaces
"WR"→PCO-TYPE
APL-WK-RST-CODE4→PCO-CODE

One to many (37) — child tables

RelationTableRulesConditionField map
Ce CommentsPACOMMENTSDelete 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
CertificatesEMPCODESDelete Cascades
APL-COMPANY→EPC-COMPANY
"CE"→EPC-TYPE
1→EPC-EMP-APP
APL-APPLICANT→EPC-EMPLOYEE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
CompetencyEMPCODESDelete Cascades
APL-COMPANY→EPC-COMPANY
1→EPC-EMP-APP
APL-APPLICANT→EPC-EMPLOYEE
—→EPC-TYPE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
CorrespondenceHRCORRESP
APL-COMPANY→HCP-COMPANY
"2"→HCP-REQ-TYPE
APL-APPLICANT→HCP-ID-NBR
Zeroes→HCP-DEPENDENT
—→HCP-SEQ-NBR
Ed CommentsPACOMMENTSDelete 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
EducationEMPCODESDelete Cascades
APL-COMPANY→EPC-COMPANY
"ED"→EPC-TYPE
1→EPC-EMP-APP
APL-APPLICANT→EPC-EMPLOYEE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
EmployersAPPJOBHISTDelete Cascades
APL-COMPANY→AJH-COMPANY
APL-APPLICANT→AJH-APPLICANT
—→AJH-EMPLOYEE
—→AJH-EMPLOYER-NAME
—→AJH-SEQ-NBR
EthnicityHRCTRYCODEValid When APL-EEO-CLASS != Spaces
"ET"→CTC-TYPE
APL-EEO-CLASS→CTC-HRCTRY-CODE
—→CTC-COUNTRY-CODE
Ge CommentsPACOMMENTSDelete 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 ErrHISTERRDelete 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
HrhistoryHRHISTORYDelete 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 DateINTERVIEWDelete Cascades
APL-COMPANY→ITV-COMPANY
1→ITV-EMP-APP
APL-APPLICANT→ITV-APPLICANT
—→ITV-IV-DATE
—→ITV-SEQ-NBR
InterviewsINTERVIEWDelete Cascades
APL-COMPANY→ITV-COMPANY
1→ITV-EMP-APP
APL-APPLICANT→ITV-APPLICANT
—→ITV-SEQ-NBR
Iv CommentsPACOMMENTSDelete 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 CommentsPACOMMENTSDelete 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 HistoryAPPJOBHISTDelete Cascades
APL-COMPANY→AJH-COMPANY
APL-APPLICANT→AJH-APPLICANT
Zeroes→AJH-EMPLOYEE
—→AJH-SEQ-NBR
Job InterestPAJOBINTRSDelete Cascades
APL-COMPANY→PJI-COMPANY
1→PJI-EMP-APP
APL-APPLICANT→PJI-EMPLOYEE
—→PJI-JOB-CODE
—→PJI-POSITION
JobauthJOBAUTHDelete Cascades
APL-COMPANY→JBA-COMPANY
1→JBA-EMP-APP
APL-APPLICANT→JBA-EMPLOYEE
—→JBA-JOB-CODE
—→JBA-POSITION
Md CommentsPACOMMENTSDelete 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 CommentsPACOMMENTSDelete 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
MilitaryMILITARYDelete Cascades
APL-COMPANY→MIL-COMPANY
1→MIL-EMP-APP
APL-APPLICANT→MIL-EMPLOYEE
—→MIL-BR-SERVICE
—→MIL-SEQ-NBR
Name PrefixHRCTRYCODEValid When APL-NAME-PREFIX != Spaces
"PR"→CTC-TYPE
APL-NAME-PREFIX→CTC-HRCTRY-CODE
—→CTC-COUNTRY-CODE
Name SuffixHRCTRYCODEValid When APL-NAME-SUFFIX != Spaces
"SU"→CTC-TYPE
APL-NAME-SUFFIX→CTC-HRCTRY-CODE
—→CTC-COUNTRY-CODE
Position1PAPOSITIONRequiredWhen APL-POSITION1 != Spaces
APL-COMPANY→POS-COMPANY
APL-POSITION1→POS-POSITION
—→POS-EFFECT-DATE
Position2PAPOSITIONRequiredWhen APL-POSITION2 != Spaces
APL-COMPANY→POS-COMPANY
APL-POSITION2→POS-POSITION
—→POS-EFFECT-DATE
Position3PAPOSITIONRequiredWhen APL-POSITION3 != Spaces
APL-COMPANY→POS-COMPANY
APL-POSITION3→POS-POSITION
—→POS-EFFECT-DATE
RacePAAEEORACE
APL-COMPANY→AEO-COMPANY
APL-APPLICANT→AEO-APPLICANT
—→AEO-RACE
Ref NameREFERENCDelete Cascades
APL-COMPANY→REF-COMPANY
APL-APPLICANT→REF-APPLICANT
—→REF-LAST-NAME
—→REF-FIRST-NAME
—→REF-MIDDLE-INIT
—→REF-SEQ-NBR
ReferencesREFERENCDelete Cascades
APL-COMPANY→REF-COMPANY
APL-APPLICANT→REF-APPLICANT
—→REF-SEQ-NBR
RelocationEMPCODESDelete Cascades
APL-COMPANY→EPC-COMPANY
"RL"→EPC-TYPE
1→EPC-EMP-APP
APL-APPLICANT→EPC-EMPLOYEE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
Requis LogPAREQLOGDelete Cascades
APL-COMPANY→PQL-COMPANY
1→PQL-EMP-APP
APL-APPLICANT→PQL-APPLICANT
—→PQL-REQUISITION
—→PQL-DATE
—→PQL-SEQ-NBR
RequisitionsPAREQAPPDelete Cascades
APL-COMPANY→PRA-COMPANY
1→PRA-EMP-APP
APL-APPLICANT→PRA-APPLICANT
—→PRA-REQUISITION
Rl CommentsPACOMMENTSDelete 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 CommentsPACOMMENTSDelete 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 FieldsHREMPUSFDelete Cascades
APL-COMPANY→HEU-COMPANY
1→HEU-EMP-APP
APL-APPLICANT→HEU-EMPLOYEE
—→HEU-FIELD-KEY
VeteranHRCTRYCODEValid When APL-VETERAN != Spaces
"VS"→CTC-TYPE
APL-VETERAN→CTC-HRCTRY-CODE
—→CTC-COUNTRY-CODE
Work ScheduleHRWRKSCHDValid 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)

Referenced by (114)