Hey all,
I have been with Cite HR for a while now and benefitted from all your postings.. Thank you all....
One of my recent projects in HR is making a HR MIS for our global team. I have some thoughts and formats but would need a lot of assistance too.
I would request members from the forum to please post your views / suggestions on HR MIS and also if you have any templates/ data on the same.
Thank you once again. :D
From India, Mumbai
I have been with Cite HR for a while now and benefitted from all your postings.. Thank you all....
One of my recent projects in HR is making a HR MIS for our global team. I have some thoughts and formats but would need a lot of assistance too.
I would request members from the forum to please post your views / suggestions on HR MIS and also if you have any templates/ data on the same.
Thank you once again. :D
From India, Mumbai
Hi,
MIS report is known as Management Information System... regarding the Manpower status of a particular month, place and overall..
It helps the Management in decision making.. like what are the reasons of resignation.. in which area attrition is high.. and so many things to help in decision making.. with the help of MIS you may prepare a lot of reports.. Like annual attrition.. region wise attrition.. region wise manpower.. graphical representation of regions manpower status.. and so on..
You may prepare the same at your end.As it will help you to prepare other such formats too.
I am describing you the contents with sheet wise..
First Sheet-
Details of employee
a. E.Code b. Name of employee
c. Date of birth d. Designation e. CTC
f. Address for communication
g.Permanent address h. Contact number
i. Blood group j. Maximum qualification
k. Extra qualification l.Total Experience
Second Sheet-
Salary structure
In this sheet write down the complete salary structure.. and make a column what is salary after any revision
Third Sheet -
New Joinees
In this sheet write down the name of New joinees of that month with detail
like
CTC,
Designation,
DOB n etc.
Forth Sheet -
Resigned employees
In this sheet write the name of employees who resigned during
that particular month with details like name, designation, date of joining,
Date of resignation, last working day.
Fifth sheet -
Attrition rate
Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports and so on can prepare a number of reports..
Regards,
Amit Seth.
From India, Ahmadabad
494MIS report is known as Management Information System... regarding the Manpower status of a particular month, place and overall..
It helps the Management in decision making.. like what are the reasons of resignation.. in which area attrition is high.. and so many things to help in decision making.. with the help of MIS you may prepare a lot of reports.. Like annual attrition.. region wise attrition.. region wise manpower.. graphical representation of regions manpower status.. and so on..
You may prepare the same at your end.As it will help you to prepare other such formats too.
I am describing you the contents with sheet wise..
First Sheet-
Details of employee
a. E.Code b. Name of employee
c. Date of birth d. Designation e. CTC
f. Address for communication
g.Permanent address h. Contact number
i. Blood group j. Maximum qualification
k. Extra qualification l.Total Experience
Second Sheet-
Salary structure
In this sheet write down the complete salary structure.. and make a column what is salary after any revision
Third Sheet -
New Joinees
In this sheet write down the name of New joinees of that month with detail
like
CTC,
Designation,
DOB n etc.
Forth Sheet -
Resigned employees
In this sheet write the name of employees who resigned during
that particular month with details like name, designation, date of joining,
Date of resignation, last working day.
Fifth sheet -
Attrition rate
Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports and so on can prepare a number of reports..
Regards,
Amit Seth.
From India, Ahmadabad
Thanks Amit... This is great..
do you have any templates that maybe of assitance?? Also any templates that show a graphical representation???
Do you think giving an Qualification, Age group bar is also a good idea?
From India, Mumbai
do you have any templates that maybe of assitance?? Also any templates that show a graphical representation???
Do you think giving an Qualification, Age group bar is also a good idea?
From India, Mumbai
HR MIS is a very complicated one. What exactly you are looking for? The templates depend on the object. Did you check Regards
From India, Panipat
From India, Panipat
Yes, very true.. Adding qualification as well as age is also a good idea..
Even you may add some more sheets with the name welfare activities, Training conducted and other activities..
Here you may detail of the work done under the subject...
Regards,
Amit Seth.
From India, Ahmadabad
Even you may add some more sheets with the name welfare activities, Training conducted and other activities..
Here you may detail of the work done under the subject...
Regards,
Amit Seth.
From India, Ahmadabad
Hi
I used to read this topic at about.com. You can use Google to search them or visit Human Resources - Business Management Development Jobs Consulting Training Policy Human Resources
Rgs
From Vietnam, Hanoi
I used to read this topic at about.com. You can use Google to search them or visit Human Resources - Business Management Development Jobs Consulting Training Policy Human Resources
Rgs
From Vietnam, Hanoi
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
HR MIS.xls
HR MIS-format.ppt