UFN_EDUCATIONALHISTORY_GETALUMNUSSTATUSTEXT
This function returns the alumnus status text for an educational history.
Return
| Return Type |
|---|
| nvarchar(14) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EDUCATIONALHISTORYID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_EDUCATIONALHISTORY_GETALUMNUSSTATUSTEXT(@EDUCATIONALHISTORYID uniqueidentifier)
returns nvarchar(14)
with execute as caller
as begin
return case (
select
EDUCATION.CONSTITUENCYSTATUSCODE
from
dbo.EDUCATIONALHISTORY as EDUCATION
where
EDUCATION.ID = @EDUCATIONALHISTORYID
)
when 1 then dbo.UFN_CONSTITUENCY_GETDESCRIPTION('4DB8F4FC-BC43-421D-B592-69BEF109B5FC') --Student
when 3 then dbo.UFN_CONSTITUENCY_GETDESCRIPTION('46EC3424-BA54-4431-A7DC-C6CEBB3B4592') --Alumnus
else null end;
end