KDSH_DATA_SOURCES

This table defines the available Data Sources throughout the dashboard.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_USERS	USER_ID	CREATED_BY

Column Name	Null?	Data Type	Description
DATA_SOURCE_ID	NOT NULL	NUMBER	System-generated identifier
CREATION_DATE	NOT NULL	DATE	Date record was created
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
DATA_SOURCE_NAME	NOT NULL	VARCHAR2(80)
DESCRIPTION	NULLABLE	VARCHAR2(400)
SOURCE_TYPE_CODE	NULLABLE	VARCHAR2(30)
SOURCE	NULLABLE	VARCHAR2(100)
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
RESTRICT_ACCESS_FLAG	NOT NULL	VARCHAR2(1)
BASE_FROM_CLAUSE	NULLABLE	VARCHAR2(4000)
BASE_WHERE_CLAUSE	NULLABLE	CLOB
BASE_ORDER_BY_CLAUSE	NULLABLE	VARCHAR2(4000)
BASE_GROUP_BY_CLAUSE	NULLABLE	VARCHAR2(4000)
BASE_HAVING_CLAUSE	NULLABLE	VARCHAR2(4000)
ENTITY_LAST_UPDATE_DATE	NOT NULL	DATE	Date a record in the entity was last updated
TIMEOUT	NULLABLE	NUMBER
LIMIT_RESULTS_FLAG	NOT NULL	VARCHAR2(1)
USE_BIND_VARIABLES_FLAG	NOT NULL	VARCHAR2(1)
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)
USE_REPORTING_DB	NOT NULL	VARCHAR2(1)	Whether or not the portlet data source query is run against the reporting database

Index Name	Index Type	Sequence	Column Name
KDSH_DATA_SOURCES_U1	UNIQUE	1	DATA_SOURCE_ID
KDSH_DATA_SOURCES_U2	UNIQUE	1	DATA_SOURCE_NAME
SYS_C00109351815	UNIQUE	1	REFERENCE_CODE

This table uses no sequences.