INT_PCSRCPN_FRTAIL

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 VARYING(3) 3
10 POLICY INTEGER 4
11 ITEMNO SMALLINT 2
12 EFFECTDTE INTEGER 4
13 ACTIVTO INTEGER 4
14 TRANCNT SMALLINT 2
15 IMAGEFLAG CHARACTER VARYING(1) 1
16 FRCNSTRYR SMALLINT 2
17 FRCNSTR CHARACTER VARYING(2) 2
18 FRFUSION NUMERIC(5,0) 19
19 FRFLOOD CHARACTER VARYING(1) 1
20 FRERTHQAK CHARACTER VARYING(1) 1
21 FRSTORM CHARACTER VARYING(1) 1
22 FRAIRCRFT CHARACTER VARYING(1) 1
23 FREXPLOSN CHARACTER VARYING(1) 1
24 FRIMPACT CHARACTER VARYING(1) 1
25 FRRIOTSTK CHARACTER VARYING(1) 1
26 FRRTSSTKM CHARACTER VARYING(1) 1
27 FRSTMRAIN CHARACTER VARYING(1) 1
28 FRWTRLKNG CHARACTER VARYING(1) 1
29 FRWIND CHARACTER VARYING(1) 1
30 FRRMVEDEB NUMERIC(11,0) 19
31 FRRPLCMNT CHARACTER VARYING(1) 1
32 FREXTCST CHARACTER VARYING(1) 1
33 FRSPRNKLR CHARACTER VARYING(1) 1
34 FRALARM CHARACTER VARYING(1) 1
35 FRSMOKDET CHARACTER VARYING(1) 1
36 FRROCCUP CHARACTER VARYING(4) 4
37 FRBUILDSI NUMERIC(11,0) 19
38 FRSTCKSI NUMERIC(11,0) 19
39 FRSTCKSSI NUMERIC(11,0) 19
40 FRCNTSSI NUMERIC(11,0) 19
41 FRCUSTSI NUMERIC(11,0) 19
42 FRCUSTSSI NUMERIC(11,0) 19
43 FRRENTSI NUMERIC(11,0) 19
44 FRRENTMTH SMALLINT 2
45 FRSPOILSI NUMERIC(11,0) 19
46 FRSPLSSI NUMERIC(11,0) 19
47 FRCONTSI NUMERIC(11,0) 19
48 FRCONTSSI NUMERIC(11,0) 19
49 FRITEMSI NUMERIC(11,0) 19
50 FRITMDESC CHARACTER VARYING(80) 80
51 FRAUTREIN CHARACTER VARYING(1) 1
52 FRRECSI NUMERIC(11,0) 19
53 FROPENSI NUMERIC(11,0) 19
54 FRCOMPREC NUMERIC(11,0) 19
55 FRARCHFEE NUMERIC(11,0) 19
56 FRREINST NUMERIC(11,0) 19
57 FRFUSIONX NUMERIC(5,0) 19
58 FRRICNST CHARACTER VARYING(1) 1
59 FRFLOODLD SMALLINT 2
60 FRMLTDISC SMALLINT 2
61 UWPOINTS CHARACTER VARYING(3) 3
62 UWCATG CHARACTER VARYING(2) 2