CSO_CONTENT_TEXT
This table contains the meta data for each content record. It has all versions of all locales. The publishing dates, workflow steps, etc are all stored here. Each CONTENT record can have 1 or more CONTENTTEXT records associated with it. The CONTENT record is the master record.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_CONTENT_TEXT_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BASED_MAJOR_VERSION | NUMBER | If this record is a localized version, this field is the used to capture the major version of the record used to create this localized record. | |||
| BASED_MINOR_VERSION | NUMBER | If this record is a localized version, this field is the used to capture the minor version of the record used to create this localized record. | |||
| BASED_LOCALE_ID | VARCHAR2 | 32 | If this record is a localized version, this field is the used to capture the source locale used to create this localized record. | ||
| CONTENT_ID | VARCHAR2 | 32 | Yes | This is the Reference to content table record. | |
| DATE_ADDED | TIMESTAMP | Yes | This is the datetime that the record was added to the repository. | ||
| DATE_MODIFIED | TIMESTAMP | Yes | This is the datetime that the record was modified. | ||
| LAST_MODIFIED_DATE | TIMESTAMP | This is the datetime the content text was last edited that would affect subscription notifications. | |||
| INDEX_MASTER_IDENTIFIERS | VARCHAR2 | 4000 | Concatenated string composed of all of the channel attributes marked as the master identifier in the channel setup. The order of the fields is based on the the order in the content channel design. This data may be truncated if it is greater than the available length in the database. | ||
| LOCALE_ID | VARCHAR2 | 32 | Yes | The locale associated with the current record. | |
| MAJOR_VERSION | NUMBER | This is the main version number that indicates which version has been published. 1.x where 1 is the major version number. | |||
| MINOR_VERSION | NUMBER | The minor version number is an interim version that indicates work in process. The minor version number is incremented any time a change is made until publishing. At publication the minor version number is set to zero and the major version number is incremented to the next highest number. | |||
| OWNER_ID | VARCHAR2 | 32 | The obsolete GUID of the current owner of the document, this is not necessarily the same as the creator of the document. | ||
| OWNER_NAME | VARCHAR2 | 100 | de-normalized name of the document owner. | ||
| PRIORITY_ID | VARCHAR2 | 32 | This is the GUID reference to LOOKUP_CODE table containing the list of available priority codes. | ||
| DISPLAY_POSITION_ID | VARCHAR2 | 32 | This is the GUID reference to LOOKUP_CODE table containing the list of available display position codes. | ||
| PUBLISH_DATE | TIMESTAMP | This is the datetime when the record was published. | |||
| PUBLISHED | CHAR | 1 | Flag indicating that the record was published. | ||
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. | |
| USER_ID | VARCHAR2 | 32 | This is the obsolete GUID of the user associated with this record. | ||
| WF_STEP_ID | VARCHAR2 | 32 | This is the GUID reference to the workflow step that his record is currently at. Null indicates that the record is not in workflow at the moment. | ||
| REQUIRES_TRANSLATION | CHAR | 1 | Flag indicating if the record needs to be translated to another supported locale. The task functionality gives a better view as to which locales need to be translated. | ||
| ANSWERED | CHAR | 1 | Deprecated. Flag indicating if the record was moderated. Only applies if this record is a threaded discussion record and the channel has been marked as “requires moderation‿ | ||
| LATEST_VERSION | CHAR | 1 | Flag indicating whether or not this record is the latest version for the content record. This flag is maintained by IM as content is changed. | ||
| USER_NAME | VARCHAR2 | 100 | De-normalized username associated with the user login. | ||
| CREATE_DATE | TIMESTAMP | Datetime the record was originally created. This is primarily used if the content was imported from another system and the create date was captured in the import file. | |||
| CHECKED_OUT | CHAR | 1 | Flag indicating that the record was checked out for editing by another person. | ||
| CHECKED_OUT_BY_ID | VARCHAR2 | 32 | This is the obsolete GUID of the user that checked out the content record. | ||
| DISPLAY_END_DATE | TIMESTAMP | Yes | This is the datetime when the record is no longer valid to be viewed. The record may still be published but it will not be returned to the JSP tag library. | ||
| DISPLAY_START_DATE | TIMESTAMP | Yes | This is the date when the record is available to be viewed. The record can be published but if the start date is after the current date it will not be returned by the JSP tag library. | ||
| EVENT_END_DATE | TIMESTAMP | If the channel supports event calendars, then this column specifies the datetime the event is scheduled to end. | |||
| EVENT_START_DATE | TIMESTAMP | If the channel supports event calendars, then this column specifies the datetime the event is scheduled to start. | |||
| DOCUMENT_ID | VARCHAR2 | 50 | This is the Reference to content record's document id. | ||
| WFSTEP_NOTIFICATION_OVERRIDE | TIMESTAMP | Allows the content editor to override when the default workflow step notification email is sent. By default. | |||
| ALIAS_ID | VARCHAR2 | 32 | This is the GUID reference to a CONTENT record that is an alias to this content record. | ||
| PENDING | CHAR | 1 | Flag indicating that the record was published with a future display date and hence pending | ||
| ANSWER_ID | NUMBER | Yes | This is the comment for the column ANSWER_ID. | ||
| DISPLAY_REVIEW_DATE | TIMESTAMP | Datetime of the next scheduled review of the contenttext record. | |||
| ARTICLE_STATUS_ID | VARCHAR2 | 32 | This is the reference to the article status in the ARTICLE_STATUS table. | ||
| OWNER_PARTY_ID | NUMBER | 18 | The ID of the current owner of the document, this is not necessarily the same as the creator of the document. | ||
| USER_PARTY_ID | NUMBER | 18 | This is the ID of the user associated with this record. | ||
| CHECKED_OUT_BY_PARTY_ID | NUMBER | 18 | This is the ID of the user that checked out the content record. | ||
| BU_ORG_IDS_1 | NUMBER | 18 | Oracle internal use only. This column value indicates the Business Units assigned to this Article version. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_CONTENT_TEXT | cso_content | CONTENT_ID |
| CSO_CONTENT_TEXT | cso_locale | LOCALE_ID |
| CSO_CONTENT_TEXT | cso_lookup_code | PRIORITY_ID |
| CSO_CONTENT_TEXT | cso_workflow_step | WF_STEP_ID |
| CSO_CONTENT_TEXT | cso_article_status | ARTICLE_STATUS_ID |
| cso_content_text_user_grp | cso_content_text | CONTENT_TEXT_ID |
| cso_bulk_update_doc_detail | cso_content_text | CONTENT_TEXT_ID |
| cso_article_links | cso_content_text | SOURCE_CONTENT_TEXT_ID |
| cso_content_text_view | cso_content_text | CONTENT_TEXT_ID |
| cso_gsr_search_result | cso_content_text | CONTENT_TEXT_ID |
| cso_content_text_bu | cso_content_text | CONTENT_TEXT_ID |
| cso_content_autosave | cso_content_text | CONTENT_TEXT_ID |
| cso_content_history | cso_content_text | CONTENT_TEXT_ID |
| cso_content_text_pub | cso_content_text | CONTENT_TEXT_ID |
| cso_gsr_doc_detail | cso_content_text | CONTENT_TEXT_ID |
| cso_content_text_category | cso_content_text | CONTENT_TEXT_ID |
| cso_c_batch_document | cso_content_text | CONTENT_TEXT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_CONTENT_TEXT_N1 | Non Unique | Default | CHECKED_OUT |
| CSO_CONTENT_TEXT_N10 | Non Unique | Default | LATEST_VERSION, OWNER_PARTY_ID |
| CSO_CONTENT_TEXT_N11 | Non Unique | Default | USER_PARTY_ID |
| CSO_CONTENT_TEXT_N12 | Non Unique | Default | CONTENT_ID, LOCALE_ID, LATEST_VERSION |
| CSO_CONTENT_TEXT_N14 | Non Unique | Default | OWNER_PARTY_ID |
| CSO_CONTENT_TEXT_N15 | Non Unique | Default | PUBLISHED |
| CSO_CONTENT_TEXT_N16 | Non Unique | Default | DISPLAY_START_DATE |
| CSO_CONTENT_TEXT_N17 | Non Unique | Default | CONTENT_ID, LOCALE_ID, PUBLISHED |
| CSO_CONTENT_TEXT_N18 | Non Unique | Default | DATE_ADDED |
| CSO_CONTENT_TEXT_N19 | Non Unique | Default | PUBLISH_DATE |
| CSO_CONTENT_TEXT_N2 | Non Unique | Default | CHECKED_OUT_BY_PARTY_ID |
| CSO_CONTENT_TEXT_N20 | Non Unique | Default | ARTICLE_STATUS_ID |
| CSO_CONTENT_TEXT_N21 | Non Unique | Default | DOCUMENT_ID |
| CSO_CONTENT_TEXT_N22 | Non Unique | Default | INDEX_MASTER_IDENTIFIERS |
| CSO_CONTENT_TEXT_N23 | Non Unique | Default | CREATE_DATE |
| CSO_CONTENT_TEXT_N24 | Non Unique | Default | DISPLAY_END_DATE |
| CSO_CONTENT_TEXT_N25 | Non Unique | Default | DATE_MODIFIED |
| CSO_CONTENT_TEXT_N26 | Non Unique | Default | DISPLAY_REVIEW_DATE |
| CSO_CONTENT_TEXT_N27 | Non Unique | Default | LAST_MODIFIED_DATE |
| CSO_CONTENT_TEXT_N28 | Non Unique | Default | ANSWER_ID |
| CSO_CONTENT_TEXT_N4 | Non Unique | Default | LATEST_VERSION, LOCALE_ID, CONTENT_ID |
| CSO_CONTENT_TEXT_N5 | Non Unique | Default | LATEST_VERSION, CONTENT_ID, LOCALE_ID |
| CSO_CONTENT_TEXT_N6 | Non Unique | Default | LOCALE_ID, LATEST_VERSION, CONTENT_ID |
| CSO_CONTENT_TEXT_N7 | Non Unique | Default | PRIORITY_ID |
| CSO_CONTENT_TEXT_N8 | Non Unique | Default | WF_STEP_ID |
| CSO_CONTENT_TEXT_N9 | Non Unique | Default | LATEST_VERSION, USER_PARTY_ID, LOCALE_ID, CONTENT_ID |
| CSO_CONTENT_TEXT_U1 | Unique | Default | RECORD_ID |
| CSO_CONTENT_TEXT_UK1 | Unique | Default | CONTENT_ID, LOCALE_ID, MAJOR_VERSION, MINOR_VERSION |
| CSO_CONTENT_TEXT_UK2 | Unique | Default | RECORD_ID, LATEST_VERSION, LOCALE_ID, CONTENT_ID, MAJOR_VERSION, MINOR_VERSION |
| CSO_CONTENT_TEXT_UK3 | Unique | Default | RECORD_ID, LATEST_VERSION, LOCALE_ID, CONTENT_ID, DATE_ADDED |