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

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 SET2
LAST_NAME		Alpha 30 (Lower Case)This field contains the reference's last name.PA32.1
#REF-FIRST-NAME SET2
FIRST_NAME		Alpha 15 (Lower Case)This field contains the reference's first name.PA32.1
#REF-MIDDLE-INIT SET2
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 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
REFSET1
  1. COMPANY
  2. APPLICANT
  3. SEQ-NBR
PrimaryHR170, HR70.1, HR90.1, HREF.1, PA232, PA241, PA32.1
REFSET2
  1. COMPANY
  2. APPLICANT
  3. LAST-NAME
  4. FIRST-NAME
  5. MIDDLE-INIT
  6. SEQ-NBR
KeyChangePA120, PA231

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequired
REF-COMPANY→APL-COMPANY
REF-APPLICANT→APL-APPLICANT
AssociationPCODESRequiredWhen REF-ASSOCIATION != Spaces
"AS"→PCO-TYPE
REF-ASSOCIATION→PCO-CODE
CompanyPRSYSTEMRequired
REF-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 Cascades
REF-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)