Home rent payments

Rent Payment Review

rent_payments Table Structure

Column Data Type Description
lease_id number foreign key to leases
payment_month date month of rent payment (yyyy-mm)
amount_due number amount of rent due
amount_paid number amount of rent paid
payment_status text categorical status of rent payment

rent_payment Data Profiling

1. Row Level Checks

Total number of rent_payment records

  • 2,804 total rent_payment records.

Null / Blanks summary
1
2
3
4
5
No Results

2. Primary Key Uniqueness Validation

Uniqueness of primary key

  • Composite primary key made up of columns lease_id, payment_month, payment_status
No Results

Discrepancies with payment_status preventing uniqueness of primary key

  • Upper/Lower casing of payment_status values creating duplicate records

3. Foreign key integrity checks

lease_id check against leases.csv
1
2
3
4
5
6
7
8
9
10
No Results

lease_id's in leases table

100%

Data Consistency Checks

4. Date Field Validation

Earliest & Latest date values

payment_month

Earliest payment_month

2018-03

Latest payment_month

2024-12

Check for future payment_months

0 rent_payment records with future payment_month

Earliest & Latest payment_month for each lease_id
1
2
3
4
5
6
7
8
9
10
No Results

5. Numeric Field Validation
1
2
No Results

amount_due

Loading...

amount_paid

Loading...
Loading...

6. Text Field Profiling
1
No Results
1
2
3
4
5
6
7
8
9
No Results

payment_status has upper/lower casing discrepancies
No Results

Business Logic & Reasonableness Check

7. Logical Checks

Logical Duplicates

62 lease_id's with duplicate records
1
2
3
4
5
6
7
8
9
10
No Results

Record window: 10

1 50

lease_id=2 deeper dive

Viewing (up to) 10 records before & after duplicate entry
1
2
3
4
5
6
7
8
9
10
11
12
13
14
No Results

payment_month before lease_start_date or after lease_end_date

There are:

  • 0 rent_payment records with *payment_month* **before** *lease_start_date*
  • 0 rent_payment records with *payment_month* **after** *lease_end_date*

Check if amount_due matches leases monthlyRent

All amount_due numbers in rent_payments match monthlyRent from leases

8. Reasonableness Checks

payment_status follows amount_paid vs. amount_due
No Results
No Results

rent_payment record exists for each month of active lease_id
1
2
3
4
5
6
7
8
9
10
No Results
No Results