Camp Analytics Summary Table

Column Name Type Allow Nulls Notes
CampAnalyticsSummaryID int No Unique ID
OrganizationID int No  
OrganizationCode varchar(40) No  
OrganizationName varchar(256) No  
OrganizationDesc varchar(256) Yes  
CampID int No  
CampCode varchar(40) No  
CampName varchar(256) No  
CampDesc varchar(256) Yes  
EventID int Yes  
EventName varchar(256) Yes  
EventDesc varchar(256) Yes  
EventYear varchar(8) Yes  
EventStartDate datetime Yes  
EventEndDate datetime Yes  
EventRegistrationType varchar(128) Yes  
RegionID int No  
RegionCode varchar(40) No  
RegionName varchar(256) No  
RegionDesc varchar(256) Yes  
UnitID int No  
UnitCode varchar(40) No  
UnitName varchar(256) No  
UnitDesc varchar(256) Yes  
UnitLeaderID int Yes  
UnitLeaderFullName varchar(512) Yes  
PersonID int No  
PersonNo varchar(40) Yes  
PersonFirstName varchar(128) No  
PersonLastName varchar(128) No  
PersonMiddleName varchar(128) Yes  
PersonFullName varchar(512) Yes  
PersonLegacyIdentifier varchar(48) Yes  
PersonBirthdate datetime Yes  
PersonGender varchar(2) Yes  
PersonYearAtCamp varchar(128) Yes  
PersonGrade varchar(128) Yes  
PersonRank varchar(128) Yes  
PersonUserName nvarchar(256) Yes  
PersonUnitLeader varchar(1) Yes  
PersonInstructor varchar(1) Yes  
PersonPrimaryPhone varchar(48) Yes  
PersonPrimaryPhoneType varchar(128) Yes  
PersonPrimaryEmail varchar(256) Yes  
DepartmentID int Yes  
DepartmentName varchar(256) Yes  
CourseID int Yes  
CourseNo varchar(40) Yes  
CourseName varchar(256) Yes  
CourseDesc varchar(256) Yes  
StartTime time(7) Yes  
EndTime time(7) Yes  
Sun bit Yes  
Mon bit Yes  
Tues bit Yes  
Wed bit Yes  
Thur bit Yes  
Fri bit Yes  
Sat bit Yes  
CourseMaxSize int Yes  
CourseEnforceMaxSize bit Yes  
CourseInstructorFullName varchar(512) Yes  
CourseInstructorPersonID int Yes  
CourseGradeLow int Yes  
CourseGradeHigh int Yes  
CourseAgeLow int Yes  
CourseAgeHigh int Yes  
CourseYearAtCamp int Yes  
CourseGender varchar(40) Yes  
CourseAllowDuplicateRegistration varchar(1) Yes  
CourseValidateStoredProcedure varchar(1) Yes Future use.
CourseRank varchar(128) Yes  
SubCampID int Yes  
SubCampCode varchar(40) Yes  
SubCampName varchar(256) Yes  
SubCampDesc varchar(256) Yes  
CampsiteID int Yes  
CampsiteCode varchar(40) Yes  
CampsiteName varchar(256) Yes  
CampsiteDesc varchar(256) Yes  
LocationID int Yes  
LocationCode varchar(40) Yes  
LocationName varchar(256) Yes  
LocationDesc varchar(256) Yes  
AreaID int Yes  
AreaCode varchar(40) Yes  
AreaName varchar(256) Yes  
AreaDesc varchar(256) Yes  
CourseCompletionSummaryID int Yes  
SummaryCompletionStatus varchar(128) Yes  
CourseCompletionSummaryComments varchar(1024) Yes  
RegistrationID int Yes  
RegistrationRegisterNumber int Yes  
RegistrationGroupID int Yes  
RegistrationActiveFlag varchar(1) Yes  
RegistrationCreationDate datetime Yes  
RegistrationCreatedBy nvarchar(256) Yes  
RegistrationLastUpdateDate datetime Yes  
RegistrationLastUpdatedBy nvarchar(256) Yes  
CreationDate datetime No  
CreatedBy nvarchar(256) No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No