FCT_BNK_COLLECTION_CMRT_REPORT2_INSIGHT
Description
Summary of Accounts in collections with counts of contact attempts by phone email mail SMS etc
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | COUNTRY | CHARACTER VARYING(2) | 2 |
| 2 | ROUND_TABLE | CHARACTER VARYING(11) | 11 |
| 3 | MEMBER | CHARACTER VARYING(7) | 7 |
| 4 | PRODUCT | CHARACTER VARYING(60) | 60 |
| 5 | MONTHSTARTDATE | DATE | 4 |
| 6 | SEGMENTS | CHARACTER VARYING(10) | 10 |
| 7 | ACCOUNTS_MONTHEND | NUMERIC(38,0) | 19 |
| 8 | ACCOUNTS_ELIGIBLE_FOR_COLLECTIONS | NUMERIC(38,0) | 19 |
| 9 | ACCOUNTS_RECEIVING_COLLECTIONS_ACTION | NUMERIC(38,0) | 19 |
| 10 | SMS_SENT | NUMERIC(38,0) | 19 |
| 11 | OIVR_ATTEMPTS | NUMERIC(38,0) | 19 |
| 12 | INTERNAL_VOICE_DIAL_ATTEMPTS | NUMERIC(38,0) | 19 |
| 13 | OVERFLOW_DIAL_ATTEMPTS | NUMERIC(38,0) | 19 |
| 14 | LETTERS_SENT | NUMERIC(38,0) | 19 |
| 15 | TOTAL_CURES | NUMERIC(38,0) | 19 |
| 16 | TOTAL_ROLLED_BACK | NUMERIC(38,0) | 19 |
| 17 | EMAILS_SENT | NUMERIC(38,0) | 19 |
| 18 | INBOUND_CALLS | NUMERIC(38,0) | 19 |