INT_GI_POLICY_EXPOSURE_NPT_WC

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COVERAGEKEY BIGINT 8
2 POLICY INTEGER 4
3 COMPANY INTEGER 4
4 PRODUCT CHARACTER VARYING(30) 30
5 ITEMNO INTEGER 4
6 TRANCNT INTEGER 4
7 INFORCEINCDATE DATE 4
8 INFORCEEXPDATE DATE 4
9 GLMONTH DATE 4
10 DELETEDTERM INTEGER 4
11 EXPOSMTH DATE 4
12 TGWP NUMERIC(15,2) 19
13 DAYSEXPOSEDTRANS INTEGER 4
14 DAYSEXPOSEDTERM INTEGER 4
15 EARNEDPREMTRANS NUMERIC(15,2) 19
16 EARNEDPREMGLTRANS NUMERIC(15,2) 19