Applicant Reference
The Applicant Reference file contains applicant reference information.
REFERENCED BY
HR170 | HR70.1 | HR90.1 | HREF.1 | PA232 | PA241 |
PA231 |
PA120 | PA32.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
REF-COMPANY Element: Company Hr | Numeric 4 Contains the company number represents an established company. |
|
||
REF-APPLICANT Element: Applicant | Numeric 9 This field contains the applicant's number. |
|
||
REF-SEQ-NBR Element: Seq Nbr | Numeric 4 This field contains the reference sequence number, which is automatically assigned when the record is created. |
|
||
REF-LAST-NAME Element: Last Name | Alpha 30 (Lower Case) This field contains the reference's last name. |
|
||
REF-FIRST-NAME Element: First Name | Alpha 15 (Lower Case) This field contains the reference's first name. |
|
||
REF-MIDDLE-INIT Element: Middle Init | Alpha 1 This field contains the reference's middle initial. |
|
||
REF-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of the reference's address. |
|
||
REF-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the second line of the reference's address. |
|
||
REF-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) Contains the third line of address information. |
|
||
REF-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) Contains the fourth line of address information. |
|
||
REF-CITY Element: Hr City | Alpha 58 (Lower Case) This field contains the city of the reference's address. |
|
||
REF-STATE Element: State | Alpha 2 This field contains the state of the reference's address. |
|
||
REF-ZIP Element: Zip | Alpha 10 This field contains the postal code of the reference's address. |
|
||
REF-WK-PHONE-CNTRY Element: Wk Phone Cntry | Alpha 6 Contains the country code of the reference's work telephone number. |
|
||
REF-WK-PHONE-NBR Element: Wk Phone Nbr | Alpha 15 Contains the reference's telephone number. |
|
||
REF-WK-PHONE-EXT Element: Wk Phone Ext | Alpha 5 Contains the extension of the reference's work telephone number. |
|
||
REF-HM-PHONE-CNTRY Element: Hm Phone Cntry | Alpha 6 Contains the country code of the reference's home telephone number. |
|
||
REF-HM-PHONE-NBR Element: Hm Phone Nbr | Alpha 15 Contains the reference's home telephone number. |
|
||
REF-CONTACT-FLAG Element: Contact Flag | Alpha 1 This field indicates if the reference has been contacted. N = Not contacted Y = Has Been Contacted |
|
||
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. |
|
||
REF-COUNTRY-CODE Element: Country Code | Alpha 2 Contains the country of the reference's address. |
|
||
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. |
|
||
REF-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
REF-USER-ID Element: User | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
REFSET1 |
COMPANY APPLICANT SEQ-NBR |
|
| ||||||||||||||
REFSET2 |
COMPANY APPLICANT LAST-NAME FIRST-NAME MIDDLE-INIT SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Applicant | APPLICANT |
Required
| ||||||||||||
Association | PCODES |
Required
| ||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||
Country | INSTCTRYCD |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Comments | PACOMMENTS |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.