FCT_CTP_RMS_SIRA_TRANSACTIONS
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | REGISTRATION | CHARACTER VARYING(12) | 12 |
| 2 | MAKE | CHARACTER VARYING(6) | 6 |
| 3 | MODEL | CHARACTER VARYING(10) | 10 |
| 4 | CLASS | CHARACTER VARYING(3) | 3 |
| 5 | CLASS_PRT | CHARACTER VARYING(4) | 4 |
| 6 | SHAPE | CHARACTER VARYING(4) | 4 |
| 7 | SHAPE_PRT | CHARACTER VARYING(4) | 4 |
| 8 | ENGINETYPE | CHARACTER VARYING(7) | 7 |
| 9 | ENGINECAPACITY | INTEGER | 4 |
| 10 | VEHICLEUSE | CHARACTER VARYING(4) | 4 |
| 11 | YEARMANUFACTURED | INTEGER | 4 |
| 12 | VIN | CHARACTER VARYING(25) | 25 |
| 13 | OWNERTYPE | CHARACTER VARYING(12) | 12 |
| 14 | OWNERBIRTHDATE | DATE | 4 |
| 15 | FIRSTNAME | CHARACTER VARYING(40) | 40 |
| 16 | LASTNAME | CHARACTER VARYING(40) | 40 |
| 17 | OWNERNAME | CHARACTER VARYING(40) | 40 |
| 18 | UNDER25INDICATOR | CHARACTER VARYING(1) | 1 |
| 19 | YOUNGESTBIRTHDATE | DATE | 4 |
| 20 | CTPINSURER | INTEGER | 4 |
| 21 | POLICYNUMBER | CHARACTER VARYING(40) | 40 |
| 22 | RMSNUMBER | CHARACTER VARYING(12) | 12 |
| 23 | TRANSACTIONTYPE | CHARACTER VARYING(4) | 4 |
| 24 | TRANSACTIONID | CHARACTER VARYING(40) | 40 |
| 25 | TRANSACTIONDATE | DATE | 4 |
| 26 | PROTECTTRANDATE | DATE | 4 |
| 27 | POLICYDURATION | INTEGER | 4 |
| 28 | POLICYLOADING | NUMERIC(38,2) | 19 |
| 29 | BONUSMALUS | NUMERIC(38,2) | 19 |
| 30 | BONUSMALUS_PRT | NUMERIC(9,6) | 19 |
| 31 | ATFAULTINDICATOR | CHARACTER VARYING(1) | 1 |
| 32 | RISKREGION_PRT | CHARACTER VARYING(3) | 3 |
| 33 | CTPREGION | CHARACTER VARYING(1) | 1 |
| 34 | RMSUSED | CHARACTER VARYING(1) | 1 |
| 35 | RMSEFFECTIVEDATE | DATE | 4 |
| 36 | INSUREREFFECTIVEDATE | DATE | 4 |
| 37 | RMSEXPIRYDATE | DATE | 4 |
| 38 | DISTRIBUTIONCHANNEL | CHARACTER VARYING(2) | 2 |
| 39 | DISTRIBUTIONCHANNELNAME | CHARACTER VARYING(100) | 100 |
| 40 | GARAGEDSUBURB | CHARACTER VARYING(40) | 40 |
| 41 | GARAGEDPOSTCODE | NUMERIC(6,0) | 19 |
| 42 | MAILPOSTCODE | NUMERIC(6,0) | 19 |
| 43 | SUBZONE | CHARACTER VARYING(60) | 60 |
| 44 | IRC | CHARACTER VARYING(6) | 6 |
| 45 | PREMIUMTAXABLE_PRT | NUMERIC(11,2) | 19 |
| 46 | PREMIUMTOTAL_PRT | NUMERIC(11,2) | 19 |
| 47 | COMMISSION_PRT | NUMERIC(11,2) | 19 |
| 48 | MCISLEVY_PRT | NUMERIC(11,2) | 19 |
| 49 | GST_PRT | NUMERIC(11,2) | 19 |
| 50 | PREMIUMTAXABLE | NUMERIC(38,2) | 19 |
| 51 | PREMIUMTOTAL | NUMERIC(38,6) | 19 |
| 52 | COMMISSION | NUMERIC(38,6) | 19 |
| 53 | MCISLEVY | NUMERIC(38,6) | 19 |
| 54 | GST | NUMERIC(38,6) | 19 |
| 55 | INPUTTAXCREDITENTITLEMENTS | CHARACTER VARYING(1) | 1 |
| 56 | USERTRANSACTIONTYPE | CHARACTER VARYING(4) | 4 |
| 57 | USERTRANSACTIONTYPENAME | CHARACTER VARYING(60) | 60 |
| 58 | USERTRANTYPE_PRT | CHARACTER VARYING(4) | 4 |
| 59 | USERTRANTYPENAME_PRT | CHARACTER VARYING(60) | 60 |
| 60 | PREMTRANSACTIONDATE | DATE | 4 |
| 61 | EFFECTIVEDATE | DATE | 4 |
| 62 | STAMPDTE | CHARACTER VARYING(10) | 10 |
| 63 | TERMSTART | DATE | 4 |
| 64 | DUEDATE | DATE | 4 |
| 65 | AGENTNAME | CHARACTER VARYING(100) | 100 |
| 66 | AGENTACCOUNTTYPE | CHARACTER VARYING(1) | 1 |
| 67 | BRAND | CHARACTER VARYING(100) | 100 |
| 68 | SCHEMELICENCE | CHARACTER VARYING(20) | 20 |
| 69 | POLICYTERM | INTEGER | 4 |
| 70 | AGENTID | INTEGER | 4 |
| 71 | REMAMOUNT_PRT | NUMERIC(38,6) | 19 |
| 72 | REMAMOUNT | NUMERIC(38,6) | 19 |
| 73 | VEHICLE_AGE_KEY | INTEGER | 4 |
| 74 | VEHICLE_AGE | CHARACTER VARYING(12) | 12 |
| 75 | OWNER_AGE_KEY | INTEGER | 4 |
| 76 | OWNER_AGE | CHARACTER VARYING(12) | 12 |
| 77 | CURRENT_WEEK | CHARACTER VARYING(25) | 25 |
| 78 | PRIOR_WEEK | CHARACTER VARYING(25) | 25 |
| 79 | ACCOUNTING_MONTH_LABEL | CHARACTER VARYING(15) | 15 |
| 80 | ACCOUNTING_CURRENT_MONTH | CHARACTER VARYING(18) | 18 |
| 81 | ACCOUNTING_LAST_MONTH | CHARACTER VARYING(18) | 18 |
| 82 | ACCOUNTING_QUARTER | INTEGER | 4 |
| 83 | ACCOUNTING_QUARTER_LABEL | CHARACTER VARYING(13) | 13 |
| 84 | ACCOUNTING_PRIOR_QTR | CHARACTER VARYING(15) | 15 |
| 85 | ACCOUNTING_YEAR | INTEGER | 4 |
| 86 | ACCOUNTING_YEAR_LABEL | CHARACTER VARYING(13) | 13 |
| 87 | SIRAFLAG | CHARACTER VARYING(1) | 1 |
| 88 | REMFLAG | CHARACTER VARYING(1) | 1 |
| 89 | CANCEL_REASON | CHARACTER VARYING(20) | 20 |
| 90 | CANCEL_REASON_NAME | CHARACTER VARYING(60) | 60 |
| 91 | POLICY_STATUS | CHARACTER VARYING(1) | 1 |
| 92 | TERM_TYPE | CHARACTER VARYING(50) | 50 |
| 93 | CHASSISNO | CHARACTER VARYING(25) | 25 |