Pay Plan Snapshot
Module: Customer Analytics
Type: Snapshot Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| A1_PERIOD_ID | VARCHAR2 | 6 | Snapshot Period | ||||
| PP_ID | VARCHAR2 | 30 | Pay Plan | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 37 | 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 | ||||
| ACCT_SK | VARCHAR2 | 39 | Account | ||||
| CURRENCY_CD | VARCHAR2 | 3 | Currency Code | ||||
| MAILING_PREM_ID | VARCHAR2 | 10 | Mailing Premise | ||||
| MAILING_PREM_SK | VARCHAR2 | 39 | Mailing Premise | ||||
| PAYOR_ACCT_ID | VARCHAR2 | 10 | Payor Account | ||||
| PAY_METH_CD | VARCHAR2 | 12 | Pay Method | ||||
| PER_ID | VARCHAR2 | 10 | Person | ||||
| PER_SK | VARCHAR2 | 39 | Person | ||||
| PP_CNT | NUMBER | 1 | 0 | Count | |||
| PP_STAT_FLG | VARCHAR2 | 2 | Pay Plan Status | ||||
| PP_TYPE_CD | VARCHAR2 | 12 | Pay Plan Type | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |