FCT_BNK_LN_LODGEMENT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_LN_LODGEMENT_V

Columns
# Name Data Type Length
1 TYPE CHARACTER VARYING(10) 10
2 WEEK_END_DATE DATE 4
3 MONTH_END_DATE DATE 4
4 FACILITY_CREATION_DATE TIMESTAMP 8
5 REGION CHARACTER VARYING(240) 240
6 BRANCH_NAME CHARACTER VARYING(105) 105
7 COST_CENTRE_CODE CHARACTER VARYING(150) 150
8 COST_CENTRE_NAME CHARACTER VARYING(240) 240
9 SUBMISSION_ID CHARACTER VARYING(50) 50
10 FACILITY_CODE CHARACTER VARYING(40) 40
11 BROKER_FLAG CHARACTER VARYING(14) 14
12 PRODUCT_GROUP_CODE CHARACTER VARYING(50) 50
13 PROD_GROUP_DESC CHARACTER VARYING(120) 120
14 SOURCE_PRODUCT_CODE CHARACTER VARYING(105) 105
15 PRODUCT_CODE CHARACTER VARYING(50) 50
16 NBR_FACILITIES INTEGER 4
17 FACILITY_REPORTING_AMOUNT NUMERIC(35,2) 19
18 SCHED_FEE_AMT NUMERIC(35,2) 19
19 ACTUAL_FEE_AMT NUMERIC(35,2) 19
20 CRATE NUMERIC(35,2) 19
21 ACTUAL_INTEREST_RATE NUMERIC(35,2) 19
22 PACKAGE_COUNT CHARACTER VARYING(8) 8
23 LVR NUMERIC(35,2) 19
24 LVR_GROUP CHARACTER VARYING(9) 9
25 VALUE_TIER CHARACTER VARYING(10) 10
26 USAGE CHARACTER VARYING(10) 10
27 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
28 INTEREST_ONLY_LOAN_TERM CHARACTER VARYING(1) 1
29 LOW_DOC_LOAN_FLAG CHARACTER VARYING(1) 1
30 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
31 PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
32 ACCREDITED_BROKER_CODE CHARACTER VARYING(20) 20
33 ACCREDITED_BROKER_SEGMENT CHARACTER VARYING(50) 50
34 STAFF_FLAG CHARACTER VARYING(1) 1
35 SALES_OFFICER_ID CHARACTER VARYING(120) 120
36 SUBMISSION_CREATED_BY CHARACTER VARYING(254) 254
37 SUBMISSION_CREATION_DATE TIMESTAMP 8
38 SUBMISSION_STATUS CHARACTER VARYING(50) 50
39 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
40 APPLICATION_CREATION_DATE TIMESTAMP 8
41 APPLICANT_ID CHARACTER VARYING(50) 50
42 FIRST_DISBURSEMENT_DATE DATE 4