Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| OnlineImportStudentsSeq | int | 4 | √ | null |
|
|
||
| StudentSurname | varchar | 30 | √ | null |
|
|
||
| StudentPreferred | varchar | 20 | √ | null |
|
|
||
| StudentGiven1 | varchar | 20 | √ | null |
|
|
||
| StudentGiven2 | varchar | 50 | √ | null |
|
|
||
| StudentGender | varchar | 15 | √ | null |
|
|
||
| StudentDOB | datetime | 16,3 | √ | null |
|
|
||
| StudentCountryOfBirth | varchar | 5 | √ | null |
|
|
||
| StudentTitle | varchar | 30 | √ | null |
|
|
||
| StudentAppliedResidencyFlag | bit | 1 | √ | null |
|
|
||
| StudentCitizenship | varchar | 5 | √ | null |
|
|
||
| OnlineImportApplicationsSeq | int | 4 | null |
|
|
|||
| StudentEnrolDate | datetime | 16,3 | √ | null |
|
|
||
| StudentCampus | varchar | 3 | √ | null |
|
|
||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentEnquirySource | varchar | 10 | √ | null |
|
|
||
| Comment | varchar | 2147483647 | √ | null |
|
|
||
| StudentPreviousSchool | varchar | 15 | √ | null |
|
|
||
| StudentVisaNumber | varchar | 20 | √ | null |
|
|
||
| StudentVisaClass | varchar | 5 | √ | null |
|
|
||
| StudentPassportCountryCode | varchar | 5 | √ | null |
|
|
||
| StudentPassportExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentCountryOfApplicationCode | varchar | 5 | √ | null |
|
|
||
| HasSpecialNeeds | bit | 1 | √ | null |
|
|
||
| HasMedicalConditions | bit | 1 | √ | null |
|
|
||
| MedicalConditions | varchar | 2000 | √ | null |
|
|
||
| VisaExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| VisaIssuedDate | datetime | 16,3 | √ | null |
|
|
||
| VisaApplicationDate | datetime | 16,3 | √ | null |
|
|
||
| StudentVisaSubclass | varchar | 15 | √ | null |
|
|
||
| StudentArrivalDate | datetime | 16,3 | √ | null |
|
|
||
| StudentPassportIssueDate | datetime | 16,3 | √ | null |
|
|
||
| StudentReligion | varchar | 5 | √ | null |
|
|
||
| StudentParish | varchar | 5 | √ | null |
|
|
||
| StudentMobile | varchar | 20 | √ | null |
|
|
||
| StudentEmail | varchar | 50 | √ | null |
|
|
||
| StudentVSNNumber | varchar | 20 | √ | null |
|
|
||
| StudentPassPortNumber | varchar | 15 | √ | null |
|
|
||
| Boarder | varchar | 3 | √ | null |
|
|
||
| StudentHomeLanguage | varchar | 5 | √ | null |
|
|
||
| ContactSurname | varchar | 30 | √ | null |
|
|
||
| ContactTitle | varchar | 30 | √ | null |
|
|
||
| ContactPreferred | varchar | 20 | √ | null |
|
|
||
| ContactGiven1 | varchar | 20 | √ | null |
|
|
||
| ContactGiven2 | varchar | 50 | √ | null |
|
|
||
| ContactGender | varchar | 15 | √ | null |
|
|
||
| ContactMobilePhone | varchar | 15 | √ | null |
|
|
||
| ContactEmail | varchar | 100 | √ | null |
|
|
||
| ContactOccupPhone | varchar | 15 | √ | null |
|
|
||
| ContactOccupCompany | varchar | 50 | √ | null |
|
|
||
| ContactSpouseSurname | varchar | 30 | √ | null |
|
|
||
| ContactSpouseTitle | varchar | 30 | √ | null |
|
|
||
| ContactSpousePreferred | varchar | 20 | √ | null |
|
|
||
| ContactSpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| ContactSpouseGiven2 | varchar | 50 | √ | null |
|
|
||
| ContactSpouseGender | varchar | 15 | √ | null |
|
|
||
| ContactSpouseDOB | datetime | 16,3 | √ | null |
|
|
||
| ContactSpouseCountryOfBirthCode | varchar | 5 | √ | null |
|
|
||
| ContactSpouseMobilePhone | varchar | 15 | √ | null |
|
|
||
| ContactSpouseEmail | varchar | 100 | √ | null |
|
|
||
| ContactSpouseOccupPhone | varchar | 15 | √ | null |
|
|
||
| ContactSpouseOccupCompany | varchar | 50 | √ | null |
|
|
||
| ContactAddress1 | varchar | 40 | √ | null |
|
|
||
| ContactAddress2 | varchar | 40 | √ | null |
|
|
||
| ContactAddress3 | varchar | 40 | √ | null |
|
|
||
| ContactSuburb | varchar | 40 | √ | null |
|
|
||
| ContactState | varchar | 5 | √ | null |
|
|
||
| ContactCountryCode | varchar | 5 | √ | null |
|
|
||
| ContactPostCode | varchar | 5 | √ | null |
|
|
||
| ContactPhone | varchar | 15 | √ | null |
|
|
||
| ContactPhoneAlt | varchar | 15 | √ | null |
|
|
||
| ContactFax | varchar | 15 | √ | null |
|
|
||
| ContactPostalHomePhone | varchar | 15 | √ | null |
|
|
||
| ContactPostalPhone | varchar | 15 | √ | null |
|
|
||
| ContactPostalCountryCode | varchar | 5 | √ | null |
|
|
||
| ContactPostalState | varchar | 5 | √ | null |
|
|
||
| ContactPostalPostCode | varchar | 5 | √ | null |
|
|
||
| ContactPostalSuburb | varchar | 40 | √ | null |
|
|
||
| ContactPostalAddress3 | varchar | 40 | √ | null |
|
|
||
| ContactPostalAddress2 | varchar | 40 | √ | null |
|
|
||
| ContactPostalAddress1 | varchar | 40 | √ | null |
|
|
||
| ContactSpouseParish | varchar | 5 | √ | null |
|
|
||
| ContactParish | varchar | 5 | √ | null |
|
|
||
| ContactDOB | datetime | 16,3 | √ | null |
|
|
||
| ContactRelationship | varchar | 5 | √ | null |
|
|
||
| ContactSpouseRelationship | varchar | 5 | √ | null |
|
|
||
| ContactReligion | varchar | 5 | √ | null |
|
|
||
| ContactSpouseReligion | varchar | 5 | √ | null |
|
|
||
| LivesWithFlag | bit | 1 | √ | null |
|
|
||
| ParentFlag | bit | 1 | √ | null |
|
|
||
| NormalMailFlag | bit | 1 | √ | null |
|
|
||
| ReportsFlag | bit | 1 | √ | null |
|
|
||
| PrimaryOnlyFlag | bit | 1 | √ | null |
|
|
||
| ContactSurname2 | varchar | 30 | √ | null |
|
|
||
| ContactTitle2 | varchar | 30 | √ | null |
|
|
||
| ContactPreferred2 | varchar | 20 | √ | null |
|
|
||
| ContactGiven12 | varchar | 20 | √ | null |
|
|
||
| ContactGiven22 | varchar | 50 | √ | null |
|
|
||
| ContactGender2 | varchar | 15 | √ | null |
|
|
||
| ContactMobilePhone2 | varchar | 15 | √ | null |
|
|
||
| ContactEmail2 | varchar | 100 | √ | null |
|
|
||
| ContactOccupPhone2 | varchar | 15 | √ | null |
|
|
||
| ContactOccupCompany2 | varchar | 50 | √ | null |
|
|
||
| ContactSpouseSurname2 | varchar | 30 | √ | null |
|
|
||
| ContactSpouseTitle2 | varchar | 30 | √ | null |
|
|
||
| ContactSpousePreferred2 | varchar | 20 | √ | null |
|
|
||
| ContactSpouseGiven12 | varchar | 20 | √ | null |
|
|
||
| ContactSpouseGiven22 | varchar | 50 | √ | null |
|
|
||
| ContactSpouseGender2 | varchar | 15 | √ | null |
|
|
||
| ContactSpouseDOB2 | datetime | 16,3 | √ | null |
|
|
||
| ContactSpouseCountryOfBirthCode2 | varchar | 5 | √ | null |
|
|
||
| ContactSpouseMobilePhone2 | varchar | 15 | √ | null |
|
|
||
| ContactSpouseEmail2 | varchar | 100 | √ | null |
|
|
||
| ContactSpouseOccupPhone2 | varchar | 15 | √ | null |
|
|
||
| ContactSpouseOccupCompany2 | varchar | 50 | √ | null |
|
|
||
| ContactAddress12 | varchar | 40 | √ | null |
|
|
||
| ContactAddress22 | varchar | 40 | √ | null |
|
|
||
| ContactAddress32 | varchar | 40 | √ | null |
|
|
||
| ContactSuburb2 | varchar | 40 | √ | null |
|
|
||
| ContactState2 | varchar | 5 | √ | null |
|
|
||
| ContactCountryCode2 | varchar | 5 | √ | null |
|
|
||
| ContactPostCode2 | varchar | 5 | √ | null |
|
|
||
| ContactPhone2 | varchar | 15 | √ | null |
|
|
||
| ContactPhoneAlt2 | varchar | 15 | √ | null |
|
|
||
| ContactFax2 | varchar | 15 | √ | null |
|
|
||
| ContactPostalHomePhone2 | varchar | 15 | √ | null |
|
|
||
| ContactPostalPhone2 | varchar | 15 | √ | null |
|
|
||
| ContactPostalCountryCode2 | varchar | 5 | √ | null |
|
|
||
| ContactPostalState2 | varchar | 5 | √ | null |
|
|
||
| ContactPostalPostCode2 | varchar | 5 | √ | null |
|
|
||
| ContactPostalSuburb2 | varchar | 40 | √ | null |
|
|
||
| ContactPostalAddress32 | varchar | 40 | √ | null |
|
|
||
| ContactPostalAddress22 | varchar | 40 | √ | null |
|
|
||
| ContactPostalAddress12 | varchar | 40 | √ | null |
|
|
||
| ContactSpouseParish2 | varchar | 5 | √ | null |
|
|
||
| ContactParish2 | varchar | 5 | √ | null |
|
|
||
| ContactDOB2 | datetime | 16,3 | √ | null |
|
|
||
| ContactRelationship2 | varchar | 5 | √ | null |
|
|
||
| ContactSpouseRelationship2 | varchar | 5 | √ | null |
|
|
||
| ContactReligion2 | varchar | 5 | √ | null |
|
|
||
| ContactSpouseReligion2 | varchar | 5 | √ | null |
|
|
||
| LivesWithFlag2 | bit | 1 | √ | null |
|
|
||
| ParentFlag2 | bit | 1 | √ | null |
|
|
||
| NormalMailFlag2 | bit | 1 | √ | null |
|
|
||
| ReportsFlag2 | bit | 1 | √ | null |
|
|
||
| PrimaryOnlyFlag2 | bit | 1 | √ | null |
|
|
||
| ContactSurname3 | varchar | 30 | √ | null |
|
|
||
| ContactTitle3 | varchar | 30 | √ | null |
|
|
||
| ContactPreferred3 | varchar | 20 | √ | null |
|
|
||
| ContactGiven13 | varchar | 20 | √ | null |
|
|
||
| ContactGiven23 | varchar | 50 | √ | null |
|
|
||
| ContactGender3 | varchar | 15 | √ | null |
|
|
||
| ContactMobilePhone3 | varchar | 15 | √ | null |
|
|
||
| ContactEmail3 | varchar | 100 | √ | null |
|
|
||
| ContactOccupPhone3 | varchar | 15 | √ | null |
|
|
||
| ContactOccupCompany3 | varchar | 50 | √ | null |
|
|
||
| ContactSpouseSurname3 | varchar | 30 | √ | null |
|
|
||
| ContactSpouseTitle3 | varchar | 30 | √ | null |
|
|
||
| ContactSpousePreferred3 | varchar | 20 | √ | null |
|
|
||
| ContactSpouseGiven13 | varchar | 20 | √ | null |
|
|
||
| ContactSpouseGiven23 | varchar | 50 | √ | null |
|
|
||
| ContactSpouseGender3 | varchar | 15 | √ | null |
|
|
||
| ContactSpouseDOB3 | datetime | 16,3 | √ | null |
|
|
||
| ContactSpouseCountryOfBirthCode3 | varchar | 5 | √ | null |
|
|
||
| ContactSpouseMobilePhone3 | varchar | 15 | √ | null |
|
|
||
| ContactSpouseEmail3 | varchar | 100 | √ | null |
|
|
||
| ContactSpouseOccupPhone3 | varchar | 15 | √ | null |
|
|
||
| ContactSpouseOccupCompany3 | varchar | 50 | √ | null |
|
|
||
| ContactAddress13 | varchar | 40 | √ | null |
|
|
||
| ContactAddress23 | varchar | 40 | √ | null |
|
|
||
| ContactAddress33 | varchar | 40 | √ | null |
|
|
||
| ContactSuburb3 | varchar | 40 | √ | null |
|
|
||
| ContactState3 | varchar | 5 | √ | null |
|
|
||
| ContactCountryCode3 | varchar | 5 | √ | null |
|
|
||
| ContactPostCode3 | varchar | 5 | √ | null |
|
|
||
| ContactPhone3 | varchar | 15 | √ | null |
|
|
||
| ContactPhoneAlt3 | varchar | 15 | √ | null |
|
|
||
| ContactFax3 | varchar | 15 | √ | null |
|
|
||
| ContactPostalHomePhone3 | varchar | 15 | √ | null |
|
|
||
| ContactPostalPhone3 | varchar | 15 | √ | null |
|
|
||
| ContactPostalCountryCode3 | varchar | 5 | √ | null |
|
|
||
| ContactPostalState3 | varchar | 5 | √ | null |
|
|
||
| ContactPostalPostCode3 | varchar | 5 | √ | null |
|
|
||
| ContactPostalSuburb3 | varchar | 40 | √ | null |
|
|
||
| ContactPostalAddress33 | varchar | 40 | √ | null |
|
|
||
| ContactPostalAddress23 | varchar | 40 | √ | null |
|
|
||
| ContactPostalAddress13 | varchar | 40 | √ | null |
|
|
||
| ContactSpouseParish3 | varchar | 5 | √ | null |
|
|
||
| ContactParish3 | varchar | 5 | √ | null |
|
|
||
| ContactDOB3 | datetime | 16,3 | √ | null |
|
|
||
| ContactRelationship3 | varchar | 5 | √ | null |
|
|
||
| ContactSpouseRelationship3 | varchar | 5 | √ | null |
|
|
||
| ContactReligion3 | varchar | 5 | √ | null |
|
|
||
| ContactSpouseReligion3 | varchar | 5 | √ | null |
|
|
||
| LivesWithFlag3 | bit | 1 | √ | null |
|
|
||
| ParentFlag3 | bit | 1 | √ | null |
|
|
||
| NormalMailFlag3 | bit | 1 | √ | null |
|
|
||
| ReportsFlag3 | bit | 1 | √ | null |
|
|
||
| PrimaryOnlyFlag3 | bit | 1 | √ | null |
|
|
||
| ContactCount | varchar | 1 | null |
|
|
|||
| UniqueId | varchar | 40 | null |
|
|
|||
| PaymentRequest | varchar | 2147483647 | null |
|
|
|||
| PaymentResponse | varchar | 2147483647 | null |
|
|
|||
| ApplicationAmount | money | 21,4 | null |
|
|
|||
| StudentSchoolPreferenceCode1 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription1 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference1 | int | 4 | null |
|
|
|||
| StudentSchoolPreferenceCode2 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription2 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference2 | int | 4 | null |
|
|
|||
| StudentSchoolPreferenceCode3 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription3 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference3 | int | 4 | null |
|
|
|||
| StudentSchoolPreferenceCode4 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription4 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference4 | int | 4 | null |
|
|
|||
| StudentSchoolPreferenceCode5 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription5 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference5 | int | 4 | null |
|
|
|||
| StudentSchoolPreferenceCode6 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription6 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference6 | int | 4 | null |
|
|
|||
| StudentSchoolPreferenceCode7 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription7 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference7 | int | 4 | null |
|
|
|||
| StudentSchoolPreferenceCode8 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription8 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference8 | int | 4 | null |
|
|
|||
| StudentSchoolPreferenceCode9 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription9 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference9 | int | 4 | null |
|
|
|||
| StudentSchoolPreferenceCode10 | varchar | 15 | null |
|
|
|||
| StudentSchoolPreferenceDescription10 | varchar | 100 | null |
|
|
|||
| StudentSchoolPreference10 | int | 4 | null |
|
|
Table contained 0 rows