Database

Name

INSNZP01_CL

Description

SDS1 Customer Layer Insight Layer

Tables
Schema Name Type
CLPADM CFG_PROCESS_CONTROL_NZ TABLE
CLPADM DIM_CMDM_GROUP_AWARE_FLAG TABLE
CLPADM DIM_CMDM_H_GROUP_AWARE_FLAG TABLE
CLPADM DIM_CUST_ACCOUNT_LINKAGE TABLE
CLPADM DIM_CUST_ACTIVITY_MASTER_LEADS TABLE
CLPADM DIM_CUST_BANK_BRANCH_LOCATION TABLE
CLPADM DIM_CUST_BANK_FACILITY_REF TABLE
CLPADM DIM_CUST_BANK_INTEGRATED_OFFER TABLE
CLPADM DIM_CUST_BANK_IO_AUDIT_REPORT TABLE
CLPADM DIM_CUST_BANK_IO_COMPLIANCE_REPORT TABLE
CLPADM DIM_CUST_BANK_IO_ELIGIBILITY_REPORT TABLE
CLPADM DIM_CUST_BANK_IO_PAYMENT_DELAYED_REPORT TABLE
CLPADM DIM_CUST_BANK_IO_UPTAKE_REPORT TABLE
CLPADM DIM_CUST_BRAND_CUST TABLE
CLPADM DIM_CUST_BRAND_CUST_ADDR TABLE
CLPADM DIM_CUST_BRAND_CUST_CONSENT TABLE
CLPADM DIM_CUST_BRAND_CUST_EMAIL TABLE
CLPADM DIM_CUST_BRAND_CUST_PHONE TABLE
CLPADM DIM_CUST_CDA_SEGMENT TABLE
CLPADM DIM_CUST_CDA_SEGMENT_REF TABLE
CLPADM DIM_CUST_COMPANY_CUST_RSHIP TABLE
CLPADM DIM_CUST_CONNECTED_CUSTOMER TABLE
CLPADM DIM_CUST_CUSTOMER_ROLE TABLE
CLPADM DIM_CUST_CUST_TO_PRODUCT_REL TABLE
CLPADM DIM_CUST_DNB_DUNS_MASTER TABLE
CLPADM DIM_CUST_GCIS_CUST TABLE
CLPADM DIM_CUST_GCIS_CUST_ADDR TABLE
CLPADM DIM_CUST_GCIS_CUST_CONSENT TABLE
CLPADM DIM_CUST_GCIS_CUST_CONSENT_DTL TABLE
CLPADM DIM_CUST_GCIS_CUST_EMAIL TABLE
CLPADM DIM_CUST_GCIS_CUST_PHONE TABLE
CLPADM DIM_CUST_GROUP_CUST TABLE
CLPADM DIM_CUST_GROUP_CUST_ADDR TABLE
CLPADM DIM_CUST_H_ACTIVITY_COMMENTS TABLE
CLPADM DIM_CUST_H_ACTIVITY_MASTER_LEADS TABLE
CLPADM DIM_CUST_H_BRAND_CUST TABLE
CLPADM DIM_CUST_H_BRAND_CUST_ADDR TABLE
CLPADM DIM_CUST_H_BRAND_CUST_CONSENT TABLE
CLPADM DIM_CUST_H_BRAND_CUST_EMAIL TABLE
CLPADM DIM_CUST_H_BRAND_CUST_PHONE TABLE
CLPADM DIM_CUST_H_COMPANY_CUST_RSHIP TABLE
CLPADM DIM_CUST_H_CONNECTED_CUSTOMER TABLE
CLPADM DIM_CUST_H_CUST_TO_PRODUCT_REL TABLE
CLPADM DIM_CUST_H_GCIS_CUST TABLE
CLPADM DIM_CUST_H_GCIS_CUST_ADDR TABLE
CLPADM DIM_CUST_H_GCIS_CUST_CONSENT TABLE
CLPADM DIM_CUST_H_GCIS_CUST_CONSENT_DTL TABLE
CLPADM DIM_CUST_H_GCIS_CUST_EMAIL TABLE
CLPADM DIM_CUST_H_GCIS_CUST_PHONE TABLE
CLPADM DIM_CUST_H_GROUP_CUST TABLE
CLPADM DIM_CUST_H_GROUP_CUST_ADDR TABLE
CLPADM DIM_CUST_H_PRODUCT TABLE
CLPADM DIM_CUST_H_PRODUCT_CATEGORY TABLE
CLPADM DIM_CUST_H_PRODUCT_SEGMENT_GROUP TABLE
CLPADM DIM_CUST_H_SOURCE_CUST TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_ADDR TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_APR TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_ASL TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_BPR TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_CIS TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_CLMS TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_CMP TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_EMP TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_GPI TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_HOG TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_IDPS TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_MTL TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_NIB TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_NPR TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_AUX_RTH TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_CONSENT TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_EMAIL TABLE
CLPADM DIM_CUST_H_SOURCE_CUST_PHONE TABLE
CLPADM DIM_CUST_NSPK_ACCOUNTS TABLE
CLPADM DIM_CUST_NSPK_CUSTOMER TABLE
CLPADM DIM_CUST_NSPK_SERVICES TABLE
CLPADM DIM_CUST_PRODUCT TABLE
CLPADM DIM_CUST_PRODUCT_CATEGORY TABLE
CLPADM DIM_CUST_PRODUCT_SEGMENT_GROUP TABLE
CLPADM DIM_CUST_REWARD_PROFILE TABLE
CLPADM DIM_CUST_REWARD_REGISTRATION TABLE
CLPADM DIM_CUST_SOURCE_CUST TABLE
CLPADM DIM_CUST_SOURCE_CUST_ADDR TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_APR TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_ASL TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_BPR TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_CIS TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_CLMS TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_CMP TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_EMP TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_GPI TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_HOG TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_IDPS TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_MTL TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_NIB TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_NPR TABLE
CLPADM DIM_CUST_SOURCE_CUST_AUX_RTH TABLE
CLPADM DIM_CUST_SOURCE_CUST_CONSENT TABLE
CLPADM DIM_CUST_SOURCE_CUST_EMAIL TABLE
CLPADM DIM_CUST_SOURCE_CUST_PHONE TABLE
CLPADM DIM_PRODUCT_CATEGORISATION_MAPPING TABLE
CLPADM DIM_SDW_CLMS_MIGRATED_PH TABLE
CLPADM FCT_CALL_INSIGHT TABLE
CLPADM FCT_CI_MOTOR_CLAIMANT_SATISFACTION TABLE
CLPADM FCT_CMPGN_EXTERNAL_CONTACT_HISTORY TABLE
CLPADM FCT_CMPGN_RESPONSE_STATUS TABLE
CLPADM FCT_COMPLAINTS_INSIGHT TABLE
CLPADM FCT_CUST_ACTIVE_PROFILE_OCID_MAPPING TABLE
CLPADM FCT_CUST_APRA_ESTABLISHED_CUSTOMER TABLE
CLPADM FCT_CUST_BANK_INTEGRATED_OFFER TABLE
CLPADM FCT_CUST_BRAND_CONSOLIDATION_INSIGHT TABLE
CLPADM FCT_CUST_BRAND_CUSTOMER_CONSENT_INSIGHT TABLE
CLPADM FCT_CUST_CLAIM_PROPERTY_CI TABLE
CLPADM FCT_CUST_CRLGC_CLLTRL_LISTINGS TABLE
CLPADM FCT_CUST_CRLGC_CLLTRL_LISTINGS_HIST TABLE
CLPADM FCT_CUST_CRLGC_CLLTRL_PTL TABLE
CLPADM FCT_CUST_CRLGC_CLLTRL_PTL_HIST TABLE
CLPADM FCT_CUST_CRLGC_CLLTRL_SALES TABLE
CLPADM FCT_CUST_CRLGC_CLLTRL_SALES_HIST TABLE
CLPADM FCT_CUST_CRLGC_HOME_INS_LISTINGS TABLE
CLPADM FCT_CUST_CRLGC_HOME_INS_LISTINGS_HIST TABLE
CLPADM FCT_CUST_CRLGC_HOME_INS_SALES TABLE
CLPADM FCT_CUST_CRLGC_HOME_INS_SALES_HIST TABLE
CLPADM FCT_CUST_CTP_INSURANCE_PH TABLE
CLPADM FCT_CUST_DEPOSIT_PH TABLE
CLPADM FCT_CUST_HEALTH_PH TABLE
CLPADM FCT_CUST_H_DOMICILE_MASTER TABLE
CLPADM FCT_CUST_INS_PAYMENT_REPRIEVE_DISCOUNT TABLE
CLPADM FCT_CUST_LOAN_ACCT_TXN TABLE
CLPADM FCT_CUST_LOAN_PH TABLE
CLPADM FCT_CUST_MARGIN_LENDING_PH TABLE
CLPADM FCT_CUST_MPD_COUNT TABLE
CLPADM FCT_CUST_PRODUCT_COMMERCIAL_INSURANCE_PH TABLE
CLPADM FCT_CUST_PRODUCT_HOLDING TABLE
CLPADM FCT_CUST_RESPONSYS_GCIS_BANK_PET TABLE
CLPADM FCT_CUST_RESPONSYS_GCIS_CTP_INS_PET TABLE
CLPADM FCT_CUST_RESPONSYS_GCIS_CUSTOMER_PROFILE TABLE
CLPADM FCT_CUST_RESPONSYS_GCIS_HOME_INS_PET TABLE
CLPADM FCT_CUST_RESPONSYS_GCIS_MODEL_PET TABLE
CLPADM FCT_CUST_RESPONSYS_GCIS_MOTOR_INS_PET TABLE
CLPADM FCT_CUST_RESPONSYS_GCIS_SEGMENT_PET TABLE
CLPADM FCT_CUST_REWARD_TRANSACTION TABLE
CLPADM FCT_CUST_TREASURY_PH TABLE
CLPADM FCT_CUST_WRKER_COMPNSTN_PH TABLE
CLPADM FCT_VOC_CUST_INITIATED_TRANSACTIONS TABLE
CLPADM FCT_VOC_HR_INSIGHTS TABLE
CLPADM FCT_VOC_INQUBA_SURVEY_REF_ALL TABLE
CLPADM FCT_VOC_INQUBA_SURVEY_REF_NZ TABLE
CLPADM FCT_VOC_INQUBA_SURVEY_RESPONSES_ALL TABLE
CLPADM FCT_VOC_INQUBA_SURVEY_RESPONSES_NZ TABLE
CLPADM FCT_VOC_INQUBA_SURV_REF TABLE
CLPADM FCT_VOC_INQUBA_SURV_RESPONSES_DETAIL TABLE
CLPADM FCT_VOC_INQUBA_SURV_RESPONSES_HEADER TABLE
CLPADM FCT_VOC_SUMMARY TABLE
CLPADM INT_CUST_SHANNON_RSA_REF TABLE
CLPADM MAIL_NOTIFICATION_PARAMETERS TABLE
CLPADM MCFD_CLAIM_CONTACT TABLE
CLPADM MCFD_CLAIM_LODGEMENT TABLE
CLPADM MCFD_CLAIM_SETTLEMENT_HOME_PI TABLE
CLPADM MCFD_CLAIM_SETTLEMENT_MOTOR_PI TABLE
CLPADM MCFD_CLAIM_USER TABLE
CLPADM MCFD_UNC_AUDIT TABLE
CLPADM TBL_CTAS_PARAM TABLE
CLPADM TEST11 TABLE
CLPADM USR_SPROUT_CUSTOMER_LOGIN_DATA TABLE
CLPADM USR_SPROUT_CUSTOMER_LOGIN_DATA_BKP TABLE