USP_DATAFORMTEMPLATE_ADD_BILLINGGENERATETRANSACTIONSCHARGEPROCESS_PRELOAD

The load procedure used by the edit dataform template "Billing Generate Transactions Charge Process Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	INOUT
@SCHOOLS	xml	INOUT	Generate charges for

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BILLINGGENERATETRANSACTIONSCHARGEPROCESS_PRELOAD
(
    @RECORDTYPEID uniqueidentifier = null output,
    @SCHOOLS xml = null output
)
as
    set nocount on;

    select @RECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'STUDENT'

    set @SCHOOLS = (
        select newID() as ID,
            CONSTITUENT.KEYNAME as NAME,
            SCHOOL.ID as SCHOOLID
        from dbo.SCHOOL
            inner join dbo.CONSTITUENT
                on SCHOOL.ID = CONSTITUENT.ID
        order by NAME
        for xml raw('ITEM'),type,elements,root('SCHOOLS'),BINARY BASE64
    )

    return 0;