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

RS_O_INSTALL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 STD_HOURS_DAY Number(5,2) DECIMAL(4,2) NOT NULL Standard Hours Day
3 SUN Character(1) VARCHAR2(1) NOT NULL Sunday
4 MON Character(1) VARCHAR2(1) NOT NULL Monday
5 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday
6 WED Character(1) VARCHAR2(1) NOT NULL Wednesday
7 THURS Character(1) VARCHAR2(1) NOT NULL Thursday
8 FRI Character(1) VARCHAR2(1) NOT NULL Friday
9 SAT Character(1) VARCHAR2(1) NOT NULL Saturday