MG_CAL_WK_VW

(SQL View)
 Index Back

Manufacturing Calendar WK View

03/04/97 RPS (CN# MG700-1.0): Added Calendar_Code field for Calendar Code Enhancement.

select BUSINESS_UNIT, CALENDAR_CODE, MFG_YEAR , MONTHCD ,DAY_POSX ,SA1 ,SA2 ,SA3 ,SA4 ,SA5 ,SA6 ,SA7 ,SA29 ,SA30 ,SA31 ,SA32 ,SA33 ,SA34 ,SA35 ,SB1 ,SB2 ,SB3 ,SB4 ,SB5 ,SB6 ,SB7 ,SB29 ,SB30 ,SB31 ,SB32 ,SB33 ,SB34 ,SB35 ,SC1 ,SC2 ,SC3 ,SC4 ,SC5 ,SC6 ,SC7 ,SC29 ,SC30 ,SC31 ,SC32 ,SC33 ,SC34 ,SC35 from PS_MG_CALENDAR_WK

# 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_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

2 CALENDAR_CODE Character(10) VARCHAR2(10) NOT NULL This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts.

Prompt Table: MG_CALENDAR_WK

3 MFG_YEAR Number(4,0) SMALLINT NOT NULL Year
4 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
5 DAY_POSX Character(70) VARCHAR2(70) NOT NULL Day String
6 SA1 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

7 SA2 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

8 SA3 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

9 SA4 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

10 SA5 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

11 SA6 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

12 SA7 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

13 SA29 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

14 SA30 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

15 SA31 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

16 SA32 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

17 SA33 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

18 SA34 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

19 SA35 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

20 SB1 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

21 SB2 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

22 SB3 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

23 SB4 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

24 SB5 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

25 SB6 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

26 SB7 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

27 SB29 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

28 SB30 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

29 SB31 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

30 SB32 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

31 SB33 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

32 SB34 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

33 SB35 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

34 SC1 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

35 SC2 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

36 SC3 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

37 SC4 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

38 SC5 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

39 SC6 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

40 SC7 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

41 SC29 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

42 SC30 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

43 SC31 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

44 SC32 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

45 SC33 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

46 SC34 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW

47 SC35 Number(2,0) SMALLINT NOT NULL

Prompt Table: MG_SHIFTS_VW