MSC_RESOURCE_CHANGES

MSC_RESOURCE_CHANGES stores information about capacity modifications for a resource on a shift in a department. This table is a child of MSC_RESOURCE_SHIFTS. You can define multiple resource changes for a shift.

Details

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

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
DEPARTMENT_ID	NUMBER		18	Yes	Department identifier or the work centre of the resource.
PLAN_ID	NUMBER		18		This value indicates the plan identifier for the record.
ORGANIZATION_ID	NUMBER		18	Yes	Organization identifier
RESOURCE_ID	NUMBER		18	Yes	This value indicates the Resource unique identifier.
SR_INSTANCE_ID	NUMBER		18	Yes	Source application instance identifier	Obsolete
SHIFT_NUM	NUMBER			Yes	This value indicates the number of the calendar shift.
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.
FROM_DATE	DATE			Yes	Identifies the Capacity exception from date
TO_DATE	DATE				This value indicates the Capacity exception to date.
FROM_TIME	NUMBER				Identifies the Capacity exception from time
TO_TIME	NUMBER				This value indicates the Capacity exception to time.
CAPACITY_CHANGE	NUMBER				The value indicates change in resource capacity/availability.
SIMULATION_SET	VARCHAR2	10		Yes	Simulation set to which the current record is added.
ATTRIBUTE_CATEGORY	VARCHAR2	30			Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ACTION_TYPE	NUMBER			Yes	Type of the capacity modification
REFRESH_NUMBER	NUMBER				Refresh number populated by the collection program
NEW_PLAN_ID	NUMBER			Yes	New Plan ID.
SIMULATION_SET_ID	NUMBER			Yes	Simulation set to which the current record is added.

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_RESOURCE_CHANGES	msc_department_resources	PLAN_ID, RESOURCE_ID, NEW_PLAN_ID, SIMULATION_SET_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_RESOURCE_CHANGES_U1	Unique	Default	SIMULATION_SET, ACTION_TYPE, DEPARTMENT_ID, RESOURCE_ID, SHIFT_NUM, FROM_DATE, TO_DATE, FROM_TIME, TO_TIME