| FormID | The outcome form ID, must be an 11-digit number. Must be unique within the workbook. |
| AdminAuth | Must be a valid Authority name, as found in the short-term or long-term Electronic Data Transfer Workbooks, on the "0.4 Admin Authority" sheet. The LA must be your LA. |
| Service_Name | If this name differs from the one SP-Bench knows (from your SPLS Extract), you'll get a warning when you upload that lets you confirm whether the record is correct or whether you want to exclude it. |
| SPServiceID | Cannot contain the following characters: , % _ [ ] ^. Note that the SPServiceID must match to an existing Service in SP-Bench's database for the Outcomes data to be imported. If the ID does not match to a Service in the database then the Outcome record is not imported. |
| MaxIncome_1a | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_1a | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_1a_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| ManagingDebt_1b | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_1b | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_1b_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| PaidWork_1c | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_1c | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_1c_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| ActualOutcome_1c_partic | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_1c_Primary_partic | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| Training_2a | Must be one of the following: "Yes", "No", "Missing". |
| Outcome_partic_2a | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_2a_Primary_partic | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| Outcome_achieved_2a | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_2a_Primary_achieved | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| LearningActivities_2b | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_2b | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_2b_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| WorkLikeActivities_2c | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_2c | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_2c_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| ExternalContacts_2d | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_2d_groups | Not mandatory. If a need was identified then this field must be one of the following: "Yes", "No", "N/A" or be an empty field. If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_2d_Primary_groups | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| ActualOutcome_2d_family | Not mandatory. If a need was identified then this field must be one of the following: "Yes", "No", "N/A" or be an empty field. If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_2d_Primary_family | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| PrimaryCare_3a | Must be one of the following: "Yes", "No", "Missing". |
| PhysHealth_Managed_3a | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_3a_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| MentalHealth_3b | Must be one of the following: "Yes", "No", "Missing". |
| MenHealth_Managed_3b | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_3b_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| DrugAlcohol_3c | Must be one of the following: "Yes", "No", "Missing". |
| DrugAlcohol_Managed_3c | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_3c_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| Adaptation_3d | Not mandatory. Must be one of the following: "Yes", "No", "Missing", "N/A", or be an empty field. |
| ActualOutcome_3d | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_3d_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| MaintainAccom_4a | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_4a | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_4a_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| StatOrder_4b | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_4b | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_4b_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| SelfHarm_4c | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_4c_SelfHarm | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_4c_Primary_SelfHarm | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| HarmToOthers_4c | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_4c_HarmToOthers | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_4c_Primary_HarmToOthers | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| HarmFromOthers_4c | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_4c_HarmFromOthers | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_4c_Primary_HarmFromOthers | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| ChoiceControl_5 | Must be one of the following: "Yes", "No", "Missing". |
| ActualOutcome_5 | If a need was identified then this field must be "Yes" or "No". If a need was not identified or (when possible) is missing, not available or its field is empty, then this field must be "Missing". |
| Reason_5_Primary | Must be one of the allowed reasons for the respective outcome, as listed on the appropriate sheet of the short-term or long-term Electronic Data Transfer Workbooks. If an outcome was achieved or is missing, not available or its field is empty, then this column must contain "Missing". If an outcome was not achieved, then this column must contain a valid reason, not "Missing". |
| EndDate | Must be a date in the format dd/mm/yy. Short-term workbooks only. |
| Date_Completed | Must be a date in the format dd/mm/yy. Long-term workbooks only. |