OBP24_CZ_SC_OR_EXPR_RESP_COLLATERAL
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_CZ_SC_OR_EXPR_RESP_COLLATERAL
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | MASTER_KEY | CHARACTER VARYING(50) | 50 |
| 2 | SUBMISSION_ID | CHARACTER VARYING(20) | 20 |
| 3 | APPLICATION_ID | CHARACTER VARYING(20) | 20 |
| 4 | COLLATERAL_ID | CHARACTER VARYING(20) | 20 |
| 5 | RC_VEND_COMP_TREE_ID | CHARACTER VARYING(8) | 8 |
| 6 | RC_VEND_COMP_TREE_NAME | CHARACTER VARYING(100) | 100 |
| 7 | RC_VEND_COMP_ID | CHARACTER VARYING(8) | 8 |
| 8 | RC_VEND_COMP_NAME | CHARACTER VARYING(100) | 100 |
| 9 | RC_VEND_LEAF_NODE_ID | CHARACTER VARYING(8) | 8 |
| 10 | RC_VEND_LEAF_NODE_NAME | CHARACTER VARYING(100) | 100 |
| 11 | RC_VEND_OUTCOME_ID | CHARACTER VARYING(8) | 8 |
| 12 | RC_VEND_OUTCOME_NAME | CHARACTER VARYING(100) | 100 |
| 13 | RC_VEND_TG_SET_ID | CHARACTER VARYING(8) | 8 |
| 14 | RC_VEND_TG_SET_NAME | CHARACTER VARYING(100) | 100 |
| 15 | RC_VEND_TG_ID | CHARACTER VARYING(2) | 2 |
| 16 | RC_VEND_TG_NAME | CHARACTER VARYING(100) | 100 |
| 17 | RC_VEND_DER_DATA_SCRIPT_ID | CHARACTER VARYING(8) | 8 |
| 18 | RC_VEND_DER_DATA_SCRIPT_NAME | CHARACTER VARYING(100) | 100 |
| 19 | RC_VEND_RANDOM_NUM | NUMERIC(20,2) | 19 |
| 20 | RC_VTS_TRTMT_TREE_ID | CHARACTER VARYING(8) | 8 |
| 21 | RC_VTS_TRTMT_TREE_NAME | CHARACTER VARYING(100) | 100 |
| 22 | RC_VTS_LEAF_NODE_ID | CHARACTER VARYING(8) | 8 |
| 23 | RC_VTS_LEAF_NODE_NAME | CHARACTER VARYING(100) | 100 |
| 24 | RC_VTS_OUTCOME_ID | CHARACTER VARYING(8) | 8 |
| 25 | RC_VTS_OUTCOME_NAME | CHARACTER VARYING(100) | 100 |
| 26 | RC_VTS_TRTMT_TABLE_ID | CHARACTER VARYING(8) | 8 |
| 27 | RC_VTS_TRTMT_TABLE_NAME | CHARACTER VARYING(100) | 100 |
| 28 | RC_VTS_TRTMT_ID | CHARACTER VARYING(8) | 8 |
| 29 | RC_VTS_TRTMT_NAME | CHARACTER VARYING(100) | 100 |
| 30 | RC_VTS_TG_SET_ID | CHARACTER VARYING(8) | 8 |
| 31 | RC_VTS_TG_SET_NAME | CHARACTER VARYING(100) | 100 |
| 32 | RC_VTS_TG_ID | CHARACTER VARYING(2) | 2 |
| 33 | RC_VTS_TG_NAME | CHARACTER VARYING(100) | 100 |
| 34 | RC_VTS_RANDOM_NUM | NUMERIC(20,2) | 19 |
| 35 | RC_VP_DEC_SETTER_ID | CHARACTER VARYING(8) | 8 |
| 36 | RC_VP_DEC_SETTER_NAME | CHARACTER VARYING(100) | 100 |
| 37 | RC_VP_COMP_TREE_ID | CHARACTER VARYING(8) | 8 |
| 38 | RC_VP_COMP_TREE_NAME | CHARACTER VARYING(100) | 100 |
| 39 | RC_VP_LEAF_NODE_ID | CHARACTER VARYING(8) | 8 |
| 40 | RC_VP_LEAF_NODE_NAME | CHARACTER VARYING(100) | 100 |
| 41 | RC_VP_OUTCOME_ID | CHARACTER VARYING(8) | 8 |
| 42 | RC_VP_OUTCOME_NAME | CHARACTER VARYING(100) | 100 |
| 43 | RC_VP_COMP_ID | CHARACTER VARYING(8) | 8 |
| 44 | RC_VP_COMP_NAME | CHARACTER VARYING(100) | 100 |
| 45 | RC_VP_TG_SET_ID | CHARACTER VARYING(8) | 8 |
| 46 | RC_VP_TG_SET_NAME | CHARACTER VARYING(100) | 100 |
| 47 | RC_VP_TG_ID | CHARACTER VARYING(2) | 2 |
| 48 | RC_VP_TG_NAME | CHARACTER VARYING(100) | 100 |
| 49 | RC_VP_RANDOM_NUM | NUMERIC(20,2) | 19 |
| 50 | RC_VEXD_COMP_TREE_ID | CHARACTER VARYING(8) | 8 |
| 51 | RC_VEXD_COMP_TREE_NAME | CHARACTER VARYING(100) | 100 |
| 52 | RC_VEXD_COMP_ID | CHARACTER VARYING(8) | 8 |
| 53 | RC_VEXD_COMP_NAME | CHARACTER VARYING(100) | 100 |
| 54 | RC_VEXD_LEAF_NODE_ID | CHARACTER VARYING(8) | 8 |
| 55 | RC_VEXD_LEAF_NODE_NAME | CHARACTER VARYING(100) | 100 |
| 56 | RC_VEXD_OUTCOME_ID | CHARACTER VARYING(8) | 8 |
| 57 | RC_VEXD_OUTCOME_NAME | CHARACTER VARYING(100) | 100 |
| 58 | RC_VEXD_TG_SET_ID | CHARACTER VARYING(8) | 8 |
| 59 | RC_VEXD_TG_SET_NAME | CHARACTER VARYING(100) | 100 |
| 60 | RC_VEXD_TG_ID | CHARACTER VARYING(2) | 2 |
| 61 | RC_VEXD_TG_NAME | CHARACTER VARYING(100) | 100 |
| 62 | RC_VEXD_DER_DATA_SCRIPT_ID | CHARACTER VARYING(8) | 8 |
| 63 | RC_VEXD_DER_DATA_SCRIPT_NAME | CHARACTER VARYING(100) | 100 |
| 64 | RC_VEXD_RANDOM_NUM | NUMERIC(20,2) | 19 |
| 65 | VALUATION_TYPE | CHARACTER VARYING(1) | 1 |
| 66 | VP_DEC_TEXT | CHARACTER VARYING(20) | 20 |
| 67 | VP_DEC_REASONCODE | CHARACTER VARYING(10) | 10 |
| 68 | VP_DEC_CATEGORY | CHARACTER VARYING(20) | 20 |
| 69 | VP_SORT_RES_COD_TAB_I1 | CHARACTER VARYING(10) | 10 |
| 70 | VP_SORT_RES_COD_TAB_I2 | CHARACTER VARYING(10) | 10 |
| 71 | VP_SORT_RES_COD_TAB_I3 | CHARACTER VARYING(10) | 10 |
| 72 | VP_SORT_RES_COD_TAB_I4 | CHARACTER VARYING(10) | 10 |
| 73 | VP_SORT_RES_COD_TAB_I5 | CHARACTER VARYING(10) | 10 |
| 74 | VP_SORT_RES_COD_TAB_I6 | CHARACTER VARYING(10) | 10 |
| 75 | VP_SORT_RES_COD_TAB_I7 | CHARACTER VARYING(10) | 10 |
| 76 | VP_SORT_RES_COD_TAB_I8 | CHARACTER VARYING(10) | 10 |
| 77 | VP_SORT_RES_COD_TAB_I9 | CHARACTER VARYING(10) | 10 |
| 78 | VP_SORT_RES_COD_TAB_I10 | CHARACTER VARYING(10) | 10 |
| 79 | VP_SORT_RES_COD_TAB_I11 | CHARACTER VARYING(10) | 10 |
| 80 | VP_SORT_RES_COD_TAB_I12 | CHARACTER VARYING(10) | 10 |
| 81 | VP_SORT_RES_COD_TAB_I13 | CHARACTER VARYING(10) | 10 |
| 82 | VP_SORT_RES_COD_TAB_I14 | CHARACTER VARYING(10) | 10 |
| 83 | VP_SORT_RES_COD_TAB_I15 | CHARACTER VARYING(10) | 10 |
| 84 | VP_SORT_RES_COD_TAB_I16 | CHARACTER VARYING(10) | 10 |
| 85 | VP_SORT_RES_COD_TAB_I17 | CHARACTER VARYING(10) | 10 |
| 86 | VP_SORT_RES_COD_TAB_I18 | CHARACTER VARYING(10) | 10 |
| 87 | VP_SORT_RES_COD_TAB_I19 | CHARACTER VARYING(10) | 10 |
| 88 | VP_SORT_RES_COD_TAB_I20 | CHARACTER VARYING(10) | 10 |
| 89 | VP_SORT_RES_COD_TAB_I21 | CHARACTER VARYING(10) | 10 |
| 90 | VP_SORT_RES_COD_TAB_I22 | CHARACTER VARYING(10) | 10 |
| 91 | VP_SORT_RES_COD_TAB_I23 | CHARACTER VARYING(10) | 10 |
| 92 | VP_SORT_RES_COD_TAB_I24 | CHARACTER VARYING(10) | 10 |
| 93 | VP_SORT_RES_COD_TAB_I25 | CHARACTER VARYING(10) | 10 |
| 94 | VP_SORT_DEC_TAB_I1 | CHARACTER VARYING(50) | 50 |
| 95 | VP_SORT_DEC_TAB_I2 | CHARACTER VARYING(50) | 50 |
| 96 | VP_SORT_DEC_TAB_I3 | CHARACTER VARYING(50) | 50 |
| 97 | VP_SORT_DEC_TAB_I4 | CHARACTER VARYING(50) | 50 |
| 98 | VP_SORT_DEC_TAB_I5 | CHARACTER VARYING(50) | 50 |
| 99 | VP_SORT_DEC_TAB_I6 | CHARACTER VARYING(50) | 50 |
| 100 | VP_SORT_DEC_TAB_I7 | CHARACTER VARYING(50) | 50 |
| 101 | VP_SORT_DEC_TAB_I8 | CHARACTER VARYING(50) | 50 |
| 102 | VP_SORT_DEC_TAB_I9 | CHARACTER VARYING(50) | 50 |
| 103 | VP_SORT_DEC_TAB_I10 | CHARACTER VARYING(50) | 50 |
| 104 | VP_SORT_DEC_TAB_I11 | CHARACTER VARYING(50) | 50 |
| 105 | VP_SORT_DEC_TAB_I12 | CHARACTER VARYING(50) | 50 |
| 106 | VP_SORT_DEC_TAB_I13 | CHARACTER VARYING(50) | 50 |
| 107 | VP_SORT_DEC_TAB_I14 | CHARACTER VARYING(50) | 50 |
| 108 | VP_SORT_DEC_TAB_I15 | CHARACTER VARYING(50) | 50 |
| 109 | VP_SORT_DEC_TAB_I16 | CHARACTER VARYING(50) | 50 |
| 110 | VP_SORT_DEC_TAB_I17 | CHARACTER VARYING(50) | 50 |
| 111 | VP_SORT_DEC_TAB_I18 | CHARACTER VARYING(50) | 50 |
| 112 | VP_SORT_DEC_TAB_I19 | CHARACTER VARYING(50) | 50 |
| 113 | VP_SORT_DEC_TAB_I20 | CHARACTER VARYING(50) | 50 |
| 114 | VP_SORT_DEC_TAB_I21 | CHARACTER VARYING(50) | 50 |
| 115 | VP_SORT_DEC_TAB_I22 | CHARACTER VARYING(50) | 50 |
| 116 | VP_SORT_DEC_TAB_I23 | CHARACTER VARYING(50) | 50 |
| 117 | VP_SORT_DEC_TAB_I24 | CHARACTER VARYING(50) | 50 |
| 118 | VP_SORT_DEC_TAB_I25 | CHARACTER VARYING(50) | 50 |
| 119 | VAL_FUSION_VAL | NUMERIC(20,2) | 19 |
| 120 | VAL_FUSION_VAL_LOW | NUMERIC(20,2) | 19 |
| 121 | VAL_FUSION_VAL_HIGH | NUMERIC(20,2) | 19 |
| 122 | VAL_FUSION_VAL_FSD | NUMERIC(20,2) | 19 |
| 123 | VAL_FUSION_VAL_DATE | CHARACTER VARYING(7) | 7 |
| 124 | PROP_PROPERTY_TYPE | CHARACTER VARYING(10) | 10 |
| 125 | PROP_DP_ID | NUMERIC(20,2) | 19 |
| 126 | PROP_PDP_ID | NUMERIC(20,2) | 19 |
| 127 | PROP_MUD_ID | NUMERIC(20,2) | 19 |
| 128 | PROP_UNIT_NO | NUMERIC(20,2) | 19 |
| 129 | PROP_UNIT_NO_DER | CHARACTER VARYING(1) | 1 |
| 130 | PROP_STREET_NO_START | NUMERIC(20,2) | 19 |
| 131 | PROP_STREET_NO_END | NUMERIC(20,2) | 19 |
| 132 | PROP_STREET_NAME | CHARACTER VARYING(100) | 100 |
| 133 | PROP_STREET_TYPE | CHARACTER VARYING(20) | 20 |
| 134 | PROP_STREET_DIRECTION | CHARACTER VARYING(10) | 10 |
| 135 | PROP_SUBURB | CHARACTER VARYING(20) | 20 |
| 136 | PROP_POST_CODE | NUMERIC(20,2) | 19 |
| 137 | PROP_STATE | CHARACTER VARYING(3) | 3 |
| 138 | PROP_LGA | CHARACTER VARYING(20) | 20 |
| 139 | PROP_LATITUDE | NUMERIC(20,2) | 19 |
| 140 | PROP_LONGITUDE | NUMERIC(20,2) | 19 |
| 141 | PROP_LAND_AREA | NUMERIC(20,2) | 19 |
| 142 | PROP_OCCUPANCY_TYPE | NUMERIC(20,2) | 19 |
| 143 | PROP_OCCUPANCY_TYPE_CONF | NUMERIC(20,2) | 19 |
| 144 | PROP_OCCUPANCY_TYPE_DATE | TIMESTAMP | 8 |
| 145 | ATTR_HISTORYF_ROM | TIMESTAMP | 8 |
| 146 | ATTR_EST_LAND_AREA | NUMERIC(20,2) | 19 |
| 147 | ATTR_LISTING_LAND_AREA | NUMERIC(20,2) | 19 |
| 148 | ATTR_EQU_BUILDING_AREA | NUMERIC(20,2) | 19 |
| 149 | ATTR_FLOOR_AREA | NUMERIC(20,2) | 19 |
| 150 | ATTR_BED_ROOMS | NUMERIC(20,2) | 19 |
| 151 | ATTR_BED_ROOMS_DERIVED | CHARACTER VARYING(1) | 1 |
| 152 | ATTR_BATH_ROOMS | NUMERIC(20,2) | 19 |
| 153 | ATTR_BATH_ROOMS_DERIVED | CHARACTER VARYING(1) | 1 |
| 154 | ATTR_CAR_SPACES | NUMERIC(20,2) | 19 |
| 155 | ATTR_GARAGES | CHARACTER VARYING(1) | 1 |
| 156 | ATTR_YEAR_BUILT | NUMERIC(20,2) | 19 |
| 157 | ATTR_MATERIALS_IN_ROOF | CHARACTER VARYING(20) | 20 |
| 158 | ATTR_MATERIALS_IN_EXT_WALLS | CHARACTER VARYING(20) | 20 |
| 159 | ATTR_MATERIALS_IN_FLOOR | CHARACTER VARYING(20) | 20 |
| 160 | ATTR_BOND_AMOUNT | NUMERIC(20,2) | 19 |
| 161 | ATTR_ACCESS_SEC_INSTALLED | CHARACTER VARYING(1) | 1 |
| 162 | ATTR_AIR_CONDITIONED | CHARACTER VARYING(1) | 1 |
| 163 | ATTR_ARCHITECTURAL_STYLE | CHARACTER VARYING(20) | 20 |
| 164 | ATTR_CLOSE_PUBLIC_TRANSPORT | CHARACTER VARYING(1) | 1 |
| 165 | ATTR_CONDITION | CHARACTER VARYING(10) | 10 |
| 166 | ATTR_CONSTRUCTION_TYPE | CHARACTER VARYING(10) | 10 |
| 167 | ATTR_DINING_ROOMS | NUMERIC(20,2) | 19 |
| 168 | ATTR_DUCTED_HEATING | CHARACTER VARYING(1) | 1 |
| 169 | ATTR_ENSUITES | NUMERIC(20,2) | 19 |
| 170 | ATTR_FAMILY_ROOMS | NUMERIC(20,2) | 19 |
| 171 | ATTR_FIRE_PLACE | NUMERIC(20,2) | 19 |
| 172 | ATTR_FLOOR_LEVEL_OF_UNIT | NUMERIC(20,2) | 19 |
| 173 | ATTR_FRONTAGE | NUMERIC(20,2) | 19 |
| 174 | ATTR_LOUNGE_ROOMS | NUMERIC(20,2) | 19 |
| 175 | ATTR_LOUNGE_DINING_COMB | NUMERIC(20,2) | 19 |
| 176 | ATTR_STR_FRONTAGE_SIZE | NUMERIC(20,2) | 19 |
| 177 | ATTR_GAMES_ROOMS | NUMERIC(20,2) | 19 |
| 178 | ATTR_KITCHENS | NUMERIC(20,2) | 19 |
| 179 | ATTR_MEAL_ROOMS | NUMERIC(20,2) | 19 |
| 180 | ATTR_STUDY_ROOMS | NUMERIC(20,2) | 19 |
| 181 | ATTR_FLOOR_LEVELS_INS_UNIT | NUMERIC(20,2) | 19 |
| 182 | ATTR_ON_MAINROAD | CHARACTER VARYING(1) | 1 |
| 183 | ATTR_OPEN_PLAN | CHARACTER VARYING(1) | 1 |
| 184 | ATTR_OTHER_ROOMS | NUMERIC(20,2) | 19 |
| 185 | ATTR_POLISHED_FLOORS | CHARACTER VARYING(1) | 1 |
| 186 | ATTR_RENOVATED | CHARACTER VARYING(1) | 1 |
| 187 | ATTR_SCENIC_VIEW | CHARACTER VARYING(1) | 1 |
| 188 | ATTR_SWIMMING_POOL | CHARACTER VARYING(1) | 1 |
| 189 | ATTR_TOILETS | NUMERIC(20,2) | 19 |
| 190 | ATTR_TOT_FLOORS_IN_BLDG | NUMERIC(20,2) | 19 |
| 191 | ATTR_VG_NUMBER | CHARACTER VARYING(20) | 20 |
| 192 | ATTR_YEAR_BLDG_REFURBISHED | NUMERIC(20,2) | 19 |
| 193 | ATTR_MAIN_ROOMS | NUMERIC(20,2) | 19 |
| 194 | ATTR_HERITAGE_FLAG | CHARACTER VARYING(1) | 1 |
| 195 | ATTR_HERITAGE_AND_OTHER | CHARACTER VARYING(1) | 1 |
| 196 | ATTR_UNIMPR_CAP_VALUE_DATE | TIMESTAMP | 8 |
| 197 | ATTR_UNIMPR_CAP_VALUE | NUMERIC(20,2) | 19 |
| 198 | ATTR_SITE_VALUE_DATE | TIMESTAMP | 8 |
| 199 | ATTR_SITE_VALUE | NUMERIC(20,2) | 19 |
| 200 | ATTR_CAP_VALUE_DATE | TIMESTAMP | 8 |
| 201 | ATTR_CAP_VALUE | NUMERIC(20,2) | 19 |
| 202 | SPARE_S1 | CHARACTER VARYING(30) | 30 |
| 203 | SPARE_S2 | CHARACTER VARYING(30) | 30 |
| 204 | SPARE_S3 | CHARACTER VARYING(30) | 30 |
| 205 | SPARE_S4 | CHARACTER VARYING(30) | 30 |
| 206 | SPARE_S5 | CHARACTER VARYING(30) | 30 |
| 207 | SPARE_S6 | CHARACTER VARYING(30) | 30 |
| 208 | SPARE_S7 | CHARACTER VARYING(30) | 30 |
| 209 | SPARE_S8 | CHARACTER VARYING(30) | 30 |
| 210 | SPARE_S9 | CHARACTER VARYING(30) | 30 |
| 211 | SPARE_S10 | CHARACTER VARYING(30) | 30 |
| 212 | SPARE_S11 | CHARACTER VARYING(30) | 30 |
| 213 | SPARE_S12 | CHARACTER VARYING(30) | 30 |
| 214 | SPARE_S13 | CHARACTER VARYING(30) | 30 |
| 215 | SPARE_S14 | CHARACTER VARYING(30) | 30 |
| 216 | SPARE_S15 | CHARACTER VARYING(30) | 30 |
| 217 | SPARE_S16 | CHARACTER VARYING(30) | 30 |
| 218 | SPARE_S17 | CHARACTER VARYING(30) | 30 |
| 219 | SPARE_S18 | CHARACTER VARYING(30) | 30 |
| 220 | SPARE_S19 | CHARACTER VARYING(30) | 30 |
| 221 | SPARE_S20 | CHARACTER VARYING(30) | 30 |
| 222 | SPARE_F1 | NUMERIC(20,2) | 19 |
| 223 | SPARE_F2 | NUMERIC(20,2) | 19 |
| 224 | SPARE_F3 | NUMERIC(20,2) | 19 |
| 225 | SPARE_F4 | NUMERIC(20,2) | 19 |
| 226 | SPARE_F5 | NUMERIC(20,2) | 19 |
| 227 | SPARE_F6 | NUMERIC(20,2) | 19 |
| 228 | SPARE_F7 | NUMERIC(20,2) | 19 |
| 229 | SPARE_F8 | NUMERIC(20,2) | 19 |
| 230 | SPARE_F9 | NUMERIC(20,2) | 19 |
| 231 | SPARE_F10 | NUMERIC(20,2) | 19 |
| 232 | SPARE_F11 | NUMERIC(20,2) | 19 |
| 233 | SPARE_F12 | NUMERIC(20,2) | 19 |
| 234 | SPARE_F13 | NUMERIC(20,2) | 19 |
| 235 | SPARE_F14 | NUMERIC(20,2) | 19 |
| 236 | SPARE_F15 | NUMERIC(20,2) | 19 |
| 237 | SPARE_F16 | NUMERIC(20,2) | 19 |
| 238 | SPARE_F17 | NUMERIC(20,2) | 19 |
| 239 | SPARE_F18 | NUMERIC(20,2) | 19 |
| 240 | SPARE_F19 | NUMERIC(20,2) | 19 |
| 241 | SPARE_F20 | NUMERIC(20,2) | 19 |
| 242 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 243 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 244 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 245 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |