INT_CI_WEEKLY_SNAPSHOT_HISTORY_DATA_BASE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 WEEK_ID BIGINT 8
2 NEW_EXPOSURE_COUNT NUMERIC(38,0) 19
3 REOPEN_EXPOSURE_COUNT NUMERIC(38,0) 19
4 CLOSED_EXPOSURE_COUNT NUMERIC(38,0) 19
5 ACTIVE_COUNT NUMERIC(38,0) 19
6 TEAM_NAME CHARACTER VARYING(100) 100
7 POLICY_NAME CHARACTER VARYING(256) 256
8 BRAND_NAME CHARACTER VARYING(256) 256
9 SIESCALATESIU_DESCRIPTION CHARACTER VARYING(256) 256
10 CATASTROPHE_DESCRIPTION CHARACTER VARYING(60) 60
11 LITIGATION_INDICATOR CHARACTER VARYING(3) 3