MSC_ST_ASSIGNMENT_SETS

The staging table used by the collection program to valid and process data for table MSC_ASSIGNMENT_SETS.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Not-null	Comments
SR_ASSIGNMENT_SET_ID	NUMBER			Assignment set identifier from source application instance
ASSIGNMENT_SET_NAME	VARCHAR2	34		Name assigned to the assignment set
DESCRIPTION	VARCHAR2	80		Description of the assignment set
DELETED_FLAG	NUMBER			Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted
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.
SR_INSTANCE_ID	NUMBER			Source application instance identifier
REFRESH_NUMBER	NUMBER			Refresh identifier populated by the collection program.
RETRY_COUNT	NUMBER			Number of retries to process failed records.
PROCESS_FLAG	NUMBER			Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed
ERROR_CODE	VARCHAR2	150		Error code for functional validation errors in the record
ERROR_TEXT	VARCHAR2	2000		This will describe the reason for the error if any.
SR_INSTANCE_CODE	VARCHAR2	30		Source Instance code from which data is being populated.
LOAD_REQUEST_ID	NUMBER			It Stores the Request ID of Job that loaded the data.
SUBINV_PLANNING_ENABLED	NUMBER			Indicates if the assignment set is enabled for sub inventory level planning.