FCT_BNK_HOG_BL_PORTFOLIO_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BNK_HOG_BL_PORTFOLIO

Columns
# Name Data Type Length
1 ACCOUNT_NUM CHARACTER VARYING(9) 9
2 BORROWER_NO CHARACTER VARYING(9) 9
3 GROUP_NO CHARACTER VARYING(50) 50
4 GROUP_NAME CHARACTER VARYING(30) 30
5 BORROWER_NAME1 CHARACTER VARYING(80) 80
6 BORROWER_NAME2 CHARACTER VARYING(80) 80
7 BORROWER_NAME3 CHARACTER VARYING(80) 80
8 ADDRESS_1 CHARACTER VARYING(50) 50
9 ADDRESS_2 CHARACTER VARYING(50) 50
10 SUBURB CHARACTER VARYING(40) 40
11 STATE CHARACTER VARYING(30) 30
12 PCODE CHARACTER VARYING(10) 10
13 BOR_BRANCH INTEGER 4
14 BOR_BRANCH_DESC CHARACTER VARYING(100) 100
15 LOAN_BRANCH INTEGER 4
16 LOAN_BRANCH_DESC CHARACTER VARYING(100) 100
17 PEOPLESOFT_CODE INTEGER 4
18 OWNER_BRANCH INTEGER 4
19 DIVISION_CODE CHARACTER VARYING(5) 5
20 PORTFOLIO_IND CHARACTER VARYING(1) 1
21 BORROWER_BDM CHARACTER VARYING(5) 5
22 BORROWER_BDM_DESC CHARACTER VARYING(50) 50
23 OFFICER_CODE CHARACTER VARYING(5) 5
24 OFFICER_DESC CHARACTER VARYING(40) 40
25 OFFICER_CD_DESC CHARACTER VARYING(50) 50
26 LOAN_BROKER_CODE CHARACTER VARYING(5) 5
27 LOAN_BROKER_NAME CHARACTER VARYING(40) 40
28 SOURCE_DESC CHARACTER VARYING(50) 50
29 INTRODUCER_TYPE CHARACTER VARYING(1) 1
30 BUSINESS_SOURCE CHARACTER VARYING(1) 1
31 PRINCIPAL_LIMIT NUMERIC(16,2) 19
32 BALANCE NUMERIC(16,2) 19
33 HINT_RATE NUMERIC(11,6) 19
34 HINT_EXEMPT_FLAG CHARACTER VARYING(1) 1
35 RCM_MARGIN NUMERIC(11,6) 19
36 RFM_MARGIN NUMERIC(11,6) 19
37 EFFECTIVE_RATE DOUBLE PRECISION 8
38 AVG_ARREARS CHARACTER VARYING(14) 14
39 INDUST_CODE CHARACTER VARYING(14) 14
40 BUS_CODE CHARACTER VARYING(14) 14
41 LOAN_PUR_CODE CHARACTER VARYING(3) 3
42 LOAN_CAT CHARACTER VARYING(10) 10
43 PRODUCT CHARACTER VARYING(3) 3
44 PRODUCT_DESC CHARACTER VARYING(40) 40
45 BORR_STRT_DATE DATE 4
46 START_DATE DATE 4
47 EXPIRY_DATE DATE 4
48 RESIDUAL NUMERIC(15,2) 19
49 COMPANY NUMERIC(10,0) 19
50 CLIENT_ANZSIC CHARACTER VARYING(4) 4
51 ACCT_ANZSIC CHARACTER VARYING(4) 4
52 CQR CHARACTER VARYING(2) 2
53 SR CHARACTER VARYING(1) 1
54 CRC CHARACTER VARYING(14) 14
55 CRGS_DATE DATE 4
56 FAST_SCORE CHARACTER VARYING(14) 14
57 CONSTRUCTION_STAGE CHARACTER VARYING(14) 14
58 MKT_SEGMENT CHARACTER VARYING(14) 14
59 SECTOR CHARACTER VARYING(14) 14
60 PROJECT_POSTCODE CHARACTER VARYING(14) 14
61 UNDRAWN_AMT NUMERIC(16,2) 19
62 TOTAL_COMMITMENT NUMERIC(16,2) 19
63 AMU_FLAG CHARACTER VARYING(14) 14
64 BOR_FB1_CAT CHARACTER VARYING(14) 14
65 LOAN_FB1_CAT CHARACTER VARYING(14) 14
66 MGT_REP_CAT CHARACTER VARYING(14) 14
67 SAL CHARACTER VARYING(14) 14
68 MASTER_LIMIT_NUMBER CHARACTER VARYING(1) 1
69 MASTER_LIMIT CHARACTER VARYING(1) 1
70 MASTER_LIMIT_DATE CHARACTER VARYING(1) 1
71 MASTER_LIMIT_AMOUNT CHARACTER VARYING(1) 1
72 PURPOSE CHARACTER VARYING(50) 50
73 NXT_REV_TYPE CHARACTER VARYING(1) 1
74 NXT_REV_DATE DATE 4
75 INBA NUMERIC(13,2) 19
76 ACCT_CQR CHARACTER VARYING(2) 2
77 ACCT_SR CHARACTER VARYING(1) 1
78 ACCT_CRC CHARACTER VARYING(3) 3
79 ACCT_CRGS_DATE DATE 4
80 SCORE_CARD CHARACTER VARYING(2) 2
81 CALC_CQR CHARACTER VARYING(2) 2
82 CALC_SR CHARACTER VARYING(1) 1
83 TCE CHARACTER VARYING(1) 1
84 TCE_SSV CHARACTER VARYING(1) 1
85 COL_CAT_A CHARACTER VARYING(1) 1
86 COL_CAT_B CHARACTER VARYING(1) 1
87 OVERRIDE CHARACTER VARYING(2) 2
88 OVERRIDE_REASON CHARACTER VARYING(100) 100
89 OVERRIDE_SOURCE CHARACTER VARYING(100) 100
90 GTEE_LIMIT NUMERIC(15,2) 19
91 GTEE_DRAWN NUMERIC(15,2) 19
92 ORIG_APP_AMT NUMERIC(16,2) 19
93 ARRS_GRTE_90DAYS_AMT NUMERIC(16,2) 19
94 THIRD_PARTY_CODE CHARACTER VARYING(1) 1
95 WEM_SCORECARD_CODE CHARACTER VARYING(2) 2
96 WEM_SCORECARD CHARACTER VARYING(19) 19
97 STATE_CODE CHARACTER VARYING(3) 3
98 CUST_MARGIN NUMERIC(11,6) 19
99 BASE_RATE DOUBLE PRECISION 8
100 COMMENT_LINE_2 CHARACTER VARYING(1) 1
101 LOAN_DESC CHARACTER VARYING(30) 30
102 WATCHLIST_FLAG CHARACTER VARYING(20) 20
103 ARRS_LSSR_30DAYS_AMT NUMERIC(16,2) 19
104 ARRS_GRTE_30DAYS_AMT NUMERIC(16,2) 19
105 ARRS_GRTE_60DAYS_AMT NUMERIC(16,2) 19
106 RATE_REVIEW_COMMENT CHARACTER VARYING(1) 1
107 RATE_REVIEW_DATE DATE 4
108 RATE_CODE CHARACTER VARYING(30) 30
109 RATE_DESC CHARACTER VARYING(40) 40
110 CURR_BAB_FV CHARACTER VARYING(14) 14
111 LEAD_NO CHARACTER VARYING(50) 50
112 CORE CHARACTER VARYING(14) 14
113 CURRENT_BALANCE NUMERIC(16,2) 19
114 CAPITAL_BALANCE CHARACTER VARYING(14) 14
115 NO_DAYS_IN_ARREARS INTEGER 4
116 REDRAW_OPTION CHARACTER VARYING(1) 1
117 PRODUCT_SOURCE_SYSTEM CHARACTER VARYING(5) 5
118 SOURCE_DATA_DATE DATE 4
119 RUN_DATE_TIME TIMESTAMP 8
120 RLNSHP_MGR_UID CHARACTER VARYING(7) 7
121 RLNSHP_MGR_NAME CHARACTER VARYING(30) 30
122 RLNSHP_MGR_UID_NM CHARACTER VARYING(100) 100
123 ASTN_RLNSHP_MGR_UID CHARACTER VARYING(7) 7
124 ASTN_RLNSHP_MGR_NAME CHARACTER VARYING(30) 30
125 ASTN_RLNSHP_MGR_UID_NM CHARACTER VARYING(100) 100
126 OPRN_DLVRY_MGR_UID CHARACTER VARYING(7) 7
127 OPRN_DLVRY_MGR_NAME CHARACTER VARYING(30) 30
128 OPRN_DLVRY_MGR_UID_NM CHARACTER VARYING(100) 100
129 HEAD_OR_EXEC_MGR_UID CHARACTER VARYING(7) 7
130 HEAD_OR_EXEC_MGR_NAME CHARACTER VARYING(30) 30
131 HEAD_OR_EXEC_MGR_UID_NM CHARACTER VARYING(100) 100
132 DSTRCT_MGR_UID CHARACTER VARYING(7) 7
133 DSTRCT_MGR_NAME CHARACTER VARYING(30) 30
134 DSTRCT_MGR_UID_NM CHARACTER VARYING(100) 100
135 DISTRIBUTION_GROUP CHARACTER VARYING(250) 250
136 LINE_FEE_PERCENTAGE NUMERIC(9,4) 19
137 COLLATERAL_PRIMARY_ABS_REGION CHARACTER VARYING(255) 255
138 COLLATERAL_PRIMARY_STATE CHARACTER VARYING(10) 10
139 COLLATERAL_PRIMARY_SUBURB CHARACTER VARYING(50) 50
140 COLLATERAL_PRIMARY_PCODE CHARACTER VARYING(10) 10
141 COLLATERAL_PRIMARY_CATEGORY CHARACTER VARYING(50) 50
142 COLLATERAL_PRIMARY_ID NUMERIC(16,0) 19