Naming Convention

The naming convention for tablespace, partitions and subpartition is standardized as follows

• Each name consists of some or all of the following parts

• The parts of the name are organized hierarchically

• Each part of the name is separated with an underscore.

• The maximum name length must not exceed 30 characters.

• For an MO, the parent table and child table share the same tablespace for the corresponding partition (or sub partition as appropriate).

• Square brackets [ ] indicate that this part of the name should be omitted if not required.

OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME[_SUBPARTITIONNAME][_ARCHIVEFLAG][_COMPRESSFLAG]

For details on the convention, please refer to the table below:

Convention	Description
OWNERFLAG	Owner flag for the relevant application for example “C1” for CCB
TABLE IDENTIFIER	The Index Name of the Primary Key index without the “P0” suffix. For example, if the PK index name is XT039P0, the table identifier would be “XT039”.
PARTITION NAME	The Partition name should be prefixed with a P followed by a name which conforms to one of the following standards: • 4 digit year and 3 letter month abbreviation PYYYYMON corresponding to the ILM date e.g. P2017JAN • PMAX if it is the Max Value partition
SUBPARTITION NAME	If subpartitions are used, name should be prefixed with S followed by a name of not more than 5 characters which conforms to the following requirements: • SMAX if this is the Max Value sub partition • If the sub partition holds data for a sub retention period use a number equal to that period e.g S91 if the sub retention period < 91 days. • For a range based SubPartition on Primary Key, use an integral number increasing by +1. For example, if there are 8 sub partitions use S01 through S08
ARCHIVEFLAG	This flag is used as a suffix to the table and tablespace name for the staging tables created for the archiving operation. • ARC
COMPRESS FLAG	This flag is used as a suffix to the tablespace name for the staging tables created when compressing a partition. • C For compression related tasks, this is used as suffix to the tablespace name. • Partition Tablespace Name: It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME. For example: CM_D1T304_PMAX CM_D1T304_P2017JAN • SubPartition Tablespace Name: It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME_SUBPARTITIONNAME. For example: CM_D1T304_PMAX_SMAX CM_D1T304_P2017JAN_SMAX CM_D1T304_PMAX_S001 CM_D1T304_P2017JAN_S181 • Archive Staging Table And Its Tablespace Name (When archiving partition): It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME_ ARCHIVEFLAG. For example: CM_D1T304_P2017JAN_ARC • Archive Staging Table And Its Tablespace Name (When archiving subpartition): It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME_SUBPARTITIONNAME_ ARCHIVEFLAG. For example: CM_D1T304_P2017JAN_S181_ARC • Compressed Tablespace name (When compressing partition): For example: CM_D1T304_P2017JAN_ C

Module Specific ILM Implementation Details

This section outlines each maintenance object that has been configured to support ILM. The parent table is noted. Other tables are child tables of the parent unless otherwise noted. In each case, the partitioning strategy is indicated.

All indexes are listed with a recommendation whether the index should be global or local and whether the index should be partitioned. In addition to the base delivered indexes, each parent table includes a recommended ILM specific local index to build with the ILM_DT, ILM_ARCH_SW and the primary key of the table. The recommended column that should be used to populate the ILM_DT is also shown. Refer to Sample SQL For Enabling ILM in C2M for CCB (Existing Installation)Sample SQL For Enabling ILM for CCB (Existing Installation) for sample DDL(s).

The following maintenance tables are included:

• To Do Entry

• Sync Request (Outbound)

• Inbound Sync Request

• Outbound Message

• Service Task

• Object Revision

• Object Erasure

• Process Flow

• Adjustment

• Approval Request

• Bill

• Bill Segment

• Statement

• Off Cycle Bill Generator

• Billable Charge

• Case

• Field Activity

• Enrollment (Order)

• Payment Event

• Payment

• Match Event

• Usage Request

• Business Flag

• Remote Message

• Statistics Snapshot

• Customer Relationship Request

• Customer Contact

• Collection Process

• Cut Process

• Overdue Process

• Severance Event

• WO Process

• General Audit

• Meter Read

• Payment Arrangement Process

• Customer Service Request

• Customer Service Request Account

• Customer Service Request Consumer Contract

• Customer Service Request Contract Product

• Customer Service Request Person

• Customer Service Request Service Location

• Customer Service Request Premise

• Market Charge

• Market Payment

• Market Usage

• Customer Service Request SA

• SA Arrears Snapshot

• Notification Preference

• Inbound Market Message

• Outbound Market Message

• Market Process

• Market Process Event

• Mobile Remote Message

To Do Entry

This table describes the To Do Entry maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_TD_ ENTRY (Parent)	RANGE (ILM_DT, TD_ENTRY_ ID)				RANGE (TD_ENTRY_ ID)	CI_TD_ENTRY.CRE_DTTM
		XT039P0	TD_ENTRY_ID	Global Partitioned
		XT039S2	ASSIGNED_TO, TD_ENTRY_ID	Global
		XT039S3	ENTRY_STATUS_ FLG, ASSIGNED_TO	Global
		XT039S4	ROLE_ID, TD_TYPE_CD, ENTRY_STATUS_ FLG, TD_PRIORITY_FLG, ASSIGNED_TO, CRE_DTTM	Global
		XT039S5	BATCH_CD, BATCH_NBR, ENTRY_STATUS_FLG	Global
		XT039S6	TD_ENTRY_ID, ASSIGNED_TO, ENTRY_STATUS_FLG	Global
		XT039S7	COMPLETE_USER_ID, COMPLETE_DTTM, TD_ENTRY_ID	Global
		CM_ILM_XT039S8	ILM_DT, ILM_ARCH_SW, TD_ENTRY_ID	Local Partitioned
CI_TD_ ENTRY_CHA	Reference Partitioning	XT701P0	TD_ENTRY_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		XT701S1	SRCH_CHAR_VAL, CHAR_TYPE_CD, TD_ENTRY_ID	Global
		XT701S2	CHAR_VAL_FK1	Global
CI_TD_ DRLKEY	Reference Partitioning	XT037P0	TD_ENTRY_ID, SEQ_NUM	Global Partitioned
		XT037S1	KEY_VALUE, TD_ENTRY_ID	Global
CI_TD_LOG	Reference Partitioning	XT721P0	TD_ENTRY_ID, SEQ_NUM	Global Partitioned
		XT721S1	LOG_DTTM,USER_ID, LOG_TYPE_FLG, TD_ENTRY_ID	Global
CI_TD_MSG_ PARM( Child table of CI_TD_LOG)	Reference Partitioning	XT040P0	TD_ENTRY_ID, SEQ_NUM	Global Partitioned
CI_TD_ SRTKEY	Reference Partitioning	XT041P0	TD_ENTRY_ID, SEQ_NUM	Global Partitioned
		XT041S1	KEY_VALUE, TD_ENTRY_ID	Global

Sync Request (Outbound)

This table describes the Sync Request (Outbound) maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_SYNC_ REQ(Parent)	RANGE (ILM_DT, F1_SYNC_ REQ_ID)				RANGE (F1_SYNC_REQ_ID)	F1_SYNC_REQ.CRE_DTTM
		F1T014P0	F1_SYNC_REQ_ID	Global Partitioned
		F1T014S1	BO_STATUS_CD, BUS_OBJ_CD, F1_SYNC_REQ_ID	Global
		F1T014S2	BO_STATUS_ REASON_CD	Global
		F1T014S3	MAINT_OBJ_CD, PK_VALUE1, PK_VALUE2, F1_SYNC_REQ_ID	Global
		CM_ILM_F1T014S4	ILM_DT, ILM_ARC_SW, F1_SYNC_REQ_ID	Local Partitioned
F1_SYNC_REQ_CHAR	Reference Partitioning	F1T017P0	F1_SYNC_REQ_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T017S1	SRCH_CHAR_VAL	Global
F1_SYNC_REQ_EXTRACT	Reference Partitioning	F1T019P0	F1_SYNC_REQ_ID, SEQ_NUM	Global Partitioned
F1_SYNC_REQ_LOG	Reference Partitioning	F1T015P0	F1_SYNC_REQ_ID, SEQNO	Global Partitioned
		F1T015S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1T015S2	CHAR_TYPE_CD, CHAR_VAL	Global
		F1T015S3	BO_STATUS_REASON_CD	Global
F1_SYNC_REQ_LOG_ PARM(Child Table of F1_SYNC_REQ_LOG_ PARM)	Reference Partitioning	F1T016P0	F1_SYNC_REQ_ID, SEQNO, PARM_SEQ	Global Partitioned

Note: It is recommended that data retention policies and rules for this object match the policies and rules implemented for the Inbound Sync Request on the target system to avoid data inconsistencies when auditing.

Inbound Sync Request

This table describes the Inbound Sync Request maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_SYNC_REQ_IN (Parent)	RANGE(ILM_DT, F1_SYNC_REQ_IN_ID)				RANGE (F1_SYNC_REQ_IN_ID)	F1_SYNC_REQ_IN.CRE_DTTM
		F1T191P0	F1_SYNC_REQ_ IN_ID	Global Partitioned
		F1T191S1	BO_STATUS_CD, BUS_OBJ_CD, F1_SYNC_REQ_ IN_ID	Global
		F1T191S2	MAINT_OBJ_CD, EXT_PK_VALUE1, NT_XID_CD, PK_VALUE1	Global
		F1T191S3	EXT_REFERENCE_ID	Global
		CM_ILM_F1T191S3	ILM_DT, ILM_ARCH_SW, F1_SYNC_REQ_IN_ID	Local Partitioned
F1_SYNC_REQ_ IN_CHAR	Reference Partitioning	F1T193P0	F1_SYNC_REQ_IN_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T193S1	SRCH_CHAR_VAL	Global
F1_SYNC_REQ_ IN_EXCP	Reference Partitioning	F1T197P0	F1_SYNC_REQ_IN_ID, SEQNO	Global Partitioned
F1_SYNC_REQ_ IN_EXCP_PARM (Child Table of F1_SYNC_REQ_IN_EXCP)	Reference Partitioning	F1T198P0	F1_SYNC_REQ_IN_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_SYNC_REQ_ IN_LOG	Reference Partitioning	F1T194P0	F1_SYNC_REQ_IN_ID, SEQNO	Global Partitioned
		F1T194S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1T194S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_SYNC_REQ_IN_LOG_PARM (Child Table of F1_SYNC_REQ_IN_LOG)	Reference Partitioning	F1T195P0	F1_SYNC_REQ_IN_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_SYNC_REQ_IN_REL_OBJ	Reference Partitioning	F1T192P0	F1_SYNC_REQ_IN_ID, MAINT_OBJ_CD, REL_OBJ_TYPE_FLG	Global Partitioned
		F1T192S1	PK_VALUE1	Global

Note: It is recommended that data retention policies and rules for this object match the policies and rules implemented for the Outbound Sync Request on the source system to avoid data inconsistencies when auditing.

Outbound Message

This table describes the Outbound Message maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_OUTMSG (Parent)	RANGE (ILM_DT, OUTMSG_ID)				RANGE (OUMSG_ID)	F1_OUTMSG. CRE_DTTM
		FT010P0	OUTMSG_ID	Global Partitioned
		FT010S1	OUTMSG_STATUS_FLG, OUTMSG_TYPE_CD	Global
		CM_ILM_ FT010S2	ILM_DT, ILM_ARC_SW, OUTMSG_ID	Local Partitioned
F1_OUTMSG_ ERRPARM	Reference Partitioning	FT011P0	OUTMSG_ID, PARM_SEQ	Global Partitioned

Service Task

This table describes the Service Task maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_SVC_TASK (Parent)	RANGE (ILM_DT, F1_SVC_TASK_ID)				RANGE (F1_SVC_TASK_ ID_)	F1_SVC_TASK. CRE_DTTM
		F1C474P0	F1_SVC_TASK_ID	Global Partitioned
		F1C474S1	F1_STASK_TYPE_CD	Global
		F1C474S2	BUS_OBJ_CD	Global
		CM_ILM_F1C474S3	ILM_DT, ILM_ARC_SW, F1_SVC_TASK_ID	Local Partitioned
F1_SVC_TASK_ CHAR	Reference Partitioning	F1C476P0	F1_SVC_TASK_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1C476S1	SRCH_CHAR_VAL	Global
F1_SVC_TASK_ LOG	Reference Partitioning	F1C477P0	F1_SVC_TASK_ID, SEQNO	Global Partitioned
		F1C477S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1C477S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_SVC_TASK_ LOG_PARM (Child Table of F1_SVC_TASK_ LOG)	Reference Partitioning	F1C478P0	F1_SVC_TASK_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_SVC_TASK_ REL_OBJ	Reference Partitioning	F1C479P0	F1_SVC_TASK_ID, MAINT_OBJ_CD, SEQ_NUM	Global Partitioned
		F1C479S1	MAINT_OBJ_CD, PK_VALUE1, PK_VALUE2, PK_VALUE3 PK_VALUE4 PK_VALUE5	Global

Object Revision

This table describes the Object Revision maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_OBJ_REV (Parent)	RANGE (ILM_DT, REV_ID)				RANGE (REV_ID)	F1_OBJ_REV. STATUS_UPD_DTTM
		FT035P0	REV_ID	Global Partitioned
		FT035S1	BO_STATUS_CD, BUS_OBJ_CD, REV_ID	Global
		FT035S2	MAINT_OBJ_CD, PK_VALUE1	Global
		FT035S3	EXT_REFERENCE_ID, MAINT_OBJ_CD	Global
		FT035S4	USER_ID, MAINT_OBJ_CD	Global
		FT035S5	PK_VALUE1	Global
		CM_ILM_ FT035S6	ILM_DT, ILM_ARC_SW, REV_ID	Local Partitioned
F1_OBJ_REV_ CHAR	Reference Partitioning	FT037P0	REV_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		FT037S1	SRCH_CHAR_VAL	Global
F1_OBJ_REV_ LOG	Reference Partitioning	FT039P0	REV_ID, SEQNO	Global Partitioned
F1_OBJ_REV_ LOG_PARM (Child Table of F1_OBJ_REV_ LOG)	Reference Partitioning	FT040P0	REV_ID, SEQNO, PARM_SEQ	Global Partitioned

Note: This maintenance object is enabled for ILM, however it is not used in a production environment. It is typically used in a development or configuration environment. Your implementation should review its use of this functionality and consider whether or not it is a candidate for ILM and in which region.

Object Erasure

This table describes the Object Erasure maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_ERASURE_SCHED (Parent)	RANGE (ILM_DT, ERASURE_ SCHED_ID)					F1_ERASURE_ SCHED. STATUS_UPD_ DTTM.
		F1T756P0	ERASURE_ SCHED_ID	GLOBAL Partitioned	RANGE (ERASURE_ SCHED_ID)
		CM_ILM_ F1T756S1	ILM_DT, ILM_ARCH_SW, ERASURE_ SCHED_ID	LOCAL Partitioned
F1_ERASURE_SCHED_ LOG	Reference partitioning	F1T757P0	ERASURE_SCHED_ID, SEQNO	GLOBAL Partitioned
F1_ERASURE_SCHED_ LOG_PARM	Reference partitioning	F1T758P0	ERASURE_SCHED_ID, SEQNO, PARM_SEQ	GLOBAL Partitioned

Process Flow

This table describes the Process Flow maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_PROC_ STORE (Parent)	RANGE (ILM_DT, PROC_STORE_ ID)					F1_PROC_STORE. STATUS_UPD_DTTM.
		F1T747P0	PROC_STORE_ID	GLOBAL Partitioned	RANGE (PROC_STORE_ID)
		CM_ILM_ F1T747S1	ILM_DT, ILM_ARCH_ SW, PROC_STORE_ID	LOCAL Partitioned
F1_PROC_STORE_DTL_ ELEMENTS	Reference partitioning	F1T748P0	PROC_ STORE_ID, CHAR_TYPE_CD, SEQ_NUM	GLOBAL Partitioned
F1_PROC_STORE_LOG	Reference partitioning	F1T749P0	PROC_STORE_ID, SEQNO	GLOBAL Partitioned
F1_PROC_STORE_LOG_ PARM	Reference partitioning	F1T750P0	PROC_STORE_ID, SEQNO, PARM_SEQ	GLOBAL Partitioned

Adjustment

This table describes the Adjustment maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_ADJ (Parent)	RANGE (ILM_DT, ADJ_ID)				RANGE (ADJ_ID)	CI_ADJ.CRE_DT
		XT012P0	ADJ_ID	Global Partitioned
		XT012S1	SA_ID, ADJ_TYPE_CD	Global
		XT012S2	XFER_ADJ_ID, ADJ_ID	Global
		XT012S4	APPR_REQ_ID, ADJ_ID	Global
		CM_ILM_ XT012S3	ILM_DT, ILM_ARCH_SW, ADJ_ID	Local Partitioned
CI_ADJ_APREQ	Reference Partitioning	XT160P0	AP_REQ_ID	Global
		XT160S1	ADJ_ID	Global
		XT160S2	BATCH_CD, BATCH_NBR	Global
CI_ADJ_CALC_ LN	Reference Partitioning	XT310P0	ADJ_ID, SEQNO	Global Partitioned
CI_ADJ_CL_ CHAR	Reference Partitioning	XT309P0	ADJ_ID, SEQNO, CHAR_TYPE_ CD	Global Partitioned
CI_ADJ_CHAR	Reference Partitioning	XC781P0	ADJ_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		XC781S1	SRCH_CHAR_ VAL	Global

Approval Request

This table describes the Approval Request maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_APPR_REQ (Parent)	RANGE (ILM_DT, APPR_REQ_ID)				RANGE (APPR_REQ_ID)	MIN(LOG_DTTM) on CI_APPR_REQ_LOG for given APPR_REQ_ID
		XT600P0	APPR_REQ_ID	Global Partitioned
		CM_ILM_ XT600S1	ILM_DT, ILM_ARCH_SW, APPR_REQ_ID	Local partitioned
CI_APPR_REQ_CHAR	Reference Partitioning	XT601P0	APPR_REQ_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		XT601S1	SRCH_CHAR_ VAL	Global
CI_APPR_REQ_LOG	Reference Partitioning	XT602P0	APPR_REQ_ID, SEQNO	Global Partitioned
		XT602S1	CHAR_TYPE_ CD, CHAR_VAL_FK1	Global
CI_APPR_REQ_LOG_PARM	Reference Partitioning	XT603P0	APPR_REQ_ID, SEQNO, PARM_SEQ	Global Partitioned

Bill

This table describes the Bill maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_BILL (Parent)	RANGE (ILM_DT, BILL_ID)				RANGE (BILL_ID)	CI_BILL.CRE_DTTM
		XT033P0	BILL_ID	Global Partitioned
		XT033S1	ACCT_ID, BILL_STAT_ FLG, BILL_CYC_CD, WIN_START_DT,CR_NOTE_FR_BILL_ID	Global
		XT033S2	CR_NOTE_FR_ BILL_ID, BILL_ID	Global
		XT033S3	ALT_BILL_ID, BILL_STAT_ FLG, BILL_ID	Global
		XT033S4	OFFCYC_BGEN_ID, BILL_ID	Global
		XT033S5	DOC_ID, DOC_TYPE_ FLG, BILL_STAT_FLG, BILL_ID	Global
		CM_ILM_ XT033S6	ILM_DT, ILM_ARCH_SW, BILL_ID	Local Partitioned
		XT033S7	ACCT_ID, OFFCYC_BGEN_ID, CRE_DTTM	Global
		XT033S8	LATE_PAY_ CHARGE_SW, LATE_PAY_ CHARGE_DT, BILL_ID	Global
