OSP ROLODEX Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_LINE_1 |
XXX |
VARCHAR2 |
80 |
ADDRESS_LINE_2 |
XXX |
VARCHAR2 |
80 |
ADDRESS_LINE_3 |
XXX |
VARCHAR2 |
80 |
CITY |
City. |
VARCHAR2 |
30 |
COUNTRY_CODE |
The 3 digit code which identifies a country (Example: USA United States of America). |
VARCHAR2 |
3 |
COUNTRY_NAME |
The long name of the country (Example United States, France) |
VARCHAR2 |
255 |
COUNTY |
XXX |
VARCHAR2 |
30 |
CREATE_USER |
XXX |
VARCHAR2 |
60 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
FAX_NUMBER |
The employee's FAX number. |
VARCHAR2 |
20 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
20 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
20 |
LAST_UPDATE_DATE |
Date the description was created or last altered. |
DATE |
|
LAST_UPDATE_USER |
Last person that changed this record. |
VARCHAR2 |
60 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
20 |
ORGANIZATION |
XXX |
VARCHAR2 |
200 |
PHONE_NUMBER |
Phone number of the credit card holder or verifier. |
VARCHAR2 |
20 |
POSTAL_CODE |
Postal Code (part of an address) |
VARCHAR2 |
15 |
PREFIX |
Prefix to a name, e.g. Mr., Mrs, Ms, Prof, Dr. |
VARCHAR2 |
10 |
ROLODEX_ID |
XXX |
NUMBER |
|
STATE |
State. |
VARCHAR2 |
30 |
SUFFIX |
Name suffix (e.g., "III", "Jr.", "Sr", etc. |
VARCHAR2 |
10 |
TITLE |
In the OSP AWARD, COST COLLECTOR, and PROJECT OSP tables, this is the Title of a Research Proposal. In KRB_PERSON, TITLE is the position title of the person. In TIP_MATERIAL view it is a TITLE of the course material. |
VARCHAR2 |
35 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |