INT_CI_RECOVERY

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RECOVERY_OWNER_ID BIGINT 8
2 RECOVERY_OWNER_GROUP BIGINT 8
3 RECOVERY_MANAGEMENT_STATUS_ID BIGINT 8
4 RECOVERY_LIABILITY_PERCENTAGE NUMERIC(4,1) 19
5 RECOVERY_PARTY_RECOVERY_STATUS_ID BIGINT 8
6 RECOVERY_PARTY_NAME_ID BIGINT 8
7 RECOVERY_PARTY_PRIMARY_PHONE CHARACTER VARYING(255) 255
8 RESPONSIBLE_PARTY_ADDRESS CHARACTER VARYING(434) 434
9 RECOVERY_PARTY_ADDRESS CHARACTER VARYING(434) 434
10 RECOVERY_PARTY_EXPOSURE_ID BIGINT 8
11 RECOVERY_PARTY_RECOVERY_TYPE_ID BIGINT 8
12 RECOVERY_PARTY_EXPECTED_RECOVERY_PERCENTAGE NUMERIC(4,1) 19
13 RECOVERY_PARTY_SCHEDULED_PAYMENTS_FLAG INTEGER 4
14 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE TIMESTAMP 8
15 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_SENT_DATE_ID INTEGER 4
16 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE TIMESTAMP 8
17 RECOVERY_PARTY_SCHEDULED_PAYMENTS_NOTE_RECEIVED_DATE_ID INTEGER 4
18 RECOVERY_PARTY_SCHEDULED_PAYMENTS_TYPE_ID BIGINT 8
19 RECOVERY_PARTY_INSURANCE_STATUS_ID BIGINT 8
20 PAYMENTREFNUMBER CHARACTER VARYING(19) 19
21 RECOVERY_PARTY_RECOVERY_AMOUNT NUMERIC(18,2) 19
22 RECOVERY_PARTY_RECOVERD_TRANSACTION_AMOUNT NUMERIC(38,2) 19
23 RECOVERY_COUNT BIGINT 8
24 RECOVERYSTATUS_NAME CHARACTER VARYING(256) 256
25 RECOVERY_PARTY_CREATE_DATE DATE 4
26 RECOVERY_PARTY_CREATE_DATE_ID INTEGER 4
27 RECOVERY_PARTY_UPDATE_DATE DATE 4
28 RECOVERY_PARTY_UPDATE_DATE_ID INTEGER 4
29 RECOVERY_PARTY_FINALISED_DATE DATE 4
30 RECOVERY_PARTY_FINALISED_DATE_ID INTEGER 4
31 RECOVERY_PARTY_CREATE_USER_ID BIGINT 8
32 RECOVERY_PARTY_UPDATE_USER_ID BIGINT 8
33 RECOVERY_CLOSE_DATE TIMESTAMP 8
34 RECOVERY_CLOSE_DATE_ID INTEGER 4
35 RECOVERY_CLOSE_COMMENT CHARACTER VARYING(255) 255
36 RECOVERY_DURATION INTEGER 4
37 RECOVERY_PARTY_INSURER_ID BIGINT 8
38 CLAIM_ID BIGINT 8
39 RECOVERY_PARTY_INITIAL_RECOVERY_AMOUNT NUMERIC(38,2) 19
40 RECOVERY_PARTY_RECOVERY_FILE_STATUS CHARACTER VARYING(5) 5