operating ledger monthly snapshot
(OLM_FACT_OPER_MONTHLY_SNAPSHOT) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (OLM_FACT_OPER_MONTHLY_SNAPSHOT)
| Column Name | Column Description |
|---|---|
| Fiscal Period Key | Foreign key associating this fact with a row from the fiscal period 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. |
| Grant Key | Foreign key associating this fact with a row from the grant dimension. |
| Audit Key | Foreign key associating this fact with a row from the audit dimension. |
| Annual Budget Amount | Annual budget amounts submitted to the Budget office as the full funds budget for the fiscal year. In the case of all research, endowment income, gift and designated funds, the amount expected to be spent within the fiscal year. Typical Usage: Comparison by fiscal years; comparison against expenditures and commitments (See Full Funds Report Sample). |
| Annual Budget Amount with Roll | Primarily used by the finance administration to hold the anticipated revenue budget for the fund. Typlical Usage: Not used by campus, only finance administration. |
| Project YTD Revenue Budget Amount | Primarily used by the finance administration to hold the anticipated revenue budget for the fund. Typical Usage: Not used by campus, only finance administration. |
| Project YTD Budget Amount | Represents the prior year ending balance plus any current YTD budget changes. Typical Usage: Budget vs. Expenditures by fund by fiscal year. |
| Project ITD Revenue Budget Amount | Primarily used by the finance administration to hold the cumulative revenue budget for the fund. Typical Usage: Not used by campus, only finance administration. |
| Project ITD Budget Amount | Represents cumulative expense budget over the life of a project. Typical Usage: Budget vs. Expenditures by fund over the life of the fund. Do NOT use for unrestricted funds. |
| Revenue Amount | Amount of revenue recognized. |
| Expenditure Amount | Amount spent. |
| Transfer Amount | Amount moved between funds. Transfers function similiar to expenditures. |
| Reservation Amount | Represents amounts reserved to be spent (i.e. purchase requisitions). |
| Encumbrance Amount | Represents requisition amounts that have turned into purchase orders and any other actual and anticpated commitments of funds (e.g. tution encumbrance against research funds). |
| Commitment Amount | Represents the sum of "Reservation" and "Encumbrance" amounts. |
| ITD Reservation Amount | Represents amounts reserved to be spent (i.e. purchase requistions) over the life of the fund. |
| ITD Encumbrance Amount | Represents requistion amounts that have been turned into purchase orders and any other actual and anticipated commitments of funds (e.g. tuition encumbrance against research funds) over the life of the fund. |
| ITD Commitment Amount | Represents the sum of "Reservation" and "Encumbrance" amounts over the life of the fund. |
