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

QSC_ATTRIBUTE_OPTIONS

This table is used to store attribute options that can be associated with product groups for defining narrow by filters, search criteria etc.

Details

  • Schema: FUSION

  • Object owner: QSC

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

QSC_ATTRIBUTE_OPTIONS_PK

ATTRIBUTE_OPTION_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ATTRIBUTE_OPTION_ID NUMBER 18 Yes Unique Identifier for narrow by attribute options. Primary Key.
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. Active
INTERNAL_ATTR_NAME VARCHAR2 100 Yes Internal Name of the attribute. Active
NB_ATTR_TYPE_CODE VARCHAR2 30 Yes Type of attribute determines whether it is a Product Attribute, Pricing Attribute etc. Active
NB_ATTR_SUBTYPE_CODE VARCHAR2 30 Subtype of the attribute. The subtype is related to the type of the attribute defined in the NB_ATTR_TYPE_CODE column. Active
DOMAIN_TYPE_CODE VARCHAR2 30 Type of domain for this attribute. Active
NB_DATA_TYPE_CODE VARCHAR2 30 Data type of the narrow by attribute that drives the domain behavior. Active
FORMAT_TYPE_CODE VARCHAR2 30 Format Type for numeric attributes.
SORT_BY_ASC_TYPE VARCHAR2 30 Defines the ascending sort order options displayed to the user. Active
SORT_BY_DESC_TYPE VARCHAR2 30 Defines the descending sort order options displayed to the user. Active
COMMENTS VARCHAR2 500 Comments for the attribute option.
APPLICATION_ID NUMBER 18 Refers to the Application Id of the DFF/EFF Context Segment
DESCRIPTIVE_FLEXFIELD_CODE VARCHAR2 40 Refers to the Descriptive Flexfield Code of the DFF/EFF Context Segment.
CONTEXT_CODE VARCHAR2 80 Refers to the DFF/EFF Context Code.
SEGMENT_CODE VARCHAR2 30 Refers to the DFF/EFF Segment Code.
OBJECT_NAME VARCHAR2 240 Refers to the name of the object that the attribute belongs to. Active
OBJECT_COL_NAME VARCHAR2 100 Refers to the name of the column in the referenced table that this attribute is based on. Active
LOOKUP_TYPE_CODE VARCHAR2 30 Refers to the lookup type code used by this attribute. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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). Active
CUSTOMIZATION_LEVEL VARCHAR2 1 Yes Used to enforce rules, restricting how and by whom the particular row can be edited.
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
qsc_prod_grp_attr_b qsc_attribute_options ATTRIBUTE_OPTION_ID

Indexes

Index Uniqueness Tablespace Columns Status
QSC_ATTRIBUTE_OPTIONS_N1 Non Unique FUSION_TS_SEED LAST_UPDATE_DATE, ATTRIBUTE_OPTION_ID Active
QSC_ATTRIBUTE_OPTIONS_PK Unique FUSION_TS_SEED ATTRIBUTE_OPTION_ID, ORA_SEED_SET1 Active
QSC_ATTRIBUTE_OPTIONS_PK1 Unique FUSION_TS_SEED ATTRIBUTE_OPTION_ID, ORA_SEED_SET2
QSC_ATTRIBUTE_OPTIONS_U1 Unique FUSION_TS_SEED INTERNAL_ATTR_NAME, ORA_SEED_SET1 Active
QSC_ATTRIBUTE_OPTIONS_U11 Unique FUSION_TS_SEED INTERNAL_ATTR_NAME, ORA_SEED_SET2