| 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 |