WM_CREWSCHED_V1

(SQL View)
Index Back

Crew Capacity View


SELECT BUSINESS_UNIT , SHOP_ID , CREW_ID , SCHED_PATTERN , PERIOD_START_DT , PERIOD_END_DT FROM PS_WM_CREWSCHED

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_WM_NONVW

2 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Prompt Table: WM_SHOP_DEFN

3 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name

Prompt Table: WM_CREW_DEFN

4 SCHED_PATTERN Character(5) VARCHAR2(5) NOT NULL Schedule Pattern
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.