# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PROBINST |
Character(20) |
VARCHAR2(20) NOT NULL |
Optimization Problem Instance
|
2 |
RMO_RR_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
ST-20/09/04 /Field length changed from 20 to 25
(Buss unit +soid +so line was coming more than 20);
|
3 |
START_DT |
Date(10) |
DATE |
Start Date
|
4 |
END_DT |
Date(10) |
DATE |
End Date
|
5 |
EST_DAYS |
Number(5,0) |
INTEGER NOT NULL |
Estimated number of days
|
6 |
QTY_INTEGER |
Number(11,0) |
DECIMAL(11) NOT NULL |
Quantity Rounded to 0 Decimals
|
7 |
PART_TIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Part Time
|
8 |
PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
9 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|