PRT_ISRTAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER VARYING(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 EFFECTDTE INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER VARYING(1) 1
9 ISMDDECLT NUMERIC(11,0) 19
10 ISMDDECLC NUMERIC(11,0) 19
11 ISMDLIABT NUMERIC(11,0) 19
12 ISMDLIABC NUMERIC(11,0) 19
13 ISMDPRM NUMERIC(11,2) 19
14 ISMDX INTEGER 4
15 ISCLDECLT NUMERIC(11,0) 19
16 ISCLDECLC NUMERIC(11,0) 19
17 ISCLLIABT NUMERIC(11,0) 19
18 ISCLLIABC NUMERIC(11,0) 19
19 ISCLPRM NUMERIC(11,2) 19
20 ISCLX INTEGER 4
21 ISLIABT NUMERIC(11,0) 19
22 ISLIABC NUMERIC(11,0) 19
23 ISLIABPRM NUMERIC(11,2) 19
24 ISLIABX INTEGER 4
25 ISTHEFTT NUMERIC(11,0) 19
26 ISTHEFTC NUMERIC(11,0) 19
27 ISTHEFTX INTEGER 4
28 ISMONEYT NUMERIC(11,0) 19
29 ISMONEYC NUMERIC(11,0) 19
30 ISMONEYX INTEGER 4
31 ISSPDAMT NUMERIC(11,0) 19
32 ISSPDAMC NUMERIC(11,0) 19
33 ISSPDAMX INTEGER 4
34 ISRMVDEBS CHARACTER VARYING(1) 1
35 ISRMVDEBT NUMERIC(11,0) 19
36 ISRMVDEBC NUMERIC(11,0) 19
37 ISRMVDEBX INTEGER 4
38 ISREINSTS CHARACTER VARYING(1) 1
39 ISREINSTT NUMERIC(11,0) 19
40 ISREINSTC NUMERIC(11,0) 19
41 ISREINSTX INTEGER 4
42 ISPRPCSTS CHARACTER VARYING(1) 1
43 ISPRPCSTT NUMERIC(11,0) 19
44 ISPRPCSTC NUMERIC(11,0) 19
45 ISPRPCSTX INTEGER 4
46 ISCSTWRKS CHARACTER VARYING(1) 1
47 ISCSTWRKT NUMERIC(11,0) 19
48 ISCSTWRKC NUMERIC(11,0) 19
49 ISCSTWRKX INTEGER 4
50 ISPYWKS1 SMALLINT 2
51 ISPYWKS2P SMALLINT 2
52 ISPYWKS2 SMALLINT 2
53 ISCONSOL SMALLINT 2
54 ISFLOODLD CHARACTER VARYING(2) 2
55 ISPREMIS CHARACTER VARYING(1) 1
56 ISPREMISX SMALLINT 2
57 ISUTIL CHARACTER VARYING(1) 1
58 ISUTILHRS SMALLINT 2
59 ISFLOAT NUMERIC(11,0) 19
60 ISINTWRD CHARACTER VARYING(1) 1
61 ISADDCOV CHARACTER VARYING(1) 1
62 FRROCCUP CHARACTER VARYING(4) 4
63 RICNSTR CHARACTER VARYING(1) 1
64 ISINDEMPE SMALLINT 2
65 UWPOINTS CHARACTER VARYING(3) 3
66 UWCATG CHARACTER VARYING(2) 2
67 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
68 RECORD_TYPE CHARACTER VARYING(16) 16
69 COMMIT_TIMESTAMP TIMESTAMP 8
70 EXTRACT_TIMESTAMP TIMESTAMP 8
71 CDC_ID BIGINT 8
72 COMPANY_CDC SMALLINT 2
73 POLICY_CDC BIGINT 8
74 ACTIVTO_CDC DATE 4
75 EFFECTDTE_CDC DATE 4
76 DW_TIMESTAMP TIMESTAMP 8