PRT_CLAIM

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

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