Identifies the time periods used in the entity.
Table 16. The Time Table
Attribute | Data Type | Definition |
|---|
TimeID | int | A key identifying a specific time period. |
TimeLabel | nvarchar | A string name for the time period. |
RealTime | datetime | A value indicating if the time period is real time. |
TimeParentID | int | If a time period aggregates to another, this stores the key of the aggregating time period. |
TimeSiblingSortOrder | int | If time periods are sibling, this stores the order in which they belong. |