| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
|
| 3 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
|
| 4 |
SEQ_NBR_5 |
Number(5,0) |
INTEGER NOT NULL |
Sequence number five digits long
|
| 5 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 6 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 7 |
LAST_UPDATED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
LastUpdatedUser
|
| 8 |
LAST_UPDATE_DTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|