PRT_FLTAIL

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 FLINDEMSI NUMERIC(11,0) 19
10 FLFFLOOD NUMERIC(11,0) 19
11 FLPRINCIP SMALLINT 2
12 FLEMPLOYS SMALLINT 2
13 FLOWNERS CHARACTER VARYING(1) 1
14 FLTYFARM CHARACTER VARYING(1) 1
15 FLAIRFLDS CHARACTER VARYING(1) 1
16 FLMLTDISC CHARACTER VARYING(2) 2
17 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 RECORD_TYPE CHARACTER VARYING(16) 16
19 COMMIT_TIMESTAMP TIMESTAMP 8
20 EXTRACT_TIMESTAMP TIMESTAMP 8
21 CDC_ID BIGINT 8
22 COMPANY_CDC SMALLINT 2
23 POLICY_CDC BIGINT 8
24 ACTIVTO_CDC DATE 4
25 EFFECTDTE_CDC DATE 4
26 DW_TIMESTAMP TIMESTAMP 8