pvStandardMergeList


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NameInternal varchar 100 null
NameExternal varchar 100 null
LegalFullName varchar 150 null
Surname varchar 30 null
Preferred varchar 20 null
PreferredFormal varchar 20 null
Title varchar 30 null
MailNamePrimary varchar 100 null
MailNameJoint varchar 100 null
DisplayName varchar 221 √ null
DefaultEmail varchar 201 null
MailSalutationPrimary varchar 100 null
MailSalutationJoint varchar 100 null
Email varchar 100 null
AddressComma varchar 200 √ null
AddressFull varchar 200 √ null
AddressSuburb varchar 40 √ null
AddressPostcode varchar 5 √ null
Phone varchar 15 √ null
MobilePhone varchar 15 null
DefaultMobilePhone varchar 15 null
Fax varchar 15 √ null
OccupDesc varchar 50 null
OccupCompany varchar 50 null
OccupAddressFull varchar 200 null
OccupAddressComma varchar 200 null
OccupPhone varchar 15 null
OccupMobilePhone varchar 15 null
OccupFax varchar 15 null
OccupSuburb varchar 40 null
OccupState varchar 5 √ null
OccupPostCode varchar 5 null
ID int 4 null
Form varchar 30 √ null
House varchar 30 √ null
TutorGroup varchar 30 √ null
StaffName varchar 100 √ null
HomeroomTutor varchar 100 √ null
StudentYearLevel smallint 2 √ null
StudentYearLevelDescription varchar 30 √ null
DateToday varchar 30 √ null
NetworkLogin varchar 100 null
EnrolYear int 4 √ null
FutureCampus varchar 30 √ null
Campus varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views