ACA_RULE_PDA_ATTR_GRP_B
Contains the list of attribute groups available for use by the application which contain primary defined attributes (PDA). Attribute groups are groups of attributes as defined by the product teams. Attribute groups can be wholly contained in a single entity or they can span multiple entities. Attribute groups can be singular or they can repeat. Customer-defined attribute groups are maintained as contexts in the EFF world.
Details
-
Schema: FUSION
-
Object owner: ACA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ACA_RULE_PDA_ATTR_GRP_B_PK |
ATTRIBUTE_GROUP_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ATTRIBUTE_GROUP_CODE | VARCHAR2 | 30 | Yes | Primary Key. The internal code that identifies the attribute group. | |
| 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. | |
| ATTRIBUTE_GROUP_TYPE | VARCHAR2 | 30 | Yes | Logic Control. An attribute group can either be used for as part of a customer-defined attribute (UDA aka EFF) or a product-defined attribute (non-UDA). PRIMARY = Product-Defined Attribute EGO_ITEMMGMT_GROUP = Customer-Defined Attribute -- carryover from PIM implementation; not willing to change this | |
| ASSIGNMENT_FLAG | VARCHAR2 | 1 | Yes | Yes/No Flag. An attribute group can either be used for validation or assignment. N = Validation Only Y = Validation and Assignment | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Yes/No Flag. An attribute group can be either disabled or enabled. N = Disabled Y = Enabled | |
| MULTIROW_FLAG | VARCHAR2 | 1 | Yes | Yes/No Flag. An attribute group can be either a single row or multiple rows. N = Single Row Y = Multiple Rows | |
| 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. | ||
| 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 |
|---|---|---|
| aca_rule_pda_entity_ag | aca_rule_pda_attr_grp_b | ATTRIBUTE_GROUP_CODE |
| aca_rule_pda_attr_b | aca_rule_pda_attr_grp_b | ATTRIBUTE_GROUP_CODE |
| aca_rule_pda_attr_grp_tl | aca_rule_pda_attr_grp_b | ATTRIBUTE_GROUP_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ACA_RULE_PDA_ATTR_GRP_B_U1 | Unique | Default | ATTRIBUTE_GROUP_CODE, ORA_SEED_SET1 |
| ACA_RULE_PDA_ATTR_GRP_B_U11 | Unique | Default | ATTRIBUTE_GROUP_CODE, ORA_SEED_SET2 |