INT_CI_ASSESSMENT_CONTENT_ITEM

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ASSESSMENT_CONTENT_ITEM_CATEGORY_ID BIGINT 8
2 ASSESSMENT_CONTENT_ITEM_ID BIGINT 8
3 ASSESSMENT_CONTENT_ITEM_ACTION_ID BIGINT 8
4 ASSESSMENT_CONTENT_ITEM_DESCRIPTION CHARACTER VARYING(255) 255
5 ASSESSMENT_CONTENT_ITEM_SERVICE_PROVIDER_ID BIGINT 8
6 ASSESSMENT_CONTENT_ITEM_EXPOSURE_ID BIGINT 8
7 ASSESSMENT_CONTENT_ITEM_EXPOSURE_NUMBER CHARACTER VARYING(40) 40
8 ASSESSMENT_CONTENT_ITEM_EXPOSURE_COVERAGE_TYPE_ID BIGINT 8
9 ASSESSMENT_CONTENT_ITEM_UPDATE_DATE TIMESTAMP 8
10 ASSESSMENT_CONTENT_ITEM_UPDATE_DATE_ID INTEGER 4
11 ASSESSMENT_CONTENT_ITEM_CREATE_DATE TIMESTAMP 8
12 ASSESSMENT_CONTENT_ITEM_CREATE_DATE_ID INTEGER 4
13 ASSESSMENT_CONTENT_ITEM_CREATE_USER_ID BIGINT 8
14 ASSESSMENT_CONTENT_ITEM_NUMBER_OF_ITEM CHARACTER VARYING(20) 20
15 ASSESSMENT_CONTENT_ITEM_ASSESSMENT_SOURCE_ID BIGINT 8
16 ASSESSMENT_CONTENT_ITEM_COUNT BIGINT 8
17 ASSESSMENT_CONTENT_ITEM_AMOUNT NUMERIC(18,2) 19
18 ASSESSMENT_CONTENT_ITEM_DATE_ACQUIRED TIMESTAMP 8
19 ASSESSMENT_CONTENT_ITEM_COMMENT CHARACTER VARYING(255) 255
20 ASSESSMENT_CONTENT_ITEM_INCIDENT_ID BIGINT 8
21 ASSESSMENT_CONTENT_ITEM_SALVAGE_POSSIBILITY_FLAG BIGINT 8
22 ASSESSMENT_CONTENT_ITEM_BRAND CHARACTER VARYING(255) 255