# |
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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
4 |
START_DT |
Date(10) |
DATE |
Start Date
|
5 |
END_DT |
Date(10) |
DATE |
End Date
|
6 |
SCHEDULED_HRS |
Signed Number(10,4) |
DECIMAL(8,4) NOT NULL |
Scheduled Hours
|
7 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|