Maintaining community setup data

Some aspects of the Community function can be set up to suit your organisation's needs.

Lookup tables

Lookup table	More information	See
luAddressRegion	Used to maintain user-defined regions used to define portal sort districts.	luAddressRegion lookup table
luCitizenshipStatus	List possible citizenship statuses for selection on the Community Maintenance - International tab.	luCitizenshipStatus lookup table
luCommunityAttributes	Used to maintain community member attributes at your organisation.	luCommunityAttributes lookup table
luCommunityCheckStatus	Used to maintain statuses for checks required by your organisation.	luCommunityCheckStatus lookup table
luCommunityCheckType	Used to maintain types of checks required by your organisation.	luCommunityCheckType lookup table
luCommunityDedupMergeIgnore	Used to maintain database tables excluded from the Community De-Duplicaiton merge process.	luCommunityDedupMergeIgnore lookup table
luConstituency	Used to maintain constituencies at your organisation.	luConstituency lookup table
luDietaryRequirement	List common dietary requirements for selection in the Community Maintenance - Other tab.	luDietaryRequirement lookup table
luGivenName	Used to define given names at your organisation.	luGivenName lookup table
luIndustry	Used to define the types of industries where community members at your organisation work.	luIndustry lookup table
luNationality	Used to define the nationalities of community members at your organisation.	luNationality lookup table
luNonNational-Qualification	Used to define qualifications obtained at a country other than the home country of your organisation.	luNonNationalQualification lookup table
luOccupation	Used to define common occupations for selection on the Community Maintenance - Occupation tab.	luOccupation lookup table
luOccupation-Position	Used to define types of positions held by community and staff members for a given occupation.	luOccupationPosition lookup table
luParish	Used to define possible parishes that community members may be members of.	luParish lookup table
luPermResStatus	Used to define permanent residency statuses at your organisation.	luPermResStatus lookup table
luQualification	Used to define qualifications held by community and staff members at your organisation.	luQualification lookup table
luQualificationLevel	Used to define levels of qualifications.	luQualificationLevel lookup table
luRelationship	List possible relationships between community members, used on the Relations tab of Community Maintenance.	luRelationship lookup table
luReligion	Used to define a list of religions as used on the Other tab of Community Maintenance.	luReligion lookup table
luSkill	Used to define extra skills possessed by staff members at your organisation.	luSkill lookup table
luSkillLevel	Used to define skill levels that indicate the competency of community members for a certain skill or activity.	luSkillLevel lookup table
luStudentSafetyActivityStatus	Used to define the status of student involvement activities.	luStudentSafetyActivityStatus lookup table
luStudentSafetyActivityType	Used to define types of interactions between community members and students.	luStudentSafetyActivityType lookup table
luStudentSafetyInteractionType	Used to define types of interactions between community members and students.	luStudentSafetyInteractionType lookup table
luTitle	Used to define the titles that prefix community members names, commonly known as honorifics.	luTitle lookup table
luVisa	Used to maintain the classes of visas that are available at your organisation.	luVisa lookup table
luVisaConditions	Used to maintain the types of visa conditions available for visa holders at your organisation.	luVisaConditions lookup table
luVISASubclasses	Used to maintain visa subclasses at your organisation.	luVISASubclasses lookup table

Configuration settings
See Maintaining configuration files.

Configuration setting	More information	See
AllowInsertFrom-ExternalSource-Flag	Determine whether new rows from an external source can be inserted into the luTitle lookup table.	AllowInsertFromExternalSourceFlag configuration setting
AllowManualEdit	Control whether or not users can edit the Latitude and Longitude coordinates of the following tabs of the Community Maintenance window: Home Address tab Company Address tab.	AllowManualEdit configuration setting
IncludeOccup-Desc	Control whether the Include Description in: Occupation Address flag is automatically selected when creating new a community member.	IncludeOccupDesc configuration setting
CitizenshipStatus	Used to define the default citizenship or residency status of community members for the CEOVIC data export.	CitizenshipStatus configuration setting
CustomIcon	Create custom icons to display important information at all times on maintenance screens.	Maintaining custom maintenance window icons
Community: NetworkLogin	Define a select statement to create network logins.	Community:NetworkLogin configuration setting
HomeLanguage-Code	Define the default home language for new community members.	HomeLanguageCode configuration setting
MailFmt	Used to determine the default formats of the mailing names used at your organisation: Mail Name Primary Mail Name Joint Mail Salutation Primary Mail Salutation Joint.	MailFmt configuration setting
MailFmtBias	Determine the bias to use when generating combined mail name for community members who are a couple.	MailFmtBias configuration setting
NetworkLogin: ForceUnique-Check	Control whether newly created network logins are checked for uniqueness.	NetworkLogin:ForceUniqueCheck configuration setting
Community: OccupEmail	Define a select statement to create email addresses.	Community:OccupEmail configuration setting
OccupEmail: ForceUnique-Check	Control whether newly created email addresses are checked for uniqueness.	OccupEmail:ForceUniqueCheck configuration setting