Hi @ASHU_1 ,

Please read the different documentation provided by ServiceNow. 

According to user profile, i'm unsure if it is the standard sys_user table or if you refer to the User profile table within the CSM application: https://docs.servicenow.com/search?q=User%20profile%20page

For HR profile: https://docs.servicenow.com/bundle/vancouver-employee-service-management/page/product/human-resource...

For employee profile: https://docs.servicenow.com/bundle/vancouver-employee-service-management/page/product/employee-cente...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

The purpose is simple, what information is relevant and safe to be shown, anyone can see the employee profile but HR profile will have certain sensitive information that will not be open to whole organization.

I think you asked very good question.

User profile is the user table (sys_user) contain basic user information from third directory service (such as Active Directory).

HR profile (sn_hr_core_profile) is a part of HRSD application, which contains basic user information by referencing to user table (sys_user) as well its own HR fields, which contains many sensitive user information.  Please see the following image highlighted.   

When you activate the Employee Profile plugin, the following fields are pulled from the HR Profile (sn_hr_core_profile) table to populate the Employee Profile (sn_employee_profile) table.

• employment_start_date
• employment_end_date

https://docs.servicenow.com/bundle/vancouver-employee-service-management/page/product/human-resource...

You can clearly understand their relationship from HR profile table screenshot above.

If you like my answer, please mark a solution or helpful

@John Zhang1 - Thank you so much for patiently answering that. I still do not understand the purpose of having Employee Profile table, why is it required? You could just have the HR Profile Table and view referenced required fields in a UI within Employee Center, why you need a separate table for it?