SPONSOR Table
View exposing sponsor master data including sponsor identifiers, names, sponsor type, administering activity, DUNS and UEI attributes, address information, Rolodex identifier, and audit-report fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMINISTERING_ACTIVITY |
Administering activity associated with the record. |
VARCHAR2 |
30 |
AUDIT_REPORT_SENT_FOR_FY |
Audit report sent for fy associated with the record. |
VARCHAR2 |
4 |
CAGE_NUMBER |
Cage number associated with the record. |
VARCHAR2 |
20 |
COUNTRY_CODE |
Country code associated with the record. |
VARCHAR2 |
3 |
COUNTRY_NAME |
Country name associated with the record. |
VARCHAR2 |
255 |
DUN_AND_BRADSTREET_NUMBER |
Dun and bradstreet number associated with the record. |
VARCHAR2 |
20 |
POSTAL_CODE |
Postal code associated with the record. |
VARCHAR2 |
15 |
ROLODEX_ID |
Business identifier for the rolodex. |
NUMBER |
28 |
SPONSOR_CODE |
Code identifying sponsor. |
VARCHAR2 |
6 |
SPONSOR_KEY |
Surrogate key identifying the sponsor. |
VARCHAR2 |
6 |
SPONSOR_NAME |
Sponsor name associated with the person or organization. |
VARCHAR2 |
200 |
SPONSOR_TYPE |
Sponsor type associated with the record. |
VARCHAR2 |
100 |
SPONSOR_TYPE_CODE |
Code identifying sponsor type. |
VARCHAR2 |
3 |
STATE |
State associated with the record. |
VARCHAR2 |
30 |
UEI |
Uei associated with the record. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |