TS_MONTHSTAT

TS_MONTHSTAT_NCC
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	ABSENTCOUNT	NUMBER	38	0			√
2	ABSENTHOUR	NUMBER	16	4			√
3	ACTUALWORKDAYS	NUMBER	16	4			√
4	ACTUALWORKHOURS	NUMBER	16	4			√
5	BEGINDATE	CHAR	19				√
6	DEPTID	VARCHAR2	36				√
7	DR	NUMBER	10	0			√	0
8	EARLYCOUNT	NUMBER	38	0			√
9	EARLYLONG	NUMBER	16	4			√
10	ELASTICRULE	NUMBER	38	0			√
11	ENDDATE	CHAR	19				√
12	F_B_1	CHAR	1				√
13	F_B_10	CHAR	1				√
14	F_B_11	CHAR	1				√
15	F_B_12	CHAR	1				√
16	F_B_13	CHAR	1				√
17	F_B_14	CHAR	1				√
18	F_B_15	CHAR	1				√
19	F_B_16	CHAR	1				√
20	F_B_17	CHAR	1				√
21	F_B_18	CHAR	1				√
22	F_B_19	CHAR	1				√
23	F_B_2	CHAR	1				√
24	F_B_20	CHAR	1				√
25	F_B_3	CHAR	1				√
26	F_B_4	CHAR	1				√
27	F_B_5	CHAR	1				√
28	F_B_6	CHAR	1				√
29	F_B_7	CHAR	1				√
30	F_B_8	CHAR	1				√
31	F_B_9	CHAR	1				√
32	F_D_1	CHAR	19				√
33	F_D_10	CHAR	19				√
34	F_D_11	CHAR	19				√
35	F_D_12	CHAR	19				√
36	F_D_13	CHAR	19				√
37	F_D_14	CHAR	19				√
38	F_D_15	CHAR	19				√
39	F_D_16	CHAR	19				√
40	F_D_17	CHAR	19				√
41	F_D_18	CHAR	19				√
42	F_D_19	CHAR	19				√
43	F_D_2	CHAR	19				√
44	F_D_20	CHAR	19				√
45	F_D_3	CHAR	19				√
46	F_D_4	CHAR	19				√
47	F_D_5	CHAR	19				√
48	F_D_6	CHAR	19				√
49	F_D_7	CHAR	19				√
50	F_D_8	CHAR	19				√
51	F_D_9	CHAR	19				√
52	F_I_1	NUMBER	38	0			√
53	F_I_10	NUMBER	38	0			√
54	F_I_11	NUMBER	38	0			√
55	F_I_12	NUMBER	38	0			√
56	F_I_13	NUMBER	38	0			√
57	F_I_14	NUMBER	38	0			√
58	F_I_15	NUMBER	38	0			√
59	F_I_16	NUMBER	38	0			√
60	F_I_17	NUMBER	38	0			√
61	F_I_18	NUMBER	38	0			√
62	F_I_19	NUMBER	38	0			√
63	F_I_2	NUMBER	38	0			√
64	F_I_20	NUMBER	38	0			√
65	F_I_21	NUMBER	38	0			√
66	F_I_22	NUMBER	38	0			√
67	F_I_23	NUMBER	38	0			√
68	F_I_24	NUMBER	38	0			√
69	F_I_25	NUMBER	38	0			√
70	F_I_26	NUMBER	38	0			√
71	F_I_27	NUMBER	38	0			√
72	F_I_28	NUMBER	38	0			√
73	F_I_29	NUMBER	38	0			√
74	F_I_3	NUMBER	38	0			√
75	F_I_30	NUMBER	38	0			√
76	F_I_4	NUMBER	38	0			√
77	F_I_5	NUMBER	38	0			√
78	F_I_6	NUMBER	38	0			√
79	F_I_7	NUMBER	38	0			√
80	F_I_8	NUMBER	38	0			√
81	F_I_9	NUMBER	38	0			√
82	F_N_1	NUMBER	16	4			√
83	F_N_10	NUMBER	16	4			√
84	F_N_100	NUMBER	16	4			√
85	F_N_11	NUMBER	16	4			√
86	F_N_12	NUMBER	16	4			√
87	F_N_13	NUMBER	16	4			√
88	F_N_14	NUMBER	16	4			√
89	F_N_15	NUMBER	16	4			√
90	F_N_16	NUMBER	16	4			√
91	F_N_17	NUMBER	16	4			√
92	F_N_18	NUMBER	16	4			√
93	F_N_19	NUMBER	16	4			√
94	F_N_2	NUMBER	16	4			√
95	F_N_20	NUMBER	16	4			√
96	F_N_21	NUMBER	16	4			√
97	F_N_22	NUMBER	16	4			√
98	F_N_23	NUMBER	16	4			√
99	F_N_24	NUMBER	16	4			√
100	F_N_25	NUMBER	16	4			√
101	F_N_26	NUMBER	16	4			√
102	F_N_27	NUMBER	16	4			√
103	F_N_28	NUMBER	16	4			√
104	F_N_29	NUMBER	16	4			√
105	F_N_3	NUMBER	16	4			√
106	F_N_30	NUMBER	16	4			√
107	F_N_31	NUMBER	16	4			√
108	F_N_32	NUMBER	16	4			√
109	F_N_33	NUMBER	16	4			√
110	F_N_34	NUMBER	16	4			√
111	F_N_35	NUMBER	16	4			√
112	F_N_36	NUMBER	16	4			√
113	F_N_37	NUMBER	16	4			√
114	F_N_38	NUMBER	16	4			√
115	F_N_39	NUMBER	16	4			√
116	F_N_4	NUMBER	16	4			√
117	F_N_40	NUMBER	16	4			√
118	F_N_41	NUMBER	16	4			√
119	F_N_42	NUMBER	16	4			√
120	F_N_43	NUMBER	16	4			√
121	F_N_44	NUMBER	16	4			√
122	F_N_45	NUMBER	16	4			√
123	F_N_46	NUMBER	16	4			√
124	F_N_47	NUMBER	16	4			√
125	F_N_48	NUMBER	16	4			√
126	F_N_49	NUMBER	16	4			√
127	F_N_5	NUMBER	16	4			√
128	F_N_50	NUMBER	16	4			√
129	F_N_51	NUMBER	16	4			√
130	F_N_52	NUMBER	16	4			√
131	F_N_53	NUMBER	16	4			√
132	F_N_54	NUMBER	16	4			√
133	F_N_55	NUMBER	16	4			√
134	F_N_56	NUMBER	16	4			√
135	F_N_57	NUMBER	16	4			√
136	F_N_58	NUMBER	16	4			√
137	F_N_59	NUMBER	16	4			√
138	F_N_6	NUMBER	16	4			√
139	F_N_60	NUMBER	16	4			√
140	F_N_61	NUMBER	16	4			√
141	F_N_62	NUMBER	16	4			√
142	F_N_63	NUMBER	16	4			√
143	F_N_64	NUMBER	16	4			√
144	F_N_65	NUMBER	16	4			√
145	F_N_66	NUMBER	16	4			√
146	F_N_67	NUMBER	16	4			√
147	F_N_68	NUMBER	16	4			√
148	F_N_69	NUMBER	16	4			√
149	F_N_7	NUMBER	16	4			√
150	F_N_70	NUMBER	16	4			√
151	F_N_71	NUMBER	16	4			√
152	F_N_72	NUMBER	16	4			√
153	F_N_73	NUMBER	16	4			√
154	F_N_74	NUMBER	16	4			√
155	F_N_75	NUMBER	16	4			√
156	F_N_76	NUMBER	16	4			√
157	F_N_77	NUMBER	16	4			√
158	F_N_78	NUMBER	16	4			√
159	F_N_79	NUMBER	16	4			√
160	F_N_8	NUMBER	16	4			√
161	F_N_80	NUMBER	16	4			√
162	F_N_81	NUMBER	16	4			√
163	F_N_82	NUMBER	16	4			√
164	F_N_83	NUMBER	16	4			√
165	F_N_84	NUMBER	16	4			√
166	F_N_85	NUMBER	16	4			√
167	F_N_86	NUMBER	16	4			√
168	F_N_87	NUMBER	16	4			√
169	F_N_88	NUMBER	16	4			√
170	F_N_89	NUMBER	16	4			√
171	F_N_9	NUMBER	16	4			√
172	F_N_90	NUMBER	16	4			√
173	F_N_91	NUMBER	16	4			√
174	F_N_92	NUMBER	16	4			√
175	F_N_93	NUMBER	16	4			√
176	F_N_94	NUMBER	16	4			√
177	F_N_95	NUMBER	16	4			√
178	F_N_96	NUMBER	16	4			√
179	F_N_97	NUMBER	16	4			√
180	F_N_98	NUMBER	16	4			√
181	F_N_99	NUMBER	16	4			√
182	F_V_1	VARCHAR2	128				√
183	F_V_10	VARCHAR2	128				√
184	F_V_11	VARCHAR2	128				√
185	F_V_12	VARCHAR2	128				√
186	F_V_13	VARCHAR2	128				√
187	F_V_14	VARCHAR2	128				√
188	F_V_15	VARCHAR2	128				√
189	F_V_16	VARCHAR2	128				√
190	F_V_17	VARCHAR2	128				√
191	F_V_18	VARCHAR2	128				√
192	F_V_19	VARCHAR2	128				√
193	F_V_2	VARCHAR2	128				√
194	F_V_20	VARCHAR2	128				√
195	F_V_3	VARCHAR2	128				√
196	F_V_4	VARCHAR2	128				√
197	F_V_5	VARCHAR2	128				√
198	F_V_6	VARCHAR2	128				√
199	F_V_7	VARCHAR2	128				√
200	F_V_8	VARCHAR2	128				√
201	F_V_9	VARCHAR2	128				√
202	ID	VARCHAR2	36		√
203	ISALLDUTY	CHAR	1				√
204	ISAPPROVE	CHAR	1				√
205	ISEFFECTIVE	CHAR	1				√
206	ISUSEFUL	CHAR	1				√
207	LACTATIONCOUNT	NUMBER	38	0			√
208	LATECOUNT	NUMBER	38	0			√
209	LATELONG	NUMBER	16	4			√
210	LEAVECNT	NUMBER	38	0			√
211	LIMITTIME	NUMBER	38	0			√
212	NIGHTSHIFTHOUR	NUMBER	16	4			√
213	NOBRUSHCOUNT	NUMBER	38	0			√
214	ORGID	VARCHAR2	36				√
215	OUTSIDECNT	NUMBER	38	0			√
216	RESIGNCNT	NUMBER	38	0			√
217	STAFFID	VARCHAR2	36				√
218	STORE	NUMBER	8	4			√
219	STOREUNIT	NUMBER	38	0			√
220	TRIPCNT	NUMBER	38	0			√
221	TS	DATE	7				√	sysdate
222	TSMONTH	CHAR	2				√
223	TSYEAR	CHAR	4				√
224	UNNORMALLEN	NUMBER	16	4			√
225	WORKDAYS	NUMBER	16	4			√
226	WORKHOURS	NUMBER	16	4			√
227	WORKPERCENT	NUMBER	16	4			√