vNZMOE_Students


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentsID int 4 null
StudentsCreatedDate datetime 16,3 √ null
StudentsCreatedBy varchar 50 √ null
StudentsModifiedDate datetime 16,3 √ null
StudentsModifiedBy varchar 50 √ null
StudentsOperator varchar 30 null
StudentsStudiesCode varchar 15 null
StudentsTertiaryRegistrationCode varchar 15 null
StudentsTimeTableCode varchar 15 null
StudentsAltCode varchar 15 null
StudentsDebtorID int 4 null
StudentsDebtorIDSeq smallint 2 null
StudentsN16StuCode varchar 50 null
StudentsN16ParCode varchar 50 null
StudentsN16DebCode varchar 50 null
StudentsAgeYearsJan smallint 2 null
StudentsAgeMonthsJan smallint 2 null
StudentsFamilyPosition smallint 2 null
StudentsEldestFlag bit 1 null
StudentsYoungestFlag bit 1 null
StudentsEntryDate datetime 16,3 √ null
StudentsEntryCampus varchar 3 null
StudentsEntryYearLevel smallint 2 √ null
StudentsEnquirySource varchar 10 null
StudentsEnquirySourceComment varchar 50 null
StudentsPreviousSchool varchar 15 null
StudentsMedicalAlert varchar 2000 √ null
StudentsExternalStudentFlag bit 1 null
StudentsEnglishSecondFlag bit 1 null
StudentsDisabilityFlag bit 1 null
StudentsFullFeeFlag bit 1 null
StudentsTuitionVariationType varchar 3 null
StudentsTuitionNoSibFlag bit 1 null
StudentsDoctorName varchar 80 null
StudentsDoctorPhone varchar 15 null
StudentsDoctorPhoneAlt varchar 15 null
StudentsDoctorAddress varchar 200 null
StudentsDoctorSpecialisation varchar 50 null
StudentsDoctor2Name varchar 80 null
StudentsDoctor2Phone varchar 15 null
StudentsDoctor2PhoneAlt varchar 15 null
StudentsDoctor2Address varchar 200 null
StudentsDoctor2Specialisation varchar 50 null
StudentsDentistName varchar 80 null
StudentsDentistPhone varchar 15 null
StudentsDentistPhoneAlt varchar 15 null
StudentsDentistAddress varchar 200 null
StudentsEmergencyName varchar 80 null
StudentsEmergencyAddress varchar 200 null
StudentsEmergencyPhone varchar 15 null
StudentsEmergencyPhoneAlt varchar 15 null
StudentsEmergencyRelat varchar 5 √ null
StudentsEmergency2Name varchar 80 null
StudentsEmergency2Address varchar 200 null
StudentsEmergency2Phone varchar 15 null
StudentsEmergency2PhoneAlt varchar 15 null
StudentsEmergency2Relat varchar 5 √ null
StudentsLastLessonRcvdDate datetime 16,3 √ null
StudentsBirthCertificateFlag bit 1 null
StudentsNonResidentFlag bit 1 null
StudentsCrecheFlag bit 1 null
StudentsBeforeSchoolCareFlag bit 1 null
StudentsAfterSchoolCareFlag bit 1 null
StudentsVisaType varchar 5 null
StudentsVisaExpiryDate datetime 16,3 √ null
StudentsPassportNo varchar 15 null
StudentsComment varchar 2147483647 √ null
StudentsCommentWarningFlag bit 1 null
StudentsBaptismFlag bit 1 null
StudentsBaptismDate datetime 16,3 √ null
StudentsReconciliationFlag bit 1 null
StudentsReconciliationDate datetime 16,3 √ null
StudentsCommunionFlag bit 1 null
StudentsCommunionDate datetime 16,3 √ null
StudentsConfirmationFlag bit 1 null
StudentsConfirmationDate datetime 16,3 √ null
StudentsAustudyFlag bit 1 null
StudentsIndigenousFlag bit 1 null
StudentsNaturalisationDate datetime 16,3 √ null
StudentsDebtorPrimaryOnlyFlag bit 1 null
StudentsStudentBillingFlag bit 1 null
StudentsAllowAutoTuitionFlag bit 1 null
StudentsAllowAutoChargesFlag bit 1 null
StudentsIBFlag bit 1 null
StudentsVisaNumber varchar 20 null
StudentsPassportCountryCode varchar 5 null
StudentsPassportExpiryDate datetime 16,3 √ null
StudentsApplicationDate datetime 16,3 √ null
StudentsEmergency3Name varchar 80 null
StudentsEmergency3Address varchar 200 null
StudentsEmergency3Phone varchar 15 null
StudentsEmergency3PhoneAlt varchar 15 null
StudentsEmergency3Relat varchar 5 null
StudentsMedicalAlertFlag bit 1 null
StudentsSpecialNeedsFlag bit 1 null
StudentsSpecialBillingType varchar 5 null
StudentsStudyAtHomeFlag bit 1 null
StudentsTSIFlag bit 1 null
StudentsESLProficiencyLevel varchar 15 null
StudentsPreEntryComment varchar 2147483647 √ null
StudentsEnquiryDate datetime 16,3 √ null
StudentsIntendsTertiaryFlag bit 1 null
StudentsPassportIssuedDate datetime 16,3 √ null
StudentsVisaIssuedDate datetime 16,3 √ null
StudentsEmergencyID int 4 null
StudentsEmergency2ID int 4 null
StudentsEmergency3ID int 4 null
StudentYearsFileYear smallint 2 null
StudentYearsStatus varchar 3 null
StudentYearsStatusNextYear varchar 3 null
StudentYearsStudentCampus varchar 3 null
StudentYearsYearLevel smallint 2 √ null
StudentYearsYearLevelSort smallint 2 null
StudentYearsHouse varchar 5 null
StudentYearsForm varchar 15 null
StudentYearsTutor varchar 15 null
StudentYearsBoarder varchar 3 null
StudentYearsSports1 varchar 15 null
StudentYearsSports2 varchar 15 null
StudentYearsLockerBook varchar 15 null
StudentYearsLockerOther varchar 15 null
StudentYearsFamilyPosition smallint 2 null
StudentYearsLeavingDate datetime 16,3 √ null
StudentYearsReturningDate datetime 16,3 √ null
StudentYearsLeavingReason varchar 3 null
StudentYearsLeavingDestination varchar 15 null
StudentYearsBoardingHouse varchar 15 null
StudentYearsOverrideNextYearLevel smallint 2 √ null
StudentYearsOverrideNextStudentCampus varchar 3 null
StudentYearsOverrideNextBoarder varchar 3 null
StudentYearsSchoolFTE decimal 7,2 null
StudentYearsCalibreMark decimal 7,2 null
StudentYearsTravelAllowanceFlag bit 1 null
CommunityArchiveIDType varchar 1 null
CommunityArchiveAddressID int 4 null
CommunityArchiveSpouseID int 4 null
CommunityArchiveSpouseFlag bit 1 null
CommunityArchiveCommunityCreatedDate datetime 16,3 √ null
CommunityArchiveCommunityCreatedBy varchar 50 √ null
CommunityArchiveCommunityModifiedDate datetime 16,3 √ null
CommunityArchiveCommunityModifiedBy varchar 50 √ null
CommunityArchiveSurname varchar 30 null
CommunityArchiveSurnamePrevious varchar 30 null
CommunityArchiveTitle varchar 30 null
CommunityArchiveInitials varchar 15 null
CommunityArchiveSuffix varchar 20 null
CommunityArchivePreferred varchar 20 null
CommunityArchiveGiven1 varchar 20 null
CommunityArchiveGiven2 varchar 50 null
CommunityArchiveOccupCode varchar 15 √ null
CommunityArchiveOccupDesc varchar 50 null
CommunityArchiveOccupCompany varchar 50 null
CommunityArchiveOccupIndustryCode varchar 8 null
CommunityArchiveOccupPositionCode varchar 8 null
CommunityArchiveOccupPhone varchar 15 null
CommunityArchiveOccupFax varchar 15 null
CommunityArchiveOccupEmail varchar 100 null
CommunityArchiveMailFormat varchar 1 null
CommunityArchiveSalutFormat varchar 1 null
CommunityArchiveBirthDate datetime 16,3 √ null
CommunityArchiveDeceasedDate datetime 16,3 √ null
CommunityArchiveDeceasedFlag bit 1 null
CommunityArchiveGender varchar 15 null
CommunityArchiveMobilePhone varchar 15 null
CommunityArchiveEmail varchar 100 null
CommunityArchiveReligionCode varchar 5 null
CommunityArchiveCountryOfBirthCode varchar 5 null
CommunityArchiveHomeLanguageCode varchar 5 null
CommunityArchiveEducation varchar 255 null
CommunityArchiveQualifications varchar 255 null
CommunityArchiveHighestSecondaryYearLevel tinyint 1 null
CommunityArchiveLastYearOfStudy int 4 null
CommunityArchiveMaritalStatus varchar 1 null
CommunityArchiveMailNamePrimary varchar 100 null
CommunityArchiveMailNameJoint varchar 100 null
CommunityArchiveMailSalutationPrimary varchar 100 null
CommunityArchiveMailSalutationJoint varchar 100 null
CommunityArchiveLegalFullName varchar 150 null
CommunityArchiveOccupAddress1 varchar 40 null
CommunityArchiveOccupAddress2 varchar 40 null
CommunityArchiveOccupAddress3 varchar 40 null
CommunityArchiveOccupSuburb varchar 40 null
CommunityArchiveOccupState varchar 5 √ null
CommunityArchiveOccupCountryCode varchar 5 null
CommunityArchiveOccupPostCode varchar 5 null
CommunityArchiveOccupMobilePhone varchar 15 null
CommunityArchiveOccupAddressFull varchar 200 null
CommunityArchiveOccupAddressComma varchar 200 null
CommunityArchiveParishCode varchar 5 null
CommunityArchiveNationalityCode varchar 5 null
CommunityArchiveInitialsOverrideFlag bit 1 null
CommunityArchiveOccupCompanyAttn varchar 40 null
CommunityArchiveDefaultEmailCode varchar 1 null
CommunityArchiveNationality2Code varchar 5 null
CommunityArchiveOccupDescIncludeInAddressFlag bit 1 null
CommunityArchiveOccupAddressDPID varchar 8 null
CommunityArchiveOccupAddressSortPlanNumber varchar 3 null
CommunityArchiveParkingSpace varchar 15 null
CommunityArchiveOccupAddressPAFVersion varchar 10 null
CommunityArchiveOccupAddressDPIDBarcode varchar 60 null
CommunityArchiveNetworkLogin varchar 100 null
CommunityArchiveBarcode varchar 20 null
CommunityArchiveOccupMobilePhoneActual varchar 15 null
CommunityArchiveSilentMobilePhoneFlag bit 1 null
CommunityArchiveMobilePhoneActual varchar 15 null
CommunityArchiveSilentOccupMobilePhoneFlag bit 1 null
CommunityArchiveDirectoryIncludeFlag bit 1 null
CommunityArchiveDirectoryProvideFlag bit 1 null
CommunityArchiveUserFlag1 bit 1 null
CommunityArchiveUserFlag2 bit 1 null
CommunityArchiveUserFlag3 bit 1 null
CommunityArchiveUserFlag4 bit 1 null
CommunityArchiveUserFlag5 bit 1 null
CommunityArchiveMailNamePrimaryOverrideFlag bit 1 null
CommunityArchiveMailNameJointOverrideFlag bit 1 null
CommunityArchiveMailSalutationPrimaryOverrideFlag bit 1 null
CommunityArchiveMailSalutationJointOverrideFlag bit 1 null
StudentStaticIntegrationFlag bit 1 null
StudentStaticInitialSchoolingDate datetime 16,3 √ null
StudentStaticSaleDailyCreditLimit money 21,4 null
StudentStaticNewArrivalsProgramFlag bit 1 null
StudentStaticPriorOvernightCampsFlag bit 1 null
StudentStaticStudentTypeCode varchar 15 null
StudentStaticResourceLevelCode varchar 15 null
StudentStaticSchoolZoneCode varchar 15 null
FormFieldName varchar 50 √ null
FormGroup varchar 15 null
FormStaffName varchar 100 √ null
MOEYearLevel varchar 15 √ null
FundingYearLevel int 4 √ null
StudentStaticExchangeSchemeCode varchar 15 null
StudentsPassportCountryDescription varchar 40 √ null
StudentStaticExchangeSchemeDescription varchar 100 √ null
StudentStaticEligibilityCode varchar 15 null
StudentStaticEligibilityDescription varchar 100 √ null
LearningPathway varchar 30 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views