WM_ADDSCHED_VW

(SQL View)
Index Back

SELECT BUSINESS_UNIT , SHOP_ID , CREW_ID , PERIOD_START_DT , SCHED_PATTERN , 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

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT

Prompt Table: SP_BU_WM_NONVW

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

Prompt Table: WM_SHOP_VW3

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

Prompt Table: WM_CREW_DEFN_VW

4 PERIOD_START_DT Date(10) DATE NOT NULL Represents the date commencement point for a given time set utilized in cash worksheet processing.

Prompt Table: WM_SCHEDPER_VW

5 SCHED_PATTERN Character(5) VARCHAR2(5) NOT NULL Schedule Pattern

Default Value: WM_SCHEDPER_VW.SCHED_PATTERN

6 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.

Default Value: WM_SCHEDPER_VW.PERIOD_END_DT