alter view [dbo].[vw_SalaryByAccount]          
as          
select [month] 工资月,case when staffID='002' then '药物研究院' else  division end  事业部,case when staffID='002' then '药物研究院' else  staffDept end 部门,
staffID 工号,staffName 姓名,isnull(S0001,0)基本工资,isnull(S0002,0)岗位工资,isnull(S0007,0)绩效工资,isnull(S0024,0)考核工资,isnull(S0087,0)保密工资,isnull(S0088,0)效益工资,
isnull(S0059,0)伙食补贴,isnull(S0025,0)+isnull(S0045,0)零点加班,isnull(S0061,0)加班工资,isnull(S0026,0)其他工资            
,isnull(S0010,0)缺勤工资,isnull(S0055,0)监事津贴,isnull(S0021,0)应发工资,isnull(S0012,0)医疗保险,isnull(S0013,0)养老保险,isnull(S0014,0)失业保险,isnull(S0066,0)工伤保险          
,isnull(S0028,0)住房公积金,isnull(S0015,0)伙食费,isnull(S0016,0)水电维修费,isnull(S0018,0)代扣税金,isnull(S0019,0)挂账工资,isnull(S0020,0)扣费总额        
,isnull(S0011,0)实发工资 
from officialSalary