WEM_DAILY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_WEM_DAILY

SDSNZP02_BANK..QRMCGN_WEM_DAILY

SDSNZP02_BANK..UBAR_WEM_DAILY

Columns
# Name Data Type Length
1 WEM_DAILY_HIID BIGINT 8
2 RUN_DATE CHARACTER VARYING(12) 12
3 LEAD_NO CHARACTER VARYING(50) 50
4 LEAD_EST_DATE CHARACTER VARYING(12) 12
5 FACILITY_NO SMALLINT 2
6 BORROWER_NO CHARACTER VARYING(50) 50
7 BORROWER_NAME CHARACTER VARYING(300) 300
8 CLIENT_TIER CHARACTER VARYING(50) 50
9 GROUP_CODE BIGINT 8
10 GROUP_DESC CHARACTER VARYING(300) 300
11 SOURCE_CODE CHARACTER VARYING(250) 250
12 SOURCE_DESC CHARACTER VARYING(250) 250
13 THIRD_PARTY_CODE CHARACTER VARYING(4) 4
14 THIRD_PARTY_DESC CHARACTER VARYING(4) 4
15 LEADS_REVIEW_EXPIRY CHARACTER VARYING(1) 1
16 BDM_CODE CHARACTER VARYING(250) 250
17 BDM_NAME CHARACTER VARYING(250) 250
18 BRANCH_NO CHARACTER VARYING(250) 250
19 BRANCH_NAME CHARACTER VARYING(250) 250
20 REGION CHARACTER VARYING(150) 150
21 LEAD_STATUS_DESCRIPTION CHARACTER VARYING(50) 50
22 LEAD_STATUS_DATE CHARACTER VARYING(12) 12
23 FACILITY_STATUS CHARACTER VARYING(100) 100
24 FACILITY_STATUS_DATE CHARACTER VARYING(12) 12
25 QUALIFIED_DATE CHARACTER VARYING(12) 12
26 INTERVIEW_DATE CHARACTER VARYING(12) 12
27 CLIENT_ADVISED_DATE CHARACTER VARYING(12) 12
28 INDICATIVE_OFFER_DATE CHARACTER VARYING(12) 12
29 SUBMISSION_DATE CHARACTER VARYING(12) 12
30 TO_CREDIT_DATE CHARACTER VARYING(12) 12
31 BANK_DECISION_DATE CHARACTER VARYING(12) 12
32 CLIENT_OFFER_DATE CHARACTER VARYING(12) 12
33 CLIENT_ACCEPTANCE_DATE CHARACTER VARYING(12) 12
34 ACCEPTANCE_OFFICER_USERID CHARACTER VARYING(25) 25
35 ACCEPTANCE_OFFICER_NAME CHARACTER VARYING(100) 100
36 SETTLEMENT_OFFICER_USERID BIGINT 8
37 SETTLEMENT_OFFICER_NAME CHARACTER VARYING(30) 30
38 PRODUCT_CODE CHARACTER VARYING(50) 50
39 PRODUCT_DESC CHARACTER VARYING(255) 255
40 LOAN_PURPOSE_DESC CHARACTER VARYING(250) 250
41 FACILITY_AMOUNT CHARACTER VARYING(50) 50
42 PROMISED_APPVL_DATE CHARACTER VARYING(12) 12
43 LOAN_NO CHARACTER VARYING(50) 50
44 LOAN_APPVL_DATE CHARACTER VARYING(12) 12
45 EXPECTED_SETTLEMENT_DATE CHARACTER VARYING(12) 12
46 SETTLEMENT_DATE CHARACTER VARYING(12) 12
47 LOAN_PURPOSE_CODE CHARACTER VARYING(250) 250
48 PROMOTION_CODE CHARACTER VARYING(250) 250
49 PROMOTION_DESC CHARACTER VARYING(4) 4
50 WCF CHARACTER VARYING(1) 1
51 BORROWER_CONTACT_NAME CHARACTER VARYING(300) 300
52 BORROWER_CONTACT_PH CHARACTER VARYING(60) 60
53 ANZSIC_CODE CHARACTER VARYING(250) 250
54 ANZSIC_DESC CHARACTER VARYING(250) 250
55 COMPETITOR_CODE CHARACTER VARYING(250) 250
56 COMPETITOR_DESC CHARACTER VARYING(250) 250
57 LEAD_NPW_CODE BIGINT 8
58 LEAD_NPW_DESC CHARACTER VARYING(250) 250
59 LEAD_FAC_NPW_CODE BIGINT 8
60 LEAD_FAC_NPW_DESC CHARACTER VARYING(250) 250
61 BANK_APPROVAL CHARACTER VARYING(1) 1
62 DECLINE_REAS_CODE CHARACTER VARYING(30) 30
63 DECLINE_REAS_DESC CHARACTER VARYING(50) 50
64 COMMENT_1 CHARACTER VARYING(4) 4
65 COMMENT_2 CHARACTER VARYING(4) 4
66 ESTABLISHMENT_FEE NUMERIC(18,0) 19
67 DEFERRED_FEE SMALLINT 2
68 RATE_TYPE CHARACTER VARYING(50) 50
69 MARGIN_RATE NUMERIC(18,6) 19
70 LVR_COST CHARACTER VARYING(4) 4
71 LVR_COMPLETION CHARACTER VARYING(4) 4
72 INCREASE_TO_ACCOUNT CHARACTER VARYING(1) 1
73 TERM NUMERIC(18,0) 19
74 TC_OVERRIDE SMALLINT 2
75 EFFECTIVE_RATE CHARACTER VARYING(4) 4
76 YIELD_RATE CHARACTER VARYING(4) 4
77 LOAN_CATEGORY_CODE CHARACTER VARYING(250) 250
78 LOAN_CATEGORY_DESC CHARACTER VARYING(250) 250
79 LEADS_LOAN_PURPOSE_CODE CHARACTER VARYING(250) 250
80 LEADS_PACKAGE_CODE CHARACTER VARYING(4) 4
81 LEADS_FACILITY_FEE_RATE CHARACTER VARYING(4) 4
82 LEADS_USER_RATE CHARACTER VARYING(4) 4
83 LEADS_ROLL_FEE CHARACTER VARYING(4) 4
84 SYNDICATE_ARRANGER CHARACTER VARYING(250) 250
85 LOAN_PURPOSE CHARACTER VARYING(250) 250
86 LEAD_STATUS BIGINT 8
87 REVIEW_EXPIRY CHARACTER VARYING(1) 1
88 REGION_CODE BIGINT 8
89 REGION_DESCRIPTION CHARACTER VARYING(150) 150
90 SOURCE_TYPE_CATEGORY_CODE CHARACTER VARYING(50) 50
91 ORIGINATING_SYSTEM CHARACTER VARYING(4) 4
92 ACCOUNT_OVERRIDE_FLAG BIGINT 8
93 ACCOUNT_OVERRIDE_REASON CHARACTER VARYING(100) 100
94 ACCOUNT_OVERRIDE_SOURCE CHARACTER VARYING(100) 100
95 BORROWER_OVERRIDE_FLAG BIGINT 8
96 BORROWER_OVERRIDE_REASON CHARACTER VARYING(100) 100
97 BORROWER_OVERRIDE_SOURCE CHARACTER VARYING(100) 100
98 CALCULATED_ACCOUNT_CQR CHARACTER VARYING(5) 5
99 ACTUAL_ACCOUNT_CQR CHARACTER VARYING(5) 5
100 CALCULATED_ACCOUNT_SR CHARACTER VARYING(5) 5
101 ACTUAL_ACCOUNT_SR CHARACTER VARYING(5) 5
102 CALCULATED_BORROWER_CQR CHARACTER VARYING(5) 5
103 ACTUAL_BORROWER_CQR CHARACTER VARYING(5) 5
104 CALCULATED_BORROWER_SR CHARACTER VARYING(5) 5
105 ACTUAL_BORROWER_SR CHARACTER VARYING(5) 5
106 BORROWER_RISK_MODEL_CODE BIGINT 8
107 ACCOUNT_RISK_MODEL_CODE BIGINT 8
108 BORROWER_LAST_SCORE_DATE CHARACTER VARYING(12) 12
109 ACCOUNT_LAST_SCORE_DATE CHARACTER VARYING(12) 12
110 NET_SALES NUMERIC(18,0) 19
111 GROUP_CRITERIA_SCORE CHARACTER VARYING(10) 10
112 ACTUAL_GROUP_CDR CHARACTER VARYING(5) 5
113 CALCULATED_GROUP_CDR CHARACTER VARYING(2) 2
114 GROUP_OVERRIDE_FLAG BIGINT 8
115 GROUP_OVERRIDE_REASON CHARACTER VARYING(100) 100
116 GROUP_OVERRIDE_SOURCE CHARACTER VARYING(100) 100
117 DELTA_TYPE CHARACTER VARYING(1) 1
118 EFFECTIVE_STRT_DT TIMESTAMP 8
119 EFFECTIVE_END_DT TIMESTAMP 8
120 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
121 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
122 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
123 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8