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 NameDescriptionRulesException HandlingValues to be placedDefault ValuesField Type
DepartmentThis 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 DepartmentThis 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 TypeThis 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)
MonthThe month valuesUser 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.

 

DepartmentSub DepartmentKPI TypeApr-15May-15Jun-15Jul-15
MiningPit 1Throughput200200200200
MiningPit 1Throughput800700200300
MiningPit 1Throughput800700200300
MiningPit 1Cost Usage100150175200
MiningPit 1Cost Usage100150175200
MiningPit 1Cost Usage200205202207
MiningPit 1Cost Usage209211214215