USP_DATALIST_BILLINGITEM_VARYBY_COSTHISTORY

Returns a list of cost history for vary by grade level/school billing item.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.USP_DATALIST_BILLINGITEM_VARYBY_COSTHISTORY(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select ID,
        CASE WHEN DATERANGETYPECODE=0 THEN 'All dates' WHEN DATERANGETYPECODE=1 THEN 'Specific dates' ELSE dbo.UFN_BILLINGITEM_GETACADEMICYEARBYDATES(STARTDATE, ENDDATE) END AS VALIDFOR,
        STARTDATE,
        ENDDATE,
        dbo.UFN_BILLINGITEM_VARYBY_COSTHISTORY_RECORDCOUNT(@CONTEXTID) AS RECORDCOUNT
    from dbo.BILLINGITEMDATES
    where BILLINGITEMID = @CONTEXTID
    order by STARTDATE DESC