ZCA_ES_ATTRIBUTES
This table is used to store the attributes of an entity
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ZCA_ES_ATTRIBUTES_PK |
META_MODEL_VERSION_UUID, ATTRIBUTE_UUID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| ATTRIBUTE_UUID | VARCHAR2 | 36 | Yes | the primary key for the attribute within the meta-data version | ||
| META_MODEL_VERSION_UUID | VARCHAR2 | 36 | Yes | the meta-data version for this attribute | ||
| ENTITY_UUID | VARCHAR2 | 36 | Yes | the uuid of the entity that this attribute belongs to | ||
| ATTRIBUTE_NAME | VARCHAR2 | 120 | Yes | the language-independent name for the entity composed from alphanumberic characters, plus underscore, beginning with a letter | ||
| ATTRIBUTE_TYPE_NAME | VARCHAR2 | 80 | Yes | one of 'Record', 'ForeignKey', 'Boolean', 'Byte', 'Short', 'Integer', 'Long', 'Float', 'Double', 'String', 'BigDecimal', 'Date', 'Percentage', 'Time', or 'Timestamp' | ||
| CURRENCY_CODE_ATTRIBUTE_UUID | VARCHAR2 | 36 | the uuid for the attriute that holds the currency code for this attribute | |||
| CONV_EXCH_RATE_ATTRIBUTE_UUID | VARCHAR2 | 36 | stores the uuid of the attribute that holds the conversion rate for converting the currency to the corporate currency. | |||
| ENTITY_USAGE_UUID | VARCHAR2 | 36 | the uuid of the entity usage that this attribute applies to, if any | |||
| COLUMN_NAME | VARCHAR2 | 30 | the column name in the table name for the entity usage that this attribute is sourced from, if any | |||
| LOOKUP_TYPE | VARCHAR2 | 30 | the lookup type if the attributes is an enum atrtibute otherwise null. The lookup type may either be the name of a SqlForLookupType enum or an lookup type that appears in FND_LOOKUP_TYPES | |||
| LOOKUP_TYPE_EXPR | VARCHAR2 | 80 | the expression that is used to initialize the lookup type when a sandbox is created | |||
| LOOKUP_TYPE_V_A_ID | NUMBER | 18 | Yes | The view application id to be used for the lookup type, if any | ||
| AGGREGATION_TYPE_NAME | VARCHAR2 | 80 | the name of the type of aggregation, either Max, Min, Sum, or Average | |||
| AGGREGATE_CLAUSE | VARCHAR2 | 999 | the select clause to compute the aggregate from the database | |||
| AGGREGATE_CHILD_ATTR_UUID | VARCHAR2 | 36 | the UUID of a child entity's attribute over which to compute in-document aggregations (mutually exclusive with AGGREGATE_CLAUSE) | |||
| RECORD_ENTITY_UUID | VARCHAR2 | 36 | the foreign key for the entity that describes the record if the attribute type name is 'Record' | |||
| USES_SECURITY_CONTEXT_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute is a foreign key reference that needs to include the security context of the reign key, otherwise N | ||
| ATTRIBUTE_UUID_FOR_FILTERING | VARCHAR2 | 36 | the uuid of the attribute within this entity that contains source of the filtering. If the attribute is a foreign key, then the uuid points to the attribute that holds the foreign key provided the FILTER is satidfied. If the atrtibute is a record, then the uuid points to the attribute that contains the list of records to be filtered | |||
| FILTERED_ATTRIBUTE_UUID | VARCHAR2 | 36 | the uuid of the attribute to be filtered. The attrbute type must be Long and the attribute to be filtered must match the type of this attribute and be an attribute in the recrod entity that is filtered. | |||
| ATTRIBUTE_UUID_FOR_RECORDS | VARCHAR2 | 36 | Obsolete: Replaced by ATTRIBUTE_UUID_FOR_FILTERING | Obsolete | ||
| ATTRIBUTE_FILTER | VARCHAR2 | 500 | the json string for the map that holds the value constrains for establishing the forign key or record.The REFRESH_ATTRIBUTE_UUID holds attribute that triggers recomputation and ATTRIBUTE_UUID_FOR_FILTERING | |||
| RECORDS_FILTER | VARCHAR2 | 500 | Obsolete: Replaced by ATTRIBUTE_FILTER | Obsolete | ||
| SQL_FOR_VALUE_TYPE_NAME | VARCHAR2 | 120 | the name of the SqlForValueType enum used to compute the attribute value | |||
| SQL_BIND_ATTRIBUTE_UUID | VARCHAR2 | 36 | the uuid of the attribute that serves as the bind variable in SQL_FOR_ATTRIUTE_VALUE | |||
| REFRESH_ATTRIBUTE_UUID | VARCHAR2 | 36 | the uuid of the attribute that should cause the value for this attribute to be re-computed | |||
| SQL_REFRESH_ATTRIBUTE_UUID | VARCHAR2 | 36 | Obsolete: Replaced by REFRESH_ATTRIBUTE_UUID | Obsolete | ||
| REFRESH_DOC_FIELD_PATH | VARCHAR2 | 120 | Obsolete | Obsolete | ||
| SQL_REFRESH_DOC_FIELD_PATH | VARCHAR2 | 120 | Obsolete: Replaced by REFRESH_DOC_FIELD_PATH | Obsolete | ||
| SQL_HIERARCHY_TYPE_NAME | VARCHAR2 | 30 | the name of the hierarchy that this attribute is dependent on, if any | |||
| MIN_OCCURS | NUMBER | 3 | the minimum times the attribute occurs | |||
| MAX_OCCURS | NUMBER | 3 | the maximum times the attribute occurs | |||
| SECURITY_TYPE_NAME | VARCHAR2 | 20 | Yes | The name of the security type, either Secured, Unsecured, or Mixed | ||
| SECURED_DATA_TYPE_NAMES | VARCHAR2 | 120 | If the attibuteis not secured, then the value is NULL. If the attribute is secured and the attribute belongs to a top-level entity then the value is a serialized JSON string that represents the list of secured data type names that need to be checked for access | |||
| IDENTIFIER_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute is an identifier | ||
| LOCALIZABLE_FLAG | VARCHAR2 | 1 | Yes | Y if the attribute is localizable,e.g., it is sourced from TL table. | ||
| COPY_TO_ENTITY_ALL_FIELD_FLAG | VARCHAR2 | 1 | Yes | Y iff the values for this attribute sghould be copied to the entity's _all field, otherwise N | ||
| INCLUDE_IN_REFERENCE_FLAG | VARCHAR2 | 1 | Yes | Y if the field should be included in the reference. Child entities must have all their attributes marked as Y. | ||
| INLINE_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute refers to a foreign key (or record) whose fields should be 'promoted' to same level as this attribute | ||
| SEARCHABLE_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute is searchable | ||
| SORTABLE_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute is sortable | ||
| AGGREGATABLE_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute can be used for aggregation | ||
| DEFAULT_AGGREGATION_UUID | VARCHAR2 | 36 | Obsolete: the uuid of the default aggregation for this field, if any | Obsolete | ||
| TRANSIENT_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute is transient, e.g., "Snippet" is transient, not searchable, not sortable, and not aggreggatable | ||
| LANG_DETECT_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Y to enable CJK language support for non translatable attributes | ||
| EXTN_ATTRIBUTE_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute is an extension field | ||
| RESOURCE_FLAG | VARCHAR2 | 1 | Yes | Y if the attribute is an resource field | ||
| CAN_BE_ENABLED_DISABLED_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute can be enabled/disabled | ||
| FORBID_REFERENCE_FLAG | VARCHAR2 | 1 | Yes | Y if the attribute cannot be included in reference | ||
| IN_SECURITY_CONTEXT_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute is part of the security context for the attribute's entity, otherwise N | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute is enabled | ||
| INDEXED_FLAG | VARCHAR2 | 1 | Yes | Y iff the attribute is indexed in Elastic Search | ||
| DISPLAY_WIDTH | NUMBER | 9 | the display width for the attribute | |||
| MIN_LENGTH | NUMBER | 9 | the minimum length for the attribute | |||
| MAX_LENGTH | NUMBER | 9 | the maximum length for the attribute | |||
| DECIMAL_PLACES | NUMBER | 9 | the number of decimal places to use, iff applicable | |||
| MIN_VALUE | NUMBER | the min value, iff applicable | ||||
| MAX_VALUE | NUMBER | the max value, iff applicable | ||||
| RESOURCE_BUNDLE_ID | VARCHAR2 | 500 | The resource bundle for this attribute | |||
| RESOURCE_KEY_NAME | VARCHAR2 | 500 | the resource key in the RESOURCE_BUNDLE_ID for the localized name | |||
| RESOURCE_KEY_DESCRIPTION | VARCHAR2 | 500 | the resource key in the RESOURCE_BUNDLE_ID for the localized description | |||
| RESOURCE_KEY_HELP | VARCHAR2 | 500 | the resource key in the RESOURCE_BUNDLE_ID for the localized help | |||
| EXTN_RESOURCE_BUNDLE_ID | VARCHAR2 | 500 | The customized resource bundle for this attribute | |||
| EXTN_RESOURCE_KEY_NAME | VARCHAR2 | 500 | the resource key in the EXTN_RESOURCE_BUNDLE_ID for the localized name | |||
| EXTN_RESOURCE_KEY_DESCRIPTION | VARCHAR2 | 500 | the resource key in the EXTN_RESOURCE_BUNDLE_ID for the localized description | |||
| EXTN_RESOURCE_KEY_HELP | VARCHAR2 | 500 | the resource key in the EXTN_RESOURCE_BUNDLE_ID for the localized help | |||
| DELETED_FLAG | VARCHAR2 | 1 | Yes | Y iff the row was deleted, otherwise N | ||
| RECORD_TYPE_FLAG | VARCHAR2 | 1 | Yes | Y if the attribute is RecordType | ||
| RECORD_TYPE_ROLES | CLOB | Jason data for record type roles and corresponding values for roles | ||||
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. | ||
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | ||||
| 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. | |||
| NORMALIZER_TYPE_NAME | VARCHAR2 | 80 | One of 'Lowercase', 'Uppercase','TitleCase' or 'None'. This represents to normalizer used for indexing the attribute. | |||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_ES_ATTRIBUTES_PK | Unique | FUSION_TS_SEED | META_MODEL_VERSION_UUID, ATTRIBUTE_UUID, ORA_SEED_SET1 |
| ZCA_ES_ATTRIBUTES_PK1 | Unique | FUSION_TS_SEED | META_MODEL_VERSION_UUID, ATTRIBUTE_UUID, ORA_SEED_SET2 |
| ZCA_ES_ATTRIBUTES_U1 | Unique | FUSION_TS_SEED | META_MODEL_VERSION_UUID, ENTITY_UUID, ATTRIBUTE_NAME, ORA_SEED_SET1 |
| ZCA_ES_ATTRIBUTES_U11 | Unique | FUSION_TS_SEED | META_MODEL_VERSION_UUID, ENTITY_UUID, ATTRIBUTE_NAME, ORA_SEED_SET2 |