vPastStudentReportsSemester


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FileType varchar 5 null
FileYear smallint 2 null
FileSemester smallint 2 null
ClassColumn smallint 2 null
StudentID int 4 null
StudentLeavingDate datetime 16,3 √ null
StudentEntryDate datetime 16,3 √ null
StudentCampus varchar 3 null
ClassCampus varchar 3 null
ClassCode varchar 15 null
ClassLearningAreaCode varchar 15 null
ClassLearningAreaDescription varchar 60 √ null
ClassLearningAreaReportSortSeq int 4 √ null
ClassLearningAreaActiveFlag bit 1 √ null
StudentStatus varchar 3 null
StudentYearLevel smallint 2 √ null
StudentYearLevelSort smallint 2 √ null
StudentYearLevelDescription varchar 30 √ null
StudentYearLevelCoordinator varchar 30 √ null
StudentHouse varchar 5 null
StudentHouseDescription varchar 30 √ null
StudentHouseHeadOfHouse varchar 100 √ null
StudentForm varchar 15 null
StudentFormDescription varchar 30 √ null
StudentFormStaffName varchar 100 √ null
StudentTutor varchar 15 null
StudentTutorGroupDescription varchar 30 √ null
StudentTutorName varchar 100 √ null
StudentTutorMailName varchar 100 √ null
StudentTertiaryRegistrationCode varchar 15 null
StudentIBFlag bit 1 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
StudentInitials varchar 15 null
StudentPreferred varchar 20 null
StudentPreferredFormal varchar 20 null
SubjectClassBoardStudiesCode varchar 15 null
SubjectClassBoardStudiesCodeDescription varchar 100 √ null
SubjectClassBoardStudiesType varchar 10 null
SubjectClassBoardStudiesTypeDescription varchar 30 √ null
SubjectClassDescription varchar 100 null
SubjectClassAssessmentCode varchar 15 null
AssessReportStyle varchar 50 √ null
AssessHeading varchar 255 √ null
AssessUnitName varchar 255 √ null
AssessOverview varchar 2147483647 √ null
AssessTopicCommentsUsedFlag bit 1 √ null
AssessProgressiveFlag bit 1 √ null
AssessPrintSelectableFlag bit 1 √ null
AssessOverallResult1EntryFlag bit 1 √ null
AssessOverallResult2EntryFlag bit 1 √ null
AssessOverallResult1PrintFlag bit 1 √ null
AssessOverallResult2PrintFlag bit 1 √ null
AssessCommentsUsedFlag bit 1 √ null
StaffID int 4 √ null
SchoolStaffCode varchar 30 √ null
StaffMailName varchar 100 √ null
StaffTitle varchar 30 √ null
StaffNameInternal varchar 100 √ null
StaffNameExternal varchar 100 √ null
StaffLegalFullName varchar 150 √ null
StaffSurname varchar 30 √ null
StaffInitials varchar 15 √ null
StaffGiven1 varchar 20 √ null
StaffGiven2 varchar 50 √ null
StaffPreferred varchar 20 √ null
StaffPreferredFormal varchar 20 √ null
StudentClassSubject varchar 15 null
StudentClassInterviewRequested varchar 15 null
OverallResult1 varchar 30 √ null
StudentClassAssessableFlag bit 1 null
StudentClassActiveNowFlag int 4 null
OverallTopicComment1 nvarchar 1073741823 √ null
OverallResult1PrintSelectFlag bit 1 √ null
OverallResult1Classification varchar 15 √ null
OverallResult1ClassificationDescription varchar 100 √ null
OverallResult2 varchar 30 √ null
OverallTopicComment2 nvarchar 1073741823 √ null
OverallResult2PrintSelectFlag bit 1 √ null
OverallResult2Classification varchar 15 √ null
OverallResult2ClassificationDescription varchar 100 √ null
StudentAssessCommentsStaffID int 4 √ null
StudentAssessCommentsComment nvarchar 1073741823 √ null
StudentAssessCommentExistsFlag int 4 null
CurrentSemesterOnlyFlag int 4 null
StudentGender varchar 15 null
ActualSemester smallint 2 null
ClassStatus varchar 3 null
StudentBoarder varchar 3 null
StudentBoarderType varchar 30 √ null
StudentBoardingHouse varchar 15 null
StudentStudiesCode varchar 15 null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
ShortCourseFlag bit 1 √ null
StudentSubSchool varchar 15 √ null
StudentClassesSeq int 4 √ null
StudentGovernmentStudentNumber varchar 15 √ null
LearningPathway varchar 30 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views