TS_ATTEND

TS_ATTEND_MONTH
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	ABSENTCOUNT	NUMBER	38	0			√
2	ABSENTLEN	NUMBER	11	2			√	0.00
3	ACTUALWORKDAYS	NUMBER	16	2			√	0.00
4	ACTUALWORKHOURS	NUMBER	16	2			√	0.00
5	BU_ID	VARCHAR2	36				√
6	CREATIONTIME	DATE	7				√
7	CREATOR	VARCHAR2	36				√
8	DR	NUMBER	10	0			√	0
9	EARLYCOUNT	NUMBER	38	0			√	0
10	EARLYLEN	NUMBER	11	2			√	0.00
11	ID	VARCHAR2	36		√
12	ISALLDUTY	CHAR	1				√
13	LATECOUNT	NUMBER	38	0			√	0
14	LATELEN	NUMBER	11	2			√	0.00
15	LEAVECOUNT	NUMBER	38	0			√
16	LEAVELEN	NUMBER	11	2			√
17	MODIFIEDTIME	DATE	7				√
18	MODIFIER	VARCHAR2	36				√
19	MONTH	NUMBER	38	0			√
20	ORG_ID	VARCHAR2	36				√
21	ORG_NAME	VARCHAR2	200				√
22	STAFF_CODE	VARCHAR2	100				√
23	STAFF_ID	VARCHAR2	36				√
24	STAFF_NAME	VARCHAR2	200				√
25	STAFFJOB_ID	VARCHAR2	36				√
26	TENANT_ID	VARCHAR2	36				√
27	TS	DATE	7				√	sysdate
28	WORKDAYS	NUMBER	16	2			√	0.00
29	WORKHOURS	NUMBER	16	2			√	0.00
30	WORKPERCENT	NUMBER	16	2			√	0.00
31	YEAR	CHAR	4				√