The stage project file loads projects, actions, and tasks.
The stage project file loads the stage_project table. The columns in the stage project file are as follows.
No. | Column | Description |
1 | project_id |
The external object identifier for a project, action, or task. Maximum: 255 Required |
2 | language_cd |
The two-character identification code for the language of the data you are importing. Values: EN (English), FR (French), JA (Japanese), and so on Default: EN (English) |
3 | default_sort_order |
A number indicating the ordering of the object in relation to other objects of the same type in the system. This is the default order and can be overridden by a user. For example, the default_sort_order for projects, actions, or tasks controls the order in which the projects, actions, or tasks appear in the projects list. Tip: To control the order in which projects, actions, or tasks appear in the projects list, use the sort_order column in the .cml file. |
4 | owner_user_ns_id |
The identifier of a Cognos 8 authentication namespace used to resolve the reference in the owner_user_id column. Used to differentiate the value in the owner_user_id when more than one Cognos 8 authentication namespace is configured. Optional |
5 | owner_user_id |
The unique identifier for the owner of the object. The name of the user, the identification of the user, or the search-path field in IBM Cognos 8. Value: owner ID |
6 | project_nm |
The name of the project, action, or task. Maximum: 255 Required |
7 | project_desc |
The description of the project, action, or task. Maximum: 1000 |
8 | parent_object_id |
The external_object_id of the parent of the project, task, or action. This refers to a scorecard in the case of a project, a project in the case of a task, or a metric in the case of an action. Required Maximum: 255 |
9 | kpi_indicator_type_id |
The unique identifier of the metric type for the metric. Required if you do not use the parent_object_id column Value: metric type ID |
10 | kpi_home_sc_id |
The unique identifier of the home scorecard for the metric. Required if you do not use the parent_object_id column Value: home scorecard ID |
11 | kpi_qualifier_id |
The unique identifier of the qualifier to distinguish this metric from other metrics of the same type on the same home scorecard. Required if you do not use the parent_object_id column Corresponds to the object_id in the .cmo file. |
12 | on_budget_metric_id |
The external_object_id of the metric that monitors the budget of a project. Optional Maximum: 255 |
13 | planned_start_dt |
The planned start date of the project. |
14 | actual_start_dt |
The actual start date of the project. |
15 | planned_completion_dt |
The planned finish date of the project. The planned finish date is when the project should be finished. |
16 | forecast_completion_dt |
The forecasted completion date of the project. The forecasted completion date is when the project will likely be completed. If the forecasted completion date is later than the planned completion date, then the project is behind schedule. |
17 | actual_completion_dt |
The actual completion date of the project. |
18 | percent_complete |
The percentage of the project that is complete. |
19 | default_report_id |
The identifier of the default report for this project. Optional |
20 | delete_flag |
The flag indicating whether the project is to be deleted. Values: Y (Yes), N (No) Default: N |
21 | parent_object_type_cd |
The code for the parent object type of the project, task, or action. Values: SC (scorecard), PRO (project), KPI (metric) |
22 | rollup_dates |
The flag indicating whether project dates and percentage complete are updated when task values change. Values: Y (Yes), N (No) . NULL is converted to Y. |
23 | task_weight |
The default weight for the tasks associated with a project, or the weight of a given task. Only numerical values are allowed. Default: 10 |
24 | created_dt |
The date the project was created. Format: yyyy-mm-dd hh:mm:ss (24-hour clock) (hh:mm:ss values are optional) Required |
www.cogknowhow.com