CREATE VIEW [dbo].[CommissionableSalespeople]
    AS
select
    SysUserLaborTypeMap.SysUserLaborTypeMapID as SysUserLaborTypeMapID,
    dbo.FormatLastNameFirstName( SysUser.LASTNAME, SysUser.FIRSTNAME ) as FullName
from Sysuser
inner join LaborType as SalesLaborType on SalesLaborType.LaborType = 'Sales'
inner join SysUserLaborTypeMap on
    SysUserLaborTypeMap.SysUserFID = Sysuser.SysUserID and
    SysUserLaborTypeMap.LaborTypeFID = SalesLaborType.PriKey
inner join Status on Status.PriKey = Sysuser.Status
where
    Status.Status != 'INACTIVE' and
    SysUserLaborTypeMap.VendorID is not null
GO
GRANT SELECT ON  [dbo].[CommissionableSalespeople] TO [MssExec]
GRANT INSERT ON  [dbo].[CommissionableSalespeople] TO [MssExec]
GRANT DELETE ON  [dbo].[CommissionableSalespeople] TO [MssExec]
GRANT UPDATE ON  [dbo].[CommissionableSalespeople] TO [MssExec]
GO