V_QUERY_COURSE_STUDENTSKILL
Provides support for querying on Course skill information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| COURSEID | uniqueidentifier | COURSEID | |
| SKILLNAME | nvarchar(400) | Skill name | |
| CATEGORY | nvarchar(100) | yes | Category |
| RATINGSTABLE | nvarchar(60) | Ratings table | |
| STARTDATE | datetime | Starting in Academic Year | |
| ENDDATE | datetime | yes | Ending after Academic Year |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | 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: 8/2/2010 7:17:29 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_COURSE_STUDENTSKILL AS
select
STUDENTSKILLCOURSE.ID,
STUDENTSKILLCOURSE.COURSEID,
STUDENTSKILL.NAME as SKILLNAME,
dbo.UFN_STUDENTSKILLCATEGORYCODE_GETDESCRIPTION(STUDENTSKILL.STUDENTSKILLCATEGORYCODEID) as CATEGORY,
STUDENTSKILLRATINGGROUP.NAME as RATINGSTABLE,
STUDENTSKILLCOURSE.STARTDATE,
STUDENTSKILLCOURSE.ENDDATE,
ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
STUDENTSKILLCOURSE.DATEADDED,
STUDENTSKILLCOURSE.DATECHANGED,
STUDENTSKILLCOURSE.TSLONG
from dbo.STUDENTSKILLCOURSE
inner join dbo.STUDENTSKILL on STUDENTSKILLCOURSE.STUDENTSKILLID = STUDENTSKILL.ID
inner join dbo.STUDENTSKILLRATINGGROUP on STUDENTSKILL.STUDENTSKILLRATINGGROUPID = STUDENTSKILLRATINGGROUP.ID
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = STUDENTSKILLCOURSE.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = STUDENTSKILLCOURSE.CHANGEDBYID