CourseRequirements Table

Column Name Type Allow Nuls Notes
CourseRequirementsID int No Primary Key
OrganizationID int No  
CampID int No  
DepartmentID int No  
CourseID int No  
SequenceNo int No Used to Order Requirements.  Must be a unique number.
RequirementType varchar(40) No  
RequirementCode varchar(40) No  
RequirementName varchar(1024) No  
RequirementDesc varchar(1024) Yes  
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  
DefaultCompletionStatus varchar(128) Yes  
CourseCompletionTransfer varchar(128) Yes