transaction date dimension
(OLT_DIM_TRANSACTION_DATE) 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_DATE)
| Column Name | Column Description |
|---|---|
| Transaction Date Key | Primary key uniquely identifying each row in the transaction date dimension, associated with facts corresponding to the posted date of the transaction fact. |
| Calendar Year | The numeric value of the calendar year (e.g. 1999, 2000, 2001). |
| Calendar Month | The 2-digit numeric value of the calendar month (01-12). |
| Calendar Month Description Long | The name of the calendar month (i.e. January, February, etc.). |
| Calendar Month Description Short | The abbreviated name of the calendar month (i.e. Jan, Feb, Mar, etc.). |
| Calendar Year Month Description | The combined display value of the calendar month and calendar year, separated by a comma (e.g. March, 2001; April, 2001; May, 2001; etc.). |
| Day of the Week | The 2-digit numeric value representing the day of the week (i.e. 01 = Monday, 02 = Tuesday, etc.). |
| Day of the Week Description | The name of the day of the week (e.g. Monday, Tuesday, etc.). |
| Day of the Month | The 2-digit numeric value representing the day of the month (01-31). |
| Week Numeric Value | The 2-digit numeric value representing the week number in the year (01-52). |
| Weekday Flag | A flag indicating whether the given day is a weekday (i.e. Y = weekday; N = weekend). |
| Last Day in Month Flag | A flag indicating whether the given day is the last day of the given month (i.e. Y = last day of month). |
| Calendar Date | The calendar date in MM/DD/YY HH:MI AMPM format (e.g. 06/30/99 12:00 AM). |
| Julian Date | The julian date, an ever-increasing numeric value. |
