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

luCommunityDedupMergeIgnoreUsed 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

luGivenNameUsed 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

luPermResStatusUsed 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

luStudentSafetyActivityStatusUsed to define the status of student involvement activities.luStudentSafetyActivityStatus lookup table
luStudentSafetyActivityTypeUsed 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