USP_DATALIST_EDUCATIONALHISTORYSTATUS

Displays all the educational history statuses within the system.
Definition



                CREATE procedure dbo.USP_DATALIST_EDUCATIONALHISTORYSTATUS
                as
                    set nocount on;

                    declare @MINSEQUENCE int = (select min(SEQUENCE) from dbo.EDUCATIONALHISTORYSTATUS);
                    declare @MAXSEQUENCE int = (select max(SEQUENCE) from dbo.EDUCATIONALHISTORYSTATUS);

                    select ID,
                           DESCRIPTION,
                           ABBREVIATION,
                           CONSTITUENCYIMPLIED,
                           (case when SEQUENCE = @MINSEQUENCE then 1 else 0 end) as ISMINSEQUENCE,
                           (case when SEQUENCE = @MAXSEQUENCE then 1 else 0 end) as ISMAXSEQUENCE
                    from dbo.EDUCATIONALHISTORYSTATUS
                    order by SEQUENCE asc;