OBP24_HST_FLX_LN_HARDSHIP_RELIEF_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REQUEST_ID CHARACTER VARYING(40) 40
2 APPLICATION_ID CHARACTER VARYING(40) 40
3 ACCOUNT_ID CHARACTER VARYING(40) 40
4 HARDSHIP_RELIEF_TYPE CHARACTER VARYING(40) 40
5 RELIEF_EFFECTIVE_DATE TIMESTAMP 8
6 RELIEF_EXPIRY_DATE TIMESTAMP 8
7 RELIEF_STATUS CHARACTER VARYING(40) 40
8 REASON_FOR_REJECTION CHARACTER VARYING(40) 40
9 WAIVE_REPAYMENT_COUNTER CHARACTER VARYING(40) 40
10 CREATED_BY CHARACTER VARYING(254) 254
11 CREATION_DATE TIMESTAMP 8
12 LAST_UPDATED_BY CHARACTER VARYING(254) 254
13 LAST_UPDATED_DATE TIMESTAMP 8
14 OBJECT_VERSION_NUMBER INTEGER 4
15 OBJECT_STATUS CHARACTER VARYING(1) 1
16 LAST_RELIEF_APPLIED_DATE TIMESTAMP 8
17 CALCULATED_BENEFIT_STR CHARACTER VARYING(1500) 1500
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8