Person Table

Column Name Type Allows Nulls Notes
PersonID int No  
PersonNo varchar(40) Yes  
UserName nvarchar(256) Yes  
OrganizationID int Yes No Longer Used
FirstName varchar(128) No  
LastName varchar(128) No  
MiddleName varchar(128) Yes  
PersonSuffix varchar(8) Yes  
PersonPrefix varchar(8) Yes  
FullName varchar(512) Yes  
Birthdate datetime Yes  
Gender varchar(2) Yes  
PrimaryPhoneNumber varchar(48) Yes  
SecondaryPhoneNumber varchar(48) Yes  
PrimaryPhoneNumberType varchar(128) Yes  
SecondaryPhoneNumberType varchar(128) Yes  
PrimaryEmail varchar(256) Yes  
SecondaryEmail varchar(256) Yes  
EmergencyContactName varchar(256) Yes  
EmergencyContactPhone varchar(50) Yes  
EmergencyContactEmail varchar(256) Yes  
EmergencyContactRelationship varchar(48) Yes  
DefaultCampPeriodNo varchar(48) Yes No Longer Used
DefaultUnitID int Yes No Longer Used
LegacyPersonIdentifier varchar(48) 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  
StartDate datetime Yes  
EndDate datetime Yes  
ActiveFlag varchar(1) No  
CreationDate datetime No  
CreatedBy nvarchar(256) No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No  
YearAtCamp varchar(128) Yes  
Grade varchar(128) Yes  
UnitLeader varchar(1) Yes  
Instructor varchar(1) Yes  
Rank varchar(128) Yes  
CampStaff varchar(1) Yes  
AllowDelete varchar(1) Yes  
PrimaryMobileCarrier varchar(128) Yes  
SecondaryMobileCarrier varchar(128) Yes  
ReceiveEmailMessages varchar(1) Yes  
ReceiveTextMessages varchar(1) Yes  
PrimaryEmailVerified varchar(1) Yes  
SecondaryEmailVerified varchar(1) Yes  
PrimaryMobileVerified varchar(1) Yes  
SecondaryMobileVerified varchar(1) Yes  
Comments varchar(1024) Yes