FCT_BNK_COLLECTION_CMRT_REPORT1_INSIGHT
Description
Summary of Accounts in collections with Hardship and FOS indicators and promises to pay history and work effort
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_SCHEDULED | NUMERIC(38,0) | 19 |
| 9 | ACCOUNTS_WORKED | NUMERIC(38,0) | 19 |
| 10 | HARDSHIPS | NUMERIC(38,0) | 19 |
| 11 | ACCOUNTS_WITH_FOS | NUMERIC(38,0) | 19 |
| 12 | FOS_FEES | NUMERIC(38,0) | 19 |
| 13 | CMRT_SKIPSN | NUMERIC(38,0) | 19 |
| 14 | CMRT_SKIP_TRACES | NUMERIC(38,0) | 19 |
| 15 | COLLECTORS_FTE | NUMERIC(38,0) | 19 |
| 16 | DIALS_TOTAL | NUMERIC(38,0) | 19 |
| 17 | DIALS_CONNECTED | NUMERIC(38,0) | 19 |
| 18 | RIGHT_PARTY_CONNECT | NUMERIC(38,0) | 19 |
| 19 | PROMISETOPAY_SINGLE | NUMERIC(38,0) | 19 |
| 20 | PROMISETOPAY_MULTI | NUMERIC(38,0) | 19 |
| 21 | KEPTPROMISESDUE_SINGLE | NUMERIC(38,0) | 19 |
| 22 | KEPTPROMISESDUE_MULTI | NUMERIC(38,0) | 19 |
| 23 | BROKENPROMISESDUE_SINGLE | NUMERIC(38,0) | 19 |
| 24 | BROKENPROMISESDUE_MULTI | NUMERIC(38,0) | 19 |
| 25 | KEPTPROMISESTAKEN_SINGLE | NUMERIC(38,0) | 19 |
| 26 | KEPTPROMISESTAKEN_MULTI | NUMERIC(38,0) | 19 |
| 27 | BROKENPROMISESTAKEN_SINGLE | NUMERIC(38,0) | 19 |
| 28 | BROKENPROMISESTAKEN_MULTI | NUMERIC(38,0) | 19 |
| 29 | AGENT_HOURS_ON_THE_DIALLER | NUMERIC(38,0) | 19 |
| 30 | RPC_ON_THE_DIALLER | NUMERIC(38,0) | 19 |