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)


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)
StageThe current state of the idea [Locked in, Evaluating etc]This consists of  four Values . It can either be the full stage word or a number from one to four that is linked to a certain stage.
The Values can be entered as the stage or the number for example:
1 Or Evaluating
2 Or Implementing
3 Or Cash Flowing
 4 Or Locked In
If there is a spelling mistake, or the stage selected on the import does not meet the stage saved on the system, the system will not import the target and an error will be displayed.Valid stage namesAn error will be displayed.Lookup (Stages)
TargetTypeThis would be Monthly/WeeklyThis would be Monthly/WeeklyIf there is a spelling mistake, or the Target Type selected on the import dis incorrect, the record will not be allowed to be imported onto the system.Monthly or WeeklyAn error will be displayed.
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 TypeStageTargetTypeApr-15May-15Jun-15Jul-15
MiningPit 1ThroughputEvaluatingMonthly200400600800
MiningPit 1ThroughputImplementingMonthly200200200200
MiningPit 1ThroughputCash FlowingMonthly800700200300
MiningPit 1ThroughputLocked InMonthly800700200300
MiningPit 1Cost UsageEvaluatingMonthly100150175200
MiningPit 1Cost UsageImplementingMonthly100150175200
MiningPit 1Cost UsageCash FlowingMonthly200205202207
MiningPit 1Cost UsageLocked InMonthly209211214215