1. Tables and Views for Sales and Fusion Service
  2. CSO_SCH_PURPOSE

CSO_SCH_PURPOSE

This table stores Search Purpose, also referred to as portlet, corresponding to display characteristics defined in the User Interface.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

CSO_SCH_PURPOSE_PK

RECORD_ID

Columns

Name Datatype Length Not-null Comments
CONFIG_CREATE_DATE TIMESTAMP This is the datetime when the config object was created (This value can be initially set by the user)
CONFIG_UPDATE_DATE TIMESTAMP This is the datetime when the config object was last modified (This value can be initially set by the user)
CREATE_USER_LOGIN VARCHAR2 255 This is the user that created the record.
DATE_ADDED TIMESTAMP Yes This is the datetime when the record was added.
DATE_MODIFIED TIMESTAMP Yes This is the datetime when the record was last modified.
DESCRIPTION VARCHAR2 4000 This is the description of the config object.
DISPLAY_AREA_ID VARCHAR2 32 Yes This is the Display area for this record.
DISPLAY_INDEX NUMBER Yes This is the Display index for this record.
ENABLED NUMBER Yes A boolean flag indicating whether the config object is enabled.
MAX_ANSS NUMBER Yes This is the Maximum number of answers.
MIN_SCORE NUMBER Yes This is the Minimum score of answers.
NOTES VARCHAR2 4000 These are the Notes for the config object.
PAGE_SIZE NUMBER Yes This is the Maximum number of answers per page.
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
REFERENCE_KEY VARCHAR2 255 Non localized reference key for the config object.
SAVE_MESSAGE VARCHAR2 255 This is the Commentary for saving the record.
TITLE VARCHAR2 4000 Yes This is the Title for this record.
TYPE VARCHAR2 50 Yes This is the type for this record.
UPDATE_USER_LOGIN VARCHAR2 255 This is the user that updated the record.
VERSION NUMBER This is the revision number for this record.
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.
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
cso_sch_man_ans cso_sch_purpose PURPOSE_ID

Indexes

Index Uniqueness Tablespace Columns
CSO_SCH_PURPOSE_U1 Unique Default RECORD_ID, ORA_SEED_SET1
CSO_SCH_PURPOSE_U11 Unique Default RECORD_ID, ORA_SEED_SET2