PRT_LSTAIL

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 LSTUDSTKN INTEGER 4
10 LSTUDSTKM NUMERIC(11,0) 19
11 LSCATTLEN INTEGER 4
12 LSCATTLEM NUMERIC(11,0) 19
13 LSBLDSTKN INTEGER 4
14 LSBLDSTKM NUMERIC(11,0) 19
15 LSHORSEN INTEGER 4
16 LSHORSEM NUMERIC(11,0) 19
17 LSSHEEPN INTEGER 4
18 LSSHEEPM NUMERIC(11,0) 19
19 LSGOATN INTEGER 4
20 LSGOATM NUMERIC(11,0) 19
21 LSPIGN INTEGER 4
22 LSPIGM NUMERIC(11,0) 19
23 LSOTHERN INTEGER 4
24 LSOTHERM NUMERIC(11,0) 19
25 LSANIMAL CHARACTER VARYING(1) 1
26 LSUSE CHARACTER VARYING(1) 1
27 LSCVRTYPE CHARACTER VARYING(1) 1
28 LSBIRTHYR SMALLINT 2
29 LSTHEFT NUMERIC(11,0) 19
30 LSTRANSIT NUMERIC(11,0) 19
31 LSMULSECT CHARACTER VARYING(2) 2
32 LSDESC CHARACTER VARYING(132) 132
33 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 RECORD_TYPE CHARACTER VARYING(16) 16
35 COMMIT_TIMESTAMP TIMESTAMP 8
36 EXTRACT_TIMESTAMP TIMESTAMP 8
37 CDC_ID BIGINT 8
38 COMPANY_CDC SMALLINT 2
39 POLICY_CDC BIGINT 8
40 ACTIVTO_CDC DATE 4
41 EFFECTDTE_CDC DATE 4
42 DW_TIMESTAMP TIMESTAMP 8