Tables used by DWH

Direct Sources

  • DIM_CUSTOMER_OL
  • DIM_EMPLOYEE_OL
  • DIM_EMPLOYMENT_OL
  • DIM_PROJECT_OL$
  • DIM_SUPPLIER_OL
  • FACT_BUSINESS_OPP_OL$
  • FACT_CUSTOMER_ORDER_LINE_OL$
  • FACT_PROJECT_TRANS_OL
  • QDIM_COMPANY_PERS_ASSIGN_C_OL$
  • QDIM_COMPANY_PERSON_ALL_CF_OL$
  • QFACT_ABSENCE_DETAILS_OL$
  • QFACT_ABSENCE_LIMIT_OVERVI_OL$
  • QFACT_BMT_ABSENCE_SUMMARY_IAS$
  • QFACT_BMT_ACTUAL_HOURS_BY_IAS$
  • QFACT_BMT_DWH_INVOICE_TAB_IAS$
  • QFACT_BMT_FACT_EMP_ANALYS_IAS$
  • QFACT_BMT_PROJ_CONN_OVERV_IAS$
  • QFACT_CUSTOMER_ORDER_CFV_OL$
  • QFACT_DETAIL_EXPENSE_CFV_OL$
  • QFACT_DETAIL_MILAGE_CFV_OL$
  • QFACT_EMP_JOB_ASSIGN_CFV_OL$

Indirect Sources

  • DIM_ACCOUNT_OL
  • DIM_ACTIVITY_OL
  • DIM_ANALYTIC_ATTR3_CODE_D_OL
  • DIM_CODE_B_OL
  • DIM_CODE_C_OL
  • DIM_CODE_E_OL
  • DIM_COMPANY_CUSTOMER_OL
  • DIM_EMPLOYEE_OL
  • DIM_MAIN_BUSINESS_CONTACT_OL
  • DIM_OPPORTUNITY_SOURCE_OL
  • DIM_OPPORTUNITY_TYPE_OL
  • DIM_ORGANIZATION_CODE_OL
  • DIM_PROC_TEMPLATE_STAGE_OL$
  • DIM_PROJECT_OL$
  • DIM_REPORT_CODE_OL
  • DIM_SALES_DISTRICT_OL
  • DIM_SALES_MARKET_OL
  • DIM_SALES_REGION_OL
  • DIM_WIN_LOSE_REASON_OL
  • DIM_WORK_LOCATION_OL
  • FACT_BUSINESS_OPP_LINE_OL
  • FACT_BUSINESS_OPP_OL
  • mis.Job Families
  • QDIM_EXPENSE_HEADER_CFV_OL$
  • QDIM_PERSON_INFO_OL$
  • QFACT_EMP_JOB_ASSIGN_CFV_OL$
  • QFACT_OPP_PROJECT_CLV_OL$

Leave a Comment