FCT_WEM_APPLICATIONS

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

INSNZP02_BANK..FCT_WEM_APPLICATIONS_INSIGHT

Columns
# Name Data Type Length
1 ACCEPTANCE_OFFICER_NAME CHARACTER VARYING(100) 100
2 ACCOUNT_LAST_SCORE_DATE DATE 4
3 ACTUAL_ACCOUNT_CQR CHARACTER VARYING(5) 5
4 ACTUAL_ACCOUNT_SR CHARACTER VARYING(5) 5
5 ACTUAL_BORROWER_CQR CHARACTER VARYING(5) 5
6 ACTUAL_BORROWER_SR CHARACTER VARYING(5) 5
7 ACTUAL_GROUP_CDR CHARACTER VARYING(5) 5
8 ANZSIC_CODE CHARACTER VARYING(250) 250
9 ANZSIC_DESC CHARACTER VARYING(250) 250
10 BANK_APPROVAL CHARACTER VARYING(1) 1
11 BANK_DECISION_DATE DATE 4
12 BDM_CODE CHARACTER VARYING(250) 250
13 BDM_NAME CHARACTER VARYING(250) 250
14 BORROWER_NAME CHARACTER VARYING(300) 300
15 BORROWER_NO CHARACTER VARYING(50) 50
16 BORROWER_RISK_MODEL_CODE BIGINT 8
17 BRANCH_NAME CHARACTER VARYING(250) 250
18 BRANCH_NO CHARACTER VARYING(250) 250
19 CLIENT_ACCEPTANCE_DATE DATE 4
20 CLIENT_ADVISED_DATE DATE 4
21 CLIENT_OFFER_DATE DATE 4
22 CURRENT_APPROVAL_STATUS CHARACTER VARYING(1) 1
23 ESTABLISHMENT_FEE NUMERIC(18,0) 19
24 EXPECTED_SETTLEMENT_DATE DATE 4
25 FACILITY_AMOUNT NUMERIC(10,2) 19
26 FACILITY_NO SMALLINT 2
27 FACILITY_STATUS CHARACTER VARYING(100) 100
28 FACILITY_STATUS_DATE DATE 4
29 GROUP_CODE BIGINT 8
30 GROUP_DESC CHARACTER VARYING(300) 300
31 ID_NUMBER CHARACTER VARYING(58) 58
32 INCREASE_TO_ACCOUNT CHARACTER VARYING(1) 1
33 INDICATIVE_OFFER_DATE DATE 4
34 INTERVIEW_DATE DATE 4
35 LEAD_EST_DATE DATE 4
36 LEAD_NO CHARACTER VARYING(50) 50
37 LEAD_STATUS BIGINT 8
38 LEAD_STATUS_DATE DATE 4
39 LEAD_STATUS_DESCRIPTION CHARACTER VARYING(50) 50
40 LEADS_LOAN_PURPOSE_CODE CHARACTER VARYING(250) 250
41 LOAN_APPVL_DATE DATE 4
42 LOAN_CATEGORY_CODE CHARACTER VARYING(250) 250
43 LOAN_CATEGORY_DESC CHARACTER VARYING(250) 250
44 LOAN_NO CHARACTER VARYING(50) 50
45 LOAN_PURPOSE CHARACTER VARYING(250) 250
46 LOAN_PURPOSE_CODE CHARACTER VARYING(250) 250
47 LOAN_PURPOSE_DESC CHARACTER VARYING(250) 250
48 MARGIN_RATE NUMERIC(18,6) 19
49 NET_SALES NUMERIC(18,0) 19
50 ORIGINATING_SYSTEM CHARACTER VARYING(4) 4
51 PRODUCT_CODE CHARACTER VARYING(50) 50
52 PRODUCT_DESC CHARACTER VARYING(255) 255
53 PROMOTION_CODE CHARACTER VARYING(250) 250
54 PROMOTION_DESC CHARACTER VARYING(4) 4
55 RATE_TYPE CHARACTER VARYING(50) 50
56 RETAIL_FACILITY_FLAG CHARACTER VARYING(1) 1
57 RUN_DATE DATE 4
58 SETTLEMENT_DATE DATE 4
59 SETTLEMENT_OFFICER_NAME CHARACTER VARYING(30) 30
60 SETTLEMENT_STATUS CHARACTER VARYING(1) 1
61 SOURCE_CODE CHARACTER VARYING(250) 250
62 SOURCE_DESC CHARACTER VARYING(250) 250
63 SOURCE_SYSTEM CHARACTER VARYING(3) 3
64 SUBMISSION_DATE DATE 4
65 TERM NUMERIC(18,0) 19
66 TO_CREDIT_DATE DATE 4
67 WCF CHARACTER VARYING(1) 1
68 YIELD_RATE CHARACTER VARYING(4) 4
69 NUMBER_LEADS INTEGER 4
70 FACILITY_REPORTING_AMOUNT NUMERIC(10,2) 19
71 ORACLE_GL_COST_CENTRE CHARACTER VARYING(150) 150
72 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
73 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
74 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
75 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
76 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
77 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240