FCM_DASHBOARDS_REGIONS

This table stores information about the areas within a dashboards. This includes the views (list, pivot, or chart) that re part of the dashboard

Details

Object type: TABLE

Primary Key

Name	Columns
FCM_DASHBOARDS_REGIONS_PK	REGION_ID, DASHBOARD_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
REGION_ID	NUMBER		18	0	No	ID of the dashboard region
DASHBOARD_ID	NUMBER		18	0	No	ID of the dashboard
REGION_INFO	CLOB				Yes	JSON information of the dashboard region
POSITION	NUMBER		3	0	No	Position of the region in the dashboard. Valid values are 1,2,3 or 4)
TITLE	VARCHAR2	255			Yes	Title of the dashboard region
FILTER_ID	NUMBER		18	0	Yes	ID of the filter created on the dashboard region
DATA_SOURCE	VARCHAR2	64				Data source on which the region is based
OBJECT_VERSION_NUMBER	NUMBER		9		No	Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried
LAST_UPDATED_BY	VARCHAR2	225			No	Who column. Stores the ID of the user who last updated this row.
LAST_UPDATE_DATE	DATE				No	Who column. Stores the date when this row was last updated.
CREATED_BY	VARCHAR2	225			No	Who column. Stores the ID of the user who created this row.
CREATION_DATE	DATE				No	Who column. Stores the date when this row was created in the database.