TS_OVERTIME_RULE 返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | WORKRESTOVERTIME | VARCHAR2 | 1 | | | | √ | | |
2 | BUSIORG | VARCHAR2 | 36 | | | | √ | | |
3 | CREATIONTIME | DATE | 7 | | | | √ | | |
4 | CREATOR | VARCHAR2 | 36 | | | | √ | | |
5 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
6 | ENABLESTATE | VARCHAR2 | 1 | | | | √ | | |
7 | HOLIDAYBCTYPE | VARCHAR2 | 1 | | | | √ | | |
8 | HOLIDAYBEGININ | VARCHAR2 | 1 | | | | √ | | |
9 | HOLIDAYCALTYPE | VARCHAR2 | 1 | | | | √ | | |
10 | HOLIDAYCHECKSIGN | VARCHAR2 | 1 | | | | √ | | |
11 | HOLIDAYDECTIMES | VARCHAR2 | 50 | | | | √ | | |
12 | HOLIDAYENDIN | VARCHAR2 | 1 | | | | √ | | |
13 | HOLIDAYOVERTIMETYPE | VARCHAR2 | 2 | | | | √ | | |
14 | HOLIDAYTURNRATE | NUMBER | 38 | 0 | | | √ | | |
15 | ID | VARCHAR2 | 36 | | √ | | | | |
16 | INCREMENTALS | NUMBER | 38 | 0 | | | √ | | |
17 | ISDEFAULT | VARCHAR2 | 1 | | | | √ | | |
18 | MANAGERCARDSHOW | VARCHAR2 | 1 | | | | √ | | |
19 | MINMINITUS | NUMBER | 38 | 0 | | | √ | | |
20 | MODIFIEDTIME | DATE | 7 | | | | √ | | |
21 | MODIFIER | VARCHAR2 | 36 | | | | √ | | |
22 | ORGID | VARCHAR2 | 36 | | | | √ | | |
23 | PSNTYPE | VARCHAR2 | 255 | | | | √ | | |
24 | PSNTYPENAME | VARCHAR2 | 255 | | | | √ | | |
25 | RESTBEGININ | VARCHAR2 | 1 | | | | √ | | |
26 | RESTBUCHANGTYPE | VARCHAR2 | 2 | | | | √ | | |
27 | RESTCALTYPE | VARCHAR2 | 1 | | | | √ | | |
28 | RESTCHECKSIGN | VARCHAR2 | 1 | | | | √ | | |
29 | RESTDECTIMES | VARCHAR2 | 50 | | | | √ | | |
30 | RESTENDIN | VARCHAR2 | 1 | | | | √ | | |
31 | RESTOVERTIMETYPE | VARCHAR2 | 2 | | | | √ | | |
32 | RESTTURNRATE | NUMBER | 38 | 0 | | | √ | | |
33 | ROUNDMODE | VARCHAR2 | 10 | | | | √ | | |
34 | RULENAME | VARCHAR2 | 100 | | | | √ | | |
35 | STAFFCARDSHOW | VARCHAR2 | 1 | | | | √ | | |
36 | TENANTID | VARCHAR2 | 36 | | | | √ | | |
37 | TIMETYPE | VARCHAR2 | 1 | | | | √ | | |
38 | TS | DATE | 7 | | | | √ | sysdate | |
39 | WORKBEGININ | VARCHAR2 | 1 | | | | √ | | |
40 | WORKBUCHANGTYPE | VARCHAR2 | 2 | | | | √ | | |
41 | WORKCALTYPE | VARCHAR2 | 1 | | | | √ | | |
42 | WORKCHECKSIGN | VARCHAR2 | 1 | | | | √ | | |
43 | WORKDECTIMES | VARCHAR2 | 50 | | | | √ | | |
44 | WORKENDIN | VARCHAR2 | 1 | | | | √ | | |
45 | WORKOVERTIMETYPE | VARCHAR2 | 2 | | | | √ | | |
46 | WORKTURNRATE | NUMBER | 38 | 0 | | | √ | | |
|