Published using Google Docs
Oraculi Data Dictionary | Loci module
Updated automatically every 5 minutes

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