WM_CSRPT_VW(SQL View) |
Index Back |
|---|
| SELECT L.BUSINESS_UNIT , L.WO_ID , L.WO_TASK_ID , L.RES_LN_NBR , L.RQMT_LN_NBR , L.CRAFT_ID , L.EMPLID , P.NAME , L.SCHED_START_DT , L.SCHED_START_TIME , L.SCHED_END_DT , L.SCHED_END_TIME , L.ACTL_DURATION , L.SHOP_ID ,%subrec(WM_CREW_SBR, L) FROM PS_WM_WO_SCHED_LBR L , PS_PERSONAL_DATA P WHERE L.EMPLID = P.EMPLID (+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 4 | RES_LN_NBR |
Number(5,0) | INTEGER NOT NULL |
Resource Line No.
Default Value: WM_WO_TSK.LAST_SCHEDLN_LBR |
| 5 | RQMT_LN_NBR | Number(5,0) | INTEGER NOT NULL | Requirement Line Number |
| 6 | CRAFT_ID | Character(16) | VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table: RS_CRAFT_DETAIL |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: WM_ELGBL_WRKR |
| 8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 9 | SCHED_START_DT | Date(10) | DATE |
Scheduled Start Date
Default Value: WM_WO_TSK.SCHED_START_DT |
| 10 | SCHED_START_TIME | Time(15) | TIMESTAMP |
Schedule Start Time
Default Value: WM_WO_TSK.SCHED_START_TIME |
| 11 | SCHED_END_DT | Date(10) | DATE |
Scheduled End Date
Default Value: WM_WO_TSK.SCHED_END_DT |
| 12 | SCHED_END_TIME | Time(15) | TIMESTAMP |
Schedule End Time
Default Value: WM_WO_TSK.SCHED_END_TIME |
| 13 | ACTL_DURATION | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Actual Duration |
| 14 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
| 15 | CREW_BU | Character(5) | VARCHAR2(5) NOT NULL |
Crew Business Unit
Prompt Table: SP_BU_WM_NONVW |
| 16 | CREW_SHOP | Character(10) | VARCHAR2(10) NOT NULL |
Crew Shop ID
Prompt Table: WM_CREWSHOP_VW |
| 17 | CREW_ID | Character(10) | VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table: WM_PREFCREW_VW |