Mapping SCIM attributes to user fields

In Alvao, the following user attributes are synchronized via the SCIM protocol:

User attribute in Alvao	Column in DB (see tPerson)	Attribute in SCIM
-	AzureAdObjectId	externalId
Account is disabled	bPersonAccountDisabled	active (negated value)
-	sAdDisplayName	displayName
-	sFirstName	name.givenName
-	sLastName	name.familyName
First and last name	sPerson	name.formatted
Position	sPersonWorkPosition	title
Email	sPersonEmail	emails[type eq "work"].value
Mobile	sPersonMobile	phoneNumbers[type eq "mobile"].value
Phone for work	sPersonPhone	phoneNumbers[type eq "work"].value
User name	sPersonLogin	userName
-	iPersonLocaleId	locale
Preferred language	sPersonPreferredLanguage	preferredLanguage
Time zone	TimeZone	timeZone
Office	sPersonOffice	addresses[type eq "work"].formatted
City	sPersonCity	addresses[type eq "work"].locality
Country	sPersonCountry	addresses[type eq "work"].region
Personal Number	sPersonPersonalNumber	urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:employeeNumber
Department	sPersonDepartment	urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:department
Organization	liAccountId	urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:organization
Report	iPersonManagerPersonId	urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:manager
Other (custom fields)	tPersonCust.*	urn:ietf:params:scim:schemas:extension:alvao_tPersonCust:2.0:User:*

Ignored attributes in SCIM:

• ims (Instant messangings)
• nickname
• addresses (other than "work")
• addresses[type eq "work"].postalCode, addresses[type eq "work"].steetAddress
• emails (other than "work")
• urn:ietf:params:scim:schemas:extension:enterprise:2.0:User: costCenter
• urn:ietf:params:scim:schemas:extension:enterprise:2.0:User: division
• custom attribute extensions not related to Alvao (alvao_tPersonCust, alvao_tblProperty)

Mapping attributes in Microsoft Entra ID (ME-ID) to custom user fields

If you want to import attributes from ME-ID into custom user fields, do the following:

1. In ME-ID, navigate to the mapping settings ( Provisioning - Edit provisioning - Mappings - Provision Microsoft Entra ID Users).

2. View advanced options and navigate to Edit attribute list for customappsso

3. For each custom user field, create a new attribute with a name of the form urn:ietf:params:scim:schemas:extension:alvao_tPersonCust:2.0:User:{column name of the custom field in the database}.

   Example: to import values into the tPersonCust.IpTelefon custom field, create an attribute named urn:ietf:params:scim:schemas:extension:alvao_tPersonCust:2.0:User:IpTelefon.

4. Save your changes and go back to the list of mapped attributes.

5. Use the Add New Mapping command to create a mapping between the new attributes in SCIM and the fields from Microsoft Entra ID (the mapping specifies what and how the attributes will be populated).

6. All existing users are updated during the next setup cycle.

For more information on mapping individual attributes, see Tutorial - Customize Microsoft Entra ID attribute mappings in Application Provisioning | Microsoft Docs.