|
|
REFERENC FILE
Applicant Reference
The Applicant Reference file contains applicant reference information.
REFERENCED BY
HR170 HR70.1 HR90.1 HREF.1 PA232 PA241
PA231
UPDATED BY
PA120 PA32.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REF-COMPANY Numeric 4 PA32.1
Element: Company Contains the company number represents
an established company.
REF-APPLICANT Numeric 9 PA32.1
Element: Applicant This field contains the applicant's
number.
REF-SEQ-NBR Numeric 4 PA32.1
Element: Sequence NumbeThis field contains the reference
sequence number, which is automatically
assigned when the record is created.
REF-LAST-NAME Alpha 30 (Lower Case) PA32.1
Element: Name This field contains the reference's
last name.
REF-FIRST-NAME Alpha 15 (Lower Case) PA32.1
Element: First Name This field contains the reference's
first name.
REF-MIDDLE-INIT Alpha 1 PA32.1
Element: Middle InitialThis field contains the reference's
middle initial.
REF-ADDR1 Alpha 30 (Lower Case) PA32.1
Element: Address 1 This field contains the first line of
the reference's address.
REF-ADDR2 Alpha 30 (Lower Case) PA32.1
Element: Address 1 This field contains the second line of
the reference's address.
REF-ADDR3 Alpha 30 (Lower Case) PA32.1
Element: Address 1 Contains the third line of address
information.
REF-ADDR4 Alpha 30 (Lower Case) PA32.1
Element: Address 1 Contains the fourth line of address
information.
REF-CITY Alpha 18 (Lower Case) PA32.1
Element: City This field contains the city of the
reference's address.
REF-STATE Alpha 2 PA32.1
Element: State or ProviThis field contains the state of the
reference's address.
REF-ZIP Alpha 10 PA32.1
Element: Postal Code This field contains the postal code of
the reference's address.
REF-WK-PHONE-CNTRY Alpha 6 PA32.1
Work Telephone Contains the country code of the
Country reference's work telephone number.
REF-WK-PHONE-NBR Alpha 15 PA32.1
Element: Work TelephoneContains the reference's telephone
number.
REF-WK-PHONE-EXT Alpha 5 PA32.1
Work Telephone Contains the extension of the
Extension reference's work telephone number.
REF-HM-PHONE-CNTRY Alpha 6 PA32.1
Element: Hm Phone CntryContains the country code of the
reference's home telephone number.
REF-HM-PHONE-NBR Alpha 15 PA32.1
Element: Hm Phone Nbr Contains the reference's home telephone
number.
REF-CONTACT-FLAG Alpha 1 PA32.1
Element: Contacted This field indicates if the reference
has been contacted.
N = Not contacted
Y = Has Been Contacted
REF-FULL-NAME Derived
Element: Full Name
REF-ASSOCIATION Alpha 10 PA32.1
Element: Association Contains a value that indicates how the
reference is related to the applicant.
REF-COUNTRY-CODE Alpha 2 PA32.1
Element: Country Code Contains the country of the reference's
address.
REF-DATE-STAMP Numeric 8 (yyyymmdd) PA32.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
REF-TIME-STAMP Numeric 6 (hhmmss) PA32.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
REF-USER-ID Alpha 10 (Lower Case) PA32.1
Element: User
REFERENC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REFSET1 COMPANY HR170 HR70.1
APPLICANT HR90.1 HREF.1
SEQ-NBR PA232 PA241
PA32.1
REFSET2 COMPANY KeyChange PA120 PA231
APPLICANT
LAST-NAME
FIRST-NAME
MIDDLE-INIT
SEQ-NBR
REFERENC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
