lyfz_repos/铂金版源码/K考勤模块/考勤Sql/View_UserInfo.sql


/*
***** 对象:  View [dbo].[View_UserInfo] 用户信息视图   脚本日期: 04/27/2015 15:05:55 *****
字段：
UserID					员工ID
UserName				员工名
dimission				是否在职
loginnoID1				指纹ID1
loginnoID2				指纹ID2
[level]					级别(好像没用到)
*/

CREATE VIEW [View_UserInfo]
AS
SELECT     
User_Account as Account,
User_Password as PWD,
User_EmployeeID AS UserID,
 [User_Name] AS UserName,
  User_Status as dimission, 
  User_Sex AS Sex,
  User_FirstFingerprintID AS loginnoID1, 
  User_SecondaryFingerprintID AS loginnoID2,
   0 as [level]
FROM       dbo.tb_ErpUser