PRT_BUSITAIL

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 OCCUPATN CHARACTER VARYING(4) 4
10 LOSSRATIO NUMERIC(11,2) 19
11 VOLEXCESS SMALLINT 2
12 RATESIZE INTEGER 4
13 INCOMESI INTEGER 4
14 ACCRECSI INTEGER 4
15 AICOWSI INTEGER 4
16 INDPERIOD CHARACTER VARYING(2) 2
17 CVRCOMB CHARACTER VARYING(1) 1
18 HISTRATE CHARACTER VARYING(4) 4
19 CLAIMCNT SMALLINT 2
20 RENTDCSI INTEGER 4
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 COMPANY_CDC SMALLINT 2
27 POLICY_CDC BIGINT 8
28 ACTIVTO_CDC DATE 4
29 EFFECTDTE_CDC DATE 4
30 DW_TIMESTAMP TIMESTAMP 8
31 TURNOVER INTEGER 4
32 BITYPE CHARACTER(3) 3
33 BITYPESI INTEGER 4
34 CLMPRPSI INTEGER 4
35 TURNRATE NUMERIC(6,5) 19