INT_PI_HOME_CLAIM_STOCK_MOVEMENT_DETAIL_BASE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_MONTH TIMESTAMP 8
2 CLAIM_ID BIGINT 8
3 STOCK_STATUS_FLAG CHARACTER VARYING(2) 2
4 ACTIVE_START_COUNT NUMERIC(38,0) 19
5 NEW_CLAIM_COUNT NUMERIC(38,0) 19
6 REOPEN_COUNT NUMERIC(38,0) 19
7 CLOSED_COUNT NUMERIC(38,0) 19
8 ACTIVE_END_COUNT NUMERIC(38,0) 19