| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 3 |
CHANGE_REQ_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Change Request ID
|
| 4 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 5 |
ACTUAL_WORK_OLD |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Actual Work (hrs)
|
| 6 |
ASSGND_WORK_OLD |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Old Work (hrs)
|
| 7 |
REMAINING_WORK_OLD |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Old Remaining Work (Hrs)
|
| 8 |
ASSGND_WORK |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
New Work (hrs)
|
| 9 |
REMAINING_WORK |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
New Remaining work in hours
|
| 10 |
COMMENTS_DETAIL |
Character(254) |
VARCHAR2(254) NOT NULL |
Comments
|
| 11 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 12 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 13 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 14 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|