Table: fct_agency_payment

Type: Fact Columns: 7

Description

Agency payment info

Columns

Column Name Description
business_id

Unique identifier for the business

school_id

Unique identifier for the school

payment_date

The date that the payment was submitted

payment_amount

The amount of money paid by the agency

agency_id

Unique identifier for the agency

agency_payment_id

Unique identifier for the agency payment

business_unit_id

Unique identifier for the business unit associated with the payment