POR_AMX_ATTRIBUTES
This table stores the approval attributes metadata of a specific approval dimension. Each dimension can have multiple attributes.
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
POR_AMX_ATTRIBUTES_PK |
ATTRIBUTE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ATTRIBUTE_ID | NUMBER | 18 | Yes | System Generated unique identifier | |
| DIMENSION_ID | NUMBER | 18 | Yes | Dimension unique identifier | |
| ATTRIBUTE_KEY | VARCHAR2 | 100 | Yes | Attribute Name from SOA | |
| SDO_ATTRIBUTE_NAME | VARCHAR2 | 100 | Yes | SDO Attribute Name | |
| ATTRIBUTE_TYPE | VARCHAR2 | 30 | Yes | Attribute Type: BASIC (Used for defining rules and complex attributes. Includes notification attributes) RULE_ONLY (Used for defining rules and complex attributes. Not Includes notification attributes) NOTIFICATION_ONLY (Attributes for notification only) CUSTOM (Custom) AGGREGATE (Aggregate) CURRENCY (Currency Conversion) | |
| DISPLAY_DATA_TYPE | VARCHAR2 | 30 | Display Data Type: String, Number Not needed for NOTIFICATION_ONLY, CUSTOM, AGGREGATE and CURRENCY | ||
| RULE_DATA_TYPE | VARCHAR2 | 30 | Yes | Rule Data Type: String, Long, BigDecimal | |
| DISPLAY_TYPE | VARCHAR2 | 30 | Display Type: LOV, INPUT_TEXT, CHOICELIST, LOV_CHOICELIST Not needed for NOTIFICATION_ONLY, CUSTOM, AGGREGATE and CURRENCY | ||
| SQL | VARCHAR2 | 1000 | SQL for LOV, CHOICELIST or LOV_CHOICELIST Base query for the aggregation attributes | ||
| LOOKUP_CODE | VARCHAR2 | 30 | Lookup code of Attribute | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | ||
| COLUMN_NAME | VARCHAR2 | 30 | Column name of the attribute | ||
| AGGREGATION_ATTRIBUTE_FLAG | VARCHAR2 | 1 | Aggregation Attribute Flag can be 'A', 'B' and 'C'. Eg. ApprovalTotal and RequisitionTotal will have 'A', Quantiy (from line) will have 'B', AgreementAmtLineExceeded, AgreementAmtLineExceededFlag, Supplier, ChargeAccount will have NULL and Other attributes will have 'C' | ||
| AGGREGATION_SQL | CLOB | Aggregation SQL | |||
| ACTION_SUPPORT_TYPE | VARCHAR2 | 30 | Action Support Type: USERNAME (Username) POSITION (Position) | ||
| HIERARCHY_TYPE | VARCHAR2 | 30 | Hierarchy Aggregate Support: ACCOUNT CATEGORY If the value is null, no hierarchy based aggregration support for the attribute | ||
| FROM_CURRENCY_ATTRIBUTE_ID | VARCHAR2 | 100 | From Currency for currency conversion. If the value is null, no currency conversion support for the attribute | ||
| FROM_CURRENCY_DIMENSION_ID | NUMBER | 18 | ID of the dimension of the attribute that stores which currency this attribute's value is denominated in. If the value is null, this attribute's value is not based on currency, or currency conversion is not supported for this attribute. | ||
| FROM_CURRENCY_ATTRIBUTE_KEY | VARCHAR2 | 100 | Key of the attribute that stores which currency this attribute's value is denominated in. If the value is null, this attribute's value is not based on currency, or currency conversion is not supported for this attribute. | ||
| 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. | ||
| 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. | |
| ROLLSUP_FLAG | VARCHAR2 | 1 | Indicates whether attribute supports rollsup or not. Expected values: Y: Supporting rolls up, NULL: rollsup is not supported by this attribute. | ||
| ROLLSUP_ATTR_SQL | CLOB | Base query for deriving attribute value list for rollsup supported attribute. | |||
| MANDATORY_FLAG | VARCHAR2 | 1 | Flag that indicates whether the attribute is mandatory. | ||
| 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 |
|---|---|---|
| POR_AMX_ATTRIBUTES | por_amx_dimensions | DIMENSION_ID |
| por_amx_aggregate_attributes | por_amx_attributes | ATTRIBUTE_ID |
| por_amx_custom_attributes | por_amx_attributes | ATTRIBUTE_ID |
| por_amx_currency_attributes | por_amx_attributes | ATTRIBUTE_ID |
| por_amx_rule_attribute_usages | por_amx_attributes | ATTRIBUTE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POR_AMX_ATTRIBUTES_U1 | Unique | Default | ATTRIBUTE_ID, ORA_SEED_SET1 |
| POR_AMX_ATTRIBUTES_U11 | Unique | Default | ATTRIBUTE_ID, ORA_SEED_SET2 |
| POR_AMX_ATTRIBUTES_U2 | Unique | Default | DIMENSION_ID, ATTRIBUTE_KEY, ORA_SEED_SET1 |
| POR_AMX_ATTRIBUTES_U21 | Unique | Default | DIMENSION_ID, ATTRIBUTE_KEY, ORA_SEED_SET2 |