Reporting Database Dependencies

Purpose

Document the setup of the database to handle reporting.

mdTransit Reporting Real Estate Reporting
sequences:
  • MDW_UTIL.mdw_util_seq
tables:
  • MDW_UTIL.LOG_OBJECT
  • MDW_UTIL.LOG_OBJECT_ATTRIBUTE
  • MDW_UTIL.PLACEMENT_CODE
  • MDW_UTIL.OBJECT_CODE
  • MDW_UTIL.CUSTOM_TRACKING_ITEM
  • MDW_UTIL.TRANSIT_REPORT
procedures:
  • MDW_UTIL.GET_NUMERIC_VALUE
  • MDW_UTIL.GET_DATE_VALUE
packages:
  • MDW_UTIL.TRANSIT_REPORT_PKG
data:
  • MDTRANSIT YMMT category codesets
  • PLACEMENT_CODES
sequences:
  • MDW_REPORT.MDW_REPORT_SEQ
tables:
  • MDW_REPORT.LOG_OBJECT
  • MDW_REPORT.LOG_OBJECT_ATTRIBUTE
  • MDW_REPORT.PLACEMENT_CODE
  • MDW_REPORT.OBJECT_CODE
  • MDW_REPORT.TRACKING_ITEM
procedures:
  • MDW_REPORT.GET_TRACKING_ITEM_PARENT_CHAIN
  • MDW_UTIL.GET_NUMERIC_VALUE
  • MDW_UTIL.GET_DATE_VALUE
packages:
  • none
data:
  • none (assuming that the product team will insert necessary configuration records)