Technical data

Schema Change
Upgrades to the Oracle Utilities Meter Data Management Database A-3
Schema Change
New Tables
The following new tables are added to Oracle Utilities Meter Data Management V2.0.1.
Dropped Tables
None
Unsupported Tables
None
Added Columns
The following Table Columns are added to Oracle Utilities Meter Data Management V2.0.1:
• D1_COMM_TYPE :COMM_TYPE_STAT_FLG
• D1_DVC_EVT :DVC_EVT_END_DTTM
• D1_INIT_MSRMT_DATA:IMD_CTRL_DC_ID
• D1_INIT_MSRMT_DATA:IMD_CTRL_MC_ID
• D1_SP_MSRMT_CYC_SCHED_RTE:BO_STATUS_CD
• D1_SP_MSRMT_CYC_SCHED_RTE:BO_STATUS_REASON_CD
• D1_SP_MSRMT_CYC_SCHED_RTE:BUS_OBJ_CD
• D1_SP_MSRMT_CYC_SCHED_RTE:CRE_DTTM
• D1_SP_MSRMT_CYC_SCHED_RTE:D1_SP_ID
• D1_SP_MSRMT_CYC_SCHED_RTE:MSRMT_CYC_CD
• D1_SP_MSRMT_CYC_SCHED_RTE:MSRMT_CYC_RTE_CD
• D1_SP_MSRMT_CYC_SCHED_RTE:SCHED_SELECTION_DT
• D1_SP_MSRMT_CYC_SCHED_RTE:STATUS_UPD_DTTM
• D1_SP_MSRMT_CYC_SCHED_RTE:VERSION
Dropped Columns
The following columns are dropped in this release.
• D1_COMM_TYPE:ACTIVITY_TYPE_STAT_FLG
• D1_COMM_TYPE:OUTMSG_TYPE_CD
Unsupported Table Columns
None
Column Format Change
None
Tables Description
D1_SP_MSRMT_CYC_SCHED_RTE SP/Measurement Cycle Schedule Route