1. Tables and Views for SCM
  2. QA_CHARACTERISTICS_B

QA_CHARACTERISTICS_B

This table stores the inspection characteristics.

Details

  • Schema: FUSION

  • Object owner: QA

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

QA_CHARACTERISTICS_B_PK

CHARACTERISTIC_ID

Columns

Name Datatype Length Precision Not-null Comments
CHARACTERISTIC_ID NUMBER 18 Yes Surrogate identifier for characteristic.
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.
CHARACTERISTIC_CODE VARCHAR2 30 Yes Indicates the user defined code for characteristic.
CHARACTERISTIC_TYPE VARCHAR2 30 Yes Indicates the type of characteristic. Options are (1)Item (2) Non-Item.
CONTEXT_TYPE VARCHAR2 30 Identifies whether the characteristic is for item class or item.
ITEM_CLASS_ID NUMBER 18 Identifies the surrogate reference of item class.
ATTRIBUTE_GROUP_TARGET VARCHAR2 80 Identifies the attribute group of the item extensible flexfield setup which contains the target value of the characteristic.
ATTRIBUTE_TARGET VARCHAR2 80 Identifies the attribute of the item extensible flexfield setup which contains the target value of the characteristic.
ATTRIBUTE_GROUP_MINIMUM VARCHAR2 80 Identifies the attribute group of the item extensible flexfield setup which contains the minimum value of the characteristic.
ATTRIBUTE_MINIMUM VARCHAR2 80 Identifies the attribute of the item extensible flexfield setup which contains the minimum value of the characteristic.
ATTRIBUTE_GROUP_MAXIMUM VARCHAR2 80 Identifies the attribute group of the item extensible flexfield setup which contains the maximum value of the characteristic.
ATTRIBUTE_MAXIMUM VARCHAR2 80 Identifies the attribute of the item extensible flexfield setup which contains the maximum value of the characteristic.
VALUE_SET_ID NUMBER 18 Identifies the value set which controls the list of values for the characteristic.
DATA_TYPE VARCHAR2 30 Indicates the data type of the information captured by the characteristic.
DEFAULT_VALUE VARCHAR2 30 Indicates the default value for the characteristic.
UOM_CODE VARCHAR2 3 Indicates the Unit of measure code of the value of the characteristic. Only applicable if the data type of the characteristic is character.
DECIMAL_PRECISION NUMBER 9 Indicates the decimal precision of the information capture by the characteristic. Allowed values are from 0 to 99.
ENABLED_FLAG VARCHAR2 1 Yes Indicates whether the characteristic is enabled for use. Options are (1)Y (2)N. Default value is Y.
START_DATE_ACTIVE DATE Indicates the start date from which the characteristic group is active. Default value is 01-Jan-2008.
END_DATE_ACTIVE DATE Indicates the end date till which the characteristic group is active. Default value is 31-Dec-4712.
TARGET_VALUE_DATE TIMESTAMP Indicates the target date for Date data type.
ATTRIBUTE_MINIMUM_DATE TIMESTAMP Indicates the Minimum date for Date data type.
ATTRIBUTE_MAXIMUM_DATE TIMESTAMP Indicates the Maximum date for Date data type.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
AI_SUGGESTION VARCHAR2 1 Indicates whether the characteristic is suggested by Generative AI. Options are (1)Y (2)N.

Indexes

Index Uniqueness Tablespace Columns
QA_CHARACTERISTICS_B_PK Unique FUSION_TS_TX_DATA CHARACTERISTIC_ID
QA_CHARACTERISTICS_B_U1 Unique FUSION_TS_TX_DATA CHARACTERISTIC_CODE