BUSINESS_UNITWR_IDSEQ_NBR1=Service Request
2=Close Work Order
WM_WR_AUDIT(SQL Table) |
Index Back |
|---|---|
Work Request AuditAudit changes to selected work request fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WR_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Request ID |
| 3 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | OLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | OLD VALUE |
| 6 | NEW_VAL | Character(50) | VARCHAR2(50) NOT NULL | NEW VALUE |
| 7 | WR_AUDIT_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Source of Change
1=Service Request 2=Close Work Order |
| 8 | CREATED_BY_USER | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 9 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date and time |