Database

Host

netezzaprd04

Name

INSNZP01_R12

Description

Edit
Tables
Schema Name Type
R12PADM AUDIT_EXPENSES_DATA_LOAD_INSIGHT TABLE
R12PADM CFG_PROCESS_CONTROL_NZ TABLE
R12PADM DIM_CFO_HR_FTE_EMPLOYEE_TYPE TABLE
R12PADM DIM_COST_CENTRE_TYPES TABLE
R12PADM DIM_FIN_MASTER_ACCOUNTS VIEW
R12PADM DIM_FIN_MASTER_ACTIVITY_CENTRE VIEW
R12PADM DIM_FIN_MASTER_CATEGORY VIEW
R12PADM DIM_FIN_MASTER_CHANNEL VIEW
R12PADM DIM_FIN_MASTER_CLASS VIEW
R12PADM DIM_FIN_MASTER_ENTITY VIEW
R12PADM DIM_FIN_MASTER_INTERCOMPANY VIEW
R12PADM DIM_FIN_MASTER_PRODUCT VIEW
R12PADM DIM_FIN_MASTER_PROJECT VIEW
R12PADM DIM_FIN_MASTER_SPARE VIEW
R12PADM DIM_FIN_MASTER_STATE VIEW
R12PADM DIM_GL_ACCOUNTS TABLE
R12PADM DIM_GL_ACCOUNTS_ADB_BANK VIEW
R12PADM DIM_GL_ACCOUNTS_BANK TABLE
R12PADM DIM_GL_ACCOUNT_BDW TABLE
R12PADM DIM_GL_ACCOUNT_HIERARCHY_BDW TABLE
R12PADM DIM_GL_ACCOUNT_HIERARCHY_HISTORY_BDW TABLE
R12PADM DIM_GL_ACTIVITY_CENTRE TABLE
R12PADM DIM_GL_ACTIVITY_CENTRE_BANK TABLE
R12PADM DIM_GL_ACTIVITY_CENTRE_OLD TABLE
R12PADM DIM_GL_ALL_TIME_BDW TABLE
R12PADM DIM_GL_CATEGORY TABLE
R12PADM DIM_GL_CATEGORY_BDW TABLE
R12PADM DIM_GL_CATEGORY_HIERARCHY_BDW TABLE
R12PADM DIM_GL_CATEGORY_HIERARCHY_HISTORY_BDW TABLE
R12PADM DIM_GL_CHANNEL TABLE
R12PADM DIM_GL_CHANNEL_BANK TABLE
R12PADM DIM_GL_CLASS TABLE
R12PADM DIM_GL_COST_CENTRE_BDW TABLE
R12PADM DIM_GL_COST_CENTRE_HIERARCHY_BDW TABLE
R12PADM DIM_GL_COST_CENTRE_HIERARCHY_HISTORY_BDW TABLE
R12PADM DIM_GL_ENTITY TABLE
R12PADM DIM_GL_ENTITY_BANK TABLE
R12PADM DIM_GL_ENTITY_BDW TABLE
R12PADM DIM_GL_ENTITY_HIERARCHY_BDW TABLE
R12PADM DIM_GL_ENTITY_HIERARCHY_HISTORY_BDW TABLE
R12PADM DIM_GL_INTERCOMPANY TABLE
R12PADM DIM_GL_INTERCOMPANY_BDW TABLE
R12PADM DIM_GL_INTERCOMPANY_HIERARCHY_BDW TABLE
R12PADM DIM_GL_INTERCOMPANY_HIERARCHY_HISTORY_BDW TABLE
R12PADM DIM_GL_PRODUCT TABLE
R12PADM DIM_GL_PRODUCT_BANK TABLE
R12PADM DIM_GL_PRODUCT_BDW TABLE
R12PADM DIM_GL_PRODUCT_HIERARCHY_BDW TABLE
R12PADM DIM_GL_PRODUCT_HIERARCHY_HISTORY_BDW TABLE
R12PADM DIM_GL_PROJECT TABLE
R12PADM DIM_GL_RECON_BDW_V VIEW
R12PADM DIM_GL_RSAGL_CV01_MAP_HEADERS_BDW TABLE
R12PADM DIM_GL_RSAGL_CV01_MAP_LINES_BDW TABLE
R12PADM DIM_GL_SET_OF_BOOKS TABLE
R12PADM DIM_GL_SET_OF_BOOKS_BDW TABLE
R12PADM DIM_GL_SPARE TABLE
R12PADM DIM_GL_STATE TABLE
R12PADM DIM_GL_STATE_BANK TABLE
R12PADM DIM_MASTER_HIERARCHY VIEW
R12PADM DIM_MASTER_HIERARCHY_INSIGHT_BS_PL TABLE
R12PADM DIM_MASTER_HIERARCHY_INSIGHT_OPX000 TABLE
R12PADM DIM_MASTER_HIERARCHY_INSIGHT_TSCC TABLE
R12PADM DIM_OEB_ACCOUNT_HIERARCHY_OPX000 TABLE
R12PADM DIM_OEB_ACCOUNT_HIERARCHY_OPX000_HR_V VIEW
R12PADM DIM_OEB_ACCOUNT_HIERARCHY_OPXATT TABLE
R12PADM DIM_OEB_CATEGORY TABLE
R12PADM DIM_OEB_COST_CENTRE_HIERARCHY_TSCC TABLE
R12PADM DIM_OEB_COST_CENTRE_HIERARCHY_TSCC_HR_V VIEW
R12PADM DIM_OEB_COST_CENTRE_HIERARCHY_TSCC_OLD TABLE
R12PADM DIM_OEB_COST_CENTRE_LEVELS_TSCC VIEW
R12PADM DIM_OEB_COST_CENTRE_TSCC TABLE
R12PADM DIM_OEB_CURRENCY TABLE
R12PADM DIM_OEB_GL_PERIOD TABLE
R12PADM DIM_OEB_ITEMS VIEW
R12PADM DIM_OEB_PERIOD TABLE
R12PADM DIM_OEB_PERIOD_HIST TABLE
R12PADM DIM_OEB_PROCUREMENT_PERIOD TABLE
R12PADM DIM_OEB_PROCUREMENT_PERIOD_X9 VIEW
R12PADM DIM_OEB_PROJECT_HIERARCHY_T TABLE
R12PADM DIM_OEB_PSTREE_HIERARCHY_CFDM_INSIGHT TABLE
R12PADM DIM_OEB_PSTREE_HIERARCHY_EXCEPTION_CFDM_INSIGHT TABLE
R12PADM DIM_OEB_PSTREE_HIERARCHY_LOOKUP_CFDM_INSIGHT TABLE
R12PADM DIM_SECURITY TABLE
R12PADM DIM_SPEND_TYPE VIEW
R12PADM DIM_TOTAL_BUYING_CHANNEL_COMMITMENT TABLE
R12PADM DIM_TOTAL_BUYING_CHANNEL_COMMITMENT_V VIEW
R12PADM FCT_CFO_HR_FTE_AGG1_INSIGHT TABLE
R12PADM FCT_CFO_HR_FTE_AGG_INSIGHT TABLE
R12PADM FCT_CFO_HR_FTE_ICARE_INSIGHT VIEW
R12PADM FCT_CFO_HR_FTE_INSIGHT TABLE
R12PADM FCT_CFO_HR_FTE_INSIGHT_330 TABLE
R12PADM FCT_CFO_HR_FTE_INSIGHT_330_BK0906 TABLE
R12PADM FCT_CFO_HR_FTE_INSIGHT_330_BK1709 TABLE
R12PADM FCT_CFO_HR_FTE_INSIGHT_BK0906 TABLE
R12PADM FCT_CFO_HR_FTE_INSIGHT_BK1709 TABLE
R12PADM FCT_CFO_HR_FTE_MOVEMENT_HIST_INSIGHT VIEW
R12PADM FCT_CFO_HR_FTE_SUMMARY_HIST_INSIGHT VIEW
R12PADM FCT_CFO_HR_LEAVE_HIST_INSIGHT VIEW
R12PADM FCT_CFO_TRANSFER_PRICING_INSIGHT TABLE
R12PADM FCT_CFO_TRANSFER_PRICING_INSIGHT_20210701 TABLE
R12PADM FCT_CFO_TRANSFER_PRICING_INSIGHT_INCOMING_20210531012654 TABLE
R12PADM FCT_CFO_TRANSFER_PRICING_INSIGHT_INCOMING_20210609012626 TABLE
R12PADM FCT_CFO_TRANSFER_PRICING_INSIGHT_INCOMING_20210701011815 TABLE
R12PADM FCT_CFO_TRANSFER_PRICING_INSIGHT_INCOMING_20210701020950 TABLE
R12PADM FCT_CFO_TRANSFER_PRICING_INSIGHT_INCOMING_20210701034150 TABLE
R12PADM FCT_CFO_TRANSFER_PRICING_INSIGHT_INCOMING_20210701062349 TABLE
R12PADM FCT_EMP_CATEGORISED_METRICS TABLE
R12PADM FCT_EMP_EXPENSE_AMEX_AGING_T TABLE
R12PADM FCT_EMP_EXPENSE_AMEX_AGING_T_BKUP_270319 TABLE
R12PADM FCT_EMP_EXPENSE_AMEX_AGING_T_TAL TABLE
R12PADM FCT_EMP_UNRECONCILED_AMEX TABLE
R12PADM FCT_EMP_UNRECONCILED_AMEX_V VIEW
R12PADM FCT_FIN_GINZ_GL_TRANSACTION_DETAIL_V VIEW
R12PADM FCT_FIN_GINZ_GL_TRANSACTION_SUMMARY_V VIEW
R12PADM FCT_FIN_MASTER_ATTRIBUTIONS VIEW
R12PADM FCT_FIN_MASTER_GL_BALANCES VIEW
R12PADM FCT_FIN_MASTER_TRANSACTION VIEW
R12PADM FCT_GL_AVG_DAILY_BALANCE_MEASURES_RRR_INSIGHT TABLE
R12PADM FCT_GL_PINNACLE_COMPARISON_SUMMARY VIEW
R12PADM FCT_GL_TRANSACTION_LISTING_MONTHLY_INSIGHT VIEW
R12PADM FCT_OEB_BANK_GL_BALANCE_MEASURES_BDW TABLE
R12PADM FCT_OEB_BANK_GL_BALANCE_MEASURES_PIVOT_RRR_INSIGHT TABLE
R12PADM FCT_OEB_BANK_GL_BALANCE_MEASURES_RRR_INSIGHT VIEW
R12PADM FCT_OEB_BANK_GL_BAL_MSR_BATCH_CTRL_BDW_INSIGHT VIEW
R12PADM FCT_OEB_BANK_GL_INTEREST_RATE_MEASURES_HIST_INSIGHT_V VIEW
R12PADM FCT_OEB_BANK_GL_INTEREST_RATE_MEASURES_INSIGHT_V VIEW
R12PADM FCT_OEB_BANK_GL_MEASURES_BALANCES_HIST_INSIGHT TABLE
R12PADM FCT_OEB_BANK_GL_MEASURES_BALANCES_INSIGHT TABLE
R12PADM FCT_OEB_BANK_GL_MEASURES_RECON_BDW TABLE
R12PADM FCT_OEB_CLAIMS_INVOICES_INSIGHT VIEW
R12PADM FCT_OEB_EXPENSE_BALANCE_AGG_INSIGHT VIEW
R12PADM FCT_OEB_EXPENSE_BALANCE_INSIGHT VIEW
R12PADM FCT_OEB_EXPENSE_TRANSACTION_INSIGHT VIEW
R12PADM FCT_OEB_GL_MEASURES_BALANCES_AGGREGATE TABLE
R12PADM FCT_OEB_GL_MEASURES_BALANCES_INSIGHT TABLE
R12PADM FCT_OEB_INDIRECT_LEGAL_PAYMENTS_INSIGHT TABLE
R12PADM FCT_OEB_PROCUREMENT_AGG1_INSIGHT TABLE
R12PADM FCT_OEB_PROCUREMENT_AGG1_INSIGHT_V VIEW
R12PADM FCT_OEB_PROCUREMENT_AGG_INSIGHT TABLE
R12PADM FCT_OEB_PROCUREMENT_AGG_INSIGHT_V VIEW
R12PADM FCT_OEB_PROCUREMENT_INSIGHT TABLE
R12PADM FCT_SOURCE_TABLE_HEALTH_CHECK_INSIGHT VIEW
R12PADM FCT_SUSTAINABILITY_EMISSIONS_FTE TABLE
R12PADM FCT_SUSTAINABILITY_EMISSIONS_FTE_V VIEW
R12PADM FCT_TRVL_CREDITS_ON_HOLD_V VIEW
R12PADM FCT_TRVL_TAL_V VIEW
R12PADM FCT_TRVL_V VIEW
R12PADM INT_EMP_CATEGORISE2 TABLE
R12PADM INT_EMP_CATEGORISE2_V VIEW
R12PADM INT_EMP_CATEGORISE3 TABLE
R12PADM INT_EMP_CATEGORISE3_V VIEW
R12PADM INT_SUSTAINABILITY_EMISSIONS_FTE TABLE
R12PADM INT_SUSTAINABILITY_EMISSIONS_FTE_V VIEW
R12PADM OEB_DIM_BV_SEGMENT_HIERARCHY_ACTUAL TABLE
R12PADM OEB_DIM_BV_SEGMENT_LIST_ACTUAL TABLE
R12PADM OEB_FND_FLEX_VALUES VIEW
R12PADM OEB_FND_FLEX_VALUES_TL VIEW
R12PADM OEB_FND_LOOKUP_VALUES VIEW
R12PADM OEB_GL_BALANCES_B VIEW
R12PADM OEB_GL_CODE_COMBINATIONS_B VIEW
R12PADM OEB_GL_DAILY_RATES VIEW
R12PADM OEB_GL_JE_HEADERS_B VIEW
R12PADM OEB_GL_JE_LINES_B VIEW
R12PADM RSAGL_CV01_MAP_HEADERS VIEW
R12PADM RSAGL_CV01_MAP_LINES VIEW
R12PADM TBL_CTAS_PARAM TABLE
R12PADM TBL_CTAS_PARAM_BK_2204 TABLE
R12PADM TM1_MASTER_HIERARCHY TABLE