HR同步功能說明

1、1、需要根據(jù)需要先寫好外部系統(tǒng)數(shù)據(jù)庫視圖，并在外部系統(tǒng)數(shù)據(jù)庫中創(chuàng)建好對應的視圖(1)分部視圖createview v_oa_com as select b. ID , b. Name, b. Code , a. ParentID , b. CreateTime , b. StatusID from ORG_co mpanya , org_unitb where a. UnitID =b. ID(2)部門視圖createview v_oa_deptment asselect b. ID , b. Name, b. Code , e. partmentid , a. CompanyID , b.

2、CreateTime , b. Stat usIDfrom org_departmenta , org_unitb ,( select c. idpartmentid , d. idid from org_uni tc , org_unitdwhere c. Code =substring ( d. code , 1, LEN( d. code )- CHARINDEX ( ., reverse ( d. code ) e where a . UnitID =b . ID and b. ID =e. ID(3)崗位視圖createview v_oa_jobtitle asselect ID ,

3、 Name, code , unitid , GETDATE() datatime from org_position(4)人員視圖createview v_oa_hrmresource asselect 10aqjb , casewhen e. otherunit !=NULL then a. code else end loginid , b. PositionID jobid , c. UnitIDdepid , d. Type_ status , a. EM_ID , a. Name, a. Sex , a. Birthday , a. C, a . IDCardID , a . Te

4、lphone , a . EMail , a. FItemID , a .ode , a. Mobile , a. NativePlace FParentID , a. DimissionTime,1 loaction , 7 yuyan from hm_employeesa leftouterjoinv_oa_hrmjobbon a. EM_ID =b. EM_IDleftouterjoinv_oa_jobtitlec on b . PositionID =c . IDleftouterjoin hm_em_workinfod on a. EM_ID =d. EM_ID leftouterj

5、oin hm_employeesaddinfoe on a . EM_ID =e. EM_ID2、在OA系統(tǒng)中配置外部系統(tǒng)的數(shù)據(jù)源 配置數(shù)據(jù)源。3、進彳T HR同步的配置工作HRR步fit MR 亦自免。向胸胞mciTE即盾至和c手工局田小血局肆局禁戒室班V4 日D2JJCSV好1mriEFraw力哥v- G卓小卻犯a conniitrti w#舊步曲.修蕾ma jTrrrKLT*注意：增量標識字段一定是時間字段。分部同步設(shè)置:竊E小苒MMEASIM岬0* F,.由情吩的*/麗小點詡蟻砒51 對rn*cpww矢嶙色gs上#臥場韭EE百K*mQidgMHifWi(y白洞p-iiettid| |削

6、Q*t度 udd部門同步設(shè)置:酬：i裳詞曲MttE】F f-LL-身工下位W或不吟&筠，占限F田S絲加，黑 KlI噲應上乘熱除0季岫MMXR六加Cl；dCl.StsQnsiGiQpiHifrirfld所需濾sip6f 討1即mrritb工行錄用glea白*e.h訃spt i_rcr&ak咤=1* t- l轉(zhuǎn)換規(guī)則:select case when ?currentvalue=1 then 0 when ?currentvalue=2 then 1 else 1 end statusid崗位同步:廿都田關(guān)室區(qū)日當門居小題智 寫煌3E而前iiFE衣同零gE 用也心尚生和沃星注可中生號巫裾HIW!M

7、貨主晚Id能愴儂人員同步:片鋼:E4異父/于 甲學屬g身忖信步般卬之需目臂.二百n吊花看二冷 吊營青Fmt面亍搐、M固!上由！加l幫京啟歌冏位1HI苧34-m_dmt|ridm-e岬Q鄴2Q白航聲K央虻咽1一變?yōu)椋?qhC4由VSstfftoui軍Mq號qQiMlMi,w同心曼息-noth tpl 2口1s-44、同步測試過程(1)如果同步之后需要再次測試同步需要先刪除數(shù)據(jù)庫表中數(shù)據(jù)，然后再修改同步時間點, 具體對應表如下：select * from HrmCompany-查詢公司select* from HrmSubCompany-查詢分部select* from HrmDepartment

8、 - 查詢音select * from HrmJobTitles- 查詢崗位select * from HrmResource-查詢?nèi)藛T 修改 hrm_syntsupda.t= hrmi synts set sn3=l 197Q01-01 : : 00 1 where id =4d=let= f roan HcmDe p axtafte nt一I箱果|_消息I山加NT業(yè):11 . :ilescstr2 2O1v-D704同聲分部 同少部門 同步國精 同:F人員where id =4b.CreateTime,update hrm_synts set synts =1970-01-01 00:00

9、:00如果是重新測試同步分部，則 ID=1,以此類推5、數(shù)據(jù)庫系統(tǒng)中創(chuàng)建視圖的語句為 創(chuàng)建分部：createview v_oa_com as SELECT b.ID, b.Name, b.Code, a.ParentID, b.CreateTime, b.StatusID FROM dbo.ORG_Company AS a INNER JOINdbo.ORG_Unit AS b ON a.UnitID = b.ID 創(chuàng)建部門： createview v_oa_deptment as SELECT b.ID, b.Name, b.Code, e.partmentid, a.CompanyID,

10、b.StatusID FROM dbo.ORG_Department AS a INNER JOINdbo.ORG_Unit AS b ON a.UnitID = b.ID INNER JOIN(SELECT c.ID AS partmentid, d.ID AS id FROM dbo.ORG_Unit AS c INNER JOIN dbo.ORG_Unit AS d ON c.Code=SUBSTRING(d.Code, 1, LEN(d.Code) - CHARINDEX(., REVERSE(d.Code) AS e ON b.ID = e.id創(chuàng)建職位：createview v_o

11、a_jobtitleasSELECT ID, Name, Code, UnitID, GETDATE() AS datatimeFROM dbo.ORG_Positioncreateview v_oa_hrmjob asSELECT ID, EM_ID, PositionlD, BeginDate FROM dbo.HM_EM_PositionHistory AS hob WHERE EXISTS (SELECT 1 AS Expr1FROM (SELECT EM_ID, MAX(BeginDate) AS BeginDate FROM dbo.HM_EM_PositionHistoryGRO

12、UP BY EM_ID) AS bzwb WHERE (EM_ID = hob.EM_ID) AND (BeginDate = hob.BeginDate)創(chuàng)建人員：createview v_oa_hrmresource asSELECT 10 AS aqjb, CASE WHEN e.otherunit != NULL THEN a.code ELSE END AS loginid, b.positionid AS jobid, c.unitid AS depid, d.Type_ AS status, a.EM_ID, a.Name,a.Sex, a.Birthday, a.Code, a.Mobile, a.NativePlace,a.IDCardID, a.Telphone, a.EMail, a.FItemID, a.FParentID, a.DimissionTime, 1 AS loaction, 7 AS yuyan FROM dbo.HM_Employees AS a LEFT OUTER JOINdbo.v_oa_hrmjob AS b ON a.