PRT_MINORIT

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 ACTIVFROM INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER(1) 1
9 LINENO SMALLINT 2
10 MINORDESC CHARACTER(200) 200
11 SUMINS INTEGER 4
12 EXCESS INTEGER 4
13 EXCESSTYP CHARACTER(1) 1
14 OPIND CHARACTER(1) 1
15 INDEXFLAG CHARACTER(1) 1
16 VOIDFLAG CHARACTER(1) 1
17 VOIDDATE INTEGER 4
18 YEAROVAL INTEGER 4
19 MINORTYP CHARACTER(2) 2
20 VALUATION CHARACTER(1) 1
21 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 RECORD_TYPE CHARACTER VARYING(16) 16
23 COMMIT_TIMESTAMP TIMESTAMP 8
24 EXTRACT_TIMESTAMP TIMESTAMP 8
25 CDC_ID BIGINT 8
26 DW_TIMESTAMP TIMESTAMP 8
27 COMPANY_CDC SMALLINT 2
28 POLICY_CDC INTEGER 4
29 ACTIVTO_CDC DATE 4
30 ACTIVFROM_CDC DATE 4
31 AGREEMENT_TYPE_CDC CHARACTER(3) 3