extendtable.sql

企业人事管理系统主要功能有： ①人事档案管理：户口状况、政治面貌、生理状况、合同管理等； ②考勤加班出差管理； ③人事变动：新进员工登记、员工离职登记、人事变更记录； ④考核奖惩； ⑤员工培

values('1016','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1016','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1017','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1017','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1017','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1017','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1017','2006-6-5','正常','有','泄露机密罚款','无')
insert into ExtendTable
values('1017','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1017','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1017','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1017','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1017','2006-6-10','正常','有','无','物流技能培训')

insert into ExtendTable
values('1018','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1018','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1018','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1018','2006-6-4','正常','有','无','物流技能培训')
insert into ExtendTable
values('1018','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1018','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1018','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1018','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1018','2006-6-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1018','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1019','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1019','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1019','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1019','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1019','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1019','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1019','2006-6-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1019','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1019','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1019','2006-6-10','正常','有','无','物流技能培训')

insert into ExtendTable
values('1020','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1020','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1020','2006-6-3','正常','有','先进个人','无')
insert into ExtendTable
values('1020','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1020','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1020','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1020','2006-6-7','迟到','无','无','无')
insert into ExtendTable
values('1020','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1020','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1020','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1021','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1021','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1021','2006-6-3','正常','有','无','无')
insert into ExtendTable
values('1021','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1021','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1021','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1021','2006-6-7','迟到','无','无','无')
insert into ExtendTable
values('1021','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1021','2006-6-9','迟到','有','无','领导技能培训')
insert into ExtendTable
values('1021','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1022','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1022','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1022','2006-6-3','正常','有','无','无')
insert into ExtendTable
values('1022','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1022','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1022','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1022','2006-6-7','迟到','无','无','无')
insert into ExtendTable
values('1022','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1022','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1022','2006-6-10','正常','有','无','无')

insert into ExtendTable
values('1023','2006-6-1','迟到','无','无','无')
insert into ExtendTable
values('1023','2006-6-2','旷到','无','无','无')
insert into ExtendTable
values('1023','2006-6-3','正常','有','无','无')
insert into ExtendTable
values('1023','2006-6-4','正常','有','无','无')
insert into ExtendTable
values('1023','2006-6-5','正常','有','无','无')
insert into ExtendTable
values('1023','2006-6-6','正常','无','无','无')
insert into ExtendTable
values('1023','2006-6-7','迟到','无','无','无')
insert into ExtendTable
values('1023','2006-6-8','出差','无','无','无')
insert into ExtendTable
values('1023','2006-6-9','迟到','有','无','无')
insert into ExtendTable
values('1023','2006-6-10','正常','有','无','领导技能培训')


insert into ExtendTable
values('1001','2006-7-1','迟到','无','无','无')
insert into ExtendTable
values('1001','2006-7-2','旷到','无','无','无')
insert into ExtendTable
values('1001','2006-7-3','正常','有','先进个人','无')
insert into ExtendTable
values('1001','2006-7-4','正常','有','无','无')
insert into ExtendTable
values('1001','2006-7-5','正常','有','无','无')
insert into ExtendTable
values('1001','2006-7-6','正常','无','无','人事技能培训')
insert into ExtendTable
values('1001','2006-7-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1001','2006-7-8','出差','无','无','无')
insert into ExtendTable
values('1001','2006-7-9','迟到','有','无','无')
insert into ExtendTable
values('1001','2006-7-10','正常','有','无','无')

insert into ExtendTable
values('1002','2006-7-1','迟到','无','无','无')
insert into ExtendTable
values('1002','2006-7-2','旷到','无','无','无')
insert into ExtendTable
values('1002','2006-7-3','正常','有','先进个人','无')
insert into ExtendTable
values('1002','2006-7-4','正常','有','无','无')
insert into ExtendTable
values('1002','2006-7-5','正常','有','无','无')
insert into ExtendTable
values('1002','2006-7-6','正常','无','无','人事技能培训')
insert into ExtendTable
values('1002','2006-7-7','迟到','无','无','无')
insert into ExtendTable
values('1002','2006-7-8','出差','无','无','无')
insert into ExtendTable
values('1002','2006-7-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1002','2006-7-10','正常','有','无','无')

insert into ExtendTable
values('1003','2006-7-1','迟到','无','无','无')
insert into ExtendTable
values('1003','2006-7-2','旷到','无','无','无')
insert into ExtendTable
values('1003','2006-7-3','正常','有','先进个人','无')
insert into ExtendTable
values('1003','2006-7-4','正常','有','无','无')
insert into ExtendTable
values('1003','2006-7-5','正常','有','无','无')
insert into ExtendTable
values('1003','2006-7-6','迟到','无','无','无')
insert into ExtendTable
values('1003','2006-7-7','迟到','无','无','无')
insert into ExtendTable
values('1003','2006-7-8','正常','无','无','无')
insert into ExtendTable
values('1003','2006-7-9','迟到','有','无','无')
insert into ExtendTable
values('1003','2006-7-10','正常','有','无','人事技能培训')

