CREATE Table dbo.WH_ComeInOut_Message
(
CM_CD Int identity(1,1) Primary key ,
CT_CD Int default(0),
ed_CD Int default(0),
et_CD Int Default(1),
UserID NVarchar(12) not null,
UserCode NVarchar(8) not null,
UserName NVarchar(20) not null,
Remark NVarchar(1000) null,
CheckedTime SmallDateTime Default(Getdate()),
bMessage bit default(0),
bMail bit default(0),
Regdate SmallDateTime Default(Getdate())
)
Select ed_CD, et_CD, UserID, UserCode, UserName
From Employee As E Inner Join Employee_Team As Et ON E.Group_No = Et.et_CD
Where UserID in ( Select WDT_UserID from WH_NotGeneler_Absence_v Where WDT_CT_CD in (Select CT_CD from CompanyTimer) )
Select CT_CD from CompanyTimer
/*
작성자 : 한영민
작성일 : 2004-03-04
설 명 : 별정근무자 NOT IN (일반 근무자전체 + 별정근무자중 출근한 사람)
*/
CREATE View dbo.WH_NotGeneler_Absence_v
AS
Select WDT_UserID, WDT_CT_CD From dbo.WH_WhoDateTime Where WDT_UserID Not In
(
--(일반근무자(전체제외)+별정근무자(출근한사람제외))
Select Distinct WWH_UserID From WH_WorkHistory
Where (WWH_CheckYear = Year(Getdate()) And WWH_CheckMonth = Month(Getdate()) And WWH_CheckDay = Day(Getdate())) And WWH_TS_CD = 1 And WWH_WC_CD <> 12
)
And Convert(DateTime, WDT_StartDate) <= dbo.fn_Get_DateTime(Year(Getdate()), Month(Getdate()), Day(Getdate()), 0, 0)
And Convert(DateTime, WDT_LastDate) >= dbo.fn_Get_DateTime(Year(Getdate()), Month(Getdate()), Day(Getdate()), 0, 0)
