8.2 Hierarchies for Materialized View
Hierarchies for Account Dimension Materialized View
Table 8-1 List of hierarchies for Account Dimension Materialized View
| HCY Code | DIM Table | Hierarchy Name |
|---|---|---|
| HCRA024 | DIM_RUN | FIC_MIS_DATE |
| HCRA0004 | DIM_STANDARD_PARTY_TYPE | V_STANDARD_PARTY_TYPE_DESC |
| HCRA0010 | DIM_STANDARD_PRODUCT_TYPE | v_standard_product_type_desc |
| HCRA0011 | DIM_Product | v_prod_desc |
| HCRA0016 | DIM_LOB | V_LINE_OF_BUSINESS_DESC |
| HCRA0002 | DIM_CURRENCY | v_currency_name |
| HCRA0009 | DIM_PRODUCT_TYPE | v_acct_prod_type_desc |
| HCRA0022 | DIM_DELQ_BAND | V_BAND_SHORT_DESC |
| HCRA0025 | DIM_ORG_STRUCTURE | V_ENTITY_CODE |
| HCRA0026 | DIM_INDUSTRY | V_D_INDUSTRY_DESC |
| HCRA0014 | DIM_CREDIT_STATUS | V_CREDIT_STATUS_DESC |
| HCRA0028 | DIM_AGE_BOOK_BAND | V_BAND_SHORT_DESC |
| HCRA0043 | DIM_ACCT_INSURED | V_FLAG_CODE |
| HCRA0044 | DIM_EVER_30_DELQ | V_FLAG_DESC |
| HCRA0045 | DIM_EVER_60_DELQ | V_FLAG_DESC |
| HCRA0046 | DIM_EVER_90_DELQ | V_FLAG_DESC |
| HCRA0047 | DIM_EVER_X_DELQ | V_FLAG_DESC |
| HCRA0048 | DIM_STD_CREDIT_LINE_TYPE | V_STD_CREDIT_LINE_TYPE_DESC |
| HCRA0020 | DIM_WHOLESALE_RETAIL_CATEGORY | V_WHOLESALE_RETAIL_DESC |
| HCRA0049 | DIM_CHANNEL | V_CHANNEL_DESC |
| HCRA0050 | DIM_LOAN_PURPOSE | V_LOAN_PURPOSE_DESC |
| HCRA0051 | DIM_UTILIZATION_BAND | V_BAND_SHORT_DESC |
| HCRA0062 | DIM_MORTGAGE_OCCUPANCY | V_MORTGAGE_OCCUPANY_DESC |
| HCRA0067 | DIM_PREPAY_IND_FLAG | V_FLAG_DESC |
| HCRA0074 | DIM_INDICATOR_VALUES | V_INDICATOR_VALUE_DESCRIPTION |
| HCRA0029 | DIM_ORG_UNIT | V_ORG_UNIT_CODE |
| HCRA0064 | DIM_STD_COUNTRY_DIVISION | V_STD_DIVISION_DESCRIPTION |
| HCRA0065 | DIM_STD_COUNTRY_REGION | V_STD_REGION_DESCRIPTION |
| HCRA0075 |
Hierarchies for Application Materialized View
Table 8-2 List of hierarchies for Application Materialized View
| HCY Code | DIM Table | Hierarchy Name |
|---|---|---|
| HCRA0011 | DIM_Product | v_prod_desc |
| HCRA0054 | DIM_DATES | N_DATE_SKEY |
| HCRA0057 | DIM_APPROVED_DATE | N_DATE_SKEY |
| HCRA0049 | DIM_CHANNEL | V_CHANNEL_DESC |
| HCRA0063 | DIM_APP_FUND_DATE | D_CALENDAR_DATE |
| HCRA0070 | DIM_SUBMITTED_DATE | N_DATE_SKEY |
| HCRA0072 | DIM_MAX_ORG_BEACON_SCORE_RANGE | V_BAND_SHORT_DESC |
| HCRA0073 | DIM_REV_BEACON_SCORE_RANGE | V_BAND_SHORT_DESC |
| HCRA0056 | DIM_LOCATION | V_LOCATION_DESC |
| HCRA0059 | DIM_APPRAISAL_TYPE | V_APPRAISAL_TYPE_DESC |
| HCRA0061 | DIM_APPLICATION_TYPE | V_APPLN_TYPE_DESC |
| HCRA0068 | ||
| HCRA0069 | ||
| HCRA0071 |