SETIDPrompt Table:
SP_SETID_NONVW
Set Control Field: BUSINESS_UNIT
BUSINESS_UNITSHOP_IDCREW_IDPERIOD_START_DTWM_SCHEDPER_VW(SQL View) |
Index Back |
|---|---|
Valid Crew Period Start DateValid Crew Period Start Date |
| SELECT DISTINCT A.SETID , C.BUSINESS_UNIT , C.SHOP_ID , C.CREW_ID , A.PERIOD_START_DT , A.PERIOD_END_DT , A.SCHED_PATTERN 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 %DateAdd(A.PERIOD_START_DT, B.DAYS_IN_PERIOD) >= %CurrentDateIn 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
Prompt Table:
SP_SETID_NONVW
|
| 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 | PERIOD_START_DT |
Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 6 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 7 | SCHED_PATTERN | Character(5) | VARCHAR2(5) NOT NULL | Schedule Pattern |