Difference between revisions of "Employee Data Export"

From SmartHCM Wiki
Jump to navigation Jump to search
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
=Introduction=
 
=Introduction=
In this section you will find report about all '''Employee Data''' fields, values and entities.
+
In this section you will find report about all '''Employees Data'''.
  
 
='''Employee Data Report'''=
 
='''Employee Data Report'''=
Employee Data Report is a screen where you can easily view and export all employee information by filtering fields required.
+
Employee Data Report is a screen where you can easily view and export all employee information by filtering fields which are required.
  
==General Parameter Panel==
+
===General Parameter Panel===
[[File:Empinfo_query_panel.PNG|200px|thumb|right|Employee information]]
+
[[File:Emp Data Rpt General Parameters.jpg |200px|thumb|right|General Parameters]]
In this panel you can select some parameters to filter employee data with respect to following parameters:
+
This panel have general parameters by default. You can filter employee data with respect to following parameters:
  
 
*'''Select Geo. Location:''' A dropdown where you can select geographical location of your company like SofDigital Dammam.
 
*'''Select Geo. Location:''' A dropdown where you can select geographical location of your company like SofDigital Dammam.
 
*'''Select Grade:''' A dropdown where you can select or filter according to employee grade.
 
*'''Select Grade:''' A dropdown where you can select or filter according to employee grade.
 
*'''Select Category:''' A dropdown where you can select or filter employee category like normal employee.
 
*'''Select Category:''' A dropdown where you can select or filter employee category like normal employee.
*'''Select Org. Location:''' A dropdown where you can select or filter department in an organization.
+
*'''Select Org. Location:''' A dropdown where you can select or filter department in a selected organization.
 
*'''Select Employee Type:''' A dropdown where you can select or filter employee type like normal employee.
 
*'''Select Employee Type:''' A dropdown where you can select or filter employee type like normal employee.
*'''Select Employee Status:''' A dropdown where you can select or filter employee type like normal employee.
+
*'''Select Employee Status:''' A dropdown where you can select status of an employee like Probation, Confirmed, Resigned, Retired, Terminated.
 
*'''Select Lanuage:''' A dropdown where you can select language in which report will be generated.
 
*'''Select Lanuage:''' A dropdown where you can select language in which report will be generated.
*'''Select Show Parameters:'''  
+
*'''Select Show Parameters:''' A checkbox if checked the parameters are shown in report and if uncheck the parameters are not shown in report.
  
 
===Specific Parameter Panel===
 
===Specific Parameter Panel===
In this Panel you can filter fields which fields will be shown in report and which will not show in report for example, if Employee Id, First Name and Last Name is selected then these three fields will be shown in employee data report.
+
[[File: Emp Data Rpt Specific Parameters.jpg |200px|thumb|right|Specific Parameters]]
 +
There are two controls in this panel.
  
 +
*'''Select Fields:''' A dropdown where you can filter which fields will be shown in report and which will not show in report for example, if Employee Id, First Name and Last Name is selected then these three fields will be shown in employee data report.
 +
*'''Generate Report Button''' It is a button that will generate employee data report based on fields selected. When pressing button a panel '''Query Parameters''' will appear to ask to search about specific criteria based on fields selected for example you have selected Employee Id and First Name and press Report button then a panel will appear that ask to enter ranges between employee Id or search specific First name.
  
 
+
===Query Panel===
You can insert basic employee information in this tab.
+
[[File: Query Panel2.jpg |200px|thumb|right|Query Panel]]
[[File:EMPLOYEE_INFO_DETAIL.PNG|200px|thumb|right|Employee Detail Panel]]
+
In this Panel the filtered employee data will be shown and there is a button named '''Export Results''' which will export generated report in Ms. Excel.
*'''Employee Id''': You have the choice to generate employee Id automatically and/or you can also type it yourself based on '''EMPLOYEE_ID_AUTO_NUMBER''' flag in [[System Default]] screen. If that flag is set to '''Y''', system will generate employee ID automatically.
 
*'''Title''': [[Title]] of the employee such as Mr., Ms., Dr., and etc.
 
*'''First Name''': Required
 
*'''Middle Name'''
 
*'''Last Name'''
 
*'''Family Name'''
 
*'''Full Name''': A read-only field which shows employee full name as you type in First, Middle, and Last name.
 
*'''Gender''': Gender of the employee such as Male or Female (required).
 
*'''Nationality''': Nationality of Employee defined in [[Country, Provinces and Cities]].
 
*'''Marital Status''': Select marital status from this dropdown defined in [[Marital Status]] screen.
 
*'''Religion''': Select one of the religions defined in [[Religion]].
 
*'''Place Of Birth''': Select city of birth of your employee defined in [[Country, Provinces and Cities]].
 
*'''Date of Birth'''
 
*'''Mobile #1''': Employee's primary mobile number.
 
*'''File/Hafeezah No.'''
 
*'''NIC.''': Employee National ID card number.
 
*'''NIC Place Of Issue''': City where employee's NIC card was issued.
 
*'''NIC Issue Date''': Issue date of NIC card written on the card.
 
*'''NIC Expiry Date'''
 
*'''Bank''': [[Bank and Branches]]
 
*'''Branch''': Shows all the branches defined against a particular bank in [[Bank and Branches]] screen.
 
