REFERENC

Applicant Reference

The Applicant Reference file contains applicant reference information.

REFERENCED BY
HR90.1


UPDATED BY
HR170 HR70.1 HREF.1 PA120 PA231 PA232
PA241 PA32.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REF-COMPANY
Element: Company Hr
Numeric 4
Contains the company number represents an established company.
PA32.1
REF-APPLICANT
Element: Applicant
Numeric 9
This field contains the applicant's number.
PA32.1
REF-SEQ-NBR
Element: Seq Nbr
Numeric 4
This field contains the reference sequence number, which is automatically assigned when the record is created.
PA32.1
REF-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
This field contains the reference's last name.
PA32.1
REF-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
This field contains the reference's first name.
PA32.1
REF-MIDDLE-INIT
Element: Middle Init
Alpha 1
This field contains the reference's middle initial.
PA32.1
REF-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of the reference's address.
PA32.1
REF-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the second line of the reference's address.
PA32.1
REF-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
Contains the third line of address information.
PA32.1
REF-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
Contains the fourth line of address information.
PA32.1
REF-CITY
Element: City
Alpha 18 (Lower Case)
This field contains the city of the reference's address.
PA32.1
REF-STATE
Element: State
Alpha 2
This field contains the state of the reference's address.
PA32.1
REF-ZIP
Element: Zip
Alpha 10
This field contains the postal code of the reference's address.
PA32.1
REF-WK-PHONE-CNTRY
Element: Wk Phone Cntry
Alpha 6
Contains the country code of the reference's work telephone number.
PA32.1
REF-WK-PHONE-NBR
Element: Wk Phone Nbr
Alpha 15
Contains the reference's telephone number.
PA32.1
REF-WK-PHONE-EXT
Element: Wk Phone Ext
Alpha 5
Contains the extension of the reference's work telephone number.
PA32.1
REF-HM-PHONE-CNTRY
Element: Hm Phone Cntry
Alpha 6
Contains the country code of the reference's home telephone number.
PA32.1
REF-HM-PHONE-NBR
Element: Hm Phone Nbr
Alpha 15
Contains the reference's home telephone number.
PA32.1
REF-CONTACT-FLAG
Element: Contact Flag
Alpha 1
This field indicates if the reference has been contacted.
N = Not contacted
Y = Has Been Contacted
PA32.1
REF-FULL-NAME
Element: Full Name
Derived
REF-ASSOCIATION
Element: Association
Alpha 10
Contains a value that indicates how the reference is related to the applicant.
PA32.1
REF-COUNTRY-CODE
Element: Country Code
Alpha 2
Contains the country of the reference's address.
PA32.1
REF-DATE-STAMP
Element: 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
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA32.1
REF-USER-ID
Element: User
Alpha 10 (Lower Case)
PA32.1


REFERENC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REFSET1 COMPANY
APPLICANT
SEQ-NBR
HR170 HR70.1
HR90.1 HREF.1
PA232 PA241
PA32.1
REFSET2 COMPANY
APPLICANT
LAST-NAME
FIRST-NAME
MIDDLE-INIT
SEQ-NBR
KeyChange
PA120 PA231


REFERENC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
REF-COMPANY->APL-COMPANY
REF-APPLICANT->APL-APPLICANT
Association PCODES Required
When REF-ASSOCIATION !=Spaces
"AS"->PCO-TYPE
REF-ASSOCIATION->PCO-CODE
Company PRSYSTEM Required
REF-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (REF-COUNTRY-CODE !=Spaces )
REF-COUNTRY-CODE->INT-COUNTRY-CODE


REFERENC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Comments PACOMMENTS Delete 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


File created: Thu Jun 09 11:22:27 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.