USP_SIMPLEDATALIST_COURSEGRADINGMARKINGCOLUMNS
Returns a simple list of marking columns for an academic year and session.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COURSEID | uniqueidentifier | IN | |
| @SESSIONSTARTDATE | date | IN | |
| @SESSIONENDDATE | date | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_COURSEGRADINGMARKINGCOLUMNS
(
@COURSEID uniqueidentifier,
@SESSIONSTARTDATE date,
@SESSIONENDDATE date
)
as
select
MARKINGCOLUMNID as VALUE,
DISPLAYNAME as LABEL
from dbo.UFN_COURSEGRADING_GETMARKINGCOLUMNS(null, @COURSEID, @SESSIONSTARTDATE, @SESSIONENDDATE)
order by SEQUENCE