RS_O_SCHED_SMRY

(SQL Table)
Index Back

Optimization Solution Summary

Note that RMO_UTILIZATION is only a key because the optimization engine requires that all optimization tables have at least one key field other than PROBINST.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 RMO_UTILIZATION Number(6,2) DECIMAL(5,2) NOT NULL Projected Utilization (%)
3 RMO_NUM_DELAY_SOL Number(6,0) INTEGER NOT NULL Number of Delayed Requests
4 RMO_TOT_FIT_SCORE Number(13,2) DECIMAL(12,2) NOT NULL Total Fitness Score
5 RMO_TOT_REVENUE Number(13,2) DECIMAL(12,2) NOT NULL Projected Revenue
6 RMO_DELAY_DAYS Number(6,0) INTEGER NOT NULL Total days delayed
7 RMO_UNDERWRKD_HRS Number(10,0) DECIMAL(10) NOT NULL Total Underworked Hours
8 RMO_OBJ_VALUE Number(10,0) DECIMAL(10) NOT NULL Total Objective Function Value
9 RMO_UNDERWRKED_SOL Number(10,0) DECIMAL(10) NOT NULL Unfulfilled service orderlines
10 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference