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
IdeaNumberThis field contains the unique Number/Code of an Idea Must be unique for non-deleted ideas, (can use the same IdeaNumber as a deleted idea). 1-20 characters.If the record data exceeds 20 characters, the record will NOT be imported. 
 If the field value is either blank or "NEW" then the number will be generated from the relevant department or subdepartments sequence which can be set up in the admin module.Variable Character (20)
TitleThis field contains the title of the idea. Titles cannot be duplicated. Titles can contain alphanumeric characters. Idea form titles cannot be duplicated. Idea titles must be unique in order for the idea to be imported.N/AN/AVariable Character (200)
OwnerThis field contains the owner of the idea. The users need to be created on the system in order to be identified as owners of an idea. This field can be blank, the record will be imported. UserFirst user on the list of the systemLookup (Users)
FacilitatorThis field contains the facilitator of the idea. The users need to be created on the system in order to be identified as facilitators of an idea. This field can be blank, the record will be imported. 


Structure Level 1This is an indication of the department(Structure Level 1) the idea belongs to. The department(Structure Level 1) selected must match up with the departments(Structure Level 1s) saved on the system.If there is a spelling mistake or the department(Structure Level 1) selected on the import does not meet the departments(Structure Level 1) saved on the system, the record will still be allowed to be imported onto the system. However, the department(Structure Level 1) field will be empty. This will be determined by the users and the codes they associate with the Department(Structure Level 1). All codes will be unique. The system will default to the first entry within the lookup. Lookup (Departments(Structure Level 1))
Structure Level 2  This is an indication of the sub-department(Structure Level 2) the idea will belong to. The sub-department(Structure Level 2) selected must match up with the sub-departments(Structure Level 2) saved on the system.If there is a spelling mistake or the sub-department(Structure Level 2) selected on the import does not meet the sub-departments(Structure Level 2) saved on the system, the record will still be allowed to be imported onto the system. However, the sub-department(Structure Level 2) field will be empty. This will be determined by the users and the codes they associate with the Sub Department(Structure Level 2). All codes will be unique. 
Lookup (Sub Departments(Structure Level 2))
Structure Level 3This is an indication of the Team(Structure Level 3) the idea is associated with. This value must be valid by the system. The team(Structure Level 3) selected must match up with the teams(Structure Level 3) saved on the system.If there is a spelling mistake or the team(Structure Level 3) selected on the import does not meet the teams(Structure Level 3) saved on the system, the record will still be allowed to be imported onto the system. However, the team(Structure Level 3) field will be empty. This will be determined by the users and the codes they associate with the Team(Structure Level 3). All codes will be unique. N/ALookup (Teams(Structure Level 3))
KPI TypeThis field contains the KPI Type Name of the idea. The KPI Type needs to be created on the system in order to be identified as a KPI.This field can be blank, the record will be imported. Throughput \ Cost Usage \ Cost Price
Lookup (KPI Types)
IdeaSourceThis is an indication of the idea generation the idea will belong to. Alphanumeric valueIf there is a spelling mistake or the idea generator selected on the import does not meet the idea generator saved on the system, the record will NOT be imported onto the system.This will be determined by the users.The system will default to the first entry within the lookup. Lookup (Idea Generator)
SituationThis field describes the situation preceding the implementation of an idea.
Can contain alphanumeric characters
The situation for the idea does not have to be captured for import to occur.  N/A
N/A
Variable Character (1000)
Opportunity
This field describes the complication/opportunity preceding the implementation of an idea.
Can contain alphanumeric characters
The complication/opportunity for the idea does not have to be captured for import to occur. 
N/A
N/A
Variable Character (1000)
SolutionThis field describes the solution preceding the implementation of an idea.
Can contain alphanumeric characters
The solution for the idea does not have to be captured for import to occur. 
N/A
N/A
Variable Character (1000)

IdeaDefinitionThis field contains the Idea Definition of the idea. The Idea Definition needs to be created on the system in order to be identified as an Idea Definition.This field can be blank, the record will be imported. N/AN/ALookup (Idea Definitions
IdeaValueThe annualized value of the ideaThe field does not have to be captured for import to occur. The field can only be a numeric value. If this field has a value greater than 0, it will be used as the Idea Value.N/AN/AN/ANumeric (whole numbers)
ForecastCalculationMethodThis indicates how forecast values will be calculatedIf no value is provided a default value will be used. Valid values are:
Forecast Percentages
 KPI Targets		If left blank, it will use a default value (See Default Values column)Forecast Percentages \ KPI TargetsForecast PercentagesLookup (Forecast CalculationMethods)
AccessLevelThe Access level (Idea level Permissions) that will be granted to the ideaIf no value is provided a default value will be used.If left blank, it will use a default value (See Default Values column)Default \ Confidential \ GlobalDefaultLookup (AccessLevels)
StatusThis field contains the Status of the idea. If no value is provided a default value will be used.If left blank, it will use a default value (See Default Values column)Active \ On HoldActiveLookup (IdeaStatuses)
BenefitStartDateThis specified when benefits will start to be tracked
This specified when benefits will start to be tracked
N/A
N/A
N/A
Date time (YYYY-MM-DD)
BenefitEndDateThis specifies when benefits are expected to end
This specifies when benefits are expected to end
N/A
N/A
N/A
Date time (YYYY-MM-DD)
Stage1TargetDateThe target date for the Evaluating Stage to begin. Calendar date, which states when the target evaluating stage will begin. N/AAny date.N/ADate time (YYYY-MM-DD)
Stage1RevisedDateThe revised target date for the Evaluating Stage to begin. Calendar date, which states when the revised target evaluating stage will begin. N/AAny date.
Date time (YYYY-MM-DD)
Stage1ActualDateThe actual date the Evaluating stage began. The calendar date, states when the Evaluating stage will begin. This value will never be used, it will always be replaced by the revised date if one exists or the target date if one exists or it will be left blankAny date.N/ADate time (YYYY-MM-DD)
Stage2TargetDateThe target date for the implementing stage is to begin. Calendar date, which states when the target implementing stage will begin. N/AAny date.N/ADate time (YYYY-MM-DD)
Stage2RevisedDateThe revised target date for the Implementing stage is to begin. Calendar date, which states when the revised target implementing stage will begin. N/AAny date.
Date time (YYYY-MM-DD)
Stage2ActualDateThe actual date the Implementing stage began. The calendar date, states when the Implementation stage will begin. This value will never be used, it will always be replaced by the revised date if one exists or the target date if one exists or it will be left blankAny date.N/ADate time (YYYY-MM-DD)
Stage3TargetDateThe target date for the cash flowing stage is to begin. Calendar date, which states when the target cash flowing stage will begin. N/AAny date.N/ADate time (YYYY-MM-DD)
Stage3RevisedDateThe revised target date for the cash flowing stage is to begin. Calendar date, which states when the revised target cash flowing stage will begin. N/AAny date.
Date time (YYYY-MM-DD)
Stage3ActualDateThe actual date the cash flowing stage began. Calendar date, which states when the cash flowing stage will begin. This value will never be used, it will always be replaced by the revised date if one exists or the target date if one exists or it will be left blankAny date.N/ADate time (YYYY-MM-DD)
Stage4TargetDateThe target date for the locked-in stage is to begin. The calendar date, states when the target is locked in the stage will begin. N/AAny date.N/ADate time (YYYY-MM-DD)
Stage4RevisedDateThe revised target date for the locked-in stage to begin. Calendar date, which states when the revised target locked-in stage will begin. N/AAny date.
Date time (YYYY-MM-DD)
Stage4ActualDateActual date the locked in stage began. Calendar date, which states when the locked-in stage will begin. This value will never be used, it will always be replaced by the revised date if one exists or the target date if one exists or it will be left blankAny date.N/ADate time (YYYY-MM-DD)
Custom Field ColumnsCustomField ValuesCustom Field column headers must be prefixed with the word 'CustomField' followed by the name of the custom field, ie: for the Category custom field, the column header name must be: 'CustomFieldCategory' remove all spaces and special characters.
This field can be blank, the record will still be imported. Their value must be the exact value shown in the form for text, long text, number and drop-down list types, for checkbox custom fields, the value must be either true or false. false = unchecked, true = checked. For date fields, the date must be a valid date. Multi-Select Custom Field Value will need to be specified inside square brackets. i.e. Budget, Invest,...N/AVariable Character
TagsThis field contains the tag name/s of the Idea Tag name length must be greater than  3 and cannot be duplicated. The tag name can contain alphanumericThis field can be blank, the record will be imported. Comma-separated listN/AVariable Character (255)