VIEW: MSC.MSC_DEPARTMENT_RESOURCES#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_CODE RESOURCE_CODE, RESOURCE_DESCRIPTION RESOURCE_DESCRIPTION, DEPARTMENT_CODE DEPARTMENT_CODE, DEPARTMENT_DESCRIPTION DEPARTMENT_DESCRIPTION, DEPARTMENT_CLASS DEPARTMENT_CLASS, LINE_FLAG LINE_FLAG, AGGREGATE_RESOURCE_ID AGGREGATE_RESOURCE_ID, AGGREGATE_RESOURCE_FLAG AGGREGATE_RESOURCE_FLAG, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME, RESOURCE_GROUP_CODE RESOURCE_GROUP_CODE, RESOURCE_SHORTAGE_TYPE RESOURCE_SHORTAGE_TYPE, RESOURCE_BALANCE_FLAG RESOURCE_BALANCE_FLAG, RESOURCE_EXCESS_TYPE RESOURCE_EXCESS_TYPE, RESOURCE_INCLUDE_FLAG RESOURCE_INCLUDE_FLAG, CRITICAL_RESOURCE_FLAG CRITICAL_RESOURCE_FLAG, OVERUTILIZED_PERCENT OVERUTILIZED_PERCENT, BOTTLENECK_FLAG BOTTLENECK_FLAG, UNDERUTILIZED_PERCENT UNDERUTILIZED_PERCENT, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID, CAPACITY_UNITS CAPACITY_UNITS, UTILIZATION UTILIZATION, EFFICIENCY EFFICIENCY, USER_TIME_FENCE USER_TIME_FENCE, RESOURCE_TYPE RESOURCE_TYPE, DISABLE_DATE DISABLE_DATE, AVAILABLE_24_HOURS_FLAG AVAILABLE_24_HOURS_FLAG, MIN_RATE MIN_RATE, MAX_RATE MAX_RATE, START_TIME START_TIME, STOP_TIME STOP_TIME, CTP_FLAG CTP_FLAG, REFRESH_NUMBER REFRESH_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, RESOURCE_COST RESOURCE_COST, RESOURCE_OVER_UTIL_COST RESOURCE_OVER_UTIL_COST, DEPT_OVERHEAD_COST DEPT_OVERHEAD_COST, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET, BATCHABLE_FLAG BATCHABLE_FLAG, BATCHING_WINDOW BATCHING_WINDOW, MIN_CAPACITY MIN_CAPACITY, MAX_CAPACITY MAX_CAPACITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, UOM_CLASS_TYPE UOM_CLASS_TYPE, ATP_RULE_ID ATP_RULE_ID, AVAIL_FACTOR AVAIL_FACTOR, CAPACITY_TOLERANCE CAPACITY_TOLERANCE, CHARGEABLE_FLAG CHARGEABLE_FLAG, LAST_KNOWN_SETUP LAST_KNOWN_SETUP, SCHEDULE_TO_INSTANCE SCHEDULE_TO_INSTANCE, SDS_SCHEDULING_WINDOW SDS_SCHEDULING_WINDOW, IDLE_TIME_TOLERANCE IDLE_TIME_TOLERANCE, BATCHING_PENALTY BATCHING_PENALTY, SETUP_TIME_PERCENT SETUP_TIME_PERCENT, UTILIZATION_CHANGE_PERCENT UTILIZATION_CHANGE_PERCENT, SETUP_TIME_TYPE SETUP_TIME_TYPE, UTILIZATION_CHANGE_TYPE UTILIZATION_CHANGE_TYPE, APPLIED APPLIED, NEW_PLAN_ID NEW_PLAN_ID, NEW_PLAN_LIST NEW_PLAN_LIST, SIMULATION_SET_ID SIMULATION_SET_ID from "MSC"."MSC_DEPARTMENT_RESOURCES"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_CODE RESOURCE_CODE
, RESOURCE_DESCRIPTION RESOURCE_DESCRIPTION
, DEPARTMENT_CODE DEPARTMENT_CODE
, DEPARTMENT_DESCRIPTION DEPARTMENT_DESCRIPTION
, DEPARTMENT_CLASS DEPARTMENT_CLASS
, LINE_FLAG LINE_FLAG
, AGGREGATE_RESOURCE_ID AGGREGATE_RESOURCE_ID
, AGGREGATE_RESOURCE_FLAG AGGREGATE_RESOURCE_FLAG
, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME
, RESOURCE_GROUP_CODE RESOURCE_GROUP_CODE
, RESOURCE_SHORTAGE_TYPE RESOURCE_SHORTAGE_TYPE
, RESOURCE_BALANCE_FLAG RESOURCE_BALANCE_FLAG
, RESOURCE_EXCESS_TYPE RESOURCE_EXCESS_TYPE
, RESOURCE_INCLUDE_FLAG RESOURCE_INCLUDE_FLAG
, CRITICAL_RESOURCE_FLAG CRITICAL_RESOURCE_FLAG
, OVERUTILIZED_PERCENT OVERUTILIZED_PERCENT
, BOTTLENECK_FLAG BOTTLENECK_FLAG
, UNDERUTILIZED_PERCENT UNDERUTILIZED_PERCENT
, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID
, CAPACITY_UNITS CAPACITY_UNITS
, UTILIZATION UTILIZATION
, EFFICIENCY EFFICIENCY
, USER_TIME_FENCE USER_TIME_FENCE
, RESOURCE_TYPE RESOURCE_TYPE
, DISABLE_DATE DISABLE_DATE
, AVAILABLE_24_HOURS_FLAG AVAILABLE_24_HOURS_FLAG
, MIN_RATE MIN_RATE
, MAX_RATE MAX_RATE
, START_TIME START_TIME
, STOP_TIME STOP_TIME
, CTP_FLAG CTP_FLAG
, REFRESH_NUMBER REFRESH_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, RESOURCE_COST RESOURCE_COST
, RESOURCE_OVER_UTIL_COST RESOURCE_OVER_UTIL_COST
, DEPT_OVERHEAD_COST DEPT_OVERHEAD_COST
, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET
, BATCHABLE_FLAG BATCHABLE_FLAG
, BATCHING_WINDOW BATCHING_WINDOW
, MIN_CAPACITY MIN_CAPACITY
, MAX_CAPACITY MAX_CAPACITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, UOM_CLASS_TYPE UOM_CLASS_TYPE
, ATP_RULE_ID ATP_RULE_ID
, AVAIL_FACTOR AVAIL_FACTOR
, CAPACITY_TOLERANCE CAPACITY_TOLERANCE
, CHARGEABLE_FLAG CHARGEABLE_FLAG
, LAST_KNOWN_SETUP LAST_KNOWN_SETUP
, SCHEDULE_TO_INSTANCE SCHEDULE_TO_INSTANCE
, SDS_SCHEDULING_WINDOW SDS_SCHEDULING_WINDOW
, IDLE_TIME_TOLERANCE IDLE_TIME_TOLERANCE
, BATCHING_PENALTY BATCHING_PENALTY
, SETUP_TIME_PERCENT SETUP_TIME_PERCENT
, UTILIZATION_CHANGE_PERCENT UTILIZATION_CHANGE_PERCENT
, SETUP_TIME_TYPE SETUP_TIME_TYPE
, UTILIZATION_CHANGE_TYPE UTILIZATION_CHANGE_TYPE
, APPLIED APPLIED
, NEW_PLAN_ID NEW_PLAN_ID
, NEW_PLAN_LIST NEW_PLAN_LIST
, SIMULATION_SET_ID SIMULATION_SET_ID
FROM "MSC"."MSC_DEPARTMENT_RESOURCES"