Table | Name | Description |
C1_COLL_PROC_ARS_HIST | Collection Process Arrears History | Used to capture a history of arrears amounts and cancellation thresholds for collection processes. |
C1_COLL_PROC_SA_ARS_HIST | Collection Process SA Arrears History | Used to capture a history of arrears amounts and cancellation thresholds for collection processes. |
C1_OD_PROC_ARS_HIST | Overdue Process Arrears History | Used to capture a history of arrears amounts and cancellation thresholds for overdue processes. |
C1_SEV_PROC_ARS_HIST | Severance Process Arrears History | Used to capture a history of arrears amounts and cancellation thresholds for severance processes. |
Table_Name | Column_Name | Data Type | Data Length |
---|---|---|---|
C1_COLL_PROC_ARS_HIST | ARS_AMT | NUMB | 15,2 |
C1_COLL_PROC_ARS_HIST | ARS_HIST_TYPE_FLG | CHAR | 4 |
C1_COLL_PROC_ARS_HIST | BO_XML_DATA_AREA | XML | 1073741824 |
C1_COLL_PROC_ARS_HIST | BUS_OBJ_CD | CHAR | 30 |
C1_COLL_PROC_ARS_HIST | CAN_THR_AMT | NUMB | 15,2 |
C1_COLL_PROC_ARS_HIST | COLL_PROC_ID | CHAR | 10 |
C1_COLL_PROC_ARS_HIST | CRE_DTTM | DTTM | 26 |
C1_COLL_PROC_ARS_HIST | DEBT_CLASS_SW | CHAR | 1 |
C1_COLL_PROC_ARS_HIST | ILM_ARCH_SW | CHAR | 1 |
C1_COLL_PROC_ARS_HIST | ILM_DT | DATE | 10 |
C1_COLL_PROC_ARS_HIST | SEQNO | NUMB | 5,0 |
C1_COLL_PROC_ARS_HIST | UNADJ_ARS_AMT | NUMB | 15,2 |
C1_COLL_PROC_ARS_HIST | VERSION | NUMB | 5,2 |
C1_COLL_PROC_SA_ARS_HIST | ARS_AMT | NUMB | 15,2 |
C1_COLL_PROC_SA_ARS_HIST | CAN_THR_AMT | NUMB | 15,2 |
C1_COLL_PROC_SA_ARS_HIST | COLL_PROC_ID | CHAR | 10 |
C1_COLL_PROC_SA_ARS_HIST | SA_ID | CHAR | 10 |
C1_COLL_PROC_SA_ARS_HIST | SEQNO | NUMB | 5,0 |
C1_COLL_PROC_SA_ARS_HIST | VERSION | NUMB | 5,0 |
C1_OD_PROC_ARS_HIST | ARS_AMT | NUMB | 15,2 |
C1_OD_PROC_ARS_HIST | ARS_AMT_INDT_SW | CHAR | 1 |
C1_OD_PROC_ARS_HIST | ARS_HIST_TYPE_FLG | CHAR | 4 |
C1_OD_PROC_ARS_HIST | BO_XML_DATA_AREA | XML | 1073741824 |
C1_OD_PROC_ARS_HIST | BUS_OBJ_CD | CHAR | 30 |
C1_OD_PROC_ARS_HIST | CAN_THR_AMT | NUMB | 15,2 |
C1_OD_PROC_ARS_HIST | CRE_DTTM | DTTM | 26 |
C1_OD_PROC_ARS_HIST | ILM_ARCH_SW | CHAR | 1 |
C1_OD_PROC_ARS_HIST | ILM_DT | DATE | 10 |
C1_OD_PROC_ARS_HIST | OD_PROC_ID | CHAR | 12 |
C1_OD_PROC_ARS_HIST | SEQNO | NUMB | 5,0 |
C1_OD_PROC_ARS_HIST | VERSION | NUMB | 5,0 |
C1_RC_CALC_LN_GTT | C1_PERCENTAGE | NUMB | 11,8 |
C1_RC_CALC_LN_GTT | C1_UNIT_PRICE | NUMB | 19,8 |
C1_RC_CALC_LN_GTT | CHARGE | NUMB | 19,8 |
C1_RC_CALC_LN_GTT | SEASON_END_DT | DATE | 10 |
C1_RC_CALC_LN_GTT | SEASON_START_DT | DATE | 10 |
C1_RC_CALC_LN_GTT | STEP_SQ_HIGH_VAL | NUMB | 18,4 |
C1_RC_CALC_LN_GTT | STEP_SQ_LOW_VAL | NUMB | 18,4 |
C1_RC_CALC_LN_GTT | STEP_SQ_SEQ | NUMB | 5,0 |
C1_RC_CALC_LN_GTT | VAL_PERIOD_END_DT | DATE | 10 |
C1_RC_CALC_LN_GTT | VAL_PERIOD_START_DT | DATE | 10 |
C1_SEV_PROC_ARS_HIST | ARS_AMT | NUMB | 15,2 |
C1_SEV_PROC_ARS_HIST | ARS_HIST_TYPE_FLG | CHAR | 4 |
C1_SEV_PROC_ARS_HIST | BO_XML_DATA_AREA | XML | 1073741824 |
C1_SEV_PROC_ARS_HIST | BUS_OBJ_CD | CHAR | 30 |
C1_SEV_PROC_ARS_HIST | CAN_THR_AMT | NUMB | 15,2 |
C1_SEV_PROC_ARS_HIST | CRE_DTTM | DTTM | 26 |
C1_SEV_PROC_ARS_HIST | DEBT_CLASS_SW | CHAR | 1 |
C1_SEV_PROC_ARS_HIST | ILM_ARCH_SW | CHAR | 1 |
C1_SEV_PROC_ARS_HIST | ILM_DT | DATE | 10 |
C1_SEV_PROC_ARS_HIST | SEQNO | NUMB | 5,0 |
C1_SEV_PROC_ARS_HIST | SEV_PROC_ID | CHAR | 10 |
C1_SEV_PROC_ARS_HIST | UNADJ_ARS_AMT | NUMB | 15,2 |
C1_SEV_PROC_ARS_HIST | VERSION | NUMB | 5,0 |
Table_Name | Index_Name |
C1_COLL_PROC_ARS_HIST | C1T164P0 |
C1_COLL_PROC_SA_ARS_HIST | C1T165P0 |
C1_COLL_PROC_SA_ARS_HIST | C1T165S1 |
C1_OD_PROC_ARS_HIST | C1T167P0 |
C1_SEV_PROC_ARS_HIST | C1T166P0 |
CI_CC_LOG | XT281S2 |
C1_OFFCYC_BGEN_BSEG | C1T160S1 |
Table_Name | Column_Name | From | To |
C1_MKTMSG_CHG_DTL | MKT_PRICE_PER_UNIT | NUMB 15,2 | NUMB 19,6 |