PRT_FIDGTAIL

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 TERLIMIT CHARACTER VARYING(1) 1
12 PRIMWORD CHARACTER VARYING(1) 1
13 PRIMLOI NUMERIC(11,0) 19
14 EMPCNTCSH SMALLINT 2
15 EMPCNTOUT SMALLINT 2
16 EMPCNTOTH SMALLINT 2
17 EMPCNTNRP SMALLINT 2
18 EMPCNTTOT INTEGER 4
19 EMPLOI NUMERIC(11,0) 19
20 EMPTOTLOI NUMERIC(11,0) 19
21 BLNKTCVR CHARACTER VARYING(1) 1
22 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
23 RECORD_TYPE CHARACTER VARYING(16) 16
24 COMMIT_TIMESTAMP TIMESTAMP 8
25 EXTRACT_TIMESTAMP TIMESTAMP 8
26 CDC_ID BIGINT 8
27 COMPANY_CDC SMALLINT 2
28 POLICY_CDC BIGINT 8
29 ACTIVTO_CDC DATE 4
30 EFFECTDTE_CDC DATE 4
31 DW_TIMESTAMP TIMESTAMP 8