表名:hrmresourcetemp
中文名称:LDAP人员同步缓存表
表类型:
返回目录说明:
序号 |
中文名称 |
英文名称 |
数据类型 |
长度 |
允许空值 |
主键 |
默认值 |
自增 |
说明 |
1 |
|
textfield13 |
varchar |
500 |
|
|
|
|
|
2 |
主键id |
id |
int |
|
N |
|
|
Y |
|
3 |
登录账号 |
loginid |
varchar |
60 |
|
|
|
|
|
4 |
密码 |
password |
varchar |
100 |
|
|
|
|
|
5 |
姓名 |
lastname |
varchar |
60 |
|
|
|
|
|
6 |
性别 |
sex |
char |
1 |
|
|
|
|
|
7 |
生日 |
birthday |
char |
10 |
|
|
|
|
|
8 |
国家 |
nationality |
int |
|
|
|
|
|
|
9 |
系统语言 |
systemlanguage |
int |
|
|
|
|
|
|
10 |
婚姻状况 |
maritalstatus |
char |
1 |
|
|
|
|
|
11 |
电话 |
telephone |
varchar |
60 |
|
|
|
|
|
12 |
手机 |
mobile |
varchar |
60 |
|
|
|
|
|
13 |
其他电话 |
mobilecall |
varchar |
60 |
|
|
|
|
|
14 |
电子邮件 |
email |
varchar |
60 |
|
|
|
|
|
15 |
工作地点 |
locationid |
int |
|
|
|
|
|
|
16 |
办公室 |
workroom |
varchar |
60 |
|
|
|
|
|
17 |
家庭住址 |
homeaddress |
varchar |
100 |
|
|
|
|
|
18 |
用户类别 |
resourcetype |
char |
1 |
|
|
|
|
|
19 |
合同开始日期 |
startdate |
char |
10 |
|
|
|
|
|
20 |
合同结束日期 |
enddate |
char |
10 |
|
|
|
|
|
21 |
岗位 |
jobtitle |
int |
|
|
|
|
|
|
22 |
职责描述 |
jobactivitydesc |
varchar |
200 |
|
|
|
|
|
23 |
工作级别 |
joblevel |
tinyint |
|
|
|
|
|
|
24 |
安全级别 |
seclevel |
tinyint |
|
|
|
|
|
|
25 |
所属部门 |
departmentid |
int |
|
|
|
|
|
|
26 |
所属分部1 |
subcompanyid1 |
int |
|
|
|
|
|
|
27 |
所属成本中心 |
costcenterid |
int |
|
|
|
|
|
|
28 |
经理 |
managerid |
int |
|
|
|
|
|
|
29 |
助理 |
assistantid |
int |
|
|
|
|
|
|
30 |
工资银行1 |
bankid1 |
int |
|
|
|
|
|
|
31 |
工资帐号1 |
accountid1 |
varchar |
100 |
|
|
|
|
|
32 |
照片id |
resourceimageid |
int |
|
|
|
|
|
|
33 |
创建人id |
createrid |
int |
|
|
|
|
|
|
34 |
创建日期 |
createdate |
char |
10 |
|
|
|
|
|
35 |
最后修改人id |
lastmodid |
int |
|
|
|
|
|
|
36 |
最后修改日期 |
lastmoddate |
char |
10 |
|
|
|
|
|
37 |
最后登陆日期 |
lastlogindate |
char |
10 |
|
|
|
|
|
38 |
自定义日期1 |
datefield1 |
varchar |
10 |
|
|
|
|
|
39 |
自定义日期2 |
datefield2 |
varchar |
10 |
|
|
|
|
|
40 |
自定义日期3 |
datefield3 |
varchar |
10 |
|
|
|
|
|
41 |
自定义日期4 |
datefield4 |
varchar |
10 |
|
|
|
|
|
42 |
自定义日期5 |
datefield5 |
varchar |
10 |
|
|
|
|
|
43 |
自定义数字1 |
numberfield1 |
float |
|
|
|
|
|
|
44 |
自定义数字2 |
numberfield2 |
float |
|
|
|
|
|
|
45 |
自定义数字3 |
numberfield3 |
float |
|
|
|
|
|
|
46 |
自定义数字4 |
numberfield4 |
float |
|
|
|
|
|
|
47 |
自定义数字5 |
numberfield5 |
float |
|
|
|
|
|
|
48 |
自定义文本1 |
textfield1 |
varchar |
100 |
|
|
|
|
|
49 |
自定义文本2 |
textfield2 |
varchar |
100 |
|
|
|
|
|
50 |
自定义文本3 |
textfield3 |
varchar |
100 |
|
|
|
|
|
51 |
自定义文本4 |
textfield4 |
varchar |
100 |
|
|
|
|
|
52 |
自定义文本5 |
textfield5 |
varchar |
100 |
|
|
|
|
|
53 |
自定义判断1 |
tinyintfield1 |
tinyint |
|
|
|
|
|
|
54 |
自定义判断2 |
tinyintfield2 |
tinyint |
|
|
|
|
|
|
55 |
自定义判断3 |
tinyintfield3 |
tinyint |
|
|
|
|
|
|
56 |
自定义判断4 |
tinyintfield4 |
tinyint |
|
|
|
|
|
|
57 |
自定义判断5 |
tinyintfield5 |
tinyint |
|
|
|
|
|
|
58 |
身份证号码 |
certificatenum |
varchar |
60 |
|
|
|
|
|
59 |
籍贯 |
nativeplace |
varchar |
100 |
|
|
|
|
|
60 |
学历 |
educationlevel |
int |
|
|
|
|
|
|
61 |
入团时间 |
bememberdate |
char |
10 |
|
|
|
|
|
62 |
入党时间 |
bepartydate |
char |
10 |
|
|
|
|
|
63 |
编号 |
workcode |
varchar |
60 |
|
|
|
|
|
64 |
户口 |
regresidentplace |
varchar |
200 |
|
|
|
|
|
65 |
健康状况 |
healthinfo |
char |
1 |
|
|
|
|
|
66 |
居住地 |
residentplace |
varchar |
200 |
|
|
|
|
|
67 |
政治面貌 |
policy |
varchar |
30 |
|
|
|
|
|
68 |
学位 |
degree |
varchar |
30 |
|
|
|
|
|
69 |
身高 |
height |
varchar |
10 |
|
|
|
|
|
70 |
用工性质 |
usekind |
int |
|
|
|
|
|
|
71 |
职称 |
jobcall |
int |
|
|
|
|
|
|
72 |
公积金帐号 |
accumfundaccount |
varchar |
30 |
|
|
|
|
|
73 |
出生地 |
birthplace |
varchar |
60 |
|
|
|
|
|
74 |
民族 |
folk |
varchar |
30 |
|
|
|
|
|
75 |
居住地电话 |
residentphone |
varchar |
60 |
|
|
|
|
|
76 |
居住地邮编 |
residentpostcode |
varchar |
60 |
|
|
|
|
|
77 |
分机 |
extphone |
varchar |
50 |
|
|
|
|
|
78 |
所有上级 |
managerstr |
varchar |
500 |
|
|
|
|
|
79 |
状态 |
status |
int |
|
|
|
|
|
|
80 |
传真 |
fax |
varchar |
60 |
|
|
|
|
|
81 |
是否为工会会员 |
islabouunion |
char |
1 |
|
|
|
|
|
82 |
体重 |
weight |
int |
|
|
|
|
|
|
83 |
暂住证号码 |
tempresidentnumber |
varchar |
60 |
|
|
|
|
|
84 |
试用期结束日期 |
probationenddate |
char |
10 |
|
|
|
|
|
85 |
|
countryid |
int |
|
|
|
1 |
|
|
86 |
|
passwdchgdate |
char |
10 |
|
|
|
|
|
87 |
|
needusb |
int |
|
|
|
|
|
|
88 |
Usb相关 |
serial |
varchar |
32 |
|
|
|
|
|
89 |
|
account |
varchar |
60 |
|
|
|
|
|
90 |
|
lloginid |
varchar |
60 |
|
|
|
|
|
91 |
是否使用动态密码 |
needdynapass |
int |
|
|
|
|
|
|
92 |
显示顺序 |
dsporder |
float |
|
|
|
|
|
|
93 |
动态密码状态 |
passwordstate |
int |
|
|
|
|
|
|
94 |
帐号类型 |
accounttype |
int |
|
|
|
|
|
|
95 |
所属主帐号 |
belongto |
int |
|
|
|
|
|
|
96 |
|
dactylogram |
varchar |
4000 |
|
|
|
|
|
97 |
|
assistantdactylogram |
varchar |
4000 |
|
|
|
|
|
98 |
密码锁定标记 |
passwordlock |
int |
|
|
|
|
|
|
99 |
连续错误次数 |
sumpasswordwrong |
int |
|
|
|
|
|
|
100 |
旧密码1 |
oldpassword1 |
varchar |
100 |
|
|
|
|
|
101 |
旧密码2 |
oldpassword2 |
varchar |
100 |
|
|
|
|
|
102 |
|
msgStyle |
varchar |
20 |
|
|
|
|
|
103 |
|
messagerurl |
varchar |
100 |
|
|
|
|
|
104 |
|
pinyinlastname |
varchar |
50 |
|
|
|
|
|
105 |
|
tokenkey |
varchar |
100 |
|
|
|
|
|
106 |
|
userUsbType |
varchar |
10 |
|
|
|
|
|
107 |
|
adsjgs |
varchar |
500 |
|
|
|
|
|
108 |
|
adgs |
varchar |
500 |
|
|
|
|
|
109 |
|
adbm |
varchar |
500 |
|
|
|
|
|
110 |
|
outkey |
varchar |
100 |
|
|
|
|
|
111 |
|
maildeldate |
varchar |
10 |
|
|
|
|
|
112 |
|
mobileshowtype |
int |
|
|
|
|
|
|
113 |
|
usbstate |
int |
|
|
|
|
|
|
114 |
|
totalSpace |
float |
|
|
|
100 |
|
|
115 |
|
occupySpace |
float |
|
|
|
0 |
|
|
116 |
|
ecology_pinyin_search |
varchar |
300 |
|
|
|
|
|
117 |
|
isADAccount |
char |
1 |
|
|
|
|
|