HUMAN RESOURCE

INFORMATION SYSTEM

INTRA - INTER ORGANIZATION HUMAN

RESOURCES MANAGEMENT SOLUTIONS

Human Resource Information System is aimed to integrate the activities of Human

Resource Department of ABC LTD (ABC LTD).

The Human Resource Information System maintains the following core

activities and core processes of ABC LTD

1. Personal Information Management

2. Personal Training Management

3. Recruitment Process Management

4. Project Management

The information collected through the above activities will be maintained in a

centralized server and could be accessed through the Internet.

The company has decided to create a corporate intranetwork to connect all offices

and their network would also be utilized in case of implementation. The information

collected through this management and process related activities are maintained

as folios.

PERSONAL INFORMATION MANAGEMENT This management process is to maintain the details of employees who are working

at ABC LTD as well as employees who are working in various client concerns.

The information will be maintained by HR Managers of all ABC LTD and its units.

Employee details that would be sent abroad and other concerns other than clients

of ABC LTD would also be managed.

PERSONAL TRAINING MANAGEMENT Employee will be given regular training on need in the latest advanced areas. The

training management maintains a folio on the various topics on which the training

is provided.

It is also maintains the details of the employee who underwent/is undergoing /will

be undergone training. The training has been classified into three categories.

• In-house training

• Offshore training

• Abroad training

The training management also maintains information about the guest lectures as

well as lecturers.

RECRUITMENT PROCESS MANAGEMENT

It creates a folio relating to Recruitment Process. There are three different

methods to recruit employees.

They are

• Through direct recruitment

• Through campus interviews and

• Absorbing project trainees

Direct Recruitment

Direct Recruitment is done on the net. Resumes of candidates are received as either directly or by

mail/e-mail/fax/courier. If they found eligible for interview they would be mailed indicating an user

name, password and date of interview.

The candidate has to log on into the ABC LTD server and he will be given a set of questions

(mostly of objective type). He has to answer those questions and the HR Manager will process his

papers. The process may include further interviews, direct appointment.

Campus Interviews

Employees are appointed by conducting interviews at college campus. The profile of the students

who are interviewed is maintained. Is also maintains the details of the college. The selected

candidates will first be given training in their respective areas and then they are put up in anyone

of its developing unit.

Absorbing Project Trainees

The Project Trainees could also be hired by the ABC LTD concern, if their project performance is

well.

PROJECT MANAGEMENT

The details of all projects done by ABC LTD are maintained. The projects are

classified into two categories.

• Offshore Projects

• Onsite Projects

In case of onsite project employees will be sent to the client concern. Offshore projects

are developed in any one of the developing units. All project-related information is

maintained.

It also maintains the details of the clients who have consulted for their project work. It

includes the client organization and nature of consultancy.

The information belonging to the students who request to work as project trainees are

also maintained. That includes the profile of the student as well as the project to which he

is sent. It also maintains the student’s college information.

The Human Resource Information System comprises of a login screen And 2

modules

There are basically 2 modules

� User module

� Administration module

� Reports

User module exits for

� Recruitment process

� Company details

RECRUITMENT PROCESS

� DIRECT INTERVIEW

� CAMPUS INTERVIEW

� ABSORBING TRAINEE

ADMINISTRATION MODULE EXITS FOR

� PROJECT MAINTENANCE

� COMPANY DETAILS

� EMPLOYEE DETAILS

� RECRUITMENT PROCESS

� RESUME MANAGEMENT

REPORTS GENERATED FOR

� EMPLOYEE DETAILS

� PROJECT TRAINING

� RECRUITMENT REPORT

� ONLINE EXAM REPORT

� COMPANY DETAILS

� RESUME DETAILS

SYSTEM STUDY System study is a process that is to be done before any project begins .this will held to understand

how the existing system is functioning and what are the drawbacks in it once the drawbacks have

been identified it will be easy to design the new system avoiding these drawbacks also system

study should explain what is the need for computerization.

Existing system The existing system is computerized only but company details has been collected in a form and not

