USP_SIMPLEDATALIST_EDUCATIONALHISTORYSTATUS_STUDENTSTATUSDESCRIPTION

Educational history status student statuses description list

Definition

Copy


            create procedure dbo.USP_SIMPLEDATALIST_EDUCATIONALHISTORYSTATUS_STUDENTSTATUSDESCRIPTION as
                select 
                    dbo.EDUCATIONALHISTORYSTATUS.ID as VALUE
                    dbo.EDUCATIONALHISTORYSTATUS.DESCRIPTION as LABEL
                from dbo.EDUCATIONALHISTORYSTATUS
                where dbo.EDUCATIONALHISTORYSTATUS.CONSTITUENCYIMPLIEDCODE = 0
                order by dbo.EDUCATIONALHISTORYSTATUS.SEQUENCE ASC