CSO_LOCALE
This table contains a list of supported locales in the IM repository.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CSO_LOCALE_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| SPELL_CHECKING_SUPPORT | CHAR | 1 | Flag indicating if InfoManager supports spell-checking for this locale. | |
| ACTIVE | CHAR | 1 | Yes | Flag indicating if the locale is active and available in the IM repository. |
| DATE_ADDED | TIMESTAMP | Yes | This is the date that the record was added to the repository. | |
| DATE_FORMAT | VARCHAR2 | 50 | This is the date format that should be used to format date for this locale (Java format) | |
| DATE_FORMAT_DISPLAY | VARCHAR2 | 50 | The format display string used to display date on the output to end user. | |
| DATE_MODIFIED | TIMESTAMP | Yes | This is the date that the record was modified. | |
| GROUP_DEFAULT | CHAR | 1 | Flag indicating if this locale is the default locale for a locale group for example en_us may be the default locale for the english group. | |
| LANGUAGE_ID | VARCHAR2 | 32 | Yes | This is the Language ID for this locale. |
| FUSION_LANGUAGE_CODE | VARCHAR2 | 32 | Oracle Fusion language abbreviations. | |
| LOCALE_CODE | VARCHAR2 | 64 | ISA code or other identifier for the locale. | |
| LOCALE_DESC | VARCHAR2 | 1000 | This is the Localized name of the locale. | |
| LOCALE_VALUE | NUMBER | Numeric value that can be used to describe a locale. | ||
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
| EXTERNAL_ID | NUMBER | ID used for integrating with external systems. | ||
| TIME_FORMAT | VARCHAR2 | 50 | The desired time format for the locale. | |
| TIME_FORMAT_DISPLAY | VARCHAR2 | 50 | The desired time format for the locale for display purposes. | |
| ENCODING | VARCHAR2 | 64 | Desired character encoding for the locale. | |
| 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_LOCALE | cso_language | LANGUAGE_ID |
| cso_db_locale | cso_locale | LOCALE_ID |
| cso_sch_dom_res | cso_locale | LOCALE_ID |
| cso_sch_cxt_var_res | cso_locale | LOCALE_ID |
| cso_event_res | cso_locale | LOCALE_ID |
| cso_stylesheet_res | cso_locale | LOCALE_ID |
| cso_schema_attribute_res | cso_locale | LOCALE_ID |
| cso_bulk_update_doc_detail | cso_locale | LOCALE_ID |
| cso_sch_req_use_case_rres | cso_locale | LOCALE_ID |
| cso_xml_schema_res | cso_locale | LOCALE_ID |
| cso_lookup_code_res | cso_locale | LOCALE_ID |
| cso_discussion_board_res | cso_locale | LOCALE_ID |
| cso_query_res | cso_locale | LOCALE_ID |
| cso_channel_res | cso_locale | LOCALE_ID |
| cso_db_forum_res | cso_locale | LOCALE_ID |
| cso_subscription | cso_locale | LOCALE_ID |
| cso_work_team_res | cso_locale | LOCALE_ID |
| cso_stylesheet | cso_locale | LOCALE_ID |
| cso_workflow_res | cso_locale | LOCALE_ID |
| cso_data_list_res | cso_locale | LOCALE_ID |
| cso_notification | cso_locale | LOCALE_ID |
| cso_user_locale | cso_locale | LOCALE_ID |
| cso_newsletter_res | cso_locale | LOCALE_ID |
| cso_sch_con_res | cso_locale | LOCALE_ID |
| cso_content_autosave | cso_locale | LOCALE_ID |
| cso_privilege_res | cso_locale | LOCALE_ID |
| cso_user_information | cso_locale | LOCALE_ID |
| cso_wf_cond_locales | cso_locale | LOCALE_ID |
| cso_content_text | cso_locale | LOCALE_ID |
| cso_survey_result | cso_locale | LOCALE_ID |
| cso_reputation_level_res | cso_locale | LOCALE_ID |
| cso_survey_question_res | cso_locale | LOCALE_ID |
| cso_sch_clus_res | cso_locale | LOCALE_ID |
| cso_content_text_pub | cso_locale | LOCALE_ID |
| cso_site | cso_locale | LOCALE_ID |
| cso_sch_man_ans_res | cso_locale | LOCALE_ID |
| cso_content_locale_request | cso_locale | LOCALE_ID |
| cso_gsr_doc_detail | cso_locale | LOCALE_ID |
| cso_c_batch_locale_owner | cso_locale | LOCALE_ID |
| cso_sch_int_hiernd_res | cso_locale | LOCALE_ID |
| cso_content | cso_locale | LOCALE_ID |
| cso_sch_int_res | cso_locale | LOCALE_ID |
| cso_replacement_tokens | cso_locale | LOCALE_ID |
| cso_role_res | cso_locale | LOCALE_ID |
| cso_c_batch_document | cso_locale | LOCALE_ID |
| cso_content_association | cso_locale | SOURCE_LOCALE_ID |
| cso_content_association | cso_locale | RELATED_LOCALE_ID |
| cso_data_list_item_res | cso_locale | LOCALE_ID |
| cso_sch_alias_list_res | cso_locale | LOCALE_ID |
| cso_db_topic | cso_locale | LOCALE_ID |
| cso_translation_req_locale | cso_locale | LOCALE_ID |
| cso_sch_man_ans_col_res | cso_locale | LOCALE_ID |
| cso_site_locale | cso_locale | LOCALE_ID |
| cso_workflow_step_res | cso_locale | LOCALE_ID |
| cso_site_res | cso_locale | LOCALE_ID |
| cso_gsr_request_locale | cso_locale | LOCALE_ID |
| cso_survey_answer_res | cso_locale | LOCALE_ID |
| cso_secured_activity_res | cso_locale | LOCALE_ID |
| cso_user_attributes | cso_locale | LOCALE_ID |
| cso_article_status_res | cso_locale | LOCALE_ID |
| cso_localized_tokens | cso_locale | LOCALE_ID |
| cso_sch_prof_res | cso_locale | LOCALE_ID |
| cso_survey_res | cso_locale | LOCALE_ID |
| cso_tag_res | cso_locale | LOCALE_ID |
| cso_db_message | cso_locale | LOCALE_ID |
| cso_lookup_category_res | cso_locale | LOCALE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_LOCALE_N1 | Non Unique | Default | LOCALE_CODE, RECORD_ID, DATE_FORMAT, TIME_FORMAT |
| CSO_LOCALE_N2 | Non Unique | Default | LANGUAGE_ID |
| CSO_LOCALE_N3 | Non Unique | Default | FUSION_LANGUAGE_CODE, RECORD_ID |
| CSO_LOCALE_U1 | Unique | Default | RECORD_ID, ORA_SEED_SET1 |
| CSO_LOCALE_U11 | Unique | Default | RECORD_ID, ORA_SEED_SET2 |