MSC_ST_ITEM_CATEGORIES

The staging table used by the collection program to validate and process data for table MSC_ITEM_CATEGORIES.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INVENTORY_ITEM_ID	NUMBER				Identifies the inventory item id
ORGANIZATION_ID	NUMBER				ORGANIZATION_ID
CATEGORY_ID	NUMBER		18		Unique identifier for the category
CATEGORY_SET_ID	NUMBER		18		Unique identifier for the category set
CATEGORY_NAME	VARCHAR2	250			Name assigned to the item category
CATEGORY_SET_NAME	VARCHAR2	30			Name assigned to the item category set
ITEM_NAME	VARCHAR2	300			Identifies the inventory item name
ORGANIZATION_CODE	VARCHAR2	18			ORGANIZATION_CODE
DELETED_FLAG	NUMBER				Flag indicating whether this is a deleted record
SR_INSTANCE_ID	NUMBER				Identifier of the source system from where the data is collected.
SR_INSTANCE_CODE	VARCHAR2	30			The value indicates the source system code from where the data is collected.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
PROCESS_FLAG	NUMBER				This flag indicates the current status of the record during collections.
ERROR_TEXT	VARCHAR2	2000			Error text for functional validation errors in the record
ERROR_CODE	VARCHAR2	150			Error code for functional validation errors in the record
REFRESH_NUMBER	NUMBER				Refresh identifier populated by the collection program.
LOAD_REQUEST_ID	NUMBER				Description of the associated calendar
RETRY_COUNT	NUMBER				Number of times this record was retried in retry cycles.