| 1 |
ACCOUNT_NUMBER |
CHARACTER VARYING(40) |
40 |
| 2 |
SOURCE_SYSTEM_CODE |
CHARACTER VARYING(5) |
5 |
| 3 |
COLLECTION_ACCOUNT_ID |
CHARACTER VARYING(10) |
10 |
| 4 |
COLLECTION_CASE_ID |
CHARACTER VARYING(10) |
10 |
| 5 |
PERSON_ID |
CHARACTER VARYING(10) |
10 |
| 6 |
COLLECTION_CASE_TYPE |
CHARACTER VARYING(12) |
12 |
| 7 |
COLLECTION_CASE_TYPE_DESCRIPTION |
CHARACTER VARYING(60) |
60 |
| 8 |
COLLECTION_CASE_STATUS |
CHARACTER VARYING(12) |
12 |
| 9 |
COLLECTION_CASE_STATUS_DESCRIPTION |
CHARACTER VARYING(60) |
60 |
| 10 |
COLLECTION_CASE_CREATION_TIMESTAMP |
CHARACTER VARYING(200) |
200 |
| 11 |
COLLECTION_CASE_APPROVER_ID |
CHARACTER VARYING(255) |
255 |
| 12 |
COLLECTION_CASE_APPROVER |
CHARACTER VARYING(201) |
201 |
| 13 |
COLLECTION_CASE_APPROVE_TIMESTAMP |
CHARACTER VARYING(200) |
200 |
| 14 |
COLLECTION_CASE_CREATED_BY |
CHARACTER VARYING(255) |
255 |
| 15 |
COLLECTION_CASE_CREATED_TIMESTAMP |
CHARACTER VARYING(200) |
200 |
| 16 |
NEXT_COLLECTION_ACTION_TYPE_CODE |
CHARACTER VARYING(12) |
12 |
| 17 |
NEXT_COLLECTION_ACTION_TIMESTAMP |
CHARACTER VARYING(200) |
200 |
| 18 |
COLLECTION_HOLD_REASON_CODE |
CHARACTER VARYING(4) |
4 |
| 19 |
COLLECTION_HOLD_TILL_DATE |
CHARACTER VARYING(200) |
200 |
| 20 |
COLLECTION_HOLD_BY_CASE |
CHARACTER VARYING(10) |
10 |
| 21 |
LMI_INSURED_SW |
CHARACTER VARYING(1) |
1 |
| 22 |
IS_DELETED |
CHARACTER VARYING(16) |
16 |
| 23 |
COLLECTION_CUSTOMER_NUMBER |
CHARACTER VARYING(40) |
40 |
| 24 |
CONTACT_PERSON_ID |
CHARACTER VARYING(10) |
10 |
| 25 |
COLLECTION_CONTACT_METHOD_FLAG |
CHARACTER VARYING(4) |
4 |
| 26 |
COLLECTION_CASE_COND_FLAG |
CHARACTER VARYING(4) |
4 |
| 27 |
COLLECTION_CONTACT_INSTRUCTIONS |
CHARACTER VARYING(2000) |
2000 |
| 28 |
COLLECTION_PHONE_TYPE_CODE |
CHARACTER VARYING(12) |
12 |
| 29 |
COLLECTION_PHONE |
CHARACTER VARYING(24) |
24 |
| 30 |
COLLECTION_EXTENSION |
CHARACTER VARYING(6) |
6 |
| 31 |
COLLECTIONS_PARTY_UID |
CHARACTER VARYING(10) |
10 |
| 32 |
COLLECTION_PARTY_TYPE |
CHARACTER VARYING(4) |
4 |
| 33 |
COLLECTIONS_PARTY_ID |
CHARACTER VARYING(10) |
10 |
| 34 |
COLLECTIONS_CASE_CATEGORY |
CHARACTER VARYING(4) |
4 |
| 35 |
COLLECTIONS_REALLOCATE_YN |
CHARACTER VARYING(1) |
1 |
| 36 |
COLLECTIONS_CREATE_MODE |
CHARACTER VARYING(1) |
1 |
| 37 |
IS_CURRENT |
CHARACTER VARYING(1) |
1 |
| 38 |
EFFECTIVE_END_TIMESTAMP |
CHARACTER VARYING(200) |
200 |
| 39 |
EFFECTIVE_START_TIMESTAMP |
CHARACTER VARYING(200) |
200 |
| 40 |
BUSINESS_END_OF_DAY_DATE |
CHARACTER VARYING(200) |
200 |
| 41 |
IS_CURRENT_FOR_END_OF_DAY |
CHARACTER VARYING(1) |
1 |