CI_BILL_CHAR	Reference Partitioning	XT313P0	BILL_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		XT313S1	SRCH_CHAR_ VAL	Global
CI_BILL_EXCP	Reference Partitioning	XT038P0	BILL_ID	Global Partitioned
CI_BILL_MSGS	Reference Partitioning	XT091P0	BILL_ID, BILL_MSG_CD	Global Partitioned
CI_BILL_MSG_ PRM	Reference Partitioning	XT085P0	BILL_ID, BILL_MSG_CD, SEQ_NUM	Global Partitioned
CI_BILL_SA	Reference Partitioning	XT046P0	BILL_ID, SA_ID	Global Partitioned
		XT046S1	SA_ID	Global
CI_BILL_ ROUTING	Reference Partitioning	XT075P0	BILL_ID, SEQNO	Global Partitioned
		XT075S1	BATCH_CD, BATCH_NBR, BILL_ID, NO_BATCH_ PRT_SW	Global

Bill Segment

This table describes the Bill Segment maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_BSEG (Parent)	RANGE (ILM_DT, BSEG_ID)				RANGE (BSEG_ID)	CI_BSEG.CRE_DTTM
		XT048P0	BSEG_ID	Global Partitioned
		XT048S1	BILL_ID	Global
		XT048S2	SA_ID	Global
		XT048S3	QUOTE_DTL_ ID, BSEG_ID	Global
		CM_ILM_ XT048S4	ILM_DT, ILM_ARCH_SW, BSEG_ID	Local Partitioned
CI_BSEG_CALC	Reference partitioning	XT072P0	BSEG_ID, HEADER_SEQ	Global Partitioned
		XT072S1	BILLABLE_CHG_ID, BSEG_ID	Global
CI_BSEG_CALC_LN	Reference partitioning	XT050P0	BSEG_ID, HEADER_SEQ, SEQNO	Global Partitioned
CI_BSEG_CL_ CHAR	Reference partitioning	XT056P0	BSEG_ID, HEADER_SEQ, SEQNO, CHAR_TYPE_ CD	Global Partitioned
CI_BSEG_EXCP	Reference partitioning	XT051P0	BSEG_ID	Global Partitioned
CI_BSEG_MSG	Reference partitioning	XT080P0	BSEG_ID, BILL_MSG_CD	Global Partitioned
CI_BSEG_READ	Reference partitioning	XT054P0	BSEG_ID, SP_ID, SEQNO	Global Partitioned
		XT054S1	SP_ID	Global
		XT054S2	START_REG_READ_ID	Global
		XT054S3	END_REG_ READ_ID	Global
CI_BSEG_SQ	Reference partitioning	XT055P0	BSEG_ID, UOM_CD, TOU_CD, SQI_CD	Global Partitioned
CI_BSEG_ITEM	Reference partitioning	XT053P0	BSEG_ID, SEQNO	Global Partitioned

Statement

This table describes the Statement maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_STM (Parent)	RANGE (ILM_DT, STM_ID)				RANGE (STM_ID)	CI_STM.STM_DT
		XT088P0	STM_ID	Global Partitioned
		CM_ILM_ XT088S1	ILM_DT, ILM_ARCH_SW, STM_ID	Local Partitioned
CI_STM_DTL		XT119P0	STM_DTL_ID	Global
		XT119S1	STM_ID	Global

Off Cycle Bill Generator

This table describes the Off Cycle Bill Generator maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_OFFCYC_ BGEN (Parent)	RANGE (ILM_DT, OFFCYC_ BGEN_ID)				RANGE (OFFCYC_BGEN_ID)	C1_OFFCYC_BGEN.STATUS_UPD_DTTM
		XT197P0	OFFCYC_BGEN_ID	Global Partitioned
		XT197S1	ACCT_ID	Global
		CM_ILM_ XT197S2	ILM_DT, ILM_ARCH_SW, OFFCYC_BGEN_ID	Local Partitioned
C1_OFFCYC_BGEN_ADJ	Reference partitioning	XT285P0	OFFCYC_BGEN_ID, ADJ_ID	Global Partitioned
		XT285S1	ADJ_ID	Global
C1_OFFCYC_BGEN_BCHG	Reference partitioning	XT326P0	OFFCYC_BGEN_ID, BILLABLE_ CHG_ID	Global Partitioned
		XT326S1	BILLABLE_CHG_ID	Global
C1_OFFCYC_BGEN_CHAR	Reference partitioning	XT343P0	OFFCYC_BGEN_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		XT343S1	SRCH_CHAR_ VAL	Global
C1_OFFCYC_BGEN_LOG	Reference partitioning	XT344P0	OFFCYC_BGEN_ID, SEQNO	Global Partitioned
		XT344S1	CHAR_TYPE_ CD, CHAR_VAL_FK1	Global
C1_OFFCYC_BGEN_LOG_PARM	Reference partitioning	XT357P0	OFFCYC_BGEN_ID, SEQNO, PARM_SEQ	Global Partitioned
C1_OFFCYC_BGEN_SA	Reference partitioning	XT359P0	OFFCYC_BGEN_ID, SA_ID	Global Partitioned
		XT359S1	SA_ID	Global

Billable Charge

This table describes the Billable Charge maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_BILL_CHG (Parent)	RANGE (ILM_DT, BILLABLE_CHG_ID)				RANGE (BILLABLE_CHG_ID)	CI_BILL_CHG.START_DT
		XT035P0	BILLABLE_CHG_ID	Global Partitioned
		XT035S1	SA_ID	Global
		CM_ILM_ XT035S2	ILM_DT, ILM_ARCH_SW, BILLABLE_CHG_ID	Local Partitioned
CI_BCHG_READ	Reference Partitioning	XT271P0	BILLABLE_CHG_ID, SP_ID, SEQNO	Global Partitioned
CI_BCHG_SQ	Reference Partitioning	XT081P0	BILLABLE_CHG_ID, SEQ_NUM	Global Partitioned
CI_B_CHG_ LINE	Reference Partitioning	XT001P0	BILLABLE_CHG_ID, LINE_SEQ	Global Partitioned
CI_B_LN_CHAR	Reference Partitioning	XT083P0	BILLABLE_CHG_ID, LINE_SEQ, CHAR_TYPE_ CD	Global Partitioned

Case

This table describes the Case maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_CASE (Parent)	RANGE (ILM_DT, CASE_ID)				RANGE (CASE_ID)	MIN(LOG_DTTM) on CI_CASE_LOG table for given CASE_ID
		XT220P0	CASE_ID	Global Partitioned
		XT220S1	PER_ID	Global
		XT220S2	ACCT_ID	Global
		XT220S3	PREM_ID	Global
		XT220S4	USER_ID	Global
		CM_ILM_ XT220S5	ILM_DT, ILM_ARCH_SW, CASE_ID	Local Partitioned
CI_CASE_CHAR	Reference Partitioning	XT222P0	CASE_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		XT222S1	SRCH_CHAR_ VAL	Global
CI_CASE_LOG	Reference Partitioning	XT221P0	CASE_ID, SEQ_NUM	Global Partitioned
		XT221S1	CHAR_TYPE_ CD, CHAR_VAL_FK1	Global
CI_CASE_LOG_PARM	Reference Partitioning	XT290P0	CASE_ID, SEQ_NUM, PARM_SEQ	Global Partitioned

Field Activity

This table describes the Field Activity maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_FA (Parent)	RANGE (ILM_DT, FA_ID)				RANGE (FA_ID)	CI_FA.CRE_ DTTM
		XT094P0	FA_ID	Global Partitioned
		XT094S1	SP_ID, FO_ID	Global
		XT094S2	FO_ID, FA_ID	Global
		XT094S3	FA_STATUS_ FLG, ELIG_ DISPATCH_SW, FO_ID, FA_ID	Global
		XT094S4	APP_SCHED_ID, FA_ID	Global
		XT094S5	TEST_SEL_ID, FA_ID	Global
		CM_ILM_ XT094S6	ILM_DT, ILM_ARCH_SW, FA_ID	Local Partitioned
		XT094S7	FA_EXT_ID, FA_ID	Global
CI_FA_CHAR	Reference Partitioning	XT406P0	FA_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		XT406S1	SRCH_CHAR_ VAL	Global
CI_FA_LOG	Reference Partitioning	XT350P0	FA_ID, SEQ_NUM	Global Partitioned
CI_FA_REM	Reference Partitioning	XT407P0	FA_ID, FA_REM_CD	Global Partitioned
CI_FA_REM_ EXC	Reference Partitioning	XT312P0	FA_ID, FA_REM_CD	Global Partitioned
CI_FA_REM_ EXP	Reference Partitioning	XT405P0	FA_ID, FA_REM_CD, PARM_SEQ	Global Partitioned
CI_FA_STEP	Reference Partitioning	XT095P0	FA_ID, STEP_SEQ_NBR	Global Partitioned
		XT095S1	CC_ID	Global
		XT095S2	SPAWNED_FA_ ID, FA_ID	Global
		XT095S3	MR_ID	Global

Enrollment (Order)

This table describes the Enrollment (Order) maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_ENRL (Parent)	RANGE (ILM_DT, ENRL_ID)				RANGE (ENRL_ID)	CI_ENRL. START_DT
		XT193P0	ENRL_ID	Global Partitioned
		XT193S1	PER_ID	Global
		XT193S2	ACCT_ID	Global
		XT193S3	PREM_ID	Global
		CM_ILM_XT193S4	ILM_DT, ILM_ARCH_SW, ENRL_ID	Local Partitioned
CI_ENRL_ADDR	Reference Partitioning	XT200P0	ENRL_ID, ENRL_ADDR_ ENT_FLG	Global Partitioned
		XT200S1	ADDRESS1_UPR, ENRL_ID	Global
		XT200S2	CITY_UPR, ENRL_ID	Global
CI_ENRL_FLD	Reference Partitioning	XT191P0	ENRL_ID, SEQ_NUM	Global Partitioned
CI_ENRL_LOG	Reference Partitioning	XT198P0	ENRL_ID, SEQ_NUM	Global Partitioned
CI_ENRL_PER_ ID	Reference Partitioning	XT199P0	ENRL_ID, ID_TYPE_CD	Global Partitioned
		XT199S1	HASH_PER_ID_NBR, ENRL_ID, ID_TYPE_CD	Global
CI_ENRL_PER_NM	Reference Partitioning	XT194P0	ENRL_ID, SEQ_NUM	Global Partitioned
		XT194S1	ENTITY_NAME_UPR, ENRL_ID	Global
CI_ENRL_PER_PHN	Reference Partitioning	XT195P0	ENRL_ID, SEQ_NUM	Global Partitioned
C1_ENRL_CONTDET	Reference Partitioning	C1T011S1	C1_ENRL_CONTACT_ID	Global Partitioned

Payment Event

This table describes the Payment Event maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_PAY_EVENT (Parent)	RANGE (ILM_DT, PAY_EVENT_ ID)				RANGE (PAY_EVENT_ ID)	CI_PAY_EVENT.PAY_DT
		XT159P0	PAY_EVENT_ID	Global Partitioned
		XT159S1	PAY_DT, PAY_EVENT_ID	Global
		XT159S2	DOC_ID, PAY_EVENT_ID	Global
		CM_ILM_XT159S3	ILM_DT, ILM_ARCH_SW, PAY_EVENT_ID	Local Partitioned
CI_PAY_EVT_CHAR	Reference Partitioning	XT244P0	PAY_EVENT_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		XT244S1	SRCH_CHAR_VAL	Global
CI_PAY_EVT_EXCP	Reference Partitioning	XT161P0	PAY_EVENT_ID	Global Partitioned
CI_PAY_TNDR	Reference Partitioning	XT265P0	PAY_TENDER_ID	Global
		XT265S1	MICR_ID	Global
		XT265S2	TENDER_AMT, PAY_TENDER_ID	Global
		XT265S3	PAY_EVENT_ID	Global
		XT265S4	PAYOR_ACCT_ ID, TENDER_AMT	Global
		XT265S5	TNDR_CTL_ID, PAY_EVENT_ID	Global
		XT265S6	ADJ_ID	Global
		XT265S7	HASH_MICR_ID, PAY_TENDER_ ID	Global
CI_APAY_CLR_STG	Reference Partitioning	XT003P0	APAY_CLR_ID	Global
		XT003S1	BILL_ID	Global
		XT003S2	PAY_TENDER_ID	Global
		XT003S3	BATCH_CD, BATCH_NBR, SCHED_EXTRACT_DT	Global
		XT003S4	ACCT_APAY_ID	Global
CI_PAY_TNDR_CHAR	Reference Partitioning	XT413P0	PAY_TENDER_ID, CHAR_TYPE_CD, SEQ_NUM	Global
		XT413S1	SRCH_CHAR_VAL	Global
CI_PEVT_DST_DTL	Reference Partitioning	XT730P0	PAY_EVENT_ID, SEQ_NUM	Global Partitioned
		XT730S1	SRCH_CHAR_VAL	Global

Payment

This table describes the Payment maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_PAY (Parent)	RANGE (ILM_DT, PAY_ID)				RANGE (PAY_ID)	CI_PAY_EVENT.PAY_DT
		XT156P0	PAY_ID	Global Partitioned
		XT156S1	ACCT_ID	Global
		XT156S2	PAY_EVENT_ID	Global
		XT156S3	PAY_AMT, PAY_ID	Global
		CM_ILM_ XT156S4	ILM_DT, ILM_ARCH_SW, PAY_ID	Local Partitioned
CI_PAY_CHAR	Reference Partitioning	XT412P0	PAY_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		XT412S1	SRCH_CHAR_VAL	Global
CI_PAY_EXCP	Reference Partitioning	XT163P0	PAY_ID	Global Partitioned
CI_PAY_SEG	Reference Partitioning	XT165P0	PAY_SEG_ID	Global
		XT165S1	PAY_ID	Global
		XT165S2	SA_ID	Global

Match Event

This table describes the Match Event maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_MATCH_EVT (Parent)	RANGE (ILM_DT, MATCH_EVT_ID)				RANGE (MATCH_EVT_ ID)	CI_MATCH_EVT.CREATE_DT
		XT266P0	MATCH_EVT_ID	Global Partitioned
		XT266S1	ACCT_ID, MEVT_STATUS_FLG	Global
		XT266S2	PAY_ID	Global
		CM_ILM_ XT266S3	ILM_DT, ILM_ARCH_SW, MATCH_EVT_ ID	Local Partitioned

Usage Request

This table describes the Usage Request maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_USAGE (Parent)	RANGE (ILM_DT, USAGE_ID)				RANGE (USAGE_ID)	C1_USAGE.CRE_DTTM
		CT368S2	BSEG_ID	Global
		CT368S3	USER_ID, USAGE_ID	Global
	Reference Partitioning	XT368P0	USAGE_ID	Global Partitioned
		XT368S1	BUS_OBJ_CD,BO_STATUS_CD, WIN_START_DT, BILL_CYC_CD, USAGE_ID	Global
		CT368S2	BSEG_ID
		CT368S3	USER_ID, USAGE_ID
		XT368S4	SA_ID	Global
		CT368S4	MASTER_USAGE_ID
		CT368S5	SA_REL_ID
		CM_ILM_ XT368S5	ILM_DT, ILM_ARCH_SW, USAGE_ID	Local Partitioned
C1_USAGE_ CHAR	Reference Partitioning	XT387P0	USAGE_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		XT387S1	SRCH_CHAR_ VAL	Global
C1_USAGE_LOG	Reference Partitioning	XT388P0	USAGE_ID, SEQNO	Global Partitioned
		XT388S1	CHAR_TYPE_ CD, CHAR_VAL_FK1	Global
C1_USAGE_LOG_PARM	Reference Partitioning	XT389P0	USAGE_ID, SEQNO, PARM_SEQ	Global Partitioned

Business Flag

This table describes the Business Flag maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_BUS_FLG (Parent)	RANGE (ILM_DT,BUS_FLG_ID)				RANGE(BUS_FLG_ID)	F1_BUS_FLG. CRE_DTTM
		F1T681P0	BUS_FLG_ID	Global Partitioned
		F1T681S1	BUS_OBJ_CD, BO_STATUS_CD, BUS_FLG_ID	Global
		CM_ILM_ F1T681S2	ILM_DT, ILM_ARCH_SW, BUS_FLG_ID	Local Partitioned
F1_BUS_FLG_ CHAR	Reference Partitioning	F1T684P0	BUS_FLG_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T684S0	SRCH_CHAR_VAL	Global
F1_BUS_FLG_ LOG	Reference Partitioning	F1T685P0	BUS_FLG_ID, SEQNO	Global Partitioned
		F1T685S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1T685S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_BUS_FLG_ LOG_PARM	Reference Partitioning	F1T686P0	BUS_FLG_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_BUS_FLG_ REL	Reference Partitioning	F1T682P0	BUS_FLG_ID, BUS_FLG_REL_ TYPE_FLG, SEQ_NUM	Global Partitioned
F1_BUS_FLG_ REL_OBJ	Reference Partitioning	F1T683P0	BUS_FLG_ID, BUS_FLG_REL_ OBJ_TYPE_FLG, SEQ_NUM	Global Partitioned

Remote Message

This table describes the Remote Message maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_REMOTE_ MSG (Parent)	RANGE (ILM_DT,F1_REMOTE_MSG_ID)				RANGE(F1_REMOTE_MSG_ID)	F1_REMOTE_MSG.CRE_DTTM
		F1T735P0	F1_REMOTE_MSG _ID	Global Partitioned
		F1T735S1	CRE_DTTM	Global
		F1T735S2	F1_MDT_ID	Global
		F1T735S3	MAINT_OBJ_CD	Global
		F1T735S4	PK_VALUE1	Global
		F1T735S5	F1_DEVICE_MSG_ID	Global
		F1T735S6	F1_MDT_ID, F1_MSG_CLASS_FLG, F1_DELIVERY_STATE_FLG	Global
		CM_ILM_ F1T735S7	ILM_DT, ILM_ARCH_SW, F1_REMOTE_MSG_ID	Local Partitioned
F1_REMOTE_ MSG_CHA	Reference Partitioning	F1T736P0	F1_REMOTE_MSG_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T736S1	SRCH_CHAR_VAL	Global
F1_REMOTE_ MSG_LOG	Reference Partitioning	F1T737P0	F1_REMOTE_MSG_ID, SEQNO	Global Partitioned
		F1T737S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1T737S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_REMOTE_MSG_LOG_PARM	Reference Partitioning	F1T738P0	F1_REMOTE_MSG_ID, SEQNO, PARM_SEQ	Global Partitioned

Statistics Snapshot

This table describes the Statistics Snapshot maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_STATS_ SNPSHT( Parent)	RANGE (ILM_DT, SNAPSHOT_ID)				RANGE (SNAPSHOT_ID)	F1_STATS_ SNPSHT. CRE_DTTM
		F1C706P0	SNAPSHOT_ID	Global Partitioned
		F1C706S1	BUS_OBJ_CD, BO_STATUS_CD, SNAPSHOT_ID	Global
		CM_ILM_ F1C706S2	ILM_DT, ILM_ARCH_SW, SNAPSHOT_ID	Local Partitioned
F1_STATS_ SNPSHT_CHAR	Reference Partitioning	F1C707P0	SNAPSHOT_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1C707S1	SRCH_CHAR_VAL	Global
F1_STATS_ SNPSHT_LOG	Reference Partitioning	F1C708P0	SNAPSHOT_ID, SEQNO	Global Partitioned
		F1C708S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		F1C708S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_STATS_SNPSHT_LOG_PARM	Reference Partitioning	F1C709P0	SNAPSHOT_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_STATS_ SNPSHT_REL_ OBJ	Reference Partitioning	F1C710P0	SNAPSHOT_ID, STATS_SNPSHT_ REL_OBJ_TYPE_ FLG, SEQ_NUM	Global Partitioned

Customer Relationship Request

This table describes the Customer Relationship Request maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_CUST_REL_ REQ	RANGE(ILM_DT,CUST_REL_REQ_ID)				RANGE(CUST_REL_REQ_ID)	C1_CUST_REL_REQ.CRE_DTTM
		C1T017P0	CUST_REL_REQ_ ID	Global Partitioned
		C1T017S1	CUST_REL_REQ_ ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_ C1T017S2	ILM_DT, ILM_ARCH_SW, CUST_REL_REQ_ ID	Local Partitioned
C1_CUST_REL_ REQ_CHAR	Reference Partitioning	C1T014P0	CUST_REL_REQ_ ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		C1T014S1	SRCH_CHAR_VAL	Global
C1_CUST_REL_ REQ_LOG	Reference Partitioning	C1T015P0	CUST_REL_REQ_ ID, SEQNO	Global Partitioned
		C1T015S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T015S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_CUST_REL_ REQ_LOG_PARM	Reference Partitioning	C1T016P0	CUST_REL_REQ_ ID, SEQNO, PARM_SEQ	Global Partitioned
C1_CUST_REL_ REQ_REL_OBJ	Reference Partitioning	C1T018P0	CUST_REL_REQ_ ID, CRR_REL_OBJ_TY_FLG, SEQ_NUM	Global Partitioned

Customer Contact

This table describes the Customer Contact maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_CC	RANGE(ILM_DT,CC_ID)				RANGE(CC_ID)	CI_CC. CC_DTTM, CI_CC. LETTER_PRINT_DTTM
		XT057P0	CC_ID	Global Partitioned
		XT057S1	PER_ID	Global
		XT057S2	BATCH_CD, BATCH_NBR, CC_ID, PRINT_LETTER_ SW	Global
		XT057S3	CC_TYPE_CD, CC_CL_CD, CC_ID	Global
		XT057S4	ACCT_ID	Global
		XT057S6	C1_CONTACT_ID	Global
		CM_ILM_ XT057S7	ILM_DT,ILM_ ARCH_SW,CC_ID	Local Partitioned
CI_CC_CHAR	Partitioning		CHAR_TYPE_CD	Partitioned	RANGE(CC_ID)
		C1T007S1	SRCH_CHAR_VAL	Global
CI_CC_LOG	Reference Partitioning	XT281P0	CC_LOG_ID	Global Partitioned	RANGE(CC_LOG_ID)
		XT281S1	CC_ID	Global

Collection Process

This table describes the Collection Process maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_COLL_PROC	RANGE(CRE_ DTTM,COLL_ PROC_ID)				RANGE (COLL_PROC_ ID)	N/A
		XT073P0	COLL_PROC_ID	Global Partitioned
		XT073S1	ACCT_ID	Global
			COLL_STATUS_ FLG
CI_COLL_EVT	Reference Partitioning	XT069P0	COLL_PROC_ID, EVT_SEQ	Global Partitioned
		XT069S0	TRIGGER_BP_SW, COLL_PROC_ID, EVT_SEQ, COLL_EVT_TYP_ CD	Global
CI_COLL_EVT_CC	Reference Partitioning	XT070P0	COLL_PROC_ID, EVT_SEQ, CC_ID	Global Partitioned
		XT070S1	CC_ID	Global
CI_COLL_PROC_ SA	Reference Partitioning	XT074P0	COLL_PROC_ID, SA_ID	Global Partitioned
		XT074S1	SA_ID	Global

Cut Process

This table describes the Cut Process maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_CUT_PROC	RANGE(CRE_DTTM,CUT_PROC_ID)				RANGE (CUT_PROC_ID)	N/A
		XT324P0	CUT_PROC_ID	Global Partitioned
		XT324S1	OD_PROC_ID, OD_EVT_SEQ	Global
CI_CUT_EVT	Reference Partitioning	XT322P0	CUT_PROC_ID, EVT_SEQ	Global Partitioned
CI_CUT_EVT_ DEP	Reference Partitioning	XT323P0	CUT_PROC_ID, EVT_SEQ, SEQ_NUM	Global Partitioned

Overdue Process

This table describes the Overdue Process maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_OD_PROC	RANGE(CRE_DTTM,OD_PROC_ID)				RANGE (OD_PROC_ID)	N/A
		XT315P0	OD_PROC_ID	Global Partitioned
CI_OD_EVT	Reference Partitioning	XT318P0	OD_PROC_ID, EVT_SEQ	Global Partitioned
CI_OD_EVT_ DEP	Reference Partitioning	XT319P0	OD_PROC_ID, EVT_SEQ, SEQ_NUM	Global Partitioned
CI_OD_PROC_LOG	Reference Partitioning	XT320P0	OD_PROC_ID, LOG_SEQ	Global Partitioned
		XT320S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
CI_OD_PROC_LOGPARM	Reference Partitioning	XT321P0	OD_PROC_ID, LOG_SEQ, PARM_SEQ	Global Partitioned
CI_OD_PROC_OBJ	Reference Partitioning	XT317P0	OD_PROC_ID, SEQ_NUM	Global Partitioned

Severance Event

This table describes the Severance Event maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_SEV_PROC	RANGE(CRE_DTTM,SEV_PROC_ID)				RANGE (SEV_PROC_ID)	N/A
		XT118P0	SEV_PROC_ID	Global Partitioned
		XT118S1	SA_ID, SEV_PROC_ID	Global
		XT118S2	COLL_PROC_ID, EVT_SEQ	Global
CI_SEV_EVT	Reference Partitioning	XT214P0	SEV_PROC_ID, EVT_SEQ	Global Partitioned
CI_SEV_EVT_DEP	Reference Partitioning	XT216P0	SEV_PROC_ID, EVT_SEQ, SEQ_NUM	Global Partitioned
CI_SEV_EVT_FA	Reference Partitioning	XT217P0	SEV_PROC_ID, EVT_SEQ, FA_ID	Global Partitioned
		XT217S1	FA_ID	Global
CI_SEV_EVT_CC	Reference Partitioning	XT215P0	SEV_PROC_ID, EVT_SEQ, CC_ID	Global Partitioned
		XT215S1	CC_ID	Global

WO Process

This table describes the WO Process maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_WO_PROC	RANGE(CRE_DTTM,WO_PROC_ID)				RANGE (WO_PROC_ID)	N/A
		XT061P0	WO_PROC_ID	Global Partitioned
		XT061S1	ACCT_ID, WO_STATUS_FLG	Global
CI_WO_EVT	Reference Partitioning	XT059P0	WO_PROC_ID, EVT_SEQ	Global Partitioned
CI_WO_EVT_CC	Reference Partitioning	XT060P0	WO_PROC_ID, EVT_SEQ, CC_ID	Global Partitioned
		XT060S1	CC_ID	Global
CI_WO_PROC_SA	Reference Partitioning	XT062P0	WO_PROC_ID, SA_ID	Global Partitioned
		XT062S1	SA_ID, WO_SA_STAT_ FLG	Global

General Audit

This table describes the General Audit maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_GNRL_ AUDIT	RANGE(ILM_DT, AUDIT_ID)				RANGE (AUDIT_ID)	F1_GNRL_AUDIT.CRE_DTTM
		F1T901P0	AUDIT_ID	Global Partitioned
		F1T901S1	USER_ID	Global
		F1T901S1	AUDIT_ID, USER_ID, CRE_DTTM	Global
		CM_ILM_ F1T901S3	ILM_DT, ILM_ARCH_SW, AUDIT_ID	Local Partitioned
F1_GNRL_ AUDIT_CHAR	Reference Partitioning	F1C504P0	AUDIT_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1C504S1	SRCH_CHAR_VAL	Global
F1_GNRL_ AUDIT_VAL	Reference Partitioning	F1T902P0	AUDIT_ID, FLD_NAME	Global Partitioned
		F1T902S1	AUDIT_ID, FLD_NAME, FLD_VAL	Global

Meter Read

This table describes the Meter Read maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
CI_MR	RANGE(ILM_DT,MR_ID)				RANGE(MR_ID)	CI_MR.READ_DTTM,
		XT132P0	MR_ID	Global Partitioned
		XT132S1	MTR_CONFIG_ID, USE_ON_BILL_SW, READ_DTTM, MR_ID	Global
		CM_ILM_ XT132L0	ILM_DT,ILM_ARCH_SW,MR_ID	Local Partitioned
CI_MR_CHAR	Reference Partitioning	XT410P0	MR_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned	RANGE(MR_ID)
		XTT410S1	SRCH_CHAR_VAL	Global
CI_MR_REM	Reference Partitioning	XT135P0	MR_ID, READER_REM_CD	Global Partitioned	RANGE(MR_ID)
CI_MR_REM_EXCP	Reference Partitioning	XT024P0	MR_ID, READER_REM_CD	Global Partitioned	RANGE(MR_ID)
CI_REG_READ	Reference Partitioning	XT186P0	REG_READ_ID	Global Partitioned	RANGE(REG_READ_ID)
		XT186S1	MR_ID	Global
		XT186S2	REVIEW_HILO_SW, TRENDED_SW, REG_READ_ID	Global
		XT186S3	REG_ID	Global

Payment Arrangement Process

This table describes the Payment Arrangement Process maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_PA_RQST (Parent)	RANGE (ILM_DT,PA_RQST_ID)					C1_PA_RQST.CRE_DTTM
		C1T020P0	PA_RQST_ID	Global Partitioned	RANGE (PA_RQST_ID)
		C1T020S1	PA_RQST_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_ C1T020S2	ILM_DT,ILM_ARCH_SW,PA_RQST_ID	Local Partitioned
C1_PA_RQST_ CHAR	Reference Partitioning	C1T024P0	PA_RQST_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		C1T024S1	SRCH_CHAR_VAL	Global
C1_PA_RQST_ELIG_RSLT	Reference Partitioning	C1T022P0	PA_RQST_ID, PA_RQST_ELIG_ CRIT_SEQ	Global Partitioned
C1_PA_RQST_ LOG	Reference Partitioning	C1T025P0	PA_RQST_ID, SEQNO	Global Partitioned
		C1T025S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T025S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_PA_RQST_ LOG_PARM	Reference Partitioning	C1T026P0	PA_RQST_ID, SEQNO, PARM_SEQ	Global Partitioned
C1_PA_RQST_REL_OBJ	Reference Partitioning	C1T023P0	PA_RQST_ID, PA_RQST_REL_ OBJ_TYPE_FLG, SEQ_NUM	Global Partitioned

Customer Service Request

This table describes the Customer Service Request maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_CS_REQ (Parent)	RANGE (ILM_DT,CS_ REQ_ID)					C1_CS_REQ.CRE_DTTM
		C1T043P0	CS_REQ_ID	Global Partitioned	RANGE (CS_REQ_ID)
		C1T043S1	CS_REQ_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_ C1T043S2	ILM_DT,ILM_ARCH_SW,CS_REQ_ID	Local Partitioned
	Reference Partitioning	C1T044P0	CS_REQ_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		C1T044S1	SRCH_CHAR_VAL	Global
	Reference Partitioning	C1T046P0	CS_REQ_ID, SEQNO	Global Partitioned
		C1T046S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T046S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_CS_REQ_ LOG_PARM	Reference Partitioning	C1T047P0	CS_REQ_ID, SEQNO, PARM_SEQ	Global Partitioned
C1_CS_REQ_ REL_OBJ	Reference Partitioning	C1T045P0	CS_REQ_ID, CS_REQ_REL_OBJ_TYPE_FLG, SEQ_NUM	Global Partitioned

Customer Service Request Account

This table describes the Customer Service Request Account maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_CS_REQ_ ACCT (Parent)	RANGE (ILM_DT,CS_ REQ_ACCT_ID)					C1_CS_REQ_ACCT.CRE_DTTM
		C1T079P0	CS_REQ_ACCT_ID	Global Partitioned	RANGE (CS_REQ_ACCT_ID)
		C1T079S1	CS_REQ_ACCT_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_ C1T079S2	ILM_DT,ILM_ARCH_SW,CS_REQ_ACCT_ID	Local Partitioned
C1_CS_REQ_ ACCT_ALERT	Reference Partitioning	C1T081P0	CS_REQ_ACCT_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_ ACCT_APAY	Reference Partitioning	C1T082P0	CS_REQ_ACCT_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_ ACCT_CHAR	Reference Partitioning	C1T083P0	CS_REQ_ACCT_ID, CS_REQ_SEQ_ NUM	Global Partitioned
		C1T083S1	SRCH_CHAR_VAL	Global
C1_CS_REQ_ ACCT_LOG	Reference Partitioning	C1T090P0	CS_REQ_ACCT_ID, SEQNO	Global Partitioned
		C1T090S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T090S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_CS_REQ_ACCT_LOG_PARM	Reference Partitioning	C1T091P0	CS_REQ_ACCT_ID, SEQNO, PARM_SEQ	Global Partitioned
C1_CS_REQ_ACCT_MSG	Reference Partitioning	C1T084P0	CS_REQ_ACCT_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_ACCT_MSG_PARM	Reference Partitioning	C1T085P0	CS_REQ_ACCT_ID, CS_REQ_SEQ_ NUM, CS_REQ_MSG_ PARM_SEQ	Global Partitioned
C1_CS_REQ_ACCT_NCD	Reference Partitioning	C1T089P0	CS_REQ_ACCT_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_ACCT_PER	Reference Partitioning	C1T086P0	CS_REQ_ACCT_ PER_ID	Global Partitioned
C1_CS_REQ_ACCT_PER_ADDR	Reference Partitioning	C1T088P0	CS_REQ_ACCT_ PER_ID	Global Partitioned

Customer Service Request Consumer Contract

This table describes the Customer Service Request Consumer Contract maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_CS_REQ_ CONT (Parent)	RANGE (ILM_DT,CS_ REQ_CONT_ID)					C1_CS_REQ_CONT.CRE_DTTM
		C1T055P0	CS_REQ_CONT_ ID	Global Partitioned	RANGE (CS_REQ_CONT_ID)
		C1T055S1	CS_REQ_CONT_ ID, BUS_OBJ_CD, BO_STATUS_ CD	Global
		CM_ILM_ C1T055S2	ILM_DT,ILM_ ARCH_SW, CS_REQ_CONT_ ID	Local Partitioned
C1_CS_REQ_ CONT_CHAR	Reference Partitioning	C1T058P0	CS_REQ_CONT_ ID, CS_REQ_SEQ_ NUM	Global Partitioned
		C1T058S1	SRCH_CHAR_VAL	Global
C1_CS_REQ_ CONT_ID	Reference Partitioning	C1T057P0	CS_REQ_CONT_ ID, CS_REQ_SEQ_ NUM	Global
C1_CS_REQ_ LOG	Reference Partitioning	C1T062P0	CS_REQ_CONT_ ID, SEQNO	Global Partitioned
		C1T062S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T062S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_CS_REQ_CONT_LOG_PARM	Reference Partitioning	C1T064P0	CS_REQ_CONT_ ID, SEQNO, PARM_SEQ	Global Partitioned
C1_CS_REQ_CONT_MS	Reference Partitioning	C1T059P0	CS_REQ_CONT_ ID, CS_REQ_SEQ_ NUM	Global Partitioned
	Reference Partitioning	C1T061P0	CS_REQ_CONT_ ID, CS_REQ_SEQ_ NUM, SEQ_NUM	Global Partitioned

Customer Service Request Contract Product

This table describes the Customer Service Request Contract Product maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_CS_REQ_ CONT_PROD (Parent)	RANGE (ILM_DT,CS_ REQ_CONT_PROD_ID)					C1_CS_REQ_CONT_PROD.CRE_DTTM
		C1T065P0	CS_REQ_CONT_PROD_ID	Global Partitioned	RANGE (CS_REQ_CONT_PROD_ID)
		C1T065S1	CS_REQ_CONT_ PROD_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_ C1T065S2	ILM_DT,ILM_ARCH_SW,CS_REQ_CONT_PROD_ID	Local Partitioned
	Reference Partitioning	C1T067P0	CS_REQ_CONT_ PROD_ID, CS_REQ_SEQ_ NUM	Global Partitioned
		C1T067S1	SRCH_CHAR_VAL	Global
C1_CS_REQ_CONT_PROD_LOG	Reference Partitioning	C1T068P0	CS_REQ_CONT_PROD_ID, SEQNO	Global Partitioned
		C1T068S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T068S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_CS_REQ_CONT_LOG_PARM	Reference Partitioning	C1T069P0	CS_REQ_CONT_PROD_ID, SEQNO, PARM_SEQ	Global Partitioned

Customer Service Request Person

This table describes the Customer Service Request Person maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_CS_REQ_ PER (Parent)	RANGE (ILM_DT,CS_REQ_PER_ID)				RANGE (CS_REQ_PER_ ID)	C1_CS_REQ_ PER.CRE_DTTM
		C1T070P0	CS_REQ_PER_ID	Global Partitioned
		C1T070S1	CS_REQ_PER_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_ C1T070S2	ILM_DT,ILM_ARCH_SW,CS_REQ_ PER_ID	Local Partitioned
C1_CS_REQ_PER_ADDR_SEAS	Reference Partitioning	C1T074P0	CS_REQ_PER_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_PER_CHAR	Reference Partitioning	C1T075P0	CS_REQ_PER_ID, CS_REQ_SEQ_ NUM	Global Partitioned
		C1T075S1	SRCH_CHAR_VAL	Global
C1_CS_REQ_PER_CONTDET	Reference Partitioning	C1T073S1	CS_REQ_PER_ID, CS_REQ_SEQ_ NUM	Global
C1_CS_REQ_PER_ID	Reference Partitioning	C1T072S1	CS_REQ_PER_ID, CS_REQ_SEQ_ NUM	Global
C1_CS_REQ_PER_LOG	Reference Partitioning	C1T077P0	CS_REQ_PER_ID, SEQNO	Global Partitioned
		C1T077S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T077S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_CS_REQ_ PER_LOG_ PARM	Reference Partitioning	C1T078P0	CS_REQ_PER_ID, SEQNO, PARM_SEQ	Global Partitioned
C1_CS_REQ_ PER_NAME	Reference Partitioning	C1T071P0	CS_REQ_PER_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_ PER_PER	Reference Partitioning	C1T076P0	CS_REQ_PER_ID, CS_REQ_SEQ_ NUM	Global Partitioned

Customer Service Request Service Location

This table describes the Customer Service Request Service Location maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_CS_REQ_ SVC_LOC (Parent)	RANGE (ILM_DT,CS_REQ_SVC_LOC_ID)					C1_CS_REQ_SVC_LOC.CRE_ DTTM
		C1T049P0	CS_REQ_SVC_LOC_ID	Global Partitioned	RANGE (CS_REQ_SVC_LOC_ID)
		C1T049S1	CS_REQ_SVC_LOC_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_ C1T049S2	ILM_DT,ILM_ARCH_SW,CS_REQ_SVC_LOC_ID	Local Partitioned
C1_CS_REQ_SVC_LOC_CHAR	Reference Partitioning	C1T051P0	CS_REQ_SVC_LOC_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		C1T051S1	SRCH_CHAR_VAL	Global
C1_CS_REQ_SVC_LOC_CONT_PROD	Reference Partitioning	C1T052P0	CS_REQ_SVC_LOC_ID, CS_REQ_SEQ_NUM	Global
C1_CS_REQ_SVC_LOC_LOG	Reference Partitioning	C1T053P0	CS_REQ_SVC_LOC_ID, SEQNO	Global Partitioned
		C1T053S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T053S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_CS_REQ_SVC_LOC_LOG_PARM	Reference Partitioning	C1T054P0	CS_REQ_SVC_LOC_ID, SEQNO, PARM_SEQ	Global Partitioned

Customer Service Request Premise

This table describes the Customer Service Request Premise maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_CS_REQ_PREM (Parent)	RANGE (ILM_DT,CS_REQ_PREM_ID)					C1_CS_REQ_PREM.CRE_DTTM
		C1T092P0	CS_REQ_PREM_ID	Global Partitioned	RANGE (CS_REQ_PREM_ID)
		CM_ILM_ C1T092S1	ILM_DT, ILM_ARCH_SW, CS_REQ_PREM_ID	Local Partitioned
C1_CS_REQ_PREM_ALT_ADDR	Reference Partitioning	C1T095P0	CS_REQ_PREM_ID, CS_REQ_SEQ_ NUM	Global
C1_CS_REQ_PREM_CHAR	Reference Partitioning	C1T093P0	CS_REQ_PREM_ID, CS_REQ_SEQ_ NUM	Global Partitioned
		C1T093S1	SRCH_CHAR_VAL	Global
C1_CS_REQ_PREM_GEO	Reference Partitioning	C1T094P0	CS_REQ_PREM_ID, CS_REQ_SEQ_ NUM	Global
C1_CS_REQ_PREM_LOG	Reference Partitioning	C1T096P0	CS_REQ_PREM_ID, SEQNO	Global Partitioned
		C1T096S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T096S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_CS_REQ_PREM_LOG_PARM	Reference Partitioning	C1T097P0	CS_REQ_PREM_ID, SEQNO, PARM_SEQ	Global Partitioned

Market Charge

This table describes the Market Charge maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_MKTMSG_CHG (Parent)	RANGE (ILM_DT,MKTMSG_CHG_ID)					C1_MKTMSG_CHG.MKT_CHG_DT
		C1T135P0	MKTMSG_CHG_ID	Global Partitioned	RANGE (MKTMSG_CHG_ID)
		C1T135S1	MKTMSG_CHG_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_C1T135S2	ILM_DT,ILM_ARCH_SW,MKTMSG_ CHG_ID
C1_MKTMSG_CHG_DTL	Reference Partitioning	C1T137P0	MKTMSG_CHG_ID, MKT_SEQNO	Global Partitioned
C1_MKTMSG_CHG_LOG	Reference Partitioning	C1T139P0	MKTMSG_CHG_ID, SEQNO	Global Partitioned
		C1T139S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T139S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_MKTMSG_CHG_LOG_PARM	Reference Partitioning	C1T140P0	MKTMSG_CHG_ID, SEQNO, PARM_SEQ	Global Partitioned
C1_MKTMSG_CHG_REL_OBJ	Reference Partitioning	C1T138P0	MKTMSG_CHG_ID, MKT_REL_OBJ_ TYPE_FLG, SEQNO	Global Partitioned

Market Payment

This table describes the Market Payment maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_MKTMSG_PAY (Parent)	RANGE (ILM_DT,MKTMSG_PAY_ID)					C1_MKTMSG_ PAY.MKT_PAY_ DT
		C1T129P0	MKTMSG_PAY_ID	Global Partitioned	RANGE (MKTMSG_PAY_ID)
		C1T129S1	MKTMSG_PAY_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_ C1T129S2	ILM_DT,ILM_ARCH_SW,MKTMSG_PAY_ID	Local Partitioned
C1_MKTMSG_PAY_DTL	Reference Partitioning	C1T131P0	MKTMSG_PAY_ID, MKT_SEQNO	Global Partitioned
C1_MKTMSG_PAY_LOG	Reference Partitioning	C1T133P0	MKTMSG_PAY_ID, SEQNO	Global Partitioned
		C1T133S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T133S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_MKTMSG_PAY_LOG_PARM	Reference Partitioning	C1T134P0	MKTMSG_PAY_ID, SEQNO, PARM_SEQ	Global Partitioned
C1_MKTMSG_PAY_REL_OBJ	Reference Partitioning	C1T132P0	MKTMSG_PAY_ID, MKT_REL_OBJ_TYPE_FLG, SEQNO	Global Partitioned

Market Usage

This table describes the Market Usage maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_MKTMSG_USG (Parent)	RANGE (ILM_DT,MKTMSG_USG_ID)					C1_MKTMSG_ USG.MKT_USG_ DT
		C1T123P0	MKTMSG_USG_ID	Global Partitioned	RANGE (MKTMSG_PAY_ID)
		C1T123S1	MKTMSG_USG_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_C1T123S2	ILM_DT,ILM_ARCH_SW,MKTMSG_USG_ID	Local Partitioned
C1_MKTMSG_ USG_DTL	Reference Partitioning	C1T125P0	MKTMSG_USG_ID, MKT_SEQNO	Global Partitioned
C1_MKTMSG_ USG_LOG	Reference Partitioning	C1T127P0	MKTMSG_USG_ID, SEQNO	Global Partitioned
		C1T127S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T127S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_MKTMSG_ USG_LOG_ PARM	Reference Partitioning	C1T128P0		Global Partitioned
C1_MKTMSG_ USG_REL_OBJ	Reference Partitioning	C1T126P0		Global Partitioned

Customer Service Request SA

This table describes the Customer Service Request SA maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_CS_REQ_SA (Parent)	RANGE (ILM_DT, CS_REQ_SA_ID)					C1_CS_REQ_SA.CRE_DTTM
		C1T141P0	CS_REQ_SA_ID	Global Partitioned	RANGE(CS_REQ_SA_ID)
		C1T141S1	CS_REQ_SA_ID, BUS_OBJ_CD, BO_STATUS_CD	Global
		CM_ILM_ C1T141S2	ILM_DT,ILM_ARCH_SW,CS_REQ_SA_ID	Local Partitioned
C1_CS_REQ_SA_CHAR	Reference Partitioning	C1T143P0	CS_REQ_SA_ID, CS_REQ_SEQ_ NUM	Global Partitioned
		C1T143S1	SRCH_CHAR_VAL	Global
C1_CS_REQ_SA_LOG	Reference Partitioning	C1T156P0	CS_REQ_SA_ID, SEQNO	Global Partitioned
		C1T156S1	CHAR_TYPE_CD, CHAR_VAL_FK1	Global
		C1T156S2	CHAR_TYPE_CD, CHAR_VAL	Global
C1_CS_REQ_SA_LOG_PARM	Reference Partitioning	C1T157P0	CS_REQ_SA_ID, SEQNO, PARM_SEQ	Global Partitioned
C1_CS_REQ SA_CONTERM	Reference Partitioning	C1T151P0	CS_REQ_SA_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_SA_ CONT_QTY	Reference Partitioning	C1T149P0	CS_REQ_SA_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_SA_ COP	Reference Partitioning	C1T153P0	CS_REQ_SA_ID,CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_SA_ COP_OVRD	Reference Partitioning	C1T154P0	CS_REQ_SA_ID, CS_REQ_SEQ_ NUM,SEQNUM	Global Partitioned
C1_CS_REQ_SA_ MSG	Reference Partitioning	C1T155P0	CS_REQ_SA_ID,CS_REQ_SEQ_NUM	Global Partitioned
C1_CS_REQ_SA_ RCHG	Reference Partitioning	C1T150P0	CS_REQ_SA_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_SA_RS	Reference Partitioning	C1T148P0	CS_REQ_SA_ID, CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_SA_TOU_CONT_ VAL	Reference Partitioning	C1T152P0	CS_REQ_SA_ID, CS_REQ_SEQ_NUM,SEQ_NUM	Global Partitioned
C1_CS_REQ_SA_SP	Reference Partitioning	C1T144P0	CS_REQ_SA_SP_ID, CS_REQ_SEQ_ NUM	Global Partitioned	RANGE (CS_REQ_SA_SP_ID)
C1_CS_REQ_SA_ SP_CHAR	Reference Partitioning	C1T147P0	CS_REQ_SA_SP_ID,CS_REQ_SEQ_ NUM	Global Partitioned
C1_CS_REQ_SA_ SP_FA	Reference Partitioning	C1T146P0	CS_REQ_SA_SP_ID,CS_REQ_SEQ_ NUM	Global Partitioned

SA Arrears Snapshot

This table describes the SA Arrears Snapshot maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_BI_SA_ SNAPSHOT (Parent)	RANGE (ILM_DT,SA_ID)					C1_BI_SA_SNAP SHOT.C1_SNAPS HOT_DTTM
		C1M020P0	SA_ID,C1_ SNAPSHOT_DTTM, C1_SNAPSHOT_ TYPE_FLG	Global Partitioned	RANGE (SA_ID)
		C1M020S1	SA_ID	Global
		C1M020S2	ACCT_ID	Global
		C1M020S3	PER_ID	Global
		C1M020S4	CURRENCY_CD	Global
		CM_ILM_ C1M020S5	ILM_DT,ILM_ ARCH_SW, SA_ID	Local Partitioned

Notification Preference

This table describes the Notification Preference maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
C1_NTF_ PREF (Parent)	RANGE (ILM_DT,NTF_PREF_ID)					C1_NTF_PREF.STATUS_UPD_DTTM
		C1T002P0	NTF_PREF_ID	Global Partitioned	RANGE (NTF_PREF_ ID)
		C1T002S1	ACCT_ID	Global
		C1T002S2	NTF_PREF_ID,BO_STATUS_CD,STATUS_UPD_DTTM	Global
		C1T002S3	C1_CONTACT_ID	Global
		CM_ILM_C1T002S4	ILM_DT,ILM_ARCH_SW,NTF_PREF_ID	Local