insert into ExtendTable
values('1004','2006-7-1','迟到','无','无','无')
insert into ExtendTable
values('1004','2006-7-2','旷到','无','无','无')
insert into ExtendTable
values('1004','2006-7-3','正常','有','先进个人','无')
insert into ExtendTable
values('1004','2006-7-4','正常','有','无','无')
insert into ExtendTable
values('1004','2006-7-5','正常','有','无','人事技能培训')
insert into ExtendTable
values('1004','2006-7-6','正常','无','无','无')
insert into ExtendTable
values('1004','2006-7-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1004','2006-7-8','出差','无','无','无')
insert into ExtendTable
values('1004','2006-7-9','迟到','有','无','无')
insert into ExtendTable
values('1004','2006-7-10','正常','有','无','无')

insert into ExtendTable
values('1005','2006-7-1','迟到','无','无','无')
insert into ExtendTable
values('1005','2006-7-2','旷到','无','无','无')
insert into ExtendTable
values('1005','2006-7-3','正常','有','先进个人','无')
insert into ExtendTable
values('1005','2006-7-4','正常','有','无','无')
insert into ExtendTable
values('1005','2006-7-5','正常','有','无','无')
insert into ExtendTable
values('1005','2006-7-6','正常','无','无','无')
insert into ExtendTable
values('1005','2006-7-7','正常','无','无','无')
insert into ExtendTable
values('1005','2006-7-8','出差','无','无','无')
insert into ExtendTable
values('1005','2006-7-9','迟到','有','无','无')
insert into ExtendTable
values('1005','2006-7-10','正常','有','无','人事技能培训')

insert into ExtendTable
values('1006','2006-7-1','迟到','无','无','无')
insert into ExtendTable
values('1006','2006-7-2','旷到','无','无','无')
insert into ExtendTable
values('1006','2006-7-3','正常','有','无','无')
insert into ExtendTable
values('1006','2006-7-4','正常','有','无','无')
insert into ExtendTable
values('1006','2006-7-5','正常','有','先进个人','无')
insert into ExtendTable
values('1006','2006-7-6','正常','无','无','无')
insert into ExtendTable
values('1006','2006-7-7','迟到','无','无','无')
insert into ExtendTable
values('1006','2006-7-8','出差','无','无','无')
insert into ExtendTable
values('1006','2006-7-9','迟到','有','泄露机密罚款','无')
insert into ExtendTable
values('1006','2006-7-10','正常','有','无','维护技能培训')

insert into ExtendTable
values('1007','2006-7-1','迟到','无','无','无')
insert into ExtendTable
values('1007','2006-7-2','旷到','无','无','无')
insert into ExtendTable
values('1007','2006-7-3','正常','有','先进个人','无')
insert into ExtendTable
values('1007','2006-7-4','正常','有','无','无')
insert into ExtendTable
values('1007','2006-7-5','正常','有','无','无')
insert into ExtendTable
values('1007','2006-7-6','正常','无','无','无')
insert into ExtendTable
values('1007','2006-7-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1007','2006-7-8','出差','无','无','无')
insert into ExtendTable
values('1007','2006-7-9','迟到','有','无','维护技能培训')
insert into ExtendTable
values('1007','2006-7-10','正常','有','无','无')

insert into ExtendTable
values('1008','2006-7-1','迟到','无','无','无')
insert into ExtendTable
values('1008','2006-7-2','旷到','无','无','无')
insert into ExtendTable
values('1008','2006-7-3','正常','有','先进个人','无')
insert into ExtendTable
values('1008','2006-7-4','正常','有','无','无')
insert into ExtendTable
values('1008','2006-7-5','正常','有','无','无')
insert into ExtendTable
values('1008','2006-7-6','正常','无','无','无')
insert into ExtendTable
values('1008','2006-7-7','迟到','无','泄露机密罚款','无')
insert into ExtendTable
values('1008','2006-7-8','出差','无','无','维护技能培训')
insert into ExtendTable
values('1008','2006-7-9','迟到','有','无','无')
insert into ExtendTable
values('1008','2006-7-10','正常','有','无','无')

insert into ExtendTable
values('1009','2006-7-1','迟到','无','无','无')
insert into ExtendTable
values('1009','2006-7-2','旷到','无','无','无')
insert into ExtendTable
values('1009','2006-7-3','正常','有','先进个人','无')
insert into ExtendTable
values('1009','2006-7-4','正常','有','无','无')
insert into ExtendTable
values('1009','2006-7-5','正常','有','无','无')
insert into ExtendTable
values('1009','2006-7-6','正常','无','无','无')