DBA Data[Home] [Help] [Dependency Information]

TABLE: QA.QA_CHARS

Object Details
Object Name: QA_CHARS
Object Type: TABLE
Owner: QA
FND Design Data: TableQA.QA_CHARS
Subobject Name:
Status: VALID


QA_CHARS contains information about collection elements also known as Quality Characteristics. Some collection elements are seeded when Oracle Quality is installed, however, you can define new collection elements, which are also stored in this table. Collection elements may be enabled or disabled. You can only use enabled collection elements for the purpose of defining collection plans.
QA_CHARS can store the following types of information: display information, such as prompts and hints, which are shown during results entry; data, such as the datatype and default value of the collection element; validation information such as SQL validation strings; and specifications, such as upper and lower limits. QA_CHARS also stores information about the collection element type and context.
Collection element context is determined by the value of the CHAR_CONTEXT_FLAG, which indicates whether or not a collection element is a standard Quality Characteristic, has any dependency to any other collection element, or is referenced from any other elements in another Oracle Applications table. Depending on the value of CHAR_CONTEXT_FLAG, some other fields in this table may represent unifying context information for the collection element. For example, the collection element in CHAR_ID depends on the collection element represented by DEPENDENT_CHAR_ID. If a collection element is referenced, information from fields such as FK_TABLENAME or PK_ID denote the relationship between QA_CHARS and the foreign table.
QA_CHARS.HARDCODED_COLUMN stores the name of the corresponding column in the QA_RESULTS table in which the values for this collection element are stored. For example, if QA_CHARS.HARDCODED_COLUMN has a value, there will be a corresponding column in the QA_RESULTS table that will store the collection element's result value. If QA_CHARS.HARDCODED_COLUMN has a null value, then one of the generic CHARACTERx columns is used to store the collection element's value.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_CHARS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHAR_ID
ColumnZD_EDITION_NAME
QA_CHARS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnZD_EDITION_NAME
QA_CHARS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
CHAR_ID NUMBER
Yes Collection element Identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
NAME VARCHAR2 (30) Yes Collection element name
CHAR_TYPE_CODE VARCHAR2 (30) Yes Collection element type code
CHAR_CONTEXT_FLAG NUMBER
Yes Collection element context indicating whether the collection element is a standard Quality Characteristic or it is a referenced collection element. This flag also indicates if the collection element is a dependent collection element
PROMPT VARCHAR2 (30)
Collection element prompt to be displayed on the results screen
DATA_ENTRY_HINT VARCHAR2 (240)
Collection element data entry hint
DATATYPE NUMBER
Yes Collection element datatype
DISPLAY_LENGTH NUMBER

Collection element display length
DECIMAL_PRECISION NUMBER

Collection element decimal precision
DEFAULT_VALUE VARCHAR2 (2000)
Default value for the collection element
DEFAULT_VALUE_ID NUMBER

Default value Identifier
MANDATORY_FLAG NUMBER
Yes Flag to indicate if collection element is mandatory or optional
UOM_CODE VARCHAR2 (3)
Collection element unit of measure code
TARGET_VALUE VARCHAR2 (150)
Target value for the collection element. This value is defaulted when the collection element is added to a specification
UPPER_SPEC_LIMIT VARCHAR2 (150)
Upper specification limit for the collection element. This value is defaulted when the collection element is added to a specification
LOWER_SPEC_LIMIT VARCHAR2 (150)
Lower specification limit for the collection element. This value is defaulted when the collection element is added to a specification
UPPER_REASONABLE_LIMIT VARCHAR2 (150)
Upper reasonable limit for the collection element. This value is defaulted when the collection element is added to a specification
LOWER_REASONABLE_LIMIT VARCHAR2 (150)
Lower reasonable limit for the collection element. This value is defaulted when the collection element is added to a specification
UPPER_USER_DEFINED_LIMIT VARCHAR2 (150)
User defined range upper limit for the collection element. This value is defaulted when the collection element is added to a specification
LOWER_USER_DEFINED_LIMIT VARCHAR2 (150)
User defined range lower limit for the collection element. This value is defaulted when the collection element is added to a specification
HARDCODED_COLUMN VARCHAR2 (30)
Underlying database column name for hardcoded collection element. All hardcoded collection elements have a corresponding static column in QA_RESULTS table.
DEVELOPER_NAME VARCHAR2 (30)
Reference name for the collection element. This field is used by developers internally and is applicable only to pre-seeded collection elements.
SQL_VALIDATION_STRING VARCHAR2 (1500)
SQL validation string for the collection element. This string is used to validate collection elements during results entry
ENABLED_FLAG NUMBER
Yes Flag to enable or disable collection elements
VALUES_EXIST_FLAG NUMBER
Yes Flag to indicate if a permissible set of values has been entered for this collection element
DEPENDENT_CHAR_ID NUMBER

