Lookup Tables

Edit these tables (be careful) from the Admin/Lookup menu.

  • Note: You must have the Admin role to use this functionality.
  • Note: You must clear the cache before any changes made here will be active.
AddressType  
AttendanceClassification  
AttendTrackLevel  
AttendType Hardwired
BaptismStatus required: NotScheduled, Completed, Canceled
BaptismType required: NotSpecified, Original, Subsequent, Biological, NonMember, Required
BundleHeaderTypes  
BundleStatusTypes  
Campus Campus Id (see wiki article)
ContactPreference not used
ContributionStatus hardwired
ContributionType hardwired
CountryLookup* non-standard columns
DecisionType required: Unknown, ProfessionForMembership, ProfessionNotForMembership, Letter, Statement, StatementReqBaptism, Cancelled
DiscoveryClassStatus required: NotSpecified, Pending, Attended, AdminApproval, Grandfathered, ExemptedChild
DropType required: Duplicate, Administrative, Deceased, LetteredOut, Requested, AnotherDenomination, Other
EntryPoint see wiki article
EnvelopeOption required: None, Individual, Joint
FamilyMemberType  
FamilyPosition  
FamilyRelationship  
Gender  
GenderClass  
InterestPoint  
JoinType required: BaptismPOF, BaptismSRB, BaptismBIO, Statement, Letter
MaritalStatus required: Unknown, Single, Married, Widowed
MeetingType  
MemberLetterStatus  
MemberStatus required: Member, NotMember, Pending, Previous, JustAdded
MemberType

Some hardwired, Required: Member, Teacher, Drop, Inactive, Visitor, InServiceMember, VIP

NameSuffix  
NameTitle  
NewContactReason other is required (160)
NewContactType other is required (7)
OrganizationStatus Active is required(30)
Origin required: Visit, PhoneIn, SurveyEE, Enrollment, NewFamilyMember - see wiki article
PhonePreference  
PostalLookup *  
ResidentCode  
ShirtSizes For recreation registration
StateLookup *  
TaskStatus required: Active, Complete, Pending, Someday,
VolApplicationStatus  
VolunteerCodes  
WeeklySchedule *  

* These do not work yet