Admin access required
This page is restricted to administrators. Return to the team hub.
Heads up: Replace mode deletes every row in the target table before inserting the new dataset. If the upload is interrupted mid-way, the table is left partially filled — just re-upload to recover. Name-map tables are safer: they only add or correct entries and never delete.
Lender metrics
Replace mode overwrites
dealer_lenders.Loading…
Columns: hash_lender_id, dealer_count, app_cnt, apprv_cnt, funded_cnt, appr_not_funded_cnt, epd6_cnt, epd6_exposure, lender_dealer_score, consortium_dealer_score, avg_fraud_score, weighted_avg_loan_amt
Dealer rows
The big one. Replace mode overwrites
dealer_rows. Uploads in batches of 500.Loading…
Columns: hash_lender_id, ppi_dealer_id, dealer_id, dealer_name, lender_dealer_score, consortium_dealer_score, avg_fraud_score, avg_loan_amt, app_cnt, apprv_cnt, funded_cnt, appr_not_funded_cnt, epd6_cnt, epd6_exposure
Lender names (unhash map)
Maps
hash_lender_id to the real lender name. Upsert is the default so corrections don't wipe the existing map.Loading…
Columns: hash_lender_id, lender_name, lender_id
Dealer names (unhash map)
Maps
dealer_id (not ppi_dealer_id) to the real dealer name. Upsert by default.Loading…
Columns: dealer_id, dealer_name