By Branch

A pivot and graph analysis of membership distribution across branches. Managers use it to compare branch sizes, spot under- or over-served locations and allocate resources, drilling into any branch's member base.

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

Workflow

  1. Go to Analytics then By Branch
  2. Read the membership counts per branch
  3. Switch between pivot and graph for the cut you need
  4. Drill into a branch to see its members
  5. Export the view for management reporting

Fields reference

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

FieldTypeRequiredDescription
Portal Access URL
access_url
Text—Customer Portal URL
Legacy Member No
legacy_member_no
Text—Previous system member number
Huduma Namba
huduma_number
Text—Kenyan Huduma Namba (10-digit national ID aggregator).
IPRS Verified
iprs_verified
Yes/No—True 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 text—Access warning
Has Message
has_message
Yes/No—Has Message
Member Number
member_no
Text—Member Number
Title
title
Choice: Mr., Mrs., Ms., Miss, Dr., Prof., Hon., Rev.—Title
Middle Name
middle_name
Text—Middle Name
Maiden Name
maiden_name
Text—Maiden Name
Full Name
full_name
Text—Full Name
Age
age
Number—Age
Age Group
age_group
Choice: Youth (18-35), Adult (36-55), Senior (56+)—Age Group
Marital Status
marital_status
Choice: Single, Married, Divorced, Widowed, Separated—Marital Status
Spouse Name
spouse_name
Text—Spouse Name
Spouse Phone
spouse_phone
Text—Spouse Phone
Spouse Occupation
spouse_occupation
Text—Spouse Occupation
Number of Dependents
number_of_dependents
Number—Number of Dependents
Nationality
nationality_id
Link → res.country—Nationality
Country of Birth
country_of_birth_id
Link → res.country—Country of Birth
Place of Birth
place_of_birth
Text—Place of Birth
Education Level
education_level
Choice: No Formal Education, Primary, Secondary, Diploma, Bachelor's Degree, Master's Degree, Doctorate, Other—Education Level
Religion
religion
Text—Religion
Ethnicity
ethnicity
Text—Ethnicity
Photo Capture Date
photo_capture_date
Date—Photo Capture Date
Photo Latitude
photo_latitude
Decimal—Photo Latitude
Photo Longitude
photo_longitude
Decimal—Photo Longitude
Fingerprint Enrolled
fingerprint_enrolled
Yes/No—Fingerprint Enrolled
ID Issue Date
id_issue_date
Date—ID Issue Date
ID Expiry Date
id_expiry_date
Date—ID Expiry Date
Place of Issue
id_issue_place
Text—Place of Issue
Issuing Authority
id_issue_authority
Text—Issuing Authority
Secondary ID Type
secondary_id_type
Choice: National ID, Passport, Driving License, Voter ID, Other—Secondary ID Type
Secondary ID Number
secondary_id_number
Text—Secondary ID Number
Tax ID / KRA PIN
tax_id
Text—Tax ID / KRA PIN
Business Registration No
business_registration_no
Text—Business Registration No
IPRS Verified On
iprs_verified_date
Date & time—IPRS 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 branch
  • Pivot and graph views
  • Branch-comparison and resourcing
  • Drill-through to member records

Technical model: mfi.member · Record: MFI Member

Was this page helpful?