CSE_ITEM_ATTRIBUTES_AUDIT
This table stores the audit information as to when the alm attributes in the item master changed.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CSE_ITEM_ATTRIBUTES_AUDIT_PK |
ATTRIBUTE_AUDIT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ATTRIBUTE_AUDIT_ID | NUMBER | 18 | Yes | Primary Key Column. The unique system key. | |
| ITEM_ID | NUMBER | 18 | Yes | The inventory item identifier for which the audit is captured. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier where the item is assigned to. | |
| ENABLE_GENEALOGY_TRACKING_FLAG | VARCHAR2 | 1 | Flag that indicates whether product genealogy is tracked for this item or nor. | ||
| ASSET_TRACKED_FLAG | VARCHAR2 | 1 | Flag to indicate whether the asset tracking is enabled for the item or not and at what scope it is tracked. | ||
| ALLOW_MAINTENANCE_ASSET_FLAG | VARCHAR2 | 1 | Flag indicating whether the maintenance management functions can be performed on this item or not. | ||
| EFFECTIVE_DATE | TIMESTAMP | Date when one of the ALM flags were changes in the item master. The effective date from which these attribute states are in effect. | |||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Load Request Identifier. This is to support the loading of the interface records from the data files using the cloud framework. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSE_ITEM_ATTRIBS_AUDIT_N01 | Non Unique | Default | ITEM_ID, ORGANIZATION_ID |
| CSE_ITEM_ATTRIBS_AUDIT_U01 | Unique | Default | ATTRIBUTE_AUDIT_ID |