^TYPE | Identifies the item that the ACTION will be taken upon. Valid options include: OBJECTIVE, MILESTONE, OBJECTIVE_TEAM, METRICLOOKUP, OBJCOMMENT. Values are case sensitive. | OBJECTIVE |
ACTION | The action to take on the item identified in TYPE. Valid options include: ADD, UPDATE, DELETE. Values are case sensitive. For Team Goals, you can use additional actions like ASSIGN, UNASSIGN, SHARE, UNSHARE. | ADD |
ID | This is the goal's internal ID and is created by the SAP SuccessFactors system. This field will identify a specific goal to be acted upon. The import creator should only add a value here if they want to modify a specific goal. The future goal export feature will automatically retrieve each goal’s ID when a goal is exported. | 12345 |
GUID | Required. This is a unique code that you define if the goal is new. If the goal already exists, run an ad hoc report to retrieve the GUID, then use that GUID to update or delete the goal. | sf123 |
SUBGUID | This is a unique code used to identify a row in a table field (MILESTONE, METRICLOOKUP). The SUBGUID is used in the same way for table field rows, as the GUID field is used for goals. | subsf123 |
FILTER_USERNAME | This field allows the assigner to populate one or more UserID’s. Multiple UserID’s can we entered by separating the IDs with a semi-colon | cgrant;mhoff;cccc |
FILTER_MGR_ID | This field is filtered against the UserID of the manager of the employees for whom you would like to add the Goal. | manager |
FILTER_DEPT | This field is filtered against the employee DEPARTMENT field. Used to determine for which users to create the goal. | Human Resources |
FILTER_DIV | This field is filtered against the employee DIVISION field. Used to determine for which users to create the goal. | Administration |
FILTER_JOBCODE | This field is filtered against the employee JOBCODE field. Used to determine for which users to create the goal. | IC |
FILTER_LOC | This field is filtered against the employee LOCATION field. Used to determine for which users to create the goal. | Paris |
FILTER_CUSTxx | This field is filtered against the employee CUSTOMXX field. Note: only a max of three custom fields can be used to filter goal actions. Custom filters can be defined in the back-end or with the admin tool Manage Business Configuration UI. | Custom text |
OBJECTIVE_CATEGORY | Category ID as defined in the goal plan XML. Check with the SAP SuccessFactors consultant to find this. | Financial |
OBJECTIVE_PARENTID | Used to manage goal alignment. This is the internal goal ID for the goal to be aligned up to. | 3364 |
OBJECTIVE_PUBLIC | Define if the goal will be public or private. Accepted values are (Y/N) or (1/0) | Y |
OBJECTIVE_name | Maps to field-definition id="name" | Increase Services Revenue per Account |
OBJECTIVE_metric | Maps to field-definition id="metric" | Service Revenue per Account |
OBJECTIVE_actual | Maps to field-definition id="actual" | |
OBJECTIVE_weight | Maps to field-definition id="weight" | |
OBJECTIVE_start | Maps to field-definition id="start" | 3/1/2021 |
OBJECTIVE_due | Maps to field-definition id="due" | 12/31/2021 |
OBJECTIVE_status | Maps to field-definition id="state" Accepts the enum value. | |
OBJECTIVE_comments | Maps to field-definition id="comments". Goal comments are added as a separate row in the CSV file with a ^TYPE of OBJCOMMENT. See examples section. | |
OBJECTIVE_actual-achievement | Maps to field-definition id="actual-achievement". This field is used to calculate the goal’s rating based on the metric lookup table. Value is numeric. | 500 |
MILESTONE_date | Date column for the Milestone table field. tables require a separate row in the CSV file. See examples section. | |
MILESTONE_target | Target column of the Milestone table. | |
MILESTONE_actual | Actual column of the Milestone table. | |
OBJECTIVE_NUMERIC_METRIC_LOOKUP_TABLE | This column appears when a goal plan is configured with both achievement and achievement-text. Accepted values are (Y/N) or (1/0). A positive value (Y,1) represents that the goal is using the achievement column and field. | Y |