TIME (DIM_TIME) TIME (DIM_TIME)

The columns on the Time-based dimensions are as below.  In each Data Mart just the columns required are available for retrieval.

On the Data Warehouse this is referred to as Dim_Time.  On the Data Marts it is referred to based upon the time column in the Fact table.

Column Name Data Type Description Derivation
time_sk integer This uniquely identifies the time record. This has no business meaning.
time_hours integer The time in hours, 24 hour clock.  
time_minutes  integer  The minutes associated with the time.   
core_time  varchar  Whether the time is the core/ main business hours.  'YES' for hours 9-17.  Other times set to 'NO'.
library_core_time varchar Whether the time is within the library core time 'YES' for hours 8-23.  Other times set to 'NO'.