SLN_FACILITY_BSC

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..AS516_SLN_FACILITY_BSC

SDSNZP02_BANK..UBAR_SLN_FACILITY_BSC

Columns
# Name Data Type Length
1 SLN_FACILITY_BSC_HIID BIGINT 8
2 ACTION_CODE CHARACTER(1) 1
3 APPLN_ID CHARACTER VARYING(20) 20
4 FACILITY_ID CHARACTER VARYING(20) 20
5 LOAN_ACCT CHARACTER VARYING(20) 20
6 DATE_SCORED TIMESTAMP 8
7 SCORECARD_ID NUMERIC(8,0) 19
8 APPLICATION_SCORE NUMERIC(5,0) 19
9 FINE_APP_RISK_GRADE NUMERIC(6,2) 19
10 CRGS_SCORECARD_ID NUMERIC(8,0) 19
11 CRGS_SCORE NUMERIC(5,0) 19
12 FINE_CRGS_GRADE NUMERIC(7,3) 19
13 DELTA_TYPE CHARACTER VARYING(1) 1
14 EFFECTIVE_STRT_DT TIMESTAMP 8
15 EFFECTIVE_END_DT TIMESTAMP 8
16 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
17 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
18 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
19 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8