vIndividualPlans


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IndividualPlanSeq int 4 null
ID int 4 null
IndividualPlanType varchar 15 null
IndividualPlanArea varchar 15 null
IndividualPlanStatus varchar 15 null
StartDate datetime 16,3 √ null
ReviewDate datetime 16,3 √ null
EndDate datetime 16,3 √ null
ReasonForPlan varchar 255 null
StaffMemberID int 4 √ null
OtherStaff varchar 100 null
StartingLevel varchar 2147483647 √ null
LevelValue decimal 6,2 √ null
Goal varchar 2147483647 √ null
Strategies varchar 2147483647 √ null
Monitoring varchar 2147483647 √ null
RelevantToAllClasses tinyint 1 null
FileTypeFilter varchar 5 null
indPlanTypeDescrip varchar 50 √ null
indPlanTypeAreaDescrip varchar 50 √ null
indPlanTypeStatusDescrip varchar 50 √ null
StudentGiven1 varchar 20 null
StudentGiven2 varchar 50 null
StudentSurname varchar 30 null
StudentID int 4 null
StudentYearLevel smallint 2 √ null
StudentBirthDate datetime 16,3 √ null
StudentGender varchar 15 null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
StudentCampus varchar 3 √ null
StudentCampusDescription varchar 30 √ null
StudentYearLevelDescription varchar 30 √ null
StudentHouse varchar 5 √ null
StudentHouseDescription varchar 30 √ null
Given1 varchar 20 √ null
Given2 varchar 50 √ null
Surname varchar 30 √ null
Photo varbinary 2147483647 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views