INT_BASE_PI_POLICY_TRANSACTION
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | COMPANY_NO | SMALLINT | 2 |
| 2 | POLICY_NO | BIGINT | 8 |
| 3 | RISK_NO | BIGINT | 8 |
| 4 | RISK_COUNT | NUMERIC(32,12) | 19 |
| 5 | ITEM_NO | SMALLINT | 2 |
| 6 | PRODUCT_TYPE_CODE | CHARACTER(3) | 3 |
| 7 | PRODUCT_CLASS_CODE | CHARACTER(3) | 3 |
| 8 | PRODUCT_SUBCLASS | CHARACTER(3) | 3 |
| 9 | PRODUCT_EXTRA_KEY1 | CHARACTER VARYING(10) | 10 |
| 10 | PRODUCT_EXTRA_KEY2 | CHARACTER VARYING(10) | 10 |
| 11 | RISK_STATE | CHARACTER(2) | 2 |
| 12 | RISK_POSTCODE | CHARACTER VARYING(9) | 9 |
| 13 | TRANSACTION_DATE | DATE | 4 |
| 14 | TRANTIME_REF | INTEGER | 4 |
| 15 | NB_INDICATOR | CHARACTER(2) | 2 |
| 16 | TRANSACTION_TYPE | CHARACTER(2) | 2 |
| 17 | SCHEDULE_START | DATE | 4 |
| 18 | SCHEDULE_END | DATE | 4 |
| 19 | TERM_START | DATE | 4 |
| 20 | INCEPTION_DATE | DATE | 4 |
| 21 | DUE_DATE | DATE | 4 |
| 22 | TRAN_BASIC_PREM | NUMERIC(11,2) | 19 |
| 23 | TRAN_BASIC_CHARGES | NUMERIC(11,2) | 19 |
| 24 | TRAN_BASIC_STMPDTY | NUMERIC(11,2) | 19 |
| 25 | TRAN_BASIC_COMSN | NUMERIC(11,2) | 19 |
| 26 | TRAN_BASIC_GST | NUMERIC(11,2) | 19 |
| 27 | TEAM_KEY1 | CHARACTER VARYING(10) | 10 |
| 28 | USERID | CHARACTER(8) | 8 |
| 29 | BUSINESS_SOURCE | CHARACTER(4) | 4 |
| 30 | USER_TYPE | CHARACTER VARYING(1) | 1 |
| 31 | PREV_POLICY_TYPE | CHARACTER(3) | 3 |
| 32 | PREV_POLICY_NO | BIGINT | 8 |
| 33 | INSTALMENT_FREQ | CHARACTER(1) | 1 |
| 34 | CANCEL_REASON_ID | CHARACTER(3) | 3 |
| 35 | NEGATIVE_GWP_FLAG | CHARACTER VARYING(1) | 1 |
| 36 | AT_RENEWAL_CANCELLATION_FLAG | CHARACTER VARYING(1) | 1 |
| 37 | RATING_ADDRESS | INTEGER | 4 |
| 38 | LURN | CHARACTER(38) | 38 |
| 39 | MODULE_NO | SMALLINT | 2 |
| 40 | RISK_TYPE1 | CHARACTER VARYING(255) | 255 |
| 41 | RISK_TYPE2 | CHARACTER VARYING(40) | 40 |
| 42 | RISK_TYPE3 | CHARACTER VARYING(40) | 40 |
| 43 | CHANNEL_KEY1 | CHARACTER VARYING(10) | 10 |
| 44 | CHANNEL_KEY2 | CHARACTER VARYING(10) | 10 |
| 45 | RISK_START_DATE | DATE | 4 |
| 46 | REVERSAL_FLAG | CHARACTER(8) | 8 |
| 47 | PART_CAN_FLAG | CHARACTER VARYING(1) | 1 |
| 48 | REVTRAN_EFFECTDTE_CDC | DATE | 4 |
| 49 | RE_EFFECTDTE | DATE | 4 |
| 50 | ITEM_EARLIEST_STARTDATE | DATE | 4 |
| 51 | PROTECT_POLICY_INCEPTION | DATE | 4 |
| 52 | ACTIVE_COVER_FLAG | CHARACTER VARYING(1) | 1 |
| 53 | RENEWAL_OFFERED_TERM_FLAG | CHARACTER VARYING(1) | 1 |
| 54 | RENEWAL_OFFERED_DATE | DATE | 4 |
| 55 | EARLIER_UNREV_TXN_FLAG | CHARACTER VARYING(1) | 1 |
| 56 | UNACTIVE_DATE | DATE | 4 |
| 57 | ITEM_START_DATE | DATE | 4 |
| 58 | CRC | CHARACTER(1) | 1 |
| 59 | CRCSTATUS | CHARACTER(1) | 1 |
| 60 | FLOODOPTOUT | CHARACTER(1) | 1 |
| 61 | FLOODRISK | CHARACTER(1) | 1 |
| 62 | RD_ASSIST | CHARACTER(1) | 1 |
| 63 | HOMEASSIST | CHARACTER(1) | 1 |
| 64 | HIRE_CAR | CHARACTER(1) | 1 |
| 65 | WINDSCREEN | CHARACTER(1) | 1 |
| 66 | END_FLAG | CHARACTER(1) | 1 |
| 67 | REN_PAYMENT_CATEGORY | CHARACTER VARYING(8) | 8 |