SPF_WO_TRK_RSRC(SQL Table) |
Index Back |
|---|---|
Track Resources on WorkOrderTrack Resources on WorkOrder |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 3 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
%EDITTABLE
|
| 4 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 5 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: A |
| 6 | START_DATE | Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 7 | END_DATE | Date(10) | DATE NOT NULL | End Date |
| 8 | SP_PREMISE_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Premise Location
N=No Y=Yes |
| 9 | COMMENTS_254 | Character(254) | VARCHAR2(254) NOT NULL | EDI Comments |
| 10 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 11 | SPF_WO_HCM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Spro-HCM integration status on work order
C=HCM Job Record Created P=Pending T=Terminated |
| 12 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP |
Row Creation Date Time
Default Value: %DateTime |
| 13 | ROW_MODIFY_DATE | DateTime(26) | TIMESTAMP |
Modified Date Time
Default Value: %DateTime |
| 14 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 15 | ROW_MODIFY_USER | Character(30) | VARCHAR2(30) NOT NULL | Modified User |