#Data elementDescription
1org_idUnique id for the lender within Lendsqr
2organizationName of the lender
3idUnique id of the user
4first_nameFirst name of the user. This is gotten from their BVN
5last_nameLast name of the user. This is gotten from their BVN
6full_nameFull name of the user which is a concatenation of the first and last name
7phone_numberPhone number the user signed up with
8phone_number_hashUnique hash generated by Lendsqr for the phone number
9emailEmail the user signed up with
10bvnBank Verification Number of the user. This has been verified
11bvn_phone_numberPhone number of the user as specified on the BVN. This may be different from the phone signed up with
12date_of_birthDate of birth of the user. This is gotten from their BVN
13ageAge of the user. Computed from the date of birth
14genderGender of the user. This is gotten from their BVN
19account_balanceThe account balance of the user as of the previous night. This is computed by 3:20am each morning
21referral_codeUnique referral code of the user. This is automatically generated by Lendsqr
23referrer_nameThe full name of the user who referred the user, if the user was referred
24referrer_emailEmail of the referee
25referrer_phonePhone of the referee
26referrer_codeThe referral code of the referee
29device_typeType of device the user uses. Gotten from the last device they logged in with
30tier_idTier ID of the user
31tierTier name of the user
32withdrawal_limitThe maximum amount the user can withdraw
33deposit_limitThe maximum amount the user can deposit
34borrower_max_cumulative_amountThe maximum cumulative amount the user can borrowe
36loan_countNumber of loans the user has taken succcessfully
37savings_plansNumber of savings plans the user has previously created
38savings_targetThe current sum of the savings target
39savings_balanceThe current balance of the savings plans
40activatedFlag to denote if the user is activated or not
41activated_onThe time the user was activated
42blacklistedFlag to denote if the user is blacklisted or not
43reasonDescription of reasons for deactivation or blacklisting
44selfie_bvn_checkStatus of AI comparison of selfie image against BVN image. Values can be successful, failed, pending
45selfie_id_checkStatus of AI comparison of selfie image against ID document image. Values can be successful, failed, pending
46last_login_dateTime of last login
47created_onTime the user was created
48modified_onTime the user was last created
49nok_first_nameFirst name of next of kin
50nok_last_nameLast name of next of kin
51nok_phone_numberMobile phone number of next of kin
52nok_emailEmail of next of kin
53nok_addressAddress of next of kin
54nok_relationshipRelationship with next of kin
55marital_statusMarital status of user. This is gotten from information submitted for their last successful loan request
56no_of_dependentNumber of dependents of user. This is gotten from information submitted for their last successful loan request
57type_of_residenceType of residence. This is gotten from information submitted for their last successful loan request
58educational_attainmentHighest level of education of user. This is gotten from information submitted for their last successful loan request
59employment_statusCurrent employment status. This is gotten from information submitted for their last successful loan request
60sector_of_employmentSector of employment of user. This is gotten from information submitted for their last successful loan request
61current_employerThe name of their current employer. This is gotten from information submitted for their last successful loan request
62employment_categoryThe employment category of their current employer. This is gotten from information submitted for their last successful loan request
63monthly_net_incomeCurrent month net income. This is a range. This is gotten from information submitted for their last successful loan request
64work_start_dateThe date the current job was started, if any. This is gotten from information submitted for their last successful loan request
65work_emailOfficial email address of the user. This is gotten from information submitted for their last successful loan request
66countryThe country from which the last loan was requested. This is gotten from information submitted for their last successful loan request
67cityThe city from which the last loan was requested. This is gotten from information submitted for their last successful loan request
71longitudeThe longitude of where the user made the last loan request
72latitudeThe latitude of where the user made the last loan request
73addressThe address of the user. This is gotten from information submitted for their last successful loan request
74process_timeThe time this data was prepared by the Lendsqr system