FCT_BNK_COLLECTION_HIGH_RISK_FACILITY
Description
Target Objects (CTAS)
INSNZP05_BANK..FCT_BNK_COLLECTION_HIGH_RISK_FACILITY_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PROCESS_DATE | DATE | 4 |
| 2 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 3 | COLLECTION_ACCOUNT_NUMBER | CHARACTER(10) | 10 |
| 4 | LAST_COLLECTIONS_ACTIVITY | TIMESTAMP | 8 |
| 5 | COLLECTION_CASE_ID | CHARACTER(10) | 10 |
| 6 | FROM_DATE | TIMESTAMP | 8 |
| 7 | TILL_DATE | TIMESTAMP | 8 |
| 8 | ARREARS | NUMERIC(38,16) | 19 |
| 9 | ACCOUNT_BALANCE | NUMERIC(38,16) | 19 |
| 10 | DPD | SMALLINT | 2 |
| 11 | PRODUCT_GROUP | CHARACTER VARYING(20) | 20 |
| 12 | COLLECTIONS_CASE_TYPE | CHARACTER(12) | 12 |
| 13 | COLLECTIONS_STATUS | CHARACTER VARYING(60) | 60 |
| 14 | COLLECTION_CASE_TYPE_DESCRIPTION | CHARACTER VARYING(60) | 60 |
| 15 | PRIMARY_ACCOUNT_NAME | CHARACTER VARYING(250) | 250 |
| 16 | QUEUE_TEAM_USER | CHARACTER VARYING(164) | 164 |