REFERENC – Applicant Reference

System
Personnel (PA)
Prefix
REF
Primary key
COMPANY, APPLICANT, SEQ-NBR
Fields
25
Updated by
2 programs
Referenced by
7 programs

REFERENC is the Applicant Reference table in Lawson Personnel (prefix REF). It is indexed by COMPANY, APPLICANT, SEQ-NBR (REFSET1); alternate indexes: REFSET2. It is related 1:1 to APPLICANT, PCODES, PRSYSTEM and INSTCTRYCD and 1:M to PACOMMENTS. It is updated by PA120 and PA32.1 and referenced by HR170, HR70.1, HR90.1, HREF.1, PA231, PA232 and PA241. The table has 25 fields, 2 indexes and 5 documented relations.

About REFERENC

The Applicant Reference file contains applicant reference information.

Fields (25)

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

Field / columnTypeDescription & valuesUpdated by
REF-COMPANY PK
COMPANY		Numeric 4Contains the company number represents an established company.PA32.1
REF-APPLICANT PK
APPLICANT		Numeric 9This field contains the applicant's number.PA32.1
REF-SEQ-NBR PK
SEQ_NBR		Numeric 4This field contains the reference sequence number, which is automatically assigned when the record is created.PA32.1
REF-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)This field contains the reference's last name.PA32.1
REF-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)This field contains the reference's first name.PA32.1
REF-MIDDLE-INIT
MIDDLE_INIT		Alpha 1This field contains the reference's middle initial.PA32.1
REF-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of the reference's address.PA32.1
REF-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the second line of the reference's address.PA32.1
REF-ADDR3
ADDR3		Alpha 30 (Lower Case)Contains the third line of address information.PA32.1
REF-ADDR4
ADDR4		Alpha 30 (Lower Case)Contains the fourth line of address information.PA32.1
REF-CITY
CITY		Alpha 58 (Lower Case)This field contains the city of the reference's address.PA32.1
REF-STATE
STATE		Alpha 2This field contains the state of the reference's address.PA32.1
REF-ZIP
ZIP		Alpha 10This field contains the postal code of the reference's address.PA32.1
REF-WK-PHONE-CNTRY
WK_PHONE_CNTRY		Alpha 6Contains the country code of the reference's work telephone number.PA32.1
REF-WK-PHONE-NBR
WK_PHONE_NBR		Alpha 15Contains the reference's telephone number.PA32.1
REF-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5Contains the extension of the reference's work telephone number.PA32.1
REF-HM-PHONE-CNTRY
HM_PHONE_CNTRY		Alpha 6Contains the country code of the reference's home telephone number.PA32.1
REF-HM-PHONE-NBR
HM_PHONE_NBR		Alpha 15Contains the reference's home telephone number.PA32.1
REF-CONTACT-FLAG
CONTACT_FLAG		Alpha 1This field indicates if the reference has been contacted.
  • N Not contacted
  • Y Has Been Contacted
PA32.1
REF-FULL-NAME
FULL_NAME		Derived——
REF-ASSOCIATION
ASSOCIATION		Alpha 10Contains a value that indicates how the reference is related to the applicant.PA32.1
REF-COUNTRY-CODE
COUNTRY_CODE		Alpha 2Contains the country of the reference's address.PA32.1
REF-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PA32.1
REF-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PA32.1
REF-USER-ID
USER_ID		Alpha 10 (Lower Case)—PA32.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
REFSET1COMPANY, APPLICANT, SEQ-NBRPrimaryHR170, HR70.1, HR90.1, HREF.1, PA232, PA241, PA32.1
REFSET2COMPANY, APPLICANT, LAST-NAME, FIRST-NAME, MIDDLE-INIT, SEQ-NBRKeyChangePA120, PA231

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredREF-COMPANY → APL-COMPANY, REF-APPLICANT → APL-APPLICANT
AssociationPCODESRequiredWhen REF-ASSOCIATION != Spaces"AS" → PCO-TYPE, REF-ASSOCIATION → PCO-CODE
CompanyPRSYSTEMRequiredREF-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredWhen (REF-COUNTRY-CODE != Spaces)REF-COUNTRY-CODE → INT-COUNTRY-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
CommentsPACOMMENTSDelete CascadesREF-COMPANY → PAC-COMPANY, 1 → PAC-EMP-APP, "RF" → PAC-CMT-TYPE, REF-APPLICANT → PAC-EMPLOYEE, Spaces → PAC-JOB-CODE, Spaces → PAC-ACTION-CODE, REF-SEQ-NBR → PAC-LN-NBR, → PAC-SEQ-NBR, → PAC-DATE

Programs

Updated by (2)

Referenced by (7)