INT_CTP_POLICY_INTERR_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 SUBCOY SMALLINT 2
3 STATE SMALLINT 2
4 RISKSTATE CHARACTER VARYING(2) 2
5 RUNNO INTEGER 4
6 RUNDATE INTEGER 4
7 PRODUCT CHARACTER VARYING(3) 3
8 POLICY INTEGER 4
9 ITEMNO SMALLINT 2
10 INTER_CLASS CHARACTER VARYING(3) 3
11 SUBCLASS CHARACTER VARYING(3) 3
12 AGENT INTEGER 4
13 TRANTYPE CHARACTER VARYING(4) 4
14 RECTYPE CHARACTER VARYING(2) 2
15 TRANDATE INTEGER 4
16 TRANTIME INTEGER 4
17 EFFECTDTE INTEGER 4
18 SEQUENCE NUMERIC(7,0) 19
19 LINENO SMALLINT 2
20 ERRNO CHARACTER VARYING(4) 4
21 RECIND SMALLINT 2
22 ACTION CHARACTER VARYING(1) 1
23 PROGID CHARACTER VARYING(8) 8
24 ERRDATE INTEGER 4
25 ERRTIME INTEGER 4
26 INTERTYP CHARACTER VARYING(3) 3
27 INTERPRO CHARACTER VARYING(3) 3
28 INTERPOL CHARACTER VARYING(20) 20
29 INTERITM CHARACTER VARYING(12) 12
30 TRANSEQ INTEGER 4
31 PROCSTATUS CHARACTER(2) 2
32 TRANCODE CHARACTER(3) 3
33 MVREG CHARACTER(12) 12
34 CTPNO CHARACTER(12) 12
35 REPLYBYDATE INTEGER 4
36 SEQPOLICY INTEGER 4
37 REPLYCODE CHARACTER(1) 1
38 REPLYREASON CHARACTER(2) 2
39 RERUNTRAN CHARACTER(1) 1
40 MANUALMATCH CHARACTER(1) 1
41 REPLYCTPNO CHARACTER(12) 12
42 REPLYSENT CHARACTER(1) 1
43 TAPEDATE INTEGER 4
44 LASTUSER CHARACTER(8) 8
45 UPDATEDATE INTEGER 4
46 UPDATETIME INTEGER 4
47 TRANDATA CHARACTER VARYING(2000) 2000
48 REGOID NUMERIC(10,0) 19
49 EXTREFID CHARACTER(15) 15
50 TOTAL_PREMIUM NUMERIC(12,2) 19
51 GST NUMERIC(12,2) 19
52 Credit/Debit CHARACTER VARYING(1) 1
53 TERM_MONTHS CHARACTER VARYING(3) 3
54 TERM_VALUE CHARACTER VARYING(1) 1
55 CLASS CHARACTER VARYING(4) 4
56 LITEXPAN_RECIND SMALLINT 2
57 KEYVALUE CHARACTER(4) 4
58 Error Description CHARACTER(60) 60
59 DESC1 CHARACTER(30) 30
60 DESC2 CHARACTER(30) 30
61 TRANSACTION_COUNT INTEGER 4
62 START_DATE INTEGER 4
63 END_DATE INTEGER 4