Client test_client_qa • Job d516ed9e-52a4-4542-ae93-fa6a4a08142e
Generated at 2026-06-17 09:59:18 UTC
| # | Test ID | Status | Report Type | Start | End | Duration (s) | Quick Validation Summary |
|---|---|---|---|---|---|---|---|
| 1 | ETL_verification | SUCCESS | - | 2026-06-15 06:45:39 UTC | 2026-06-15 06:46:04 UTC | 25 | snapshot_gold_count=74125 | presentation_count=74125 |
| 2 | enrollment_report_all_students | SUCCESS | - | 2026-06-15 06:45:39 UTC | 2026-06-15 06:46:08 UTC | 28 | row_count_match=True | mismatched_rows=0 | matched_rows=3 |
| 3 | enrollment_report_base_population | FAILED | - | 2026-06-15 06:45:39 UTC | 2026-06-15 06:45:44 UTC | 5 | row_count_match=True | mismatched_rows=2 | matched_rows=1 |
| 4 | enrollment_report_test_001 | FAILED | - | 2026-06-15 06:45:39 UTC | 2026-06-15 06:46:06 UTC | 26 | row_count_match=True | mismatched_rows=3 | matched_rows=0 |
{
"test_name": "ETL_verification",
"overall_status": "success",
"client_id": "test_client_qa",
"academic_year": "2026",
"snapshot_date": "20260607",
"bronze_path": "s3://hce-ama-dev/data/bronze/test_client_qa/academic_year=2026/snapshot_date=20260607/data/test_client_qa-2026-20260607.csv",
"counts": {
"bronze_file_count": 74125,
"snapshot_bronze_count": 74125,
"snapshot_silver_count": 74125,
"snapshot_gold_count": 74125,
"presentation_count": 74125
},
"comparisons": {
"snapshot_bronze_count_matches_file": true,
"snapshot_silver_count_matches_file": true,
"snapshot_gold_count_matches_file": true,
"presentation_count_matches_file": true
},
"missing_snapshot_counts": []
}{
"test_name": "snapshot_desc_report",
"validation": {
"overall_status": "success",
"row_count_match": true,
"matched_rows": 3,
"mismatched_rows": 0,
"field_results": [
{
"pbi_row_index": 0,
"redshift_row_index": 0,
"primary_key_values": {
"data[year]": 2024
},
"fields": [
{
"pbi_field": "data[year]",
"redshift_field": "year",
"pbi_value": 2024,
"redshift_value": 2024,
"match": true
},
{
"pbi_field": "[applicants_snapshot]",
"redshift_field": "applicants_snapshot",
"pbi_value": 23712,
"redshift_value": 23712,
"match": true
},
{
"pbi_field": "[applicants_census]",
"redshift_field": "applicants_census",
"pbi_value": 25245,
"redshift_value": 25245,
"match": true
},
{
"pbi_field": "[admitted_students_snapshot]",
"redshift_field": "admitted_students_snapshot",
"pbi_value": 14405,
"redshift_value": 14405,
"match": true
},
{
"pbi_field": "[admitted_students_census]",
"redshift_field": "admitted_students_census",
"pbi_value": 15554,
"redshift_value": 15554,
"match": true
},
{
"pbi_field": "[admit_rate_snapshot]",
"redshift_field": "admit_rate_snapshot",
"pbi_value": 60.75,
"redshift_value": "60.75",
"match": true
},
{
"pbi_field": "[admit_rate_census]",
"redshift_field": "admit_rate_census",
"pbi_value": 61.61,
"redshift_value": "61.61",
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_snapshot]",
"redshift_field": "pct_admits_applying_aid_snapshot",
"pbi_value": 57.02,
"redshift_value": "57.02",
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_census]",
"redshift_field": "pct_admits_applying_aid_census",
"pbi_value": 57.06,
"redshift_value": "57.06",
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_snapshot]",
"redshift_field": "admitted_aid_applicants_snapshot",
"pbi_value": 8214,
"redshift_value": 8214,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_census]",
"redshift_field": "admitted_aid_applicants_census",
"pbi_value": 8875,
"redshift_value": 8875,
"match": true
},
{
"pbi_field": "[deposits_snapshot]",
"redshift_field": "deposits_snapshot",
"pbi_value": 1410,
"redshift_value": 1410,
"match": true
},
{
"pbi_field": "[deposits_census]",
"redshift_field": "deposits_census",
"pbi_value": 1557,
"redshift_value": 1557,
"match": true
},
{
"pbi_field": "[yield_snapshot]",
"redshift_field": "yield_snapshot",
"pbi_value": 9.68,
"redshift_value": "9.68",
"match": true
},
{
"pbi_field": "[yield_census]",
"redshift_field": "yield_census",
"pbi_value": 10.01,
"redshift_value": "10.01",
"match": true
}
],
"row_matched_field_count": 15,
"row_mismatched_field_count": 0,
"row_status": "matched"
},
{
"pbi_row_index": 1,
"redshift_row_index": 1,
"primary_key_values": {
"data[year]": 2025
},
"fields": [
{
"pbi_field": "data[year]",
"redshift_field": "year",
"pbi_value": 2025,
"redshift_value": 2025,
"match": true
},
{
"pbi_field": "[applicants_snapshot]",
"redshift_field": "applicants_snapshot",
"pbi_value": 24283,
"redshift_value": 24283,
"match": true
},
{
"pbi_field": "[applicants_census]",
"redshift_field": "applicants_census",
"pbi_value": 25648,
"redshift_value": 25648,
"match": true
},
{
"pbi_field": "[admitted_students_snapshot]",
"redshift_field": "admitted_students_snapshot",
"pbi_value": 14730,
"redshift_value": 14730,
"match": true
},
{
"pbi_field": "[admitted_students_census]",
"redshift_field": "admitted_students_census",
"pbi_value": 15498,
"redshift_value": 15498,
"match": true
},
{
"pbi_field": "[admit_rate_snapshot]",
"redshift_field": "admit_rate_snapshot",
"pbi_value": 60.66,
"redshift_value": "60.66",
"match": true
},
{
"pbi_field": "[admit_rate_census]",
"redshift_field": "admit_rate_census",
"pbi_value": 60.43,
"redshift_value": "60.43",
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_snapshot]",
"redshift_field": "pct_admits_applying_aid_snapshot",
"pbi_value": 66.65,
"redshift_value": "66.65",
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_census]",
"redshift_field": "pct_admits_applying_aid_census",
"pbi_value": 65.98,
"redshift_value": "65.98",
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_snapshot]",
"redshift_field": "admitted_aid_applicants_snapshot",
"pbi_value": 9817,
"redshift_value": 9817,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_census]",
"redshift_field": "admitted_aid_applicants_census",
"pbi_value": 10226,
"redshift_value": 10226,
"match": true
},
{
"pbi_field": "[deposits_snapshot]",
"redshift_field": "deposits_snapshot",
"pbi_value": 1454,
"redshift_value": 1454,
"match": true
},
{
"pbi_field": "[deposits_census]",
"redshift_field": "deposits_census",
"pbi_value": 1261,
"redshift_value": 1261,
"match": true
},
{
"pbi_field": "[yield_snapshot]",
"redshift_field": "yield_snapshot",
"pbi_value": 8.15,
"redshift_value": "8.15",
"match": true
},
{
"pbi_field": "[yield_census]",
"redshift_field": "yield_census",
"pbi_value": 8.14,
"redshift_value": "8.14",
"match": true
}
],
"row_matched_field_count": 15,
"row_mismatched_field_count": 0,
"row_status": "matched"
},
{
"pbi_row_index": 2,
"redshift_row_index": 2,
"primary_key_values": {
"data[year]": 2026
},
"fields": [
{
"pbi_field": "data[year]",
"redshift_field": "year",
"pbi_value": 2026,
"redshift_value": 2026,
"match": true
},
{
"pbi_field": "[applicants_snapshot]",
"redshift_field": "applicants_snapshot",
"pbi_value": 23232,
"redshift_value": 23232,
"match": true
},
{
"pbi_field": "[applicants_census]",
"redshift_field": "applicants_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[admitted_students_snapshot]",
"redshift_field": "admitted_students_snapshot",
"pbi_value": 15649,
"redshift_value": 15649,
"match": true
},
{
"pbi_field": "[admitted_students_census]",
"redshift_field": "admitted_students_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[admit_rate_snapshot]",
"redshift_field": "admit_rate_snapshot",
"pbi_value": 67.36,
"redshift_value": "67.36",
"match": true
},
{
"pbi_field": "[admit_rate_census]",
"redshift_field": "admit_rate_census",
"pbi_value": 0.0,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_snapshot]",
"redshift_field": "pct_admits_applying_aid_snapshot",
"pbi_value": 73.0,
"redshift_value": "73.00",
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_census]",
"redshift_field": "pct_admits_applying_aid_census",
"pbi_value": 0.0,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_snapshot]",
"redshift_field": "admitted_aid_applicants_snapshot",
"pbi_value": 11424,
"redshift_value": 11424,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_census]",
"redshift_field": "admitted_aid_applicants_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[deposits_snapshot]",
"redshift_field": "deposits_snapshot",
"pbi_value": 1527,
"redshift_value": 1527,
"match": true
},
{
"pbi_field": "[deposits_census]",
"redshift_field": "deposits_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[yield_snapshot]",
"redshift_field": "yield_snapshot",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[yield_census]",
"redshift_field": "yield_census",
"pbi_value": 0.0,
"redshift_value": "0.00",
"match": true
}
],
"row_matched_field_count": 15,
"row_mismatched_field_count": 0,
"row_status": "matched"
}
],
"summary": {
"total_rows_compared": 3,
"matched_rows": 3,
"mismatched_rows": 0,
"success": true
}
}
}{
"test_name": "snapshot_desc_report",
"validation": {
"overall_status": "failure",
"row_count_match": true,
"matched_rows": 1,
"mismatched_rows": 2,
"field_results": [
{
"pbi_row_index": 0,
"redshift_row_index": 0,
"primary_key_values": {
"data[year]": 2024
},
"fields": [
{
"pbi_field": "data[year]",
"redshift_field": "year",
"pbi_value": 2024,
"redshift_value": 2024,
"match": true
},
{
"pbi_field": "[applicants_snapshot]",
"redshift_field": "applicants_snapshot",
"pbi_value": 18540,
"redshift_value": 18540,
"match": true
},
{
"pbi_field": "[applicants_census]",
"redshift_field": "applicants_census",
"pbi_value": 18799,
"redshift_value": 18799,
"match": true
},
{
"pbi_field": "[admitted_students_snapshot]",
"redshift_field": "admitted_students_snapshot",
"pbi_value": 11703,
"redshift_value": 11703,
"match": true
},
{
"pbi_field": "[admitted_students_census]",
"redshift_field": "admitted_students_census",
"pbi_value": 11842,
"redshift_value": 11842,
"match": true
},
{
"pbi_field": "[admit_rate_snapshot]",
"redshift_field": "admit_rate_snapshot",
"pbi_value": 63.12,
"redshift_value": "63.12",
"match": true
},
{
"pbi_field": "[admit_rate_census]",
"redshift_field": "admit_rate_census",
"pbi_value": 62.99,
"redshift_value": "62.99",
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_snapshot]",
"redshift_field": "admitted_aid_applicants_snapshot",
"pbi_value": 7859,
"redshift_value": 7859,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_census]",
"redshift_field": "admitted_aid_applicants_census",
"pbi_value": 8339,
"redshift_value": 8339,
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_snapshot]",
"redshift_field": "pct_admits_applying_aid_snapshot",
"pbi_value": 67.15,
"redshift_value": "67.15",
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_census]",
"redshift_field": "pct_admits_applying_aid_census",
"pbi_value": 70.42,
"redshift_value": "70.42",
"match": true
},
{
"pbi_field": "[deposits_snapshot]",
"redshift_field": "deposits_snapshot",
"pbi_value": 1148,
"redshift_value": 1148,
"match": true
},
{
"pbi_field": "[deposits_census]",
"redshift_field": "deposits_census",
"pbi_value": 1149,
"redshift_value": 1149,
"match": true
},
{
"pbi_field": "[yield_snapshot]",
"redshift_field": "yield_snapshot",
"pbi_value": 9.58,
"redshift_value": "9.58",
"match": true
},
{
"pbi_field": "[yield_census]",
"redshift_field": "yield_census",
"pbi_value": 9.7,
"redshift_value": "9.70",
"match": true
},
{
"pbi_field": "[modal_coa_snapshot]",
"redshift_field": "modal_coa_snapshot",
"pbi_value": 70700.0,
"redshift_value": 70700.0,
"match": true
},
{
"pbi_field": "[modal_coa_census]",
"redshift_field": "modal_coa_census",
"pbi_value": 70700.0,
"redshift_value": 70700.0,
"match": true
},
{
"pbi_field": "[modal_tuition_snapshot]",
"redshift_field": "modal_tuition_snapshot",
"pbi_value": 47322.0,
"redshift_value": 47322.0,
"match": true
},
{
"pbi_field": "[modal_tuition_census]",
"redshift_field": "modal_tuition_census",
"pbi_value": 47322.0,
"redshift_value": 47322.0,
"match": true
},
{
"pbi_field": "[avg_institutional_grant_snapshot]",
"redshift_field": "avg_institutional_grant_snapshot",
"pbi_value": 28626.14,
"redshift_value": "28626.14",
"match": true
},
{
"pbi_field": "[avg_institutional_grant_census]",
"redshift_field": "avg_institutional_grant_census",
"pbi_value": 28665.07,
"redshift_value": "28665.07",
"match": true
},
{
"pbi_field": "[discount_snapshot]",
"redshift_field": "discount_snapshot",
"pbi_value": 60.49,
"redshift_value": 60.489999999999995,
"match": false
},
{
"pbi_field": "[discount_census]",
"redshift_field": "discount_census",
"pbi_value": 60.57,
"redshift_value": 60.57000000000001,
"match": false
},
{
"pbi_field": "[avg_net_tuition_revenue_snapshot]",
"redshift_field": "avg_net_tuition_revenue_snapshot",
"pbi_value": 18695.86,
"redshift_value": "18695.86",
"match": true
},
{
"pbi_field": "[avg_net_tuition_revenue_census]",
"redshift_field": "avg_net_tuition_revenue_census",
"pbi_value": 18656.93,
"redshift_value": "18656.93",
"match": true
},
{
"pbi_field": "[agg_net_tuition_revenue_snapshot]",
"redshift_field": "agg_net_tuition_revenue_snapshot",
"pbi_value": 21462849.0,
"redshift_value": "21462849",
"match": true
},
{
"pbi_field": "[agg_net_tuition_revenue_census]",
"redshift_field": "agg_net_tuition_revenue_census",
"pbi_value": 21436810.0,
"redshift_value": "21436810",
"match": true
}
],
"row_matched_field_count": 25,
"row_mismatched_field_count": 2,
"row_status": "mismatch"
},
{
"pbi_row_index": 1,
"redshift_row_index": 1,
"primary_key_values": {
"data[year]": 2025
},
"fields": [
{
"pbi_field": "data[year]",
"redshift_field": "year",
"pbi_value": 2025,
"redshift_value": 2025,
"match": true
},
{
"pbi_field": "[applicants_snapshot]",
"redshift_field": "applicants_snapshot",
"pbi_value": 19251,
"redshift_value": 19251,
"match": true
},
{
"pbi_field": "[applicants_census]",
"redshift_field": "applicants_census",
"pbi_value": 19541,
"redshift_value": 19541,
"match": true
},
{
"pbi_field": "[admitted_students_snapshot]",
"redshift_field": "admitted_students_snapshot",
"pbi_value": 12386,
"redshift_value": 12386,
"match": true
},
{
"pbi_field": "[admitted_students_census]",
"redshift_field": "admitted_students_census",
"pbi_value": 12533,
"redshift_value": 12533,
"match": true
},
{
"pbi_field": "[admit_rate_snapshot]",
"redshift_field": "admit_rate_snapshot",
"pbi_value": 64.34,
"redshift_value": "64.34",
"match": true
},
{
"pbi_field": "[admit_rate_census]",
"redshift_field": "admit_rate_census",
"pbi_value": 64.14,
"redshift_value": "64.14",
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_snapshot]",
"redshift_field": "admitted_aid_applicants_snapshot",
"pbi_value": 9403,
"redshift_value": 9403,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_census]",
"redshift_field": "admitted_aid_applicants_census",
"pbi_value": 9600,
"redshift_value": 9600,
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_snapshot]",
"redshift_field": "pct_admits_applying_aid_snapshot",
"pbi_value": 75.92,
"redshift_value": "75.92",
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_census]",
"redshift_field": "pct_admits_applying_aid_census",
"pbi_value": 76.6,
"redshift_value": "76.60",
"match": true
},
{
"pbi_field": "[deposits_snapshot]",
"redshift_field": "deposits_snapshot",
"pbi_value": 1164,
"redshift_value": 1164,
"match": true
},
{
"pbi_field": "[deposits_census]",
"redshift_field": "deposits_census",
"pbi_value": 1101,
"redshift_value": 1101,
"match": true
},
{
"pbi_field": "[yield_snapshot]",
"redshift_field": "yield_snapshot",
"pbi_value": 8.65,
"redshift_value": "8.65",
"match": true
},
{
"pbi_field": "[yield_census]",
"redshift_field": "yield_census",
"pbi_value": 8.78,
"redshift_value": "8.78",
"match": true
},
{
"pbi_field": "[modal_coa_snapshot]",
"redshift_field": "modal_coa_snapshot",
"pbi_value": 73776.0,
"redshift_value": 73776.0,
"match": true
},
{
"pbi_field": "[modal_coa_census]",
"redshift_field": "modal_coa_census",
"pbi_value": 73776.0,
"redshift_value": 73776.0,
"match": true
},
{
"pbi_field": "[modal_tuition_snapshot]",
"redshift_field": "modal_tuition_snapshot",
"pbi_value": 49320.0,
"redshift_value": 49320.0,
"match": true
},
{
"pbi_field": "[modal_tuition_census]",
"redshift_field": "modal_tuition_census",
"pbi_value": 49320.0,
"redshift_value": 49320.0,
"match": true
},
{
"pbi_field": "[avg_institutional_grant_snapshot]",
"redshift_field": "avg_institutional_grant_snapshot",
"pbi_value": 29738.84,
"redshift_value": "29738.84",
"match": true
},
{
"pbi_field": "[avg_institutional_grant_census]",
"redshift_field": "avg_institutional_grant_census",
"pbi_value": 29854.71,
"redshift_value": "29854.71",
"match": true
},
{
"pbi_field": "[discount_snapshot]",
"redshift_field": "discount_snapshot",
"pbi_value": 60.3,
"redshift_value": 60.3,
"match": true
},
{
"pbi_field": "[discount_census]",
"redshift_field": "discount_census",
"pbi_value": 60.53,
"redshift_value": 60.529999999999994,
"match": false
},
{
"pbi_field": "[avg_net_tuition_revenue_snapshot]",
"redshift_field": "avg_net_tuition_revenue_snapshot",
"pbi_value": 19581.16,
"redshift_value": "19581.16",
"match": true
},
{
"pbi_field": "[avg_net_tuition_revenue_census]",
"redshift_field": "avg_net_tuition_revenue_census",
"pbi_value": 19465.29,
"redshift_value": "19465.29",
"match": true
},
{
"pbi_field": "[agg_net_tuition_revenue_snapshot]",
"redshift_field": "agg_net_tuition_revenue_snapshot",
"pbi_value": 22792466.0,
"redshift_value": "22792466",
"match": true
},
{
"pbi_field": "[agg_net_tuition_revenue_census]",
"redshift_field": "agg_net_tuition_revenue_census",
"pbi_value": 21431287.0,
"redshift_value": "21431287",
"match": true
}
],
"row_matched_field_count": 26,
"row_mismatched_field_count": 1,
"row_status": "mismatch"
},
{
"pbi_row_index": 2,
"redshift_row_index": 2,
"primary_key_values": {
"data[year]": 2026
},
"fields": [
{
"pbi_field": "data[year]",
"redshift_field": "year",
"pbi_value": 2026,
"redshift_value": 2026,
"match": true
},
{
"pbi_field": "[applicants_snapshot]",
"redshift_field": "applicants_snapshot",
"pbi_value": 19987,
"redshift_value": 19987,
"match": true
},
{
"pbi_field": "[applicants_census]",
"redshift_field": "applicants_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[admitted_students_snapshot]",
"redshift_field": "admitted_students_snapshot",
"pbi_value": 14003,
"redshift_value": 14003,
"match": true
},
{
"pbi_field": "[admitted_students_census]",
"redshift_field": "admitted_students_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[admit_rate_snapshot]",
"redshift_field": "admit_rate_snapshot",
"pbi_value": 70.06,
"redshift_value": "70.06",
"match": true
},
{
"pbi_field": "[admit_rate_census]",
"redshift_field": "admit_rate_census",
"pbi_value": 0.0,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_snapshot]",
"redshift_field": "admitted_aid_applicants_snapshot",
"pbi_value": 10958,
"redshift_value": 10958,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_census]",
"redshift_field": "admitted_aid_applicants_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_snapshot]",
"redshift_field": "pct_admits_applying_aid_snapshot",
"pbi_value": 78.25,
"redshift_value": "78.25",
"match": true
},
{
"pbi_field": "[pct_admits_applying_aid_census]",
"redshift_field": "pct_admits_applying_aid_census",
"pbi_value": 0.0,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[deposits_snapshot]",
"redshift_field": "deposits_snapshot",
"pbi_value": 1261,
"redshift_value": 1261,
"match": true
},
{
"pbi_field": "[deposits_census]",
"redshift_field": "deposits_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[yield_snapshot]",
"redshift_field": "yield_snapshot",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[yield_census]",
"redshift_field": "yield_census",
"pbi_value": 0.0,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[modal_coa_snapshot]",
"redshift_field": "modal_coa_snapshot",
"pbi_value": 76690.0,
"redshift_value": 76690.0,
"match": true
},
{
"pbi_field": "[modal_coa_census]",
"redshift_field": "modal_coa_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[modal_tuition_snapshot]",
"redshift_field": "modal_tuition_snapshot",
"pbi_value": 51270.0,
"redshift_value": 51270.0,
"match": true
},
{
"pbi_field": "[modal_tuition_census]",
"redshift_field": "modal_tuition_census",
"pbi_value": null,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[avg_institutional_grant_snapshot]",
"redshift_field": "avg_institutional_grant_snapshot",
"pbi_value": 30858.79,
"redshift_value": "30858.79",
"match": true
},
{
"pbi_field": "[avg_institutional_grant_census]",
"redshift_field": "avg_institutional_grant_census",
"pbi_value": 0.0,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[discount_snapshot]",
"redshift_field": "discount_snapshot",
"pbi_value": 60.19,
"redshift_value": 60.19,
"match": true
},
{
"pbi_field": "[discount_census]",
"redshift_field": "discount_census",
"pbi_value": 0.0,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[avg_net_tuition_revenue_snapshot]",
"redshift_field": "avg_net_tuition_revenue_snapshot",
"pbi_value": 20411.21,
"redshift_value": "20411.21",
"match": true
},
{
"pbi_field": "[avg_net_tuition_revenue_census]",
"redshift_field": "avg_net_tuition_revenue_census",
"pbi_value": 0.0,
"redshift_value": null,
"match": true
},
{
"pbi_field": "[agg_net_tuition_revenue_snapshot]",
"redshift_field": "agg_net_tuition_revenue_snapshot",
"pbi_value": 25738542.0,
"redshift_value": "25738542",
"match": true
},
{
"pbi_field": "[agg_net_tuition_revenue_census]",
"redshift_field": "agg_net_tuition_revenue_census",
"pbi_value": null,
"redshift_value": null,
"match": true
}
],
"row_matched_field_count": 27,
"row_mismatched_field_count": 0,
"row_status": "matched"
}
],
"summary": {
"total_rows_compared": 3,
"matched_rows": 1,
"mismatched_rows": 2,
"success": false
}
}
}{
"test_name": "snapshot_desc_report",
"validation": {
"overall_status": "failure",
"row_count_match": true,
"matched_rows": 0,
"mismatched_rows": 3,
"field_results": [
{
"pbi_row_index": 0,
"redshift_row_index": 0,
"primary_key_values": {
"data[year]": 2024
},
"fields": [
{
"pbi_field": "data[year]",
"redshift_field": "year",
"pbi_value": 2024,
"redshift_value": 2024,
"match": true
},
{
"pbi_field": "[applicants_snapshot]",
"redshift_field": "applicants_snapshot",
"pbi_value": 23712,
"redshift_value": 23712,
"match": true
},
{
"pbi_field": "[applicants_census]",
"redshift_field": "applicants_census",
"pbi_value": 25245,
"redshift_value": 25245,
"match": true
},
{
"pbi_field": "[admitted_students_snapshot]",
"redshift_field": "admitted_students_snapshot",
"pbi_value": 14405,
"redshift_value": 14405,
"match": true
},
{
"pbi_field": "[admitted_students_census]",
"redshift_field": "admitted_students_census",
"pbi_value": 15554,
"redshift_value": 15554,
"match": true
},
{
"pbi_field": "[admit_rate_snapshot]",
"redshift_field": "admit_rate_snapshot",
"pbi_value": 60.75,
"redshift_value": "60.75",
"match": true
},
{
"pbi_field": "[admit_rate_census]",
"redshift_field": "admit_rate_census",
"pbi_value": 61.61,
"redshift_value": "61.61",
"match": true
},
{
"pbi_field": "[% Admits Applying for Aid_Snapshot]",
"redshift_field": "% Admits Applying for Aid_Snapshot",
"pbi_value": 57.02,
"redshift_value": "57.02",
"match": true
},
{
"pbi_field": "[% Admits Applying for Aid_Census]",
"redshift_field": "% Admits Applying for Aid_Census",
"pbi_value": 57.06,
"redshift_value": "57.06",
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_snapshot]",
"redshift_field": "admitted_aid_applicants_snapshot",
"pbi_value": 8214,
"redshift_value": 8214,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_census]",
"redshift_field": "admitted_aid_applicants_census",
"pbi_value": 8875,
"redshift_value": 8875,
"match": true
},
{
"pbi_field": "[deposits_matrics_snapshot]",
"redshift_field": "deposits_matrics_snapshot",
"pbi_value": 1410,
"redshift_value": 1410,
"match": true
},
{
"pbi_field": "[deposits_matrics_census]",
"redshift_field": "deposits_matrics_census",
"pbi_value": 1557,
"redshift_value": 1557,
"match": true
},
{
"pbi_field": "[yield_snapshot]",
"redshift_field": "yield_census",
"pbi_value": 9.79,
"redshift_value": "10.01",
"match": false
},
{
"pbi_field": "[yield_census]",
"redshift_field": "yield_census",
"pbi_value": 10.01,
"redshift_value": "10.01",
"match": true
}
],
"row_matched_field_count": 14,
"row_mismatched_field_count": 1,
"row_status": "mismatch"
},
{
"pbi_row_index": 1,
"redshift_row_index": 1,
"primary_key_values": {
"data[year]": 2025
},
"fields": [
{
"pbi_field": "data[year]",
"redshift_field": "year",
"pbi_value": 2025,
"redshift_value": 2025,
"match": true
},
{
"pbi_field": "[applicants_snapshot]",
"redshift_field": "applicants_snapshot",
"pbi_value": 24283,
"redshift_value": 24283,
"match": true
},
{
"pbi_field": "[applicants_census]",
"redshift_field": "applicants_census",
"pbi_value": 25648,
"redshift_value": 25648,
"match": true
},
{
"pbi_field": "[admitted_students_snapshot]",
"redshift_field": "admitted_students_snapshot",
"pbi_value": 14730,
"redshift_value": 14730,
"match": true
},
{
"pbi_field": "[admitted_students_census]",
"redshift_field": "admitted_students_census",
"pbi_value": 15498,
"redshift_value": 15498,
"match": true
},
{
"pbi_field": "[admit_rate_snapshot]",
"redshift_field": "admit_rate_snapshot",
"pbi_value": 60.66,
"redshift_value": "60.66",
"match": true
},
{
"pbi_field": "[admit_rate_census]",
"redshift_field": "admit_rate_census",
"pbi_value": 60.43,
"redshift_value": "60.43",
"match": true
},
{
"pbi_field": "[% Admits Applying for Aid_Snapshot]",
"redshift_field": "% Admits Applying for Aid_Snapshot",
"pbi_value": 66.65,
"redshift_value": "66.65",
"match": true
},
{
"pbi_field": "[% Admits Applying for Aid_Census]",
"redshift_field": "% Admits Applying for Aid_Census",
"pbi_value": 65.98,
"redshift_value": "65.98",
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_snapshot]",
"redshift_field": "admitted_aid_applicants_snapshot",
"pbi_value": 9817,
"redshift_value": 9817,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_census]",
"redshift_field": "admitted_aid_applicants_census",
"pbi_value": 10226,
"redshift_value": 10226,
"match": true
},
{
"pbi_field": "[deposits_matrics_snapshot]",
"redshift_field": "deposits_matrics_snapshot",
"pbi_value": 1454,
"redshift_value": 1454,
"match": true
},
{
"pbi_field": "[deposits_matrics_census]",
"redshift_field": "deposits_matrics_census",
"pbi_value": 1261,
"redshift_value": 1261,
"match": true
},
{
"pbi_field": "[yield_snapshot]",
"redshift_field": "yield_census",
"pbi_value": 9.87,
"redshift_value": "8.14",
"match": false
},
{
"pbi_field": "[yield_census]",
"redshift_field": "yield_census",
"pbi_value": 8.14,
"redshift_value": "8.14",
"match": true
}
],
"row_matched_field_count": 14,
"row_mismatched_field_count": 1,
"row_status": "mismatch"
},
{
"pbi_row_index": 2,
"redshift_row_index": 2,
"primary_key_values": {
"data[year]": 2026
},
"fields": [
{
"pbi_field": "data[year]",
"redshift_field": "year",
"pbi_value": 2026,
"redshift_value": 2026,
"match": true
},
{
"pbi_field": "[applicants_snapshot]",
"redshift_field": "applicants_snapshot",
"pbi_value": 23232,
"redshift_value": 23232,
"match": true
},
{
"pbi_field": "[applicants_census]",
"redshift_field": "applicants_census",
"pbi_value": 23232,
"redshift_value": 23232,
"match": true
},
{
"pbi_field": "[admitted_students_snapshot]",
"redshift_field": "admitted_students_snapshot",
"pbi_value": 15649,
"redshift_value": 15649,
"match": true
},
{
"pbi_field": "[admitted_students_census]",
"redshift_field": "admitted_students_census",
"pbi_value": 15649,
"redshift_value": 15649,
"match": true
},
{
"pbi_field": "[admit_rate_snapshot]",
"redshift_field": "admit_rate_snapshot",
"pbi_value": 67.36,
"redshift_value": "67.36",
"match": true
},
{
"pbi_field": "[admit_rate_census]",
"redshift_field": "admit_rate_census",
"pbi_value": 67.36,
"redshift_value": "67.36",
"match": true
},
{
"pbi_field": "[% Admits Applying for Aid_Snapshot]",
"redshift_field": "% Admits Applying for Aid_Snapshot",
"pbi_value": 73.0,
"redshift_value": "73.00",
"match": true
},
{
"pbi_field": "[% Admits Applying for Aid_Census]",
"redshift_field": "% Admits Applying for Aid_Census",
"pbi_value": 73.0,
"redshift_value": "73.00",
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_snapshot]",
"redshift_field": "admitted_aid_applicants_snapshot",
"pbi_value": 11424,
"redshift_value": 11424,
"match": true
},
{
"pbi_field": "[admitted_aid_applicants_census]",
"redshift_field": "admitted_aid_applicants_census",
"pbi_value": 11424,
"redshift_value": 11424,
"match": true
},
{
"pbi_field": "[deposits_matrics_snapshot]",
"redshift_field": "deposits_matrics_snapshot",
"pbi_value": 1527,
"redshift_value": 1527,
"match": true
},
{
"pbi_field": "[deposits_matrics_census]",
"redshift_field": "deposits_matrics_census",
"pbi_value": 0,
"redshift_value": 0,
"match": true
},
{
"pbi_field": "[yield_snapshot]",
"redshift_field": "yield_census",
"pbi_value": 9.76,
"redshift_value": "0.00",
"match": false
},
{
"pbi_field": "[yield_census]",
"redshift_field": "yield_census",
"pbi_value": 0.0,
"redshift_value": "0.00",
"match": true
}
],
"row_matched_field_count": 14,
"row_mismatched_field_count": 1,
"row_status": "mismatch"
}
],
"summary": {
"total_rows_compared": 3,
"matched_rows": 0,
"mismatched_rows": 3,
"success": false
}
}
}