BUSINESS_UNITSHOP_IDSCHEDULER_CODEPrompt Table: WM_SHOP_RES_VW
WM_SCHEDULER_VW(SQL View) |
Index Back |
|---|---|
Shop Schedulers |
| SELECT A.BUSINESS_UNIT , A.SHOP_ID , A.SCHEDULER_CODE , A.EMPLID , C.NAME FROM PS_WM_SHOP_SCHEDLR A , PS_WM_SHOP_SCHED_H B , PS_PERSONAL_DATA C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SHOP_ID = B.SHOP_ID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_WM_SHOP_SCHED_H B1 WHERE B1.BUSINESS_UNIT = B.BUSINESS_UNIT AND B1.SHOP_ID = B.SHOP_ID AND B1.EFFDT <= %CurrentDateIn) AND A.EFFDT = B.EFFDT AND A.EMPLID = C.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SHOP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
| 3 | SCHEDULER_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Scheduler Code |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: WM_SHOP_RES_VW |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |