Employee upload using excel

Employee Upload Using Excel

Once first employee is uploaded in system, rest employees can be uploaded through excel format. Excel upload can be done designation wise.

Roles

Org Admin

Path

Org Admin >> Employee Service Book

Terminology Used

• Post Type: Post type is first category to bifurcate employees. Post types can be Teaching/Non teaching/ Contractual/ Committee/ Visiting Faculties etc. Any employee which is uploaded under Teaching gets by default role as 'faculty'. Also employees which are uploaded under 'Non Teaching' gets by default role of 'Staff'.
• Post Name: Post names can be called as 'Designation' which comes under Post type. For example under 'Teaching' post type there can be posts like 'Assistant Professor', 'Associate Professor', 'Teacher' etc. Non teaching can be 'Clerk', 'Librarian' etc.
• Grade Type- There are fixed ranges of basic salary defined by Governing body which can be called as 'Grade Type'. Grade type is defined post wise. For example all assistant professors which are on 'VI Pay Scale' will fall under same range of their basic salary. There can be grade type like Consolidated, VI pay scale, or institutes own pay scale in case of private institutes (DES- Pay scale, Indira-Pay scale)
• Pay Band- 'Pay-band' is range of basic salary linked with Grade Type. For example 'VI pay scale' for Assistant Professor is 15,600 - 39,100.
• Pay in pay band- 'Pay in pay band' is simply amount of basic salary in between defined 'Pay Band'
• GP/AGP- GP is called as Grade Pay and AGP is called as Academic Grade pay. Academic grade pay is usually given to teaching employees along with their basic salary. And Grade pay is given to Non Teaching employees along with their basic salary.

Inputs Needed

Post type

Post Name

Grade Type

Pay Band

Employee Id

First name, Middle name & Last name

Gender

Email id

Phone number

Pay in pay band

GP/AGP

Joining date

With effect date

Appointment category

Functionality

Adding new employees

Step by step

1)