pvvCommunitySkills


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
DefaultMobilePhone varchar 15 null
OccupMobilePhone varchar 15 null
Email varchar 100 null
Education varchar 255 null
HighestSecondaryYearLevel tinyint 1 null
LastYearOfStudy int 4 null
MailNamePrimary varchar 100 null
SkillExistsFlag int 4 null
SkillSeq int 4 √ null
SkillCode varchar 15 √ null
SkillDescription varchar 80 √ null
SkillLevel varchar 15 √ null
SkillLevelDescription varchar 80 √ null
SkillComment varchar 2147483647 √ null
SkillAttainedDate datetime 16,3 √ null
SkillExpiryDate datetime 16,3 √ 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
StaffActiveFlag bit 1 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views