transaction type dimension
(OLT_DIM_TRANSACTION_TYPE) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (OLT_DIM_TRANSACTION_TYPE)
| Column Name | Column Description |
|---|---|
| Transaction Type Key | Primary key uniquely identifying each row in the transaction type dimension. |
| Document Sequence Code | A Banner code that identifies the type of transaction for a document. |
| Document Type Code | A code that uniquely identifies the type of transaction. |
| Document Type Description | The description corresponding to the document type code. |
| Fact Type | The type of fact record associated with the transaction (e.g. Budget, Actual, Commitment, etc). |
| Transaction Type | The type of transaction (i.e. Initial Budget, Adjusted Budget, Rolled Budget, Temporary Budget, Rolled Encumbrance, Initial, Expenditure, Encumbrance, Reservation, Revenue, Transfer). |
| Rule Class Code | A code that identifies the specific posting rule corresponding to a transaction. |
| Rule Class Code Description | The description corresponding to the rule class code. |
| Year to Date Flag | A flag (Y or N) indicating whether the transaction should be included in year-to-date reporting (i.e. Y = all transactions except those associated with annual budget (AB/0B) funds). |
| Inception to Date Flag | A flag (Y or N) indicating whether the transaction should be included in inception-to-date reporting (i.e. Y = all transactions except those associated with rolled budgets). |
| Annual Flag | A flag (Y or N) indicating whether the transaction should be included when performing annual budget calculations (i.e. Y = all transactions associated with annual budget (AB/0B) funds). |
| Annual with Roll Flag | A flag (Y or N) indicating whether the transaction represents rolled amounts corresponding to annual budgets. |
