ASSET_WO_VW(SQL View) |
Index Back |
|---|---|
Asset Work Orders view |
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.BUSINESS_UNIT_WO , A.WO_ID , A.RESPONSIBILITY , W.PM_SCHD_ID , W.REQ_START_DT , W.COMPLTED_DT , W.WO_TYPE , W.STATUS_CD , W.WO_APPROVAL_STATUS , W.DESCR254 FROM PS_ASSET_MAINT A , PS_WM_WO_HDR W WHERE A.BUSINESS_UNIT_WO = W.BUSINESS_UNIT AND A.WO_ID = W.WO_ID |
| # | 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_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table: SP_BU_WM_NONVW |
| 4 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table: WM_WO_TSK_VW3 |
| 5 | RESPONSIBILITY | Character(30) | VARCHAR2(30) NOT NULL | Responsibility |
| 6 | PM_SCHD_ID | Character(10) | VARCHAR2(10) NOT NULL | Preventive Maintenance Schedule ID |
| 7 | REQ_START_DT | Date(10) | DATE | Required Start |
| 8 | COMPLTED_DT | Date(10) | DATE | Completed Date |
| 9 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table: WM_WO_TYPE |
| 10 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table: WM_STATUS_HDR |
| 11 | WO_APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
work order approval status
A=Approved C=Cancelled E=Denied I=Initial P=Pending Approval Default Value: I |
| 12 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |