SPF_WO_HISTORY(SQL Table) |
Index Back |
|---|---|
SP Work Order HistoryKeeps track of either the "Work Order Status" changes or "Route To" changes that happen during the work order process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Work Order ID
Prompt Table:
SPF_WORDERREC
|
| 3 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | WO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Status
A=Approved C=Closed D=Denied F=Finalize L=Released N=Canceled O=Open P=Pending Terminate S=Submitted T=Terminated Prompt Table: SPF_WORDERREC |
| 5 | SP_ROUTE_TO | Character(30) | VARCHAR2(30) NOT NULL | WorkOrder Approver Person. |
| 6 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP NOT NULL | Row Creation Date Time |
| 7 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 8 | TE_TEMPLATE_ID | Character(8) | VARCHAR2(8) NOT NULL | Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets. |
| 9 | INVAPPROVER | Character(30) | VARCHAR2(30) NOT NULL | Invoice Approver |
| 10 | REASON_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Reason Type |
| 11 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 12 | COMMENTS | Long Character | CLOB | Comment |
| 13 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 14 | END_DATE | Date(10) | DATE | End Date |
| 15 | ACT_START_DT | Date(10) | DATE | Activity Start Date |
| 16 | ACT_END_DT | Date(10) | DATE | Activity End Date |
| 17 | RECRUITER | Character(15) | VARCHAR2(15) NOT NULL | Service Coordinator |
| 18 | TEAM_ID | Character(15) | VARCHAR2(15) NOT NULL | Team ID |
| 19 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider's ID assigned on work order |