# | Data element | Description |
1 | org_id | Unique id for the lender within Lendsqr |
2 | organization | Name of the lender |
3 | id | Unique id of the user |
4 | first_name | First name of the user. This is gotten from their BVN |
5 | last_name | Last name of the user. This is gotten from their BVN |
6 | full_name | Full name of the user which is a concatenation of the first and last name |
7 | phone_number | Phone number the user signed up with |
8 | phone_number_hash | Unique hash generated by Lendsqr for the phone number |
9 | Email the user signed up with | |
10 | bvn | Bank Verification Number of the user. This has been verified |
11 | bvn_phone_number | Phone number of the user as specified on the BVN. This may be different from the phone signed up with |
12 | date_of_birth | Date of birth of the user. This is gotten from their BVN |
13 | age | Age of the user. Computed from the date of birth |
14 | gender | Gender of the user. This is gotten from their BVN |
19 | account_balance | The account balance of the user as of the previous night. This is computed by 3:20am each morning |
21 | referral_code | Unique referral code of the user. This is automatically generated by Lendsqr |
23 | referrer_name | The full name of the user who referred the user, if the user was referred |
24 | referrer_email | Email of the referee |
25 | referrer_phone | Phone of the referee |
26 | referrer_code | The referral code of the referee |
29 | device_type | Type of device the user uses. Gotten from the last device they logged in with |
30 | tier_id | Tier ID of the user |
31 | tier | Tier name of the user |
32 | withdrawal_limit | The maximum amount the user can withdraw |
33 | deposit_limit | The maximum amount the user can deposit |
34 | borrower_max_cumulative_amount | The maximum cumulative amount the user can borrowe |
36 | loan_count | Number of loans the user has taken succcessfully |
37 | savings_plans | Number of savings plans the user has previously created |
38 | savings_target | The current sum of the savings target |
39 | savings_balance | The current balance of the savings plans |
40 | activated | Flag to denote if the user is activated or not |
41 | activated_on | The time the user was activated |
42 | blacklisted | Flag to denote if the user is blacklisted or not |
43 | reason | Description of reasons for deactivation or blacklisting |
44 | selfie_bvn_check | Status of AI comparison of selfie image against BVN image. Values can be successful, failed, pending |
45 | selfie_id_check | Status of AI comparison of selfie image against ID document image. Values can be successful, failed, pending |
46 | last_login_date | Time of last login |
47 | created_on | Time the user was created |
48 | modified_on | Time the user was last created |
49 | nok_first_name | First name of next of kin |
50 | nok_last_name | Last name of next of kin |
51 | nok_phone_number | Mobile phone number of next of kin |
52 | nok_email | Email of next of kin |
53 | nok_address | Address of next of kin |
54 | nok_relationship | Relationship with next of kin |
55 | marital_status | Marital status of user. This is gotten from information submitted for their last successful loan request |
56 | no_of_dependent | Number of dependents of user. This is gotten from information submitted for their last successful loan request |
57 | type_of_residence | Type of residence. This is gotten from information submitted for their last successful loan request |
58 | educational_attainment | Highest level of education of user. This is gotten from information submitted for their last successful loan request |
59 | employment_status | Current employment status. This is gotten from information submitted for their last successful loan request |
60 | sector_of_employment | Sector of employment of user. This is gotten from information submitted for their last successful loan request |
61 | current_employer | The name of their current employer. This is gotten from information submitted for their last successful loan request |
62 | employment_category | The employment category of their current employer. This is gotten from information submitted for their last successful loan request |
63 | monthly_net_income | Current month net income. This is a range. This is gotten from information submitted for their last successful loan request |
64 | work_start_date | The date the current job was started, if any. This is gotten from information submitted for their last successful loan request |
65 | work_email | Official email address of the user. This is gotten from information submitted for their last successful loan request |
66 | country | The country from which the last loan was requested. This is gotten from information submitted for their last successful loan request |
67 | city | The city from which the last loan was requested. This is gotten from information submitted for their last successful loan request |
71 | longitude | The longitude of where the user made the last loan request |
72 | latitude | The latitude of where the user made the last loan request |
73 | address | The address of the user. This is gotten from information submitted for their last successful loan request |
74 | process_time | The time this data was prepared by the Lendsqr system |
Users Print
Modified on: Thu, 25 Aug, 2022 at 6:41 AM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.