| 1 |
PERIOD_DT |
TIMESTAMP |
8 |
| 2 |
ACCOUNT_NUMBER |
CHARACTER VARYING(40) |
40 |
| 3 |
COLLECTION_ACCOUNT_ID |
CHARACTER(10) |
10 |
| 4 |
PRODUCT_GROUP_CODE |
CHARACTER VARYING(20) |
20 |
| 5 |
COLLECTION_CASE_TYPE |
CHARACTER(12) |
12 |
| 6 |
COLLECTION_CASE_TYPE_DESCRIPTION |
CHARACTER VARYING(60) |
60 |
| 7 |
COLLECTION_CASE_STATUS_DESCRIPTION |
CHARACTER VARYING(60) |
60 |
| 8 |
COLLECTION_CASE_STATUS |
CHARACTER(12) |
12 |
| 9 |
COLLECTION_CASE_ID |
CHARACTER(10) |
10 |
| 10 |
DAYS_PAST_DUE |
SMALLINT |
2 |
| 11 |
LAG_DAYS_PAST_DUE |
SMALLINT |
2 |
| 12 |
IS_DELINQUENT |
CHARACTER(1) |
1 |
| 13 |
LAG_IS_DELINQUENT |
CHARACTER(1) |
1 |
| 14 |
OVERDUE_AMOUNT |
NUMERIC(38,16) |
19 |
| 15 |
OUTSTANDING_AMOUNT |
NUMERIC(38,16) |
19 |
| 16 |
DELINQUENCY_END_DATE |
TIMESTAMP |
8 |
| 17 |
ACCOUNT_STATUS_CODE |
CHARACTER VARYING(50) |
50 |
| 18 |
EFFECTIVE_START_TIMESTAMP |
TIMESTAMP |
8 |