vScholarshipApplicationsPrimC


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 √ null
StudentNameInternal varchar 100 √ null
StudentNameExternal varchar 100 √ null
StudentLegalFullName varchar 150 √ null
StudentSurname varchar 30 √ null
StudentPreferred varchar 20 √ null
StudentPreferredFormal varchar 20 √ null
StudentGiven1 varchar 20 √ null
StudentGiven2 varchar 50 √ null
StudentBirthdate datetime 16,3 √ null
StudentGender varchar 15 √ null
StudentName varchar 52 √ null
EnquiryStudentFlag int 4 null
ScholarshipCampus varchar 3 null
Scholarship varchar 10 null
ScholarshipStatus varchar 3 null
ScholarshipYear smallint 2 null
ScholarshipEnquiryDate datetime 16,3 √ null
ScholarshipTestingMark tinyint 1 √ null
ScholarshipTesingDate datetime 16,3 √ null
ScholarshipFinalisedDate datetime 16,3 √ null
ScholarshipComment varchar 2147483647 null
ScholarshipDescription varchar 100 √ null
ScholarchipStatusDescription varchar 30 √ null
StudentContactID int 4 √ null
StudentContactAddressID int 4 √ null
StudentContactDeceasedFlag bit 1 √ null
ContactMailName varchar 100 √ null
ContactMailSalutation varchar 100 √ null
ContactPhone varchar 15 √ null
ContactValidAddressFlag int 4 √ null
ContactAddressComma varchar 200 √ null
ContactAddressFull varchar 200 √ null
FutureStatus varchar 3 √ null
ApplicantSource varchar 7 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views