BUSINESS_UNITASSET_IDA=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval
PI_WO_VW(SQL View) |
Index Back |
|---|---|
Work Orders for an AssetAsset Tracking Quick Scan Work Order information. |
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.BUSINESS_UNIT_WO , A.WO_ID , B.PM_SCHD_ID , B.REQ_START_DT , B.COMPLTED_DT , B.WO_TYPE , B.STATUS_CD , B.WO_APPROVAL_STATUS , A.RESPONSIBILITY , A.MAINT_TYPE , B.DESCR254 FROM %Table(ASSET_MAINT) A , %Table(WM_WO_HDR) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_AM AND A.ASSET_ID = B.ASSET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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 |
| 4 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 5 | PM_SCHD_ID | Character(10) | VARCHAR2(10) NOT NULL | Preventive Maintenance Schedule ID |
| 6 | REQ_START_DT | Date(10) | DATE | Required Start |
| 7 | COMPLTED_DT | Date(10) | DATE | Completed Date |
| 8 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Work Order Type |
| 9 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL | User defined Status Code |
| 10 | WO_APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
work order approval status
A=Approved C=Cancelled E=Denied I=Initial P=Pending Approval |
| 11 | RESPONSIBILITY | Character(30) | VARCHAR2(30) NOT NULL | Responsibility |
| 12 | MAINT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | This field is used for maintenance type |
| 13 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |