CSO_CHANNEL
This table contains the meta information that defines the behaviors and properties of a content channel.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CSO_CHANNEL_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| VALIDATE_HTML | CHAR | 1 | Flag indicating if the HTML should be validated in this channel. | |
| ASSOCIABLE | CHAR | 1 | Flag indicating if the content channel can be associated with another channel, used only for SYSTEM channels. | |
| DATE_ADDED | TIMESTAMP | Yes | This is the date that the record was added to the repository. | |
| DATE_MODIFIED | TIMESTAMP | Yes | This is the date that the record was modified. | |
| 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. |
| LOOKUP_CODE_ID | VARCHAR2 | 32 | Yes | This column Defines the channel type. |
| MODERATED | CHAR | 1 | Yes | flag indicating whether the threaded discussions associated with the channel are moderated prior to publication. |
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
| STRIPE_CD | VARCHAR2 | 30 | Lookup code that indicates the stripe code. | |
| REFERENCE_KEY | VARCHAR2 | 100 | Yes | Locale independent name used to uniquely identify a content channel. |
| SITE_ID | VARCHAR2 | 32 | This is the GUID for the repository that the record belongs to | |
| VALID_TIME_FRAME | NUMBER | This is the number of days a content record is valid before it is required to be reviewed. | ||
| IS_EVENT | CHAR | 1 | Flag indicating if the content channel supports event calendars. | |
| SURVEY_ID | VARCHAR2 | 32 | This is the GUID of the rating associated with the content channel. | |
| HAS_TALK_BACK | CHAR | 1 | Flag indicating whether or not the channel supports threaded discussions. | |
| NUMBER_OF_VERSIONS | NUMBER | Maximum number of versions to maintain, if set to null or zero all versions are maintained. | ||
| REMOVE_VERSIONS | CHAR | 1 | Flag indicating whether or nor any minor versions are removed when the content record is published. | |
| HAS_PRIORITY | CHAR | 1 | Flag indicating whether or not the channel supports setting the priority level of a content record in the channel. | |
| HAS_RELATED_CONTENT | CHAR | 1 | Flag indicating if the channel has related content enabled. | |
| APPROVE_WORKFLOW_MAIL | CHAR | 1 | Flag indicating if an email should be generated if a workflow step is completed. | |
| REJECT_WORKFLOW_MAIL | CHAR | 1 | Flag indicating if an email should be sent if a workflow step is rejected. | |
| REJECT_MAIL_TO_GROUP | CHAR | 1 | Flag indicating if an email should be sent to the group if a workflow step is rejected. | |
| ALLOW_CHECKOUT | CHAR | 1 | Flag indicating if the channel allows multi-user content editing | |
| TRACK_USER_ACTIVITY | CHAR | 1 | Flag indicating if the contentuser activity log should be maintained for the channel. | |
| COUNTER | NUMBER | Counter for the document id functionality. | ||
| COUNTER_PREFIX | VARCHAR2 | 50 | The prefix for the document counter. | |
| PROPERTIES_TO_DISPLAY | NUMBER | binary number representing the content channel attributes that are displayed on the properties page. | ||
| REVIEW_DATE | NUMBER | This is the number of days after publication when the content record is scheduled for its next review. | ||
| WORKFLOW_ID | VARCHAR2 | 32 | This is the Reference to the workflow process associated with this channel. | |
| ALLOW_RECOMMENDATIONS | CHAR | 1 | Flag to indicate if content recommendations are enabled for this channel. | |
| ENABLE_INDEXING | CHAR | 1 | Yes | Flag indicating if Oracle Knowledge Search is allowed to crawl this channel. |
| EXTEND_REVIEW_DATE | CHAR | 1 | Flag indicating if to extend the review date by the default number of days when an article is marked as reviewed. | |
| INDEX_STATUS | VARCHAR2 | 50 | Yes | A value which indicates the status of the documents to be crawled/index by Oracle Knowledge Search (e.g: PUBLISHED, IN_PROCESS, ALL, NONE). |
| 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_CHANNEL | cso_lookup_code | LOOKUP_CODE_ID |
| CSO_CHANNEL | cso_survey | SURVEY_ID |
| CSO_CHANNEL | cso_site | SITE_ID |
| CSO_CHANNEL | cso_workflow | WORKFLOW_ID |
| cso_channel_assoc | cso_channel | PARENT_ID |
| cso_channel_assoc | cso_channel | SUBORDINATE_ID |
| cso_channel_privilege | cso_channel | CONTENT_CHANNEL_ID |
| cso_bulk_update_doc_detail | cso_channel | CONTENT_CHANNEL_ID |
| cso_channel_res | cso_channel | CONTENT_CHANNEL_ID |
| cso_subscription | cso_channel | CHANNEL_ID |
| cso_query | cso_channel | CONTENT_CHANNEL_ID |
| cso_content_autosave | cso_channel | CONTENT_CHANNEL_ID |
| cso_c_batch_request | cso_channel | CHANNEL_ID |
| cso_channel_metric_tag | cso_channel | CONTENT_CHANNEL_ID |
| cso_gsr_doc_detail | cso_channel | CONTENT_CHANNEL_ID |
| cso_channel_user_grps | cso_channel | CHANNEL_ID |
| cso_content | cso_channel | CONTENT_CHANNEL_ID |
| cso_channel_req_tag | cso_channel | CONTENT_CHANNEL_ID |
| cso_data_list | cso_channel | CONTENT_CHANNEL_ID |
| cso_translation_req_locale | cso_channel | CHANNEL_ID |
| cso_channel_tag | cso_channel | CONTENT_CHANNEL_ID |
| cso_site_content_channel | cso_channel | CONTENT_CHANNEL_ID |
| cso_channel_newsletter | cso_channel | CONTENT_CHANNEL_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_CHANNEL_N1 | Non Unique | Default | REFERENCE_KEY, SITE_ID |
| CSO_CHANNEL_N2 | Non Unique | Default | REFERENCE_KEY, RECORD_ID |
| CSO_CHANNEL_N3 | Non Unique | Default | LOOKUP_CODE_ID |
| CSO_CHANNEL_N4 | Non Unique | Default | SURVEY_ID |
| CSO_CHANNEL_N5 | Non Unique | Default | SITE_ID, REFERENCE_KEY |
| CSO_CHANNEL_N6 | Non Unique | Default | WORKFLOW_ID |
| CSO_CHANNEL_U1 | Unique | Default | RECORD_ID, ORA_SEED_SET1 |
| CSO_CHANNEL_U11 | Unique | Default | RECORD_ID, ORA_SEED_SET2 |