OSP ROLODEX Table
View exposing rolodex-style contact records for sponsors and related contacts including names, titles, organizations, contact information, and relationship tracking used for sponsor relationship management.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_LINE_1 |
Address line 1 associated with the record. |
VARCHAR2 |
80 |
ADDRESS_LINE_2 |
Address line 2 associated with the record. |
VARCHAR2 |
80 |
ADDRESS_LINE_3 |
Address line 3 associated with the record. |
VARCHAR2 |
80 |
CITY |
City associated with the record. |
VARCHAR2 |
30 |
COUNTRY_CODE |
Code identifying country. |
VARCHAR2 |
3 |
COUNTRY_NAME |
Country name associated with the record. |
VARCHAR2 |
255 |
COUNTY |
County associated with the record. |
VARCHAR2 |
30 |
CREATE_USER |
Create user associated with the record. |
VARCHAR2 |
60 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
60 |
FAX_NUMBER |
Fax number associated with the record. |
VARCHAR2 |
20 |
FIRST_NAME |
First name associated with the record. |
VARCHAR2 |
20 |
LAST_NAME |
Last name associated with the record. |
VARCHAR2 |
20 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LAST_UPDATE_USER |
Last update user associated with the record. |
VARCHAR2 |
60 |
MIDDLE_NAME |
Middle name associated with the record. |
VARCHAR2 |
20 |
ORGANIZATION |
Organization associated with the record. |
VARCHAR2 |
200 |
PHONE_NUMBER |
Phone number associated with the record. |
VARCHAR2 |
20 |
POSTAL_CODE |
Code identifying postal. |
VARCHAR2 |
15 |
PREFIX |
Prefix associated with the record. |
VARCHAR2 |
10 |
ROLODEX_ID |
Business identifier for the rolodex. |
NUMBER |
|
STATE |
State associated with the record. |
VARCHAR2 |
30 |
SUFFIX |
Suffix associated with the record. |
VARCHAR2 |
10 |
TITLE |
Title associated with the record. |
VARCHAR2 |
35 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |