TimePeriods
Stores time period structures that are used in forecasting and reporting. This table supports standardized analysis intervals and planning cycles.
Columns
| Name | Type | ReadOnly | Description |
| Created_By | String | True |
The unique identifier (Id) of the user who created this time period record. This value identifies the record author for auditing and ownership tracking. |
| Date_Entered | Datetime | True |
The date and time when this time period record was created. This value supports lifecycle tracking and audit visibility. |
| Date_Modified | Datetime | True |
The date and time when this time period record was most recently updated. This field supports version history and change transparency. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this time period record is marked as deleted. It returns a value of 'false' when the record remains active and available. |
| End_Date | Date | False |
The final date for this time period. This value defines when the time period stops being active or applicable. |
| End_Date_Timestamp | Int | False |
The numeric timestamp that corresponds to the end date of this time period. This value is used for sorting and time-based calculations. |
| Id [KEY] | String | True |
The Id for this time period record. This value is used to reference and manage the record throughout the system. |
| Is_Fiscal | Bool | False |
A Boolean field that returns a value of 'true' when this time period aligns with the organization's fiscal calendar. It returns a value of 'false' when it follows a non-fiscal schedule. |
| Is_Fiscal_Year | Bool | False |
A Boolean field that returns a value of 'true' when this time period represents a full fiscal year. It returns a value of 'false' when the time period covers a quarter, month, or custom span. |
| Leaf_Cycle | Int | True |
The cycle position of this time period relative to others in its forecast hierarchy. This value supports grouped reporting and timeline stacking. |
| Name | String | True |
The name of the time period (for example, 'Q1', 'FY2024', or 'January'). This value is used for display in reports, planning tools, and forecasting dashboards. |
| Parent_Id | String | False |
The Id of the parent time period in the hierarchy, when it is applicable. This value links the current period to broader fiscal or calendar structures. |
| Start_Date | Date | False |
The first date for this time period. This value defines when planning, forecasting, or reporting begins for the period. |
| Start_Date_Timestamp | Int | False |
The numeric timestamp that corresponds to the start date of this time period. This value is used for ordering and date-based comparison. |
| Type | String | False |
The classification of the time period (for example, 'month', 'quarter', or 'year'). This value determines how the period is used in forecasting and reporting processes. |