MSC_ST_SR_LOOKUP_VALUES

Details

Schema: FUSION
Object owner: MSC
Object type: TABLE
Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LOOKUP_TYPE	VARCHAR2	30			Lookup type
LOOKUP_CODE	VARCHAR2	1000			lookup code
SR_LOOKUP_CODE	VARCHAR2	1000			Source side value of the lookup code in the planning lookups.
SR_SET_ID	NUMBER		18		Source side value of the Set identifier.
VIEW_APPLICATION_ID	NUMBER		18		Application identifier against which the lookup is defined.
ENABLED_FLAG	VARCHAR2	1			Used to enable/desable a record
START_DATE_ACTIVE	DATE				Date from which this record is active
END_DATE_ACTIVE	DATE				Date from which this record is no longer active
DELETED_FLAG	NUMBER		1		Indicates if record should be deleted. 1- Yes, 2 - No.
REFRESH_NUMBER	NUMBER				Refresh identifier populated by the collection program.
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
RETRY_COUNT	NUMBER				Number of retries to process failed records
SR_INSTANCE_ID	NUMBER		18		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.