V_QUERY_STUDENTCOURSEREQUEST
Provides support for querying student course requests.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| STUDENTID | uniqueidentifier | yes | STUDENTID |
| COURSEID | uniqueidentifier | yes | COURSEID |
| COURSEID_NAME | nvarchar(12) | yes | Course ID |
| COURSENAME | nvarchar(60) | yes | Course name |
| ACADEMICYEARNAME | nvarchar(100) | Academic year | |
| SESSIONNAME | nvarchar(100) | Session | |
| TERMNAME | nvarchar(100) | yes | Start term |
| SCHOOL_NAME | nvarchar(154) | yes | School |
| STUDENT_NAME | nvarchar(154) | yes | Student name |
| ADDEDBY_APPLICATION | nvarchar(200) | Added by application | |
| ADDEDBY_USERNAME | nvarchar(128) | Added by user name | |
| CHANGEDBY_APPLICATION | nvarchar(200) | Changed by application | |
| CHANGEDBY_USERNAME | nvarchar(128) | Changed by user name | |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 4/29/2010 7:29:41 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_STUDENTCOURSEREQUEST AS
select
STUDENTCOURSEREQUEST.ID,
STUDENTCOURSE.STUDENTID,
STUDENTCOURSE.COURSEID,
COURSE.COURSEID COURSEID_NAME,
COURSE.NAME COURSENAME,
ACADEMICYEARNAMECODE.DESCRIPTION AS ACADEMICYEARNAME,
SESSIONNAMECODE.DESCRIPTION AS SESSIONNAME,
TERMNAMECODE.DESCRIPTION AS TERMNAME,
CONS_SCH.NAME SCHOOL_NAME,
CONS_STD.NAME STUDENT_NAME,
isnull([ADDEDBY].APPLICATIONNAME, '') as [ADDEDBY_APPLICATION],
isnull([ADDEDBY].USERNAME, '') as [ADDEDBY_USERNAME],
isnull([CHANGEDBY].APPLICATIONNAME, '') as [CHANGEDBY_APPLICATION],
isnull([CHANGEDBY].USERNAME, '') as [CHANGEDBY_USERNAME],
STUDENTCOURSEREQUEST.DATEADDED,
STUDENTCOURSEREQUEST.DATECHANGED,
STUDENTCOURSEREQUEST.TSLONG
/*#EXTENSION*/
from
dbo.STUDENTCOURSEREQUEST
left join
dbo.STUDENTCOURSE on STUDENTCOURSEREQUEST.ID = STUDENTCOURSE.ID
left join
dbo.COURSE on STUDENTCOURSE.COURSEID = COURSE.ID
inner join
dbo.SESSION on dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, STUDENTCOURSEREQUEST.STARTDATE, STUDENTCOURSEREQUEST.ENDDATE) = SESSION.ID
inner join
dbo.SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
inner join
dbo.ACADEMICYEAR on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID
inner join
dbo.ACADEMICYEARNAMECODE on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID
inner join
dbo.CONSTITUENT CONS_SCH on COURSE.SCHOOLID = CONS_SCH.ID
inner join
dbo.CONSTITUENT CONS_STD on STUDENTCOURSE.STUDENTID = CONS_STD.ID
left join
dbo.TERM on STUDENTCOURSEREQUEST.CLASSSTARTDATE = TERM.STARTDATE
left join
dbo.TERMNAMECODE on TERM.TERMNAMECODEID = TERMNAMECODE.ID
left outer join
dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = STUDENTCOURSEREQUEST.ADDEDBYID
left outer join
dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = STUDENTCOURSEREQUEST.CHANGEDBYID