vStudentAssessmentResultsCurriculumClasses


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FileYear int 4 null
ActualSemester int 4 null
FileSemester smallint 2 null
FileSemesterEndDate datetime 16,3 √ null
FileType varchar 5 null
ClassCampus varchar 3 null
AssessmentCode varchar 15 null
AssessmentHeading varchar 255 null
ClassCode varchar 15 null
ClassDescription varchar 100 null
SchoolStaffCode varchar 30 √ null
ReportSortSeq int 4 null
StaffMailName varchar 100 √ null
StaffInternalName varchar 100 √ null
StaffSurname varchar 30 √ null
StaffPreferred varchar 20 √ null
StaffGiven1 varchar 20 √ null
StaffTitle varchar 30 √ null
StaffInitials varchar 15 √ null
StaffNameExternal varchar 100 √ null
StudentID int 4 null
ID int 4 null
StudentSurname varchar 30 null
StudentPreferred varchar 20 null
StudentGiven1 varchar 20 null
StudentNameInternal varchar 100 null
StudentNameExternal varchar 100 null
StudentLegalFullName varchar 150 null
StudentCampus varchar 3 null
StudentYearLevel smallint 2 √ null
StudentSubSchool varchar 15 √ null
StudentYearLevelDescription varchar 30 null
StudentYearLevelSort smallint 2 null
StudentHouse varchar 5 null
StudentForm varchar 15 null
StudentTutor varchar 15 null
StudentGovernmentStudentNumber varchar 15 null
CurriculumCode varchar 15 null
CurriculumDescription varchar 100 null
Level1Name varchar 100 null
Level1Code varchar 15 √ null
Level1Description varchar 100 √ null
Level2Name varchar 100 null
Level2Code varchar 15 √ null
Level2Description varchar 100 √ null
Level2SummariseFlag bit 1 √ null
AustralianCurriculumFlag bit 1 √ null
Level3Name varchar 100 null
Level3Code varchar 15 √ null
Level3Description varchar 100 √ null
Pathway varchar 100 √ null
Sequence varchar 100 √ null
Result varchar 5 √ null
ResultYearLevel smallint 2 √ null
ResultReportPositionYearLevelSemester decimal 5,1 √ null
ResultGrade varchar 10 √ null
FileYearPrior int 4 √ null
ActualSemesterPrior int 4 √ null
ClassCampusPrior varchar 3 √ null
AssessmentCodePrior varchar 15 √ null
ResultPrior varchar 5 √ null
ResultYearLevelPrior smallint 2 √ null
ResultReportPositionYearLevelSemesterPrior decimal 5,1 √ null
ResultGradePrior varchar 10 √ null
ResultExpected varchar 5 √ null
ResultReportPositionYearLevelSemesterExpected decimal 5,1 √ null
ReportExpectedYearLevelAreaFlag bit 1 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views