INT_CI_ASSESSMENT_ITEM

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ASSESSMENT_BUILDING_ITEM_CATEGORY_ID BIGINT 8
2 ASSESSMENT_BUILDING_ITEM_ID BIGINT 8
3 ASSESSMENT_BUILDING_ITEM_DESCRIPTION CHARACTER VARYING(255) 255
4 ASSESSMENT_BUILDING_ITEM_ACTION_ID BIGINT 8
5 ASSESSMENT_BUILDING_ITEM_COUNT BIGINT 8
6 ASSESSMENT_BUILDING_ITEM_ESTIMATE_AMOUNT NUMERIC(18,2) 19
7 ASSESSMENT_BUILDING_ITEM_COMMENT CHARACTER VARYING(255) 255
8 ASSESSMENT_BUILDING_ITEM_SERVICE_PROVIDER_ID BIGINT 8
9 ASSESSMENT_BUILDING_ITEM_EXPOSURE_NUMBER CHARACTER VARYING(40) 40
10 ASSESSMENT_BUILDING_ITEM_EXPOSURE_COVERAGE_TYPE_ID BIGINT 8
11 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE TIMESTAMP 8
12 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_LBL CHARACTER VARYING(30) 30
13 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_ID INTEGER 4
14 ASSESSMENT_BUILDING_ITEM_CREATE_DATE TIMESTAMP 8
15 ASSESSMENT_BUILDING_ITEMCREATE_DATE_LBL CHARACTER VARYING(30) 30
16 ASSESSMENT_BUILDING_ITEMCREATE_DATE_ID INTEGER 4
17 ASSESSMENT_BUILDING_ITEM_CREATE_USER_ID BIGINT 8
18 ASSESSMENT_BUILDING_ITEM_EXPOSURE_ID BIGINT 8
19 ASSESSMENT_BUILDING_ITEM_ASSESSMENT_SOURCE_ID BIGINT 8
20 ASSESSMENT_BUILDING_ITEM_INCIDENT_ID BIGINT 8
21 ASSESSMENT_BUILDING_ITEM_SALVAGE_POSSIBILITY_FLAG BIGINT 8