By Category

Analyses membership by member category, for example individual, group, junior, corporate or staff classes. It shows the product and segment mix of the membership and helps tailor products and pricing per category.

By Category
By Category — live screen from the BridgeERP MFI Suite.

Workflow

  1. Go to Analytics then By Category
  2. Review counts and shares per member category
  3. Toggle pivot or graph to explore the mix
  4. Drill into a category to inspect its members
  5. Export for product and segmentation planning

Fields reference

Every field on this screen, drawn from the live data model.

FieldTypeRequiredDescription
Portal Access URL
access_url
TextCustomer Portal URL
Legacy Member No
legacy_member_no
TextPrevious system member number
Huduma Namba
huduma_number
TextKenyan Huduma Namba (10-digit national ID aggregator).
IPRS Verified
iprs_verified
Yes/NoTrue when Kenyan IPRS (Integrated Population Registration Service) has confirmed identity.
Member Type
member_type
Choice: Individual, Group Representative, Corporate/Institution, Joint AccountYesMember Type
First Name
first_name
TextYesFirst Name
Last Name
last_name
TextYesLast Name
Gender
gender
Choice: Male, Female, OtherYesGender
Date of Birth
date_of_birth
DateYesDate of Birth
Primary ID Type
id_type
Choice: National ID, Passport, Driving License, Voter ID, Military ID, Refugee ID, Alien ID, Birth CertificateYesPrimary ID Type
ID Number
id_number
TextYesID Number
Mobile Phone
mobile
TextYesMobile Phone
Access warning
access_warning
Long textAccess warning
Has Message
has_message
Yes/NoHas Message
Member Number
member_no
TextMember Number
Title
title
Choice: Mr., Mrs., Ms., Miss, Dr., Prof., Hon., Rev.Title
Middle Name
middle_name
TextMiddle Name
Maiden Name
maiden_name
TextMaiden Name
Full Name
full_name
TextFull Name
Age
age
NumberAge
Age Group
age_group
Choice: Youth (18-35), Adult (36-55), Senior (56+)Age Group
Marital Status
marital_status
Choice: Single, Married, Divorced, Widowed, SeparatedMarital Status
Spouse Name
spouse_name
TextSpouse Name
Spouse Phone
spouse_phone
TextSpouse Phone
Spouse Occupation
spouse_occupation
TextSpouse Occupation
Number of Dependents
number_of_dependents
NumberNumber of Dependents
Nationality
nationality_id
Link → res.countryNationality
Country of Birth
country_of_birth_id
Link → res.countryCountry of Birth
Place of Birth
place_of_birth
TextPlace of Birth
Education Level
education_level
Choice: No Formal Education, Primary, Secondary, Diploma, Bachelor's Degree, Master's Degree, Doctorate, OtherEducation Level
Religion
religion
TextReligion
Ethnicity
ethnicity
TextEthnicity
Photo Capture Date
photo_capture_date
DatePhoto Capture Date
Photo Latitude
photo_latitude
DecimalPhoto Latitude
Photo Longitude
photo_longitude
DecimalPhoto Longitude
Fingerprint Enrolled
fingerprint_enrolled
Yes/NoFingerprint Enrolled
ID Issue Date
id_issue_date
DateID Issue Date
ID Expiry Date
id_expiry_date
DateID Expiry Date
Place of Issue
id_issue_place
TextPlace of Issue
Issuing Authority
id_issue_authority
TextIssuing Authority
Secondary ID Type
secondary_id_type
Choice: National ID, Passport, Driving License, Voter ID, OtherSecondary ID Type
Secondary ID Number
secondary_id_number
TextSecondary ID Number
Tax ID / KRA PIN
tax_id
TextTax ID / KRA PIN
Business Registration No
business_registration_no
TextBusiness Registration No
IPRS Verified On
iprs_verified_date
Date & timeIPRS Verified On

Actions & buttons

Buttons available on this screen and what they do:

  • Submit
  • Approve
  • Reject
  • Activate
  • Affirm KYC
  • Re-Affirm KYC
  • Suspend
  • Mark Dormant
  • Reactivate
  • Blacklist
  • Exit Member
  • Calculate Credit Score
  • Verify IPRS
  • Pull CRB Report

Status lifecycle

Records on this screen move through these statuses:

Application → Pending Approval → Approved → Active → Dormant → Suspended → Blacklisted → Exited → Deceased → Rejected

Notes & rules

  • Model mfi.member grouped by category
  • Categories defined in Configuration
  • Pivot and graph views
  • Informs product/segment strategy

Technical model: mfi.member · Record: MFI Member

Was this page helpful?