Course Table

Column Name Type Allow Nulls Notes
CourseID int No  
CourseNo varchar(40) No  
CourseName varchar(256) No  
CourseDesc varchar(256) Yes  
OrganizationID int No  
CampID int No  
DepartmentID int No  
StartTime time(7) No  
EndTime time(7) No  
Sun bit Yes  
Mon bit Yes  
Tues bit Yes  
Wed bit Yes  
Thur bit Yes  
Fri bit Yes  
Sat bit Yes  
MaxSize int Yes  
EnforceMaxSize bit Yes  
InstructorFullName varchar(512) Yes  
InstructorPersonID int Yes  
GradeLow int Yes  
GradeHigh int Yes  
AgeLow int Yes  
AgeHigh int Yes  
YearAtCamp int Yes  
Gender varchar(40) Yes  
AllowDuplicateRegistration varchar(1) No  
ValidateStoredProcedure varchar(1) No  
Attribute1 varchar(128) Yes  
Attribute2 varchar(128) Yes
Attribute3 varchar(128) Yes  
Attribute4 varchar(128) Yes  
Attribute5 varchar(128) Yes  
Attribute6 varchar(128) Yes  
Attribute7 varchar(128) Yes  
Attribute8 varchar(128) Yes  
Attribute9 varchar(128) Yes  
Attribute10 varchar(128) Yes  
ActiveFlag varchar(1) No  
CreationDate datetime No  
CreatedBy nvarchar(256) No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No  
Rank varchar(128) Yes  
DefaultLocationID int Yes  
DefaultAreaID int Yes  
CourseCompletionTransferIn varchar(128) Yes