ATK_KRH_CONFIG

Details

Schema: FUSION
Object owner: ATK
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
ATK_KRH_CONFIG_PK	CONFIG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ENTERPRISE_ID	NUMBER		18	Yes	Tenant Enterprise Id
LOGO_FILE_NAME	VARCHAR2	255			CUSTOM_FILE_NAME
CONFIG_ID	NUMBER		18	Yes	Configuration Identifier.
TECH_LIBRARY_URL	VARCHAR2	2000			This is the URL to the Apps Technology Library.
SITEMAP_HIERARCHY_TYPE	VARCHAR2	4			Specifies the hierarchy that is displayed on the Site Map. This hiearchy must contain all topics so that external crawlers can find them via the site map.
DISCUSSION_FORUM_ENABLED	VARCHAR2	1		Yes	DISCUSSION_FORUM_ENABLED
ANNOUNCEMENT_ENABLED	VARCHAR2	1		Yes	ANNOUNCEMENT_ENABLED
CUSTOMER_FORUM_ENABLED	VARCHAR2	1		Yes	CUSTOMER_FORUM_ENABLED
ORACLE_UNIV_ENABLED	VARCHAR2	1		Yes	ORACLE_UNIV_ENABLED
HELP_ENABLED	VARCHAR2	1		Yes	HELP_ENABLED
PRIVACY_STMT_URL	VARCHAR2	2000			The Privacy Statement URL
INCLUDE_UPK	VARCHAR2	1			This flag indicates if the UOK Link should be displayed in the Page or not
DEFAULT_CONTENT_LOCATION	VARCHAR2	2000			The Directory where the Custom Contents can be uploaded from.
URL	VARCHAR2	2000			The UPK URL
REMOTE_HELP_PORTAL_FLAG	VARCHAR2	1		Yes	This flag indicates where the help portal resides. If set to Yes, the usage is through the central, hosted environment accessed remotely over the internet. If set to No, indicates the usage of local installation at customer site.
REMOTE_USER_RATING_FLAG	VARCHAR2	1		Yes	This flag indicates if user ratings are stored centrally in hosted help portal or locally at customer site. Yes value for this flag is applicable only when REMOTE_HELP_PORTAL_FLAG is set to No at customer site. If REMOTE_HELP_PORTAL_FLAG is set to Yes, then this flag must be set to No.
UPK_WEBSERVER_AGENT	VARCHAR2	2000			UPK_WEBSERVER_AGENT
UPK_ALL_DEMO_URL	VARCHAR2	2000			UPK_ALL_DEMO_URL
LOGO	BLOB				LOGO
SECURE_CUSTOM_HELP	VARCHAR2	1		Yes	Enable data security on help topics. (Y/N)
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that 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.
ORACLE_SUPPORT_ENABLED	VARCHAR2	1		Yes	ORACLE_SUPPORT_ENABLED
CUSTOMER_FORUM_URL	VARCHAR2	2000			Customer Forum URL
ORACLE_UNIVERSITY_URL	VARCHAR2	2000			Oracle University URL
ORACLE_SUPPORT_URL	VARCHAR2	2000			Oracle Support URL
HOME_BCKGRD_IMAGE	BLOB				This is the background image that gets displayed on help landing page.
HOME_BCKGRD_IMAGE_NAME	VARCHAR2	255			This is the name of the background image that gets displayed on help landing page.
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table	Foreign Table	Foreign Key Column
atk_krh_config_tl	atk_krh_config	CONFIG_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ATK_KRH_CONFIG_PK	Unique	Default	CONFIG_ID, ORA_SEED_SET1
ATK_KRH_CONFIG_PK1	Unique	Default	CONFIG_ID, ORA_SEED_SET2