V_SCHOLARSHIPTERM

Fields

Field Field Type Null Description
ID uniqueidentifier
ACADEMICYEARNAMECODEID uniqueidentifier
NAME nvarchar(100)
STARTDATE date
ENDDATE date
SCHOOLID uniqueidentifier
ADDEDBYID uniqueidentifier
CHANGEDBYID uniqueidentifier
DATEADDED datetime
DATECHANGED datetime
TSLONG bigint yes

Indexes

Index Name Fields Unique Primary Clustered
UIX_V_SCHOLARSHIPTERM_SCHOOLID_ACADEMICYEARNAMECODEID SCHOOLID, ACADEMICYEARNAMECODEID yes yes

Definition

Copy 

            create view [dbo].[V_SCHOLARSHIPTERM] with schemabinding
                as
                select
                    ACADEMICYEAR.ID,
                    ACADEMICYEARNAMECODEID,
            ACADEMICYEARNAMECODE.DESCRIPTION as NAME,
                    ACADEMICYEAR.STARTDATE,
                    ACADEMICYEAR.ENDDATE,
                    ACADEMICYEAR.SCHOOLID,
                    ACADEMICYEAR.ADDEDBYID,
                    ACADEMICYEAR.CHANGEDBYID,
                    ACADEMICYEAR.DATEADDED,
                    ACADEMICYEAR.DATECHANGED,
                    ACADEMICYEAR.TSLONG
                from 
                    dbo.ACADEMICYEAR   
        join 
            dbo.ACADEMICYEARNAMECODE on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID