vStudentCocurricularSubjectClass


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentLegalFullName varchar 150 null
StudentNameInternal varchar 100 null
StudentID int 4 null
StudentSurname varchar 30 null
StudentPreferred varchar 20 null
StudentGiven1 varchar 20 null
StudentGiven2 varchar 50 null
StudentFileYear smallint 2 √ null
StudentFileSemester smallint 2 √ null
StudentCampus varchar 3 √ null
StudentCampusDescription varchar 30 √ null
StudentYearLevel smallint 2 √ null
StudentYearLevelDescription varchar 30 √ null
StudentYearLevelCoordinator varchar 30 √ null
StudentGender varchar 15 null
StudentHouse varchar 5 √ null
StudentHouseDescription varchar 30 √ null
StudentFullFeeFlag bit 1 null
StudentBirthDate datetime 16,3 √ null
StudentForm varchar 15 √ null
StudentFormDescription varchar 30 √ null
studentTutor varchar 15 √ null
StudentStatus varchar 3 √ null
studentBoarder varchar 3 √ null
studentBoarderType varchar 30 √ null
StudentBoardingHouse varchar 15 √ null
StudentLeavingDate datetime 16,3 √ null
FileSemesterDesc varchar 100 null
StaffID int 4 √ null
StaffCode varchar 30 √ null
StaffSurname varchar 30 √ null
StaffPreferred varchar 20 √ null
StaffGiven1 varchar 20 √ null
StaffGiven2 varchar 50 √ null
StudentClassesFileType varchar 5 null
StudentClassesFileTypeDesc varchar 30 null
StudentClassesFileYear smallint 2 null
StudentClassesFileSemester smallint 2 null
StudentClassesClassColumn smallint 2 null
StudentClassesAssessableFlag bit 1 null
StudentClassesModifiedDate datetime 16,3 √ null
StudentClassesModifiedBy varchar 50 √ null
StudentClassesUnitsAdjustment smallint 2 null
StudentClassesUnitsTotal smallint 2 null
StudentClassesStatus varchar 3 null
StudentClassesInterviewRequested varchar 15 null
StudentClassesAuthorApprovedFlag bit 1 null
StudentClassesEditorApprovedFlag bit 1 null
StudentClassesPrintApprovedFlag bit 1 null
StudentClassesComment varchar 255 null
StudentClassesFocusArea varchar 5 null
StudentClassesStartDate datetime 16,3 √ null
StudentClassesStopDate datetime 16,3 √ null
StudentClassesResultsCopiedFlag bit 1 null
StudentClassesStudentClassesSeq int 4 null
StudentClassesSubjectClassesSeq int 4 √ null
StudentClassesStudentCoursesSeq int 4 √ null
StudentClassesCommPortalPrintDate datetime 16,3 √ null
StudentClassesCommPortalPrintID int 4 √ null
StudentClassesPostingNumberClassCharges int 4 √ null
StudentClassesHoldUnitsAdjustment smallint 2 √ null
StudentClassesHoldUnitsTotal smallint 2 √ null
StudentClassesLearningAreaPositionCode varchar 15 √ null
StudentClassesLearningAreaPositionDesc varchar 100 √ null
StudentClassesColours varchar 255 null
StudentClassesPoints decimal 10,2 √ null
StudentClassesRepresentation varchar 1000 null
SubjectClassesClassCampus varchar 3 null
SubjectClassesClassCode varchar 15 null
SubjectClassesDescription varchar 100 null
SubjectClassesAssessmentCode varchar 15 null
SubjectClassesNormalYearLevel smallint 2 √ null
SubjectClassesNormalYearLevel2 smallint 2 √ null
SubjectClassesLearningAreaCode varchar 15 null
SubjectClassesClassID varchar 5 null
SubjectClassesFeeCode varchar 15 null
SubjectClassesFeeDefaultUnits smallint 2 null
SubjectClassesEventPayCode varchar 10 √ null
SubjectClassesEventActiveFlag bit 1 null
SubjectClassesEventGroupFlag bit 1 null
SubjectClassesBoardStudiesCode varchar 15 null
SubjectClassesCoreSubjectFlag bit 1 null
SubjectClassesResultsLockedFlag bit 1 null
SubjectClassesCourseAutoSelectFlag bit 1 null
SubjectClassesCopyToSem2ClassCode varchar 15 null
SubjectClassesAuthorBlockedFlag bit 1 null
SubjectClassesTimetableImportKeepAssessFlag bit 1 null
SubjectClassesTimetableImportNeverClearFlag bit 1 null
SubjectClassesBoardStudiesType varchar 10 null
SubjectClassesAdjustmentMean decimal 7,2 null
SubjectClassesAdjustmentStandardDeviation decimal 7,2 null
SubjectClassesClassType varchar 15 null
SubjectClassesRoom varchar 15 null
SubjectClassesReportingPeriodHours decimal 9,4 null
SubjectClassesSubjectClassesSeq int 4 null
SubjectClassesLocationCode varchar 15 null
SubjectClassesComment varchar 4000 √ null
SubjectClassesAssessmentSchemeApprovalNumber varchar 30 null
SubjectClassesLanguageCode varchar 5 null
SubjectClassesSubjectAssessmentsSeq int 4 √ null
SubjectClassesMultipleStaffMarkbookFlag bit 1 null
SubjectClassesCommPortalMarkbookPublishFlag bit 1 null
SubjectClassesSubjectClassesGUID varchar 32 null
SubjectClassesLinkedSubjectClassesSeq int 4 √ null
SubjectClassesSubjectClassCategoryCode varchar 15 √ null
SubjectClassesMasterClassCode varchar 15 √ null
SubjectClassesPortalElectiveDescription varchar 200 null
SubjectClassesAgeGroupCode varchar 15 √ null
ClassCategroyDesc varchar 100 √ null
AgeGroupDesc varchar 100 √ null
RestrictedEndDate datetime 16,3 √ null
MedicalConditionSeverityDisplayColour varchar 10 √ null
StudentGenderSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views