WM_TE_LBR(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.OPRID , B.BUSINESS_UNIT , B.WO_ID , B.WO_TASK_ID , L.EMPLID , L.CRAFT_ID , L.RES_LN_NBR , T.BUSINESS_UNIT_AM , T.ASSET_ID , T.ASSET_LOCATION , T.LOCATION , W.SHOP_ID , T.BUSINESS_UNIT_PC , T.PROJECT_ID , T.ACTIVITY_ID , L.ASSIGNMENT_ID , B.INTERNAL_STATUS , B.STATUS_CD , L.LABOR_COST_RATE , L.LABOR_BILL_RATE FROM PS_WM_WOE_WB_VW B LEFT OUTER JOIN PS_WM_WO_SCHED_LBR L ON B.BUSINESS_UNIT = L.BUSINESS_UNIT AND B.WO_ID = L.WO_ID AND B.WO_TASK_ID = L.WO_TASK_ID AND L.EMPLID <> ' ' AND L.ACTL_SOURCE_CD NOT IN ('W') , PS_WM_WO_HDR W , PS_WM_WO_TSK T WHERE %Join(COMMON_KEYS, WM_WOE_WB_VW B, WM_WO_TSK T) AND %Join(COMMON_KEYS, WM_WO_HDR W, WM_WO_TSK T) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 4 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | CRAFT_ID | Character(16) | VARCHAR2(16) NOT NULL | Craft Identification |
| 7 | RES_LN_NBR | Number(5,0) | INTEGER NOT NULL | Resource Line No. |
| 8 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: BUS_UNIT_AM_VW |
| 9 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 10 | ASSET_LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Asset Location
Prompt Table: ASSET_LOCATION |
| 11 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 12 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
| 13 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Default Value: BUS_UNIT_TBL_WM.BUSINESS_UNIT_PC |
| 14 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: WM_WO_HDR.PROJECT_ID Prompt Table: WM_PC_PRJ_VW |
| 15 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACTIVITY |
| 16 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 17 | INTERNAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Internal Status
01=Open 02=Awaiting Schedule 03=Scheduled 04=Work In Progress 05=Complete 06=Closed 07=Canceled 08=On Hold 09=Work Order Created |
| 18 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL | User defined Status Code |
| 19 | LABOR_COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
| 20 | LABOR_BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |