FCT_OBP_LOAN_ORIGINATION_SENSITIVE_DETAILS

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BUSINESS_DATE DATE 4
2 SUBMISSION_ID CHARACTER VARYING(50) 50
3 SUBMISSION_DATE TIMESTAMP 8
4 SUBMISSION_STATUS CHARACTER VARYING(50) 50
5 WITHDRAW_DATE TIMESTAMP 8
6 EXPIRED_DATE DATE 4
7 CANCELLED_DATE DATE 4
8 DECLINE_LETTER_DATE DATE 4
9 OFFER_LETTER_GENERATED_DATE TIMESTAMP 8
10 PRE_APPROVAL CHARACTER VARYING(1) 1
11 PRE_APPROVAL_DATE TIMESTAMP 8
12 PRE_APPROVAL_90DAY_DATE DATE 4
13 SUSPENDED_DATE TIMESTAMP 8
14 SUSPENDED_90DAY_DATE DATE 4
15 PRODUCT_TYPE CHARACTER VARYING(120) 120
16 FACILITY_ID CHARACTER VARYING(40) 40