*'''Bank Account No.''': Account number of employee in the above selected bank and branch.
 
*'''Hiring Date'''
 
*'''Date of Joining''': Date of joining could or could not be same as Hiring date. Select this appropriately.
 
*'''Blood Group''': Select employee blood, maybe useful in case of emergency.
 
*'''Active Directory User''': Based on the flag '''ACTIVE_DIRECTORY_USER_AUTO_GEN''' value set in [[System Default]], system will enable/disable this field. If it is set to '''Y''', system will disable this field and generate AD user on its own.
 
*'''Email''': If '''ACTIVE_DIRECTORY_USER_AUTO_GEN''' flag in [[System Default]] is set to Y, system will generate Email id on its own with domain name '''EMAIL_DOMAIN''' specified in [[System Default]] screen.
 
 
 
===Organizational Details===
 
[[File:EMPLOYEE_JOB.PNG|200px|thumb|right|Employee Organizational Details]]
 
*'''Job No.''': Select one of the jobs you created earlier in [[Job Information]] screen.
 
*'''Position''': Shows the position you associated with the job in [[Job Information]] screen.
 
*'''Category''': Category of the employee you linked with the job in [[Job Information]] screen.
 
*'''Employment Type''': Shows the Employment Type you chose for the job in [[Job Information]] screen.
 
*'''Basic Salary''': Basic salary defined against any particular job in [[Job Information]] screen.
 
*'''Org. Location''': Job needs to be in a department such as Networking, Development, Sales, HR and etc. You define job department in [[Job Information]] screen.
 
*'''Geo Location''': It is the geographical location of the job, it could be anywhere from country to state to city to street.
 
 
 
===Employee Type===
 
[[File:Employee_type.PNG|200px|thumb|right|Employee Type]]
 
*'''Employee Type:''' Select one of the type of Employees you created in [[Employee Type]] screen.
 
*'''Grade:''' [[Grade]]s have paramount importance in SmartHCM, because most of the payroll and HR settings depend on them.
 
*'''Employee Status:''' Choose one of the statuses you created in [[Employee Status]] screen.
 
*'''Status Date:''' System automatically sets status date to your system clock when you take action such as create a new employee and/or change existing employee/s status.
 
*'''Shift:''' Select a suitable shift for your employee you created in [[Shift]] screen.
 
*'''Confirm. Date:''' The date on which you change employee status from '''Probation''' to '''Continue'''.
 
*'''Retirement Date:''' Good moments always come to end. Select when he/she is going to retire.
 
*'''Start Basic Salary:''' Starting salary of your employee on the date of joining.
 
*'''Basic Salary'''
 
*'''Gross Pay:''' Inclusive of incentives such as housing, transportation, medical and others.
 
 
 
===Employee Name Translation===
 
[[File:Employee_name_tran.PNG|200px|thumb|right|Employee Name Translation]]
 
In this panel you can add employee name in secondary language.
 
 
 
*'''Language:''' Select language in which you want to translate your name.
 
*'''First Name'''
 
*'''Middle Name'''
 
*'''Last Name'''
 
*'''Family Name'''
 
*'''Full Name:''' Shows complete name as you type in First, middle, last and family name fields.
 
 
 
===LOC LONG CODE Issue===
 
In some cases, employee and / or organizations LOC LONG CODES are not updated / correct, following database script will fix this issue
 
 
 
BEGIN set_loc_long_code_loc; END;
 
 
 
BEGIN set_loc_long_code_emp; END;
 
 
 
COMMIT;
 

Latest revision as of 08:10, 11 April 2017

Introduction

In this section you will find report about all Employees Data.

Employee Data Report

Employee Data Report is a screen where you can easily view and export all employee information by filtering fields which are required.

General Parameter Panel

General Parameters

This panel have general parameters by default. You can filter employee data with respect to following parameters:

  • Select Geo. Location: A dropdown where you can select geographical location of your company like SofDigital Dammam.
  • Select Grade: A dropdown where you can select or filter according to employee grade.
  • Select Category: A dropdown where you can select or filter employee category like normal employee.
  • Select Org. Location: A dropdown where you can select or filter department in a selected organization.
  • Select Employee Type: A dropdown where you can select or filter employee type like normal employee.
  • Select Employee Status: A dropdown where you can select status of an employee like Probation, Confirmed, Resigned, Retired, Terminated.
  • Select Lanuage: A dropdown where you can select language in which report will be generated.
  • Select Show Parameters: A checkbox if checked the parameters are shown in report and if uncheck the parameters are not shown in report.

Specific Parameter Panel

[[File: Emp Data Rpt Specific Parameters.jpg |200px|thumb|right|Specific Parameters]] There are two controls in this panel.

  • Select Fields: A dropdown where you can filter which fields will be shown in report and which will not show in report for example, if Employee Id, First Name and Last Name is selected then these three fields will be shown in employee data report.
  • Generate Report Button It is a button that will generate employee data report based on fields selected. When pressing button a panel Query Parameters will appear to ask to search about specific criteria based on fields selected for example you have selected Employee Id and First Name and press Report button then a panel will appear that ask to enter ranges between employee Id or search specific First name.

Query Panel

[[File: Query Panel2.jpg |200px|thumb|right|Query Panel]] In this Panel the filtered employee data will be shown and there is a button named Export Results which will export generated report in Ms. Excel.