vStudentFamilySiblingCount


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
StudentContactType varchar 3 √ null
StudentContactDescription varchar 30 √ null
StudentContactLivesWithFlag bit 1 √ null
StudentContactPrimaryOnlyFlag bit 1 √ null
StudentContactNormalMailFlag bit 1 √ null
StudentContactValidAddress bit 1 √ null
StudentContactReportsFlag bit 1 √ null
StudentContactParentFlag bit 1 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 √ null
Status varchar 3 √ null
StatusDescription varchar 30 √ null
StatusNextYear varchar 3 √ null
StatusNextYearDescription varchar 30 √ null
StudentCampus varchar 3 √ null
StudentEntryDate datetime 16,3 √ null
StudentEntryCampus varchar 3 null
StudentEntryYearLevel smallint 2 √ null
StudentReturningDate datetime 16,3 √ null
StudentCampusDescription varchar 30 √ null
YearLevel smallint 2 √ null
YearLevelSort smallint 2 √ null
House varchar 5 √ null
Form varchar 15 √ null
StudentFormDescription varchar 30 √ null
StudentFormHomeroom varchar 15 √ null
StudentFormHomeroomTeacher varchar 100 √ null
Tutor varchar 15 √ null
Boarder varchar 3 √ null
BoarderSynergyMeaning varchar 30 √ null
BoardingHouse varchar 15 √ null
DebtorID int 4 null
StudentNoSiblingDiscountFlag bit 1 null
FullFeeFlag bit 1 null
NameInternal varchar 100 √ null
NameExternal varchar 100 √ null
LegalFullName varchar 150 √ null
Surname varchar 30 √ null
Preferred varchar 20 √ null
PreferredFormal varchar 20 √ null
Given1 varchar 20 √ null
Given2 varchar 50 √ null
StudentName varchar 51 √ null
StudentBirthDate datetime 16,3 √ null
StudentGender varchar 15 √ null
StudentReligionCode varchar 5 √ null
StudentReligionDescription varchar 40 √ null
StudentParishCode varchar 5 √ null
StudentParishDescription varchar 50 √ null
StudentContactID int 4 √ null
StudentContactSpouseID int 4 √ null
StudentContactMailName varchar 100 √ null
StudentContactMailSalutation varchar 100 √ null
StudentContactAddressComma varchar 200 √ null
StudentContactAddressFull varchar 200 √ null
StudentContactHomeAddressComma varchar 200 √ null
StudentContactHomeAddressFull varchar 200 √ null
StudentContactHomeAddressSameFlag bit 1 √ null
StudentContactEmail varchar 100 √ null
StudentContactMobilePhone varchar 15 √ null
StudentContactDefaultMobilePhone varchar 15 √ null
StudentContactState varchar 5 √ null
StudentContactCountryCode varchar 5 √ null
StudentContactCountryDesc varchar 40 √ null
StudentContactPostCode varchar 5 √ null
StudentContactMailFlag bit 1 √ null
StudentContactRaffleFlag bit 1 √ null
StudentContactDeceasedFlag bit 1 √ null
StudentContactTitle varchar 30 √ null
StudentContactNameInternal varchar 100 √ null
StudentContactNameExternal varchar 100 √ null
StudentContactLegalFullName varchar 150 √ null
StudentContactSurname varchar 30 √ null
StudentContactPreferred varchar 20 √ null
StudentContactPreferredFormal varchar 20 √ null
StudentContactOccupCompany varchar 50 √ null
StudentContactOccupType varchar 50 √ null
StudentContactOccupDescription varchar 120 √ null
StudentContactOccupCode varchar 15 √ null
StudentContactOccupPhone varchar 15 √ null
StudentContactOccupFax varchar 15 √ null
StudentContactDefaultEmailCode varchar 1 √ null
StudentContactOccupEmail varchar 100 √ null
StudentContactOccupMobilePhone varchar 15 √ null
StudentContactSpouseTitle varchar 30 √ null
StudentContactSpouseNameInternal varchar 100 √ null
StudentContactSpouseNameExternal varchar 100 √ null
StudentContactSpouseLegalFullName varchar 150 √ null
StudentContactSpouseSurname varchar 30 √ null
StudentContactSpousePreferred varchar 20 √ null
StudentContactSpousePreferredFormal varchar 20 √ null
StudentContactSpouseOccupCompany varchar 50 √ null
StudentContactSpouseOccupType varchar 50 √ null
StudentContactSpouseOccupDescription varchar 120 √ null
StudentContactSpouseOccupPhone varchar 15 √ null
StudentContactSpouseOccupFax varchar 15 √ null
StudentContactSpouseOccupEmail varchar 100 √ null
StudentContactSpouseEmail varchar 100 √ null
StudentContactSpouseDefaultEmailCode varchar 1 √ null
StudentContactSpouseMobilePhone varchar 15 √ null
StudentContactSpouseDefaultMobilePhone varchar 15 √ null
StudentContactSpouseOccupMobilePhone varchar 15 √ null
StudentContactHomePhone varchar 15 √ null
StudentContactHomePhoneAlt varchar 15 √ null
StudentContactHomeFax varchar 15 √ null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
BarCode varchar 20 √ null
StudiesCode varchar 15 null
GovernmentStudentNumber varchar 15 √ null
TimetableCode varchar 15 null
ValidAddressFlag bit 1 √ null
CurrentSemesterOnlyFlag int 4 null
StudentFamilyPosition smallint 2 √ null
SiblingCount int 4 √ null
OldestID int 4 √ null
OldestFamilyPosition smallint 2 √ null
YoungestID int 4 √ null
YoungestFamilyPosition smallint 2 √ null
CampusSiblingCount int 4 √ null
CampusOldestID int 4 √ null
CampusOldestFamilyPosition smallint 2 √ null
CampusYoungestID int 4 √ null
CampusYoungestFamilyPosition smallint 2 √ null
StudentSubSchool varchar 15 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views