vCommunityKeys


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 √ null
NameInternal varchar 100 √ null
NameExternal varchar 100 √ null
LegalFullName varchar 150 √ null
Surname varchar 30 √ null
Title varchar 30 √ null
Initials varchar 15 √ null
Preferred varchar 20 √ null
PreferredFormal varchar 20 √ null
Given1 varchar 20 √ null
Given2 varchar 50 √ null
BirthDate datetime 16,3 √ null
Gender varchar 15 √ null
MobilePhone varchar 15 √ null
Email varchar 100 √ null
Education varchar 255 √ null
HighestSecondaryYearLevel tinyint 1 √ null
LastYearOfStudy int 4 √ null
MailNamePrimary varchar 100 √ null
ParkingSpace varchar 15 √ null
CommunityKeyExistsFlag int 4 null
CommunityKeyIssuedDate datetime 16,3 √ null
CommunityReturnedDate datetime 16,3 √ null
CommunityKeyNumber varchar 15 √ null
CommunityKeyComment varchar 255 √ null
CommunityKeysSeq int 4 √ null
KeyCode varchar 15 null
KeyDescription varchar 80 null
KeyReplacedDate datetime 16,3 √ null
KeyComment varchar 2147483647 √ null
AddressFull varchar 200 √ null
AddressComma varchar 200 √ null
ValidAddressFlag bit 1 √ null
StaffFlag int 4 null
StaffSchoolStaffCode varchar 30 √ null
StaffRegSchoolsBoardCode varchar 15 √ null
StaffRegistrationNumber varchar 15 √ null
StaffRegistrationType varchar 15 √ null
StaffRegistrationExpiryDate datetime 16,3 √ null
StaffStartDate datetime 16,3 √ null
StaffCampus varchar 3 √ null
StaffExtension varchar 15 √ null
StaffDepartmentCode varchar 15 √ null
StaffDepartmentCampus varchar 3 √ null
StaffDepartmentDescription varchar 80 √ null
StaffDepartmentLocation varchar 100 √ null
StaffDepartmentHeadOfDepartment varchar 50 √ null
StaffForm varchar 15 √ null
StaffHouse varchar 5 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views