USP_SIMPLEDATALIST_APPUSERSESSION_DEPARTMENT
Simple list of departments filtered by the academic scheduling session.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_APPUSERSESSION_DEPARTMENT
(
@CURRENTAPPUSERID uniqueidentifier
)
as
set nocount on;
select
ACADEMICCATALOGDEPARTMENT.ID as VALUE,
ACADEMICCATALOGDEPARTMENT.USERID as LABEL
from dbo.ACADEMICCATALOGDEPARTMENT
inner join dbo.ACADEMICYEAR on ACADEMICCATALOGDEPARTMENT.SCHOOLID = ACADEMICYEAR.SCHOOLID
inner join dbo.SESSION on ACADEMICYEAR.ID = SESSION.ACADEMICYEARID
inner join dbo.APPUSERSESSION on SESSION.ID = APPUSERSESSION.SESSIONID
where APPUSERSESSION.ID = @CURRENTAPPUSERID
order by NAME