Description
This fact table provides the amounts for bills (bills may include itemized and registration types). The grain of this fact table is at the itemized bill (account + bill for a given time). It can be combined with fct_transation to understand what payments and credits are intended to be applied toward the itemized bill. Credits in fct_transaction that are applied to an itemized bill can be connected their intended applied bill via the applied_bill_id in fct_transaction to bill_id in fct_bill. For itemized bill type, payments in fct_transaction can be assumed to be applied toward a particular itemized bill by matching the cash basis date key in fct_transaction that occur on or after the to the bill date on fct_bill but before the next itemized bill date. This fact table, coupled with accompanying fct_transaction and dimension tables, can help users to understand questions such as: How much of a bill is paid off before the due date or before the itemized bill occurs? How much money is still unpaid? What accounts are currently paid, unpaid, or partially paid? How much of an itemized bill has been disbursed?
Columns
| Column Name | Type | Description |
|---|---|---|
bill_id |
string
|
Unique identifier for the itemized bill |
user_friendly_bill_id |
string
|
User friendly identifier for the itemized bill |
business_id |
string
|
Unique identifier for the business |
school_id |
string
|
Unique identifier for the school |
account_id |
string
|
Unique identifier for the account |
customer_id |
string
|
Unique identifier for the customer |
forward_amount |
double
|
The amount (in dollars) not paid off from the previous itemized bill; registration bills do not count toward forward amount |
amount |
double
|
The amount (in dollars) accrued since the previous itemized bill |
total_amount |
double
|
The amount (in dollars) owed for the itemized bill; the combination of the forward_amount plus the amount acrued since the previous itemized bill |
bill_invoice_time_key |
int32
|
The time when the itemized bill was created; a surrogate key to the dim_time table |
bill_invoice_date |
date32[day]
|
The date when the itemized bill was created |
payment_due_date |
date32[day]
|
The date when the itemized bill was due |
is_latest_itemized_bill |
string
|
A flag indicating if the itemized bill is the latest bill within an account at a school; enumerated: "Yes' or 'No" |
bill_order |
int32
|
The order in which the itemized bills occured based on the created at datetime; 1 is the first itemized bill |
bill_type |
string
|
The type of bill; enumerated: 'Itemized Bill' or 'Registration Bill' |
business_unit_id |
string
|
Unique identifier for the business unit associated with the bill |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |