|
|
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
Company Contains the company number represents
an established company.
REF-APPLICANT Numeric 9 PA32.1
Applicant This field contains the applicant's
number.
REF-SEQ-NBR Numeric 4 PA32.1
Sequence Number This field contains the reference
sequence number, which is automatically
assigned when the record is created.
REF-LAST-NAME Alpha 30 (Lower Case) PA32.1
Last Name This field contains the reference's
last name.
REF-FIRST-NAME Alpha 15 (Lower Case) PA32.1
First Name This field contains the reference's
first name.
REF-MIDDLE-INIT Alpha 1 PA32.1
Middle Initial This field contains the reference's
middle initial.
REF-ADDR1 Alpha 30 (Lower Case) PA32.1
Address 1 This field contains the first line of
the reference's address.
REF-ADDR2 Alpha 30 (Lower Case) PA32.1
Address 2 This field contains the second line of
the reference's address.
REF-ADDR3 Alpha 30 (Lower Case) PA32.1
Address 3 Contains the third line of address
information.
REF-ADDR4 Alpha 30 (Lower Case) PA32.1
Address 4 Contains the fourth line of address
information.
REF-CITY Alpha 18 (Lower Case) PA32.1
City This field contains the city of the
reference's address.
REF-STATE Alpha 2 PA32.1
State or Province This field contains the state of the
reference's address.
REF-ZIP Alpha 10 PA32.1
Postal Code This field contains the postal code of
the reference's address.
REF-COUNTRY Alpha 30 (Lower Case)
Country or Other Contains the country 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
Work Telephone Contains the reference's telphone
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
Hm Phone Cntry Contains the country code of the
reference's home telephone number.
REF-HM-PHONE-NBR Alpha 15 PA32.1
Hm Phone Nbr Contains the reference's home telephone
number.
REF-CONTACT-FLAG Alpha 1 PA32.1
Contacted This field indicates if the reference
has been contacted.
N = Not contacted
Y = Has Been Contacted
REF-FULL-NAME Derived
Full Name
REF-ASSOCIATION Alpha 10 PA32.1
Association Contains a value that indicates how the
reference is realted to the applicant.
REF-COUNTRY-CODE Alpha 2 PA32.1
Country Code Contains the country of the reference's
address.
REF-DATE-STAMP Numeric 8 (yyyymmdd) PA32.1
Date Stamp Contains the server date (month, date,
and year) of the last change to this
record.
REF-TIME-STAMP Numeric 6 (hhmmss) PA32.1
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
User ID Name Contains the user ID of the person who
last changed this record.
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
|