SLN_FACILITY_FUNDING

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SLN_FACILITY_FUNDING_HIID BIGINT 8
2 ACTION_CODE CHARACTER(1) 1
3 FACILITY_ID CHARACTER VARYING(20) 20
4 PURPOSE_CODE CHARACTER VARYING(60) 60
5 COST NUMERIC(13,2) 19
6 BORR_CONTRIBUTION_AMOUNT NUMERIC(13,2) 19
7 FUNDING_AMOUNT NUMERIC(13,2) 19
8 INFORMATION CHARACTER VARYING(60) 60
9 TRADE_IN_FL CHARACTER(1) 1
10 DELTA_TYPE CHARACTER VARYING(1) 1
11 EFFECTIVE_STRT_DT TIMESTAMP 8
12 EFFECTIVE_END_DT TIMESTAMP 8
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8