PRT_SLTAIL

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 SLGENLIAB NUMERIC(11,0) 19
10 SLPRDLIAB NUMERIC(11,0) 19
11 SLROCCUP CHARACTER VARYING(4) 4
12 SLSICCODE CHARACTER VARYING(3) 3
13 SLRATEMTH CHARACTER VARYING(2) 2
14 SLFACTNO INTEGER 4
15 SLWAGES NUMERIC(11,0) 19
16 SLTURNOVR NUMERIC(11,0) 19
17 SLCONTAMT NUMERIC(11,0) 19
18 SLCVRTYPE CHARACTER VARYING(2) 2
19 SLTOCPOLT CHARACTER VARYING(1) 1
20 SLLOIPOLT NUMERIC(11,0) 19
21 SLNODIR SMALLINT 2
22 SLTOTASS NUMERIC(11,0) 19
23 SLTOTLIAB NUMERIC(11,0) 19
24 SLLOICO NUMERIC(11,0) 19
25 SLLOIIND NUMERIC(11,0) 19
26 SLPUBINSR CHARACTER VARYING(20) 20
27 SLPUBPOL CHARACTER VARYING(20) 20
28 SLPUBLOI NUMERIC(11,0) 19
29 SLPRDINSR CHARACTER VARYING(20) 20
30 SLPRDPOL CHARACTER VARYING(20) 20
31 SLPRDLOI NUMERIC(11,0) 19
32 SLMOTINSR CHARACTER VARYING(20) 20
33 SLMOTPOL CHARACTER VARYING(20) 20
34 SLMOTLOI NUMERIC(11,0) 19
35 SLWKRINSR CHARACTER VARYING(20) 20
36 SLWKRPOL CHARACTER VARYING(20) 20
37 SLWKRLOI NUMERIC(11,0) 19
38 SLMARINSR CHARACTER VARYING(20) 20
39 SLMARPOL CHARACTER VARYING(20) 20
40 SLMARLOI NUMERIC(11,0) 19
41 SLAVNINSR CHARACTER VARYING(20) 20
42 SLAVNPOL CHARACTER VARYING(20) 20
43 SLAVNLOI NUMERIC(11,0) 19
44 SLOTHINSR CHARACTER VARYING(20) 20
45 SLOTHPOL CHARACTER VARYING(20) 20
46 SLOTHLOI NUMERIC(11,0) 19
47 SLUWINFO CHARACTER VARYING(212) 212
48 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
49 RECORD_TYPE CHARACTER VARYING(16) 16
50 COMMIT_TIMESTAMP TIMESTAMP 8
51 EXTRACT_TIMESTAMP TIMESTAMP 8
52 CDC_ID BIGINT 8
53 COMPANY_CDC SMALLINT 2
54 POLICY_CDC BIGINT 8
55 ACTIVTO_CDC DATE 4
56 EFFECTDTE_CDC DATE 4
57 DW_TIMESTAMP TIMESTAMP 8