PRT_ISRASSET

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 ACTIVFROM INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER VARYING(1) 1
9 LINENO SMALLINT 2
10 RISKNO NUMERIC(6,0) 19
11 ADDRREF INTEGER 4
12 ISRDESC CHARACTER VARYING(30) 30
13 ISRVALUE NUMERIC(11,0) 19
14 FLTINDLOC CHARACTER VARYING(1) 1
15 FRROCCUP CHARACTER VARYING(4) 4
16 FRFLOATSI INTEGER 4
17 ISRBIVAL NUMERIC(11,0) 19
18 FRSPRNKLR CHARACTER VARYING(1) 1
19 FRSMOKDET CHARACTER VARYING(1) 1
20 FRALARM CHARACTER VARYING(1) 1
21 ISRCNSTR CHARACTER VARYING(2) 2
22 EMLPERC NUMERIC(7,4) 19
23 RIAREA CHARACTER VARYING(1) 1
24 RICNSTR CHARACTER VARYING(1) 1
25 COYBIVAL NUMERIC(11,0) 19
26 COYMDVAL NUMERIC(11,0) 19
27 LOCALSI NUMERIC(11,0) 19
28 UWPOINTS CHARACTER VARYING(3) 3
29 UWCATG CHARACTER VARYING(2) 2
30 KEYRISKIND CHARACTER VARYING(1) 1
31 SUBSIDNME CHARACTER VARYING(30) 30
32 FLOODIND CHARACTER VARYING(1) 1
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 DW_TIMESTAMP TIMESTAMP 8
42 MVREG CHARACTER(12) 12
43 MVMANUFYR SMALLINT 2
44 MODEL CHARACTER(60) 60
45 POSTCODE NUMERIC(6,0) 19
46 COVERTYPE CHARACTER(4) 4
47 REGION CHARACTER(2) 2
48 VEHTYPE CHARACTER(4) 4
49 MVCLASS CHARACTER(2) 2
50 NVIC CHARACTER(6) 6
51 VEHCAT CHARACTER(2) 2
52 EXCESS INTEGER 4
53 RISKSTATE SMALLINT 2