vPastStudentReportsSemesterResults


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FileType varchar 5 null
FileYear smallint 2 null
FileSemester smallint 2 null
ID int 4 null
StudentID int 4 null
ClassColumn smallint 2 null
ClassCampus varchar 3 null
ClassCode varchar 15 null
ActiveFlag bit 1 √ null
AssessableFlag bit 1 null
UnitsAdjustment smallint 2 null
UnitsTotal smallint 2 null
Status varchar 3 null
InterviewRequested varchar 15 null
AuthorApprovedFlag bit 1 null
EditorApprovedFlag bit 1 null
PrintApprovedFlag bit 1 null
ClassComment varchar 255 null
ClassDescription varchar 100 √ null
ClassNormalYearLevel smallint 2 √ null
ClassLearningAreaCode varchar 15 √ null
ClassLearningAreaDescription varchar 60 √ null
ClassLearningAreaActiveFlag bit 1 √ null
ClassLearningAreaReportSortSeq int 4 √ null
AssessmentCode varchar 15 √ null
AssessHeading varchar 255 √ null
AssessUnitName varchar 255 √ null
AssessOverview varchar 2147483647 √ null
AssessReportStyle varchar 50 √ null
AssessInterimReportStyle varchar 30 √ null
AssessCommentsUsedFlag bit 1 √ null
AssessTopicCommentsUsedFlag bit 1 √ null
AssessProgressiveFlag bit 1 √ null
AssessPrintSelectableFlag bit 1 √ null
OverrideReportSortSeq int 4 √ null
AssessAreaResultType varchar 15 √ null
AssessAreaResultTypeShortDesc varchar 10 √ null
AssessAreaResultTypeSort int 4 √ null
AssessAreaResultGroup varchar 15 √ null
AssessAreaResultGroupDescription varchar 50 √ null
AssessAreaResultGroupLockedFlag bit 1 √ null
AssessAreaSeq smallint 2 √ null
UnderlayFollowingAreaFlag bit 1 √ null
AssessAreaOverallFlag bit 1 √ null
AssessAreaOverallSeq smallint 2 √ null
AssessAreaNumericFlag bit 1 √ null
AssessDefaultValue varchar 30 √ null
AssessAreaEntryFlag bit 1 √ null
AssessAreaPrintFlag bit 1 √ null
AssessAreaCalculatedFlag bit 1 √ null
AssessAreaMarkOutOf int 4 √ null
AssessAreaWeightingFactor numeric 10,4 √ null
AssessAreaMaskCode varchar 4000 √ null
AssessAreaSummariseToSeq smallint 2 √ null
AreaBlockEndFlag bit 1 √ null
AutoPickFlag bit 1 √ null
AssessAreaHdgAbbrev1 varchar 10 √ null
AssessAreaHdgAbbrev2 varchar 10 √ null
AssessAreaHeading varchar 255 √ null
AssessAreaOverview varchar 2147483647 √ null
AssessAreaResultEntryFlag bit 1 √ null
AssessAreaResultPrintFlag bit 1 √ null
AssessAreaDefaultClassification varchar 15 √ null
AssessAreaExternalLinkSeq int 4 √ null
AssessAreaResultMin decimal 10,2 √ null
AssessAreaResultMax decimal 10,2 √ null
AssessAreaResultAverage decimal 10,2 √ null
AssessAreaResultVariance decimal 10,2 √ null
AssesAreaResultStandardDeviation decimal 10,2 √ null
AssessAreaResultMaskPercentUseForCalc decimal 9,2 √ null
AssessAreaResultMaskPercentGreaterEqualThan decimal 9,2 √ null
AssessAreaResultMaskPercentLessThan decimal 9,2 √ null
AssessTargetResultMin decimal 7,2 √ null
AssessTargetResultMax decimal 7,2 √ null
AssessResultsResult varchar 30 √ null
AssessResultDescription varchar 100 √ null
AssessResultsResultDate datetime 16,3 √ null
AssessResultsOverrideFlag bit 1 √ null
AssessResultsTopicComment nvarchar 1073741823 √ null
AssessResultsTopicCommentExistsFlag int 4 null
AssessResultsPrintSelectFlag bit 1 √ null
AssessResultsClassification varchar 15 √ null
AssessResultClassificationDescription varchar 100 √ null
AssessCommentsCommentType char 3 √ null
AssessCommentsStaffID int 4 √ null
AssessCommentsComment nvarchar 1073741823 √ null
AssessCommentExistsFlag int 4 null
CurrentSemesterOnlyFlag int 4 null
StudentNameInternal varchar 100 √ null
StudentNameExternal varchar 100 √ null
StudentLegalFullName varchar 150 √ null
StudentSurname varchar 30 √ null
StudentGiven1 varchar 20 √ null
StudentGiven2 varchar 50 √ null
StudentInitials varchar 15 √ null
StudentPreferred varchar 20 √ null
StudentPreferredFormal varchar 20 √ null
StudentGender varchar 15 √ null
StudentCampus varchar 3 √ null
StudentCampusDescription varchar 30 √ null
StudentYearLevel smallint 2 √ null
StudentYearLevelDescription varchar 30 √ null
StudentYearLevelSort smallint 2 √ null
StudentYearLevelCoordinator varchar 30 √ null
StudentStatus varchar 3 √ null
StudentBoarder varchar 3 √ null
StudentBoarderType varchar 30 √ null
StudentBoardingHouse varchar 15 √ null
StudentHouse varchar 5 √ null
StudentHouseDescription varchar 30 √ null
StudentHouseHeadOfHouse varchar 100 √ null
StudentIBFlag bit 1 √ null
StudentIntendsTertiaryFlag bit 1 √ null
StudentForm varchar 15 √ null
StudentFormDescription varchar 30 √ null
StudentFormHomeRoom varchar 15 √ null
StudentFormStaffName varchar 100 √ null
StudentFormStaffID int 4 √ null
StudentTutor varchar 15 √ null
StudentTutorDescription varchar 30 √ null
StudentTutorName varchar 100 √ null
StudentEntryDate datetime 16,3 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 √ null
StudentLeavingDestination varchar 15 √ null
StudentReturningDate datetime 16,3 √ null
StaffName varchar 63 √ null
StaffMailName varchar 100 √ null
StaffTitle varchar 30 √ null
StaffNameInternal varchar 100 √ null
StaffNameExternal varchar 100 √ null
StaffLegalFullName varchar 150 √ null
StaffInitials varchar 15 √ null
StaffPreferred varchar 20 √ null
StaffPreferredFormal varchar 20 √ null
StaffGiven1 varchar 20 √ null
StaffGiven2 varchar 50 √ null
StaffSurname varchar 30 √ null
AssessmentComment nvarchar 1073741823 √ null
ActualSemester smallint 2 √ null
StaffID int 4 √ null
SchoolStaffCode varchar 30 √ null
StudentStudiesCode varchar 15 √ null
StudentGovernmentStudentNumber varchar 15 √ null
ClassDefaultPrintFlag int 4 null
AssessAreaResultTypeSynergyMeaning varchar 30 √ null
SubjectComment varchar 4000 √ null
ClassStartDate datetime 16,3 √ null
ClassStopDate datetime 16,3 √ null
AssessResultGroupSort tinyint 1 √ null
AssessResultGroupDescription varchar 50 √ null
StudentBirthDate datetime 16,3 √ null
StudentCoursesSeq int 4 √ null
StudentClassesSeq int 4 √ null
SubjectAssessmentsSeq int 4 √ null
SubjectClassesSeq int 4 √ null
ClassType varchar 15 √ null
ClassTypeDescription varchar 50 √ null
ShortCourseFlag bit 1 √ null
SubjectAssessmentAreaGUID int 4 √ null
StudentSubSchool varchar 15 √ null
LearningPathway varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views