UFN_CORPORATION_GETEMPLOYEECOUNT_WITHDATE

Returns the number of employees for the given constituent based on the currently selected employee relationship types.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@ORGANIZATIONID	uniqueidentifier	IN
@ASOFDATE	datetime	IN

Definition

Copy



            CREATE function [dbo].[UFN_CORPORATION_GETEMPLOYEECOUNT_WITHDATE]
            (
                @ORGANIZATIONID uniqueidentifier,
                @ASOFDATE datetime = null
            )
            returns int
            as
            begin
                declare @EMPLOYEECOUNT as int;
                select @EMPLOYEECOUNT = count(ID) from dbo.UFN_CORPORATION_GETEMPLOYEES_WITHDATE(@ORGANIZATIONID, @ASOFDATE)

                return @EMPLOYEECOUNT;
            end