A downloadable PDF version is available at the bottom of the page together with the Excel import template.
Rules. (Required fields are marked with a Red background colour)
Please note this is dependent on the target level setting which can either be department or sub-department.
| Field Name | Description | Rules | Exception Handling | Values to be placed | Default Values | Field Type |
| Department | This is an indication of the department the Pipeline will belong to. | User will have to select from existing departments. The department selected must match up with the departments saved on the system. Departments will have codes associated with them. Codes will be unique for departments. 10 characters alphanumeric. Codes can be alpha numeric. 10 characters with a hyphen. That is all. | If the department is not found, the system will not import the target and an error will be displayed. | This will be determined by the users and the codes they associate to the Department. All codes will be unique. | An error will be displayed. | Lookup (Departments) |
| Sub Department | This is an indication of the sub department the Pipeline will belong to. | User will have to select from existing sub departments. The sub department selected must match up with the sub departments saved on the system. The system will only use the sub department if the pipeline target level is set to sub department. | If the sub department is not found, the system will not import the target and an error will be displayed. | An error will be displayed. | Lookup(SubDepartments) | |
| Kpi Type | This is an indicator which determines the type of KPI the KPI within the repository belongs to. | This is a selection. The KPI Types are configurable on the system, and each KPI Type should be unique. 10 characters for codes, alphanumeric. Codes can be alpha numeric. 10 characters with a hyphen. That is all. | If the selection is not chosen a default value will be associated to the KPI. | This will be determined by the users and the codes they associate to the KPI Type. All codes will be unique. | The system will default to the first entry within the lookup. | Lookup (KPI Types) |
| Month | The month values | User can add multiple month columns. The heading of the column must be a valid date. The value of the row will be the pipeline target value for the month. | Number |
Sample.
| Department | Sub Department | KPI Type | Apr-15 | May-15 | Jun-15 | Jul-15 |
| Mining | Pit 1 | Throughput | 200 | 200 | 200 | 200 |
| Mining | Pit 1 | Throughput | 800 | 700 | 200 | 300 |
| Mining | Pit 1 | Throughput | 800 | 700 | 200 | 300 |
| Mining | Pit 1 | Cost Usage | 100 | 150 | 175 | 200 |
| Mining | Pit 1 | Cost Usage | 100 | 150 | 175 | 200 |
| Mining | Pit 1 | Cost Usage | 200 | 205 | 202 | 207 |
| Mining | Pit 1 | Cost Usage | 209 | 211 | 214 | 215 |