| 1 |
SK |
BIGINT |
8 |
| 2 |
AGENT |
INTEGER |
4 |
| 3 |
AGENT_ABN_NUMBER |
CHARACTER VARYING(12) |
12 |
| 4 |
AGENT_COMMISSION_PAID_FLAG |
CHARACTER VARYING(1) |
1 |
| 5 |
AGENT_GROUP |
INTEGER |
4 |
| 6 |
AGENT_NAME |
CHARACTER VARYING(100) |
100 |
| 7 |
AGENT_NAME_BDM |
CHARACTER VARYING(100) |
100 |
| 8 |
AGENT_NAME_BDM_KEY |
SMALLINT |
2 |
| 9 |
AGENT_OWNED_ID |
INTEGER |
4 |
| 10 |
AGENT_UNPAID_POLICY_FLAG |
CHARACTER VARYING(1) |
1 |
| 11 |
AGREEMENT_TYPE |
CHARACTER(4) |
4 |
| 12 |
ALLOCATED_ATRNTYPE |
CHARACTER VARYING(2) |
2 |
| 13 |
ALLOCATED_DATE |
INTEGER |
4 |
| 14 |
ALLOCATED_TIME |
CHARACTER VARYING(2000) |
2000 |
| 15 |
AT_FAULT_ACCIDENT |
SMALLINT |
2 |
| 16 |
AT_FAULT_ACCIDENT_VALUE |
SMALLINT |
2 |
| 17 |
AT_FAULT_ACCIDENT_GROUP |
CHARACTER VARYING(10) |
10 |
| 18 |
AT_FAULT_ACCIDENT_GROUP_KEY |
INTEGER |
4 |
| 19 |
AT_FAULT_ACCIDENT_NAME |
CHARACTER VARYING(60) |
60 |
| 20 |
AT_FAULT_ACCIDENT_LAST3YR |
CHARACTER VARYING(60) |
60 |
| 21 |
NOT_AT_FAULT_ACCIDENT |
SMALLINT |
2 |
| 22 |
NOT_AT_FAULT_ACCIDENT_VALUE |
SMALLINT |
2 |
| 23 |
NOT_AT_FAULT_ACCIDENT_GROUP |
CHARACTER VARYING(10) |
10 |
| 24 |
NOT_AT_FAULT_ACCIDENT_GROUP_KEY |
INTEGER |
4 |
| 25 |
NOT_AT_FAULT_ACCIDENT_NAME |
CHARACTER VARYING(60) |
60 |
| 26 |
NOT_AT_FAULT_ACCIDENT_LAST3YR |
CHARACTER VARYING(60) |
60 |
| 27 |
TOTAL_ACCIDENTS |
SMALLINT |
2 |
| 28 |
BACKOUT_INDICACTOR |
CHARACTER VARYING(3) |
3 |
| 29 |
BASIC_PREMIUM |
NUMERIC(12,2) |
19 |
| 30 |
BATCH_RUN_NUMBER |
INTEGER |
4 |
| 31 |
BRANCH_NAME |
CHARACTER VARYING(255) |
255 |
| 32 |
BRANCH_NO |
INTEGER |
4 |
| 33 |
BRANCH_STATE |
CHARACTER VARYING(255) |
255 |
| 34 |
BRAND_ID |
CHARACTER(3) |
3 |
| 35 |
BRAND_NAME |
CHARACTER VARYING(60) |
60 |
| 36 |
BUSINESS_SOURCE |
CHARACTER(4) |
4 |
| 37 |
BUSINESS_SOURCE_WHERE_PROPOSAL_INITIATED |
CHARACTER VARYING(4) |
4 |
| 38 |
CAMPAIGN_NAME |
CHARACTER VARYING(73) |
73 |
| 39 |
CAMPAIGN_NAME_KEY |
CHARACTER(10) |
10 |
| 40 |
CANCEL_REASON |
CHARACTER VARYING(20) |
20 |
| 41 |
CANCEL_REASON_NAME |
CHARACTER VARYING(60) |
60 |
| 42 |
CANCEL_REASON_NAME_KEY |
CHARACTER VARYING(60) |
60 |
| 43 |
CERTIFICATE_TYPE |
CHARACTER VARYING(10) |
10 |
| 44 |
CHARGES_TOTAL |
NUMERIC(12,2) |
19 |
| 45 |
CHECK_DIGIT_FOR_CTP_NUMBER |
CHARACTER(1) |
1 |
| 46 |
CLIENT_ID |
INTEGER |
4 |
| 47 |
CLIENT_NAME |
CHARACTER VARYING(100) |
100 |
| 48 |
COMMISSION |
NUMERIC(12,2) |
19 |
| 49 |
COMMISSION_GST |
NUMERIC(12,2) |
19 |
| 50 |
COMMISSION_RATE_AMOUNT |
NUMERIC(11,2) |
19 |
| 51 |
COMMISSION_SCALE |
SMALLINT |
2 |
| 52 |
COMPANY |
SMALLINT |
2 |
| 53 |
COMPANY_REGISTERED |
CHARACTER VARYING(10) |
10 |
| 54 |
COMPANY_REGISTERED_ORDER_KEY |
CHARACTER VARYING(4) |
4 |
| 55 |
CONVERTED_QUOTE_USER_ID |
CHARACTER(8) |
8 |
| 56 |
CONVERTED_QUOTE_USER_NAME |
CHARACTER VARYING(100) |
100 |
| 57 |
CTP_NO |
CHARACTER(12) |
12 |
| 58 |
DEBTORS_ACCOUNT_PERIOD |
CHARACTER VARYING(20) |
20 |
| 59 |
DEBTORS_ACCOUNT_PERIOD_ORDER |
SMALLINT |
2 |
| 60 |
DISCOUNTED_ISSUED_POLICY_COUNT |
INTEGER |
4 |
| 61 |
DISCOUNTED_ISSUED_QUOTE_COUNT |
INTEGER |
4 |
| 62 |
DISCOUNTED_PAID_POLICY_COUNT |
INTEGER |
4 |
| 63 |
DISCOUNTED_TRANSACTION_COUNT |
INTEGER |
4 |
| 64 |
DISTRIBUTION_CHANNEL_ID |
CHARACTER(1) |
1 |
| 65 |
DISTRIBUTION_CHANNEL_NAME |
CHARACTER VARYING(100) |
100 |
| 66 |
DISTRIBUTION_CHANNEL_NAME_ORDER_KEY |
CHARACTER VARYING(2) |
2 |
| 67 |
DISTRIBUTION_CHANNEL_USERID |
CHARACTER(50) |
50 |
| 68 |
DISTRIBUTION_CHANNEL_USERNAME |
CHARACTER VARYING(100) |
100 |
| 69 |
DISTRIBUTION_CHANNEL_USERNAME_ORDER_KEY |
CHARACTER VARYING(201) |
201 |
| 70 |
DISTRIBUTION_CHANNEL_LEVEL1_ID |
CHARACTER(1) |
1 |
| 71 |
DISTRIBUTION_CHANNEL_LEVEL1_NAME |
CHARACTER VARYING(100) |
100 |
| 72 |
DISTRIBUTION_CHANNEL_LEVEL1_NAME_ORDER_KEY |
CHARACTER VARYING(100) |
100 |
| 73 |
DISTRIBUTION_CHANNEL_LEVEL2 |
CHARACTER VARYING(30) |
30 |
| 74 |
DISTRIBUTION_CHANNEL_LEVEL2_ID |
CHARACTER VARYING(130) |
130 |
| 75 |
DISTRIBUTION_CHANNEL_LEVEL3 |
CHARACTER VARYING(100) |
100 |
| 76 |
DISTRIBUTION_CHANNEL_LEVEL3_ID |
CHARACTER VARYING(230) |
230 |
| 77 |
DISTRIBUTION_CHANNEL_LEVEL4 |
CHARACTER VARYING(100) |
100 |
| 78 |
DISTRIBUTION_CHANNEL_LEVEL4_ID |
CHARACTER VARYING(330) |
330 |
| 79 |
DISTRIBUTION_CHANNEL_LEVEL5 |
CHARACTER VARYING(100) |
100 |
| 80 |
DISTRIBUTION_CHANNEL_LEVEL5_ID |
CHARACTER VARYING(430) |
430 |
| 81 |
DISTRIBUTION_CHANNEL_LEVEL6_ID |
CHARACTER(50) |
50 |
| 82 |
DISTRIBUTION_CHANNEL_LEVEL6_NAME |
CHARACTER VARYING(100) |
100 |
| 83 |
DISTRIBUTION_CHANNEL_LEVEL6_KEY |
CHARACTER VARYING(100) |
100 |
| 84 |
DISTRIBUTION_CHANNEL_LEVEL6_ORDER_KEY |
CHARACTER VARYING(530) |
530 |
| 85 |
DISTRIBUTION_CHANNEL_LEVEL1_SOS_ID |
CHARACTER(1) |
1 |
| 86 |
DISTRIBUTION_CHANNEL_LEVEL1_SOS_NAME |
CHARACTER VARYING(100) |
100 |
| 87 |
DISTRIBUTION_CHANNEL_LEVEL1_NAME_ORDER_SOS_KEY |
CHARACTER VARYING(100) |
100 |
| 88 |
DISTRIBUTION_CHANNEL_SOS_LEVEL2 |
CHARACTER VARYING(30) |
30 |
| 89 |
DISTRIBUTION_CHANNEL_LEVEL2_SOS_ID |
CHARACTER VARYING(130) |
130 |
| 90 |
DISTRIBUTION_CHANNEL_SOS_LEVEL3 |
CHARACTER VARYING(100) |
100 |
| 91 |
DISTRIBUTION_CHANNEL_LEVEL3_SOS_ID |
CHARACTER VARYING(230) |
230 |
| 92 |
DISTRIBUTION_CHANNEL_SOS_LEVEL4 |
CHARACTER VARYING(100) |
100 |
| 93 |
DISTRIBUTION_CHANNEL_LEVEL4_SOS_ID |
CHARACTER VARYING(330) |
330 |
| 94 |
DISTRIBUTION_CHANNEL_SOS_LEVEL5 |
CHARACTER VARYING(100) |
100 |
| 95 |
DISTRIBUTION_CHANNEL_LEVEL5_SOS_ID |
CHARACTER VARYING(430) |
430 |
| 96 |
DISTRIBUTION_CHANNEL_LEVEL6_SOS_ID |
CHARACTER(50) |
50 |
| 97 |
DISTRIBUTION_CHANNEL_LEVEL6_SOS_NAME |
CHARACTER VARYING(100) |
100 |
| 98 |
DISTRIBUTION_CHANNEL_LEVEL6_SOS_KEY |
CHARACTER VARYING(100) |
100 |
| 99 |
DISTRIBUTION_CHANNEL_LEVEL6_ORDER_SOS_KEY |
CHARACTER VARYING(530) |
530 |
| 100 |
EFFECTIVE_DATE_KEY |
INTEGER |
4 |
| 101 |
EQUALISED_BASIC_PREMIUM |
NUMERIC(12,2) |
19 |
| 102 |
EQUALISED_INFORCE_PREMIUM |
NUMERIC(12,2) |
19 |
| 103 |
EQUALISED_TOTAL_PAID_POLICY_PREMIUM |
NUMERIC(12,2) |
19 |
| 104 |
EQUALISED_TRANSACTION_PREMIUM |
NUMERIC(12,2) |
19 |
| 105 |
ESTREG |
CHARACTER(1) |
1 |
| 106 |
ESTREG_KEY |
INTEGER |
4 |
| 107 |
ESTREG_DESC |
CHARACTER VARYING(50) |
50 |
| 108 |
EXCESS_IMPOSED |
CHARACTER VARYING(15) |
15 |
| 109 |
EXCESS_IMPOSED_KEY |
INTEGER |
4 |
| 110 |
EXCESS_VOLUNTARY |
CHARACTER VARYING(15) |
15 |
| 111 |
EXCESS_VOLUNTARY_KEY |
INTEGER |
4 |
| 112 |
EXCESS_STANDARD |
CHARACTER VARYING(15) |
15 |
| 113 |
EXCESS_STANDARD_KEY |
INTEGER |
4 |
| 114 |
FINANCIAL_IMPACT |
CHARACTER VARYING(3) |
3 |
| 115 |
FLEET_BAND |
CHARACTER VARYING(15) |
15 |
| 116 |
FLEET_BAND_KEY |
INTEGER |
4 |
| 117 |
FLEET_SIZE |
INTEGER |
4 |
| 118 |
FLEET_TYPE_NAME |
CHARACTER(3) |
3 |
| 119 |
FLEETCLT_COMMON_DUE_DATE |
INTEGER |
4 |
| 120 |
FLEET_CUSTOMER_ROLE_LEVEL1 |
CHARACTER VARYING(255) |
255 |
| 121 |
FLEET_CUSTOMER_ROLE_LEVEL2 |
CHARACTER VARYING(103) |
103 |
| 122 |
FLEET_CUSTOMER_ROLE_LEVEL3 |
CHARACTER VARYING(100) |
100 |
| 123 |
CRN_PRIMARY |
CHARACTER(15) |
15 |
| 124 |
CLIENT_NAME_PRIM |
CHARACTER VARYING(81) |
81 |
| 125 |
CRN_SECONDARY |
CHARACTER(15) |
15 |
| 126 |
CLIENT_NAME_SCND |
CHARACTER VARYING(81) |
81 |
| 127 |
CRN_REGD_OPTR |
CHARACTER(15) |
15 |
| 128 |
CLIENT_NAME_REGD_OPTR |
CHARACTER VARYING(81) |
81 |
| 129 |
CRN_PAY_AGENT |
CHARACTER(15) |
15 |
| 130 |
CLIENT_NAME_PAY_AGENT |
CHARACTER VARYING(81) |
81 |
| 131 |
CRN_CLIENT |
CHARACTER(15) |
15 |
| 132 |
FUTURE_ITCE_STATUS |
CHARACTER(1) |
1 |
| 133 |
GENDER |
CHARACTER(1) |
1 |
| 134 |
GENDER_NAME |
CHARACTER VARYING(9) |
9 |
| 135 |
GROSS_FULL_TERM_PAID_POLICY_COUNT |
INTEGER |
4 |
| 136 |
GROSS_FULL_TERM_PAID_POLICY_PREMIUM |
NUMERIC(11,2) |
19 |
| 137 |
GROSS_FULL_TERM_POLICY_COUNT |
INTEGER |
4 |
| 138 |
GROSS_FULL_TERM_POLICY_PREMIUM |
NUMERIC(11,2) |
19 |
| 139 |
GROSS_PREMIUM |
NUMERIC(11,2) |
19 |
| 140 |
GROSS_VEHICLE_MASS_OVER_4_5_TON |
CHARACTER(1) |
1 |
| 141 |
GST |
NUMERIC(12,2) |
19 |
| 142 |
INFORCE_PREMIUM |
NUMERIC(11,2) |
19 |
| 143 |
INSURANCE_RATING_CODE |
CHARACTER VARYING(2000) |
2000 |
| 144 |
ISSUED_CERTIFICATE_COUNT |
INTEGER |
4 |
| 145 |
ISSUED_CERTIFICATE_PREMIUM |
NUMERIC(12,2) |
19 |
| 146 |
ISSUED_POLICY_COUNT |
INTEGER |
4 |
| 147 |
ISSUED_POLICY_STATUS |
CHARACTER VARYING(28) |
28 |
| 148 |
ISSUED_POLICY_PREMIUM |
NUMERIC(11,2) |
19 |
| 149 |
ISSUED_QUOTE_COUNT |
INTEGER |
4 |
| 150 |
ISSUED_QUOTE_PREMIUM |
NUMERIC(11,2) |
19 |
| 151 |
ITCE_STATUS |
CHARACTER(1) |
1 |
| 152 |
ITCE_STATUS_KEY |
CHARACTER(2) |
2 |
| 153 |
ITCE_STATUS_NAME |
CHARACTER VARYING(64) |
64 |
| 154 |
ITEM_CBASICPRM |
NUMERIC(12,2) |
19 |
| 155 |
ITEM_CCHARGES |
NUMERIC(12,2) |
19 |
| 156 |
ITEM_CCOMMISN |
NUMERIC(12,2) |
19 |
| 157 |
ITEM_CCOMMGST |
NUMERIC(12,2) |
19 |
| 158 |
ITEM_CGST |
NUMERIC(12,2) |
19 |
| 159 |
ITEM_CSTMPDUTY |
NUMERIC(12,2) |
19 |
| 160 |
ITEM_RBASICPRM |
NUMERIC(12,2) |
19 |
| 161 |
ITEM_RCHARGES |
NUMERIC(12,2) |
19 |
| 162 |
ITEM_RCOMMISN |
NUMERIC(12,2) |
19 |
| 163 |
ITEM_RCOMMGST |
NUMERIC(12,2) |
19 |
| 164 |
ITEM_RGST |
NUMERIC(12,2) |
19 |
| 165 |
ITEM_RSTMPDUTY |
NUMERIC(12,2) |
19 |
| 166 |
ITEM_TBASICPRM |
NUMERIC(12,2) |
19 |
| 167 |
ITEM_TCHARGES |
NUMERIC(12,2) |
19 |
| 168 |
ITEM_TCOMMISN |
NUMERIC(12,2) |
19 |
| 169 |
ITEM_TGST |
NUMERIC(12,2) |
19 |
| 170 |
ITEM_TCOMMGST |
NUMERIC(12,2) |
19 |
| 171 |
ITEM_TSTMPDUTY |
NUMERIC(12,2) |
19 |
| 172 |
ITEMPREM_A_BASEPREM |
NUMERIC(38,6) |
19 |
| 173 |
ITEMPREM_A_BONUSMALUS |
NUMERIC(38,6) |
19 |
| 174 |
ITEMPREM_A_CANCEL_FEE |
NUMERIC(38,6) |
19 |
| 175 |
ITEMPREM_A_GST |
NUMERIC(38,6) |
19 |
| 176 |
ITEMPREM_A_ITC |
NUMERIC(38,6) |
19 |
| 177 |
ITEMPREM_A_OVERRIDE |
NUMERIC(38,6) |
19 |
| 178 |
ITEMPREM_A_RISKPREM |
NUMERIC(38,6) |
19 |
| 179 |
ITEMPREM_A_RETAILPREM |
NUMERIC(38,6) |
19 |
| 180 |
ITEMPREM_A_SHORTTERM |
NUMERIC(38,6) |
19 |
| 181 |
ITEMPREM_A_MAALEVY |
NUMERIC(38,6) |
19 |
| 182 |
ITEMPREM_A_MAITCLEVY |
NUMERIC(38,6) |
19 |
| 183 |
ITEMPREM_A_NOMLLEVY |
NUMERIC(38,6) |
19 |
| 184 |
ITEMPREM_A_LTCSLEVY |
NUMERIC(38,6) |
19 |
| 185 |
ITEMPREM_D_BASEPREM |
NUMERIC(38,6) |
19 |
| 186 |
ITEMPREM_D_BONUSMALUS |
NUMERIC(38,6) |
19 |
| 187 |
ITEMPREM_D_CANCEL_FEE |
NUMERIC(38,6) |
19 |
| 188 |
ITEMPREM_D_GST |
NUMERIC(38,6) |
19 |
| 189 |
ITEMPREM_D_ITC |
NUMERIC(38,6) |
19 |
| 190 |
ITEMPREM_D_OVERRIDE |
NUMERIC(38,6) |
19 |
| 191 |
ITEMPREM_D_RISKPREM |
NUMERIC(38,6) |
19 |
| 192 |
ITEMPREM_D_RETAILPREM |
NUMERIC(38,6) |
19 |
| 193 |
ITEMPREM_D_SHORTTERM |
NUMERIC(38,6) |
19 |
| 194 |
ITEMPREM_D_MAALEVY |
NUMERIC(38,6) |
19 |
| 195 |
ITEMPREM_D_MAITCLEVY |
NUMERIC(38,6) |
19 |
| 196 |
ITEMPREM_D_NOMLLEVY |
NUMERIC(38,6) |
19 |
| 197 |
ITEMPREM_D_LTCSLEVY |
NUMERIC(38,6) |
19 |
| 198 |
ITEMPREM_T_BASEPREM |
NUMERIC(38,6) |
19 |
| 199 |
ITEMPREM_T_BONUSMALUS |
NUMERIC(38,6) |
19 |
| 200 |
ITEMPREM_T_CANCEL_FEE |
NUMERIC(38,6) |
19 |
| 201 |
ITEMPREM_T_GST |
NUMERIC(38,6) |
19 |
| 202 |
ITEMPREM_T_ITC |
NUMERIC(38,6) |
19 |
| 203 |
ITEMPREM_T_OVERRIDE |
NUMERIC(38,6) |
19 |
| 204 |
ITEMPREM_T_RISKPREM |
NUMERIC(38,6) |
19 |
| 205 |
ITEMPREM_T_RETAILPREM |
NUMERIC(38,6) |
19 |
| 206 |
ITEMPREM_T_SHORTTERM |
NUMERIC(38,6) |
19 |
| 207 |
ITEMPREM_T_MAALEVY |
NUMERIC(38,6) |
19 |
| 208 |
ITEMPREM_T_MAITCLEVY |
NUMERIC(38,6) |
19 |
| 209 |
ITEMPREM_T_NOMLLEVY |
NUMERIC(38,6) |
19 |
| 210 |
ITEMPREM_T_LTCSLEVY |
NUMERIC(38,6) |
19 |
| 211 |
ITEM_NUMBER |
INTEGER |
4 |
| 212 |
ITEM_RISK_TAILOR_GROUP |
CHARACTER VARYING(2000) |
2000 |
| 213 |
LICENCE_CANCELLATION_COUNT |
SMALLINT |
2 |
| 214 |
LICENCE_CANCELLATION_COUNT_KEY |
SMALLINT |
2 |
| 215 |
LICENCE_CANCELLATION_COUNT_NAME |
CHARACTER VARYING(10) |
10 |
| 216 |
LICENCE_CANCELLATION_YESNO |
CHARACTER VARYING(60) |
60 |
| 217 |
LICENCE_DEMERIT_POINTS |
SMALLINT |
2 |
| 218 |
LICENCE_DEMERIT_POINTS_KEY |
SMALLINT |
2 |
| 219 |
LICENCE_DEMERIT_POINTS_NAME |
CHARACTER VARYING(10) |
10 |
| 220 |
LOADED_ISSUED_POLICY_COUNT |
INTEGER |
4 |
| 221 |
LOADED_ISSUED_QUOTE_COUNT |
INTEGER |
4 |
| 222 |
LOADED_PAID_POLICY_COUNT |
INTEGER |
4 |
| 223 |
LOADED_TRANSACTION_COUNT |
INTEGER |
4 |
| 224 |
LTCS_LEVY |
NUMERIC(12,2) |
19 |
| 225 |
LURN_ADDRESS |
CHARACTER(38) |
38 |
| 226 |
LURN_SCALE |
CHARACTER(1) |
1 |
| 227 |
MAA_LEVY |
NUMERIC(12,2) |
19 |
| 228 |
MAITC_LEVY |
NUMERIC(12,2) |
19 |
| 229 |
MANAGED_FLEETS_LEVEL1_NAME |
CHARACTER VARYING(17) |
17 |
| 230 |
MANAGED_FLEETS_LEVEL1_NAME_KEY |
INTEGER |
4 |
| 231 |
MANAGED_FLEETS_LEVEL2_NAME |
CHARACTER VARYING(80) |
80 |
| 232 |
MANAGED_FLEETS_LEVEL2_NAME_KEY |
INTEGER |
4 |
| 233 |
MANAGED_FLEETS_LEVEL3_NAME |
CHARACTER VARYING(101) |
101 |
| 234 |
MANAGED_FLEETS_LEVEL3_NAME_KEY |
INTEGER |
4 |
| 235 |
MCIS |
NUMERIC(12,2) |
19 |
| 236 |
MOTOR_DEALER_STOCK_NUMBER |
CHARACTER(12) |
12 |
| 237 |
MOTOR_INSURANCE_TYPE |
CHARACTER(1) |
1 |
| 238 |
MOTOR_INSURANCE_TYPE_NAME |
CHARACTER VARYING(60) |
60 |
| 239 |
MOTOR_INSURANCE_YEARS |
INTEGER |
4 |
| 240 |
MOTOR_INSURANCE_YEARS_NAME |
CHARACTER VARYING(9) |
9 |
| 241 |
MOTOR_INSURER |
CHARACTER VARYING(4) |
4 |
| 242 |
MOTOR_INSURER_NAME |
CHARACTER VARYING(60) |
60 |
| 243 |
MOTOR_INSURER_NAME_KEY |
CHARACTER VARYING(60) |
60 |
| 244 |
MOTOR_INSURER_GROUP |
CHARACTER VARYING(60) |
60 |
| 245 |
MOTOR_INSURER_GROUP_KEY |
INTEGER |
4 |
| 246 |
MOTOR_POLICY_DUE_MONTH |
INTEGER |
4 |
| 247 |
MOTOR_POLICY_NUMBER |
CHARACTER(12) |
12 |
| 248 |
MOTOR_VEHICLE_CATEGORY |
CHARACTER(2) |
2 |
| 249 |
MOTOR_VEHICLE_CURRENTLY_REGISTERED_IN_CTP_STATE |
CHARACTER(1) |
1 |
| 250 |
MOTOR_VEHICLE_CYLINDERS_OR_ROTARY_INDICATOR |
CHARACTER(1) |
1 |
| 251 |
MOTOR_VEHICLE_ENGINE_CAPACITY |
INTEGER |
4 |
| 252 |
MOTOR_VEHICLE_ENGINE_NUMBER |
CHARACTER(30) |
30 |
| 253 |
MOTOR_VEHICLE_FUEL_TYPE |
CHARACTER(4) |
4 |
| 254 |
MOTOR_VEHICLE_GROSS_COMBINED_MASS_WEIGHT |
INTEGER |
4 |
| 255 |
MOTOR_VEHICLE_GROSS_VEHICLE_MASS_WEIGHT |
INTEGER |
4 |
| 256 |
MOTOR_VEHICLE_MAKE |
CHARACTER(6) |
6 |
| 257 |
MOTOR_VEHICLE_MODEL |
CHARACTER VARYING(2000) |
2000 |
| 258 |
MOTOR_VEHICLE_MODEL_VARIANT |
CHARACTER(10) |
10 |
| 259 |
MOTOR_VEHICLE_MONTH_OF_MANUFACTURER |
INTEGER |
4 |
| 260 |
MOTOR_VEHICLE_NUMBER_OF_CYLINDERS |
INTEGER |
4 |
| 261 |
MOTOR_VEHICLE_NUMBER_OF_DOORS |
INTEGER |
4 |
| 262 |
MOTOR_VEHICLE_NUMBER_OF_GEARS |
INTEGER |
4 |
| 263 |
MOTOR_VEHICLE_NUMBER_OF_SEATS |
INTEGER |
4 |
| 264 |
MOTOR_VEHICLE_NUMBER_TRANSMISSION_TYPE |
CHARACTER(1) |
1 |
| 265 |
MOTOR_VEHICLE_PLATE_TYPE |
CHARACTER(1) |
1 |
| 266 |
MOTOR_VEHICLE_PRIMARY_COLOUR_CODE |
CHARACTER(4) |
4 |
| 267 |
MOTOR_VEHICLE_PRIVATE_OR_BUSINESS_USE |
CHARACTER(1) |
1 |
| 268 |
MOTOR_VEHICLE_REGO_NO |
CHARACTER VARYING(2000) |
2000 |
| 269 |
MOTOR_VEHICLE_SECONDARY_COLOUR_CODE |
CHARACTER(4) |
4 |
| 270 |
MOTOR_VEHICLE_SHAPE |
CHARACTER(4) |
4 |
| 271 |
MOTOR_VEHICLE_TARE_WEIGHT |
INTEGER |
4 |
| 272 |
MOTOR_VEHICLE_TYPE |
CHARACTER(4) |
4 |
| 273 |
NET_FULL_TERM_PAID_POLICY_COUNT |
INTEGER |
4 |
| 274 |
NET_FULL_TERM_PAID_POLICY_PREMIUM |
NUMERIC(11,2) |
19 |
| 275 |
NET_FULL_TERM_POLICY_COUNT |
INTEGER |
4 |
| 276 |
NET_FULL_TERM_POLICY_PREMIUM |
NUMERIC(11,2) |
19 |
| 277 |
NET_PREMIUM |
NUMERIC(11,2) |
19 |
| 278 |
NET_RENEWAL_COUNT |
INTEGER |
4 |
| 279 |
NEXT_RENEWAL_TERM |
CHARACTER(1) |
1 |
| 280 |
NO_CLAIM_BONUS_INDICATOR |
CHARACTER(1) |
1 |
| 281 |
NO_CLAIM_BONUS_PERCENTAGE |
INTEGER |
4 |
| 282 |
NOMINATION_STAGE_CREATED_COUNT |
INTEGER |
4 |
| 283 |
NOMINATION_STAGE_BATCHED_COUNT |
INTEGER |
4 |
| 284 |
NOMINATION_STAGE_REJECTED_COUNT |
INTEGER |
4 |
| 285 |
NOMINATION_STAGE_VALIDATED_COUNT |
INTEGER |
4 |
| 286 |
NOMINATION_STAGE_LEVEL1 |
CHARACTER VARYING(20) |
20 |
| 287 |
NOMINATION_STAGE_LEVEL1_KEY |
CHARACTER VARYING(4) |
4 |
| 288 |
NOML_LEVY |
NUMERIC(12,2) |
19 |
| 289 |
NON_MANAGED_FLEETS_LEVEL1_NAME |
CHARACTER VARYING(121) |
121 |
| 290 |
NUMBER_OF_TRAFFIC_INFRINGEMENTS |
INTEGER |
4 |
| 291 |
NVIC |
CHARACTER(6) |
6 |
| 292 |
OWNER_AGE |
INTEGER |
4 |
| 293 |
OWNER_AGE_BAND |
CHARACTER VARYING(12) |
12 |
| 294 |
OWNER_AGE_BAND_KEY |
INTEGER |
4 |
| 295 |
OWNER_AGE_KEY |
INTEGER |
4 |
| 296 |
OWNER_AGE_NAME |
CHARACTER VARYING(10) |
10 |
| 297 |
OWNER_DOB |
INTEGER |
4 |
| 298 |
OWNER_TYPE |
CHARACTER(1) |
1 |
| 299 |
OPPORTUNITY_ID |
CHARACTER(52) |
52 |
| 300 |
OPPORTUNITY_ID_DESCRIPTION |
CHARACTER VARYING(255) |
255 |
| 301 |
ORIGINAL_TRANSACTION_TYPE |
CHARACTER(2) |
2 |
| 302 |
ORIGINATING_CHANNEL_ID |
CHARACTER(1) |
1 |
| 303 |
ORIGINATING_CHANNEL_NAME |
CHARACTER VARYING(100) |
100 |
| 304 |
ORIGINATING_CHANNEL_NAME_ORDER_KEY |
CHARACTER VARYING(2) |
2 |
| 305 |
ORIGINATING_CHANNEL_USERID |
CHARACTER(9) |
9 |
| 306 |
ORIGINATING_CHANNEL_USERNAME |
CHARACTER VARYING(100) |
100 |
| 307 |
ORIGINATING_CHANNEL_USERNAME_ORDER_KEY |
CHARACTER VARYING(201) |
201 |
| 308 |
ORIGINATING_CHANNEL_LEVEL1_ID |
CHARACTER(1) |
1 |
| 309 |
ORIGINATING_CHANNEL_LEVEL1_NAME |
CHARACTER VARYING(100) |
100 |
| 310 |
ORIGINATING_CHANNEL_LEVEL1_NAME_ORDER_KEY |
CHARACTER VARYING(100) |
100 |
| 311 |
ORIGINATING_CHANNEL_LEVEL2 |
CHARACTER VARYING(30) |
30 |
| 312 |
ORIGINATING_CHANNEL_LEVEL2_ID |
CHARACTER VARYING(130) |
130 |
| 313 |
ORIGINATING_CHANNEL_LEVEL3 |
CHARACTER VARYING(100) |
100 |
| 314 |
ORIGINATING_CHANNEL_LEVEL3_ID |
CHARACTER VARYING(230) |
230 |
| 315 |
ORIGINATING_CHANNEL_LEVEL4 |
CHARACTER VARYING(100) |
100 |
| 316 |
ORIGINATING_CHANNEL_LEVEL4_ID |
CHARACTER VARYING(330) |
330 |
| 317 |
ORIGINATING_CHANNEL_LEVEL5 |
CHARACTER VARYING(100) |
100 |
| 318 |
ORIGINATING_CHANNEL_LEVEL5_ID |
CHARACTER VARYING(430) |
430 |
| 319 |
ORIGINATING_CHANNEL_LEVEL6_ID |
CHARACTER(9) |
9 |
| 320 |
ORIGINATING_CHANNEL_LEVEL6_NAME |
CHARACTER VARYING(100) |
100 |
| 321 |
ORIGINATING_CHANNEL_LEVEL6_KEY |
CHARACTER VARYING(100) |
100 |
| 322 |
ORIGINATING_CHANNEL_LEVEL6_ORDER_KEY |
CHARACTER VARYING(530) |
530 |
| 323 |
PAID_ATRNTYPE |
CHARACTER VARYING(2) |
2 |
| 324 |
PAID_TRANSACTION_BASICAMT |
NUMERIC(12,2) |
19 |
| 325 |
PAID_TRANSACTION_COMMISSION |
NUMERIC(12,2) |
19 |
| 326 |
PAID_TRANSACTION_COMMISSION_GST |
NUMERIC(12,2) |
19 |
| 327 |
PAID_TRANSACTION_COMMISSION_TOTAL |
NUMERIC(12,2) |
19 |
| 328 |
PAID_TRANSACTION_NET_PREMIUM |
NUMERIC(11,2) |
19 |
| 329 |
PAYMENT_CARDTYPE_KEY |
CHARACTER VARYING(2) |
2 |
| 330 |
PAYMENT_CARDTYPE |
CHARACTER VARYING(255) |
255 |
| 331 |
PAYMENT_CHANNEL |
CHARACTER VARYING(20) |
20 |
| 332 |
PAYMENT_DATE |
CHARACTER VARYING(10) |
10 |
| 333 |
PAYMENT_METHOD |
CHARACTER VARYING(1) |
1 |
| 334 |
PAYMENT_METHOD_NAME |
CHARACTER VARYING(255) |
255 |
| 335 |
PAYMENT_USERID |
CHARACTER VARYING(20) |
20 |
| 336 |
PAYMENT_ACT_USER_FULL_NAME |
CHARACTER VARYING(1025) |
1025 |
| 337 |
PAYMENT_ACT_USER_DEPARTMENT |
CHARACTER VARYING(512) |
512 |
| 338 |
PAYMENT_ACT_USER_PHYSICALDELIVERYOFFICENAME |
CHARACTER VARYING(512) |
512 |
| 339 |
PAYMENT_ACT_USER_TITLE |
CHARACTER VARYING(512) |
512 |
| 340 |
PAYMENT_ACT_USER_DESCRIPTION |
CHARACTER VARYING(512) |
512 |
| 341 |
PILLION_PASSENGER |
CHARACTER(1) |
1 |
| 342 |
PILLION_PASSENGER_NAME |
CHARACTER VARYING(9) |
9 |
| 343 |
PILLION_PASSENGER_ORDER_KEY |
INTEGER |
4 |
| 344 |
POLICY |
INTEGER |
4 |
| 345 |
POLICY_CVN |
INTEGER |
4 |
| 346 |
POLICY_POL |
INTEGER |
4 |
| 347 |
POLICY_DUE_DATE_KEY |
INTEGER |
4 |
| 348 |
POLICY_DURATION_BAND |
CHARACTER VARYING(12) |
12 |
| 349 |
POLICY_DURATION_YEAR |
INTEGER |
4 |
| 350 |
POLICY_EXPIRING_COUNT |
INTEGER |
4 |
| 351 |
POLICY_INCEPTION_DATE |
CHARACTER VARYING(18) |
18 |
| 352 |
POLICY_INCEPTION_DATE_KEY |
INTEGER |
4 |
| 353 |
POLICY_NUMBER |
CHARACTER VARYING(2000) |
2000 |
| 354 |
POLICY_STAGE_LEVEL1 |
CHARACTER VARYING(20) |
20 |
| 355 |
POLICY_STAGE_LEVEL1_KEY |
INTEGER |
4 |
| 356 |
POLICY_STAGE_LEVEL2 |
CHARACTER VARYING(2000) |
2000 |
| 357 |
POLICY_STAGE_LEVEL2_KEY |
INTEGER |
4 |
| 358 |
POLICY_STAGE_LEVEL3 |
CHARACTER VARYING(31) |
31 |
| 359 |
POLICY_STAGE_LEVEL3_KEY |
INTEGER |
4 |
| 360 |
POLICY_STATE_ISSUED |
CHARACTER(2) |
2 |
| 361 |
POLICY_STATUS |
CHARACTER VARYING(2000) |
2000 |
| 362 |
POLICY_STATUS_CVN |
CHARACTER VARYING(2000) |
2000 |
| 363 |
POLICY_TERM |
INTEGER |
4 |
| 364 |
POLICY_TERMSTART |
CHARACTER VARYING(10) |
10 |
| 365 |
POLICY_TERM_NAME |
CHARACTER VARYING(10) |
10 |
| 366 |
POLICY_TERM_UNITS |
CHARACTER(1) |
1 |
| 367 |
PREMIUM_RESPONSIBILITY_CODE |
CHARACTER(2) |
2 |
| 368 |
PREMIUM_RESPONSIBILITY_NAME |
CHARACTER VARYING(510) |
510 |
| 369 |
PREMIUM_TIERS |
CHARACTER VARYING(9) |
9 |
| 370 |
PREMIUM_TIERS_KEY |
INTEGER |
4 |
| 371 |
PREMIUM_TIERS_PERCENTAGE |
NUMERIC(38,6) |
19 |
| 372 |
PREMIUM_TIERS_PERCENTAGE_NAME |
CHARACTER VARYING(10) |
10 |
| 373 |
PREVIOUS_INSURER_POLICY_NUMBER |
CHARACTER(14) |
14 |
| 374 |
PREVIOUS_INSURER |
CHARACTER(4) |
4 |
| 375 |
PREVIOUS_INSURER_DUE_DATE |
INTEGER |
4 |
| 376 |
PREVIOUS_INSURER_NAME |
CHARACTER VARYING(255) |
255 |
| 377 |
PREVIOUS_POLICY_NUMBER |
BIGINT |
8 |
| 378 |
PRIORCLM |
CHARACTER VARYING(10) |
10 |
| 379 |
PRO_RATA_FLAG |
CHARACTER(1) |
1 |
| 380 |
PRODUCT |
CHARACTER(3) |
3 |
| 381 |
PROD_TYPE_DESC |
CHARACTER VARYING(60) |
60 |
| 382 |
PROD_CLASS_DESC |
CHARACTER VARYING(60) |
60 |
| 383 |
PRODUCT_STRUCT1 |
CHARACTER VARYING(50) |
50 |
| 384 |
PRODUCT_STRUCT2 |
CHARACTER VARYING(50) |
50 |
| 385 |
PRODUCT_STRUCT3 |
CHARACTER VARYING(50) |
50 |
| 386 |
PRODUCT_STRUCT4 |
CHARACTER VARYING(50) |
50 |
| 387 |
PRODUCT_STRUCT5 |
CHARACTER VARYING(50) |
50 |
| 388 |
PRODUCT_STRUCT6 |
CHARACTER VARYING(50) |
50 |
| 389 |
POLICY_TERM_UNITS_NAME |
CHARACTER VARYING(15) |
15 |
| 390 |
QUOTE_CREATION_DATE_KEY |
INTEGER |
4 |
| 391 |
QUOTE_LATEST_AMEND_DATE_KEY |
INTEGER |
4 |
| 392 |
QUOTE_STATUS |
CHARACTER VARYING(28) |
28 |
| 393 |
REALTIMEPAY_TRANSACTION_TYPE_CVN |
CHARACTER(4) |
4 |
| 394 |
REALTIMEPAY_TRANSACTION_DATE_CVN |
INTEGER |
4 |
| 395 |
REALTIMEPAY_TRANSACTION_TIME_CVN |
INTEGER |
4 |
| 396 |
RED_GREEN_INDICATOR |
CHARACTER VARYING(10) |
10 |
| 397 |
RED_GREEN_INDICATOR_KEY |
INTEGER |
4 |
| 398 |
RED_GREEN_REFDATA_PERCENT |
NUMERIC(12,2) |
19 |
| 399 |
REGISTRATION_CONDITIONS |
CHARACTER(1) |
1 |
| 400 |
REGISTRATION_END_DATE |
CHARACTER VARYING(10) |
10 |
| 401 |
REGISTRATION_STATUS |
CHARACTER VARYING(10) |
10 |
| 402 |
REGISTRATION_TYPE |
CHARACTER VARYING(2000) |
2000 |
| 403 |
REM_FLAG |
CHARACTER(1) |
1 |
| 404 |
REM_PREMIUM_ADJUSTMENT_AMOUNT |
NUMERIC(11,2) |
19 |
| 405 |
REM_TOTAL_PAID_POLICY_PREMIUM_ADJUSTMENT_AMOUNT |
NUMERIC(11,2) |
19 |
| 406 |
REM_TRANSACTION_PREMIUM_ADJUSTMENT_AMOUNT |
NUMERIC(11,2) |
19 |
| 407 |
RENEWAL_TERM |
INTEGER |
4 |
| 408 |
RENEWAL_TERM_LABEL |
CHARACTER VARYING(13) |
13 |
| 409 |
RENEWAL_TERM_KEY |
INTEGER |
4 |
| 410 |
RENEWAL_TERM_LEVEL2_LABEL |
CHARACTER VARYING(18) |
18 |
| 411 |
RENEWAL_TERM_LEVEL2_KEY |
INTEGER |
4 |
| 412 |
REP |
INTEGER |
4 |
| 413 |
REVERSAL_TIMESTAMP |
TIMESTAMP |
8 |
| 414 |
RIDESHARE_INDICATOR |
CHARACTER VARYING(3) |
3 |
| 415 |
RIDESHARE_PREMIUM |
NUMERIC(12,2) |
19 |
| 416 |
RIDESHARE_KMS |
NUMERIC(12,2) |
19 |
| 417 |
RIDESHARE_OPERATOR_ID |
CHARACTER VARYING(3) |
3 |
| 418 |
RIDESHARE_OPERATOR |
CHARACTER VARYING(250) |
250 |
| 419 |
RIDESHARE_TRAN_COUNT |
INTEGER |
4 |
| 420 |
RISK_PERCENTAGE |
NUMERIC(12,2) |
19 |
| 421 |
RISK_POSTCODE |
NUMERIC(6,0) |
19 |
| 422 |
RISK_POSTCODE_NAME |
CHARACTER VARYING(10) |
10 |
| 423 |
RISK_REGION |
CHARACTER(2) |
2 |
| 424 |
RISK_REGION_NAME |
CHARACTER VARYING(100) |
100 |
| 425 |
RISK_SUBURB |
CHARACTER VARYING(40) |
40 |
| 426 |
RMS_CODE |
CHARACTER VARYING(10) |
10 |
| 427 |
RMS_ORDER_KEY1 |
CHARACTER VARYING(8) |
8 |
| 428 |
RMS_ORDER_KEY2 |
CHARACTER VARYING(4) |
4 |
| 429 |
RTA_QT_REGISTRATION_ID |
NUMERIC(10,0) |
19 |
| 430 |
RTA_QT_VEHICLE_ID |
NUMERIC(15,0) |
19 |
| 431 |
SCHEME_VEHICLE_CLASS_REFNO |
SMALLINT |
2 |
| 432 |
SCHEME_LICENCE_STATE |
CHARACTER VARYING(30) |
30 |
| 433 |
SCHEME_VEHICLE_CLASS |
CHARACTER(4) |
4 |
| 434 |
SCHEME_VEHICLE_CLASS_KEY |
CHARACTER VARYING(60) |
60 |
| 435 |
SCHEME_VEHICLE_CLASS_LEVEL2 |
CHARACTER VARYING(67) |
67 |
| 436 |
SCHEME_VEHICLE_CLASS_ORDER_KEY_1 |
INTEGER |
4 |
| 437 |
SCHEME_VEHICLE_CLASS_ORDER_KEY_2 |
CHARACTER VARYING(10) |
10 |
| 438 |
SHORT_PAID_PREMIUM |
CHARACTER VARYING(9) |
9 |
| 439 |
SOURCE_AGENT |
INTEGER |
4 |
| 440 |
STAMP_DATE |
CHARACTER VARYING(10) |
10 |
| 441 |
STAMP_DUTY |
NUMERIC(12,2) |
19 |
| 442 |
STATEMENT_DATE_DATE_KEY |
INTEGER |
4 |
| 443 |
SUPPLIER_ADDRESS |
CHARACTER VARYING(100) |
100 |
| 444 |
SUPPLIER_ADDRESS_LINE2 |
CHARACTER VARYING(100) |
100 |
| 445 |
TOTAL_CHARGES |
INTEGER |
4 |
| 446 |
TOTAL_MID_TERM_COUNT |
INTEGER |
4 |
| 447 |
TOTAL_MID_TERM_PREMIUM |
NUMERIC(11,2) |
19 |
| 448 |
TOTAL_PAID_POLICY_COUNT |
INTEGER |
4 |
| 449 |
TOTAL_PAID_POLICY_PREMIUM |
NUMERIC(11,2) |
19 |
| 450 |
TOTAL_POLICY_COUNT |
INTEGER |
4 |
| 451 |
TOTAL_POLICY_PREMIUM |
NUMERIC(11,2) |
19 |
| 452 |
TRANCNT |
INTEGER |
4 |
| 453 |
TRANSACTION_DATE_KEY |
INTEGER |
4 |
| 454 |
TRANSACTION_ACCOUNTING_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 455 |
TRANSACTION_WEEK_ENDING |
CHARACTER VARYING(13) |
13 |
| 456 |
TRANSACTION_ACCOUNTING_MONTH_KEY |
INTEGER |
4 |
| 457 |
TRANSACTION_ACCOUNTING_MONTH_LABEL |
CHARACTER VARYING(15) |
15 |
| 458 |
TRANSACTION_COUNT |
INTEGER |
4 |
| 459 |
TRANSACTION_PREMIUM |
NUMERIC(11,2) |
19 |
| 460 |
TRANSACTION_TIME |
INTEGER |
4 |
| 461 |
TRANSACTION_TYPE |
CHARACTER(50) |
50 |
| 462 |
TRANSACTION_TYPE_NAME |
CHARACTER VARYING(100) |
100 |
| 463 |
TRANSACTION_TYPE_KEY |
INTEGER |
4 |
| 464 |
TRANSFER_DATE |
CHARACTER VARYING(10) |
10 |
| 465 |
TYPE_OF_COMMISSION |
CHARACTER VARYING(12) |
12 |
| 466 |
UNPAID_TRANSACTION_BACISAMT |
NUMERIC(12,2) |
19 |
| 467 |
UNPAID_TRANSACTION_COMMISSION |
NUMERIC(12,2) |
19 |
| 468 |
UNPAID_TRANSACTION_COMMISSION_GST |
NUMERIC(12,2) |
19 |
| 469 |
UNPAID_TRANSACTION_COMMISSION_TOTAL |
NUMERIC(12,2) |
19 |
| 470 |
UNPAID_TRANSACTION_MCIS |
NUMERIC(12,2) |
19 |
| 471 |
UNPAID_TRANSACTION_NET_PREMIUM |
NUMERIC(11,2) |
19 |
| 472 |
USE_BY_DATE |
CHARACTER VARYING(10) |
10 |
| 473 |
USER_TRANSACTION_TYPE |
CHARACTER(50) |
50 |
| 474 |
USER_TRANSACTION_TYPE_CVN |
CHARACTER(4) |
4 |
| 475 |
USER_TRANSACTION_TYPE_NAME |
CHARACTER VARYING(100) |
100 |
| 476 |
USER_TRANSACTION_TYPE_KEY |
INTEGER |
4 |
| 477 |
VALID_FROM_DATE |
TIMESTAMP |
8 |
| 478 |
VALID_TO_DATE |
TIMESTAMP |
8 |
| 479 |
VEHICLE_AGE |
CHARACTER VARYING(10) |
10 |
| 480 |
VEHICLE_AGE_BAND |
CHARACTER VARYING(12) |
12 |
| 481 |
VEHICLE_AGE_BAND_KEY |
INTEGER |
4 |
| 482 |
VEHICLE_AGE_KEY |
INTEGER |
4 |
| 483 |
VEHICLE_USAGE |
CHARACTER(4) |
4 |
| 484 |
VEHICLE_USAGE_NAME |
CHARACTER VARYING(60) |
60 |
| 485 |
VIN_CHASSIS_NO |
CHARACTER VARYING(2000) |
2000 |
| 486 |
YEAR_OF_MANUFACTURE |
CHARACTER VARYING(10) |
10 |
| 487 |
YEARLY_KILOMETERS_TRAVELLED |
CHARACTER VARYING(10) |
10 |
| 488 |
YEARLY_KILOMETERS_TRAVELLED_KEY |
CHARACTER VARYING(10) |
10 |
| 489 |
YEARLY_KILOMETERS_TRAVELLED_NAME |
CHARACTER VARYING(25) |
25 |
| 490 |
YEARS_LICENCED |
CHARACTER VARYING(10) |
10 |
| 491 |
YEARS_LICENCED_NAME |
CHARACTER VARYING(10) |
10 |
| 492 |
YEARS_LICENCED_YESNO |
CHARACTER VARYING(60) |
60 |
| 493 |
YOUNGEST_DRIVER_AGE |
INTEGER |
4 |
| 494 |
YOUNGEST_DRIVER_AGE_BAND |
CHARACTER VARYING(12) |
12 |
| 495 |
YOUNGEST_DRIVER_AGE_BAND_KEY |
INTEGER |
4 |
| 496 |
YOUNGEST_DRIVER_AGE_KEY |
INTEGER |
4 |
| 497 |
YOUNGEST_DRIVER_AGE_NAME |
CHARACTER VARYING(10) |
10 |
| 498 |
YOUNGEST_DRIVER_DOB |
CHARACTER VARYING(18) |
18 |
| 499 |
PRINT_INDICATOR |
CHARACTER(1) |
1 |
| 500 |
RISK_LEVEL |
CHARACTER(1) |
1 |
| 501 |
RISK_LEVEL_NAME |
CHARACTER VARYING(12) |
12 |
| 502 |
CHASSIS |
CHARACTER VARYING(20) |
20 |
| 503 |
VIN |
CHARACTER VARYING(17) |
17 |
| 504 |
CTP_TENURE |
INTEGER |
4 |
| 505 |
CTP_TENURE_DESC |
CHARACTER VARYING(20) |
20 |
| 506 |
EFFECTIVE_CAL_YEAR |
INTEGER |
4 |
| 507 |
EFFECTIVE_CAL_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 508 |
EFFECTIVE_CAL_QUARTER |
INTEGER |
4 |
| 509 |
EFFECTIVE_CAL_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 510 |
EFFECTIVE_CAL_MONTH |
INTEGER |
4 |
| 511 |
EFFECTIVE_CAL_MONTH_LABEL |
CHARACTER VARYING(13) |
13 |
| 512 |
EFFECTIVE_CAL_DAY |
INTEGER |
4 |
| 513 |
EFFECTIVE_CAL_DAY_LABEL |
CHARACTER VARYING(13) |
13 |
| 514 |
EFFECTIVE_ACCOUNTING_CALENDAR_YEAR |
INTEGER |
4 |
| 515 |
EFFECTIVE_ACCOUNTING_EOM_DAY |
INTEGER |
4 |
| 516 |
EFFECTIVE_ACCOUNTING_EOQ_DAY |
INTEGER |
4 |
| 517 |
EFFECTIVE_ACCOUNTING_QUARTER |
INTEGER |
4 |
| 518 |
EFFECTIVE_ACCOUNTING_YEAR |
INTEGER |
4 |
| 519 |
EFFECTIVE_ACCOUNTING_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 520 |
EFFECTIVE_ACCOUNTING_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 521 |
EFFECTIVE_ACCOUNTING_MONTH_KEY |
INTEGER |
4 |
| 522 |
EFFECTIVE_ACCOUNTING_MONTH_LABEL |
CHARACTER VARYING(15) |
15 |
| 523 |
EFFECTIVE_WEEK_ENDING |
CHARACTER VARYING(13) |
13 |
| 524 |
EFFECTIVE_ACCOUNTING_CURRENT_MONTH |
CHARACTER VARYING(18) |
18 |
| 525 |
EFFECTIVE_ACCOUNTING_CURRENT_MONTH_DAY_KEY |
INTEGER |
4 |
| 526 |
EFFECTIVE_ACCOUNTING_LAST_MONTH |
CHARACTER VARYING(18) |
18 |
| 527 |
EFFECTIVE_ACCOUNTING_CURRENT_MONTH_LAST_YEAR |
CHARACTER VARYING(30) |
30 |
| 528 |
EFFECTIVE_ACCOUNTING_YTD |
CHARACTER VARYING(8) |
8 |
| 529 |
EFFECTIVE_ACCOUNTING_YTD_MONTH_KEY |
INTEGER |
4 |
| 530 |
EFFECTIVE_ACCOUNTING_PRIOR_YTD |
CHARACTER VARYING(15) |
15 |
| 531 |
EFFECTIVE_ACCOUNTING_PRIOR_YTD_MONTH_KEY |
INTEGER |
4 |
| 532 |
EFFECTIVE_PRIOR_YEAR_MONTH |
CHARACTER VARYING(20) |
20 |
| 533 |
EFFECTIVE_ACCOUNTING_QTD |
CHARACTER VARYING(10) |
10 |
| 534 |
EFFECTIVE_ACCOUNTING_QTD_MONTH_KEY |
INTEGER |
4 |
| 535 |
EFFECTIVE_ACCOUNTING_PRIOR_QTD |
CHARACTER VARYING(15) |
15 |
| 536 |
EFFECTIVE_ACCOUNTING_PRIOR_QTD_MONTH_KEY |
INTEGER |
4 |
| 537 |
EFFECTIVE_ACCOUNTING_PRIOR_QTR |
CHARACTER VARYING(15) |
15 |
| 538 |
EFFECTIVE_ROLLING_26_WEEKS |
CHARACTER VARYING(25) |
25 |
| 539 |
EFFECTIVE_ROLLING_13_WEEKS |
CHARACTER VARYING(25) |
25 |
| 540 |
EFFECTIVE_CURRENT_WEEK |
CHARACTER VARYING(25) |
25 |
| 541 |
EFFECTIVE_PRIOR_WEEK |
CHARACTER VARYING(25) |
25 |
| 542 |
EFFECTIVE_ROLLING_12_MONTHS |
CHARACTER VARYING(25) |
25 |
| 543 |
EFFECTIVE_ROLLING_24_MONTHS |
CHARACTER VARYING(25) |
25 |
| 544 |
EFFECTIVE_ROLLING_36_MONTHS |
CHARACTER VARYING(25) |
25 |
| 545 |
EFFECTIVE_ACCOUNTING_DATE_INCEPTION_DATE_CODE |
CHARACTER(4) |
4 |
| 546 |
STATEMENT_DATE_CAL_YEAR |
INTEGER |
4 |
| 547 |
STATEMENT_DATE_CAL_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 548 |
STATEMENT_DATE_CAL_QUARTER |
INTEGER |
4 |
| 549 |
STATEMENT_DATE_CAL_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 550 |
STATEMENT_DATE_CAL_PRIOR_WEEK |
CHARACTER VARYING(20) |
20 |
| 551 |
STATEMENT_DATE_CAL_CURRENT_WEEK |
CHARACTER VARYING(20) |
20 |
| 552 |
STATEMENT_DATE_CAL_PRIOR_MONTH |
CHARACTER VARYING(20) |
20 |
| 553 |
STATEMENT_DATE_CAL_MONTH |
CHARACTER VARYING(20) |
20 |
| 554 |
STATEMENT_DATE_CAL_MONTH_KEY |
INTEGER |
4 |
| 555 |
STATEMENT_DATE_CAL_MONTH_LABEL |
CHARACTER VARYING(13) |
13 |
| 556 |
STATEMENT_DATE_CAL_DAY |
INTEGER |
4 |
| 557 |
STATEMENT_DATE_CAL_DAY_LABEL |
CHARACTER VARYING(13) |
13 |
| 558 |
STATEMENT_DATE_ACCOUNTING_CALENDAR_YEAR |
INTEGER |
4 |
| 559 |
STATEMENT_DATE_ACCOUNTING_EOM_DAY |
INTEGER |
4 |
| 560 |
STATEMENT_DATE_ACCOUNTING_EOQ_DAY |
INTEGER |
4 |
| 561 |
STATEMENT_DATE_ACCOUNTING_QUARTER |
INTEGER |
4 |
| 562 |
STATEMENT_DATE_ACCOUNTING_YEAR |
INTEGER |
4 |
| 563 |
STATEMENT_DATE_ACCOUNTING_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 564 |
STATEMENT_DATE_ACCOUNTING_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 565 |
STATEMENT_DATE_ACCOUNTING_MONTH_KEY |
INTEGER |
4 |
| 566 |
STATEMENT_DATE_ACCOUNTING_MONTH_LABEL |
CHARACTER VARYING(15) |
15 |
| 567 |
STATEMENT_DATE_WEEK_ENDING |
CHARACTER VARYING(13) |
13 |
| 568 |
STATEMENT_DATE_ACCOUNTING_CURRENT_WEEK |
CHARACTER VARYING(25) |
25 |
| 569 |
STATEMENT_DATE_ACCOUNTING_CURRENT_MONTH |
CHARACTER VARYING(18) |
18 |
| 570 |
STATEMENT_DATE_ACCOUNTING_CURRENT_MONTH_DAY_KEY |
INTEGER |
4 |
| 571 |
STATEMENT_DATE_ACCOUNTING_PRIOR_WEEK |
CHARACTER VARYING(25) |
25 |
| 572 |
STATEMENT_DATE_ACCOUNTING_LAST_MONTH |
CHARACTER VARYING(18) |
18 |
| 573 |
STATEMENT_DATE_ACCOUNTING_CURRENT_MONTH_LAST_YEAR |
CHARACTER VARYING(30) |
30 |
| 574 |
STATEMENT_DATE_ACCOUNTING_YTD |
CHARACTER VARYING(8) |
8 |
| 575 |
STATEMENT_DATE_ACCOUNTING_YTD_MONTH_KEY |
INTEGER |
4 |
| 576 |
STATEMENT_DATE_ACCOUNTING_PRIOR_YTD |
CHARACTER VARYING(15) |
15 |
| 577 |
STATEMENT_DATE_ACCOUNTING_PRIOR_YTD_MONTH_KEY |
INTEGER |
4 |
| 578 |
STATEMENT_DATE_PRIOR_YEAR_MONTH |
CHARACTER VARYING(20) |
20 |
| 579 |
STATEMENT_DATE_ACCOUNTING_QTD |
CHARACTER VARYING(10) |
10 |
| 580 |
STATEMENT_DATE_ACCOUNTING_QTD_MONTH_KEY |
INTEGER |
4 |
| 581 |
STATEMENT_DATE_ACCOUNTING_PRIOR_QTD |
CHARACTER VARYING(15) |
15 |
| 582 |
STATEMENT_DATE_ACCOUNTING_PRIOR_QTD_MONTH_KEY |
INTEGER |
4 |
| 583 |
STATEMENT_DATE_ACCOUNTING_PRIOR_QTR |
CHARACTER VARYING(15) |
15 |
| 584 |
STATEMENT_DATE_ROLLING_26_WEEKS |
CHARACTER VARYING(25) |
25 |
| 585 |
STATEMENT_DATE_ROLLING_13_WEEKS |
CHARACTER VARYING(25) |
25 |
| 586 |
STATEMENT_DATE_CURRENT_WEEK |
CHARACTER VARYING(25) |
25 |
| 587 |
STATEMENT_DATE_PRIOR_WEEK |
CHARACTER VARYING(25) |
25 |
| 588 |
POLICY_DUE_CAL_DAY |
INTEGER |
4 |
| 589 |
POLICY_DUE_CAL_DAY_LABEL |
CHARACTER VARYING(13) |
13 |
| 590 |
POLICY_DUE_ACCOUNTING_YEAR |
INTEGER |
4 |
| 591 |
POLICY_DUE_ACCOUNTING_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 592 |
POLICY_DUE_ACCOUNTING_MONTH_KEY |
INTEGER |
4 |
| 593 |
POLICY_DUE_ACCOUNTING_MONTH_LABE |
CHARACTER VARYING(15) |
15 |
| 594 |
QUOTE_CREATION_CAL_DAY |
INTEGER |
4 |
| 595 |
QUOTE_CREATION_CAL_DAY_LABEL |
CHARACTER VARYING(13) |
13 |
| 596 |
QUOTE_CREATION_ACCOUNTING_QUARTER |
INTEGER |
4 |
| 597 |
QUOTE_CREATION_ACCOUNTING_YEAR |
INTEGER |
4 |
| 598 |
QUOTE_CREATION_ACCOUNTING_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 599 |
QUOTE_CREATION_ACCOUNTING_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 600 |
QUOTE_CREATION_ACCOUNTING_MONTH_KEY |
INTEGER |
4 |
| 601 |
QUOTE_CREATION_ACCOUNTING_MONTH_LABEL |
CHARACTER VARYING(15) |
15 |
| 602 |
QUOTE_CREATION_ACCOUNTING_CURRENT_MONTH |
CHARACTER VARYING(18) |
18 |
| 603 |
QUOTE_CREATION_ACCOUNTING_CURRENT_MONTH_DAY_KEY |
INTEGER |
4 |
| 604 |
QUOTE_CREATION_WEEK_ENDING |
CHARACTER VARYING(13) |
13 |
| 605 |
QUOTE_CREATION_CURRENT_WEEK |
CHARACTER VARYING(25) |
25 |
| 606 |
TRANSACTION_CAL_YEAR |
INTEGER |
4 |
| 607 |
TRANSACTION_CAL_YEAR_LABEL |
CHARACTER VARYING(13) |
13 |
| 608 |
TRANSACTION_CAL_QUARTER |
INTEGER |
4 |
| 609 |
TRANSACTION_CAL_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 610 |
TRANSACTION_CAL_PRIOR_WEEK |
CHARACTER VARYING(20) |
20 |
| 611 |
TRANSACTION_CAL_CURRENT_WEEK |
CHARACTER VARYING(20) |
20 |
| 612 |
TRANSACTION_CAL_PRIOR_MONTH |
CHARACTER VARYING(20) |
20 |
| 613 |
TRANSACTION_CAL_MONTH |
CHARACTER VARYING(20) |
20 |
| 614 |
TRANSACTION_CAL_MONTH_KEY |
INTEGER |
4 |
| 615 |
TRANSACTION_CAL_MONTH_LABEL |
CHARACTER VARYING(13) |
13 |
| 616 |
TRANSACTION_CAL_DAY |
INTEGER |
4 |
| 617 |
TRANSACTION_CAL_DAY_LABEL |
CHARACTER VARYING(13) |
13 |
| 618 |
TRANSACTION_ACCOUNTING_CALENDAR_YEAR |
INTEGER |
4 |
| 619 |
TRANSACTION_ACCOUNTING_EOM_DAY |
INTEGER |
4 |
| 620 |
TRANSACTION_ACCOUNTING_EOQ_DAY |
INTEGER |
4 |
| 621 |
TRANSACTION_ACCOUNTING_QUARTER |
INTEGER |
4 |
| 622 |
TRANSACTION_ACCOUNTING_YEAR |
INTEGER |
4 |
| 623 |
TRANSACTION_ACCOUNTING_QUARTER_LABEL |
CHARACTER VARYING(13) |
13 |
| 624 |
TRANSACTION_ACCOUNTING_CURRENT_WEEK |
CHARACTER VARYING(25) |
25 |
| 625 |
TRANSACTION_ACCOUNTING_CURRENT_MONTH |
CHARACTER VARYING(18) |
18 |
| 626 |
TRANSACTION_ACCOUNTING_CURRENT_MONTH_DAY_KEY |
INTEGER |
4 |
| 627 |
TRANSACTION_ACCOUNTING_PRIOR_WEEK |
CHARACTER VARYING(25) |
25 |
| 628 |
TRANSACTION_ACCOUNTING_LAST_MONTH |
CHARACTER VARYING(18) |
18 |
| 629 |
TRANSACTION_ACCOUNTING_CURRENT_MONTH_LAST_YEAR |
CHARACTER VARYING(30) |
30 |
| 630 |
TRANSACTION_ACCOUNTING_YTD |
CHARACTER VARYING(8) |
8 |
| 631 |
TRANSACTION_ACCOUNTING_YTD_MONTH_KEY |
INTEGER |
4 |
| 632 |
TRANSACTION_ACCOUNTING_PRIOR_YTD |
CHARACTER VARYING(15) |
15 |
| 633 |
TRANSACTION_ACCOUNTING_PRIOR_YTD_MONTH_KEY |
INTEGER |
4 |
| 634 |
TRANSACTION_PRIOR_YEAR_MONTH |
CHARACTER VARYING(20) |
20 |
| 635 |
TRANSACTION_ACCOUNTING_QTD |
CHARACTER VARYING(10) |
10 |
| 636 |
TRANSACTION_ACCOUNTING_QTD_MONTH_KEY |
INTEGER |
4 |
| 637 |
TRANSACTION_ACCOUNTING_PRIOR_QTD |
CHARACTER VARYING(15) |
15 |
| 638 |
TRANSACTION_ACCOUNTING_PRIOR_QTD_MONTH_KEY |
INTEGER |
4 |
| 639 |
TRANSACTION_ACCOUNTING_PRIOR_QTR |
CHARACTER VARYING(15) |
15 |
| 640 |
TRANSACTION_ROLLING_26_WEEKS |
CHARACTER VARYING(25) |
25 |
| 641 |
TRANSACTION_ROLLING_13_WEEKS |
CHARACTER VARYING(25) |
25 |
| 642 |
TRANSACTION_CURRENT_WEEK |
CHARACTER VARYING(25) |
25 |
| 643 |
TRANSACTION_PRIOR_WEEK |
CHARACTER VARYING(25) |
25 |
| 644 |
TRANSACTION_ROLLING_12_MONTHS |
CHARACTER VARYING(25) |
25 |
| 645 |
TRANSACTION_ROLLING_24_MONTHS |
CHARACTER VARYING(25) |
25 |
| 646 |
TRANSACTION_ROLLING_36_MONTHS |
CHARACTER VARYING(25) |
25 |
| 647 |
TRANSACTION_ACCOUNTING_DATE_INCEPTION_DATE_CODE |
CHARACTER(4) |
4 |