INT_CI_WEEKLY_SNAPSHOT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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