TS_DAYSTAT

TS_DAYSTAT_TODAY
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
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	FIRSTBEGINSIGN	DATE	7				√
16	FIRSTBEGINSIGNSTATUS	NUMBER	38	0			√
17	FIRSTENDSIGN	DATE	7				√
18	FIRSTENDSIGNSTATUS	NUMBER	38	0			√
19	ID	VARCHAR2	36		√
20	ISABSENT	CHAR	1				√
21	ISAPPROVE	CHAR	1				√
22	ISEARLY	CHAR	1				√
23	ISEFFECTIVE	CHAR	1				√
24	ISFILLATTEND	CHAR	1				√
25	ISLATER	CHAR	1				√
26	ISLEAVE	CHAR	1				√
27	ISNIGHTSHIFT	CHAR	1				√
28	ISNORMAL	CHAR	1				√
29	ISOUTSIDE	CHAR	1				√
30	ISUSELACTATION	CHAR	1				√
31	LACTATIONCOUNT	NUMBER	38	0			√
32	LATECOUNT	NUMBER	38	0			√
33	LATELONG	NUMBER	8	4			√
34	LEAVECNT	NUMBER	38	0			√
35	MODIFIEDTIME	DATE	7				√
36	MODIFIER	VARCHAR2	36				√
37	NIGHTSHIFTHOUR	NUMBER	8	4			√
38	ORG_ID	VARCHAR2	36				√
39	ORIGINAL_ISNORMAL	CHAR	1				√
40	OUTSIDECOUNT	NUMBER	38	0			√
41	PK_PSNCALENDAR	VARCHAR2	36				√
42	PK_TIMEDATA	VARCHAR2	36				√
43	RESIGNCNT	NUMBER	38	0			√
44	RULEID	VARCHAR2	36				√
45	SHIFT_ID	VARCHAR2	36				√
46	SHIFTBEGINTIME	DATE	7				√
47	SHIFTENDTIME	DATE	7				√
48	SIGNBEGINTIME	DATE	7				√
49	SIGNENDTIME	DATE	7				√
50	STAFF_ID	VARCHAR2	36				√
51	STORE	NUMBER	8	4			√
52	STOREUNIT	NUMBER	38	0			√
53	TENANTID	VARCHAR2	36				√
54	TRIPCNT	NUMBER	38	0			√
55	TS	DATE	7				√	sysdate
56	UNNORMALLEN	NUMBER	16	4			√
57	WORKDAYS	NUMBER	8	4			√
58	WORKHOURS	NUMBER	8	4			√