SAP Knowledge Base Article - Public

2687374 - Character limit of Learning user records' fields

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.

FieldCharacter Limit FieldCharacter Limit
User ID90 Time Zone100
Active (*required)1 Locale30
First Name50 Currency  ID3
Last Name50 Related Instructor ID30
Middle Initial30 Custom Column Name300
Gender1 Custom Column Value120 bytes
Job Code ID50 Custom Column Name300
Job Title100 Custom Column Value120 bytes
Role (*required)30 Custom Column Name300
Job Location ID30 Custom Column Value120 bytes
Domain ID (*required)30 Custom Column Name300
Organization ID30 Custom Column Value120 bytes
Employee Type ID30 Custom Column Name300
Employee Status ID30 Custom Column Value120 bytes
Address600 Custom Column Name300
City50 Custom Column Value120 bytes
State/Province50 Custom Column Name300
Postal Code50 Custom Column Value120 bytes
Country256 Custom Column Name300
Region ID30 Custom Column Value120 bytes
Email Address128 Custom Column Name300
Supervisor ID30 Custom Column Value120 bytes
Coach30 Custom Column Name300
Resume200 Custom Column Value120 bytes
Comments600 Include in government reporting1
Account Code ID30 2483 Legal Entity90
User May Use Organization Account Code1 2483 Employee Class90
Phone Number I30 Hourly Rate Currency3
Phone Number Description I100 Native DeepLink User1
Phone Number 230 Adjusted Hourly Rate Currency3
Phone Number Description 2100 Disability Classification ID90
Phone Number 330 Gamification User ID300
Phone Number Description 3100   

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?

2404463 - LMS Connectors - Connector Workbooks FAQ

User Connector Header Mapping

Keywords

LMS, User ID, User ID length, User, character limit, length, character LMS, learning , KBA , LOD-SF-LMS-USR , User Entity , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions