Organizational Data in Microsoft 365 - Attribute reference
The following table provides more details about the Organizational Data in Microsoft 365 attributes.
Note
Be aware that Microsoft_LevelDesignation and Microsoft_Layer attributes don't have corresponding properties in Microsoft Entra. Because of this, the only way to add these values to a Microsoft 365 User Profile is by using the Organizational Data in Microsoft 365 feature.
| # | Attribute | Description | Data type | Example |
|---|---|---|---|---|
| 1 | Microsoft_PersonEmail | Unique identifier for the employee record - an employee's email address. | [email protected] | |
| 2 | Microsoft_ManagerEmail | Unique identifier for an employee’s manager - the employee's manager’s email address. | [email protected] | |
| 3 | Microsoft_Organization | The internal organization or department name that an employee belongs to. | String | Financial Planning and Analysis |
| 4 | Microsoft_LevelDesignation | Level that represents an employee's experience, management level, or seniority within the organization. This is whatever public level designation your company uses. | String | Director |
| 5 | Microsoft_JobDiscipline | The discipline that an employee belongs to. For more actionable insights, avoid using too few or too many unique Job disciplines. This is the public job discipline. | String | Finance management |
| 6 | Microsoft_Layer | An employee's position within the organizational hierarchy, expressed as their distance from the top leader of the organization. For example, the CEO is at Layer 0. Avoid using too few or too many unique layers. This is the layer that is publicly available in your company. | Integer | 2 |
| 7 | Microsoft_FirstName | First name of the end user. | String | Alexa |
| 8 | Microsoft_LastName | Last name of the end user. | String | Smith |
| 9 | Microsoft_DisplayName | Preferred name of employee to display. This is the public display name an employee chooses to list. | String | Alexa Smith |
| 10 | Microsoft_JobTitle | The public facing job title of the employee. | String | Software engineer |
| 11 | Microsoft_CompanyOfficeLocation | An employee’s company office location. This is a location code, like a building number, floor, or room. This shouldn't be an employee's home office or personal address. | String | 2N |
| 12 | Microsoft_CompanyPostOfficeBox | The post office box number. This is the publicly available company office box number. | String | PO Box 12 |
| 13 | Microsoft_CompanyOfficeStreet | The street. This is the publicly available company office street address. | String | NE 12th Street |
| 14 | Microsoft_CompanyOfficeCity | The city of the company office the user is associated with. This is the publicly available office address city. | String | Redmond |
| 15 | Microsoft_CompanyOfficeState | The state. This is the publicly available company office state. | String | Washington |
| 16 | Microsoft_CompanyOfficeCountryOrRegion | The country or region. It's a free-format string value, for example, "United States". This is the publicly available company office country or region. | String | United States |
| 17 | Microsoft_CompanyOfficePostalCode | The publicly available company office postal code. | String | 98004 |
| 18 | Microsoft_Company | Company name. | String | Contoso |
| 19 | Microsoft_CompanyCode | Legal entity number of the company or its subdivision. | String | A2518 |
| 20 | Microsoft_SecondaryJobTitle | Secondary job title for the employee | String | Software engineer |
| 21 | Microsoft_UserSkillNames | Skills the employee has, separated by commas. This value is used for Viva Skills inferencing, so it's important to make sure the field uploaded here is a field that you want to use to generate skills for your users. | String | Project management, organization |
Attribute to property mapping
The following table shows how Organizational Data in Microsoft 365 attributes map to properties in the Microsoft 365 User Profile schema.
| # | Attribute (column heading) in .csv file | Property in Microsoft 365 User Profile schema |
|---|---|---|
| 1 | Microsoft_PersonEmail | N/A The email is converted to the Microsoft Entra objectId of the end user and is used for internal processing. |
| 2 | Microsoft_ManagerEmail | positions -> manager -> userId The email is converted to the Microsoft Entra objectId for the manager and is stored in the Microsoft 365 User Profile. |
| 3 | Microsoft_Organization | positions -> positionDetail -> companyDetail -> department |
| 4 | Microsoft_LevelDesignation | positions -> positionDetail -> level |
| 5 | Microsoft_JobDiscipline | positions -> positionDetail -> role |
| 6 | Microsoft_Layer | positions -> positionDetail -> layer |
| 7 | Microsoft_FirstName | names -> first |
| 8 | Microsoft_LastName | names -> last |
| 9 | Microsoft_DisplayName | names -> displayName |
| 10 | Microsoft_JobTitle | positions -> positionDetail -> jobTitle |
| 11 | Microsoft_CompanyOfficeLocation | positions -> positionDetail -> companyDetail -> officeLocation |
| 12 | Microsoft_CompanyPostOfficeBox | positions -> positionDetail -> companyDetail -> physicalAddress -> postOfficeBox |
| 13 | Microsoft_CompanyOfficeStreet | positions -> positionDetail -> companyDetail -> physicalAddress -> street |
| 14 | Microsoft_CompanyOfficeCity | positions -> positionDetail -> companyDetail -> physicalAddress -> city |
| 15 | Microsoft_CompanyOfficeState | positions -> positionDetail -> companyDetail -> physicalAddress -> state |
| 16 | Microsoft_CompanyOfficeCountryOrRegion | positions -> positionDetail -> companyDetail -> physicalAddress -> countryOrRegion |
| 17 | Microsoft_CompanyOfficePostalCode | positions -> positionDetail -> companyDetail -> physicalAddress -> postalCode |
| 18 | Microsoft_Company | positions -> positionDetail -> companyDetail -> displayName |
| 19 | Microsoft_CompanyCode | positions -> positionDetail -> companyDetail ->companyCode |
| 20 | Microsoft_SecondaryJobTitle | positions -> positionDetail -> secondaryJobTitle |