INT_PCSRCPN_CLAIM

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 CLAIMNO NUMERIC(11,0) 19
10 PRODUCT CHARACTER(3) 3
11 POLICY INTEGER 4
12 ITEMNO SMALLINT 2
13 CREATEDTE INTEGER 4
14 CLMSTATUS CHARACTER(1) 1
15 COMPLTIND CHARACTER(1) 1
16 FINALDTE INTEGER 4
17 TRANDATE INTEGER 4
18 LOSSDATE INTEGER 4
19 LOSSTIME SMALLINT 2
20 REPORTDTE INTEGER 4
21 REINSTED CHARACTER(1) 1
22 REOPENIND CHARACTER(2) 2
23 REOPENDTE INTEGER 4
24 HIGHLTDTE INTEGER 4
25 FSPRNTDTE INTEGER 4
26 USERRESP CHARACTER(8) 8
27 BRCHRESP SMALLINT 2
28 INCIDENT INTEGER 4
29 CATAST CHARACTER(4) 4
30 ORIGEST NUMERIC(11,2) 19
31 NATURECDE CHARACTER(3) 3
32 CLAIMDESC CHARACTER(60) 60
33 PREVCLMNO CHARACTER(14) 14
34 CUSTREF CHARACTER(14) 14
35 COYISSUED SMALLINT 2
36 BRANCH SMALLINT 2
37 STATE SMALLINT 2
38 REP SMALLINT 2
39 AGENT INTEGER 4
40 CLIENT INTEGER 4
41 SITNREF INTEGER 4
42 DUEDATE INTEGER 4
43 CLASS CHARACTER(3) 3
44 SUBCLASS CHARACTER(3) 3
45 RISKSTATE CHARACTER(2) 2
46 RISKDESC1 CHARACTER(50) 50
47 RISKDESC2 CHARACTER(50) 50
48 SUMINS INTEGER 4
49 SUMINSCDE CHARACTER(3) 3
50 EXCESS INTEGER 4
51 EXCESSTYP CHARACTER(1) 1
52 FORM CHARACTER(10) 10
53 OCCUPATN CHARACTER(8) 8
54 DISTRICT CHARACTER(2) 2
55 FIREBRIG CHARACTER(1) 1
56 TYPEOFPOL CHARACTER(1) 1
57 COINSPC NUMERIC(5,3) 19
58 NATCOVER CHARACTER(1) 1
59 EXCCOVER NUMERIC(11,0) 19
60 MVREG CHARACTER(12) 12
61 TAILORGRP CHARACTER(2) 2
62 MULTIGRP CHARACTER(2) 2
63 POLCOMPLT CHARACTER(1) 1
64 ITMCOMPLT CHARACTER(1) 1
65 POLTRNCNT SMALLINT 2
66 ITMTRNCNT SMALLINT 2
67 STATRNCNT SMALLINT 2
68 RITRANCNT SMALLINT 2
69 SCHTRNCNT SMALLINT 2
70 OSGRS NUMERIC(11,2) 19
71 OSLOC NUMERIC(11,2) 19
72 OSTTY NUMERIC(11,2) 19
73 OSNET NUMERIC(11,2) 19
74 PAIDGRS NUMERIC(11,2) 19
75 PAIDLOC NUMERIC(11,2) 19
76 PAIDTTY NUMERIC(11,2) 19
77 PAIDNET NUMERIC(11,2) 19
78 ESTRCVOS NUMERIC(11,2) 19
79 EOLOS NUMERIC(11,2) 19
80 EOLPAID NUMERIC(11,2) 19
81 CATOS NUMERIC(11,2) 19
82 CATPAID NUMERIC(11,2) 19
83 RIVERSCNT SMALLINT 2
84 RCVRECCNT SMALLINT 2
85 THRECCNT SMALLINT 2
86 LOCKUSER CHARACTER(8) 8
87 LOCKDATE INTEGER 4
88 LOCKTIME INTEGER 4
89 EOLCATIND CHARACTER(1) 1
90 DOCLOCATE CHARACTER(4) 4
91 SEQCLAIM NUMERIC(11,0) 19
92 CUSTSATIS CHARACTER(1) 1
93 REASONCDE CHARACTER(1) 1
94 ASSESSOR CHARACTER(4) 4
95 RECOVIND CHARACTER(1) 1
96 TOTALLOSS CHARACTER(1) 1
97 LOSSLOCN INTEGER 4
98 POLICERPT CHARACTER(1) 1
99 POLICESTN CHARACTER(20) 20
100 CRIMENO CHARACTER(20) 20
101 INSDITCPC NUMERIC(5,2) 19
102 GSTEXCLUD CHARACTER(2) 2
103 PAYTDWITC NUMERIC(11,2) 19
104 ITCESTTD NUMERIC(11,2) 19
105 ITCPAYTD NUMERIC(11,2) 19
106 CLMMINOR CHARACTER(1) 1
107 INSPDATE INTEGER 4
108 AUTHDATE INTEGER 4
109 POSTALREF INTEGER 4
110 INSPLOCN INTEGER 4
111 FORMSTAT CHARACTER(1) 1
112 FORMSENT INTEGER 4
113 FORMRCVD INTEGER 4
114 XSRECOVD NUMERIC(11,2) 19
115 DISCOVBY CHARACTER(20) 20
116 POINTENTRY CHARACTER(35) 35