INT_PCSRCPN_PREMTRAN

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MD5_KEY CHARACTER VARYING(128) 128
2 REC_TYPE_CD INTEGER 4
3 BATCH_KEY INTEGER 4
4 RUN_REG_KEY BIGINT 8
5 ROW_INSERT_DT TIMESTAMP 8
6 ROW_EFFECTIVE_DT TIMESTAMP 8
7 AUDIT_FLAG CHARACTER VARYING(1) 1
8 COMPANY SMALLINT 2
9 PRODUCT CHARACTER(3) 3
10 POLICY INTEGER 4
11 ITEMNO SMALLINT 2
12 TRANDATE INTEGER 4
13 TRANTIME INTEGER 4
14 STATE SMALLINT 2
15 BRANCH SMALLINT 2
16 COYISSUED SMALLINT 2
17 TRANCNT SMALLINT 2
18 RISKSTATE CHARACTER(2) 2
19 CLIENT INTEGER 4
20 AGENT INTEGER 4
21 REP SMALLINT 2
22 CLASS CHARACTER(3) 3
23 SUBCLASS CHARACTER(3) 3
24 EFFECTDTE INTEGER 4
25 DUEDATE INTEGER 4
26 ACTMONTH INTEGER 4
27 SUMINS INTEGER 4
28 SUMINSCDE CHARACTER(3) 3
29 FIREBRIG CHARACTER(1) 1
30 TBASICPRM NUMERIC(11,2) 19
31 TCHARGES NUMERIC(11,2) 19
32 TSTMPDUTY NUMERIC(11,2) 19
33 TCOMMISN NUMERIC(11,2) 19
34 ATRNTYPE CHARACTER(2) 2
35 REASONCDE CHARACTER(2) 2
36 BUSNESSRC CHARACTER(4) 4
37 CHRGECODE CHARACTER(2) 2
38 TAILORGRP CHARACTER(2) 2
39 GLUPDNO INTEGER 4
40 CHGEXCLUD CHARACTER(2) 2
41 SDEXCLUD CHARACTER(2) 2
42 SDPREMT NUMERIC(11,2) 19
43 TGST NUMERIC(11,2) 19
44 GSTEXCLUD CHARACTER(2) 2
45 TCOMMGST NUMERIC(11,2) 19
46 GSTCOMMEX CHARACTER(2) 2