RF_UTIL_GOAL_VW (SQL View)	Index Back
Goal - Utilization Rate View Input view for Goal - Utilization Rate ACE report

RF_UTIL_GOAL_VW

(SQL View)

Goal - Utilization Rate View

Input view for Goal - Utilization Rate ACE report

SELECT B.PROBINST , A.UTILIZATION_GOAL , A.SELECT_FLAG FROM PS_RF_UTIL_CONFIG A , PS_RF_UTIL_CF_INST B WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

2 UTILIZATION_GOAL Number(8,2) DECIMAL(7,2) NOT NULL Percentage of utilization that is the goal in the utilization rate smart view.

3 SELECT_FLG Character(1) VARCHAR2(1) NOT NULL Field is a flag for selection .

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	UTILIZATION_GOAL	Number(8,2)	DECIMAL(7,2) NOT NULL	Percentage of utilization that is the goal in the utilization rate smart view.
3	SELECT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Field is a flag for selection .