Sales station Datamodel Table List SL NO Table Name Type Description Frequency Version Remarks 1 AQUISATION_FACT Fact Table Daliy/Monthly 2 PORTFOLIO_ACCOUNT_FACT Fact Table Daliy/Monthly 3 PORTFOLIO_CUSTOMER_FACT Fact Table Daliy/Monthly 4 INSURANCE_FACT Fact Table Daliy/Monthly 5 INVESTMENT_FACT Fact Table Daliy/Monthly 6 RM_PORTFOLIO_CUBE CUBE Used by Reports and Dashboard 7 DIM_ACCOUNT_STATUS Dimention Table 8 DIM_CHANNEL Dimention Table 9 DIM_PRODUCT Dimention Table 10 DIM_TIME Dimention Table 11 DIM_CLIENT_SEGMENT Dimention Table 12 DIM_CURRENCY Dimention Table 13 DIM_PRODUCT_HIERARCHY Dimention Table 14 DIM_TENOR_BAND Dimention Table 15 SSD_USER User Upload Tables Monthly Data is uploaded by the Business from front end, every month end. 16 SSD_RCAO_MAPPING User Upload Tables Monthly Data is uploaded by the Business from front end, every month end. 17 SSD_BRANCH User Upload Tables Monthly Data is uploaded by the Business from front end, every month end. 18 SSD_USER_SUPERVISOR User Upload Tables Monthly Data is uploaded by the Business from front end, every month end. 19 RESULT_TABLE KPI 20 SSI_KPI_GOAL_VALUE_TMP        KPI 21 SSI_KPI_GOAL_VALUE_AUDIT      KPI 22 SSI_KPI_GOAL_VALUE_DROOLS     KPI 23 SSI_KPI_GOAL_VALUE_ROLLUP KPI 24 SSI_RM_CUST_LINK KPI