CUSTOMFORMDASHBOARDFORMENTRY

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
CURRENTGRADELEVEL	nvarchar(100)		Default = ''
GRADELEVELAPPLY	nvarchar(100)		Default = ''
ACADEMICYEARID	nvarchar(100)		Default = ''
CHANGEDATE	datetime	yes
STUDENTFIRSTNAME	nvarchar(50)		Default = ''
STUDENTLASTNAME	nvarchar(100)		Default = ''
SUBMITDATE	datetime	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
CUSTOMFORMENTRYID	uniqueidentifier		CustomFormEntry.EntryID

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_CUSTOMFORMDASHBOARDFORMENTRY	ID	yes	yes	yes
UC_CUSTOMFORMDASHBOARDFORMENTRY_CUSTOMFORMENTRYID	CUSTOMFORMENTRYID	yes