Symptom
Which are the limits of the user's record fields at Learning?
Environment
SAP SuccessFactors Learning
Resolution
Here are the character limits in the user records' fields. Please note that while importing the user record through the Import Data Tool, the user ID field's limit is 30 characters. For imports through connector and users created directly through the UI, the maximum allowed is 90 bytes.
Field | Character Limit | Field | Character Limit | |
User ID | 90 | Time Zone | 100 | |
Active (*required) | 1 | Locale | 30 | |
First Name | 50 | Currency ID | 3 | |
Last Name | 50 | Related Instructor ID | 30 | |
Middle Initial | 30 | Custom Column Name | 300 | |
Gender | 1 | Custom Column Value | 120 bytes | |
Job Code ID | 50 | Custom Column Name | 300 | |
Job Title | 100 | Custom Column Value | 120 bytes | |
Role (*required) | 30 | Custom Column Name | 300 | |
Job Location ID | 30 | Custom Column Value | 120 bytes | |
Domain ID (*required) | 30 | Custom Column Name | 300 | |
Organization ID | 30 | Custom Column Value | 120 bytes | |
Employee Type ID | 30 | Custom Column Name | 300 | |
Employee Status ID | 30 | Custom Column Value | 120 bytes | |
Address | 600 | Custom Column Name | 300 | |
City | 50 | Custom Column Value | 120 bytes | |
State/Province | 50 | Custom Column Name | 300 | |
Postal Code | 50 | Custom Column Value | 120 bytes | |
Country | 256 | Custom Column Name | 300 | |
Region ID | 30 | Custom Column Value | 120 bytes | |
Email Address | 128 | Custom Column Name | 300 | |
Supervisor ID | 30 | Custom Column Value | 120 bytes | |
Coach | 30 | Custom Column Name | 300 | |
Resume | 200 | Custom Column Value | 100 | |
Comments | 600 | Include in government reporting | 1 | |
Account Code ID | 30 | 2483 Legal Entity | 90 | |
User May Use Organization Account Code | 1 | 2483 Employee Class | 90 | |
Phone Number I | 30 | Hourly Rate Currency | 3 | |
Phone Number Description I | 100 | Native DeepLink User | 1 | |
Phone Number 2 | 30 | Adjusted Hourly Rate Currency | 3 | |
Phone Number Description 2 | 100 | Disability Classification ID | 90 | |
Phone Number 3 | 30 | Gamification User ID | 300 | |
Phone Number Description 3 | 100 |
Important:
Connectors accept up to 90 characters due to technical aspects, and is not meant to be used to insert beyond 30 characters. One of such aspects is the fact that some characters in other languages take more than 1 byte, hence it is extended to 90 bytes for connectors.
For example Japanese, Chinese and Korean can occupy more bytes depending on the character. It can be from 2 - 4 bytes
UTF-8 uses 1 byte to represent characters in the ASCII set, two bytes for characters in several more alphabetic blocks,
and three bytes for the rest of the BMP. Supplementary characters use 4 bytes.
UTF-16 uses 2 bytes for any character in the BMP, and 4 bytes for supplementary characters.
UTF-32 uses 4 bytes for all characters.
There are string to byte counters calculators online that can help assist you with calculations of characters for each language [These tools are not supported by SAP]
See Also
2601761 - Character Limit For Import Data Templates
2776742 - What are the character limits of the Item fields/columns?
Keywords
LMS, User ID, User ID length, User, character limit, length, character LMS, learning , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , LOD-SF-LMS-CON , Connectors , Problem