UFN_BILLINGGENERATETRANSACTIONSPROCESS_GETSCHOOLS

Returns the schools to generate transactions for, for a generate transactions process.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BILLINGGENERATETRANSACTIONSPROCESSID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_BILLINGGENERATETRANSACTIONSPROCESS_GETSCHOOLS
(
    @BILLINGGENERATETRANSACTIONSPROCESSID uniqueidentifier
)
returns table
as return
(
    select
        PROCESSSCHOOL.ID,
        PROCESSSCHOOL.SCHOOLID,
        CONSTITUENT.KEYNAME as NAME
    from
        dbo.BILLINGGENERATETRANSACTIONSPROCESSSCHOOL PROCESSSCHOOL
        inner join dbo.CONSTITUENT
            on PROCESSSCHOOL.SCHOOLID = CONSTITUENT.ID
    where
        PROCESSSCHOOL.BILLINGGENERATETRANSACTIONSPROCESSID = @BILLINGGENERATETRANSACTIONSPROCESSID
)