SAP Knowledge Base Article - Public

2734323 - What happens when you change field types - Recruiting Management


What happens when you change a field type in Recruiting Management templates?


SAP SuccessFactors Recruiting Management


It is strictly NOT ADVISED to change types in the templates, since recruiting management module uses field types to build columns inside the Database along the field id, and that is where the system will storage the information related to that field id and type and depending on the type, the system will store the information differently. Changing the type of the field in any template might result in a data loss and/or corruption, and may not be revertible.

Let's say that you have a field id="MyField" with type="picklist" pointing to a specific picklist. Perhaps you changed the type of this field to type="text", since the system when using picklist storages the OptionID of the picklist, you may end up losing the reference of the picklist and then in your system from now on you will only have the number of the OptionID displaying in your system.

Other case would be if you changed a type="date" to type="text" or any other, as the system composes the name of the column in the database using this information, you will end up losing the information that you have in this field, and also losing the historical data, in other words, you will not even be able to report on this field information anymore.

If by any chance you need to change the field type, the best possible option would be to create a new field with the new desired type, and hide the old field, to avoid data loss or data corruption.


change, type, template, recruiting, picklist, date, text, types, data loss, corruption , KBA , LOD-SF-RCM , Recruiting Management , How To


SAP SuccessFactors Recruiting all versions