MSC_ST_ALLOC_ASSIGNMENTS

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

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Not-null	Comments
ASSIGNMENT_TYPE	NUMBER		Yes	Sourcing Assignment type for the item.
ALLOC_RULE_NAME	VARCHAR2	80	Yes	Unique name for the allocation rule
CATEGORY_NAME	VARCHAR2	250		Category to which assignment is made
CATEGORY_SET_NAME	VARCHAR2	30		Category set name to which assignment is made
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.
ITEM_NAME	VARCHAR2	300		Item to which assignment is made
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.
ORGANIZATION_CODE	VARCHAR2	18		This column stores the value of organization code for which allocation rule is assigned.
SR_INSTANCE_CODE	VARCHAR2	30		The value indicates the source system code from where the data is collected.
REFRESH_NUMBER	NUMBER			Refresh identifier populated by the collection program
PROCESS_FLAG	NUMBER			Processing Flag indicating the status of records during pre-processing. 1- Complete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record
ERROR_TEXT	VARCHAR2	2000		This will describe the reason for the error if any.
ERROR_CODE	VARCHAR2	80		Error code for functional validation errors in the record
DELETED_FLAG	NUMBER			Flag that indicates if the record should be deleted in collections
LOAD_REQUEST_ID	NUMBER			It Stores the Request ID of Job that loaded the data.
ALLOCATION_AREA	NUMBER			This column stores the value of product for which allocation is defined. 1/NULL - GOP and 2 -BM.