ILM Database Administrator’s Tasks

For a database administrator, there are two key phases involved with managing your data using ILM.

• Preparation Phase: Covers the database level configuration that needs to be done before the ILM solution runs in a production environment.

• On-going Maintenance Phase: Covers the ongoing maintenance tasks, such as add partition, archive and restore partitions.

• Database Blueprint Installation: Describes additional steps about how to install/upgrade in ADM with ILM partitioning.

• Naming Convention: Covers the recommended naming convention to be used for partitions/subpartitions and tablespaces.

Preparation Phase

Note: To successfully implement ILM as described here, the following DB Version and Patch are pre-requisites: database version 19.3.0.0 or newer.

The steps needed to enable ILM functionality differ depending on whether ILM is enabled as part of the initial implementation of the product or enabled ILM on an existing implementation where data already exists in the respective tables.

• Initial Install: For an initial installation, the section Module Specific ILM Implementation Details outlines the additional steps to be performed on base delivered ILM Enabled Tables to conform to ILM requirements. In addition, Sample SQL for Enabling ILM for CCB (Initial Install) provides sample reference DDLs using two maintenance objects as examples.

• Transform NON-ILM implementation to ILM Enabled Implementation: The following steps provide a high level overview of steps that must be performed to implement ILM on enabled MOs for an existing implementation. Please refer to Sample SQL For Enabling ILM for CCB (Existing Installation) for detailed information using To Do Entry as an example.

1. Rename the existing tables (Parent table followed by child table(s)), and primary key index associated with ILM enabled MOs by renaming the tables.

2. Save the DDLs for the secondary indexes as you will need to recreate them later.

3. Drop secondary indexes on the renamed tables.

4. Create Partitioned table with no secondary indexes for ILM enabled MOs using a CTAS operation (Create Table as Select), which will also load the data into the partitioned table structure.

Functional Note: ILM enabled MOs should have the ILM date (ILM_DT) populated when data is moved into the new partitioned table. Please refer to the Module Specific ILM Implementation Details section below for initial load details on which date column to use as the basis for populating the ILM date. Often it is based on Create Date (CRE_DTTM). ILM_ARCH_SW should initially be set to ‘N’.

5. Enable logging option.

6. Create Primary Key index.

7. Create Primary Key Constraint of parent table.

8. Create secondary indexes for the newly-created partitioned tables. This includes creating an index used specifically to benefit the ILM Crawler batch. The recommendation for this index name is to prefix it with "ILM".

Note: This can be created specifying parallel index create; remember to turn off parallelism after the index is created.

9. Follow similar operation for all child tables for this MO, such as rename child table, and primary key index, generate DDL for secondary index, drop secondary index etc. Sample DDL for child tables their partitioning and indexes can be found in Sample SQL For Enabling ILM for CCB (Existing Installation). Please note that child table should be partitioned using reference partitioning of the parent table’s partitioning key.

10. Drop the original, renamed tables after verifying the newly created partitioned tables.

On-going Maintenance Phase

The following steps provide a high level overview of what needs to be done for on-going maintenance for ILM on enabled maintenance objects.

Please refer to the Sample SQL for Periodic Maintenance for CCB Data for detailed information using two maintenance objects as examples.

1. Add the partition:

a. Create Tablespace to be used for the new parent table partition.

b. Since, we define MAXVALUE Partition; new partition can only be created using “SPLIT” operation. Identify and use next HIGH_VALUE Partition for the split operation.

c. All the child table(s) partition(s)\LOB(s) must be altered to use the same tablespace as that of the parent table’s partition.

d. Enable advanced compression on all child table(s).

e. Copy partition level statistics from the previous partition

2. Archive the partition:

a. Make the tablespace that will be archived READ ONLY.

b. Check that no records have ILM_ARCH_SW = ‘N’.

• If record count is zero, proceed with further steps.

• If record count is not zero, then change the tablespace back to READ WRITE MODE as Archive is not Feasible at the time.

c. Create an archive tablespace for the partition that needs to be archived.

d. Create staging tables using the new archive tablespace. Load data for all child tables first.

e. Create staging table using the new archive tablespace and load data for the parent table.

f. Export tablespace using TRANSPORT_TABLESPACES method.

Make Sure Tablespace datafile required for further import is preserved.

g. Drop the partition, partition the tablespace and archive the tablespace (as it is already exported).

3. Restore the partition:

a. Create a new tablespace to restore the partition.

b. Add partition using split operation on next greater high value partition.

If the table contains LOBS, there will an additional statement in split partition DDL indicating tablespace where the LOBs will be stored.

c. Enable advanced compression on all child table(s).

d. Import Tablespace using TRANSPORT_TABLESPACES method.

e. Load data into the parent table first from the staging table

f. Load data into the child table from the staging table

g. Drop the archive tablespace after import and data loading is successful.

4. Move Data between different storage tiers:

The ILM facilities can be used within the database to implement storage savings, as follows:

• Use ILM Assistant to define the data groups to be used for the individual objects. Assign those data groups to partitions and storage devices to implement the storage savings.

• Use ILM assistant to generate the necessary commands to implement the data changes manually or use Automatic Storage Management (ASM) to automate the data storage policies.

• Optionally, use Automatic Data Optimization to provide further optimizations.

For more information about ILM refer to the following:

• Oracle Database VLDB and Partitioning Guide (19c) available at:

https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/manage-data-db-ilm.html

• Oracle Enterprise Manager 13.4 Lifecycle Management available at:

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.4/lifecycle.html

Database Blueprint Installation

This section describes additional steps about how to install/upgrade in ADM with ILM partitioning. OraDBI will have an option for ILM using -t and -x parameters in ADB. Please add both parameters at the end of the OraDBI command.

Example:

Non ILM partitioned:

java -Xmx1500M com.oracle.ouaf.oem.install.OraDBI -d jdbc:oracle:thin:@<tnsname>?TNS_ADMIN=<wallet location>,<DBUSER>,<DBPASS>,<RW_USER>,<R_USER>,<RW_USER_ROLE>,<R_USER_ROLE>,<DBUSER> -p <RW_USERPASS>,<R_USERPASS>

ILM partitioned:

For initial install instructions, refer to Initial Install (Installing V2.0.0.1.3 for the First Time) section.

For upgrade instructions, refer to the Upgrade Install section.

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: Formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME. Example: CM_D1T304_PMAX CM_D1T304_P2017JAN • SubPartition Tablespace Name: It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME_SUBPARTITIONNAME. 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. Example: CM_D1T304_P2017JAN_ARC • Archive Staging Table And Its Tablespace Name (When archiving subpartition): It is formed by OWNERFLAG_TABLEIDENTIFIER_PARTITIONNAME_SUBPARTITIONNAME_ ARCHIVEFLAG. Example: CM_D1T304_P2017JAN_S181_ARC • Compressed Tablespace name (When compressing partition): 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 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

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
	Reference Partitioning	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
		XT039S8	ENTRY_STATUS_FLG,TD_TYPE_CD,MESSAGE_CAT_NBR,MESSAGE_NBR	Global
		CM_ILM_XT039L0	ILM_DT,ILM_ARCH_SW,TD_ENTRY_ID	Local
CI_TD_DRLKEY	Reference Partitioning	XT037P0	TD_ENTRY_ID,SEQ_NUM	Global Partitioned
		XT037S1	KEY_VALUE,TD_ENTRY_ID	Global
CI_TD_MSG_PARM	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
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_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

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
	Reference Partitioning	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_F1T014L0	ILM_DT,ILM_ARCH_SW,F1_SYNC_REQ_ID	Local
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_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		Global
F1_SYNC_REQ_LOG_ PARM	Reference Partitioning	F1T016P0		Global Partitioned
F1_SYNC_REQ_EXTRACT	Reference Partitioning	F1T019P0		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
	Reference Partitioning	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_F1T191L0	ILM_DT,ILM_ARCH_SW,F1_SYNC_REQ_IN_ID	Local
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	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	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(OUTMSG_ID)	F1_OUTMSG.CRE_DTTM
	Reference Partitioning	FT010P0	OUTMSG_ID	Global Partitioned
		FT010S1	OUTMSG_STATUS_FLG,OUTMSG_TYPE_CD	Global
		FT010S2	NT_XID_CD,CRE_DTTM,OUTMSG_STATUS_FLG	Global
		CM_ILM_FT010L0	ILM_DT,ILM_ARCH_SW,OUTMSG_ID	Local
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
	Reference Partitioning	F1C474P0	F1_SVC_TASK_ID	Global Partitioned
		F1C474S1	F1_STASK_TYPE_CD	Global
		F1C474S2	BUS_OBJ_CD	Global
		F1C474S3	BO_STATUS_CD,BUS_OBJ_CD,F1_SVC_TASK_ID	Global
		CM_ILM_F1C474L0	ILM_DT,ILM_ARCH_SW,F1_SVC_TASK_ID	Local
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	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
	Reference Partitioning	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_FT035L0	ILM_DT,ILM_ARCH_SW,REV_ID	Local
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	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)				RANGE(ERASURE_SCHED_ID)	F1_ERASURE_SCHED.STATUS_UPD_DTTM
	Reference Partitioning	F1T756P0	ERASURE_SCHED_ID	Global Partitioned
		F1T756S1	BO_STATUS_CD,BUS_OBJ_CD,ERASURE_SCHED_ID	Global
		CM_ILM_F1T756L0	ILM_DT,ILM_ARCH_SW,ERASURE_SCHED_ID	Local
F1_ERASURE_SCHED_LOG_PARM	Reference Partitioning	F1T758P0	ERASURE_SCHED_ID,SEQNO,PARM_SEQ	Global Partitioned
F1_ERASURE_SCHED_LOG	Reference Partitioning	F1T757P0	ERASURE_SCHED_ID,SEQNO	Global Partitioned
		F1T757S1	CHAR_TYPE_CD,CHAR_VAL_FK1	Global
		F1T757S2	CHAR_TYPE_CD,CHAR_VAL	Global

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)				RANGE(PROC_STORE_ID)	F1_PROC_STORE.STATUS_UPD_DTTM
	Reference Partitioning	F1T747P0	PROC_STORE_ID	Global Partitioned
		F1T747S1	BO_STATUS_CD,BUS_OBJ_CD,PROC_STORE_ID	Global
		CM_ILM_F1T747L0	ILM_DT,ILM_ARCH_SW	Local
F1_PROC_STORE_LOG_PARM	Reference Partitioning	F1T750P0	PROC_STORE_ID,SEQNO,PARM_SEQ	Global Partitioned
F1_PROC_STORE_DTL_ELEMENTS	Reference Partitioning	F1T748P0	PROC_STORE_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		F1T748S1	SRCH_CHAR_VAL	Global
F1_PROC_STORE_LOG	Reference Partitioning	F1T749P0	PROC_STORE_ID,SEQNO	Global Partitioned
		F1T749S1	CHAR_TYPE_CD,CHAR_VAL_FK1	Global
		F1T749S2	CHAR_TYPE_CD,CHAR_VAL	Global

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
	Reference Partitioning	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_XT012L0	ILM_DT,ILM_ARCH_SW	Local
CI_ADJ_CHAR	Reference Partitioning	XC781P0	ADJ_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		XC781S1	SRCH_CHAR_VAL	Global
CI_ADJ_APREQ	Reference Partitioning	XT160P0	AP_REQ_ID	Global Partitioned
		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

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
	Reference Partitioning	XT600P0	APPR_REQ_ID	Global Partitioned
		CM_ILM_XT600L0	ILM_DT,ILM_ARCH_SW	Local
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
	Reference Partitioning	XT033P0	BILL_ID		(
		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
		XT033S7	ACCT_ID,OFFCYC_BGEN_ID,CRE_DTTM	Global
		XT033S8	LATE_PAY_CHARGE_SW,LATE_PAY_CHARGE_DT,BILL_ID	Global
		CM_ILM_XT033L0	ILM_DT,ILM_ARCH_SW	Local
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_CHAR	Reference Partitioning	XT313P0	BILL_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		XT313S1	SRCH_CHAR_VAL	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
Reference Partitioning		XT048P0	BSEG_ID	Global Partitioned
		XT048S1	BILL_ID	Global
		XT048S2	SA_ID	Global
		XT048S3	QUOTE_DTL_ID,BSEG_ID	Global
		CM_ILM_XT048L0	ILM_DT,ILM_ARCH_SW	Local
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_EXCP	Reference Partitioning	XT051P0	BSEG_ID	Global Partitioned
CI_BSEG_ITEM	Reference Partitioning	XT053P0	BSEG_ID,SEQNO	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_CL_CHAR	Reference Partitioning	XT056P0	BSEG_ID,HEADER_SEQ,SEQNO,CHAR_TYPE_CD	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
	Reference Partitioning	XT088P0	STM_ID	Global Partitioned
		CM_ILM_XT088L0	ILM_DT,STM_ID	Local
CI_STM_DTL	Reference Partitioning	XT119P0	STM_DTL_ID	Global Partitioned
		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
	Reference Partitioning	XT197P0	OFFCYC_BGEN_ID	Global Partitioned
		XT197S1	ACCT_ID	Global
		CM_ILM_XT197L0	ILM_DT,ILM_ARCH_SW	Local
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_SA	Reference Partitioning	XT359P0	OFFCYC_BGEN_ID,SA_ID	Global Partitioned
		XT359S1	SA_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_PARM	Reference Partitioning	XT357P0	OFFCYC_BGEN_ID,SEQNO,PARM_SEQ	Global Partitioned
C1_OFFCYC_BGEN_BSEG	Reference Partitioning	C1T160P0	OFFCYC_BGEN_ID,BSEG_CLASS_FLG,BSEG_ID	Global Partitioned

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
	Reference Partitioning	XT035P0	BILLABLE_CHG_ID	Global Partitioned
		XT035S1	SA_ID	Global
		CM_ILM_XT035L0	ILM_DT,ILM_ARCH_SW	Local
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
CI_BCHG_READ	Reference Partitioning	XT271P0	BILLABLE_CHG_ID,SP_ID,SEQNO	Global Partitioned
		XT271S1	START_REG_READ_ID	Global
		XT271S2	END_REG_READ_ID	Global

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 or given CASE_ID
	Reference Partitioning	XT220P0	CASE_ID	Global Partitioned
		XT220S1	PER_ID	Global
		XT220S2	ACCT_ID	Global
		XT220S3	PREM_ID	Global
		XT220S4	USER_ID	Global
		CM_ILM_XT220L0	ILM_DT,ILM_ARCH_SW	Local
CI_CASE_LOG_PARM	Reference Partitioning	XT290P0	CASE_ID,SEQ_NUM,PARM_SEQ	Global 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

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
	Reference Partitioning	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
		XT094S7	FA_EXT_ID,FA_ID	Global
		CM_ILM_XT094L0	ILM_DT,ILM_ARCH_SW	Local
CI_FA_CHAR	Reference Partitioning	XT406P0	FA_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		XT406S1	SRCH_CHAR_VAL	Global
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_LOG	Reference Partitioning	XT350P0	FA_ID,SEQ_NUM	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
	Reference Partitioning	XT193P0	ENRL_ID	Global Partitioned
		XT193S1	PER_ID	Global
		XT193S2	ACCT_ID	Global
		XT193S3	PREM_ID	Global
		CM_ILM_XT193L0	ILM_DT,ILM_ARCH_SW	Local
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	C1T011P0	C1_ENRL_CONTACT_ID	Global Partitioned
		C1T011S1	PER_ID	Global

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
	Reference Partitioning	XT159P0	PAY_EVENT_ID	Global Partitioned
		XT159S1	PAY_EVENT_ID,PAY_DT	Global
		XT159S2	DOC_ID,PAY_EVENT_ID	Global
		CM_ILM_XT159L0	ILM_DT,ILM_ARCH_SW	Local
CI_APAY_CLR_STG	Reference Partitioning	XT003P0	APAY_CLR_ID	Global Partitioned
		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_EVT_EXCP	Reference Partitioning	XT161P0	PAY_EVENT_ID	Global Partitioned
CI_PAY_TNDR	Reference Partitioning	XT265P0	PAY_TENDER_ID	Global Partitioned
		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_PEVT_DST_DTL	Reference Partitioning	XT730P0	PAY_EVENT_ID,SEQ_NUM	Global Partitioned
		XT730S1	SRCH_CHAR_VAL	Global
CI_PAY_TNDR_CHAR	Reference Partitioning	XT413P0	PAY_TENDER_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		XT413S1	SRCH_CHAR_VAL	Global
CI_PAY_EVT_CHAR	Reference Partitioning	XT244P0	PAY_TENDER_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		XT244S1	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
	Reference Partitioning	XT156P0	PAY_ID	Global Partitioned
		XT156S1	ACCT_ID	Global
		XT156S2	PAY_EVENT_ID	Global
		XT156S3	PAY_AMT,PAY_ID	Global
		CM_ILM_XT156L0	ILM_DT,ILM_ARCH_SW	Local
CI_PAY_EXCP	Reference Partitioning	XT163P0	PAY_ID	Global Partitioned
CI_PAY_SEG	Reference Partitioning	XT165P0	PAY_SEG_ID	Global Partitioned
		XT165S1	PAY_ID	Global
		XT165S2	SA_ID	Global
CI_PAY_CHAR	Reference Partitioning	XT412P0	PAY_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		XT412S1	SRCH_CHAR_VAL	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
	Reference Partitioning	XT266P0	MATCH_EVT_ID	Global Partitioned
		XT266S1	ACCT_ID,MEVT_STATUS_FLG	Global
		XT266S2	PAY_ID	Global
		CM_ILM_XT266L0	ILM_DT,ILM_ARCH_SW	Local

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
	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	Global
		CT368S3	USER_ID,USAGE_ID	Global
		CT368S4	MASTER_USAGE_ID	Global
		XT368S4	SA_ID	Global
		CT368S5	SA_REL_ID	Global
		CM_ILM_CT368L0	ILM_DT,ILM_ARCH_SW	Local
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
	Reference Partitioning	F1T681P0	BUS_FLG_ID	Global Partitioned
		F1T681S1	BO_STATUS_CD,BUS_OBJ_CD,BUS_FLG_ID	Global
		CM_ILM_F1T681L0	ILM_DT,ILM_ARCH_SW	Local
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
	Reference Partitioning	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
		F1T735S7	BO_STATUS_CD,BUS_OBJ_CD,F1_REMOTE_MSG_ID	Global
		CM_ILM_F1T735L0	#NAME?	Local
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_CHAR	Reference Partitioning	F1T736P0	F1_REMOTE_MSG_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		F1T736S1	SRCH_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
	Reference Partitioning	F1C706P0	SNAPSHOT_ID	Global Partitioned
		F1C706S1	BUS_OBJ_CD,BO_STATUS_CD,SNAPSHOT_ID	Global
		CM_ILM_F1C706L0	ILM_DT,ILM_ARCH_SW	Local
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
	Reference Partitioning	C1T017P0	CUST_REL_REQ_ID	Global Partitioned
		C1T017S1	CUST_REL_REQ_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		CM_ILM_C1T017L0	ILM_DT,ILM_ARCH_SW	Local
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_REL_OBJ	Reference Partitioning	C1T018P0	CUST_REL_REQ_ID,CRR_REL_OBJ_TY_FLG,SEQ_NUM	Global Partitioned
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

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 (Parent)	RANGE(ILM_DT,CC_ID)				RANGE(CC_ID)	CI_CC. CC_DTTM, CI_CC. LETTER_PRI NT_DTTM
	Reference Partitioning	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
		XT057S5	PREM_ID	Global
		XT057S6	C1_CONTACT_ID	Global
		XT057S7	NTF_INST_ID	Global
		XT057S8	NTF_CONTACT_ID	Global
		CM_ILM_XT057L0	ILM_DT,ILM_ARCH_SW	Local
CI_CC_CHAR	Reference Partitioning	XT280P0	CC_ID,CHAR_TYPE_CD	Global Partitioned
		C1T007S1	SRCH_CHAR_VAL	Global
CI_CC_LOG	Reference Partitioning	XT281P0	CC_LOG_ID	Global Partitioned
		XT281S1	CC_ID	Global
C1_CC_LOG	Reference Partitioning	C1T162P0	CC_ID,SEQNO	Global Partitioned
		C1T162S1	CHAR_TYPE_CD,CHAR_VAL_FK1	Global
		C1T162S2	CHAR_TYPE_CD,CHAR_VAL	Global
C1_CC_IDENTIFIER	Reference Partitioning	C1T161P0	CC_ID,CC_ID_TYPE_FLG	Global Partitioned
		C1T161S1	CC_EXT_REF_ID	Global
C1_CC_LOG_PARM	Reference Partitioning	C1T163P0	CC_ID,SEQNO,PARM_SEQ	Global Partitioned

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
	Reference Partitioning	XT073P0	COLL_PROC_ID	Global Partitioned
		XT073S1	ACCT_ID,COLL_STATUS_FLG	Global
		CM_ILM_XT073L0	ILM_DT,ILM_ARCH_SW	Local
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 (Parent)	RANGE(CRE_DTTM,CUT_PROC_ID)				RANGE (CUT_PROC_ID)	N/A
	Reference Partitioning	XT324P0	CUT_PROC_ID	Global Partitioned
		XT324S1	OD_PROC_ID,OD_EVT_SEQ	Global
		XT324S2	SA_ID,CUT_PROC_ID	Global
		CM_ILM_XT324L0	ILM_DT,ILM_ARCH_SW	Local
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 (Parent)	RANGE(ILM_DT,OD_PROC_ID)				RANGE (OD_PROC_ID)	N/A
	Reference Partitioning	XT315P0	OD_PROC_ID	Global Partitioned
		XT315S1	ACCT_ID,OD_STATUS_FLG	Global
		CM_ILM_XT315L0	ILM_DT,ILM_ARCH_SW	Local
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 (Parent)	RANGE(ILM_DT,SEV_PROC_ID)				RANGE (SEV_PROC_ID)	N/A
	Reference Partitioning	XT118P0	SEV_PROC_ID	Global Partitioned
		XT118S1	SA_ID,SEV_PROC_ID	Global
		XT118S2	COLL_PROC_ID,EVT_SEQ	Global
		CM_ILM_XT118L0	ILM_DT,ILM_ARCH_SW	Local
CI_SEV_EVT	Reference Partitioning	XT214P0	SEV_PROC_ID,EVT_SEQ	Global Partitioned
CI_SEV_EVT_CC	Reference Partitioning	XT215P0	SEV_PROC_ID,EVT_SEQ,CC_ID	Global Partitioned
		XT215S1	CC_ID	Global
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

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)
CI_WO_PROC (Parent)	RANGE(ILM_DT,WO_PROC_ID)				RANGE(WO_PROC_ID)
	Reference Partitioning	XT061P0	WO_PROC_ID	Global Partitioned
		XT061S1	ACCT_ID,WO_STATUS_FLG	Global
		CM_ILM_XT061L0	ILM_DT,ILM_ARCH_SW,WO_PROC_ID	Local
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 (Parent)	RANGE(ILM_DT, AUDIT_ID)				RANGE (AUDIT_ID)	F1_GNRL_AUDIT.CRE_DTTM
	Reference Partitioning	F1T901P0	AUDIT_ID	Global Partitioned
		F1T901S1	USER_ID	Global
		F1T901S2	AUDIT_ID,USER_ID,CRE_DTTM	Global
		CM_ILM_F1T901L0	ILM_DT,ILM_ARCH_SW,AUDIT_ID	Local
F1_GNRL_AUDIT_VAL	Reference Partitioning	F1T902P0	AUDIT_ID,FLD_NAME	Global Partitioned
		F1T902S1	AUDIT_ID,FLD_NAME,FLD_VAL	Global
F1_GNRL_AUDIT_CHAR	Reference Partitioning	F1C504P0	AUDIT_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		F1C504S1	SRCH_CHAR_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 (Parent)	RANGE(ILM_DT,MR_ID)				RANGE(MR_ID)	CI_MR.READ_DTTM
	Reference Partitioning	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
CI_MR_CHAR	Reference Partitioning	XT410P0	MR_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		XT410S1	SRCH_CHAR_VAL	Global
CI_MR_REM	Reference Partitioning	XT135P0	MR_ID,READER_REM_CD	Global Partitioned
CI_MR_REM_EXCP	Reference Partitioning	XT024P0	MR_ID,READER_REM_CD	Global Partitioned
CI_REG_READ	Reference Partitioning	XT186P0	REG_READ_ID	Global Partitioned
		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)				RANGE(PA_RQST_ID)	C1_PA_RQST.CRE_DTTM
	Reference Partitioning	C1T020P0	PA_RQST_ID	Global Partitioned
		C1T020S1	PA_RQST_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T020S2	ACCT_ID	Global
		CM_ILM_C1T020L0	ILM_DT,ILM_ARCH_SW,PA_RQST_ID	Local
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_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
C1_PA_RQST_ELIG_RSLT	Reference Partitioning	C1T022P0	PA_RQST_ID,PA_RQST_ELIG_CRIT_SEQ	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)				RANGE(CS_REQ_ID)	C1_CS_REQ.CRE_DTTM
	Reference Partitioning	C1T043P0	CS_REQ_ID	Global Partitioned
		C1T043S1	CS_REQ_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T043S2	C1_CREATED_BY_USER	Global
		C1T043S3	C1_FINAL_USER	Global
		C1T043S4	CS_REQ_TYPE_CD	Global
		C1T043S5	CS_REQ_EXT_REF_ID,CS_REQ_ID	Global
		C1T043S6	CRE_DTTM,CS_REQ_ID	Global
		CM_ILM_C1T043L0	ILM_DT,ILM_ARCH_SW,CS_REQ_ID	Local
C1_CS_REQ_CHAR	Reference Partitioning	C1T044P0	CS_REQ_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		C1T044S1	SRCH_CHAR_VAL	Global
C1_CS_REQ_LOG	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
		C1T045S1	MAINT_OBJ_CD,PK_VALUE1,PK_VALUE2	Global
		C1T045S2	PK_VALUE1,CS_REQ_REL_OBJ_TYPE_FLG,MAINT_OBJ_CD	Global

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)				RANGE(CS_REQ_ACCT_ID)	C1_CS_REQ_ACCT.CRE_DTTM
	Reference Partitioning	C1T079P0	CS_REQ_ACCT_ID	Global Partitioned
		C1T079S1	CS_REQ_ACCT_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T079S2	CS_REQ_ID	Global
		C1T079S3	MAILING_PREM_ID	Global
		C1T079S4	ACCT_ID	Global
		C1T079S5	BILL_PRT_INTERCEPT	Global
		CM_ILM_C1T079L0	ILM_DT,ILM_ARCH_SW,CS_REQ_ACCT_ID	Local
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
		C1T082S1	ACCT_APAY_ID	Global
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_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_PER	Reference Partitioning	C1T086P0	CS_REQ_ACCT_PER_ID	Global Partitioned
		C1T086S1	CS_REQ_ACCT_ID	Global
		C1T086S2	CS_REQ_PER_ID	Global
		C1T086S3	PER_ID	Global
C1_CS_REQ_ACCT_PER_ADDR	Reference Partitioning	C1T088P0	CS_REQ_ACCT_PER_ID	Global Partitioned
C1_CS_REQ_ACCT_NCD	Reference Partitioning	C1T089P0	CS_REQ_ACCT_ID,CS_REQ_SEQ_NUM	Global Partitioned
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

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)				RANGE(CS_REQ_CONT_ID)	C1_CS_REQ_CONT.CRE_DTTM
	Reference Partitioning	C1T055P0	CS_REQ_CONT_ID	Global Partitioned
		C1T055S1	CS_REQ_CONT_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T055S2	CS_REQ_ID	Global
		C1T055S3	CONT_ID	Global
		CM_ILM_C1T055L0	ILM_DT,ILM_ARCH_SW,CS_REQ_CONT_ID	Local
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 Partitioned
C1_CS_REQ_CONT_MS	Reference Partitioning	C1T059P0	CS_REQ_CONT_ID,CS_REQ_SEQ_NUM	Global Partitioned
C1_CS_REQ_CONT_MS_PROD	Reference Partitioning	C1T061P0	CS_REQ_CONT_ID,CS_REQ_SEQ_NUM,SEQ_NUM	Global Partitioned
		C1T061S1	CONT_PROD_ID	Global
C1_CS_REQ_CONT_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

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)				RANGE(CS_REQ_CONT_PROD_ID)	C1_CS_REQ_CONT_PROD.CRE_DTTM
	Reference Partitioning	C1T065P0	CS_REQ_CONT_PROD_ID	Global Partitioned
		C1T065S1	CS_REQ_CONT_PROD_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T065S2	CS_REQ_ID	Global
		C1T065S3	CONT_ID	Global
		C1T065S4	ACCT_ID	Global
		C1T065S5	CS_REQ_ACCT_ID	Global
		C1T065S6	CONT_PROD_ID	Global
		C1T065S7	CS_REQ_CONT_ID	Global
		CM_ILM_C1T065L0	ILM_DT,ILM_ARCH_SW,CS_REQ_CONT_PROD_ID	Local
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_PROD_LOG_PARM	Reference Partitioning	C1T069P0	CS_REQ_CONT_PROD_ID,SEQNO,PARM_SEQ	Global Partitioned
C1_CS_REQ_CONT_PROD_CHAR	Reference Partitioning	C1T067P0	CS_REQ_CONT_PROD_ID,CS_REQ_SEQ_NUM	Global Partitioned
		C1T067S1	SRCH_CHAR_VAL	Global

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
	Reference Partitioning	C1T070P0	CS_REQ_PER_ID	Global Partitioned
		C1T070S1	CS_REQ_PER_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T070S2	CS_REQ_ID	Global
		C1T070S3	PER_ID	Global
		CM_ILM_C1T070L0	ILM_DT,ILM_ARCH_SW,CS_REQ_PER_ID	Local
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	C1T073P0	CS_REQ_PER_ID,CS_REQ_SEQ_NUM	Global Partitioned
C1_CS_REQ_PER_ID	Reference Partitioning	C1T072P0	CS_REQ_PER_ID,CS_REQ_SEQ_NUM	Global Partitioned
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
		C1T071S1	ENTITY_NAME_UPR,CS_REQ_PER_ID,CS_REQ_SEQ_NUM	Global
		C1T071S2	CS_REQ_PER_ID,NAME_TYPE_FLG,ENTITY_NAME	Global
		C1T071S3	ENTITY_NAME_UPR	Global
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)				RANGE(CS_REQ_SVC_LOC_ID)	C1_CS_REQ_SVC_LOC.CRE_DTTM
	Reference Partitioning	C1T049P0	CS_REQ_SVC_LOC_ID	Global Partitioned
		C1T049S1	CS_REQ_SVC_LOC_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T049S2	CS_REQ_ID	Global
		C1T049S3	SP_ID	Global
		C1T049S4	C1_MKT_RP_ID	Global
		C1T049S5	PREM_ID	Global
		C1T049S6	CONT_ID	Global
		C1T049S7	CS_REQ_PREM_ID	Global
		C1T049S8	CS_REQ_CONT_ID	Global
		CM_ILM_C1T049L0	ILM_DT,ILM_ARCH_SW,CS_REQ_SVC_LOC_ID	Local
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 Partitioned
		C1T052S1	CONT_PROD_ID	Global
		C1T052S2	CS_REQ_CONT_PROD_ID	Global
		C1T052S3	CS_REQ_ACCT_ID	Global
		C1T052S4	ACCT_ID	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)				RANGE(CS_REQ_PREM_ID)	C1_CS_REQ_PREM.CRE_DTTM
	Reference Partitioning	C1T092P0	CS_REQ_PREM_ID	Global Partitioned
		C1T092S1	BUS_OBJ_CD,BO_STATUS_CD,CS_REQ_PREM_ID	Global
		C1T092S2	CS_REQ_ID	Global
		C1T092S3	PREM_ID	Global
		C1T092S4	ADDRESS1_UPR,CITY_UPR,POSTAL	Global
		C1T092S5	CITY_UPR,POSTAL	Global
		C1T092S6	POSTAL	Global
		C1T092S7	ADDRESS1_UPR	Global
		C1T092S8	CITY_UPR	Global
		C1T092S9	PRNT_PREM_ID	Global
		C1T092S10	LL_ID	Global
		CM_ILM_C1T092L0	ILM_DT,ILM_ARCH_SW,CS_REQ_PREM_ID	Local
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 Partitioned
C1_CS_REQ_PREM_ALT_ADDR	Reference Partitioning	C1T095P0	CS_REQ_PREM_ID,CS_REQ_SEQ_NUM	Global Partitioned
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)				RANGE(MKTMSG_CHG_ID)	C1_MKTMSG_CHG.MKT_CHG_DT
	Reference Partitioning	C1T135P0	MKTMSG_CHG_ID	Global Partitioned
		C1T135S1	MKTMSG_CHG_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T135S2	MKTMSG_ID	Global
		CM_ILM_C1T135L0	ILM_DT,ILM_ARCH_SW,MKTMSG_CHG_ID	Local
C1_MKTMSG_CHG_DTL	Reference Partitioning	C1T137P0	MKTMSG_CHG_ID,MKT_SEQNO	Global Partitioned
		C1T137S1	BSEG_ID	Global
		C1T137S2	ADJ_ID	Global
		C1T137S3	BILLABLE_CHG_ID	Global
		C1T137S4	UOM_CD	Global
		C1T137S5	MKT_SO_NBR	Global
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
		C1T138S1	MAINT_OBJ_CD,MKT_REL_OBJ_TYPE_FLG,PK_VALUE1	Global
		C1T138S2	PK_VALUE1,MKT_REL_OBJ_TYPE_FLG,MAINT_OBJ_CD	Global

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)				RANGE(MKTMSG_PAY_ID)	C1_MKTMSG_PAY.MKT_PAY_DT
	Reference Partitioning	C1T129P0	MKTMSG_PAY_ID	Global Partitioned
		C1T129S1	MKTMSG_PAY_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T129S2	MKTMSG_ID	Global
		CM_ILM_C1T129L0	ILM_DT,ILM_ARCH_SW,MKTMSG_PAY_ID	Local
C1_MKTMSG_PAY_DTL	Reference Partitioning	C1T131P0	MKTMSG_PAY_ID,MKT_SEQNO	Global Partitioned
		C1T131S1	ACCT_ID	Global
		C1T131S2	BILL_ID	Global
		C1T131S3	MKT_ADJ_ID	Global
C1_MKTMSG_PAY_LOG	Reference Partitioning	C1T133P0	MKTMSG_PAY_ID,MKT_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
		C1T132S1	MAINT_OBJ_CD,MKT_REL_OBJ_TYPE_FLG,PK_VALUE1	Global
		C1T132S2	PK_VALUE1,MKT_REL_OBJ_TYPE_FLG,MAINT_OBJ_CD	Global

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)				RANGE(MKTMSG_USG_ID)	C1_MKTMSG_USG.MKT_USG_DT
	Reference Partitioning	C1T123P0	MKTMSG_USG_ID	Global Partitioned
		C1T123S1	MKTMSG_USG_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T123S2	MKTMSG_ID	Global
		CM_ILM_C1T123L0	ILM_DT,ILM_ARCH_SW,MKTMSG_USG_ID	Local
C1_MKTMSG_USG_DTL	Reference Partitioning	C1T125P0	MKTMSG_USG_ID,MKT_SEQNO	Global Partitioned
C1_MKTMSG_USG_REL_OBJ	Reference Partitioning	C1T126P0	MKTMSG_USG_ID,MKT_REL_OBJ_TYPE_FLG,SEQNO	Global Partitioned
		C1T126S1	MAINT_OBJ_CD,MKT_REL_OBJ_TYPE_FLG,PK_VALUE1	Global
		C1T126S2	PK_VALUE1,MKT_REL_OBJ_TYPE_FLG,MAINT_OBJ_CD	Global
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	MKTMSG_USG_ID,SEQNO,PARM_SEQ	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)				RANGE(CS_REQ_SA_ID)	C1_CS_REQ_SA.CRE_DTTM
	Reference Partitioning	C1T141P0	CS_REQ_SA_ID	Global Partitioned
		C1T141S1	CS_REQ_SA_ID,BUS_OBJ_CD,BO_STATUS_CD	Global
		C1T141S2	CS_REQ_ID	Global
		C1T141S3	SA_ID	Global
		C1T141S4	ACCT_ID	Global
		C1T141S5	CHAR_PREM_ID	Global
		C1T141S6	ENRL_ID	Global
		C1T141S7	CS_REQ_ACCT_ID	Global
		C1T141S8	SA_REL_ID	Global
		CM_ILM_C1T141L0	ILM_DT,ILM_ARCH_SW,CS_REQ_SA_ID	Local
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_SP	Reference Partitioning	C1T144P0	CS_REQ_SA_SP_ID	Global Partitioned
		C1T144S1	CS_REQ_SA_ID	Global
		C1T144S2	SA_ID	Global
		C1T144S3	SP_ID	Global
		C1T144S4	START_MR_ID	Global
		C1T144S5	STOP_MR_ID	Global
C1_CS_REQ_SA_SP_FA	Reference Partitioning	C1T146P0	CS_REQ_SA_SP_ID,CS_REQ_SEQ_NUM	Global Partitioned
		C1T146S1	CS_REQ_SA_SP_ID	Global
		C1T146S2	SA_ID	Global
		C1T146S3	SP_ID	Global
		C1T146S4	FA_ID	Global
C1_CS_REQ_SA_SP_CHAR	Reference Partitioning	C1T147P0	CS_REQ_SA_SP_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_CONT_QTY	Reference Partitioning	C1T149P0	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_CONTERM	Reference Partitioning	C1T151P0	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_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,SEQ_NUM	Global Partitioned
C1_CS_REQ_SA_MSG	Reference Partitioning	C1T155P0	CS_REQ_SA_ID,CS_REQ_SEQ_NUM	Global Partitioned
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

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)				RANGE (SA_ID)	C1_BI_SA_SNAPSHOT.C1_SNAPSHOT_DTTM
	Reference Partitioning	C1M020P0	SA_ID,C1_SNAPSHOT_DT,C1_SNAPSHOT_TYPE_FLG	Global Partitioned
		C1M020S1	SA_ID	Global
		C1M020S2	ACCT_ID	Global
		C1M020S3	PER_ID	Global
		C1M020S4	CURRENCY_CD	Global
		CM_ILM_C1M020L0	ILM_DT,ILM_ARCH_SW,SA_ID	Local

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)				RANGE(NTF_PREF_ID)	C1_NTF_PREF.STATUS_UPD_DTTM
	Reference Partitioning	C1T002P0	NTF_PREF_ID	Global Partitioned
		C1T002S1	ACCT_ID	Global
		C1T002S2	NTF_PREF_ID,BO_STATUS_CD,STATUS_UPD_DTTM	Global
		C1T002S3	C1_CONTACT_ID	Global
		C1T002S4	F1_SVC_TASK_ID	Global
		CM_ILM_C1T002L0	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_ID	Reference Partitioning	C1T006P0	NTF_PREF_ID,NTF_PREF_ID_TYPE_FLG	Global Partitioned
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

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)				RANGE(MKTMSG_ID)	F1_MKTMSG_IN.CRE_DTTM
	Reference Partitioning	F1T759P0	MKTMSG_ID	Global Partitioned
		F1T759S1	BO_STATUS_CD,BUS_OBJ_CD,MKTMSG_ID	Global
		F1T759S2	CRE_DTTM,F1_MKTMSG_TYPE_CD,MKT_PARTCPT	Global
		F1T759S3	MKT_REG_NBR	Global
		CM_ILM_F1T759L0	ILM_DT,ILM_ARCH_SW,MKTMSG_ID	Local
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_CHAR	Reference Partitioning	F1T760P0	MKTMSG_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		F1T760S1	SRCH_CHAR_VAL	Global
F1_MKTMSG_IN_REL_OBJ	Reference Partitioning	F1T767P0	MKTMSG_ID,MKT_REL_OBJ_TYPE_FLG,SEQNO	Global Partitioned
		F1T767S1	MAINT_OBJ_CD,MKT_REL_OBJ_TYPE_FLG,PK_VALUE1	Global
