VIEW: MSC.MSC_ST_DEPARTMENT_RESOURCES#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, RESOURCE_ID RESOURCE_ID, RESOURCE_CODE RESOURCE_CODE, DEPARTMENT_ID DEPARTMENT_ID, DEPARTMENT_CODE DEPARTMENT_CODE, DEPARTMENT_CLASS DEPARTMENT_CLASS, LINE_FLAG LINE_FLAG, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID, CAPACITY_UNITS CAPACITY_UNITS, MAX_RATE MAX_RATE, MIN_RATE MIN_RATE, AGGREGATED_RESOURCE_ID AGGREGATED_RESOURCE_ID, AGGREGATED_RESOURCE_FLAG AGGREGATED_RESOURCE_FLAG, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME, RESOURCE_GROUP_CODE RESOURCE_GROUP_CODE, RESOURCE_BALANCE_FLAG RESOURCE_BALANCE_FLAG, BOTTLENECK_FLAG BOTTLENECK_FLAG, START_TIME START_TIME, STOP_TIME STOP_TIME, DEPARTMENT_DESCRIPTION DEPARTMENT_DESCRIPTION, RESOURCE_DESCRIPTION RESOURCE_DESCRIPTION, OVER_UTILIZED_PERCENT OVER_UTILIZED_PERCENT, UNDER_UTILIZED_PERCENT UNDER_UTILIZED_PERCENT, RESOURCE_SHORTAGE_TYPE RESOURCE_SHORTAGE_TYPE, RESOURCE_EXCESS_TYPE RESOURCE_EXCESS_TYPE, USER_TIME_FENCE USER_TIME_FENCE, UTILIZATION UTILIZATION, EFFICIENCY EFFICIENCY, RESOURCE_INCLUDE_FLAG RESOURCE_INCLUDE_FLAG, CRITICAL_RESOURCE_FLAG CRITICAL_RESOURCE_FLAG, RESOURCE_TYPE RESOURCE_TYPE, DISABLE_DATE DISABLE_DATE, LINE_DISABLE_DATE LINE_DISABLE_DATE, AVAILABLE_24_HOURS_FLAG AVAILABLE_24_HOURS_FLAG, CTP_FLAG CTP_FLAG, DELETED_FLAG DELETED_FLAG, 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, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, DEPT_OVERHEAD_COST DEPT_OVERHEAD_COST, RESOURCE_COST RESOURCE_COST, RESOURCE_OVER_UTIL_COST RESOURCE_OVER_UTIL_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, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, OWNING_DEPARTMENT_CODE OWNING_DEPARTMENT_CODE, ORGANIZATION_CODE ORGANIZATION_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, ERROR_TEXT ERROR_TEXT, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ATP_RULE_ID ATP_RULE_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_DEPARTMENT_ID SOURCE_DEPARTMENT_ID, SOURCE_RESOURCE_ID SOURCE_RESOURCE_ID, SOURCE_OWNING_DEPARTMENT_ID SOURCE_OWNING_DEPARTMENT_ID, CAPACITY_TOLERANCE CAPACITY_TOLERANCE, CHARGEABLE_FLAG CHARGEABLE_FLAG, IDLE_TIME_TOLERANCE IDLE_TIME_TOLERANCE, BATCHING_PENALTY BATCHING_PENALTY, LAST_KNOWN_SETUP LAST_KNOWN_SETUP, SCHEDULE_TO_INSTANCE SCHEDULE_TO_INSTANCE, SDS_SCHEDULING_WINDOW SDS_SCHEDULING_WINDOW, SETUP_TIME_PERCENT SETUP_TIME_PERCENT, UTILIZATION_CHANGE_PERCENT UTILIZATION_CHANGE_PERCENT, SETUP_TIME_TYPE SETUP_TIME_TYPE, UTILIZATION_CHANGE_TYPE UTILIZATION_CHANGE_TYPE from "MSC"."MSC_ST_DEPARTMENT_RESOURCES"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, RESOURCE_ID RESOURCE_ID
, RESOURCE_CODE RESOURCE_CODE
, DEPARTMENT_ID DEPARTMENT_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, DEPARTMENT_CLASS DEPARTMENT_CLASS
, LINE_FLAG LINE_FLAG
, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID
, CAPACITY_UNITS CAPACITY_UNITS
, MAX_RATE MAX_RATE
, MIN_RATE MIN_RATE
, AGGREGATED_RESOURCE_ID AGGREGATED_RESOURCE_ID
, AGGREGATED_RESOURCE_FLAG AGGREGATED_RESOURCE_FLAG
, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME
, RESOURCE_GROUP_CODE RESOURCE_GROUP_CODE
, RESOURCE_BALANCE_FLAG RESOURCE_BALANCE_FLAG
, BOTTLENECK_FLAG BOTTLENECK_FLAG
, START_TIME START_TIME
, STOP_TIME STOP_TIME
, DEPARTMENT_DESCRIPTION DEPARTMENT_DESCRIPTION
, RESOURCE_DESCRIPTION RESOURCE_DESCRIPTION
, OVER_UTILIZED_PERCENT OVER_UTILIZED_PERCENT
, UNDER_UTILIZED_PERCENT UNDER_UTILIZED_PERCENT
, RESOURCE_SHORTAGE_TYPE RESOURCE_SHORTAGE_TYPE
, RESOURCE_EXCESS_TYPE RESOURCE_EXCESS_TYPE
, USER_TIME_FENCE USER_TIME_FENCE
, UTILIZATION UTILIZATION
, EFFICIENCY EFFICIENCY
, RESOURCE_INCLUDE_FLAG RESOURCE_INCLUDE_FLAG
, CRITICAL_RESOURCE_FLAG CRITICAL_RESOURCE_FLAG
, RESOURCE_TYPE RESOURCE_TYPE
, DISABLE_DATE DISABLE_DATE
, LINE_DISABLE_DATE LINE_DISABLE_DATE
, AVAILABLE_24_HOURS_FLAG AVAILABLE_24_HOURS_FLAG
, CTP_FLAG CTP_FLAG
, DELETED_FLAG DELETED_FLAG
, 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
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, DEPT_OVERHEAD_COST DEPT_OVERHEAD_COST
, RESOURCE_COST RESOURCE_COST
, RESOURCE_OVER_UTIL_COST RESOURCE_OVER_UTIL_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
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, OWNING_DEPARTMENT_CODE OWNING_DEPARTMENT_CODE
, ORGANIZATION_CODE ORGANIZATION_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, ERROR_TEXT ERROR_TEXT
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ATP_RULE_ID ATP_RULE_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_DEPARTMENT_ID SOURCE_DEPARTMENT_ID
, SOURCE_RESOURCE_ID SOURCE_RESOURCE_ID
, SOURCE_OWNING_DEPARTMENT_ID SOURCE_OWNING_DEPARTMENT_ID
, CAPACITY_TOLERANCE CAPACITY_TOLERANCE
, CHARGEABLE_FLAG CHARGEABLE_FLAG
, IDLE_TIME_TOLERANCE IDLE_TIME_TOLERANCE
, BATCHING_PENALTY BATCHING_PENALTY
, LAST_KNOWN_SETUP LAST_KNOWN_SETUP
, SCHEDULE_TO_INSTANCE SCHEDULE_TO_INSTANCE
, SDS_SCHEDULING_WINDOW SDS_SCHEDULING_WINDOW
, SETUP_TIME_PERCENT SETUP_TIME_PERCENT
, UTILIZATION_CHANGE_PERCENT UTILIZATION_CHANGE_PERCENT
, SETUP_TIME_TYPE SETUP_TIME_TYPE
, UTILIZATION_CHANGE_TYPE UTILIZATION_CHANGE_TYPE
FROM "MSC"."MSC_ST_DEPARTMENT_RESOURCES"