SA Arrears Snapshot
Module: Customer Analytics
Type: Snapshot Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| C1_SNAPSHOT_DT | NUMBER | 38 | 0 | Snapshot Date | |||
| C1_SNAPSHOT_TYPE_FLG | VARCHAR2 | 4 | Snapshot Type | ||||
| SA_ID | VARCHAR2 | 10 | Service Agreement | DW_EWB_X_EWDI_BASE_CI_SA_D | SA_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 54 | Source Record Id | ||||
| A1_ARS_AMT01 | NUMBER | 15 | 2 | Arrears Amount 01 | |||
| A1_ARS_AMT02 | NUMBER | 15 | 2 | Arrears Amount 02 | |||
| A1_ARS_AMT03 | NUMBER | 15 | 2 | Arrears Amount 03 | |||
| A1_ARS_AMT04 | NUMBER | 15 | 2 | Arrears Amount 04 | |||
| A1_ARS_AMT05 | NUMBER | 15 | 2 | Arrears Amount 05 | |||
| A1_ARS_AMT06 | NUMBER | 15 | 2 | Arrears Amount 06 | |||
| A1_ARS_AMT07 | NUMBER | 15 | 2 | Arrears Amount 07 | |||
| A1_ARS_AMT08 | NUMBER | 15 | 2 | Arrears Amount 08 | |||
| A1_ARS_AMT09 | NUMBER | 15 | 2 | Arrears Amount 09 | |||
| A1_ARS_AMT10 | NUMBER | 15 | 2 | Arrears Amount 10 | |||
| ACCT_ID | VARCHAR2 | 10 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| CURRENCY_CD | VARCHAR2 | 3 | Currency Code | DW_EWC_X_EWDI_CUST_CI_CURRENCY_CD_D | F1_BI_CURRENCY_CD | ||
| CUR_BAL | NUMBER | 15 | 2 | Current Balance | |||
| ILM_ARCH_SW | VARCHAR2 | 38 | ILM Archive Switch | ||||
| NEW_CHG_BAL | NUMBER | 15 | 2 | New Charge Balance | |||
| PER_ID | VARCHAR2 | 10 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| SA_SNAPSHOT_CNT | NUMBER | 9 | 0 | Service Agreements | |||
| TOT_BAL | NUMBER | 15 | 2 | Payoff Balance | |||
| VERSION | NUMBER | 5 | 0 | Version | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |