Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StudentsHistorySeq | int | 4 | null |
|
|
|||
| StudentsHistoryID | int | 4 | null |
|
|
|||
| StudentsHistoryCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryCreatedBy | varchar | 50 | √ | null |
|
|
||
| StudentsHistoryModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryModifiedBy | varchar | 50 | √ | null |
|
|
||
| StudentsHistoryOperator | varchar | 30 | null |
|
|
|||
| StudentsHistoryStudiesCode | varchar | 15 | null |
|
|
|||
| StudentsHistoryTertiaryRegistrationCode | varchar | 15 | null |
|
|
|||
| StudentsHistoryTimeTableCode | varchar | 15 | null |
|
|
|||
| StudentsHistoryAltCode | varchar | 15 | null |
|
|
|||
| StudentsHistoryDebtorID | int | 4 | null |
|
|
|||
| StudentsHistoryDebtorIDSeq | smallint | 2 | null |
|
|
|||
| StudentsHistoryN16StuCode | varchar | 50 | null |
|
|
|||
| StudentsHistoryN16ParCode | varchar | 50 | null |
|
|
|||
| StudentsHistoryN16DebCode | varchar | 50 | null |
|
|
|||
| StudentsHistoryAgeYearsJan | smallint | 2 | null |
|
|
|||
| StudentsHistoryAgeMonthsJan | smallint | 2 | null |
|
|
|||
| StudentsHistoryFamilyPosition | smallint | 2 | null |
|
|
|||
| StudentsHistoryEldestFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryYoungestFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryEntryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryEntryCampus | varchar | 3 | null |
|
|
|||
| StudentsHistoryEntryYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentsHistoryEnquirySource | varchar | 10 | null |
|
|
|||
| StudentsHistoryEnquirySourceComment | varchar | 50 | null |
|
|
|||
| StudentsHistoryPreviousSchool | varchar | 15 | null |
|
|
|||
| StudentsHistoryMedicalAlert | varchar | 2000 | √ | null |
|
|
||
| StudentsHistoryExternalStudentFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryEnglishSecondFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryDisabilityFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryFullFeeFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryTuitionVariationType | varchar | 3 | null |
|
|
|||
| StudentsHistoryTuitionNoSibFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryDoctorName | varchar | 80 | null |
|
|
|||
| StudentsHistoryDoctorPhone | varchar | 15 | null |
|
|
|||
| StudentsHistoryDoctorPhoneAlt | varchar | 15 | null |
|
|
|||
| StudentsHistoryDoctorAddress | varchar | 200 | null |
|
|
|||
| StudentsHistoryDoctorSpecialisation | varchar | 50 | null |
|
|
|||
| StudentsHistoryDoctor2Name | varchar | 80 | null |
|
|
|||
| StudentsHistoryDoctor2Phone | varchar | 15 | null |
|
|
|||
| StudentsHistoryDoctor2PhoneAlt | varchar | 15 | null |
|
|
|||
| StudentsHistoryDoctor2Address | varchar | 200 | null |
|
|
|||
| StudentsHistoryDoctor2Specialisation | varchar | 50 | null |
|
|
|||
| StudentsHistoryDentistName | varchar | 80 | null |
|
|
|||
| StudentsHistoryDentistPhone | varchar | 15 | null |
|
|
|||
| StudentsHistoryDentistPhoneAlt | varchar | 15 | null |
|
|
|||
| StudentsHistoryDentistAddress | varchar | 200 | null |
|
|
|||
| StudentsHistoryEmergencyName | varchar | 80 | null |
|
|
|||
| StudentsHistoryEmergencyAddress | varchar | 200 | null |
|
|
|||
| StudentsHistoryEmergencyPhone | varchar | 15 | null |
|
|
|||
| StudentsHistoryEmergencyPhoneAlt | varchar | 15 | null |
|
|
|||
| StudentsHistoryEmergencyRelat | varchar | 5 | √ | null |
|
|
||
| StudentsHistoryEmergency2Name | varchar | 80 | null |
|
|
|||
| StudentsHistoryEmergency2Address | varchar | 200 | null |
|
|
|||
| StudentsHistoryEmergency2Phone | varchar | 15 | null |
|
|
|||
| StudentsHistoryEmergency2PhoneAlt | varchar | 15 | null |
|
|
|||
| StudentsHistoryEmergency2Relat | varchar | 5 | √ | null |
|
|
||
| StudentsHistoryLastLessonRcvdDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryBirthCertificateFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryNonResidentFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryCrecheFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryBeforeSchoolCareFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryAfterSchoolCareFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryVisaType | varchar | 5 | null |
|
|
|||
| StudentsHistoryVisaExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryPassportNo | varchar | 15 | null |
|
|
|||
| StudentsHistoryComment | varchar | 2147483647 | √ | null |
|
|
||
| StudentsHistoryCommentWarningFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryBaptismFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryBaptismDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryReconciliationFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryReconciliationDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryCommunionFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryCommunionDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryConfirmationFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryConfirmationDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryAustudyFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryIndigenousFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryNaturalisationDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryDebtorPrimaryOnlyFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryStudentBillingFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryAllowAutoTuitionFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryAllowAutoChargesFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryIBFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryVisaNumber | varchar | 20 | null |
|
|
|||
| StudentsHistoryPassportCountryCode | varchar | 5 | null |
|
|
|||
| StudentsHistoryPassportExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryApplicationDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryEmergency3Name | varchar | 80 | null |
|
|
|||
| StudentsHistoryEmergency3Address | varchar | 200 | null |
|
|
|||
| StudentsHistoryEmergency3Phone | varchar | 15 | null |
|
|
|||
| StudentsHistoryEmergency3PhoneAlt | varchar | 15 | null |
|
|
|||
| StudentsHistoryEmergency3Relat | varchar | 5 | null |
|
|
|||
| StudentsHistoryMedicalAlertFlag | bit | 1 | null |
|
|
|||
| StudentsHistorySpecialNeedsFlag | bit | 1 | null |
|
|
|||
| StudentsHistorySpecialBillingType | varchar | 5 | null |
|
|
|||
| StudentsHistoryStudyAtHomeFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryTSIFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryESLProficiencyLevel | varchar | 15 | null |
|
|
|||
| StudentsHistoryPreEntryComment | varchar | 2147483647 | √ | null |
|
|
||
| StudentsHistoryEnquiryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryIntendsTertiaryFlag | bit | 1 | null |
|
|
|||
| StudentsHistoryPassportIssuedDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryVisaIssuedDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsHistoryEmergencyID | int | 4 | null |
|
|
|||
| StudentsHistoryEmergency2ID | int | 4 | null |
|
|
|||
| StudentsHistoryEmergency3ID | int | 4 | null |
|
|
|||
| StudentYearsHistorySeq | int | 4 | null |
|
|
|||
| StudentYearsHistoryFileYear | smallint | 2 | √ | null |
|
|
||
| StudentYearsHistoryStatus | varchar | 3 | √ | null |
|
|
||
| StudentYearsHistoryStatusNextYear | varchar | 3 | √ | null |
|
|
||
| StudentYearsHistoryStudentCampus | varchar | 3 | √ | null |
|
|
||
| StudentYearsHistoryYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentYearsHistoryYearLevelSort | smallint | 2 | √ | null |
|
|
||
| StudentYearsHistoryHouse | varchar | 5 | √ | null |
|
|
||
| StudentYearsHistoryForm | varchar | 15 | √ | null |
|
|
||
| StudentYearsHistoryTutor | varchar | 15 | √ | null |
|
|
||
| StudentYearsHistoryBoarder | varchar | 3 | √ | null |
|
|
||
| StudentYearsHistorySports1 | varchar | 15 | √ | null |
|
|
||
| StudentYearsHistorySports2 | varchar | 15 | √ | null |
|
|
||
| StudentYearsHistoryLockerBook | varchar | 15 | √ | null |
|
|
||
| StudentYearsHistoryLockerOther | varchar | 15 | √ | null |
|
|
||
| StudentYearsHistoryFamilyPosition | smallint | 2 | √ | null |
|
|
||
| StudentYearsHistoryLeavingDate | datetime | 16,3 | √ | null |
|
|
||
| StudentYearsHistoryReturningDate | datetime | 16,3 | √ | null |
|
|
||
| StudentYearsHistoryLeavingReason | varchar | 3 | √ | null |
|
|
||
| StudentYearsHistoryLeavingDestination | varchar | 15 | √ | null |
|
|
||
| StudentYearsHistoryBoardingHouse | varchar | 15 | √ | null |
|
|
||
| StudentYearsHistoryOverrideNextYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentYearsHistoryOverrideNextStudentCampus | varchar | 3 | √ | null |
|
|
||
| StudentYearsHistoryOverrideNextBoarder | varchar | 3 | √ | null |
|
|
||
| StudentYearsHistorySchoolFTE | decimal | 7,2 | √ | null |
|
|
||
| StudentYearsHistoryCalibreMark | decimal | 7,2 | √ | null |
|
|
||
| StudentYearsHistoryTravelAllowanceFlag | bit | 1 | √ | null |
|
|
||
| StudentYearsHistoryModifiedDate | datetime | 16,3 | null |
|
|
|||
| StudentYearsHistoryModifiedBy | varchar | 50 | 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 |
|
|
|||
| StudentStaticHistorySeq | int | 4 | null |
|
|
|||
| StudentStaticHistoryIntegrationFlag | bit | 1 | null |
|
|
|||
| StudentStaticHistoryInitialSchoolingDate | datetime | 16,3 | √ | null |
|
|
||
| StudentStaticHistorySaleDailyCreditLimit | money | 21,4 | null |
|
|
|||
| StudentStaticHistoryNewArrivalsProgramFlag | bit | 1 | null |
|
|
|||
| StudentStaticHistoryPriorOvernightCampsFlag | bit | 1 | null |
|
|
|||
| StudentStaticHistoryStudentTypeCode | varchar | 15 | null |
|
|
|||
| StudentStaticHistoryResourceLevelCode | varchar | 15 | null |
|
|
|||
| StudentStaticHistorySchoolZoneCode | varchar | 15 | null |
|
|
|||
| SystemProcessNumber | int | 4 | √ | null |
|
|
||
| RollReturnMonth | varchar | 1 | √ | null |
|
|
||
| RollReturnYear | int | 4 | √ | null |
|
|
||
| FormFieldName | varchar | 50 | √ | null |
|
|
||
| FormGroup | varchar | 15 | √ | null |
|
|
||
| FormStaffName | varchar | 100 | √ | null |
|
|
||
| MOEYearLevel | varchar | 15 | √ | null |
|
|
||
| RollReturnCountDate | datetime | 16,3 | √ | null |
|
|
||
| LearningPathway | varchar | 30 | null |
|
|
Table contained 0 rows