Preparing Legacy Data Extract for Upload

The legacy data mapping and extract will vary from one customer to another. The files created as a result of the extract process should conform to the specifications generated above. The resulting data extract files should be:

• Created according to the specifications

• Named according to the naming convention (see the online help and the specifications for more details)

• Optionally, the file might be compressed with gzip or zip (see the online help for details)

Special Data Considerations:

Oracle Utilities Cloud Services provide support for Information Lifecycle Management (ILM) and Data Archiving.

All ILM-enabled objects contain the following fields:

• ILM Date (ILM_DT)

• ILM Archive Switch (ILM_ARCH_SW).

The ILM and Data Archiving functionality is controlled by the combination of these two fields.

• The ILM Date field is used in conjunction with partitioning to group data by age.

• The ILM Archive Switch is set by a background process when a record meets the business rules specific to the record’s Maintenance Object that indicates the record is eligible to be archived.

See Information Lifecycle Management in the application’s Administrative User Guide for more information about how these fields are used.

When preparing the legacy data extract for a target table, perform the following steps:

• Access the Oracle Utilities application, search for a Conversion Instructions Conversion Task Type (see Conversion Task Types in the Oracle Utilities Cloud Service Foundation Administrative User Guide) for the target table or maintenance object and review the input data specifications. Determine if the field list contains the fields named ILM_DT and ILM_ARCH_SW.

• In the data extract, populate the ILM_ARCH_SW field as follows:

• Set the field with a value of "Y" for high-volume tables. In specific, the ILM_ARCH_SW field MUST be set to "Y" for the following tables used with Oracle Utilities Customer Cloud Service and Oracle Utilities Meter Solution Cloud Service:

• D1_DVC_EVT (Device Event)

• D1_INIT_MSRMT_DATA (Initial Measurement Data)

• D1_USAGE (Usage Transaction)

• Set the field with a value of "N" for all other tables

• For the ILM_DT field, the ILM Date Fields table below lists the recommended column whose value should be used to populate the ILM _DT for conversion data upload.

• Locate your target table name in the list and determine how the ILM_DT field should be populated

• If the table is not listed, please contact Oracle Utilities support.

ILM Date Fields

Table Name	ILM DT Initial Load
CI_TD_ENTRY	CI_TD_ENTRY.CRE_DTTM
F1_SYNC_REQ_IN	F1_SYNC_REQ_IN.CRE_DTTM
F1_OUTMSG	F1_OUTMSG.CRE_DTTM
F1_SVC_TASK	F1_SVC_TASK.CRE_DTTM
F1_OBJ_REV	F1_OBJ_REV.STATUS_UPD_DTTM
F1_BUS_FLG	F1_BUS_FLG.CRE_DTTM
F1_REMOTE_MSG	F1_REMOTE_MSG.CRE_DTTM
F1_STATS_SNPSHT	F1_STATS_SNPSHT.CRE_DTTM
F1_ERASURE_SCHED	F1_ERASURE_SCHED.STATUS_UPD_DTTM
F1_PROC_STORE	F1_PROC_STORE.STATUS_UPD_DTTM
F1_GNRL_AUDIT	F1_GNRL_AUDIT.CRE_DTTM
D1_ACTIVITY	D1_ACTIVITY.CRE_DTTM
D1_COMM_IN	D1_COMM_IN.CRE_DTTM
D1_COMM_OUT	D1_COMM_OUT.CRE_DTTM
D1_DVC_EVT	D1_DVC_EVT.CRE_DTTM
D1_COMPL_EVT	D1_COMPL_EVT.CRE_DTTM
D1_INIT_MSRMT_DATA	D1_INIT_MSRMT_DATA.CRE_DTTM
D1_USAGE	D1_USAGE.CRE_DTTM
D1_USAGE_EXCP	D1_USAGE_EXCP.CRE_DTTM
D1_VEE_EXCP	D1_VEE_EXCP.CRE_DTTM
D1_ACTIVITY	D1_ACTIVITY.CRE_DTTM
CI_ADJ	CI_ADJ.CRE_DT
CI_APPR_REQ	MIN(LOG_DTTM) on CI_APPR_REQ_LOG for given APPR_REQ_ID
CI_BILL	CI_BILL.CRE_DTTM
CI_BSEG	CI_BSEG.CRE_DTTM
CI_STM	CI_STM.STM_DT
C1_OFFCYC_BGEN	C1_OFFCYC_BGEN.STATUS_UPD_DTTM
CI_BILL_CHG	CI_BILL_CHG.START_DT
CI_CASE	MIN(LOG_DTTM) on CI_CASE_LOG table for given CASE_ID
CI_FA	CI_FA.CRE_DTTM
CI_ENRL	CI_ENRL.START_DT
CI_PAY_EVENT	CI_PAY_EVENT.PAY_DT
CI_PAY	CI_PAY_EVENT.PAY_DT
CI_MATCH_EVT	CI_MATCH_EVT.CREATE_DT
C1_USAGE	C1_USAGE.CRE_DTTM
C1_CUST_REL_REQ	C1_CUST_REL_REQ.CRE_DTTM
CI_CC	CI_CC.CC_DTTM or CI_CC.LETTER_PRINT_DTTM
CI_MR	CI_MR.READ_DTTM
C1_PA_RQST	C1_PA_RQST.CRE_DTTM
C1_CS_RQST	C1_CS_RQST.CRE_DTTM
C1_CS_REQ_ACCT	C1_CS_REQ_ACCT.?
C1_CS_REQ_CONT	C1_CS_REQ_CONT.CRE_DTTM
C1_CS_RQST_CONT_PROD	C1_CS_RQST_CONT_PROD.CRE_DTTM
C1_CS_REQ_PER	C1_CS_REQ_PER.CRE_DTTM
C1_CS_REQ_CVS_LOC	C1_CS_REQ_CVS_LOC.CRE_DTTM
C1_CS_REQ_PREM	C1_CS_REQ_PREM.CRE_DTTM
C1_MKTMSG_CHG	C1_MKTMSG_CHG.MKT_CHG_DT
C1_MKTMSG_PAY	C1_MKTMSG_PAY.MKT_PAY_DT
C1_MKTMSG_USG	C1_MKTMSG_USG.MKT_USG_DT