MG_CAL_WKC_WK

(SQL Table)
 Index Back

Mfg WKC Calendar WK Table

# 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 MFG_YEAR Number(4,0) SMALLINT NOT NULL Year
3 WKCTR Character(10) VARCHAR2(10) NOT NULL Work Center

Prompt Table: EN_WORK_CENTER

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

Prompt Table: MG_CAL_SRCH_VW

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 CA1 Number(3,0) SMALLINT NOT NULL
112 CA2 Number(3,0) SMALLINT NOT NULL
113 CA3 Number(3,0) SMALLINT NOT NULL
114 CA4 Number(3,0) SMALLINT NOT NULL
115 CA5 Number(3,0) SMALLINT NOT NULL
116 CA6 Number(3,0) SMALLINT NOT NULL
117 CA7 Number(3,0) SMALLINT NOT NULL
118 CA8 Number(3,0) SMALLINT NOT NULL
119 CA9 Number(3,0) SMALLINT NOT NULL
120 CA10 Number(3,0) SMALLINT NOT NULL
121 CA11 Number(3,0) SMALLINT NOT NULL
122 CA12 Number(3,0) SMALLINT NOT NULL
123 CA13 Number(3,0) SMALLINT NOT NULL
124 CA14 Number(3,0) SMALLINT NOT NULL
125 CA15 Number(3,0) SMALLINT NOT NULL
126 CA16 Number(3,0) SMALLINT NOT NULL
127 CA17 Number(3,0) SMALLINT NOT NULL
128 CA18 Number(3,0) SMALLINT NOT NULL
129 CA19 Number(3,0) SMALLINT NOT NULL
130 CA20 Number(3,0) SMALLINT NOT NULL
131 CA21 Number(3,0) SMALLINT NOT NULL
132 CA22 Number(3,0) SMALLINT NOT NULL
133 CA23 Number(3,0) SMALLINT NOT NULL
134 CA24 Number(3,0) SMALLINT NOT NULL
135 CA25 Number(3,0) SMALLINT NOT NULL
136 CA26 Number(3,0) SMALLINT NOT NULL
137 CA27 Number(3,0) SMALLINT NOT NULL
138 CA28 Number(3,0) SMALLINT NOT NULL
139 CA29 Number(3,0) SMALLINT NOT NULL
140 CA30 Number(3,0) SMALLINT NOT NULL
141 CA31 Number(3,0) SMALLINT NOT NULL
142 CA32 Number(3,0) SMALLINT NOT NULL
143 CA33 Number(3,0) SMALLINT NOT NULL
144 CA34 Number(3,0) SMALLINT NOT NULL
145 CA35 Number(3,0) SMALLINT NOT NULL
146 CB1 Number(3,0) SMALLINT NOT NULL
147 CB2 Number(3,0) SMALLINT NOT NULL
148 CB3 Number(3,0) SMALLINT NOT NULL
149 CB4 Number(3,0) SMALLINT NOT NULL
150 CB5 Number(3,0) SMALLINT NOT NULL
151 CB6 Number(3,0) SMALLINT NOT NULL
152 CB7 Number(3,0) SMALLINT NOT NULL
153 CB8 Number(3,0) SMALLINT NOT NULL
154 CB9 Number(3,0) SMALLINT NOT NULL
155 CB10 Number(3,0) SMALLINT NOT NULL
156 CB11 Number(3,0) SMALLINT NOT NULL
157 CB12 Number(3,0) SMALLINT NOT NULL
158 CB13 Number(3,0) SMALLINT NOT NULL
159 CB14 Number(3,0) SMALLINT NOT NULL
160 CB15 Number(3,0) SMALLINT NOT NULL
161 CB16 Number(3,0) SMALLINT NOT NULL
162 CB17 Number(3,0) SMALLINT NOT NULL
163 CB18 Number(3,0) SMALLINT NOT NULL
164 CB19 Number(3,0) SMALLINT NOT NULL
165 CB20 Number(3,0) SMALLINT NOT NULL
166 CB21 Number(3,0) SMALLINT NOT NULL
167 CB22 Number(3,0) SMALLINT NOT NULL
168 CB23 Number(3,0) SMALLINT NOT NULL
169 CB24 Number(3,0) SMALLINT NOT NULL
170 CB25 Number(3,0) SMALLINT NOT NULL
171 CB26 Number(3,0) SMALLINT NOT NULL
172 CB27 Number(3,0) SMALLINT NOT NULL
173 CB28 Number(3,0) SMALLINT NOT NULL
174 CB29 Number(3,0) SMALLINT NOT NULL
175 CB30 Number(3,0) SMALLINT NOT NULL
176 CB31 Number(3,0) SMALLINT NOT NULL
177 CB32 Number(3,0) SMALLINT NOT NULL
178 CB33 Number(3,0) SMALLINT NOT NULL
179 CB34 Number(3,0) SMALLINT NOT NULL
180 CB35 Number(3,0) SMALLINT NOT NULL
181 CC1 Number(3,0) SMALLINT NOT NULL
182 CC2 Number(3,0) SMALLINT NOT NULL
183 CC3 Number(3,0) SMALLINT NOT NULL
184 CC4 Number(3,0) SMALLINT NOT NULL
185 CC5 Number(3,0) SMALLINT NOT NULL
186 CC6 Number(3,0) SMALLINT NOT NULL
187 CC7 Number(3,0) SMALLINT NOT NULL
188 CC8 Number(3,0) SMALLINT NOT NULL
189 CC9 Number(3,0) SMALLINT NOT NULL
190 CC10 Number(3,0) SMALLINT NOT NULL
191 CC11 Number(3,0) SMALLINT NOT NULL
192 CC12 Number(3,0) SMALLINT NOT NULL
193 CC13 Number(3,0) SMALLINT NOT NULL
194 CC14 Number(3,0) SMALLINT NOT NULL
195 CC15 Number(3,0) SMALLINT NOT NULL
196 CC16 Number(3,0) SMALLINT NOT NULL
197 CC17 Number(3,0) SMALLINT NOT NULL
198 CC18 Number(3,0) SMALLINT NOT NULL
199 CC19 Number(3,0) SMALLINT NOT NULL
200 CC20 Number(3,0) SMALLINT NOT NULL
201 CC21 Number(3,0) SMALLINT NOT NULL
202 CC22 Number(3,0) SMALLINT NOT NULL
203 CC23 Number(3,0) SMALLINT NOT NULL
204 CC24 Number(3,0) SMALLINT NOT NULL
205 CC25 Number(3,0) SMALLINT NOT NULL
206 CC26 Number(3,0) SMALLINT NOT NULL
207 CC27 Number(3,0) SMALLINT NOT NULL
208 CC28 Number(3,0) SMALLINT NOT NULL
209 CC29 Number(3,0) SMALLINT NOT NULL
210 CC30 Number(3,0) SMALLINT NOT NULL
211 CC31 Number(3,0) SMALLINT NOT NULL
212 CC32 Number(3,0) SMALLINT NOT NULL
213 CC33 Number(3,0) SMALLINT NOT NULL
214 CC34 Number(3,0) SMALLINT NOT NULL
215 CC35 Number(3,0) SMALLINT NOT NULL
216 ZBOX Character(35) VARCHAR2(35) NOT NULL zero out box