stored in database it need to process more as ABC LTD is developing company the drawback of existing

system is the only company details are maintained is client validation it make to move to proposed

system. The existing system is about the details about the company as it is done during period of

company development

The company many branches and the details are not maintained in the existing system. The

employee details are maintained in the ledger this makes the more time to take and maintaining is

very tough to do the existing system has many disadvantage. this makes move to the proposed

system.

PROPOSED SYSTEM

The proposed system consists of the main processing of the company.

The employee details of the company the recruitment processing of the

company ABC LTD., as the ABC LTD is the software company in

Chennai it need the maintenance of the company.

The recruitment is made as per examination conducted by the company

in the on-line of the ABC LTD. The company also conducted campus

interview many colleges in the state the processing wholly done to the

branches of the ABC LTD

The branch companies of the ABC LTD is at maduari, trichy,

coimbatore and triplicane. The each branch has is main processing in

the company details and employee details recruitment processing and

project details of the company. the personal management system has

the both client side and organization view.

The proposed system reduces the burden of the selection committee

the ABC LTD also the system will be enable easy storage and retrieval

of the data maintained in the system.

PROPOSED SYSTEM REQUIREMENTS

PROPOSED SYSTEM SOFTWARE REQUIREMENTS

Server : Windows 2000 and Client

Client : Windows Client

Software : ASP.NET

Database : Oracle / SQL SERVER / Access

PROPOSED SYSTEM HARDWARE REQUIREMENTS

• PIII and Above with 256 MB RAM

• 40 GB HDD

• Digital Color Monitor

• Key Board, Mouse

DATABASE TABLES EMPLOYEE MASTER

FIELD NAME DATA TYPE SIZE

Emp_code(pk) Integer 3

Empname Text 30

Email_id integer 20

Qualification Text 20

Pre_exp_det Text 50

Pre_exp Text 50

Blood group Text 5

D_o_b Date

Job_code Integer 50

Job_nature Text 50

Marr_status Text 1

Refre_by Text 30

Present address Text 50

Permanent address Text 50

Photo file Image

EMPLOYEE TRAINING DETAILS

FIELD NAME DATA TYPE SIZE

Emp code(pk) Text 3

Email Text 5

Job code Integer 3

Train category Text 20

Train place Text 10

Train from date Date

Train to date Date

Train person Text 20

RECURITMENT MASTER

FIELD NAME DATA TYPE SIZE

Rec code(pk) Text 3

Name Text 20

Email Text 5

Address Text 20

Qualification Text 20

RECURIMENT_DIRECT

FIELD NAME DATA TYPE SIZE

Rec code (pk) Integer 3

Name Text 10

Resume by Text 20

Passwd Text 10

Date of interview Date

Marks obtained Integer 10

Referance by Text 10

RECURIMENT CAMPUS

FIELD NAME DATA TYPE SIZE

REC CODE(pk) Integer

Name Text 10

Coll_name Text 30

Coll_add Text 30

D_of_inter Date

Performance Text 30

Placement area Text 20

Areaof train Text 20

Ref_by Text 20

RECRUITMENT PROJECT

Field name DATA TYPE SIZE

Rec code(pk) Integer 10

Name Text 20

Pro_tittle Text 20

Pro_language Text 10

Pro_place Text 30

Proj from_date Date

Proj_status Text 20

Proj_to_date Date

Date_of_inter Date

PROJECT_MASTER

FIELD NAME DATA TYPE SIZE

Proj_code(pk) Integer 10

Proj _cat Text 20

Pro_place Text 20

Client name Text 20

Client nature Text 20

Proj_name Text 30

Proj_area Text 20

Proj_from_date Date

Proj_to_date Date

COMPANY_DETAILS

FIELD NAME DATA TYPE SIZE

Comp_code(pk) Integer 20

Comp_name Text 20

Comp_add Text 60

Comp_city Text 30

Comp_area Text 30

Mail_id Text 20

Md_name Text 20

Yr_of_origin Date