员工编号姓名所属部门性别工资何时加入公司工龄年假0001李海广告部男¥6,0002001/918230002苏杨行政部男¥6,5002004/115200003陈霞文秘部女¥2,0002002/1116210004武海市场部男¥5,0002003/416210005刘繁企划部女¥2,3002003/516210006袁锦辉研发部男¥6,0002004/115200007贺华研发部男¥6,0002004/115200008钟兵市场部男¥5,5001998/521260009丁芬行政部女¥6,0001997/722270010程静文秘部女¥2,0002002/517220011刘健产品开发部男¥6,0001997/222270012苏江行政部男¥5,5001995/424290013廖嘉文秘部女¥2,0002003/716210014刘佳人力资源部男¥6,0002001/118230015陈永研发部男¥6,0002003/216210016周繁财务部女¥6,0001992/127320017周波文秘部男¥2,0002002/117220018熊亮行政部男¥5,0001999/420250019吴娜文秘部女¥2,5001994/825300020丁琴文秘部女¥2,5002003/116210021宋沛人力资源部男¥5,0001994/425300022柳鑫行政部男¥5,0001994/425300023张郡研发部男¥6,0001998/721260024白雪市场部女¥4,3002003/516210025孙民市场部男¥5,0002003/416210026阮贸研发部男¥6,0001995/724290027罗重市场部男¥5,6001994/425300028王梓研发部男¥6,0001995/824290029王鸣市场部男¥4,0002002/71722员工年假表18151616161515212217222416181627172025162525211616242524172320212121202026272227292123213222253021303026212129302922请假日期员工编号姓名所属部门假别是否使用年假请假天数2004/5/80007贺华研发部事假否0.22004/5/80008钟兵市场部病假12004/5/80023张郡研发部婚假0.12004/5/80011刘健产品开发部事假否0.42004/5/90009丁芬行政部分娩假12004/5/90021宋沛人力资源部事假否0.62004/5/90027罗重市场部事假是0.62004/5/90004武海市场部事假否12004/5/100007贺华研发部年假12004/5/100011刘健产品开发部病假12004/5/100002苏杨行政部事假否0.42004/5/110011刘健产品开发部年假0.22004/5/110023张郡研发部病假0.12004/5/110009丁芬行政部事假否0.22004/5/110021宋沛人力资源部病假12004/5/110007贺华研发部事假否1月度出勤表应扣除工资¥40¥37¥0¥80¥0¥100¥0¥167¥0¥40¥87¥0¥4¥40¥33¥200月度出勤表贺华研发部事假否0.2钟兵市场部病假1张郡研发部婚假0.1刘健产品开发部事假否0.4丁芬行政部分娩假1宋沛人力资源部事假否0.6罗重市场部事假是0.6武海市场部事假否1贺华研发部年假1刘健产品开发部病假1苏杨行政部事假否0.4刘健产品开发部年假0.2张郡研发部病假0.1丁芬行政部事假否0.2宋沛人力资源部病假1贺华研发部事假否1¥40¥37¥0¥80¥0¥100¥0¥167¥0¥40¥87¥0¥4¥40¥33¥200