PRT_PGTAIL

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 PGPREMISE CHARACTER VARYING(1) 1
10 PGEXTGLS CHARACTER VARYING(1) 1
11 PGEXSQMTR SMALLINT 2
12 PGINTGLS CHARACTER VARYING(1) 1
13 PGINSQMTR SMALLINT 2
14 PGTEMSHUT SMALLINT 2
15 PGREFRAME SMALLINT 2
16 PGSGNTAPE SMALLINT 2
17 PGSTCKDES SMALLINT 2
18 PGTOUGH CHARACTER VARYING(1) 1
19 PGTRIPLEX CHARACTER VARYING(1) 1
20 PGBENT CHARACTER VARYING(1) 1
21 PGSTAIN CHARACTER VARYING(1) 1
22 PGADVERT SMALLINT 2
23 PGBASINS CHARACTER VARYING(1) 1
24 PGSHOWFRM SMALLINT 2
25 PGREMDEB SMALLINT 2
26 PGSPECIFY CHARACTER VARYING(1) 1
27 PGMLTDISC CHARACTER VARYING(2) 2
28 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 RECORD_TYPE CHARACTER VARYING(16) 16
30 COMMIT_TIMESTAMP TIMESTAMP 8
31 EXTRACT_TIMESTAMP TIMESTAMP 8
32 CDC_ID BIGINT 8
33 COMPANY_CDC SMALLINT 2
34 POLICY_CDC BIGINT 8
35 ACTIVTO_CDC DATE 4
36 EFFECTDTE_CDC DATE 4
37 DW_TIMESTAMP TIMESTAMP 8