SPONSOR HIERARCHY Table
View exposing sponsor hierarchy assignments for current sponsors including hierarchy name, sponsor identifiers, multi-level category and sort values, acronym, sponsor type, DUNS and CAGE attributes, address fields, Rolodex identifier, and owning unit.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
DODAC_NUMBER |
Dodac number associated with the record. |
VARCHAR2 |
20 |
DUNS_PLUS_FOUR_NUMBER |
Duns plus four number associated with the record. |
VARCHAR2 |
20 |
DUN_AND_BRADSTREET_NUMBER |
Dun and bradstreet number associated with the record. |
VARCHAR2 |
20 |
HIERARCHY_NAME |
Hierarchy name associated with the record. |
VARCHAR2 |
100 |
OWNED_BY_UNIT |
Owned by unit associated with the record. |
VARCHAR2 |
8 |
POSTAL_CODE |
Postal code associated with the record. |
VARCHAR2 |
15 |
ROLODEX_ID |
Business identifier for the rolodex. |
NUMBER |
28 |
SPONSOR_ACRONYM |
Sponsor acronym associated with the record. |
VARCHAR2 |
10 |
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 |
SP_LEVEL1_CATEGORY |
Sp level1 category associated with the record. |
VARCHAR2 |
50 |
SP_LEVEL1_SORT |
Sp level1 sort associated with the record. |
NUMBER |
|
SP_LEVEL2_CATEGORY |
Sp level2 category associated with the record. |
VARCHAR2 |
50 |
SP_LEVEL2_SORT |
Sp level2 sort associated with the record. |
NUMBER |
|
SP_LEVEL3_CATEGORY |
Sp level3 category associated with the record. |
VARCHAR2 |
50 |
SP_LEVEL3_SORT |
Sp level3 sort associated with the record. |
NUMBER |
28 |
SP_LEVEL4_CATEGORY |
Sp level4 category associated with the record. |
VARCHAR2 |
50 |
SP_LEVEL4_SORT |
Sp level4 sort associated with the record. |
NUMBER |
28 |
SP_LEVEL5_CATEGORY |
Sp level5 category associated with the record. |
VARCHAR2 |
50 |
SP_LEVEL5_SORT |
Sp level5 sort associated with the record. |
NUMBER |
28 |
STATE |
State associated with the record. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |