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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |