vStudentClassesContactsAll


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 null
StudentCreatedDate datetime 16,3 √ null
StudentCreatedBy varchar 50 √ null
StudentModifiedDate datetime 16,3 √ null
StudentModifiedBy varchar 50 √ null
StudentOperator varchar 30 null
StudentBarCode varchar 20 null
StudentStudiesCode varchar 15 null
StudentGovernmentStudentNumber varchar 15 √ null
StudentTertiaryRegistrationCode varchar 15 null
StudentTimeTableCode varchar 15 null
StudentAltCode varchar 15 null
StudentDebtorID int 4 null
StudentDebtorIDSeq smallint 2 null
StudentN16StuCode varchar 50 null
StudentN16ParCode varchar 50 null
StudentN16DebCode varchar 50 null
StudentEntryDate datetime 16,3 √ null
StudentEntryCampus varchar 3 null
StudentEntryYearLevel smallint 2 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 null
StudentLeavingDestination varchar 15 null
StudentEnquirySource varchar 10 null
StudentEnquirySourceComment varchar 50 null
StudentPreviousSchool varchar 15 null
StudentMedicalAlert varchar 2000 √ null
StudentExternalStudentFlag bit 1 null
StudentEnglishSecondFlag bit 1 null
StudentDisabilityFlag bit 1 null
StudentIBFlag bit 1 null
StudentFullFeeFlag bit 1 null
StudentTuitionVariationType varchar 3 null
StudentTuitionNoSibFlag bit 1 null
StudentDoctorName varchar 80 null
StudentDoctorPhone varchar 15 null
StudentDoctorPhoneAlt varchar 15 null
StudentDoctorAddress varchar 200 null
StudentDoctorSpecialisation varchar 50 null
StudentDoctor2Name varchar 80 null
StudentDoctor2Phone varchar 15 null
StudentDoctor2PhoneAlt varchar 15 null
StudentDoctor2Address varchar 200 null
StudentDoctor2Specialisation varchar 50 null
StudentDentistName varchar 80 null
StudentDentistPhone varchar 15 null
StudentDentistPhoneAlt varchar 15 null
StudentDentistAddress varchar 200 null
StudentEmergencyName varchar 80 null
StudentEmergencyAddress varchar 200 null
StudentEmergencyPhone varchar 15 null
StudentEmergencyPhoneAlt varchar 15 null
StudentEmergencyRelat varchar 5 √ null
StudentEmergency2Name varchar 80 null
StudentEmergency2Address varchar 200 null
StudentEmergency2Phone varchar 15 null
StudentEmergency2PhoneAlt varchar 15 null
StudentEmergency2Relat varchar 5 √ null
StudentLastLessonRcvdDate datetime 16,3 √ null
StudentBirthCertificateFlag bit 1 null
StudentNonResidentFlag bit 1 null
StudentCrecheFlag bit 1 null
StudentBeforeSchoolCareFlag bit 1 null
StudentAfterSchoolCareFlag bit 1 null
StudentVisaType varchar 5 null
StudentVisaExpiryDate datetime 16,3 √ null
StudentVisaNumber varchar 20 null
StudentPassportCountryCode varchar 5 null
StudentPassportExpiryDate datetime 16,3 √ null
StudentPassportNo varchar 15 null
StudentComment varchar 2147483647 √ null
StudentCommentWarningFlag bit 1 null
StudentBaptismFlag bit 1 null
StudentBaptismDate datetime 16,3 √ null
StudentReconciliationFlag bit 1 null
StudentReconciliationDate datetime 16,3 √ null
StudentCommunionFlag bit 1 null
StudentCommunionDate datetime 16,3 √ null
StudentConfirmationFlag bit 1 null
StudentConfirmationDate datetime 16,3 √ null
StudentAustudyFlag bit 1 null
StudentIndigenousFlag bit 1 null
StudentNaturalisationDate datetime 16,3 √ null
StudentReturningDate datetime 16,3 √ null
StudentDebtorPrimaryOnlyFlag bit 1 null
StudentStudentBillingFlag bit 1 null
StudentAllowAutoTuitionFlag bit 1 null
StudentAllowAutoChargesFlag bit 1 null
StudentEmergency3Name varchar 80 null
StudentEmergency3Phone varchar 15 null
StudentEmergency3PhoneAlt varchar 15 null
StudentEmergency3Address varchar 200 null
StudentMedicalAlertFlag bit 1 null
StudentSpecialNeedsFlag bit 1 null
StudentSpecialBillingType varchar 5 null
StudentStudyAtHomeFlag bit 1 null
StudentTSIFlag bit 1 null
StudentESLProficiencyLevel varchar 15 null
StudentESLListeningLevelCode varchar 15 √ null
StudentESLSpeakingLevelCode varchar 15 √ null
StudentESLReadingLevelCode varchar 15 √ null
StudentESLWritingLevelCode varchar 15 √ null
StudentIntendsTertiaryFlag bit 1 null
FileYear smallint 2 null
FileSemester smallint 2 null
ID int 4 null
StudentStatus varchar 3 null
StudentStatusNextYear varchar 3 null
StudentCampus varchar 3 null
StudentYearLevel smallint 2 √ null
StudentYearLevelSort smallint 2 null
StudentHouse varchar 5 null
StudentForm varchar 15 null
StudentTutor varchar 15 null
StudentBoarder varchar 3 null
StudentBoardingHouse varchar 15 null
StudentBoarderType varchar 30 √ null
StudentSports1 varchar 15 null
StudentSports2 varchar 15 null
StudentFamilyPosition smallint 2 null
ClassColumn smallint 2 null
ClassCampus varchar 3 null
FileType varchar 5 null
ClassCode varchar 15 null
ModifiedDate datetime 16,3 √ null
ModifiedBy varchar 50 √ null
UnitsAdjustment smallint 2 null
UnitsTotal smallint 2 null
ClassStatus varchar 3 null
InterviewRequested varchar 15 null
OverallResult1 varchar 30 √ null
OverallTopicComment1 nvarchar 1073741823 √ null
OverallResult2 varchar 30 √ null
OverallTopicComment2 nvarchar 1073741823 √ null
AuthorApprovedFlag bit 1 null
EditorApprovedFlag bit 1 null
PrintApprovedFlag bit 1 null
SchoolStaffCode varchar 30 √ null
StartDate datetime 16,3 √ null
StopDate datetime 16,3 √ null
AssessmentCode varchar 15 null
StudentContactType varchar 3 null
StudentContactLinkedID int 4 null
StudentContactPrimaryOnlyFlag bit 1 null
StudentContactNormalMailFlag bit 1 null
StudentContactReportsFlag bit 1 null
StudentContactParentFlag bit 1 null
StudentContactLivesWithFlag bit 1 null
StudentNameInternal varchar 100 null
StudentNameExternal varchar 100 null
StudentLegalFullName varchar 150 null
StudentSurname varchar 30 null
StudentPreferred varchar 20 null
StudentPreferredFormal varchar 20 null
StudentGiven1 varchar 20 null
StudentGiven2 varchar 50 null
StudentBirthDate datetime 16,3 √ null
StudentGender varchar 15 null
StudentEmail varchar 100 null
StudentCountryOfBirthCode varchar 5 null
StudentContactNameInternal varchar 100 null
StudentContactNameExternal varchar 100 null
StudentContactLegalFullName varchar 150 null
StudentContactSurname varchar 30 null
StudentContactSurnamePrevious varchar 30 null
StudentContactTitle varchar 30 null
StudentContactInitials varchar 15 null
StudentContactSuffix varchar 20 null
StudentContactPreferred varchar 20 null
StudentContactPreferredFormal varchar 20 null
StudentContactGiven1 varchar 20 null
StudentContactGiven2 varchar 50 null
StudentContactOccupCode varchar 15 √ null
StudentContactOccupDesc varchar 50 null
StudentContactOccupCompany varchar 50 null
StudentContactOccupIndustryCode varchar 8 null
StudentContactOccupPositionCode varchar 8 null
StudentContactOccupPhone varchar 15 null
StudentContactOccupFax varchar 15 null
StudentContactOccupEmail varchar 100 null
StudentContactMailFormat varchar 1 null
StudentContactSalutFormat varchar 1 null
StudentContactBirthDate datetime 16,3 √ null
StudentContactDeceasedDate datetime 16,3 √ null
StudentContactDeceasedFlag bit 1 null
StudentContactGender varchar 15 null
StudentContactMobilePhone varchar 15 null
StudentContactDefaultMobilePhone varchar 15 null
StudentContactEmail varchar 100 null
StudentContactReligionCode varchar 5 null
StudentContactCountryOfBirthCode varchar 5 null
StudentContactHomeLanguageCode varchar 5 null
StudentContactEducation varchar 255 null
StudentContactQualifications varchar 255 null
StudentContactHighestSecondaryYearLevel tinyint 1 null
StudentContactLastYearOfStudy int 4 null
StudentContactMaritalStatus varchar 1 null
StudentContactMailNamePrimary varchar 100 null
StudentContactMailNameJoint varchar 100 null
StudentContactMailName varchar 100 null
StudentContactMailSalutationPrimary varchar 100 null
StudentContactMailSalutationJoint varchar 100 null
StudentContactMailSalutation varchar 100 null
StudentContactOccupAddress1 varchar 40 null
StudentContactOccupAddress2 varchar 40 null
StudentContactOccupAddress3 varchar 40 null
StudentContactOccupSuburb varchar 40 null
StudentContactOccupState varchar 5 √ null
StudentContactOccupCountryCode varchar 5 null
StudentContactOccupPostCode varchar 5 null
StudentContactOccupMobilePhone varchar 15 null
StudentContactComment varchar 2147483647 √ null
StudentContactBiography varchar 2147483647 √ null
StudentContactOccupAddressFull varchar 200 null
StudentContactOccupAddressComma varchar 200 null
StudentContactParishCode varchar 5 null
StudentContactNationalityCode varchar 5 null
StudentContactNationality2Code varchar 5 null
StudentContactInitialsOverrideFlag bit 1 null
StudentContactOccupCompanyAttn varchar 40 null
StudentContactDefaultEmailCode varchar 1 null
Address1 varchar 40 null
Address2 varchar 40 null
Address3 varchar 40 null
Suburb varchar 40 null
State varchar 5 null
CountryCode varchar 5 null
PostCode varchar 5 null
PhoneActual varchar 15 null
PhoneAlt varchar 15 null
Fax varchar 15 null
HomeAddressSameFlag bit 1 null
HomeAddress1 varchar 40 null
HomeAddress2 varchar 40 null
HomeAddress3 varchar 40 null
HomeSuburb varchar 40 null
HomeState varchar 5 null
HomeCountryCode varchar 5 null
HomePostCode varchar 5 null
ValidAddressFlag bit 1 null
SilentPhoneFlag bit 1 null
MailFlag bit 1 null
MagazineFlag bit 1 null
SolicitationFlag bit 1 null
RaffleFlag bit 1 null
ReasonFlagChange varchar 50 null
ReasonFlagChangeDate datetime 16,3 √ null
AddressComma varchar 200 √ null
AddressFull varchar 200 √ null
AddressDPIDBarCode varchar 60 null
HomeAddressComma varchar 200 √ null
HomeAddressFull varchar 200 √ null
HomeAddressDPIDBarcode varchar 60 null
Phone varchar 15 √ null
AddressRegion varchar 10 √ null
AddressRegionOverrideFlag tinyint 1 √ null
CurrentSemesterOnlyFlag int 4 null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
StudentSubSchool varchar 15 √ null
InterviewRequestedCode varchar 15 null
InterviewRequestedDescription varchar 50 null
LearningPathway varchar 30 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views