F1_MKTMSG_IN_DATA	Reference Partitioning	F1T761P0	MKTMSG_ID,MKT_DATA_TYPE_FLG	Global Partitioned
F1_MKTMSG_IN_ID	Reference Partitioning	F1T763P0	MKTMSG_ID,MKT_ID_TYPE_FLG	Global Partitioned
		F1T763S1	MKT_ID_TYPE_FLG,MKT_ID_VALUE	Global
F1_MKTMSG_IN_LOG_PARM	Reference Partitioning	F1T766P0	MKTMSG_ID,SEQNO,PARM_SEQ	Global Partitioned
F1_MKTMSG_IN_EXT_REF	Reference Partitioning	F1T762P0	MKTMSG_ID,MKT_REF_TYPE_FLG,SEQNO	Global Partitioned
		F1T762S1	MKT_REF_TYPE_FLG,EXT_REF_VAL	Global

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)				RANGE(MKTMSG_ID)	F1_MKTMSG_OUT.CRE_DTTM
	Reference Partitioning	F1T782P0	MKTMSG_ID	Global Partitioned
		F1T782S1	BO_STATUS_CD,BUS_OBJ_CD,MKTMSG_ID	Global
		F1T782S2	MKT_PARTCPT,F1_MKTMSG_TYPE_CD,CRE_DTTM	Global
		F1T782S3	OUTMSG_ID	Global
		F1T782S4	MKTPROC_ID	Global
		F1T782S5	MKT_REG_NBR	Global
		CM_ILM_F1T782L0	ILM_DT,ILM_ARCH_SW,MKTMSG_ID	Local
F1_MKTMSG_OUT_LOG_PARM	Reference Partitioning	F1T789P0	MKTMSG_ID,SEQNO,PARM_SEQ	Global 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_REL_OBJ	Reference Partitioning	F1T790P0	MKTMSG_ID,MKT_REL_OBJ_TYPE_FLG,SEQNO	Global Partitioned
		F1T790S1	MAINT_OBJ_CD,MKT_REL_OBJ_TYPE_FLG,PK_VALUE1	Global
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_EXT_REF	Reference Partitioning	F1T785P0	MKTMSG_ID,MKT_REF_TYPE_FLG,SEQNO	Global Partitioned
		F1T785S1	MKT_REF_TYPE_FLG,EXT_REF_VAL	Global
F1_MKTMSG_OUT_DATA	Reference Partitioning	F1T784P0	MKTMSG_ID,MKT_DATA_TYPE_FLG	Global Partitioned
F1_MKTMSG_OUT_ID	Reference Partitioning	F1T786P0	MKTMSG_ID,MKT_ID_TYPE_FLG	Global Partitioned
		F1T786S1	MKT_ID_TYPE_FLG,MKT_ID_VALUE	Global

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_DT,MKTPROC_ID)				RANGE(MKTPROC_ID)	F1_MKTPROC.CRE_DTTM
	Reference Partitioning	F1T768P0	MKTPROC_ID	Global Partitioned
		F1T768S1	BO_STATUS_CD,BUS_OBJ_CD,MKTPROC_ID	Global
		F1T768S2	MKTPROC_TYPE_CD,CRE_DTTM	Global
		CM_ILM_F1T768L0	ILM_DT,ILM_ARCH_SW,MKTPROC_ID	Local
F1_MKTPROC_LOG	Reference Partitioning	F1T772P0	MKTPROC_ID,SEQNO	Global Partitioned
		F1T772S1	CHAR_TYPE_CD,CHAR_VAL_FK1	Global
		F1T772S2	CHAR_TYPE_CD,CHAR_VAL	Global
F1_MKTPROC_ID	Reference Partitioning	F1T770P0	MKTPROC_ID,MKT_ID_TYPE_FLG	Global Partitioned
		F1T770S1	MKT_ID_TYPE_FLG,MKT_ID_VALUE	Global
F1_MKTPROC_CHAR	Reference Partitioning	F1T769P0	MKTPROC_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		F1T769S1	SRCH_CHAR_VAL	Global
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)				RANGE(MKTPROC_EVT_ID)	F1_MKTPROC_EVT.CRE_DTTM
	Reference Partitioning	F1T776P0	MKTPROC_EVT_ID	Global Partitioned
		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
F1_MKTPROC_EVT_REL_OBJ	Reference Partitioning	F1T781P0	MKTPROC_EVT_ID,MKT_REL_OBJ_TYPE_FLG,SEQNO	Global Partitioned
		F1T781S1	MAINT_OBJ_CD,PK_VALUE1,PK_VALUE2,PK_VALUE3,PK_VALUE4,PK_VALUE5	Global
		F1T781S2	MAINT_OBJ_CD,MKT_REL_OBJ_TYPE_FLG,PK_VALUE1	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_CHAR	Reference Partitioning	F1T777P0	MKTPROC_EVT_ID,CHAR_TYPE_CD,SEQ_NUM	Global Partitioned
		F1T777S1	SRCH_CHAR_VAL	Global