C1_NTF_ PREF_CHAR	Reference Partitioning	C1T003P0	NTF_PREF_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		C1T003S1	SRCH_CHAR_ VAL	Global
C1_NTF_ PREF_LOG	Reference Partitioning	C1T004P0	NTF_PREF_ID, SEQNO	Global Partitioned
		C1T004S1	CHAR_TYPE_CD, CHAR_VAL_ FK1	Global
		C1T004S2	CHAR_TYPE_ CD, CHAR_VAL	Global
C1_NTF_PREF_LOG_PARM	Reference Partitioning	C1T005P0	NTF_PREF_ID, SEQNO, PARM_SEQ	Global Partitioned
C1_NTF_ PREF_ID	Reference Partitioning	C1T006P0	NTF_PREF_ID,NTF_PREF_ID_TYPE_FLG	Global Partitioned

Inbound Market Message

This table describes the Inbound Market Message maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_MKTMSG_IN(Parent)	RANGE(ILM_DT,MKTMSG_ID)	F1T759P0	MKTMSG_ID	Global Partitioned	Range(MKTMSG_ID)	F1_MKTMSG_IN.CRE_DTTM
		F1T759S1	BO_STATUS_CD, BUS_OBJ_CD, MKTMSG_ID	Global
		CM_ILM_F1T759L0	ILM_DT, ILM_ARCH_SW, MKTMSG_ID	Local Partitioned
F1_MKTMSG_IN_CHAR	Reference Partitioning	F1T760P0	MKTMSG_ID, CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		F1T760S1	SRCH_CHAR_VAL	Global
F1_MKTMSG_IN_DATA	Reference Partitioning	F1T761P0	MKTMSG_ID, MKT_DATA_TYPE_FLG	Global Partitioned
	Reference Partitioning	F1T762P0	MKTMSG_ID, MKT_REF_TYPE_FLG, SEQNO	Global Partitioned
F1_MKTMSG_IN_ID	Reference Partitioning	F1T763P0	MKTMSG_ID, MKT_ID_TYPE_FLG	Global Partitioned
F1_MKTMSG_IN_LOG	Reference Partitioning	F1T765P0	MKTMSG_ID, SEQNO	Global Partitioned
		F1T765S1	CHAR_TYPE_ CD,CHAR_VAL_FK1	Global
		F1T765S2	CHAR_TYPE_ CD, CHAR_VAL	Global
F1_MKTMSG_IN_LOG_PARM	Reference Partitioning	F1T766P0	MKTMSG_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_MKTMSG_IN_REL_OBJ	Reference Partitioning	F1T767P0	MKTMSG_ID, MKT_REL_OBJ_TYPE_FLG, SEQNO	Global Partitioned

Outbound Market Message

This table describes the Outbound Market Message maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_MKTMSG_OUT(Parent)	RANGE(ILM_DT,MKTMSG_ID)	F1T782P0	MKTMSG_ID	Global Partitioned	Range(MKTMSG_ID)	F1_MKTMSG_OUT.CRE_DTTM
		F1T782S1	BO_STATUS_CD, BUS_OBJ_CD, MKTMSG_ID	Global
		CM_ILM_F1T782L0	ILM_DT, ILM_ARCH_SW, MKTMSG_ID	Local Partitioned
F1_MKTMSG_OUT_CHAR	Reference Partitioning	F1T783P0	MKTMSG_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		F1T783S1	SRCH_CHAR_VAL	Global
F1_MKTMSG_OUT_DATA	Reference Partitioning	F1T784P0	MKTMSG_ID, MKT_DATA_TYPE_FLG	Global Partitioned
F1_MKTMSG_OUT_EXT_ REF	Reference Partitioning	F1T785P0	MKTMSG_ID, MKT_REF_TYPE_FLG, SEQNO	Global Partitioned
F1_MKTMSG_OUT_ID	Reference Partitioning	F1T786P0	MKTMSG_ID, MKT_ID_TYPE_FLG	Global Partitioned
F1_MKTMSG_OUT_LOG	Reference Partitioning	F1T788P0	MKTMSG_ID, SEQNO	Global Partitioned
		F1T788S1	CHAR_TYPE_CD, CHAR_VAL_ FK1	Global
		F1T788S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_MKTMSG_OUT_LOG_PARM	Reference Partitioning	F1T789P0	MKTMSG_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_MKTMSG_OUT_REL_ OBJ	Reference Partitioning	F1T790P0	MKTMSG_ID, MKT_REL_OBJ_TYPE_FLG, SEQNO	Global Partitioned

Market Process

This table describes the Market Process maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_MKTPROC (Parent)	Range(ILM,MKTPROC_ID)	F1T768P0	MKTPROC_ID	Global Partitioned	Range (MKTPROC_ ID)	F1_MKTPROC.CRE_ DTTM
		F1T768S1	BO_STATUS_ CD, BUS_OBJ_CD, MKTPROC_ID	Global
		CM_ILM_F1T768L0	ILM_DT, ILM_ARCH_ SW, MKTPROC_ID	Local Partitioned
F1_MKTPROC_CHAR	Reference Partitioning	F1T769P0	MKTPROC_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		F1T769S1	SRCH_CHAR_VAL	Global
F1_MKTPROC_ID	Reference Partitioning	F1T770P0	MKTPROC_ID, MKT_ID_TYPE_FLG	Global Partitioned
F1_MKTPROC_LOG	Reference Partitioning	F1T772P0	MKTPROC_ID, SEQNO	Global Partitioned
F1_MKTPROC_LOG_PARM	Reference Partitioning	F1T773P0	MKTPROC_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_MKTPROC_REL_OBJ	Reference Partitioning	F1T775P0	MKTPROC_ID, MKT_REL_OBJ_TYPE_FLG, SEQNO	Global Partitioned
F1_MKTPROC_REL_PROC	Reference Partitioning	F1T774P0	MKTPROC_ID, MKTPROC_REL_ID, MKTPROC_REL_TYPE_FLG	Global Partitioned

Market Process Event

This table describes the Market Process Event maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_MKTPROC_EVT(Parent)	Range(ILM_DT,MKTPROC_EVT_ID)	F1T776P0	MKTPROC_EVT_ID	Global Partitioned	Range(MKTPROC_EVT_ID)	F1_MKTPROC_EVT.CRE_DTTM
		F1T776S1	MKTPROC_ID	Global
		F1T776S2	MKT_REG_ NBR, BUS_OBJ_CD, BO_STATUS_ CD	Global
		F1T776S3	BO_STATUS_CD, BUS_OBJ_CD, MKTPROC_EVT_ID	Global
		CM_ILM_F1T776L0	ILM_DT, ILM_ARCH_SW, MKTPROC_ EVT_ID	Local Partitioned
F1_MKTPROC_EVT_CHAR	Reference Partitioning	F1T777P0	MKTPROC_EVT_ID, CHAR_TYPE_CD, SEQ_NUM	Global Partitioned
		F1T777S1	SRCH_CHAR_ VAL	Global
F1_MKTPROC_EVT_LOG	Reference Partitioning	F1T779P0	MKTPROC_EVT_ID, SEQNO	Global Partitioned
		F1T779S1	CHAR_TYPE_CD, CHAR_VAL_ FK1	Global
		F1T779S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_MKTPROC_EVT_LOG_ PARM	Reference Partitioning	F1T780P0	MKTPROC_EVT_ID, SEQNO, PARM_SEQ	Global Partitioned
F1_MKTPROC_EVT_REL_ OBJ	Reference Partitioning	F1T781P0	MKTPROC_EVT_ID, MKT_REL_OBJ_TYPE_FLG, SEQNO	Global Partitioned

Mobile Remote Message

This table describes the Mobile Remote Message maintenance object.

Table Name	Table Partitioning Type (Partitioning, Sub-Partitioning Key)	Index Name	Index Columns	Index Type Global or Local	Index Partitioning Sub-Partitioning Key	ILM_DT Initial Load
F1_REMOTE_MSG (Parent)	Range(ILM_DT,F1_REMOTE_MSG_ID)	F1T735P0	F1_REMOTE_MSG_ID	Global Partitioned	Range(F1_REMOTE_MSG_ID)	F1_REMOTE_MSG.CRE_DTTM
		F1T735S1	CRE_DTTM	Global
		F1T735S2	F1_MDT_ID	Global
		F1T735S3	MAINT_OBJ_ CD	Global
		F1T735S4	PK_VALUE1	Global
		F1T735S5	F1_DEVICE_ MSG_ID	Global
		F1T735S6	F1_MDT_ID, F1_MSG_CLASS_FLG, F1_DELIVERY_STATE_FLG	Global
		F1T735S7	BO_STATUS_ CD, BUS_OBJ_CD, F1_REMOTE_MSG_ID	Global
		CM_ILM_F1T735L0	ILM_DT, ILM_ARCH_SW, F1_REMOTE_ MSG_ID	Local Partitioned
F1_REMOTE_MSG_CHAR	Reference Partitioning	F1T736P0	F1_REMOTE_MSG_ID, CHAR_TYPE_ CD, SEQ_NUM	Global Partitioned
		F1T736S1	SRCH_CHAR_ VAL	Global
F1_REMOTE_MSG_LOG	Reference Partitioning	F1T737P0	F1_REMOTE_MSG_ID, SEQNO	Global Partitioned
		F1T737S1	CHAR_TYPE_CD, CHAR_VAL_ FK1	Global
		F1T737S2	CHAR_TYPE_CD, CHAR_VAL	Global
F1_REMOTE_MSG_LOG_PARM	Reference Partitioning	F1T738P0	F1_REMOTE_MSG_ID, SEQNO, PARM_SEQ	Global Partitioned