SPF_AUDIT_WO(SQL Table) |
Index Back |
|---|---|
Work Order Audit record |
| # | 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 | ROW_MODIFY_DATE |
DateTime(26) | TIMESTAMP | Modified Date Time |
| 4 | USE_SP_LOC_SUT | Character(1) | VARCHAR2(1) NOT NULL |
Service Performed Location
1=Work Order Location 2=Supplier Location 3=Service Provider Location 4=Other Location |
| 5 | VNDR_LOC_SP | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | 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 |
| 7 | AUDIT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| 8 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |