表名:hrmperformanceplanmodul
中文名称:人力资源计划工作模板表
表类型:
返回目录说明:
序号 |
中文名称 |
英文名称 |
数据类型 |
长度 |
允许空值 |
主键 |
默认值 |
自增 |
说明 |
1 |
ID |
id |
int |
|
N |
Y |
|
|
|
2 |
分组id |
groupId |
int |
|
|
|
|
|
|
3 |
类型 |
type_n |
char |
1 |
|
|
|
|
目标计划:6 工作安排:0 |
4 |
名称 |
name |
varchar |
1000 |
|
|
|
|
|
5 |
对象id |
objId |
int |
|
|
|
|
|
|
6 |
人员id |
resourceid |
varchar |
1000 |
|
|
|
|
|
7 |
|
oppositeGoal |
int |
|
|
|
|
|
|
8 |
开始时间 |
begindate |
char |
10 |
|
|
|
|
|
9 |
计划属性 |
planProperty |
int |
|
|
|
|
|
|
10 |
负责人 |
principal |
varchar |
4000 |
|
|
|
|
|
11 |
|
cowork |
varchar |
1000 |
|
|
|
|
|
12 |
|
upPrincipal |
varchar |
1000 |
|
|
|
|
|
13 |
|
downPrincipal |
varchar |
1000 |
|
|
|
|
|
14 |
|
teamRequest |
text |
|
|
|
|
|
|
15 |
开始时间 |
begintime |
char |
8 |
|
|
|
|
|
16 |
结束日期 |
enddate |
char |
10 |
|
|
|
|
|
17 |
结束时间 |
endtime |
char |
8 |
|
|
|
|
|
18 |
|
rbeginDate |
char |
10 |
|
|
|
|
|
19 |
|
rendDate |
char |
10 |
|
|
|
|
|
20 |
|
rbeginTime |
char |
8 |
|
|
|
|
|
21 |
|
rendTime |
char |
8 |
|
|
|
|
|
22 |
定期模式 |
cycle |
char |
1 |
|
|
|
|
|
23 |
计划所属类型 |
planType |
char |
1 |
|
|
|
|
|
24 |
上级名称 |
percent_n |
int |
|
|
|
|
|
|
25 |
颜色 |
color |
char |
6 |
|
|
|
|
|
26 |
描述 |
description |
text |
|
|
|
|
|
|
27 |
|
requestIdn |
int |
|
|
|
|
|
|
28 |
|
requestid |
varchar |
1000 |
|
|
|
|
|
29 |
相关项目 |
projectid |
varchar |
1000 |
|
|
|
|
|
30 |
相关客户 |
crmid |
varchar |
1000 |
|
|
|
|
|
31 |
相关文档 |
docid |
varchar |
1000 |
|
|
|
|
|
32 |
相关会议 |
meetingid |
varchar |
1000 |
|
|
|
|
|
33 |
状态 |
status |
char |
1 |
|
|
|
|
|
34 |
是否提醒 |
isremind |
int |
|
|
|
|
|
|
35 |
提醒时间 |
waketime |
int |
|
|
|
|
|
|
36 |
创建人id |
createrid |
int |
|
|
|
|
|
|
37 |
创建日期 |
createdate |
char |
10 |
|
|
|
|
|
38 |
创建时间 |
createtime |
char |
8 |
|
|
|
|
|
39 |
|
deleted |
char |
1 |
|
|
|
|
|
40 |
任务id |
taskid |
int |
|
|
|
|
|
|
41 |
所属等级 |
urgentLevel |
char |
1 |
|
|
|
|
|
42 |
|
agentId |
int |
|
|
|
|
|
|
43 |
部门id |
deptId |
int |
|
|
|
|
|
|
44 |
分部id |
subcompanyId |
int |
|
|
|
|
|
|
45 |
创建类型 |
createrType |
char |
1 |
|
|
|
|
|
46 |
是否已经提醒 |
finishRemind |
int |
|
|
|
|
|
|
47 |
|
relatedprj |
varchar |
1000 |
|
|
|
|
|
48 |
|
relatedcus |
varchar |
1000 |
|
|
|
|
|
49 |
|
relatedwf |
varchar |
1000 |
|
|
|
|
|
50 |
|
relateddoc |
varchar |
1000 |
|
|
|
|
|
51 |
|
allShare |
char |
1 |
|
|
|
|
|
52 |
计划日期 |
planDate |
varchar |
1000 |
|
|
|
|
|
53 |
定期模式 |
timeModul |
char |
1 |
|
|
|
|
0,1,2 周月年 |
54 |
|
frequency |
int |
|
|
|
|
|
|
55 |
|
frequencyy |
int |
|
|
|
|
|
|
56 |
工作计划类型id |
workPlanTypeID |
int |
|
|
|
|
|
|
57 |
创建时间 |
createType |
char |
1 |
|
|
|
|
|
58 |
工作计划创建时间 |
workPlanCreateTime |
char |
8 |
|
|
|
|
|
59 |
持续方式 |
persistentType |
char |
1 |
|
|
|
|
|
60 |
持续时间 |
persistentTimes |
varchar |
1000 |
|
|
|
|
|
61 |
有效期开始时间 |
availableBeginDate |
char |
10 |
|
|
|
|
|
62 |
有效期截止时间 |
availableEndDate |
char |
10 |
|
|
|
|
|
63 |
是否开始前提醒 |
remindBeforeStart |
char |
1 |
|
|
|
|
|
64 |
是否结束前提醒 |
remindBeforeEnd |
char |
1 |
|
|
|
|
|
65 |
提醒方式 |
remindType |
char |
1 |
|
|
|
|
|
66 |
开始前提醒时间 |
remindTimesBeforeStart |
int |
|
|
|
|
|
|
67 |
结束前提醒时间 |
remindTimesBeforeEnd |
int |
|
|
|
|
|
|
68 |
是否立即触发 |
immediatetouch |
int |
|
|
|
0 |
|
1为触发 |