USP_SIMPLEDATALIST_ACADEMICCATALOGPROGRAM

Returns a list of academic catalog programs for a given educational institution.

Parameters

Parameter	Parameter Type	Mode	Description
@EDUCATIONALINSTITUTIONID	uniqueidentifier	IN	Educational institution

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGPROGRAM
                (
                    @EDUCATIONALINSTITUTIONID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        ID as VALUE,
                        PROGRAM as LABEL
                    from
                        dbo.ACADEMICCATALOGPROGRAM
                    where
                        EDUCATIONALINSTITUTIONID = isnull(@EDUCATIONALINSTITUTIONID,EDUCATIONALINSTITUTIONID);