问题现象: | 年转后2011和2012年度中,人事管理-人员档案及基础档案-人员档案打开后均为空,经查数据表数据未缺失,打最新补丁测试问题仍存在。年转前数据备份已上传FTP(滨海快餐2.rar),烦请ZHANGKANGA@UFIDA.COM处理,多谢! 之前问题号:201201040212 |
问题原因: | |
解决方案: | 请在两个年度帐的库中分别执行如下语句: 执行前请做好数据备份 SET ANSI_NULLS ON; GO SET QUOTED_IDENTIFIER ON; GO ALTER view [dbo].[hr_v_HR31_show] as select Person.fCreditQuantity,Person.iCreDate,Person.cCreGrade, convert(char(10),Person.dPValidDate,121) dPValidDate, convert(char(10),Person.dPInValidDate,121) dPInValidDate, case HR_HI_PERSON.bPsnPerson when '1' then dbo.UDF_GetResourceMessageByID('U8.HR.HM.hr_HRVouchBus.00001') else dbo.UDF_GetResourceMessageByID('U8.HR.HM.hr_HRVouchBus.00002') end as bPsnPerson,hr_hi_person.vCardNo,hr_hi_Person.vAliaName, convert(char(10),hr_hi_Person.dJoinworkDate,121) dJoinworkDate, convert(char(10),hr_hi_Person.dEnterDate,121) dEnterDate, convert(char(10),hr_hi_Person.dRegularDate,121) dRegularDate,hr_hi_Person.vSSNo, convert(char,convert(money,hr_hi_person.hrts),2) as 'hrts',hr_hi_Person.cPsn_Num,hr_hi_Person.cPsnEmail,hr_hi_Person.cPsnFAddr,hr_hi_Person.cPsnFPhone,hr_hi_Person.cPsnInPhone,hr_hi_Person.cPsnMobilePhone,hr_hi_Person.cPsnOPhone,hr_hi_Person.cPsnOSeat,hr_hi_Person.cPsnPostAddr,hr_hi_Person.cPsnPostCode,hr_hi_Person.cPsnProperty,hr_hi_Person.cPsnQQCode,hr_hi_Person.cPsnURL,hr_hi_Person.cPsn_Name,hr_hi_Person.cDept_num, case HR_HI_PERSON.bProbation when '1' then dbo.UDF_GetResourceMessageByID('U8.HR.HM.hr_HRVouchBus.00001') else dbo.UDF_GetResourceMessageByID('U8.HR.HM.hr_HRVouchBus.00002') end as bProbation, convert(char(10),HR_HI_PERSON.dEnterUnitDate,121) dEnterUnitDate, convert(char(10),hr_hi_person.CardEffectiveBeginTime,121) CardEffectiveBeginTime, convert(char(10),hr_hi_person.CardEffectiveEndTime,121) CardEffectiveEndTime,hr_hi_person.PersonDepart,hr_hi_Person.iRecordID, convert(char(10),HR_HI_PERSON.dLeaveDate,121) dLeaveDate, convert(char(10),hr_hi_Person.dBirthDate,121) dBirthDate,hr_hi_Person.vIDNo,hr_hi_Person.cpsnAccount,Person.cDepCode, aa_bank1.cbankname AS cpsnBankCode,department2.cDepName AS cDepName,department3.cDepName AS cDept_Name, HR_CT0004.vdescription AS rPersonType, HR_CT0015.vdescription AS rSex, HR_CT0026.vdescription AS reducation, HR_CT0057.vdescription AS rNational, HR_CT0068.vdescription AS rCountry, HR_CT0079.vdescription AS rPerResidence, HR_CT00710.vdescription AS rNativePlace, HR_CT00811.vdescription AS rhealthStatus, HR_CT00912.vdescription AS rMarriStatus, HR_CT05913.vdescription AS rCheckInFlag, HR_CT15714.vDescription AS rFigure, HR_CT15815.vDescription AS rWorkStatus, HR_CT32216.vDescription AS CardState, HR_CT80317.vDescription AS EmploymentForm, hr_om_duty18.Vdutyname AS cDutycode, hr_om_job19.Vjobname AS cjobcode, hr_tm_DutyClass20.vName AS cdutyclass, hr_tm_PersonParameters21.vName AS rPersonParameters from hr_hi_Person left JOIN person ON hr_hi_Person.cPsn_Num = person.cpersoncode left join hr_hi_jobinfo on hr_hi_jobinfo.cpsn_num=hr_hi_person.cpsn_num and blastflag=1 and bpartjob=0 left join hr_hi_edu on hr_hi_person.cpsn_num=hr_hi_edu.cpsn_num and hr_hi_edu.blastflag=1 and hr_hi_edu.irecordid=(select isnull(max(hhe.iRecordID),0) from hr_hi_edu hhe where hhe.cpsn_num=hr_hi_person.cpsn_num and hhe.blastflag=1) Left join aa_bank as aa_bank1 on hr_hi_Person.cpsnBankCode=aa_bank1.cbankCode Left join department as department2 on Person.cdepcode=department2.CDepCode Left join department as department3 on hr_hi_Person.cdept_num=department3.CDepCode Left join HR_CT000 as HR_CT0004 on hr_hi_Person.rPersonType=HR_CT0004.ccodeid Left join HR_CT001 as HR_CT0015 on hr_hi_Person.rSex=HR_CT0015.ccodeid Left join HR_CT002 as HR_CT0026 on hr_hi_edu.reducation=HR_CT0026.ccodeid Left join HR_CT005 as HR_CT0057 on hr_hi_Person.rNational=HR_CT0057.ccodeid Left join HR_CT006 as HR_CT0068 on HR_HI_PERSON.rCountry=HR_CT0068.ccodeid Left join HR_CT007 as HR_CT0079 on hr_hi_Person.rPerResidence=HR_CT0079.ccodeid Left join HR_CT007 as HR_CT00710 on hr_hi_Person.rNativePlace=HR_CT00710.ccodeid Left join HR_CT008 as HR_CT00811 on hr_hi_Person.rhealthStatus=HR_CT00811.ccodeid Left join HR_CT009 as HR_CT00912 on hr_hi_Person.rMarriStatus=HR_CT00912.ccodeid Left join HR_CT059 as HR_CT05913 on hr_hi_Person.rCheckInFlag=HR_CT05913.ccodeid Left join HR_CT157 as HR_CT15714 on HR_HI_PERSON.rFigure=HR_CT15714.cCodeID Left join HR_CT158 as HR_CT15815 on HR_HI_PERSON.rWorkStatus=HR_CT15815.cCodeID Left join HR_CT322 as HR_CT32216 on HR_HI_PERSON.CardState=HR_CT32216.cCodeID Left join HR_CT803 as HR_CT80317 on HR_HI_PERSON.EmploymentForm=HR_CT80317.cCodeID Left join hr_om_duty as hr_om_duty18 on hr_hi_jobinfo.cDutycode=hr_om_duty18.Cdutycode Left join hr_om_job as hr_om_job19 on hr_hi_jobinfo.cjobcode=hr_om_job19.cJobcode Left join hr_tm_DutyClass as hr_tm_DutyClass20 on hr_hi_person.cdutyclass=hr_tm_DutyClass20.cCode Left join hr_tm_PersonParameters as hr_tm_PersonParameters21 on HR_HI_PERSON.rPersonParameters=hr_tm_PersonParameters21.cCode GO 如有问题,请及时与我沟通联系。 |
相关补丁: | |
版本: | 8.72sp1 |
模块: | 人事信息管理 |
产品: | 人力资源 |
问题名称: | 人员档案打开为空问题重提 |
最后更新: | 2012-01-13 23:56:06 |