operating ledger commitment transactions
(OLT_FACT_COMMITMENT_TRANSACTNS) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (OLT_FACT_COMMITMENT_TRANSACTNS)
| 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. |
| Reservation Amount | No description available. |
| Encumbrance Amount | No description available. |
| Commitment Amount | No description available. |
| ITD Reservation Amount | No description available. |
| ITD Encumbrance Amount | No description available. |
| ITD Commitment Amount | No description available. |