SETIDBUSINESS_UNITSHOP_IDCREW_IDSCHED_PATTERNPERIOD_START_DTWM_PERIODDT_DVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.SETID , C.BUSINESS_UNIT , C.SHOP_ID , C.CREW_ID , A.SCHED_PATTERN , A.PERIOD_START_DT , A.PERIOD_END_DT FROM PS_WM_SCHED_PERIOD A , PS_WM_SCHED_PTRN B , PS_WM_CREW_HDR C WHERE A.SETID = B.SETID AND A.SCHED_PATTERN = B.SCHED_PATTERN AND B.ACTIVE_FLG = 'Y' AND A.SCHED_PATTERN = C.SCHED_PATTERN AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_WM_CREW_HDR X WHERE X.BUSINESS_UNIT = C.BUSINESS_UNIT AND X.SHOP_ID = C.SHOP_ID AND X.CREW_ID = C.CREW_ID AND X.EFFDT <= A.PERIOD_START_DT ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | SHOP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
| 4 | CREW_ID |
Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 5 | SCHED_PATTERN |
Character(5) | VARCHAR2(5) NOT NULL | Schedule Pattern |
| 6 | PERIOD_START_DT |
Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 7 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |