INT_PI_HOME_CLAIM_STOCK_MOVEMENT_DETAIL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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