SCRM 2006 SCRS_Time_Dimension_View
SCRS_Time_Dimension_View contains the Universal Time (GMT) time of day.
SCRS_Time_Dimension_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| TimeKey | int | Not Null | Foreign key that uniquely identifies each product in the SC_TimeDimension_Table. |
| AMPMFlag | nvarchar | Not Null | Indicates whether current time is A.M. or P.M. |
| BusinessHours | tinyint | Null values allowed | Indicates whether current time occurs during regular business hours. |
| GMTHour | tinyint | Not Null | Coordinated Universal Time (Greenwich Mean Time) hour of day. |
| GMTMinute | tinyint | Not Null | Coordinated Universal Time (Greenwich Mean Time)minute of the current hour. |
| GMTSecond | tinyint | Not Null | Coordinated Universal Time (Greenwich Mean Time) second of the current minute. |
| MinuteOfDay | smallint | Not Null | Minute of the current day. |
| PeakPeriod | tinyint | Null values allowed | Indicates whether current time is a peak business period. |
| SecondOfDay | int | Not Null | Second of the current day. |
| ShiftNumber | tinyint | Null values allowed | Indicates current work shift. |