TS_DAYSTAT

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