V_COURSERESTRICTION
A SQL view of course restriction records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ID | |
| COURSEID | uniqueidentifier | COURSEID | |
| STARTDATE | datetime | STARTDATE | |
| ENDDATE | datetime | ENDDATE | |
| LENGTHINTERMS | int | LENGTHINTERMS | |
| PATTERNID | uniqueidentifier | yes | PATTERNID |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 3:30:39 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_COURSERESTRICTION AS
select
ID,
COURSEID,
STARTDATE,
ENDDATE,
LENGTHINTERMS,
PATTERNID
from
dbo.COURSERESTRICTION