Oraculi Data Dictionary | Loci module
id | Name | Data Key | Description | Sample Data |
1 | Loan requests | loan_requests | This is the number of loan requests a borrower has made on a lender's application | 160 |
2 | Gender | gender | This is the number of times that a customer have changed their gender over a period of time. It if its more than 1, this may signify a fraudulent intent. | Female |
3 | Marital Status | marital_status | This is the number of times a borrower has updated their marital status over a period of time. | Single |
4 | Number of Dependents | no_of_dependent | This refers to the number of individuals a borrower is responsible for, and it is used to build a credit score using the scoring model. A frequent update to this number indicates a fraudulent intent | 2 |
5 | Type of Residence | type_of_residence | This refers to the type of residence a borrower lives in, and it is used to build a credit score using the scoring model. A frequent update to this number indicates a fraudulent intent | Rented apartment |
6 | Educational Attainment | educational_attainment | This refers to the different educational attainment by the borrower, and it is used to build a credit score using the scoring model. A frequent update to this number indicates a fraudulent intent | Masters and above |
7 | Employment Status | employment_status | This refers to the borrower's current employment status and it is used to build a credit score using the scoring model. A frequent update to this can indicate a fraudulent intent | Employed |
8 | Sector of Employment | sector_of_employment | This refers to the sector of employment a borrower works in and it is used to build a credit score using the scoring model. A frequent update to this can indicate a fraudulent intent | Private |
9 | Monthly net income | monthly_net_income | This refers to the income range earned by the borrower and it is used to build a credit score using the scoring model. A frequent update to this can indicate a fraudulent intent | 200,000 - 399,000 |
10 | Work Email | work_email | This is the official work email of the borrower and it is usually verified in the event that the lender requires a work email. Unless the work email has been validated by the borrower, the loan status remains 'Pending". | someone@lendsqr.com |
11 | Purpose | purpose | This is the reason for stated by the borrower for taking the loan | Personal |
12 | Gender 7 day | gender_7_day | This is the number of times a borrower has changed their gender over a period of 7 days. If it is more than the maximum limit in 7 days, it might indicate fraudulent activity | 1 |
13 | Marital Status 7 Day | marital_status_7_day | This is the number of times a borrower has changed their marital status over a period of 7 days. If it is more than the maximum limit in 7 days, it can signify a fraudulent intent | 1 |
14 | Number of Dependents | no_of_dependent_7_day | This is how many times a user has updated how many people they're responsible for within 7 days. If it's more than the allowed number in 7 days, it can signify a fraudulent intent. | 1 |
15 | Type of Residence & Day | type_of_residence_7_day | This is the number of times a borrower has changed their place of residence over a period of 7 days. If it is more than the maximum limit in 7 days, this may signify a fraudulent intent. | 1 |
16 | Educational Attainment 7 Day | educational_attainment_7_day | This is the number of times a borrower has changed their educational attainment over a period of 7 days. If it's more than the maximum limit in 7 days, this may signify a fraudulent intent. | 1 |
17 | Employment Status 7 day | employment_status_7_day | This is the number of times a borrower has changed their employment status over a period of 7 days. If it is more than the maximum limit in 7 days, it can signify a fraudulent intent. | 1 |
18 | Sector of Employment 7 Day | sector_of_employment_7_day | This is the number of times a borrower has changed their sector of employment over a period of 7 days. If it is more than the maximum limit in 7 days, it can signify a fraudulent intent. | 1 |
19 | Monthly Income 7 Day | monthly_net_income_7_day | This tells us how many times a user has updated their monthly net income within 7 days. If it exceeds the highest allowed number in 7 days, it can signify a fraudulent intent. | 1 |
20 | Loan Requests Last 1 hour | loan_requests_last_1_hour | This is the total number of allowable loan requests that can be made by a borrower within an hour. | 2 |
21 | Loan Requests Last 5 hours | loan_requests_last_5_hour | This is the total number of allowable loan requests that can be made by a borrower within 5 hours. | 1 |
22 | Loan Requests Last 10 Hour | loan_requests_last_10_hour | This is the total number of allowable loan requests that can be made by a borrower within 10 hours. | 1 |
23 | Loan Requests Last 24 Hour | loan_requests_last_24_hour | This is the total number of allowable loan requests that can be made by a borrower within 24 hours. | 5 |
24 | Loan Requests Last 7 Day | loan_requests_last_7_day | This is the total number of allowable loan requests that can be made by a borrower within 7 days. | 7 |
25 | Loan Requests Last 30 Day | loan_requests_last_30_day | This is the total number of allowable loan requests that can be made by a borrower within 30 days. | 10 |
26 | Loan Requests Last 90 Day | loan_requests_last_90_day | This is the total number of allowable loan requests that can be made by a borrower within 90 days. | 20 |
27 | Loan Requests 180 Day | loan_requests_last_180_day | This is the total number of allowable loan requests that can be made by a borrower within 180 days. | 30 |
28 | Loan Requests Last 360 Day | loan_requests_last_360_day | This is the total number of allowable loan requests that can be made by a borrower within 360 days. | 46 |
29 | Loan Requests Failed 1 Hour | loan_requests_failed_1_hour | This is the allowable number of times a loan request can be failed within 1 hour. A borrower's failed loan request reason can be checked using the decision data. | 0 |
30 | Loan Requests Failed 24 Hours | loan_requests_failed_24_hour | This is the allowable number of times a loan request can be failed within 1 hour. A borrower's failed loan request reason can be checked using the decision data. | 0 |
31 | Failed Credit Bureau 24 hour | failed_credit_bureau_24_hour | The total number of times the loan requests have failed the dredit bureau checks in the last 24 hours. | 0 |
32 | Failed Credit Bureau 30 Day | failed_credit_bureau_30_day | The total number of times the loan requests have failed the dredit bureau checks within the last 30 days. | 0 |
33 | Used Credit Bureau 30 days | used_credit_bureau_30_day >= 1 | The total number of time credit bureau has been checked for a borrower in the past 30 days | 1 |
34 | Passed Credit Bureau 30 Day | passed_credit_bureau_30_day >= 1 | The total number of times a borrower passed the credit bureau check in the past 30 days. If the borrower passed the check, the credit bureau data isn't checked anymore | 1 |
35 | Work Email Domain | work_email_domain | This is the work email domain of a borrower which is gotten from the work email address. The work email domain is specified after the "@" symbol in the work email address. | example.com |
36 | State | state | This is the state that the borrower is based in. | Lagos |
37 | Loans | loans | This is the total number of loans that a customer has taken from the borrower | 64 |
38 | Loans Canceled | loans_canceled | This is the number of canceled loans by a borrower. | 23 |
39 | Loans Declined | loans_declined | This is the total number of loans declined by an admin. | 11 |
40 | loan_declined_1_hour | This is the allowable number of declined loans within the last 1 hour by an admin that a borrower has before they can reapply for a loan | 0 | |
41 | Loan Declined 24 Hour | loan_declined_24_hour | This is the allowable number of declined loans within the last 24 hours by an admin that a borrower has before they can reapply for a loan | 0 |
42 | Loans Declined 7 days | loan_declined_7_day | This is the allowable number of declined loans within the last 7 days by an admin that a borrower has before they can reapply for a loan | 0 |
43 | Loans Declined 30 days | loan_declined_30_day | This is the allowable number of declined loans within the last 30 days by an admin that a borrower has before they can reapply for a loan | 1 |
44 | Loans Approved | loans_approved | This is the total number of loans approved by an admin for a borrower | 10 |
45 | loans_approved_amount | This is the total amount of loans approved by an admin for a borrower | 200,000.00 | |
46 | Loan Approved 1 Day | loan_approved_1_day | This is the allowable number of approved loans within the last 1 day by an admin that a borrower has before they can reapply for a loan | 1 |
47 | Loan Approved 2 Day | loan_approved_2_day | This is the allowable number of approved loans within the last 2 days by an admin that a borrower has before they can reapply for a loan | 1 |
48 | Loan Approved 3 day | loan_approved_3_day | This is the allowable number of approved loans within the last 3 days by an admin that a borrower has before they can reapply for a loan | 1 |
49 | Loan Approved 7 day | loan_approved_7_day | This is the allowable number of approved loans within the last 7 days by an admin that a borrower has before they can reapply for a loan | 2 |
50 | Loan Approved 30 day | loan_approved_30_day | This is the allowable number of approved loans within the last 30 days by an admin that a borrower has before they can reapply for a loan | 3 |
51 | Loan Approved 90 Day | loan_approved_90_day | This is the allowable number of approved loans within the last 90 days by an admin that a borrower has before they can reapply for a loan | 5 |
52 | Loan Approved 180 Day | loan_approved_180_day | This is the allowable number of approved loans within the last 180 days by an admin that a borrower has before they can reapply for a loan | 9 |
53 | Loan Approved 360 Day | loan_approved_360_day | This is the allowable number of approved loans within the last 360 days by an admin that a borrower has before they can reapply for a loan | 10 |
54 | Loans running | loans_running | This is the total number of loans that are still running at a particular point in time. Running loans are active loans that are not overdue. | 1 |
55 | Loans Settled | loans_settled | This is the total number of loans settled by a borrower | 10 |
56 | Loans Settled Amount | loans_settled_amount | This is the total amount of loans that have been settled by a borrower. | 673,507.85 |
57 | Cards | cards | This is the unique bank debit card of a borrower, linked to the borrower's bank account and BVN | 3 |
58 | Card Mastercard | card_mastercard | This shows the type of card added by the borrower | 4 |
59 | Card Verve | card_verve | This shows the type of card added by the borrower | 0 |
60 | Card Visa | card_visa | This shows the type of card added by the borrower | 1 |
61 | Transactions | transactions | Total number of transactions performed by a user. | 167 |
62 | Amount | amount | This refers to the value of a transaction. | 6,458,001.85 |
63 | Credit Transaction | credit_transactions | This is the number of credit transactions on the card added by the borrower. | 93 |
64 | Credit Transaction Amount | credit_transaction_amount | This is the total amount of credit transactions on the card added by the borrower. | 2,943,111.44 |
65 | Debit Transactions | debit_transactions | This is the number of debit transactions on the cards added by the borrower. | 74 |
66 | Debit Transaction Amount | debit_transaction_amount | The total sum of debit transactions performed by a user. | 3,514,890.41 |
67 | Loan Payments | loan_payments | This is the total number of loan payments that have been made by the borrower. | 53 |
68 | Loan Payments Sucessful | loan_payments_successful | This is the total number of loan payments by the borrower that have been successful. | 49 |
69 | Loan Amount Successful | loan_amount_successful | This is the monetary value of all successful loan payments that have been made by the borrower. | 724,507.85 |
70 | Loan Payments Failed | loan_payments_failed | This is the total number of failed loan payment transactions by the borrower. | 4 |
71 | Loan Amount Failed | loan_amount_failed | This is the total sum of all failed loan payments that have been made by a user. | 570,969 |
72 | Apple Device | apple_device | This is the total number of apple devices the user has used to sign into the account. | 0 |
73 | Android Device | android_device | This is the total number of android devices the user has used to sign into the account. | 1 |
74 | Documents Uploaded | documents_uploaded | This is the total number of documents that have been added by the borrower. | 3 |
75 | Documents Pending | documents_pending | This is the number of documents added by a borrower pending approval from an admin. | 0 |
76 | Documents Approved | documents_approved | This is the number of documents added by a user that have been approved by an admin. | 2 |
77 | Documents Rejected | documents_rejected | This is the number of documents added by a user that have been rejected by an admin. | 1 |
78 | Documents Pending or Approved | documents_pending_or_approved | This is the total number of documents added by a borrower pending approval from an admin or already approved by an admin. | Pending |
79 | Device Name | device_name | This is the name of the device a borrower used to sign in. | K |
80 | Disallowed Device | disallowed_device | This is the total number of devices disallowed from accessing a borrower's account. | 0 |
81 | Tier Id | tier_id | Unique Id allocated to a tier | 4 |
82 | Tier | tier | This indicates the level or grade of a customer within the application. | Tier 2 |
83 | Selfie BVN Check | selfie_bvn_check | This indicates if the selfie uploaded by the borrower matches the selfies associated with the BVN of the borrower. | 1 |
84 | Selfie ID Check | selfie_id_check | This shows if the uploaded selfie image matches the image on the borrower's ID. | 0 |
85 | Staff Profiles | staff_profiles | This is an indicator to verify if a borrower is a staff or has an existing staff profile in the organization they added during onboarding. | 1 |
86 | Current Hour | current_hour | This tells the current hour of the day | 16 |
87 | Current Day | current_day | This tells the current day | 6 |