USP_CUSTOMFORMDASHBOARD_GETCONFIGURATION

CREATE procedure dbo.USP_CUSTOMFORMDASHBOARD_GETCONFIGURATION
(
    @REENROLLMENT_INVITEDBACK_ISINCLUDED bit = 0 output,
    @REENROLLMENT_CONTRACTWITHHELD_ISINCLUDED bit = 0 output,
    @REENROLLMENT_STILLWAITING_ISINCLUDED bit = 0 output,
    @REENROLLMENT_COMINGBACK_ISINCLUDED bit = 0 output,
    @REENROLLMENT_NOTRETURNING_ISINCLUDED bit = 0 output,
    @REENROLLMENT_PERCENTAGENCOMINGBACK_ISINCLUDED bit = 0 output,

    @REENROLLMENT_CONTRACTWITHHELD_CONTRACTSTATUS int = -1 output,
    @REENROLLMENT_STILLWAITING_CONTRACTSTATUS int = -1 output,
    @REENROLLMENT_COMINGBACK_CONTRACTSTATUS int = -1 output,
    @REENROLLMENT_NOTRETURNING_CONTRACTSTATUS int = -1 output,

    @ADMISSIONS_FORMSSTARTED_ISINCLUDED bit = 0 output,
    @ADMISSIONS_FORMSCOMPLETED_ISINCLUDED bit = 0 output,
    @ADMISSIONS_TOTALAPPLIED_ISINCLUDED bit = 0 output,
    @ADMISSIONS_ACCEPTED_ISINCLUDED bit = 0 output,
    @ADMISSIONS_ACCEPTEDSTILLWAITING_ISINCLUDED bit = 0 output,
    @ADMISSIONS_ACCEPTEDCOMING_ISINCLUDED bit = 0 output,
    @ADMISSIONS_ACCEPTEDNOTCOMING_ISINCLUDED bit = 0 output,
    @ADMISSIONS_WAITPOOLED_ISINCLUDED bit = 0 output,
    @ADMISSIONS_WAITPOOLACCEPTED_ISINCLUDED bit = 0 output,
    @ADMISSIONS_WAITPOOLDENIED_ISINCLUDED bit = 0 output,
    @ADMISSIONS_TOTALCOMING_ISINCLUDED bit = 0 output,
    @ADMISSIONS_PERCENTAGEENROLLING_ISINCLUDED bit = 0 output,

    @ADMISSIONS_ACCEPTED_STATUS int = -1 output,
    @ADMISSIONS_ACCEPTEDSTILLWAITING_STATUS int = -1 output,
    @ADMISSIONS_ACCEPTEDCOMING_STATUS int = -1 output,
    @ADMISSIONS_ACCEPTEDNOTCOMING_STATUS int = -1 output,
    @ADMISSIONS_WAITPOOLED_STATUS int = -1 output,
    @ADMISSIONS_WAITPOOLACCEPTED_STATUS int = -1 output,
    @ADMISSIONS_WAITPOOLDENIED_STATUS int = -1 output,
    @ADMISSIONS_TOTALCOMING_STATUS int = -1 output,

    @TOTALS_TOTALDEFINITELYCOMING_ISINCLUDED bit = 0 output,
    @TOTALS_MAYBES_ISINCLUDED bit = 0 output,
    @TOTALS_TOTALEXPECTED_ISINCLUDED bit = 0 output,
    @TOTALS_SEATSREMAINING_ISINCLUDED bit = 0 output,

    @FINANCIALAID_FINANCIALAIDDESIRED_ISINCLUDED bit = 0 output,
    @FINANCIALAID_FINANCIALAIDGRANTED_ISINCLUDED bit = 0 output,

    @GRADEYEARMODECODE int = 0 output,
    @GRADELEVELS xml = null output
)
as
begin
    set nocount on;

    select top(1)
        @REENROLLMENT_INVITEDBACK_ISINCLUDED = REENROLLMENT_INVITEDBACK_ISINCLUDED,
        @REENROLLMENT_CONTRACTWITHHELD_ISINCLUDED = REENROLLMENT_CONTRACTWITHHELD_ISINCLUDED,
        @REENROLLMENT_STILLWAITING_ISINCLUDED = REENROLLMENT_STILLWAITING_ISINCLUDED,
        @REENROLLMENT_COMINGBACK_ISINCLUDED = REENROLLMENT_COMINGBACK_ISINCLUDED,
        @REENROLLMENT_NOTRETURNING_ISINCLUDED = REENROLLMENT_NOTRETURNING_ISINCLUDED,
        @REENROLLMENT_PERCENTAGENCOMINGBACK_ISINCLUDED = REENROLLMENT_PERCENTAGENCOMINGBACK_ISINCLUDED,

        @REENROLLMENT_CONTRACTWITHHELD_CONTRACTSTATUS = REENROLLMENT_CONTRACTWITHHELD_CONTRACTSTATUS,
        @REENROLLMENT_STILLWAITING_CONTRACTSTATUS = REENROLLMENT_STILLWAITING_CONTRACTSTATUS,
        @REENROLLMENT_COMINGBACK_CONTRACTSTATUS = REENROLLMENT_COMINGBACK_CONTRACTSTATUS,
        @REENROLLMENT_NOTRETURNING_CONTRACTSTATUS = REENROLLMENT_NOTRETURNING_CONTRACTSTATUS,

        @ADMISSIONS_FORMSSTARTED_ISINCLUDED = ADMISSIONS_FORMSSTARTED_ISINCLUDED,
        @ADMISSIONS_FORMSCOMPLETED_ISINCLUDED = ADMISSIONS_FORMSCOMPLETED_ISINCLUDED,
        @ADMISSIONS_TOTALAPPLIED_ISINCLUDED = ADMISSIONS_TOTALAPPLIED_ISINCLUDED,
        @ADMISSIONS_ACCEPTED_ISINCLUDED = ADMISSIONS_ACCEPTED_ISINCLUDED,
        @ADMISSIONS_ACCEPTEDSTILLWAITING_ISINCLUDED = ADMISSIONS_ACCEPTEDSTILLWAITING_ISINCLUDED,
        @ADMISSIONS_ACCEPTEDCOMING_ISINCLUDED = ADMISSIONS_ACCEPTEDCOMING_ISINCLUDED,
        @ADMISSIONS_ACCEPTEDNOTCOMING_ISINCLUDED = ADMISSIONS_ACCEPTEDNOTCOMING_ISINCLUDED,
        @ADMISSIONS_WAITPOOLED_ISINCLUDED = ADMISSIONS_WAITPOOLED_ISINCLUDED,
        @ADMISSIONS_WAITPOOLACCEPTED_ISINCLUDED = ADMISSIONS_WAITPOOLACCEPTED_ISINCLUDED,
        @ADMISSIONS_WAITPOOLDENIED_ISINCLUDED = ADMISSIONS_WAITPOOLDENIED_ISINCLUDED,
        @ADMISSIONS_TOTALCOMING_ISINCLUDED = ADMISSIONS_TOTALCOMING_ISINCLUDED,
        @ADMISSIONS_PERCENTAGEENROLLING_ISINCLUDED = ADMISSIONS_PERCENTAGEENROLLING_ISINCLUDED,

        @ADMISSIONS_ACCEPTED_STATUS = ADMISSIONS_ACCEPTED_STATUS,
        @ADMISSIONS_ACCEPTEDSTILLWAITING_STATUS = ADMISSIONS_ACCEPTEDSTILLWAITING_STATUS,
        @ADMISSIONS_ACCEPTEDCOMING_STATUS = ADMISSIONS_ACCEPTEDCOMING_STATUS,
        @ADMISSIONS_ACCEPTEDNOTCOMING_STATUS = ADMISSIONS_ACCEPTEDNOTCOMING_STATUS,
        @ADMISSIONS_WAITPOOLED_STATUS = ADMISSIONS_WAITPOOLED_STATUS,
        @ADMISSIONS_WAITPOOLACCEPTED_STATUS = ADMISSIONS_WAITPOOLACCEPTED_STATUS,
        @ADMISSIONS_WAITPOOLDENIED_STATUS = ADMISSIONS_WAITPOOLDENIED_STATUS,
        @ADMISSIONS_TOTALCOMING_STATUS = ADMISSIONS_TOTALCOMING_STATUS,

        @TOTALS_TOTALDEFINITELYCOMING_ISINCLUDED = TOTALS_TOTALDEFINITELYCOMING_ISINCLUDED,
        @TOTALS_MAYBES_ISINCLUDED = TOTALS_MAYBES_ISINCLUDED,
        @TOTALS_TOTALEXPECTED_ISINCLUDED = TOTALS_TOTALEXPECTED_ISINCLUDED,
        @TOTALS_SEATSREMAINING_ISINCLUDED = TOTALS_SEATSREMAINING_ISINCLUDED,

        @FINANCIALAID_FINANCIALAIDDESIRED_ISINCLUDED = FINANCIALAID_FINANCIALAIDDESIRED_ISINCLUDED,
        @FINANCIALAID_FINANCIALAIDGRANTED_ISINCLUDED = FINANCIALAID_FINANCIALAIDGRANTED_ISINCLUDED,

        @GRADEYEARMODECODE = GRADEYEARMODECODE,
        @GRADELEVELS = dbo.UFN_CUSTOMFORMDASHBOARD_GETGRADELEVELS_TOITEMLISTXML()
    from
        dbo.CUSTOMFORMDASHBOARDCONFIGURATION
end