MG_CALENDAR_WK (SQL Table)	Index Back
Production Calendar Work Table 03/04/97 RPS (CN# MG700-1.0): Added Calendar_Code field for Calendar Code Enhancement. 06/30/98 WHS CN#DI-RSHANKAR-4 - Prevent production calendar deletions that would cause alt. cal. to go out of range 11/14/98 TKI Testing to get PC compares to work

MG_CALENDAR_WK

(SQL Table)

Production Calendar Work Table

03/04/97 RPS (CN# MG700-1.0): Added Calendar_Code field for Calendar Code Enhancement. 06/30/98 WHS CN#DI-RSHANKAR-4 - Prevent production calendar deletions that would cause alt. cal. to go out of range 11/14/98 TKI Testing to get PC compares to work

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

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 SA8 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

14 SA9 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

15 SA10 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

16 SA11 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

17 SA12 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

18 SA13 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

19 SA14 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

20 SA15 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

21 SA16 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

22 SA17 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

23 SA18 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

24 SA19 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

25 SA20 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

26 SA21 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

27 SA22 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

28 SA23 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

29 SA24 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

30 SA25 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

31 SA26 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

32 SA27 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

33 SA28 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

34 SA29 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

35 SA30 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

36 SA31 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

37 SA32 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

38 SA33 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

39 SA34 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

40 SA35 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

41 SB1 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

42 SB2 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

43 SB3 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

44 SB4 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

45 SB5 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

46 SB6 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

47 SB7 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

48 SB8 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

49 SB9 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

50 SB10 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

51 SB11 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

52 SB12 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

53 SB13 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

54 SB14 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

55 SB15 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

56 SB16 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

57 SB17 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

58 SB18 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

59 SB19 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

60 SB20 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

61 SB21 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

62 SB22 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

63 SB23 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

64 SB24 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

65 SB25 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

66 SB26 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

67 SB27 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

68 SB28 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

69 SB29 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

70 SB30 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

71 SB31 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

72 SB32 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

73 SB33 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

74 SB34 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

75 SB35 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

76 SC1 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

77 SC2 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

78 SC3 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

79 SC4 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

80 SC5 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

81 SC6 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

82 SC7 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

83 SC8 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

84 SC9 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

85 SC10 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

86 SC11 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

87 SC12 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

88 SC13 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

89 SC14 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

90 SC15 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

91 SC16 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

92 SC17 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

93 SC18 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

94 SC19 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

95 SC20 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

96 SC21 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

97 SC22 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

98 SC23 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

99 SC24 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

100 SC25 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

101 SC26 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

102 SC27 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

103 SC28 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

104 SC29 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

105 SC30 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

106 SC31 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

107 SC32 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

108 SC33 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

109 SC34 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

110 SC35 Number(2,0) SMALLINT NOT NULL
Prompt Table: MG_SHIFTS_VW

111 ZBOX Character(35) VARCHAR2(35) NOT NULL zero out box

#	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.
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	SA8	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
14	SA9	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
15	SA10	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
16	SA11	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
17	SA12	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
18	SA13	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
19	SA14	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
20	SA15	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
21	SA16	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
22	SA17	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
23	SA18	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
24	SA19	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
25	SA20	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
26	SA21	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
27	SA22	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
28	SA23	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
29	SA24	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
30	SA25	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
31	SA26	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
32	SA27	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
33	SA28	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
34	SA29	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
35	SA30	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
36	SA31	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
37	SA32	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
38	SA33	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
39	SA34	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
40	SA35	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
41	SB1	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
42	SB2	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
43	SB3	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
44	SB4	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
45	SB5	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
46	SB6	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
47	SB7	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
48	SB8	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
49	SB9	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
50	SB10	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
51	SB11	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
52	SB12	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
53	SB13	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
54	SB14	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
55	SB15	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
56	SB16	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
57	SB17	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
58	SB18	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
59	SB19	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
60	SB20	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
61	SB21	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
62	SB22	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
63	SB23	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
64	SB24	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
65	SB25	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
66	SB26	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
67	SB27	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
68	SB28	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
69	SB29	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
70	SB30	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
71	SB31	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
72	SB32	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
73	SB33	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
74	SB34	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
75	SB35	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
76	SC1	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
77	SC2	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
78	SC3	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
79	SC4	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
80	SC5	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
81	SC6	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
82	SC7	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
83	SC8	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
84	SC9	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
85	SC10	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
86	SC11	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
87	SC12	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
88	SC13	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
89	SC14	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
90	SC15	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
91	SC16	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
92	SC17	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
93	SC18	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
94	SC19	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
95	SC20	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
96	SC21	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
97	SC22	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
98	SC23	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
99	SC24	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
100	SC25	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
101	SC26	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
102	SC27	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
103	SC28	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
104	SC29	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
105	SC30	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
106	SC31	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
107	SC32	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
108	SC33	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
109	SC34	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
110	SC35	Number(2,0)	SMALLINT NOT NULL	Prompt Table: MG_SHIFTS_VW
111	ZBOX	Character(35)	VARCHAR2(35) NOT NULL	zero out box