PRT_LIACTAIL

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 TRANCNT SMALLINT 2
6 EFFECTDTE INTEGER 4
7 ACTIVTO INTEGER 4
8 IMAGEFLAG CHARACTER VARYING(1) 1
9 ISALIACDE CHARACTER VARYING(4) 4
10 ANZSICCDE CHARACTER VARYING(4) 4
11 APRAOCCDE CHARACTER VARYING(6) 6
12 TERLIMIT CHARACTER VARYING(1) 1
13 PRIMWORD CHARACTER VARYING(1) 1
14 PRIMLOI NUMERIC(11,0) 19
15 GENLIALOI NUMERIC(11,0) 19
16 PRDLIALOI NUMERIC(11,0) 19
17 WORDTYP CHARACTER VARYING(2) 2
18 UWCATG CHARACTER VARYING(2) 2
19 RATEMETH CHARACTER VARYING(2) 2
20 FACTORNO NUMERIC(4,2) 19
21 TURNOVER NUMERIC(11,0) 19
22 ASSETS NUMERIC(11,0) 19
23 WAGES NUMERIC(11,0) 19
24 PROFFEES NUMERIC(11,0) 19
25 STAFFCNT INTEGER 4
26 POLLTOC CHARACTER VARYING(1) 1
27 POLLLOI NUMERIC(11,0) 19
28 POLLINDX CHARACTER VARYING(2) 2
29 ASBSTEXCL CHARACTER VARYING(1) 1
30 EXPORT CHARACTER VARYING(1) 1
31 NTHAMLOI NUMERIC(11,0) 19
32 WRKEREXCL CHARACTER VARYING(1) 1
33 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 RECORD_TYPE CHARACTER VARYING(16) 16
35 COMMIT_TIMESTAMP TIMESTAMP 8
36 EXTRACT_TIMESTAMP TIMESTAMP 8
37 CDC_ID BIGINT 8
38 COMPANY_CDC SMALLINT 2
39 POLICY_CDC BIGINT 8
40 ACTIVTO_CDC DATE 4
41 EFFECTDTE_CDC DATE 4
42 DW_TIMESTAMP TIMESTAMP 8
43 FEESPERC SMALLINT 2
44 FEESLASTYR NUMERIC(11,0) 19
45 FEESTHISYR NUMERIC(11,0) 19
46 FEESFORECST NUMERIC(11,0) 19
47 FEESAVG NUMERIC(11,0) 19
48 STAFFFULL INTEGER 4
49 STAFFPART INTEGER 4
50 RATEPERC SMALLINT 2
51 MARKCAP NUMERIC(11,0) 19
52 PUBLICCOY CHARACTER VARYING(1) 1
53 LIMITTYPE CHARACTER VARYING(1) 1
54 NOOFREINS SMALLINT 2
55 MAXAGGRLIM NUMERIC(11,0) 19
56 JURLIMIT CHARACTER VARYING(1) 1
57 NTHAMFLAG CHARACTER VARYING(1) 1
58 NTHAMEMPL INTEGER 4
59 NTHAMASSETS NUMERIC(11,0) 19
60 CONTTYPE CHARACTER VARYING(2) 2
61 CONTDATE INTEGER 4
62 RETROTYPE CHARACTER VARYING(1) 1
63 RETRODATE INTEGER 4
64 CRMRETTYPE CHARACTER VARYING(2) 2
65 CRMRETDATE INTEGER 4
66 LEADINSCOY CHARACTER VARYING(4) 4
67 REVSPLIT01 NUMERIC(5,2) 19
68 REVSPLIT02 NUMERIC(5,2) 19
69 REVSPLIT03 NUMERIC(5,2) 19
70 REVSPLIT04 NUMERIC(5,2) 19
71 REVSPLIT05 NUMERIC(5,2) 19
72 REVSPLIT06 NUMERIC(5,2) 19
73 REVSPLIT07 NUMERIC(5,2) 19
74 REVSPLIT08 NUMERIC(5,2) 19
75 REVSPLIT99 NUMERIC(5,2) 19
76 STAFFFTE NUMERIC(7,1) 19