Rensselaer global navigation
Rensselaer Polytechnic Institute RPInfo Search RPI Contact RPI Campus Directories Depts/Offices with web sites Degree Programs, Academic Schools

Rensselaer Data Warehouse Project

operating ledger budget transactions

(OLT_FACT_BUDGET_TRANSACTIONS) No description available.

general ledger star schemas

monthly balances

operating ledger star schemas

monthly snapshots
actual transactions
budget transactions
commitment transactions


individual column descriptions (OLT_FACT_BUDGET_TRANSACTIONS)

Column Name Column Description
Fiscal Period Key Foreign key associating this fact with a row from the fiscal period dimension.
Date Key Foreign key associating this fact with a row from the date dimension.
Activity Date Key Foreign key associating this fact with a row from the activity date dimension.
Organization Key Foreign key associating this fact with a row from the organization dimension.
Fund Key Foreign key associating this fact with a row from the fund dimension.
Account Key Foreign key associating this fact with a row from the account dimension.
Program Key Foreign key associating this fact with a row from the program dimension.
Activity Key Foreign key associating this fact with a row from the activity dimension.
Financial Transaction Key Foreign key associating this fact with a row from the financial transaction dimension.
Grant Key Foreign key associating this fact with a row from the grant dimension.
Transaction Type Key Foreign key associating this fact with a row from the transaction type dimension.
Audit Key Foreign key associating this fact with a row from the audit dimension.
Document Code No description available.
Item Number No description available.
Document Sequence Number No description available.
Document Sequence Code No description available.
Submission Number No description available.
Reversal Indicator No description available.
Serial Number No description available.
Document Reference Number No description available.
Encd Number No description available.
Encd Item Sequence Number No description available.
Encd Sequence Number No description available.
Annual Budget Amount No description available.
Annual Budget Amount with Roll No description available.
YTD Revenue Budget Amount No description available.
YTD Budget Amount No description available.
ITD Revenue Budget Amount No description available.
ITD Budget Amount No description available.