PRT_ITEMRISK

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 EFFECTDTE INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER(1) 1
9 LURN CHARACTER(38) 38
10 LURNSCALE CHARACTER(1) 1
11 LURNVERS INTEGER 4
12 PRODGRP CHARACTER(2) 2
13 ANZSICCD CHARACTER(8) 8
14 MINPRMAMT NUMERIC(11,2) 19
15 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 RECORD_TYPE CHARACTER VARYING(16) 16
17 COMMIT_TIMESTAMP TIMESTAMP 8
18 EXTRACT_TIMESTAMP TIMESTAMP 8
19 CDC_ID BIGINT 8
20 COMPANY_CDC SMALLINT 2
21 POLICY_CDC BIGINT 8
22 ACTIVTO_CDC DATE 4
23 AGREEMENT_TYPE_CDC CHARACTER(3) 3
24 EFFECTDTE_CDC DATE 4
25 DW_TIMESTAMP TIMESTAMP 8
26 OCCMINPREM NUMERIC(11,2) 19
27 MINPREREAS CHARACTER(2) 2
28 GNLONGTITUDE CHARACTER VARYING(20) 20
29 GNLATITUDE CHARACTER VARYING(20) 20
30 GNSTRTLONG CHARACTER VARYING(20) 20
31 GNSTRTLAT CHARACTER VARYING(20) 20
32 GNSBRBLONG CHARACTER VARYING(20) 20
33 GNSBRBLAT CHARACTER VARYING(20) 20
34 SUNLONG CHARACTER VARYING(20) 20
35 SUNLATITUDE CHARACTER VARYING(20) 20
36 GNLOCPID CHARACTER VARYING(15) 15
37 GNADDRPID CHARACTER VARYING(15) 15
38 GNSTRTPID CHARACTER VARYING(15) 15
39 GNMBCDE CHARACTER VARYING(15) 15
40 GNSA1 CHARACTER VARYING(11) 11
41 GNSA2 CHARACTER VARYING(9) 9
42 GNSA3 CHARACTER VARYING(5) 5
43 GNSA4 CHARACTER VARYING(3) 3
44 GNSTATE CHARACTER VARYING(2) 2
45 CAPERULEID NUMERIC(10,0) 19
46 PROPN01 NUMERIC(5,2) 19
47 PROPN02 NUMERIC(5,2) 19
48 PROPN03 NUMERIC(5,2) 19
49 PROPN04 NUMERIC(5,2) 19
50 PROPN05 NUMERIC(5,2) 19
51 PROPN06 NUMERIC(5,2) 19
52 PROPN07 NUMERIC(5,2) 19
53 PROPN08 NUMERIC(5,2) 19