Pay Plan
Module: Customer Analytics
Type: Fact
PP_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PP_ID | VARCHAR2 | 30 | True | Pay Plan | |||
| SOURCE_RECORD_ID | VARCHAR2 | 30 | Source Record Id | ||||
| A1_DAYS_FROM_START | NUMBER | 15 | 0 | Days from Start | |||
| A1_DAYS_TO_GO | NUMBER | 15 | 0 | Days to Go | |||
| A1_NBR_FUTURE_SCHED_PAYMENTS | NUMBER | 15 | 0 | Future Scheduled Payments | |||
| A1_NBR_TOT_SCHED_PAYMENTS | NUMBER | 15 | 0 | Total Scheduled Payments | |||
| A1_PAID_TO_DATE_AMT | NUMBER | 15 | 2 | Paid to Date Amount | |||
| A1_PP_END_DT | NUMBER | 38 | 0 | Pay Plan End Date | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET01 | NUMBER | 15 | 2 | Future Payment Amount Bucket 01 | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET02 | NUMBER | 15 | 2 | Future Payment Amount Bucket 02 | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET03 | NUMBER | 15 | 2 | Future Payment Amount Bucket 03 | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET04 | NUMBER | 15 | 2 | Future Payment Amount Bucket 04 | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET05 | NUMBER | 15 | 2 | Future Payment Amount Bucket 05 | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET06 | NUMBER | 15 | 2 | Future Payment Amount Bucket 06 | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET07 | NUMBER | 15 | 2 | Future Payment Amount Bucket 07 | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET08 | NUMBER | 15 | 2 | Future Payment Amount Bucket 08 | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET09 | NUMBER | 15 | 2 | Future Payment Amount Bucket 09 | |||
| A1_PP_FUTURE_PAY_AMT_BUCKET10 | NUMBER | 15 | 2 | Future Payment Amount Bucket 10 | |||
| A1_PP_START_DT | NUMBER | 38 | 0 | Pay Plan Start Date | |||
| A1_TOTAL_FUTURE_PAY_AMT | NUMBER | 15 | 2 | Future Scheduled Payment Amount | |||
| A1_TOT_SCHED_PAY_AMT | NUMBER | 15 | 2 | Total Scheduled Payment Amount | |||
| ACCT_ID | VARCHAR2 | 10 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| CURRENCY_CD | VARCHAR2 | 3 | Currency Code | ||||
| MAILING_PREM_ID | VARCHAR2 | 10 | Mailing Premise | DW_EWB_X_EWDI_BASE_CI_PREM_D | PREM_ID | ||
| PAYOR_ACCT_ID | VARCHAR2 | 10 | Payor Account | ||||
| PAY_METH_CD | VARCHAR2 | 12 | Pay Method | DW_EWC_X_EWDI_CUST_CI_PAY_METH_D | PAY_METH_CD | ||
| PER_ID | VARCHAR2 | 10 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| PP_CNT | NUMBER | 1 | 0 | Count | |||
| PP_STAT_FLG | VARCHAR2 | 2 | Pay Plan Status | ||||
| PP_TYPE_CD | VARCHAR2 | 12 | Pay Plan Type | DW_EWC_X_EWDI_CUST_CI_PP_TYPE_D | PP_TYPE_CD | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |