_x0001_ On

On

Project: Modernization of coal industry and PAYROLL System. RAJRAPPA Submitted in partial fulfillment of the requirements of Dual Degree (B.Tech+M.Tech)in Information Technology SUBMITTED TO

INDIAN INSTITUTE OF ENGINEERING SCIENCE AND TECHNOLOGY,SHIBPUR BY

Durgesh Kumar B.Tech+M.Tech (IT) 4th semester

A MINIRATNA COMPANY "Committed to create eco-friendly mining"

CERTIFICATE OF SUMMER INTERNSHIPThis is to certify that the project report titled MODERNIZATION OF COAL INDUSTRY AND PAYROLL SYSTEM in Central Coalfields Limited,Rajrappa submitted to Indian Institute of Engineering Science and Technology,Shibpur by DURGESH KUMAR in partial fulfillment of Dual Degree(B.Tech+M.Tech) in Information Technology is an original work carried out by the below mentioned student under the guidance and supervision of the below mentioned guides/supervisors. This work has not been submitted anywhere else for any other degree/diploma under my signature. The original work was carried out during May-July,2016 in Central Coalfields Limited,Rajrappa. Name of the student: ___________________________________________ Dated: _________________________________________________________ Name of the Industry Guide: _______________________________________ Designation of the Industry Guide: __________________________________ E-mail Address: ________________________________________________

ACKNOWLEDGEMENTAny activity big or small is a result of collective effort of several individuals. From the very beginning of human civilization to this complex world, we are dependent on each other for accomplishment our goals. This project report is also the result of collective effort and support of several individuals who have been given me their valuable contribution in fulfillment of the work. Exchange of ideas generates a new object to work in a better way. I extend my gratitude to all those who imparted support & experience even at the cost of heavy demand of their precious time and busy schedule. Without their assistance and continuous guidance this project would not have been completed. My experience from this project has certainly widened my knowledge arena. I would acknowledge my company mentor MR. ARUN KUMAR sir ,MR.HALDAR sir and MR.PATHAK sir for their valuable guidance, inspiration on numerous occasions, which acted as a morale booster in times of problems. I truly appreciate from inner sanctum of my heart, their thoughtful recommendations that have made this project successful. First of all, I would like to give special thanks to the almighty whose blessing helped me to complete this project. Completing a task is never a one man effort. Before explaining my project report, Mr. ARUN KUMAR (GM SYSTEM DEPT.of CCL Rajrappa) to provide a proper guidance and a right approach from time to time, to accomplish the goal. They shared ideas with me to complete my project. They have always been guiding and suggesting me like teacher, guide and mentor as well.It shall be an injustice, if I dont express thank to my friends who helped me in completing my project report. It is my earnest duty to express most gratitude and honor to my parents.

DURGESH KUMAR DECLARATIONI Durgesh Kumar of 2nd year (B.Tech+M.Tech) in information technology,Indian Institute of Engineering Science and Technology,Shibpur , hereby declare that the project titled - MODERNIZATION OF COAL INDUSTRY AND PAYROLL SYSTEM in CCL Rajrappa as the original work conducted by me and submitted in the partial fulfillment for degree. The information and data given in the report is authentic and true to the best of my knowledge. I also declare that this project has not been submitted for the award of any other degree, diploma, literature or recognition earlier.

DURGESH KUMAR Roll No: - 510814022 Course:-B.Tech+M.Tech(IT)Signature of the college mentor:-Date:- TABLE OF CONTENT:-CHAPTER TITLE PAGE NO.NO.

01 INTRODUCTION 8-13

02 COMPANY PROFILE(1) 14-23

03 COMPANY PROFILE(2) 24-38

04 PROJECT DETAILS 39-66 05 RESULTS AND EVALUATION 67-69 06 SUGGESTIONS &CONCLUSION 70-71

BIBLIOGRAPHY 72

ATTENDANCE RECORD 73-74

EXECUTIVE SUMMARY Project Title: MODERNIZATION IN COAL INDUSTRY AND PAYROLL SYSTEM

Organization: Central Coalfields Limited,Rajrappa

Name: Durgesh Kumar

Course Persuading:Dual Degree( B.Tech+M.Tech)

Specialization: Information Technology

Institute: Indian Institute of Engineering Science and Technology,Shibpur.

1 INTRODUCTION OF INFORMATION TECHNOLOGY IN MINING Information Technology(it) is the application of computers to store,retrieve,transmit and manipulate data,often in the context of a business or other enterprise.It is a growing field that offers relatively secure positions for those with solid technical skill.It covers the design,administration and support of computers and telecommunication system. WHY? To enable the use of IT for improving the administrative efficiency in the organization and for easy data sharing between MOC,company and its subsidiaries. It enables improving productivity through effective and efficient management,control of wasteful expenditure and producing quality goods. It will provide better communication,control,information flow and overall development of mines.The major challenge in modernization of coal mines is the availability of highly functional software.Fortunately,CCL RAJRAPPA has got such a working software called COAL NET. COALNET is a centrally processed and an integrated software developed to integrate function through collection and dissemination of data and information across ministry of coal,coal India,its subsidiaries ,areas and collieries. It is being implemented by Electronics Corporation of India.It consists of 14 different modules serving various purposes like material transactions,payrolls,employee record etc.

SCOPE OF THE PROJECT:

A. The scope/range of this project report is not too far stretching to the whole of CCL Rajrappa , rather it only covers the basic knowledge of the multi functional software COAL NET ,payroll system and role of information technology in mining industry . B. My project mainly deals with the present scenario of use of information technology in any manner at CCL Rajrappa during my tenure of the project, May-July 2016.

C. This project also covers basic knowledge of modules of coal net software especially the payroll.

OBJECTIVE OF THE PROJECT:

a) To study the role of information technology in mining industry.b) To gain knowledge about the multi -functional high end software,Coal Net.c) To study in brief the various modules of Coal Net software.d) To study the payroll system.

LIMITATIONS :

The project is a collection of study, observation, and practical experience during my summer internship programmed where i was a member of the team working in the system department of CCL Rajrappa..

I tried to perform this project in best possible manner to avoid any lacuna . In spite of all my efforts in this regard but due to the far stretching activities conducted at CCL Rajrappa head office, my project lack in some of the following heads ,Where there is a chance of further elaborating study on the same subject.

Some information being very sensitive as far as organization is concerned ,is left untouched and not mentioned in any way.

Top-level strategic type of decisions and information too are not taken under study to avoid any favour to the business counter parts.

My project does not concern about the designing and coding part of the coal net software rather it only covers the details of its features,working and importance in the company.

No research has been conducted on this topic for the purpose of this project thus holds a complete field research and development.

Due to time constraints, I was not able to touch all the aspects like coding and designing of the software or the payroll system ,knowledge of back end etc.

History of the company:-

Central Coalfields Limited - The Historical March

Central Coalfields Limited is a Category-I Mini-Ratna Company since October 2007. During 2009-10, coal production of the company reached its highest-ever figure of 47.08 million tones, with net worth amounting to Rs.2644 crore against a paid-up capital of Rs.940 crore.

Formed on 1st November 1975, CCL (formerly National Coal Development Corporation Ltd) was one of the five subsidiaries of Coal India Ltd. which was the first holding company for coal in the country (CIL now has 8 subsidiaries).

Early History - Formation of NCDC (Pre-nationalisation)

CCL had a proud past. As NCDC, it heralded the beginning of nationalization of coal mines in India.

National Coal Development Corporation Ltd. (NCDC) was set up in October, 1956 as Government-owned Company in pursuance of the Industrial Policy Resolutions of 1948 and 1956 of the Government of India. It was started with a nucleus of 11 old state collieries (owned by the Railways) having a total annual production of 2.9 million tonnes of coal.

Until the formation of NCDC, coal mining in India was largely confined to the Raniganj coal belt in West Bengal and the Jharia coalfields in Bihar (now in Jharkhand), besides a few other areas in Bihar (now in Jharkhand) and a part of Madhya Pradesh (now Chattishgarh also) and Orissa.

From its very beginning, NCDC addressed itself to the task of increasing coal production and developing new coal resources in the outlying areas, besides introducing modern and scientific techniques of coal mining.

In the Second Five Year Plan (1956-1961) NCDC was called upon to increase its production from new collieries, to be opened mainly in areas away from the already developed Raniganj and Jharia coalfields. Eight new collieries were opened during this period and the production increased to 8.05 million tonnes by the end of Second Plan.During Third Five Year Plan (1961-1966), though the Corporation had built up a much larger production capacity, it could not be utilized due to a sluggish domestic coal market. Production had, therefore, to be pegged down and the development of several collieries undertaken from the early part of the Plan period, had to be suspended. By this time, the contribution of NCDC to the nation's coal production (67.72 million tones) increased to around 9.6 million tonnes.

With gradual rise in the demand of coal due to commissioning of new power plants and development of other coal-based industries during Fourth Five Year Plan (1969-1974), NCDC's production increased to 15.55 million tonnes by the terminal year of Fourth Five Year Plan, i.e., 1973-74.Fig. Shovel loading a bottom dischargedumper in an opencast mine in 1977-78Fig. Shovel loading a rear dischargedumper in an opencast mine 2009-10

NCDC played a pioneering role in India's coal industry by introducing large-scale mechanization and modern and scientific methods of coal mining for promoting conservation of high grades of coal and exploiting deep coking coal seams necessitating heavy capital investment and sophisticated technical skill. NCDC went in for foreign collaboration with countries such as Poland and the USSR besides limited collaboration with Japan, West Germany and France.

NCDC's role can be truly assessed by its contribution towards growth of new coal resources in, what are known as, the outlying areas. The opening of new mines in Madhya Pradesh, Orissa and Maharashtra brought about a significant change in these regions by creating new opportunities of industrialization and employment. Development of the Singrauli coalfields has brought coal almost to the door steps of northern India.

With the development and application of improved mining techniques, emphasis on planning, design and research; introduction of modern mine management systems and an enlightened industrial relations policy, NCDC was able to provide the infrastructure for the total nationalization of coal industry in the country.

Nationalization of Coal Mines

A major event in the history of Indian coal industry during the Fourth Plan Period (1969-74) was the nationalisation of the erstwhile privately owned coal mines in two phases. In the first phase, the management of coking coal mines was taken over by the Government of India on 17thOct. 1971 and nationalization was effective from 5th January 1972. A state owned company, Bharat Coking Coal Ltd. was formed for managing coking coal mines. For convenience of management, BCCL collieries in the East Bokaro coalfields in Bihar (now Jharkhand) were transferred to NCDC, and its projects in Central Jharia region viz., Sudamdih and Moonidih deep shaft mines were handed over, in stages to BCCL.

In the second phase of nationalisation, the management of non-coking coal mines in the country, excepting the captive coal mines of the two steel plants, viz., TISCO and IISCO, was taken over by the Government on 31stJanuary 1973. These mines were subsequently nationalized with effect from 1stMay 1973 and another state-owned company, Coal Mines Authority Ltd. (CMAL) came into being with headquarters at Calcutta (now Kolkata) to manage and develop NCDC collieries and other newly nationalized units. NCDC itself, in this process, became a division of CMAL which owned 36 collieries under commercial production in Bihar, Orissa, Madhya Pradesh and Maharashtra, besides four coal washeries, one by-product coke oven plant, two large central workshops and manpower of about 71,000.

The formation of CMAL witnessed regrouping of the coal mines into three divisions, namely, Western, Central and Eastern. The regrouping had to be done for the convenience of management, keeping in view the geographical location of the collieries.As a result, NCDC units located in the States of Maharashtra and Madhya Pradesh, with the exception of Singrauli Coalfields, became a part of the Western Division.The Central Division consisted of all the old collieries of NCDC in Orissa and Bihar (except Sudamdih and Moonidih which had been handed over to BCCL) and those acquired by CMAL after take-over in Giridih, East Bokaro, West Bokaro, South Karanpura, North Karanpura, Hutar & Daltonganj Coalfields in Bihar. The Central Division consisted of 64 collieries, four coal washeries, one by-product coke oven plat, on bee-hive coke plant and one central workshop having a manpower of 1,11,500.

Formation of CCL

The CMAL, with its three divisions continued upto 1stNovember 1975 when it was renamed as Coal India Limited (CIL) following the decision of Govt. of India to restructure the coal industry. The Central Division of CMAL came to be known as Central Coalfields Limited and became a separate company with the status of a subsidiary of CIL, which became the holding company.

Presently CCL has

Number of Mines62 Operative Mines (22 Underground & 40 Opencast Mines)

Washeries7 Washeries5 Coking Coal Washeries (Kathara, Rajrappa, Kedla & Sawang, Kargali)2 Non-Coking Coal Washeries (Piparwar & Giddi)

Repair/Workshops1 Central Workshop (ISO 9001) at Barkakana5 Regional Repair/Workshops (3 w/s are ISO 9001) at Jarandih, Tapin North, Dakra, Giridih & Bhurkunda

Operating Coalfields7 Coalfields (East Bokaro, West Bokaro, North Karanpura, South Karanpura, Ramgarh, Giridih & Hutar)

Geological Coal Reserves in CCL Command Area up to 300m & above depth (as on 01.04.2015)

COMPANYS VALUES AND STATEMENT :

Their Vision

"Committed to create eco-friendly mining"

The Mission of CCL is to produce and market the planned quantity of coal and coal products efficiently and economically with due regard to safety, conservation and quality. The main thrust of CCL in the present context is to orient its operations towards market requirements maintaining at the same time financial viability to meet the resource needs.Their Mission

"To become a World class, Innovative, Competitive & ProfitableCoal Mining Operation to achieve Customer Satisfactionas top priority."Their Objectives

Coal Mining through efficiently operated mines. Besides fulfilling coal needs of the customer in terms of quantity, focus on quality, value addition and beneficiation to the satisfaction of the customers.Marketing of coal as main product

MINING METHODS ADOPTED :

OPENCAST: Generally opencast mine of the company employs operating method with shovel and dumper combination and conveying system for mining. UNDERGROUND :Underground mines of the company employs intermediate technology with Load Haul Dumper /Side Discharge Loader and conventional manual method for mining.

BOARD OF DIRECTORS:- Chairman-cum Managing Director of the company:-Mr.Gopal Singh Director Finance of the company:- Mrs. Dipak Kumar Ghosh Director Technical:-Mr. Pradeep Kumar Tiwari Director Personnel of the company:-Mr. Radha Shyam Mahapatro

Coal Reserves in India Coalfield wise

Introduction of the products:-

Coking Coal

These coals, when heated in the absence of air, from coherent beads, free from volatiles, with strong and porous mass, called coke. These have coking properties Mainly used in steel making and metallurgical industries Also used for hard coke manufacturing

Semi Coking Coal

These coals, when heated in the absence of air, from coherent beads not strong enough to be directly fed into the blast furnace. coals are blended with coking coal in adequate proportion to make coke.These have comparatively less coking properties than coking coalMainly used as blend-able coal in steel making, merchant coke manufacturing and other metallurgical industries

NLW Coking Coal

This coal is not used in metallurgical industries. Because of higher ash content, this coal is not acceptable for washing in washeries. This coal is used for power utilities and non-core sector consumers.

Non-Coking Coal

These are coals without coking properties. Mainly used as thermal grade coal for power generation Also used for cement, fertilizer, glass, ceramic, paper, chemical and brick manufacturing, and for other heating purposes.

Hard Coal

Hard coke is formed from coking / semi-coking coal through the process of carbonization. Mainly used in metallurgical industries Also used in industrial plants utilizing furnaces

Washed and Beneficiated Coal

These coals have undergone the process of coal washing or coal beneficiation, resulting in value addition of coaldue to reduction in ash percentage. Used in manufacturing of hard coke for steel making Beneficiated and washed non-coking coal is used mainly for power generation Beneficiated non-coking coal is used by cement, sponge iron and other industrial plants

Middlings

Middlings are by-products of the three stage coal washing / beneficiation process, as a fraction of feed raw coal. Used for power generation Also used by domestic fuel plants, brick manufacturing units, cement plants, industrial plants, etc.

Rejects

Rejects are the products of coal beneficiation process after separation of cleans and / or middlings, as a fraction of feed raw coal. Used for Fluidized Bed Combustion (FBC) Boilers for power generation, Road repairs, briquette(domestic fuel) making, land filling, etc.

CILCoke / LTC Coke

CIL Coke / LTC Coke is a smokeless, environment friendly product of the Dankuni Coal Complex, obtained through low temperature carbonization. Used in furnaces and kilns of industrial units Also used as domestic fuel by halwais, hotels, etc.

Coal Fines / Coke Fines

These are the screened fractions of feed raw coal and LTC coke / CIL Coke respectively, obtained from the Dankuni Coal Complex and other coke oven plants. Used in industrial furnaces as well as for domestic purposes

TAR / Heavy Oil / Soft Pitch

These are products from Dankuni Coal Complex using low temperature carbonization of non-coking coal in vertical retorts. Used in furnaces and boilers of industrial plants as well as power houses, oil, dye, pharmaceutical industries, etc

GRADATION OF COAL

Coking Coal

Grade Parameter

Steel I Ash not exceeding 15%

Steel IIAsh exceeding 15% but not exceeding 18%

Washery I Ash exceeding 18% but not exceeding 21%

Washery II Ash exceeding 21% but not exceeding 24%

Washery III Ash exceeding 24% but not exceeding 28%

Washery IVAsh exceeding 28% but not exceeding 35%

Semi Coking Coal

Grade Parameter

Semi Coking I Ash + moisture not exceeding 19%

Semi Coking II Ash + moisture exceeding 19% but not exceeding 24%

Non Coking Coal

Grade UHV RANGE (KCALS/KG)

A Exceeding 6200

BExceeding 5600 but not exceeding 6200

CExceeding 4940 but not exceeding 5600

DExceeding 4200 but not exceeding 4940

EExceeding 3360 but not exceeding 4200

FExceeding 2400 but not exceeding 3360

GExceeding 1300 but not exceeding 2400

Assam Coal

Grade UHV RANGE (KCALS/KG)

A6200 - 6299

B5600 6199

Hard Coke

Grade Ash %

By Product PremiumNot exceeding 25%

By Product OrdinaryExceeding 25% but not exceeding 30%

Beehive PremiumNot exceeding 27%

Beehive SuperiorExceeding 27% but not exceeding 31%

Beehive OrdinaryExceeding 31% but not exceeding 36%

SUITABILITY OF COAL

Hard Coke

Industry Type of Coal Required

Steel makingCoking and semi-coking coal, direct feed andwashed; blendable coal; low ash % Assam and Raniganj coal.

Steel making, sponge iron industryNon-coking coal of high Initial DeformationTemperature (IDT) (>1200 degrees Celcius)

Cokeries / coke oven plantsCoking and semi-coking coal

Briquette making / domestic fuel makingSemi-coking and non-coking coal; middling& rejects of washeries

Special Smokeless Fuel (SSF)Semi-coking coal of Coking Index 8 10

Power sectorNon-coking coal; middlings of coking coalwasheries; washed coal of non-coking coalwasheries

Cement sectorNon-coking coal; middlings of coking coalwasheries

Glass and potteries Long Flame non-coking coal

Cast iron castings Hard coke

Steel castings Non-coking coal

Bricks Non-coking coal; middlings of coking coalWasheries

Old boilers Superior grades of non-coking coal

Halwais, domestic use, hotels, etc. Non-coking coal; CIL Coke / LTC Coke.

MANPOWER :CategoryStrength

Monthly Rated 491

Daily Rated 1122

P/rated 0

Officer 100

Casuals Stipend(T) 1

Mega Projects

The main strength of CCL, so far as coal production is concerned, is its large opencast mines with mechanised coal production, mostly through shovel-dumper combination and surface Miner. Some of the large opencast mines (producing more than 2 MTY) are, Piparwar OCP Ashok OCPKDH OCPAmlo OCP

Kalyani OCPAmrapali OCPMagadh OCPPurnadih OCP

Karo OCPKonar OCP North Urimari OCP

Piparwar OCP was commissioned with Australian collaboration in early 90s and is equipped with a unique in-pit coal crushing and conveying system the only unit of its kind engaged in the coal production in India. Ashok OCP produces coal by adopting Surface Miner technology. The technological growth has been phenomenal considering the fact that a number of OC mines used to be worked with manual labour in the past.

Future Projects

CCL has a definite plan of growth. It has envisaged commissioning of a number of green field and expansion projects, both opencast and underground, during XI Plan with state-of-the-art technologies. The process of land acquisition and obtaining various approvals/clearances has started in mines, e.g.:Sl. No.Name of ProjectPeak Capacity (MTY)

1.Magadh OCP Expn71

2.Amrapali OCP Expn27

3.Karo OCP Expn11

4.Sangh Mitra OCP20

5.Chandragupta OCP 15

6.Churi Benti UGP 0.81

7.Parej East UGP 0.51

SWOT ANALYSIS OF CCL:

STRENGTH: Huge amount of resources available. Mini Ratna status. Huge manpower. WEAKNESS : Poor management due to huge manpower and large infrastructure. Old technology. Geographic condition.OPPORTUNITY : Bulk of power generation in India is coal based. Rising demand of electricity. Fast growing economy offers a huge market for coal. THREATS : Unpredictable future of coal. Limited availability of natural resources. Increasing pollution. Operational risks. Market competition. Unstable world economy

Project details

PART( A)Information Technology(it) is the application of computers to store,retrieve,transmit and manipulate data,often in the context of a business or other enterprise. NEED: To enable the use of IT for improving the administrative efficiency in the organization and for easy data sharing between MOC,company and its subsidiaries. It enables improving productivity through effective and efficient management,control of wasteful expenditure and producing quality goods. It will provide better communication,control,information flow and overall development of mines. Adaptation of IT based management system in coal industry will allow officials to quickly access,integrate and display critical information for better tactical decision and other strategic decision.

PRESENT SCENARIO-- Wireless communication facility:All the workers are provided with a walky-talky to interact with their supervisors and among themselves.With this they can easily pass orders,report about anything to the control room and many other things just by sitting at one place. Payroll system:With the payroll system ,employees can see their monthly income,inquire about anything so easily and see their deductions and other information just by one click. Proper maintenance of Employee record through coal net software:Record of each employee like their income,loan,bank account,deductions,attendance,leave is well maintained through the coal net software. Record of material transactions,bills etc. through coal net :Proper record of all the transactions for buying equipment,machine parts selling and other bills are well managed through coal net software. Online services offered :a) Online complaint systemb) Online recruitmentc) E - tenders

Technology used for mining : For opencast mining,shovel-dumper combination,mobile in pit crushing and conveying system is used. For underground mining ,technology used is intermediate with load haul dumpers and side discharge loader.

Proposed areas of further application of IT:- Underground wireless communication: A proper and reliable wireless communication system in mines will save machine break down time and also help in immediate passing of messages and instructions between the workers and supervisors . Reduction of production discrepancy:In most of the coal mines there is a coal production discrepancy of about 13-16%.Main reason of this is the way the miners fill the coal tub such that it looks full but its not.Using weight-o- meter, this problem can be solved easily. Maintenance of Equipment:1. Regular monitoring of major equipment using line sensors.2. Recording frequency and duration of all breakdowns.3. Regular tracking of fuel consumption and working hours. Environment monitoring system :Sensors to keep track of amount of gases like CO,H2S,SO2 which can be harmful if their amount increases.these sensors send the record of the amount of gases to the system and keeps it as a record.

PART (B):

COAL NET SYSTEM is an Enterprise Resource Planning (ERP)package solely developed for Coal India Ltd. Centrally processed software and implemented by Electronic Corporation of India. 14 individual modules are integrated in this system like Finance,Sales,Payroll etc. COAL NET is to computerize all the activities of Coal India Ltd. and its subsidiaries.The basic idea is to integrate the information,collection and dissemination through integrated infrastructure for all principle stack holder i.e. (CIL,Subsidiaries, Areas, Collieries, MOC).

Attributes:

1) Reliability In order to ensure reliability, this system is being designed using software that is established to be stable and easy to use. 2) AvailabilityThis system is designed to run 24/7 and be readily available to the user.3) SecurityThe access to the software is given only to valid operators. We need a specific ID and password to get access to the software.

NEED:To enable the use of IT for improving the administrative efficiency in the organization and for easy data sharing between MOC,company and its subsidiaries.

Technology Used-Coal Net uses Java based technology and it can be ported in any H/W Platform. It consists of the following components:- Database: Oracle 12c Application Server: Web logic Front End: JSP,JS, HTML pages Reporting Tool: Oracle Reports 11g and JSP

FUNCTIONS1) Reporting of coal .2) Issuance of coal delivery orders.3) Material transactions.4) Preparation of payroll.5) Billings etc.

MODULES: Finance Sales and Marketing Personnel Information System Payroll Materials Management System etc.

ADVANTAGES:

a) Increment in productivity through speedy processing of information.b) Prompt decision making.c) Faster movement of activities.d) Proper maintenance of employee record which is easily available just by one click.e) Regular tracking of material transactions,bill payment record,easy ordering of materials parts and other services.f) Less paperwork,reduced labour for the employees.

Coal Net home page

Few important modules :

MATERIALS MANAGEMENT SYSTEM

MATERIAL MANAGEMENT SYSTEM (MMS) is one of the modules responsible for keeping information of the materials Coal Industry deals with. Overall the application package is developed to produce different reports to control inventory and maximize the growth.CYCLE OF MMS INDENTING PURCHASING RECEIVING NOT AVAILABLE ISSUING

HOME PAGE OF MMS

MODULE 2:PIS :

It consists of the following entities:

Qualification DetailThis screen contains details of Qualification for each employee.Attendance statusThis screen capture master data for attendance status.NationalityThis screen capture master data for Nationality.CasteThis screen capture master data for Caste.Marital StatusThis screen capture master data for Marital Status.

QUALIFICATION DETAILS PAGE:MODULE 3

Payroll system is the heart of any Human Resource System of an organization. It is to take care of the calculation of salary as per rules of the company, income tax calculation and various deductions to be done from the salary including statutory deductions like Income tax and provident fund deductions. It has to generate pay-slip, cheque summary and MIS reports. Purpose

Main aim of developing Employee Payroll Management is to provide an easy way not only to automate all functionalities involved managing leaves and Payroll for the employees of Company, but also to provide full functional reports to management of Company with the details about usage of leave facility.

Improves the efficiency. Quickly find out information of an employee details. Provides easy and faster access information. Provides user friendly environment. Eco friendly as it saves paper work.

SCREENS

Master Maintenance:

Salary: LIC Working Days Recurring Details Salary Head Processing Month Beno-GrIns Master Pay Group

Transactions:

Salary Enter/Edit Variable Data Edit Cooperative Data Edit Income Tax Salary Head Stop Salary Process Option

General Attendance Entry Leave Attendance Entry OT Offline Adjustment Entry Bank Loan Entry Screen EL/HPL Entry Screen Basic Rate Entry Screen LWP Entry Screen Medical Sunday Entry Screen ArrChangeBasicRateNew Arrear Basic 0910

Payroll Checks PayrollStatusCheck Payroll Unit Check

PROCESS

Processing:

Salary Pre Salary Salary Post Salary Rollback Salary Process Transaction Data Upload Transaction Data Mapping Payslip Generation Attendance Data Mapping Attendance Data Upload Leave

REPORTS

Reports: Payroll Salary Payslip Recuring Deposite Details Deduction Schedule CMPF Schedule LIC Schedule Bank& Chq Stmt Schedule Salary Classification Schdule Dummy Payslip BankFormat - SBI & IOB Pay Bill Summary GPF

General OT Check List Attendance Capture Leave Attendance Capture OT Attendance CheckSheet OT Change Basic Check List Updation Check List Group Insurance Premium Medical Sunday Checklist LWP Checklist Benevolent Scheme EL/HPL CheckSheet Offline CheckSheet Attendance CheckSheet Leave

Area Salary Bank Cheque Stmt New AreaDeduction Schedule CMPF Schedule Stmt Paybill Stmt Area Updation Check List Payslip Stmt Attendance Capture

QUERY

MIS Query: Employee Salary Info Earning Statement

No. of Screens--------------------------------------94 No. of Reports------------------------------------- 132Total No. Of Active Screens---------------------35Total No. of Active Reports---------------------32(plus many excel reports daily)

Masters:This module helps the administrator to enter the designation and the related description. It also helps to add the department. Employee:This module helps to add the details of the employee like the personal detail and the employee detail. Search:This module helps to search the employee details department wise and designation wise.

Attendance:This module helps to different types of leave for different year. It also helps the employee to enter their entry and exit time. Using the attendance module the employee can also check their remaining leaves and also apply for the leave.Salary:This module helps to calculate the salary by adding the allowances and the basic salary and by deducting the deductions based on the leaves and also the PF, ESI. It also helps to generate the employee pay slip.Report:This module helps to generate the administrative reports like the Salary Report, Attendance Report and the Employee Report which is in can be exported to word, pdf.

THE FOLLOWING STEPS ARE INVOLVED IN PAYROLL INFORMATION SYSTEM

1. Adjustment Entry

We have also the options for entering the adjustment amount of any corresponding salary head apart from the transaction entry (which includes also the adjustment data) through another screen.But one thing must be kept in our mind the on the screen there is a column named adjustment type (which is having two options, positive and negative). Hence the flag of the particular salary head is very important in this regard. Because seeing the flag of the head we can only decide the adjustment type of any salary head. Any adjustment head may be positive or negative in nature itself. We have single earning deduct code for every adjustment head for both earning and deduction.

2. Offline Entry (Transaction)

We know that all the transaction data is valid for that particular month for which the salary will be run. So it is clearly understood that we have to entry all the transaction data for every month. This is the important step for processing salary. One of the most important fields on this screen is flag. This must be D for to be deleted head, A for as it is head and null for inserting or updating any salary head.

3. EL/HPL EntryNow for every month we have to entry all the EL/HPL data by the screen through the following link. Here two fields are very much important, related year and related month. On those two the whole el/hpl calculation is depending. There is an important table t_pay_emp_basic_da_rate where the basic rate and vda rate is given for every employee. So this table should not be blank for that month and employee for which the el/hpl calculation is done. 4. Bank Loan Entry

We have the option to enter the bank loan data for any employee from the screen. But one idea should be kept in our mind that for entering the bank loan data for any employee A/C no is mandatory.

Salary Processing:-

After entering all the data successfully in the system we are in a position to process the salary. The salary can be run in four different ways. We have four options: 1] Employee Wise 2] Category Wise 3] Department Wise 4] For all DepartmentNow this is to be set at beginning of the salary processing. Whatever option you will select this will be taken as standard throughout the processing by the system.

The chronological steps are as follows when processing the salary for any month:-

1.Option for salary processingLink ----->Transaction----->Salary----->Salary Process optionLink TransactionSalarySalary Process optionLink TransactionSalarySalary Process option

2. Working Days MasterLink ----->Master Maintenance---->Salary-->Working Days

3. Attendance Data UploadLink---->Processing---->Salary----->Attendance Data Upload Leave

4. Attendance Data MappingLink---->Processing----->Salary----->Attendance Data Mapping

5. Transaction Data UploadLink----->Processing----->Salary----->Transaction Data Upload

6. Transaction Data MappingLink----->Processing----->Salary----->Transaction Data Mapping

7. Pre Salary ProcessLink ----->Processing----->Salary----->Pre Salary Process

8. Salary Process Link----->Processing----->Salary----->Salary Process

9. Rollback Salary ProcessLink----->Processing----->Salary ----->Rollback Salary Process

10. Post Salary ProcessLink----->Processing ----->Salary----->Post Salary Process

Now the salary process is over for that month. But we must know when we are processing the salary we have to be careful before running the post salary process. Because once you run this process the processing of salary will be stopped for that month particularly. Then you cant rollback. So after running salary you run the rollback salary process if you find any wrong and when you are confident run the post salary process. If you rollback then again you have to start from pre salary process.

PAYSLIP (PRINTED IN PRE-PRINTED PAPER)Output:

RESULTS AND EVALUATION

Adequacy and CoverageThe payroll software can perform the following functions :- Store employee information. Calculate gross and net pay, and determine tax deductions to be made Print payslips for each month, showing year-to-date totals Create and maintain a ledger containing all necessary records of employee payments Provide the user with adequate help by the user manual with the software Efficiency and Effectiveness The payroll software calculates the total earnings of the employee and automatically updates the employees earning to date. The employers can set different rates for employees. The software does its calculations in a very clear and concise manner. All calculations are guaranteed accuracy. Productiveness The payroll software gives the employee the ability to keep track of their earnings by printing their payslip for each month. Elegance and User-friendliness The different tasks and functions are outlined in a very simple and clear manner for the users. The help file can be used by the users to know how to use the payroll software. The interface is very simple and not complicated to allow for easy usage.

Critical Evaluation The software overwrites employees information when re-entered. However, employee data is discarded when the employee is deleted from the software. The software also stores every information provided by the user, but does not store results of calculations. Instead, calculations are done on the fly when the user needs to see them on the ledger, the payroll records, or the pay slip. The pay slip not only provides the employee with their earning, it also reflects their year-to date recorded earning.

Suggestions and conclusion

1)Payslip of each employee should be mailed to them at the end of the month. 2) A proper and reliable wireless communication system in mines will save machine break down time and also help in immediate passing of messages and instructions between the workers and supervisors . 3)Reduction of production discrepancy:In most of the coal mines there is a coal production discrepancy of about 13-16%.Main reason of this is the way the miners fill the coal tub such that it looks full but its not.Using weight-o- meter, this problem can be solved easily. 4)There should be regular monitoring of major equipment using line sensors. 5)There should be proper recording frequency and duration of all breakdowns. 6)Regular tracking of fuel consumption and working hours. 7)Sensors to keep track of amount of gases like CO,H2S,SO2 which can be harmful if their amount increases.These sensors send the record of the amount of gases to the system and keeps it as a record.

BIBLIOGRAPHY: www.ccl.gov.in www.scribd.com www.slideshare.com www.freestudentprojects.com

ATTENDANCE RECORDDATEATTENDANCEDATEATTENDANCE

20/05/16YES13/06/16YES

21/05/16YES14/06/16YES

23/05/16YES15/06/16YES

24/05/16YES16/06/16YES

25/05/16YES17/06/16YES

26/05/16YES18/06/16YES

27/05/16YES20/06/16YES

28/05/16YES21/06/16YES

30/05/16YES22/06/16YES

31/05/16YES23/06/16YES

01/06/16YES24/06/16YES

02/06/16YES25/06/16YES

03/06/16YES27/06/16YES

04/06/16YES28/06/16YES

06/06/16YES29/06/16YES

07/06/16YES30/06/16YES

08/06/16YES

09/06/16YES

10/06/16YES

11/06/16YES

----------X---------------------X----------------------