renshiguanli(ACCESS).zip_EHLIB 3.2P_EhLib_access_renshiguanli ac

培训记录 select Cultivate_EmployeeID as 职工编号,Cultivate_Speciality as 培训专业,Cultivate_Mode as 培训方式,Cultivate_StartDate as 开始日期,Cultivate_StopDate as 结束日期,Cultivate_Corp as 培训单位,Cultivate_Outlay as 培训经费,Cultivate_Result as 培训结果 From Cultivate 奖惩记录 select AP_EmployeeID as 职工编号, AP_Type as 奖惩类型,AP_FirstDept as 一级部门,AP_SecondDept as 二级部门,AP_StartDate as 奖惩日期, AP_StartExplain as 奖惩原因,AP_StopDate as 解除日期,AP_StopExplain as 解除原因, 家庭记录 select Family_EmployeeID as 职工编号, Family_Name as 成员姓名,Family_Birthday as 出生日期,Family_Work as 工作单位,Family_Role as 担任职务,Family_polity as 政治面貌,Family_Connection as 关系,Family_Tel as 电话 From Family 请假记录 select Leave_EmployeeID as 职工编号,Leave_Type as 请假类型,Leave_Explain as 请假原因,Leave_StartDate as 开始日期,Leave_StopDate as 结束日期 From Leave 调动记录 select MT_EmployeeID as 职工编号,MT_OleDept as 调动前部门 ,MT_NewDept as 调动后部门,MT_Explain as 调动理由,MT_Date as 调动日期,MT_OlePay as 调动前薪资,MT_NewPay as 调动后薪资 From MoveTo 工作单位记录 select WS_EmployeeID as 职工编号,WS_StartDate as 开始日期,WS_StopDate as 结束日期,WS_Corp as 工作单位,WS_Dept as 工作部门,WS_Role as 担任职务　From WorkStoy