Dependent collection element Identifier on which the current collection element depends
FK_LOOKUP_TYPE NUMBER

Foreign key lookup type
FK_TABLE_NAME VARCHAR2 (30)
Name of the table to which collection element is a foreign key
FK_TABLE_SHORT_NAME VARCHAR2 (5)
Short name of the foreign key table
PK_ID VARCHAR2 (30)
Primary key column Identifier for the foreign key. Oracle Quality uses this information for dynamic view creation and validation purposes.
FK_ID VARCHAR2 (30)
Foreign key column Identifier in Oracle Quality. This information is used for dynamic view creation and validation purposes.
PK_ID2 VARCHAR2 (30)
Additional primary key Identifier
FK_ID2 VARCHAR2 (30)
Additional foreign key Identifier
PK_ID3 VARCHAR2 (30)
Additional primary key Identifier
FK_ID3 VARCHAR2 (30)
Additional foreign key Identifier
FK_MEANING VARCHAR2 (30)
Foreign key meaning
FK_DESCRIPTION VARCHAR2 (30)
Foreign key description
FK_ADD_WHERE VARCHAR2 (255)
Where clause that needs to be added to quality dynamic view creation logic
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SEQUENCE_NUMBER NUMBER

Sequence number if the datatype is sequence
SEQUENCE_PREFIX VARCHAR2 (10)
Sequence prefix if the datatype is sequence
SEQUENCE_SUFFIX VARCHAR2 (10)
Sequence suffix if the datatype is sequence
SEQUENCE_SEPARATOR VARCHAR2 (1)
Sequence separator character if datatype is sequence
SEQUENCE_START NUMBER

Sequence starting number if datatype is sequence
SEQUENCE_LENGTH NUMBER

Sequence display length if datatype is sequence
SEQUENCE_INCREMENT NUMBER

Sequence incremental value if datatype is sequence
SEQUENCE_NEXTVAL NUMBER

Next value if datatype is sequence
SEQUENCE_ZERO_PAD NUMBER

Indicates whether the sequence number should be padded with 0
DEPENDENT_ELEMENT VARCHAR2 (1)
Column to indicate if the collection element is a dependent element
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CHAR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      CHAR_TYPE_CODE
,      CHAR_CONTEXT_FLAG
,      PROMPT
,      DATA_ENTRY_HINT
,      DATATYPE
,      DISPLAY_LENGTH
,      DECIMAL_PRECISION
,      DEFAULT_VALUE
,      DEFAULT_VALUE_ID
,      MANDATORY_FLAG
,      UOM_CODE
,      TARGET_VALUE
,      UPPER_SPEC_LIMIT
,      LOWER_SPEC_LIMIT
,      UPPER_REASONABLE_LIMIT
,      LOWER_REASONABLE_LIMIT
,      UPPER_USER_DEFINED_LIMIT
,      LOWER_USER_DEFINED_LIMIT
,      HARDCODED_COLUMN
,      DEVELOPER_NAME
,      SQL_VALIDATION_STRING
,      ENABLED_FLAG
,      VALUES_EXIST_FLAG
,      DEPENDENT_CHAR_ID
,      FK_LOOKUP_TYPE
,      FK_TABLE_NAME
,      FK_TABLE_SHORT_NAME
,      PK_ID
,      FK_ID
,      PK_ID2
,      FK_ID2
,      PK_ID3
,      FK_ID3
,      FK_MEANING
,      FK_DESCRIPTION
,      FK_ADD_WHERE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SEQUENCE_NUMBER
,      SEQUENCE_PREFIX
,      SEQUENCE_SUFFIX
,      SEQUENCE_SEPARATOR
,      SEQUENCE_START
,      SEQUENCE_LENGTH
,      SEQUENCE_INCREMENT
,      SEQUENCE_NEXTVAL
,      SEQUENCE_ZERO_PAD
,      DEPENDENT_ELEMENT
,      ZD_EDITION_NAME
FROM QA.QA_CHARS;

Dependencies

[top of page]

QA.QA_CHARS does not reference any database object

QA.QA_CHARS is referenced by following:

SchemaQA
ViewQA_CHARS#