The import source time periods stage file identifies time period information in the cube import source.
The import source time periods stage file loads the import_source_tp_stage table. The columns in the import source time periods stage file are as follows.
| No. | Column | Description |
| 1 | level_id |
The unique identifier for the time level. |
| 2 | start_time_cd |
The calendar date that identifies the period for the current data row. |
| 3 | end_time_cd |
The calendar-based end date for the specified period. Value: yyyy-mm-dd hh:mm:ss (24-hour clock) The end_time_cd value must be specified as the last minute of a time period. For example, 2005-01-01 23:59:00. Required |
| 4 | import_source_id |
The unique identifier of the cube import source. |
| 5 | time_period_exp |
The IBM Cognos 8 expression for the time period used in the cube. |
| 6 | created_dt |
The date the import was created. Format: yyyy-mm-dd hh:mm:ss (24-hour clock) (hh:mm:ss values are optional) Required |
www.cogknowhow.com