salary change date dimension
(PLH_DIM_SALARY_CHANGE_DATE) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (PLH_DIM_SALARY_CHANGE_DATE)
| Column Name | Column Description |
|---|---|
| SC_SALARY_CHANGE_DATE_KEY | No description available. |
| SC_CALENDAR_YEAR | The numeric value of the calendar year (e.g. 1999, 2000, 2001). |
| SC_CALENDAR_MONTH | The 2-digit numeric value of the calendar month (01-12). |
| SC_CALENDAR_MONTH_LONG_DESC | The name of the calendar month (i.e. January, February, etc.). |
| SC_CALENDAR_MONTH_SHORT_DESC | The abbreviated name of the calendar month (i.e. Jan, Feb, Mar, etc.). |
| SC_CALENDAR_YEAR_MONTH_DESC | The combined display value of the calendar month and calendar year, separated by a comma (e.g. March, 2001; April, 2001; May, 2001; etc.). |
| SC_DAY_OF_THE_WEEK | The 2-digit numeric value representing the day of the week (i.e. 01 = Monday, 02 = Tuesday, etc.). |
| SC_DAY_OF_THE_WEEK_DESC | The name of the day of the week (e.g. Monday, Tuesday, etc.). |
| SC_DAY_OF_THE_MONTH | The 2-digit numeric value representing the day of the month (01-31). |
| SC_WEEK_NUMERIC_VALUE | The 2-digit numeric value representing the week number in the year (01-52). |
| SC_WEEKDAY_FLAG | A flag indicating whether the given day is a weekday (i.e. Y = weekday; N = weekend). |
| SC_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). |
| SC_CALENDAR_DATE | The calendar date in MM/DD/YY HH:MI AMPM format (e.g. 06/30/99 12:00 AM). |
| SC_JULIAN_DATE | The julian date, an ever-increasing numeric value. |
