WM_SHOPSCHED_VW(SQL View) |
Index Back |
---|---|
Shop Schedulers |
SELECT B.BUSINESS_UNIT , B.SHOP_ID , B.SCHEDULER_CODE , B.EMPLID , C.NAME , B.SHIFT_ID FROM PS_WM_SHOP_SCHED_H A , PS_WM_SHOP_SCHEDLR B , PS_PERSONAL_DATA C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SHOP_ID = B.SHOP_ID AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = 'A' AND B.EMPLID = C.EMPLID AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_WM_SHOP_SCHED_H D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.SHOP_ID = D.SHOP_ID) |
# | 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 |
6 | SHIFT_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shift ID
Default Value: WM_SHOP_RES_VW.SHIFT_ID Prompt Table: WM_SHIFT_VW |