FCT_BNK_QRM_FACILITY_BSC_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP extract with select Experian Scorecard details consumed by QRM

Columns
# Name Data Type Length
1 ACTION_CODE CHARACTER VARYING(1) 1
2 APPLICATION_ID CHARACTER VARYING(60) 60
3 FACILITY_ID CHARACTER VARYING(50) 50
4 ACCOUNT_ID CHARACTER VARYING(40) 40
5 DATE_SCORED TIMESTAMP 8
6 SCORECARD_ID INTEGER 4
7 APPLICATION_SCORE INTEGER 4
8 FINE_APP_RISK_GRADE SMALLINT 2
9 CRGS_SCORECARD_ID INTEGER 4
10 CRGS_SCORE INTEGER 4
11 FINE_CRGS_GRADE SMALLINT 2
12 BSN_LOAD_DT DATE 4