保險行業(yè)的bi分析模型ppt(編輯修改稿)
2025-02-16 02:36 本頁面
【文章內(nèi)容簡介】 MEASURE_UNIT_ID fk INTEGER COR_RPT_STRC_ID pk,fk INTEGER GEO_ID pk,fk INTEGER MEASURE_UNIT_ID pk,fk INTEGER FNCL_SCOR_ID pk,fk INTEGER LANGUAGE_ID pk,fk INTEGER PN_BHVR_SCOR_ID pk,fk INTEGER PRODUCT_ID pk,fk INTEGER DEMO_ID pk,fk INTEGER ENTY_ID pk,fk INTEGER V_E_ENTY_ID fk INTEGER COR_EVT_TXN_SEQ_NB pk NUMBER PRD_ID fk INTEGER AMOUNT NUMBER D_CORE_EVT_TYP EVT_TYP_ID pk INTEGER EVT_TYP_SHRT_NAM VARCHAR(15) EVT_TYP_LONG_NAM VARCHAR(35) EVT_TYP_SUBTYP_NAM VARCHAR(15) D_CORE_RPT_STRC COR_RPT_STRC_ID pk INTEGER HOLDING_COMPANY VARCHAR(35) ORG_TYPE VARCHAR(20) ORG_NAME VARCHAR(35) REGION VARCHAR(20) SALES_TEAM_TYPE VARCHAR(15) SALES_TEAM VARCHAR(15) SALES_PERSON_NAME char SALES_PERSON_GRADE CHAR SALES_PERSON_TYPE CHAR CHNL_CATEGORY1 char(18) CHNL_TYPE CHAR CHNL_SUBCAT CHAR CHNL_NAME char CHNL_CEASED_TRD_DT DATE CHNL_ENTY_ID INTEGER CHNL_CITY VARCHAR(20) CHNL_POSTCODE VARCHAR(20) BEGIN_DATE_PRD_ID INTEGER END_DATE_PRD_ID INTEGER D_GEOGRAPHY GEO_ID pk INTEGER ALL_ENTRIES CHAR POSTAL_CODE CHAR VARYING(15) CITY char POSTAL_CD_PFX char(3) HZRD_WTHR_AREA CHAR HZD_WTHR_TYPE CHAR DMA_CODE CHAR SMSA_CODE CHAR ST_PROV_AREA CHAR TV_REGION CHAR NTL_RADIO_AREA CHAR LCL_RADIO_AREA CHAR REGION CHAR COUNTRY char(3) CONTINENTY_ABBR char(3) GEO_SUB_CNTNT_ABBR char(3) SMRY_EFF_DT INTEGER SMRY_END_DT INTEGER PRISN_ADRS_IND CHAR D_MSR_UNIT MEASURE_UNIT_ID pk INTEGER SHRT_DESC char(6) LONG_DESC char(20) D_DEMOGRAPHICS DEMO_ID pk INTEGER ALL_ENTRIES CHAR INCOME_BAND VARCHAR(50) AGE_BAND VARCHAR(50) GNDR CHAR MRTL_STAT CHAR HIGH_VALUE_INDICAT CHAR ACMDTN_CTGRY CHAR NBR_IN_HH_BAND VARCHAR(50) CHLD_AT_HOME_BAND VARCHAR(50) SIZE_CLS CHAR LEGAL_ORG_TYPE CHAR NBR_EMP_BAND VARCHAR(50) SECTOR_CLS CHAR MAIL_PRMSN_IND CHAR TELMKT_PRMSN_IND CHAR D_FNCL_SCOR FNCL_SCORES_ID pk INTEGER INTERNAL_FNCL_SCOR VARCHAR(50) EXPERIAN_SCOR_BAND VARCHAR(50) SCOR_N_BAND VARCHAR(50) PRFT_IND_BAND VARCHAR(50) DEBT_INCOME_RATIO NUMBER D_LANGUAGE LANGUAGE_ID pk INTEGER ISO_LANG_CODE CHAR ISO_LANG_NAME char LANG_GROUP VARCHAR(20) D_PN_BHVR_SCOR PN_BHVR_SCOR_ID pk INTEGER SCORE1_BAND VARCHAR(20) SCORE_N_BAND VARCHAR(20) D_PRODUCT PRODUCT_ID pk,fk INTEGER ENTY_ID fk INTEGER PRODUCT_LINE CHAR PRODUCT_GROUP CHAR PRODUCT_CODE CHAR PRODUCT_NAME CHAR PD_VARIANT_CODE CHA
教學課件相關(guān)推薦
鄂ICP備17016276號-1