RDM_SIRA_POLICY_TRANS

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND CHARACTER VARYING(100) 100
2 SCHEMELICENCE CHARACTER VARYING(20) 20
3 INSURER_NUMBER INTEGER 4
4 REGISTRATION CHARACTER VARYING(10) 10
5 MAKE CHARACTER VARYING(20) 20
6 MODEL CHARACTER VARYING(20) 20
7 CLASS CHARACTER VARYING(3) 3
8 SHAPE CHARACTER VARYING(6) 6
9 ENGINETYPE CHARACTER VARYING(7) 7
10 ENGINECAPACITY INTEGER 4
11 VEHICLEUSE CHARACTER VARYING(4) 4
12 YEARMANUFACTURED INTEGER 4
13 VIN CHARACTER VARYING(17) 17
14 OWNERTYPE CHARACTER VARYING(1) 1
15 OWNERBIRTHDATE INTEGER 4
16 FIRSTNAME CHARACTER VARYING(30) 30
17 LASTNAME CHARACTER VARYING(35) 35
18 OWNERNAME CHARACTER VARYING(35) 35
19 UNDER25INDICATOR CHARACTER VARYING(1) 1
20 YOUNGESTBIRTHDATE INTEGER 4
21 POLICYNUMBER CHARACTER VARYING(20) 20
22 RMSNUMBER CHARACTER VARYING(10) 10
23 TRANSACTIONTYPE CHARACTER VARYING(3) 3
24 TRANSACTIONID CHARACTER VARYING(100) 100
25 TRANSACTIONDATE INTEGER 4
26 POLICYDURATION INTEGER 4
27 POLICYLOADING NUMERIC(11,2) 19
28 BONUS_MALUS NUMERIC(11,2) 19
29 ATFAULTINDICATOR CHARACTER VARYING(1) 1
30 CTPREGION CHARACTER VARYING(1) 1
31 RMSUSED CHARACTER VARYING(1) 1
32 RMSEFFECTIVEDATE INTEGER 4
33 INSUREREFFECTIVEDATE INTEGER 4
34 RMSEXPIRYDATE INTEGER 4
35 DISTRIBUTIONCHANNEL CHARACTER VARYING(2) 2
36 GARAGEDSUBURB CHARACTER VARYING(50) 50
37 GARAGEDPOSTCODE INTEGER 4
38 MAILPOSTCODE INTEGER 4
39 SUBZONE CHARACTER VARYING(60) 60
40 IRC CHARACTER VARYING(3) 3
41 PREMIUMTAXABLE NUMERIC(11,2) 19
42 PREMIUMTOTAL NUMERIC(11,2) 19
43 COMMISSION NUMERIC(11,2) 19
44 MCISLEVY NUMERIC(11,2) 19
45 GST NUMERIC(11,2) 19
46 INPUTTAXCREDITENTITLEMENTS CHARACTER VARYING(1) 1
47 LOADDATE CHARACTER VARYING(50) 50
48 LOADFILENAME CHARACTER VARYING(50) 50
49 PROTECT_TRANSACTION_DATE INTEGER 4
50 LAST_MODIFIED_DATE CHARACTER VARYING(50) 50
51 LAST_MODIFIED_BY CHARACTER VARYING(50) 50
52 LAST_MODIFIED_NOTES CHARACTER VARYING(200) 200
53 REM_AMOUNT NUMERIC(20,2) 19
54 REM_ID CHARACTER VARYING(60) 60
55 REM_ID_ADJ CHARACTER VARYING(60) 60
56 REM_OWNER_AGE CHARACTER VARYING(12) 12
57 REM_SUB_ZONE CHARACTER VARYING(60) 60
58 REM_VEHICLE_AGE CHARACTER VARYING(12) 12
59 REM_CLASS CHARACTER VARYING(4) 4
60 COMMENTS CHARACTER VARYING(100) 100
61 REM_LOADTIME CHARACTER VARYING(50) 50
62 REM_QUARTER CHARACTER VARYING(6) 6
63 VEHICLE_AGE_KEY INTEGER 4
64 OWNER_AGE_KEY INTEGER 4
65 CLEAR_HOUSE_REM CHARACTER VARYING(1) 1
66 PVD_SIRA_REM CHARACTER VARYING(1) 1
67 CANCEL_REASON CHARACTER VARYING(20) 20
68 CANCEL_REASON_NAME CHARACTER VARYING(60) 60
69 POLICY_STATUS CHARACTER VARYING(1) 1
70 TERM_TYPE CHARACTER VARYING(50) 50