FCT_LENDING_CLOUD_APPLICATIONS_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_LENDING_CLOUD_APPLICATIONS

Synonyms

INSNZP01_BANK..SYN_FCT_LENDING_CLOUD_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 TIMESTAMP 8
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 ESTABLISHMENT_FEE NUMERIC(18,0) 19
23 EXPECTED_SETTLEMENT_DATE DATE 4
24 FACILITY_AMOUNT NUMERIC(10,2) 19
25 FACILITY_NO SMALLINT 2
26 FACILITY_STATUS CHARACTER VARYING(100) 100
27 FACILITY_STATUS_DATE DATE 4
28 GROUP_CODE BIGINT 8
29 GROUP_DESC CHARACTER VARYING(300) 300
30 ID_NUMBER CHARACTER VARYING(58) 58
31 INCREASE_TO_ACCOUNT CHARACTER VARYING(1) 1
32 INDICATIVE_OFFER_DATE DATE 4
33 INTERVIEW_DATE DATE 4
34 LEAD_EST_DATE TIMESTAMP 8
35 LEAD_NO CHARACTER VARYING(50) 50
36 LEAD_STATUS BIGINT 8
37 LEAD_STATUS_DATE DATE 4
38 LEAD_STATUS_DESCRIPTION CHARACTER VARYING(50) 50
39 LEADS_LOAN_PURPOSE_CODE CHARACTER VARYING(250) 250
40 LOAN_APPVL_DATE TIMESTAMP 8
41 LOAN_CATEGORY_CODE CHARACTER VARYING(250) 250
42 LOAN_CATEGORY_DESC CHARACTER VARYING(250) 250
43 LOAN_NO CHARACTER VARYING(50) 50
44 LOAN_PURPOSE CHARACTER VARYING(250) 250
45 LOAN_PURPOSE_CODE CHARACTER VARYING(250) 250
46 LOAN_PURPOSE_DESC CHARACTER VARYING(250) 250
47 MARGIN_RATE NUMERIC(18,6) 19
48 NET_SALES NUMERIC(18,0) 19
49 ORIGINATING_SYSTEM CHARACTER VARYING(4) 4
50 PRODUCT_CODE CHARACTER VARYING(50) 50
51 PRODUCT_DESC CHARACTER VARYING(255) 255
52 PROMOTION_CODE CHARACTER VARYING(250) 250
53 PROMOTION_DESC CHARACTER VARYING(4) 4
54 RATE_TYPE CHARACTER VARYING(50) 50
55 RETAIL_FACILITY_FLAG CHARACTER VARYING(1) 1
56 RUN_DATE DATE 4
57 SETTLEMENT_DATE TIMESTAMP 8
58 SETTLEMENT_OFFICER_NAME CHARACTER VARYING(30) 30
59 SETTLEMENT_STATUS CHARACTER VARYING(1) 1
60 SOURCE_CODE CHARACTER VARYING(250) 250
61 SOURCE_DESC CHARACTER VARYING(250) 250
62 SOURCE_SYSTEM CHARACTER VARYING(3) 3
63 SUBMISSION_DATE DATE 4
64 TERM NUMERIC(18,0) 19
65 TO_CREDIT_DATE DATE 4
66 WCF CHARACTER VARYING(1) 1
67 YIELD_RATE CHARACTER VARYING(4) 4
68 NUMBER_LEADS INTEGER 4
69 FACILITY_REPORTING_AMOUNT NUMERIC(10,2) 19
70 PEOPLESOFT_GL_COST_CENTRE CHARACTER VARYING(10) 10
71 ORACLE_GL_COST_CENTRE_NAME CHARACTER VARYING(240) 240
72 ORACLE_GL_COST_CENTRE CHARACTER VARYING(150) 150
73 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
74 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
75 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
76 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
77 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
78 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240
79 WEM_CHANNEL CHARACTER VARYING(30) 30
80 GL_DEPARTMENT_CHANNEL CHARACTER VARYING(30) 30
81 CLMS_DIVISION_NAME CHARACTER VARYING(256) 256
82 PRODUCT_1_DESC CHARACTER VARYING(100) 100
83 PRODUCT_2_DESC CHARACTER VARYING(100) 100
84 PRODUCT_3_DESC CHARACTER VARYING(100) 100
85 PRODUCT_4_DESC CHARACTER VARYING(100) 100
86 PRODUCT_5_DESC CHARACTER VARYING(100) 100