vStudentReportsNoResults


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProblemDescription varchar 35 √ null
ProblemCode varchar 12 √ null
FileType varchar 5 null
FileYear smallint 2 null
FileSemester smallint 2 null
ClassColumn smallint 2 null
ClassCampus varchar 3 √ null
ClassCode varchar 15 √ null
SubjectClassDescription varchar 100 √ null
SubjectClassAssessmentCode varchar 15 √ null
AssessHeading varchar 255 √ null
StaffID int 4 √ null
StaffMailName varchar 100 √ null
StaffNameInternal varchar 100 √ null
StaffNameExternal varchar 100 √ null
StaffLegalFullName varchar 150 √ null
StaffSurname varchar 30 √ null
StaffPreferred varchar 20 √ null
StaffPreferredFormal varchar 20 √ null
StaffGiven1 varchar 20 √ null
SchoolStaffCode varchar 30 √ null
AssessmentAreaSeq smallint 2 √ null
AssessmentAreaHdgAbbrev1 varchar 10 √ null
AssessmentAreaHdgAbbrev2 varchar 10 √ null
AssessmentAreaResultType varchar 15 √ null
AssessmentAreaResultGroup varchar 15 √ null
StudentID int 4 null
StudentStatus varchar 3 √ null
StudentYearLevel smallint 2 √ null
StudentHouse varchar 5 √ null
StudentForm varchar 15 √ null
StudentTutor varchar 15 √ null
StudentNameInternal varchar 100 √ null
StudentNameExternal varchar 100 √ null
StudentLegalFullName varchar 150 √ null
StudentSurname varchar 30 √ null
StudentSurnameUpper varchar 30 √ null
StudentGiven1 varchar 20 √ null
StudentGiven2 varchar 50 √ null
StudentPreferred varchar 20 √ null
StudentPreferredFormal varchar 20 √ null
CurrentSemesterOnlyFlag int 4 null
StudentClassAssessableFlag bit 1 null
StudentClassStartDate datetime 16,3 √ null
StudentClassStopDate datetime 16,3 √ null
StudentCoursesSeq int 4 √ null
StudentClassesSeq int 4 null
StudentLeavingDate datetime 16,3 √ null
StudentSubSchool varchar 15 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views