FCT_BNK_HINDSIGHT_CREDIT_DECISION_HISTORY_LOAN_DATA_INFLIGHT_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP extract used by Hindsight system for loan credit decisions on apps still in progress

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 FACILITY_ID CHARACTER VARYING(40) 40
3 CREDIT_DECISION_ID CHARACTER VARYING(50) 50
4 DECISION_STAGE_TYPE CHARACTER VARYING(50) 50
5 DECISION_DATE DATE 4
6 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
7 APPROVING_OFFICER_ID CHARACTER VARYING(40) 40
8 APPLICATION_ID CHARACTER VARYING(50) 50