PRT_BUTAIL

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 BUSTKSI INTEGER 4
10 BUSTKVAL INTEGER 4
11 BUSTKSEAS INTEGER 4
12 BUCNTSI INTEGER 4
13 BUCNTVAL INTEGER 4
14 BUCIGSI INTEGER 4
15 BUCIGVAL INTEGER 4
16 BUCIGSEAS INTEGER 4
17 BUACNTSI INTEGER 4
18 BUACNTVAL INTEGER 4
19 BUACNTSS INTEGER 4
20 BUGOODSI INTEGER 4
21 BUGOODVAL INTEGER 4
22 BUAIRSI INTEGER 4
23 BUAIRVAL INTEGER 4
24 BUAIRSEAS INTEGER 4
25 BUDMGSI INTEGER 4
26 BUDMGSSI INTEGER 4
27 BUSPCSI INTEGER 4
28 BUSPCDESC CHARACTER VARYING(80) 80
29 BUROCCUP CHARACTER VARYING(4) 4
30 BURIOTS CHARACTER VARYING(1) 1
31 BUHOLDUP CHARACTER VARYING(1) 1
32 BUTHEFT CHARACTER VARYING(1) 1
33 BUSKYLT CHARACTER VARYING(1) 1
34 BUSKYLTTY CHARACTER VARYING(1) 1
35 BUTYWIND CHARACTER VARYING(1) 1
36 BUBARS CHARACTER VARYING(1) 1
37 BUDOORPRT CHARACTER VARYING(1) 1
38 BUDOORLCK CHARACTER VARYING(1) 1
39 BUALARM CHARACTER VARYING(2) 2
40 BUWATCHMN CHARACTER VARYING(1) 1
41 BUTYWINDP CHARACTER VARYING(1) 1
42 BULIQSI INTEGER 4
43 BULIQVAL INTEGER 4
44 BULIQSEAS INTEGER 4
45 BUMLTDISC CHARACTER VARYING(2) 2
46 BUSTKPC SMALLINT 2
47 BUCNTPC SMALLINT 2
48 BUCIGPC SMALLINT 2
49 BULIQPC SMALLINT 2
50 BUACNTPC SMALLINT 2
51 BUGOODPC SMALLINT 2
52 BUAIRPC SMALLINT 2
53 BUTOOLS INTEGER 4
54 BUFURNTRE INTEGER 4
55 BUTARGET CHARACTER VARYING(1) 1
56 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
57 RECORD_TYPE CHARACTER VARYING(16) 16
58 COMMIT_TIMESTAMP TIMESTAMP 8
59 EXTRACT_TIMESTAMP TIMESTAMP 8
60 CDC_ID BIGINT 8
61 COMPANY_CDC SMALLINT 2
62 POLICY_CDC BIGINT 8
63 ACTIVTO_CDC DATE 4
64 EFFECTDTE_CDC DATE 4
65 DW_TIMESTAMP TIMESTAMP 8