PRT_CONTACT

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 CLIENT INTEGER 4
3 CONTACTNO SMALLINT 2
4 STATE SMALLINT 2
5 BRANCH SMALLINT 2
6 CREATEDTE INTEGER 4
7 USERID CHARACTER VARYING(8) 8
8 MAINTDATE INTEGER 4
9 CONTACTYP CHARACTER VARYING(1) 1
10 PRODUCT CHARACTER VARYING(3) 3
11 MEDIUM CHARACTER VARYING(1) 1
12 PRAISETYP CHARACTER VARYING(1) 1
13 PLAINTTYP CHARACTER VARYING(2) 2
14 PLAINTSUB CHARACTER VARYING(1) 1
15 OUTCOME CHARACTER VARYING(1) 1
16 RESOLVDTE INTEGER 4
17 DISPLEVEL CHARACTER VARYING(1) 1
18 DISPUTENO INTEGER 4
19 NOTIFDATE INTEGER 4
20 IECCLASS CHARACTER VARYING(2) 2
21 HOLDDATE INTEGER 4
22 DECIDEDTE INTEGER 4
23 ESCALDATE INTEGER 4
24 CLAIMNO NUMERIC(11,0) 19
25 POLICY INTEGER 4
26 TRANCNT SMALLINT 2
27 RECTYPE CHARACTER VARYING(1) 1
28 MAINTTIME INTEGER 4
29 MRKTCMPGN CHARACTER VARYING(4) 4
30 MARKTMAIL CHARACTER VARYING(1) 1
31 MRKTXSELL CHARACTER VARYING(1) 1
32 MRKTPHONE CHARACTER VARYING(2) 2
33 ASSESSOR INTEGER 4
34 CAUSECDE CHARACTER VARYING(2) 2
35 AUTHDTE INTEGER 4
36 AUTHID CHARACTER VARYING(8) 8
37 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 RECORD_TYPE CHARACTER VARYING(16) 16
39 COMMIT_TIMESTAMP TIMESTAMP 8
40 EXTRACT_TIMESTAMP TIMESTAMP 8
41 CDC_ID BIGINT 8
42 COMPANY_CDC SMALLINT 2
43 POLICY_CDC BIGINT 8
44 DW_TIMESTAMP TIMESTAMP 8