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