PRT_PAITAIL

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 TRANCNT SMALLINT 2
6 EFFECTDTE INTEGER 4
7 ACTIVTO INTEGER 4
8 IMAGEFLAG CHARACTER(1) 1
9 LOSSRATIO NUMERIC(11,2) 19
10 VOLEXCESS SMALLINT 2
11 ROLECLASS CHARACTER(4) 4
12 AGE SMALLINT 2
13 HEIGHT SMALLINT 2
14 WEIGHT SMALLINT 2
15 SMOKER CHARACTER(1) 1
16 AVGGRWKINC INTEGER 4
17 HISTRATE CHARACTER(4) 4
18 CLAIMCNT SMALLINT 2
19 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
20 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
21 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
22 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
23 CDC_ID BIGINT 8
24 COMPANY_CDC SMALLINT 2
25 POLICY_CDC BIGINT 8
26 ACTIVTO_CDC DATE 4
27 DW_TIMESTAMP TIMESTAMP 8