SPONSOR HIERARCHY FP HISTORY Table
View exposing fiscal-period sponsor hierarchy history including sponsor fiscal-period key, hierarchy name, fiscal period, sponsor identifiers, multi-level category and sort values, sponsor attributes, 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 |
40 |
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 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
6 |
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. |
VARCHAR2 |
6 |
SPONSOR_ACRONYM |
Sponsor acronym associated with the record. |
VARCHAR2 |
10 |
SPONSOR_CODE |
Code identifying sponsor. |
VARCHAR2 |
6 |
SPONSOR_FP_KEY |
Surrogate key identifying the sponsor fp. |
VARCHAR2 |
14 |
SPONSOR_KEY |
Surrogate key identifying the sponsor. |
VARCHAR2 |
10 |
SPONSOR_NAME |
Sponsor name associated with the person or organization. |
VARCHAR2 |
200 |
SPONSOR_TYPE |
Sponsor type associated with the record. |
VARCHAR2 |
40 |
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 |
|
SP_LEVEL4_CATEGORY |
Sp level4 category associated with the record. |
VARCHAR2 |
50 |
SP_LEVEL4_SORT |
Sp level4 sort associated with the record. |
NUMBER |
|
SP_LEVEL5_CATEGORY |
Sp level5 category associated with the record. |
VARCHAR2 |
50 |
SP_LEVEL5_SORT |
Sp level5 sort associated with the record. |
NUMBER |
|
STATE |
State associated with the record. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |