KSIDC-ERP-URS

Document Sample
KSIDC-ERP-URS Powered By Docstoc
					  USER REQUIREMENTS SPECIFICATIONS [URS]
                                         FOR
                               KSIDC – ERP

Document Id:               NeST/DU2_142_KSIDC_ERP_URS         Version:       1.0
                           Name / Signature                   Date
Prepared / Amended by      Kiron K Rahulan, Mathew M          15-Jun-2010 To 30-Jun-
                           Mathew, Aju N Peter                2010
Reviewed by                Abhayakumar K                      01-Jul-2010

Approved by                Dr.Joseph George                   01-Jul-2010




                        Network System and Technologies Pvt Ltd
                                South Kalamassery, Kochi
                                           NeST




Security Classification:   NeST Confidential
Control Status:            This document is controlled as per the CM Plan of Project
Format ID                  NeST IT/FM/01 V 4.0




                                       Page 1 of 87
Amendment Record


Version   Date          Author                   Reviewer        Change Description

1.0       15-Jul-2010   Kiron    K    Rahulan,   Abhayakumar K   Updated        review
                        Mathew M Mathew,                         comments from KSIDC.
                        Aju N Peter

1.0       11-Aug-2010   Kiron K Rahulan          Abhayakumar K   Updated comments for
                                                                 KSIDC for BFD and IGC




                                        Page 2 of 87
                                                                               INDEX
1       INTRODUCTION ................................................................................................................................... 4
    1.1         PURPOSE ....................................................................................................................................................4
    1.2         SCOPE.........................................................................................................................................................4
    1.3         ABBREVIATIONS/DEFINITIONS.................................................................................................................4
2       BUSINESS FACILITATION DIVISION ........................................................................................ 4
3       BUSINESS DEVELOPMENT DIVISION ...................................................................................... 11
4       ADVISORY & STRATEGIC PLANNING DIVISION ............................................................... 15
5       PROJECT APPRAISAL DIVISION ................................................................................................ 20
6       SYSTEMS DIVISION ......................................................................................................................... 28
7       PLANNING DIVISION...................................................................................................................... 31
8       INDUSTRIAL INFRASTRUCTURE DIVISION ......................................................................... 36
9       FINANCIAL VETTING & RECOVERY .......................................................................................... 42
10 PROJECT MONITORING & DISBURSEMENT .......................................................................... 48
11 FINANCE AND ACCOUNT DIVISION ......................................................................................... 52
12 SECRETARIAL & LEGAL DIVISION ............................................................................................ 56
13 LAR COURT CASES MANAGEMENT ............................................................................................ 63
14 RIGHT TO INFORMATION ............................................................................................................. 64
15 HR & ADMIN ........................................................................................................................................ 66
16 MIS ........................................................................................................................................................... 80
17 EXISTING SOFTWARE AND HARDWARE DETAILS ............................................................ 81




                                                                           Page 3 of 87
1 Introduction
1.1    Purpose

Purpose of this document is to explain User Requirements Specifications for the proposed
integrated solution (could be an ERP) for KSIDC, based on the requirement specifications
formulated based on the discussions and study conducted at KSIDC.


This document shall be used for having a broad understanding of the required system and
thus helping vendors to understand and estimate the requirements. This document shall
also be a base document for the preparation of a detailed System Requirement Specification
(SRS) document.

1.2 Scope
Scope of the document is to summarize the KSIDC requirements for proposed integrated
solution / ERP system.

1.3 Abbreviations/Definitions

           URS             User Requirements Specifications
           TEFR            Techno Economic Feasibility Report
           DPR             Detailed Project Report
           DFR             Detailed Feasibility Report
           EIA             Environment Impact Assessment
           SLPC            State Level Purchase Committee
           SPV             Special Purpose Vehicle
           LAC             Land Acquisition Cases
           IGC             Industrial Growth Centre
           PIC             Project Implementation Committee
           PAD             Project Appraisal Division
           CIBIL           Credit Information Bureau (India) Limited
           ED              Executive Director
           EC              Executive Board



2 Business Facilitation Division
Overview

The Business Facilitation Division work along with Business Development department deals
with

      Business facilitation to promote Kerala Industry
      Foreign Delegates visit management
      Investor meets management
      Sending delegation to foreign countries.


                                        Page 4 of 87
      Road shows.
      Publicity Activities.


Business Facilitation Section-Activity Planning & Scheduling

      Major activities that come under business facilitation division are facilitating major
       investments, Promotion & publicity, discussions with prospective investors, visiting
       delegations & dignitaries, participation in meetings, organizing seminars and road
       shows towards marketing Kerala, Sending delegation to foreign countries,
       correspondence on project proposals towards their development, communication
       with industry associations & chambers of commerce, co-ordination with govt.
       departments whenever necessary. This division conducts events like Investor Meets,
       Seminars, etc.for increasing Publicity for KSIDC and industrial climate of Kerala. Also
       send invitations to business delegations to visit Kerala.




                                         Page 5 of 87
Schedule plan & activities for a period as planned / scheduled will be Business Facilitation
tasks like the following below
      Sending delegation to foreign countries.
      Road shows.
      Promotion & Publicity.
      Any other tool identified for business development.
      Publicity for KSIDC and industrial climate of Kerala.
      Investor Meets, Seminars, etc.
      Inviting business delegations to Kerala




                                         Page 6 of 87
Existing System Workflow




Reports/Registers


   Various Correspondence for the delegation, road shows, advertisements, publicity,
      seminars, meeting details etc.



Single Window Clearance

     Monitoring and co-ordinating the activities of the State Board
     Expediting the clearances for new projects with the concerned departments in Govt.
     Clearing any bottlenecks that arise in the process
     Single point contact for all clearances in the Medium & Large scale Sector
     Arranging periodic meetings of the Board preparing the agenda and minutes for the
      meeting
     Special meetings at Private Secretary (Ind.)/Chief Secretary level as and when
      required ,to resolve specific issues faced by units

                                       Page 7 of 87
  .

Reports/Registers


     Single Window Clearance Details Register: This includes details like Applicant name,
      Applicant details, Present Status of application, Information details, Clearance details
      and Meetings details (Agenda & Mom‟s).
     Various Correspondence for the Single window clearance


Sale Tax Exemption and Subsidy

     Advise and assist units on matters relating to Subsidy and Sales Tax
     Issue Eligibility certificates for Sales Tax Exemption
     Co-ordinate with Commissionerate of Taxes for issue of final certificate
     Provide any additional information sought by Commissionerate of Taxes regarding
      Sales Tax
     Attend State Level Committee meetings for Subsidy and Sales Tax
     Issue of Subsidy Sanction letters; receive and scrutinize subsidy agreements
     Co-ordinate the sanction and disbursement of subsidy funds
     Provide information to Govt. on a periodic basis on these areas
     Recommend and co-ordinate with State Govt. on any issues raised regarding Subsidy
      & sales Tax
     Suggest/facilitate amendments and clarifications to Govt. orders on incentives,
      wherever necessary.
   .
Existing System Workflow




                                        Page 8 of 87
Reports/Registers


     Sales Tax/ Subsidy Register: Details like Date of Application, Company Name, Date
      of Meeting, Amount, Amount Passed, Amount Distributed etc. In the case of Subsidy
      additional details like Subsidy Amount, Date of Subsidy Agreement Executed,
      Subsidy sanctioned and Subsidy Released.
     Subsidy related correspondences
     Subsidy Sanction Letters
     Subsidy Agreements
     Sales Tax Correspondences
     State level committee Sales tax exemption
     Eligibility certificate for Sales tax exemption

                                          Page 9 of 87
Other Reports/Registers


       Advertisement Details Register

Proposed System Requirements


Req.     Requirement                                      Must    Desired   Remarks
No                                                        Have?
R.1.1    The proposed system should have a                Y
         mechanism to plan and schedule
         Business Facilitation activities for a
         period (for a year normally). The
         activities that could be planned /
         scheduled shall be Business Facilitation
         tasks, Foreign Delegates visits, Investor
         meets, Advertisement Plans etc.
R.1.2    The proposed system should be capable            Y
         to record the progress of each scheduled
         activity with its current status and action
         taken details.
R.1.3    System should have a facility to register        Y
         an activity for Single window clearance.
R.1.4    Facility to schedule sub activities related      Y
         to the registered single window activity.
         (The sub activities could be monitoring
         and co-ordination activities between
         board and various Govt dept activities,
         expediting details etc)
R.1.5    Provision for tracking and updating the          Y
         status of sub activities related to single
         window with its details like obstacles
         faced, solutions, meeting outcomes etc.
R.1.6    System should have facility to generate          Y
         reports to track the status of various
         activities and sub activities.
R.1.7    System should be capable to register the         O       Y
         activities related to sales tax exemption
         and subsidy.
R.1.8    System should be able to initiate the sub        O       Y
         activities related to the main activity
         registered related to sales tax exception
         and subsidy. The sub activities could be
         Eligibility verification, necessary approval
         process,       meetings      &     decisions,
         coordination activities and Issue of
         Eligibility certificates for Sales Tax
         Exemption etc


                                          Page 10 of 87
R.1.9     System should be able to update the                Y
          action performed against each activity
          with its current status. Approvals or
          rejections    of   subsidy    exceptions,
          subsidies etc shall be some of the final
          statuses of these activities.
R.1.10    System should have the facility to                 Y
          retrieve the captured information at any
          point of time to track its status with
          available details.
R.1.11    Vendor list of advertisement agencies              O
          could be maintained
R.1.12    System shall have facility to capture the          O
          details of entrepreneurs and maintain the
          database for this.


* O  Optional

3 Business Development Division
The Business Development Division deals with the following activities.


Core Activities
         1. Mega Projects Management
         2. Mega Projects Facilitation


Workflow – Project Development


        1. Yearly Working Plan with monthly spilt up is prepared. Various Activities are listed
           in the Working plan.
        2. Monthly Working Plan is allocated to various Managers.
        3. Activities contain Seminars, Investment, Communications (via mail, phone etc)
           meets etc.
        4. Monthly newsletter – print & sent e-copy to mail list
        5. Capture present status of various projects under development.
        6. Fund needed for various events is allocated by Board of Directors.
        7. Status of each event is reviewed in monthly basis.
        8. A file is maintained for each project, which contain and status of each project and
           review details. Details include project details, Party details, employment details,
           investment amount details etc.
        9. Indentify investor by investors meeting in Kerala./other capitals
        10. Project development & profiles
        11. Project idea development
        12. Identification & acquisition of land for projects



                                             Page 11 of 87
Workflow – Mega Projects Management
  1. Govt of Kerala appoints KSIDC as nodal agency for a project. (Project development
     can be also done without appointment KSIDC as Nodal Agency)
  2. KSIDC Board approves the Government proposal.
  3. Engaging consultant for TEFR, DPR, DFR, EIA, other studies etc:
  4. Land acquisition
         a. SLPC meeting
         b. Agreement with land owners
         c. Document/Award under section 11(2)
         d. Taking possession and payment
  5. Fine-tuning Project Implementation Strategy and plan
         a. Assessment of fund availability/required fund and decision on phasing out of
            project implementation
         b. Identification of potential occupants of the project
         c. Interaction with Consultancy
         d. Preparing detailed project implementation strategy and plan
  6. Fund Mobilization
         a. Identification of various fund sources.
  7. Promotion and Marketing
         a. Creation of database of potential occupants
         b. Formulation of marketing strategy
         c. Preparation of marketing toolkit-brochures, CDs, Website etc.
  8. Development of master plan
         a. Positioning of the consultant
                 i.    Preparation of RFP
                 ii.   Inviting EOI (Expression of Interest)
                iii.   Evaluation of proposal
                iv.    Appointment of consultant
                 v.    Performance of the work
  9. SPV formation (By Secretarial Division)
         a. Drafting & vetting of Memorandum of Association, Articles of Association and
            placement for approval
         b. Approval of Memorandum of Association & Articles of Association from Board
            of KSIDC / Govt of Kerala
         c. Company formation (Formalities with Registrar of Companies & incorporation
            of the Company)
  10. Development of Basic Infrastructure like power, water, approach road etc:
         a. Appointment of Architect/consultant
         b. Preparation of Detailed Engineering Design
         c. Approval of Engineering Design
         d. Tender preparation
         e. Tender publication, Finalisation & Award
         f.   Commencement of Creation of Infrastructure


                                        Page 12 of 87
11. Development of Common Infrastructure
      a. Appointment of Architect/consultant
      b. Preparation of Detailed Engineering Design
      c. Approval of Engineering Design
      d. Tender preparation
      e. Tender publication, Finalisation & Award
      f.   Commencement of Creation of Common Infrastructure


**** The activities will change depending on the nature of the project


Existing System Workflow




                                   Page 13 of 87
Business Development Division


                 Start




                                 Govt of Kerala appoints KSIDC as nodal
                                          agency for a project




                                                  No
        KSIDC Board approves


                      Yes


         Engaging consultant




           Land acquisition




Project Implementation Strategy and plan




           Fund Mobilization




       Promotion and Marketing




      Development of master plan




             SPV formation




  Development of Basic Infrastructure




 Development of Common Infrastructure




                  END
                                                                          Page 1


              Page 14 of 87
Files/Registers Involved


   1. Annual Work Plan
   2. Concerned file with note file
   3. Monthly action Diary


Proposed System Requirements

Requirements List
Req.     Requirement                                     Must    Desired   Remarks
No                                                       Have?
R.2.1    The proposed system should manage and           Y
         maintain various activities related to
         Mega Projects Management. There should
         a     provision     to   add/delete/modify
         activities related to each project as
         activities will change depending on nature
         of the project.
R.2.2    Provision for status tracking of various        Y
         activities & Projects based on the
         Annual/Monthly working plan.
R.2.3    Provision for generating various reports        Y
R.2.4    The proposed system should generate             Y
         Alerts for pending Project Activity/Tasks.
R.2.5    System should have a facility to register       Y
         main activities like land acquisition,
         preparation of EOI, RFP, etc
R.2.6    Facility to schedule sub activities related     Y
         to the registered main activities. The sub
         activities could be monitoring and status
         tracking should be there.




4 Advisory & Strategic Planning Division

The Advisory & Strategic Planning Division deals with the following activities.


Core Activities
   1. Constituency Project Development
   2. Project Advisory Activities
   3. Strategic/Corporate Planning Activities

                                         Page 15 of 87
Workflow - Constituency
  1. Constituency Details include Area details, Potential Survey, Economic Survey &
     Project details.
  2. Each Constituency will occupy different Projects. The project development process
     involves the following steps.
            Project identification
            Project profile creation
            Project Implementation details through DPR – Detailed Project Report
            Project Implementation
  3. Investment decision will be based on the Project report.
  4. Project Financing tie-up
  5. Project Implementation and review process
  6. Handing over of project to a Party/Company.


Workflow - Consultancy
  KSIDC undertakes Consultancy work for the following sectors.
         a. Government Companies
         b. Private Companies
         c. Semi-Government Companies


   The workflow for Consultancy work is as follows.
   1. Initial Meetings/Discussions with Clients.
   2. Submitting the offer based on man hours/days input.
   3. Getting MD‟s approval for the study/assignment.
   4. Executing the Project work in time
   5. Obtaining the fees for the consultancy project
  1. Submitting the Consultancy Report. Consultancy report includes the following
              a. Feasibility Report
              b. Market Survey details
              c. Offer Details
              d. Quotation Details
              e.   Detailed Project Report




                                        Page 16 of 87
   Existing System Workflow




Files/Registers Involved


   1. File no: 1887/66. This file is used for registering new consultancy enquires for
      submitting the offer.



                                       Page 17 of 87
2. Note File: Notes are put-up to MD for approval of assignment to be undertaken.
   Once it is approved proposal is submitted to party.

3. Project Report

4. Board Agenda Notes

5. Notes




                                   Page 18 of 87
Proposed System Requirements

Use Case Diagram




Requirements List
Req.    Requirement                                     Must    Desired   Remarks
No                                                      Have?
R.3.1   The proposed system should manage and           Y
        maintain   the   Constituency       Project
        Development details and activities.
R.3.2   The proposed system should manage and           Y
        maintain various Constituency project
        development details and activities.
R.3.3   The proposed system should generate             Y
        Standard formats of Proposals.
R.3.4   The proposed system should manage and           Y
        maintain the Consultancy Project details.
R.3.5   The proposed system should be able to           Y
        track the various status of undergoing
        projects, both Constituency projects and


                                        Page 19 of 87
          Consultancy projects.
R.3.6     The proposed system should be able to           Y
          manage information sharing to other
          KSIDC departments and viz.
R.3.7     Provision for generating various reports        Y
          like List of projects with status,
          Completion reports,
R.3.8     Provision for updating and tracking             Y
          Annual plan of the corporate/companies.
R.3.9     Provision for updating and maintaining          Y
          details for various Consultancy agencies
          available with their area of expertise and
          contact details.
R.3.10    The proposed system      should be able to      Y
          track and define         various Strategic
          Planning Activities of   KSIDC and should
          be able to track the     status and action
          taken details.



5 Project Appraisal Division
Overview

The Project Appraisal Division deals with prospective investors / entrepreneurs to initiate
project in state of Kerala by assisting them for project report, Initiating the processing
Loans, financial vetting and approving the appraisal report. Core activities of the
department are

        Project Initiation
        Project Sanction


Project Appraisal Section

Major activities that come under PAD are initial discussions along with project report
preparations, data sheet collections, initiate bank enquiry, legal , site visit, creating project
note, approval process, loan process, appraisal note, final approval & co-ordination within
the departments whenever necessary especially with legal and Financial division




                                          Page 20 of 87
Project Appraisal Initiation and Approval


      Starts with Discussions with prospective investors/entrepreneurs
      Data sheet is collected from Individual/Company, in respect of Promoter
       Directors/Key promoters
      Bank Reference is taken on the company/promoter
      CIBIL - Credit Information Bureau (India) Limited enquiry/status of the promoter is
       taken (Optional)
      Affidavit for Solvency is taken from the Key promoters/guarantors.
      Scrutiny of land documents by legal departments
      Site Visit is conducted by PAD.
      Project Note is prepared.
      Preliminary approval from MD for detailed project appraisal is placed along with
       Project note
      Processing Fee is collected from the Promoter.
      Once approval is got from MD, detailed project appraisal process is started. This
       includes various discussions/meetings with Promoter. Various Communications
       regarding different clarifications are taken from the Promoter at this stage.
      Loan application (priced) is given to Promoter
      Appraisal note is prepared with all project particulars.



                                         Page 21 of 87
      This appraisal note (Land details, Land Development details, Civil Works details,
       Plant and Machinery details, Utilities details, Miscellaneous Fixed Assets details,
       Deposit details, Preliminary & Pre-operative Expenses details, Contingencies details
       and Working Capital details) is sent to Financial Division for financial vetting.
      Remarks from Financial Vetting Division are incorporated in the appraisal report.
      The final report is forwarded to MD (Managing Director) through Executive Director
       (ED) for approval.
      Finally the report is placed before the Board/EC for final approval.


If the project is in Tourism sector, the proposal will be placed before an Expert Committee
for their views/recommendations, before finalising the appraisal report.




                                         Page 22 of 87
Existing System Workflow




                           Page 23 of 87
Reports/Registers

     Data Sheet – Individual
     Data Sheet – Company
     Affidavit for Solvency of key promoters/guarantors.
     Loan Application Form
     Detailed Project Report

                                      Page 24 of 87
   Credit rating to fix interest rate for loan
   Appraisal Memorandum
   Financial Statements
       o   Cost of Project and proposed means finance
       o   Projected Cash Flow Statement
       o   Viability Indicators
       o   Initial Data capture and its validations
       o   Projected Cost of Production & Profitability
       o   Projected Balance Sheet
       o   Income tax calculation
       o   Sensitivity analysis
       o   Depreciation Calculations
       o   Working Capital Requirements
       o   Interest & Repayment of Principal Calculations




                                       Page 25 of 87
Proposed System Requirements

Use Case Diagram – Initiation and Sanction




                                  Page 26 of 87
Requirements List


Req. No     Requirement                                 Must    Desired   Remarks
                                                        Have?
R.4.1       System shall have the facility to           Y
            maintain all the Activities and its
            related sub activities with respect to
            project    appraisal   (initiation and
            sanction).
R.4.2       Action status and details with respect      Y
            to each sub activities should be
            captured as part of the proposed
            system.
            Following are the activities and sub
            activities that could be coming under
            project appraisal division.
R.4.3       The proposed system should manage           Y
            and maintain discussion details and
            member details and actions taken
R.4.4       Provision to capture the Data Sheet         Y
R.4.5       The proposed system should manage           Y
            and maintain the   bank  and CBIL
            Enquiry details
R.4.6       The proposed system should manage           Y
            and maintain the Affidavit details and
            track its status
R.4.7       The proposed system should manage           Y
            and maintain the land details from
            legal section
R.4.8       Provision to store site visit details and   Y
            members attended and action taken
R.4.9       The proposed system should manage           Y
            and maintain Project note
R.4.10      Provision to track the approval process     Y
R.4.11      Provision to store and view of process      Y
            fess details
R.4.12      The proposed system should manage           Y
            and maintain the details to Initiate
            loan
R.4.13      Provision to manage and maintain            Y
            appraisal note
R.4.14      The proposed system should manage           Y
            and maintain and track /Initiate Fin
            vetting and its status


                                        Page 27 of 87
R.4.15       The proposed system should manage           Y
             and maintain Initiate MD approval
             process and track its status
R.4.16       Provision   for   generating various        Y
             reports

6 Systems Division
The Systems division deals with the following activities.


Core Activities
   1. Hardware Purchase
   2. System Maintenance
   3. Network Administration, Net Connectivity, Web Maintenance, Video Conference,
      Presentation through LCD


Workflow Details


   Purchase


   Small Purchase
   1. Request letter is obtained from the concerned department.
   2. Approval is taken System Head
   3. Purchase is done from Keltron
   4. Item is handed over to the requested person.


   Large Purchase
   1. Request is obtained from various departments
   2. A Committee along with ED will be formed for approving the purchase.
   3. Once the committee approves, Advertisement is done.
   4. Tenders will be processed.
   5. Purchase will be made from the Vendor, selected by the committee
   5. Item handed over to the requester.


   System department holds the details of PC‟s and Servers owned by KSIDC.


   Maintenance


   1. Issue will be communicated directly or through phone.
   2. Systems department will rectify the issue.




                                         Page 28 of 87
Existing System Workflow




Files/Registers Involved

                           Page 29 of 87
Purchase Register
Purchase details of Computers, Printers, UPS, Laptops, Cartridges etc

Proposed System Requirements

Use Case Diagram




Requirements List
Req.    Requirement                                    Must    Desired   Remarks
No                                                     Have?
R.5.1   The proposed system should have the            Y
        facility to manage and track various
        Purchase related activities.
R.5.2   The proposed system should also contain        Y
        the history of purchase details.
R.5.3   The proposed system should contain             Y
        input facility for various Service/Issue
        calls. The issues related to systems
        should be logged through the system and
        should be tracked. Alerts should be there


                                       Page 30 of 87
         for pending issues.
R.5.4    The proposed system should contain              Y
         option for updating website related things
         from various departments, which can be
         used for KSIDC website updating.
R.5.5    The proposed system should contain the          Y
         details of PC‟s and Servers owned by
         KSIDC.
R.5.6    The proposed system should contain the          Y
         details of internet and broadband
         connections
R.5.7    The proposed system should contain the          Y
         details of internet and broadband
         connections
R.5.8    The proposed system should generate             Y
         alerts for periodic maintenance of Video
         conferencing,      Audio    conferencing
         equipments etc



7 Planning Division
The Planning Division deals with the following activities.


Core Activities
   1. Planning
   2. Library Management
   3. Legislative Assembly Interpellations
   4. Statistics


Workflow – Planning
   1. Planning starts from collection of data from various departments of KSIDC
   2. Value addition is done by planning department, like employment generation details,
      economic factors etc.
   3. Plan is prepared and sent to approval through GM‟s, ED, and finally MD.
   4. Once approved it is send to various government departments (Industries dept.,
      Planning board and Finance dept.)
   5. Follow-up with State Planning Board and Govt. for budget allocation
   6. Government will allocate funds for the plan through budget/budget speech.
   7. Then project report/proposal has to be got prepared from the Project department.
   8. The report is submitted to government.
   9. Follow up with DIC is done for the release of funds.
   10. Collection of funds from treasury through cheques.
   11. Furnish quarterly and mid-term plan implementation reports to Govt. and Planning
       Board


                                         Page 31 of 87
  12. Submit reports for Subject Committee of the Legislative Assembly
  13. Preparation of Budget and Business Plan of KSIDC


Existing System Workflow




                                     Page 32 of 87
Workflow – Library Management


                                Page 33 of 87
   1. KSIDC library is managed by LibSys library management system.
   2. Library has to collect and provide all published information to employees of KSEB,
      industrialists and entrepreneurs, research scholars.
   3. CMIE: I-Cube Service (To provide authentic data on Corporate and Economies)


Workflow – Legislative Assembly Interpellations
   1. Furnish draft answers to the Interpellations and submissions of Kerala Legislature &
      Indian Parliament
   2. Attend the Question Answer Hour and demand days of industries in the Assembly


Workflow – Statistics
   1. Maintain the statistics on various activities of KSIDC like MoU signed, projects
      cleared by Board, number of units commissioned, Closed units, Sick units etc, and
      the financial data on sanctions and disbursements, recovery, profit     since its
      formation in 1961
   2. Provide material for the statistics preparation of the annual report
   3. Build up the industrial statistics on Kerala and provide industrial data for various
      purposes like Economic Review of State Planning Board, CMIE etc.
   4. Compilation of Industrial directory of kerala


Files/Registers Involved
   1. Scheme files on Planning, Statistics, Library, Information Service, Nominee Director
      etc.
   2. Register of books & Periodicals
   3. Reports & publications (Accession register, Issue Register etc)
   4. Register of LA Interpellations
   5. Register of Sales of Industrial directory
   6. R & D directory


Proposed System Requirements

Use Case Diagram – Single Window Clearance




                                        Page 34 of 87
                                                        Planning




                                         *                                              *                     *
                                     *                                                   *
                                                          Planning
                                                                                                          *
                                                                                                          *
                 *
                  *
                   *
                                                                                                                  Projects Dept
                  *                      *
                                                     Library Management


 Planning Dept
                                                                                                                  *
                                                                                                              *
                                                                                                              *

                 *                           *                              *
                  *                                                                 *
                                                     Legislative Assembly
                                                        Interpellations

                                                                                                        KSIDC assisted companies


 Accounts Dept                                                                  *
                                             *   *                                  *

                                                          Statistics




Requirements List
Req.        Requirement                                                     Must             Desired   Remarks
No                                                                          Have?
R.6.1       The proposed system should manage and                           Y
            maintain   the   various  activities in
            planning.
R.6.2       Provision for collect data from LibSys                          Y
            (library management system) to the new
            system
R.6.3       The proposed system should manage and                           Y
            maintain the various details of Legislative
            Assembly Interpellations.
R.6.4       The proposed system should manage and                           Y
            maintain statistics on various activities of
            KSIDC.
R.6.5       Provision for generating various reports                        Y
            on    Planning,  Library   Management,
            Legislative Assembly Interpellations and
            Statistics




                                                      Page 35 of 87
8 Industrial Infrastructure Division
Overview

The Industrial Infrastructure Division of the Corporation is aimed at procuring large extent
of land to set up Industrial Growth Centres/estates in different locations in the state.
Infrastructure facilities like, road formation, drainage, water supply, power, common
effluent treatment facilities etc created and small plots are demarcated and allotted to
prospective entrepreneurs to set up various industrial units

Industrial Infrastructure Section

Major activities that come under Industrial Infrastructure are


      Procurement of land
      Developing infrastructural facilities
      Demarcation of plots
      Allotment of plots to set up industrial units
      Maintain and provide service to the allotters
      IGC Accounting

Industrial Infrastructure work flow


    1. Land is obtained from 1) Government directly 2) from Private Party through
       negotiated purchase or taken through the acquisition route
    2. Preparation of the sketch through detailed survey of the land by revenue
       department/private agencies
    3. Mutation of land in favour of KSIDC.
    4. Invitation of offers from Architect firms for preparation of master Plan
    5. Selection of Architect firm by PIC
    6. Preparation of master plan by Architect
    7. Design, drawings and estimate preparation by Architect for basic infrastructure
       development like site levelling, roads, drains, electricity distribution, water
       distribution, common effluent treatment etc
    8. Demarcation of industrial plots and preparation ofsketch
    9. Tendering of works for infrastructure development
    10. Pricing of plots considering basic land cost, additional compensation, infrastructural
       development etc
    11. Advertisement inviting entrepreneurs for sale of plots.
    12. Receipt of application for plot allotment
    13. Selection of entrepreneurs and plot allotment by PIC
    14. Process of Plot allotment trough
    15. Initial Intimation Letter, Collection of Upfront Fee, Plot Allotment letter, Collection of
        50% Lease premium, Licence Agreement , Collection of balance 50% within two
        years , Lease Agreement etc


                                           Page 36 of 87
   16. Monitoring of the activities in the plots allotted and capture of repayment



Existing System Workflow




                                        Page 37 of 87
Reports/Registers

Reports on the firms to which whom land/built-up space allocation has been made.

   1. Reports on lease rent paid
   1. Reports on arrears in lease rentals,
   2. Common expenses arrears

Proposed System Requirements




                                       Page 38 of 87
Use Case Diagram – Initiation and Sanction




                                  Page 39 of 87
IGC Accounting
Payments from IGC relating to general expenditure like Petty Cash, other major contracts, Legal
Expanses, Contract employee’s payments etc are done from KSIDC. From KSIDC all these will be
marked as a single entry debiting IGC account (923 A/C). Split-up for each debit/credit has to be created
in IGC accounting.
IGC Correspondences: All correspondences related to IGC activities.
Lease Management
The management of allotters, companies details etc at IGC. Details include Lessee details, due details,
down payment details etc. Monitoring and managing their activities. Collection of various payments
related to infrastructure development. Utility management like Water charges, Maintenance Charges,
Electricity Charges etc.
Salary Charging for KSIDC Employees
Based on the KSIDC employee’s activities for IGC related tasks, particular amount has to be marked as
IGC contribution and has to be accounted with IGC expanse.
Contract Work Management
Contract workers management and their payment details.

Registers
Expense details report/contract file etc
Progress Report Legal details – MIS report


Requirements List


Req. No       Requirement                                    Must       Desired      Remarks
                                                             Have?
R.7.1         System should have facility to register        Y
              IGCs. The IGC should contain details
              like Land details, area details, location
              details etc.
R.7.2         Proposed system should be able to              Y
              plan and schedule the development
              activities for each IGC. This could be
              construction     of   roads,     common
              facilities & infrastructure, buildings,
              plots etc.
R.7.3         Sub activities could be planned for the        Y
              execution of each planned activity.
              Tender process and related selection
              process could be part of such sub
              activities.
R.7.4         System should be able to track and             Y
              record the progress of each of the
              planned activity / sub activity.
R.7.5         Proposed system should be able to              Y
              capture     all   the   legal    disputes
              registered and continuously do the
              progress update related to these
              cases.



                                             Page 40 of 87
R.7.6    System should have a provision to               Y
         view       the      IGC      infrastructure
         components        (plots   buildings    etc)
         graphically. System should be capable
         enough to project the allocation and
         availability details of each of these
         components.
         Graphical view of the allocation details
         with respect to each plot and building
         should be available.
R.7.7    System should have an option to apply           O
         online for the IGC facilities.
R.7.8    System should be able to define the             O
         mandatory documents required with
         respect to each facility request.
R.7.9    Proposed system should be able to               O
         capture the required documents as
         attachments during the application
         process.
R.7.10   System should have an approval work             Y
         flow    for    finalizing   the    received
         applications and decide the allocations.
R.7.11   As part of the application approval             Y
         process, system should have a
         mechanism to refer the application to
         YPIC and capture the status based on
         that.
R.7.12   System shall have a facility to define          O
         the pricing factors for each IGC
         component and apply this for doing the
         pricing.
R.7.13   System shall have a facility to manage          O
         various advertisement activities related
         to IGC.
R.7.14   The proposed system should manage               Y
         and maintain the lease details
R.7.15   Proposed system should be capable               Y
         enough to define repayment schedules
         corresponding to applications and
         collect and track the repayments
R.7.16   System should have a provision to               Y
         define     various      concurring     costs
         applicable to IGC. (Eg: Water charges,
         Maintenance         Charges,      Electricity
         Charges etc.). Also, there should be
         provision to capture the payments with
         respect to this and mechanism for
         periodic reminders for the same.
R.7.17   System shall have a facility to do the          O
         reverting and cancellation of a PIC
         approved application.         The officers
         involved during the approval process

                                        Page 41 of 87
             are also captured along with this
             process so that system shall generate
             required reports based on this.
R.7.18       The proposed system should manage           O
             and maintain the built-up area
             availability and it needs to be available
             to public
R.7.19       IGC accounting activities will be done      Y
             separately. This will be considered as
             a division / sub company of KSIDC
             common accounting system. Each IGC
             account will be reflected in KSIDC
             accounting      system.   The    detailed
             entries and reports of the IGC account
             will be available only from the IGC
             accounting section.
R.7.20       System should have facility to do           Y
             charge allocation (costing) to IGC and
             do the accounting for that. Eg: Salary
             allocation of KSIDC resources worked
             for IGC.
R.7.21       Provision     for   generating    various   Y
             reports

9 Financial Vetting & Recovery
The Financial Vetting & Recovery Division deals with the following activities.


Core Activities
   1. Financial Vetting
   2. Project Monitoring & Recovery
   3. Change of Management
   4. Liquidation Process
   5. One Time Settlement
   6. Share Investment Details


Workflow – Financial Vetting
   1. Appraisal note is obtained from Project Appraisal division as well as their Note file.
   2. Checks the following financial indices.
           a) Debt-to-Equity Ratio
           b) Debt Service Coverage Ratio
           c) Internal Rate of Return – IRR
           d) Security Margin details
           e) Interest rate grading
   3. Based on the financial indices analysis, comments are raised in the Note file and sent
      to Project dept. for their consideration.
   4. Project team rechecks the comments and with replies forwarded the Note file to ED
      and MD

                                         Page 42 of 87
Existing System Workflow




Workflow – Project Monitoring & Recovery
   1. After the Project Implementation is over, the project file will come to recovery
      department for regular follow-up.
   2. Quarterly Performance Report is taken from the Company/Party
   3. Review meetings are conducted with the Party
   4. The Recovery team does Site Visit/Inspection.
   5. Default review meeting is conducted if any payment default is there.
   6. Inter Institutional meetings (IIM) are conducted/attended in the case of joint
      financing.
   7. Rescheduling for Principle amount is done if requested by the Party
   8. Based on the inspection report agenda notes are prepared for the consideration of
      the Board

                                       Page 43 of 87
  9. Rescheduling for interest is also done in select cases.
  10. Revenue Recovery – RR will be initiated against the Party if found default.
  11. MD‟s approval is required for RR processing
  12. Once RR is initiated, follow up is done with Tahsildar
Existing System Workflow




                                       Page 44 of 87
Project Monitoring & Recovery


                  Start



 Quarterly Performance Report is taken
           from the Company




           Review meetings




               Site Visit




  Review meeting is conducted if any
          payment default



  Inter Institutional meetings (IIM) are
conducted in the case of joint financing




  Rescheduling for Principle amount




 Based on the inspection report agenda
          notes are prepared




       Rescheduling for interest




   Revenue Recovery will be initiated
    against the Party if found default




                                           No
          MD approval for RR




                          Yes


      RR follow up with Tahsildar




                  END
                                                Page 1



             Page 45 of 87
Workflow – Change of Management (Company/Party)
   1. Existing party has to give application for change of management
   2. New party has to provide acceptance letter
   3. New party has to provide security details
   4. KSIDC will approve the change of management after verifying the documents.


Workflow – Liquidation Process
   1. KSIDC will initiate the Liquidation process when statutory dues are very high.
   2. KSIDC will apply to the Official Liquidator.
   3. Follow-up with the Liquidator about the status.
   4. Liquidator will give the proceeds to KSIDC after the Sales process is over.


Workflow – OTS - One Time Settlement
   1. Party will submit application for OTS.
   2. KSIDC will do negotiations with the Party.
   3. After that the File will be sent to Board for approval.
   4. Schedule for OTS is created. Normally 50% down payment and rest in 1 year.
   5. Follow-up with the Party for payment.
   5. Revenue Recovery – RR will be initiated against the Party if found default.


Workflow – Share Investment Details
   1. Investment details
   2. Dividend details and Follow-ups if required.
   3. Buyback Follow ups if buyback agreement exists.
   4. Sale Value calculation As On Date based on market value, Dividend and Bonus
      Shares.
   5. History of all Share related activities.


Files/Registers Involved
   1. Scheme files
   2. Note file


Proposed System Requirements

Use Case Diagram – Single Window Clearance




                                         Page 46 of 87
                                        Financial Vetting & Recovery



                                                                                  *                   *
                                        *
                                                         Financial Vetting




                    *
                     *                                                                                      Projects Dept
                      *                  *
                      *                                                           *
                                        *               Project Monitoring
                                                           & Recovery
                          *


                                                                                                        *
 Vetting & Recovery Dept                                                                              *
                                                                                                      *
                                             *                                    *
                                         *
                                                            Change of                                 *
                                                           Management


                 **                                                                                          Legal Dept
                   *
                       *
                                                *                                 *
                                            *
                                                        Liquidation Process


    Accounts Dept



                                             *      *                         *

                                                        One Time Settlement




Requirements List
Req.        Requirement                                                 Must          Desired   Remarks
No                                                                      Have?
R.8.1       The proposed system should manage and                       Y
            maintain the various activities of Financial
            Vetting process for various projects.
R.8.2       The proposed system should manage and                       Y
            maintain the Project Monitoring &
            Recovery activity.
R.8.3       The proposed system should manage and                       Y
            maintain the Change of Management
            process.
R.8.4       The proposed system should manage and                       Y
            maintain the Liquidation process.
R.8.5       The proposed system should manage and                       Y
            maintain the One Time Settlement

                                                    Page 47 of 87
        process.
R.8.6   The proposed system should manage and            Y
        maintain the Share Investment Details.
R.8.7   Provision for generating various reports.        Y
R.8.8   Provision for status tracking of various         Y
        workflows.




10 Project Monitoring & Disbursement
Core Activities


   1. Project Monitoring & Disbursement


Workflow - Project Monitoring


   1. After Board approval, the Project details will come to Monitoring division.
   2. A new File for the project is opened with appraisal copy, board note, minutes of
      approval & sanction letter.
   3. Project documentation follow up details with KSIDC Company Secretary.
   4. Monitoring of delay in accepting our sanction letter and delay in executing
      documents.
   5. If the delay exceeds the stipulated time, alert the management for action to rectify
      the problems or else cancel the assistance.
   6. Preparation of periodical statements for cancellation of unavailed/ unutilised financial
      assistance.
   7. Various Communications with Promoter.
   8. Monthly Physical Progress report from promoter is taken.
   9. Bar chart is prepared to identify activity details that are processing parallel for a sing
      project.
   10. Preparation of undisbursed commitments showing the status of implementation.
   11. Preparation of statement on budgeted disbursements vis s vis actual disbursements
       effected.
   12. Calculation of interest during implementation provided in the appraisal to be
       adjusted against eligible disbursement.



Workflow - Disbursement


   1. After Board approval, the Project details will come to Monitoring division.
   2. A new File for the project is opened with appraisal copy, board note, minutes of
      approval & sanction letter.
   3. Project documentation follow up details with KSIDC Company Secretary.
   4. Various Communications with Promoter.

                                         Page 48 of 87
  5. Disbursement request along with the certificates from the chartered accountants
     regarding amount raised and spent to be obtained.
  6. Site visit is conducted
  7. Disbursement process is initiated. The payment is done using 3 Forms – Form A,
     Form B & Form C. Form A is used for the first payment. Form B for subsequent
     payment and form C for final payment.
  8. The disbursement check list will be send to vetting officer.
  9. Vetting Officer after verification will return back the file to ED
  10. ED will send this to MD for final approval, after MD‟s approval this will be send to
      Account for release of money.
  11. If not approved, file returned to ED with comments.
  12. File to be resubmitted after complying with the changes.


Existing System Workflow




                                        Page 49 of 87
Files/Registers Involved

                           Page 50 of 87
       Statement of Un-disbursed Commitments
       Statement of Anticipatory Disbursements
       Interest Recovery Statement

Proposed System Requirements

Use Case Diagram




Requirements List
Req.     Requirement                                   Must    Desired   Remarks
No                                                     Have?
R.9.1    The proposed system should have the           Y
         facility to manage and track various
         activities related to Project monitoring
         and Disbursement.
R.9.2    The proposed system should have the           Y
         facility to manage and track various
         communications with Promoter and with
         various KSIDC departments.
R.9.3    There should be alert facility for the        Y


                                       Page 51 of 87
        following actions.
        a) To collect company‟s board approval
        with in 30 days of sanction date.
        b) Completion of Documentation with in
        60 days of sanction date
R.9.4   Report on Implementation period delayed        Y
        projects,   i.e.   extended      beyond
        completion date of specified in sanction
        letter.
R.9.5   Provision to list, search, filter and          Y
        produce detailed, summary and status
        reports on project monitoring and
        disbursement activities.


11 Finance and Account Division

Note : - New software (ASP.NET & SQL) for Financial Accounting and Loan
Accounting is getting implemented. This will cater all the requirements of the
Financial Accounting Division. The new ERP should work closely integrated with
this system.

The Finance and account division deals with Projects, Disbursements, Recovery &
Monitoring, Legal divisions of KSIDC


FA work flow

        Acceptance of Cheques & Cash and issuing receipts thereon.
        Details of presentation of Cheques on due dates in the current account with
         HDFC/Central Bank of India/ ICICI bank as per instructions.
        Periodic Bank Reconciliation Statements
        Issue of Cheques & Cash Payments including advances for local purchases,
         payment of bills etc., as approved by DGM
        Disbursement of Salary, Medical Reimbursement, Conveyance allowance, TA
         advance, Reimbursement of Telephone bills and other expenses relating to
         employees of the Corporation as approved by DGM or as directed by Head Office.
        Sale of Loan application forms & Industrial directory
        Book keeping, Data entry & Voucher preparation– Financial Accounting and Loan
         accounting including appropriation of receipts into current account, interest &
         principal dues.
        Maintenance of Cheque Received Register/Payment Register/Service Tax
         Register/TDS Register/Journal Register
        Maintenance of Fixed Deposit Register and all works related thereto (opening,
         custody & closing of FD‟s and verification of interest workings )
        Maintenance and updating Fixed Asset Register
        Creation & modifications of Loan accounts including rescheduling, balance loan
         cancellations, interest or principal waivers/w-offs etc., as per the sanction letter
        Issue of Debit or Credit Notes in time to assisted units
        Settlement of advances including TA bills by employees of the Corporation as per
         the Rules.

                                       Page 52 of 87
           Deduction of personal calls and other amounts as per instruction of
            administration or as directed by HO.
           Preparation of monthly principal instalment due list & quarterly interest due list
           Preparation of Interest Rebate payable on loan accounts
           Providing details of Loan accounts to Projects/Recovery/Legal departments as
            and when required
           Preparation of monthly statements to Head office – Service Tax, TDS, HO Control
            a/c, Cash flow, FD, Sanction & Disbursement, Recovery including NPA Statement
           Preparation of Final Accounts including various statements, schedules and sub
            schedules



Loan accounting



            Effective dates for loan purposes: local cheques: the date of depositing with
             banks; outstation cheques- date of FD receipt or realization
            Appropriation- first towards current a/c dues; then interest and then principal-
             first to oldest account- unless the borrower specifies otherwise
            If current a/c dues are left out by mistake, then adjustment shall be done in the
             loan a/c, on the actual receipt date only
            All recoveries after the date of RR proceedings (not notice) shall go to the
             principal a/c only
            Similarly all OTS receipts shall go to first principal and finally to interest
            Loans shall be rescheduled by accounts dept., only after all the conditions are
             satisfied
            Interest shall be processed on 20th of every quarter and informed to the Client
            Monthly Principal demand notice by 25th of the preceding month
            Principal prepaid by the client can be adjusted towards subsequent interest fallen
             due only at the written request of the company-the date of such adjustment will
             be the due date of interest
            Excess interest credit “at the year end” shall be transferred to principal account
            All recoveries will be accounted on daily basis
            List of RR proceeding cases, sale of units and OTS cases may be maintained
            Cheque bouncing- notice asking for DD will be sent by Accounts.
            First interest due date will be the nearest quarter ending date
            Grace period of 7 days- cheque dated 30th/31st – if collected by 7th of next
             month- effective date will be the interest due date- no penal interest
            No prompt payment rebate from 1.4.2003 for all cases where interest rate has
             been reduced to 12%.
            Interest reduction to 12% may be done even after 30.6.2003
            If RRR is withdrawn in the same financial year, reverse all principal credits to
             interest, on the date of RRR withdrawal notice; interest reworking is required
            If RRR is withdrawn during the next FY, reverse similarly; interest has to be
             reworked.



Other Activities



            Issue of Notice on Cheque Dishonour cases


                                          Page 53 of 87
                NPA Classification
                Valuation of Investments
                Sale of Loan Application /Industrial Directory
                Audit coordination (Internal audit/ Statutory audit/CAG Audit)




Existing System Workflow

New software (ASP.NET & SQL) for Financial Accounting and Loan Accounting




Reports/Registers


          Cash Flow
          Sanction
          Disbursement
          NPA Analysis & Recovery Report
          HO Control Account reporting
          Fixed Deposits & Fund position
          TDS
          Service Tax
          Trial Balance
          General ledger
          Sub-ledgers
          Receipts/Payment register
          Journal
          Salary statement
          Fixed assets and Depreciation statement
          Annual Corporate Plan
          Cash flow statements
          Reports to RBI- ALM statement
          EPF
          Cheque/Cash receipt register
          Cheque Payment register
          Petty Cash Book
          FD Register
          Fixed Assets Register
          Post dated cheques register
          Attendance details



                                             Page 54 of 87
Reports based on loan/ledger

   Outstanding loan
   Arrears
   Disbursements
   Recoveries
   principal due list
   Interest due list
   Interest workings
   Arrear workings
   Interest simulation (forward and retrospective)
   Repayment schedules
   NPA statement




                                    Page 55 of 87
Proposed System Requirements

Most of the reports/registers are being prepared manually. Principal demand/Interest dues
demand generated manually. Atomisation of several routine activities is lacking which ends
up in delay/waste of manpower etc


The new ERP should be integrated with the new Accounting software


Requirements List


Req. No     Requirement                                Must    Desired    Remarks
                                                       Have?
R.10.1      The proposed ERP system should be          Y
            able to transfer all the financial
            accounting related entries to the
            existing financial accounting system.
            (ie, the existing financial accounting
            system should have a common
            interface available to receive the
            accounting transactions sent from the
            proposed ERP system)
R.10.2      All the other financial accounting         Y
            entries and generation of reports shall
            be executed by the existing financial
            accounting system.



12       Secretarial & Legal Division
Core Activities


   1. Legal Verifications & Loan Documentation
   2. Court Cases Management


Workflow - Legal Verification Before Project Sanction


   1. Before Sanction of project a Preliminary Scrutiny of Land is done by Legal
      Department.
   2. Prior Deed, Title Deed, Possession Certificate, Land Tax Receipt, Encumbrance are
      the documents used for initial verification.
   3. Company Secretary ( Head Legal) will assign the job to M(L)/AM(L)
   4. M(Legal)/AM(Legal) does the verification process and submits the report to the Legal
      Head.
   5. Head Legal will forward this to Project Head. Project head will forward this to
      concerned Project appraisal officer.



                                       Page 56 of 87
Existing System Workflow




Workflow - Legal Verification After Project Sanction


   1. Once the loan is sanctioned, duplicate sanction letter will come to Legal department.
   2. Legal department will collect security documents (Memorandum, Articles of
      Company, Possession Certificate, Non-Attachment certificate, Borrowing limit
      certificate) from Client/Party.
   3. In case of refinance to existing companies “Search report” is collected from Registrar
      of Companies.
   4. The Company‟s list of Director‟s details is collected from the Chartered Accountant.
   5. If collateral security is there, then Company has to give an additional board
      resolution of their Company.
   6. A new Affidavit is taken from the Party. This is cross-verified with the one obtained
      at the earlier stage of Project Appraisal.
   7. If all verification is done, then the Project will be taken for Documentation.
   8. Loan Agreement is prepared along with Deed of Hypothecation, Deed of guarantee;
      also following undertakings are taken from the party.
          a. Over Run and Short Fall
          b. Non-disposal of Shares
          c. Not to vacate office


                                        Page 57 of 87
       d. Not to withdraw the unsecured loan
       e. To abide by all sanction conditions
9. Mortgage taking (Declaration process).
10. Update the Encumbrance to cover the date of Mortgage.
11. Charge will be registered with registrar of properties
12. Registrar of Companies ROC will issue the Certificate of registration.
13. Follow up with the company for Insurance.
14. Disbursement note is generated and send to Head Legal




                                     Page 58 of 87
Existing System Workflow




                           Page 59 of 87
In the case of corporate Guarantee, Borrower Company has to produce and deposit
corporate guarantee from the new company. Memorandum and Articles of new company are
taken. Borrowing limit certificate is taken from the new Party.


In the case of Pledging of Shares, an agreement has to be executed with the new company
and the existing party.


In the case of Collateral Land, land documents are collected and additional mortgage is
taken. Intimation is sent to Tahsildar and Village officer about this transaction, title
documents of his properties purported to be mortgaged together with prior deeds,
Encumbrance Certificate, tax paid receipt, possession certificate


Legal Cases Management: Cases are of the following types
      High Court Cases
      Civil court Cases
      Consumer Court Cases
      Dept Recovery Tribunal – DRT Cases
      Criminal Complaints Etc.


Statement is filed once notice is received. Frequent follow-ups are taken. Windup cases,
once wound up it will move to official liquidator. Follow-ups with official liquidator for selling.
Supporting documents has to be produced when liquidator invites for the same.


BIFR - Board for Industrial & Financial Reconstruction cases follow-ups.
Section 29 Cases follow-ups for selling.
LAR Cases follow-ups (Life Science Park).


Board Meeting Management
   1. Organise board meeting and intimation is sent to concern Directors/Officers.
   2. Compilation of Agenda and coordination with Departmental/Divisional heads.
   3. Forwarding Agenda notes to the Directors.
   4. Prepare minutes of board meetings and distribute to the Directors.
   5. Maintain details of each board meetings.
   6. Ensure minutes are distributed to members shortly after meeting.
   7. Issue sanction letter to companies after Board sanction in consultation with Project
      Appraisal Division.


SPV Formation
           a. Drafting & vetting of Memorandum of Association, Articles of Association and
              placement for approval
           b. Approval of Memorandum of Association & Articles of Association from Board
              of KSIDC / Govt of Kerala
           c. Company formation (Formalities with Registrar of Companies & incorporation
              of the Company)

                                           Page 60 of 87
Registers/Reports Involved
  1. PRESENT POSITION OF DISHONOURED CHEQUE CASES
  2. BIFR Cases
  3. Cases pending before civil court
  4. Cases pending before debt recovery tribunal
  5. Cases pending before high court of Kerala
  6. Cases pending before high court of Kerala, Ernakulam-No relief from KSIDC
  7. Cases pending before high court of Kerala, Ernakulam-matter stayed and we are
  unable to proceed with recovery
  8. Cases pending before high court of Kerala, Ernakulam – Filed by Auction purchaser
  for reimbursement from KSIDC
  9. Cases pending before high court of Kerala, Ernakulam – Matter is Infructous
  10. Land Acquisition cases (Life Science Park, TVM) Pending before HighCourt of Kerala,
  Ernakulam
  11. Land Acquisition cases (IGC, Malappuram) pending before HighCourt of Kerala,
  Ernakulam
  12. Legal documentation-pending cases
  13. List of cases –preliminary scrutiny-status
  14. List of cases MACT, Ernakulam
  15. Public Interest Litigation CASES Filed Against KSIDC
  16. Units taken over under Section of the State Financial Corporations Act, 1951 of
  KSIDC, Cochin office and which still are in our custody
  17. List of Units taken over and sold under Sec.29 of the State Financial Corporation Act,
  1951
  18. List of Companies against which winding up petition filed by KSIDC is pending
  19. List of Companies against which winding up petition filed by others, pending before
  the high court of Kerala, Ernakulam
  20. Wound up cases- Pending for sale
  21. Wound up cases where in dividend paid and no further chance to receive any amount
  towards our proportionate share
  22. WOUND UP CASES WHEREIN WE HAVE FILED AFFIDAVIT OF PROOF OF DEBT AND
  ARE UNLIKELY TO RECEIVE OUR PROPORTIONATE SHARE
  23. WOUND UP CASES WHEREIN WE HAVE FILED AFFIDAVIT OF PROOF OF DEBT AND
  HAD PARTLY RECEIVED OUR PROPORTIONATE SHARE
  24. WOUND UP CASES WHEREIN WE HAVE FILED AFFIDAVIT OF PROOF OF DEBT AND
  CLAIMS ARE YET TO BE INVITED / SETTLED BY O/L

Proposed System Requirements

Use Case Diagram




                                        Page 61 of 87
Requirements List
Req.     Requirement                                     Must    Desired   Remarks
No                                                       Have?
R.11.1   The proposed system should have the             Y
         facility to manage and track various
         activities related to Legal Verification and
         Legal Documentation.
R.11.2   The proposed system should have the             Y
         facility to manage and track various
         activities    related   to    Legal   Cases
         Management. Case details should be
         available in the system. (Petitioner
         details, Case No, Current Status, Counter
         affidavit filed date, Next Posting Date,
         Last Posting Date, Company/Party Name,
         Advocate Name and contact details,
         details of security etc). In the case of RR
         cases RR Notice date, Amount, Guarantor
         details, status etc.


                                         Page 62 of 87
R.11.3   The proposed system should generate             Y
         alert facility for cases nearing posting
         date.
R.11.4   Provision to list, search, filter and           Y
         produce detailed, summary and status
         reports on projects processing for
         documentation.
R.11.5   The proposed system should have facility        Y
         to manage/update Party details like
         Name, Photo, Passport No, Pan No,
         Previous case details etc
R.11.6   The proposed system should have facility        Y
         to manage/update Board meetings details
         like Date, Project details, attendee details
         and Remarks. MOM‟s details should be
         incorporated in the system which can be
         used for future reference.
R.11.7   The data from existing “Excel software”         Y
         should be migrated to the new Proposed
         system.
R.12.8   The proposed system should have facility        Y
         to manage/update various activities
         related to SPV formation.




13       LAR Court Cases Management
Core Activities


   1. LAR Court Cases Handling


IGC – LAR Court Cases Management


   1. Preparation of details of awards relating to land acquisition showing survey nos,
      Occupier‟s name, category of land, rate, value awarded, increase,      solautium,
      compensation for standing trees and structures etc
   2. List of LAR cases on the above
   3. List of LAA cases on the above
   4. List of cases with details like Advocate name, Category, hearing details, Current
      status etc.
   5. Details of court fee and decreetal deposits on LA cases
   6. Details of 28 (a) applications preferred.
   7. History of all Case related activities.
   8. Database on government orders relating to land acquisition
   9. Position of LAR cases pending with court/revenue department


                                         Page 63 of 87
Files/Registers Involved
              Awards file
              Lar cases file
              LAA cases file
              Advocates file
              IGC „s file
              Inward & movement register
              Note to accounts file
              LA/LAR note files
              Government order/ correspondence file

Proposed System Requirements
Requirements List
Req.     Requirement                                     Must    Desired   Remarks
No                                                       Have?
R.12.1   The proposed system should have the             Y
         facility to manage and track various LAR
         Cases. The details like Advocate name,
         Category, Due Date, hearing details,
         Current status etc should be updated in
         the system.
R.12.2   The proposed system should have the             Y
         facility to view history of all Case related
         activities.
R.12.3   The proposed system should have the             Y
         facility to update/search details of various
         government orders related to land
         acquisition.
R.12.4   Reports related to LAR cases with current       Y
         status.
R.12.5   The proposed system should generate             Y
         Alerts, i.e. positions of case, hearing
         dates etc.




14       Right To Information
Core Activities


   1. Right To Information Management


Workflow - Right To Information


   1. Party has to submit application with adequate fee/stamp.

                                         Page 64 of 87
  2. Application will be forwarded to ED for identifying the department who has to give
     the required information.
  3. PIO will forward the application to concerned officers.
  4. Follow up for Comments from the concerned officers.
  5. If the information sought for relates to third party, prior consent to be obtained from
     the third party before divulging the information.
  6. Based on the comments, a Reply is given to the applicant.
  7. If not satisfied with the reply, the applicant may prefer appeal before the appellate
     authority.
  8. The appellate authority to hold hearing.
  9. If still unsatisfied, the applicant may prefer appeal before the State Public
     Information Commissioner.


Existing System Workflow




                                       Page 65 of 87
Files/Registers Involved
        Inward register
        Movement register
        Party file

Proposed System Requirements
Requirements List
Req.      Requirement                                  Must    Desired   Remarks
No                                                     Have?
R.13.1    The proposed system should have the          Y
          facility to manage and track various
          applications  related to  Right   To
          Information.
R.13.2    The proposed system should have the          Y
          facility to generate alerts for pending
          applications    regarding    Right   To
          Information.
R.13.3    Reports related to Right To Information      Y
          applications
R.13.4    The proposed system should have the          Y
          facility to generate alerts regarding
          Statutory   Time  Limits  for various
          activities.




15       HR & Admin
The HR & Admin department deals with the following activities.


Core Activities
   1. Attendance/Leave Management
   2. Medical Reimbursement
   3. Tour Reimbursement
   4. Store Management
   5. Employee Loan Management
   6. Annual Performance Appraisal/Annual increment Management
   7. New Appointment Management.
   8. Management of telephone/newspaper reimbursement(Admin will check the eligibility-
      then to Accounts)
   9. Management of conveyance allowance reimbursement(attendance given by Admin to
      Accounts-Accounts will disburse based on attendance for the month)



                                       Page 66 of 87
Workflow – Leave Management
  1. Leave Types:
         a) Permanent Employees
                    Casual Leave (20/Yr)
                    Commuted (10/Yr)
                    Earned leaves (+1 for 11 working days) & +1 for 22 working days
                     during the first year of appointment
         b) Contingent Employees
                    Casual Leave (20/Yr)
                    Commuted – NIL
                    Earned leaves (+1 for 11 working days) for Full Time contingent staff
                     & 15 for Part Time contingent staff
         c) Contract Employees & Advisors
                    Casual Leave – 12 per year
  2. Two level approvals for leave sanctioning.
  3. a. Leave application is first sent to concerned department head & to the head of
     Tvm/Kochi offices, as the case may be for approval. Department head will inform the
     details to Admin Head. Admin will update the details and will inform the Payroll
     section.
     b. For leave surrender, the application is sent to Admin head. Admin head will update
     the details and will inform the Accounts section.


  Existing System Workflow




                                      Page 67 of 87
                                   Leave Management


                                               Start




                                         Leave Application




                                                                    No
                                        Dept head approval



                                                  Yes



                                                                         No
                                          Admin approval



                                                   Yes


                               Admin will update the details and send
                                         to Payroll section




                                          Payroll Process




                                               END



                                                                                 Page 1



Workflow - Medical Reimbursement
  1. Application along with Bills is submitted to Admin department.
  2. Admin will send the bill to the doctor for approval.
  3. Once approved, Admin will check the eligible amount
  4. Application is sent to the accounts department for disbursing the eligible amount to
     the employee.


Existing System Workflow




                                         Page 68 of 87
                              Medical Reimbursement


                                            Start




                                   Applications with Bills




                                                                    No
                                      Doctors approval



                                               Yes


                             Admin will check the eligible amount




                                       Accounts Dept




                                            END
                                                                                 Page 1




Workflow – Tour Reimbursement
  1. Employee will send the application to concerned head.
  2. Department head will forward it to the Head of Tvm/Kochi offices as the case may be
     for approval.
  3. The Head of Tvm/Kochi offices as the case may be will send the approval details to
     Accounts department for release of tour advances.
  4. A copy of the tour program will be sent to Admin. Admin will mark as Tour and sent
     this copy back to the employee for his/her records


Existing System Workflow




                                        Page 69 of 87
                                       Tour Reimbursement


                                                     Start




                                                  Employee




                                                                         No
                                                  Dept Head



                                                        Yes



                                               Head of Tvm/Kochi              No
                                                    offices



                                                        Yes




                   Admin will mark as Travel                       Accounts




                                                  Employee




                                                    END

                                                                                   Page 1




Workflow – Store
  1. Purchase of Goods
        a) Purchase request is given to vendor.
        b) Vendor will deliver the goods with Delivery note.
        c) Invoice is send by the concerned company to KSIDC
        d) Invoice is checked with the Delivery note.
        e) Invoice copy is filed, and original is send to the accounts department for
           release of payment.

                                                Page 70 of 87
  2. Distribution of Goods
            a) Requisition for stationery by the employee
            b) Approve by Admin department
            c) Distribution of goods by Admin department and updated in the Inventory
               Register


Existing System Workflow

                                                   Store


                                                                             Start
                   Start



                                                                    Requisition by employee
             Purchase request




    Deliver the goods with Delivery note
                                                                                                    No
                                                                       Approve by Admin


     Invoice received from concerned
                 company                                                        Yes


                                                                      Distribution of goods

                                           No
          Invoice is checked with
             the Delivery note


                                                                updated in the Inventory Register
                      Yes


       Invoice copy is filed by Admin

                                                                              END




                 Accounts




                   END
                                                                                                         Page 1




Workflow – Employee Loan Management
  1. Employee will send the loan request to Admin Dept
  2. Admin Dept will check the eligibility
  3. In case of housing loan it is hand over to Legal Section
  4. Employee loan request is send to ED for approval
  5. Then it is send to MD for approval, if necessary



                                                Page 71 of 87
  6. After getting approval from MD. Admin Dept will hand over the request to Accounts
     Dept and disburse the eligible amount to the employee.


Existing System Workflow




                                    Page 72 of 87
                            Employee Loan Management


                                          Start




                                  Employee loan request




                                    Admin check the
                                       eligibility


                                                Yes


                                                               Yes   Legal Dept
                                     If housing loan



                                              No


                                                         Yes                      No
                                                                      Approve




                                                                     No
                                    Executive Director



                                             Yes



                                                                     No
                                           MD



                                              Yes


                                          Admin




                                        Accounts




                                          END


                                                                                       Page 1

Workflow – Employee Appraisal
  1. Performance Appraisal forms filled up by employees are forwarded to their respective
     reporting officers.


                                      Page 73 of 87
  2. Reporting officer after appraising the form, will forward to ED
  3. ED appraises the form, and forwards it to MD
  4. MD further appraisal the form and then return back to the Admin Dept.
  5. Admin will process the promotion/increments based on the performance as well as
     defined standards and send to Accounts


Existing System Workflow

                                      Employee Appraisal


                                                Start




                                     Appraisal forms by employee




                                          Reporting officer




                                          Executive Director




                                                 MD




                                               Admin




                                              Accounts




                                                 END

                                                                                   Page 1




                                       Page 74 of 87
Recruitment of Employee
          a. Direct Recruitment for officers.
          b. PSC for Staff selection.
          c. Employment exchange for contract employee (for 179 days)
          d. Advisors recruitment
          e. Contingent employee recruitment.
          f.   Management Trainees
   The requirement details will be updated in the KSIDC website and advertised in
   newspapers.


Employee Details Maintained

Following employee details are kept in excel.
Name, ID, Designation, Division, Location (TVM/Cochin), Email-Official, Email-Personal,
Phone Office, Phone Residence, Mobile no, Present Address, Permanent Address, Blood
Group, Age, Height, Weight, Gender, Martial Status, Religion, Caste, Category, Passport No,
Licence No, PAN No, DOB, DOJ, DOR, Mode of Employment, Employment status, No of Years
in Service, Pay details, PF No, Break in Service if any, Educational Qualifications,
Professional Qualifications, Documents Submitted, Experience Certificate previous
organisation, Total years of work experience, Awards if any, Native Place, Father Name,
Mother Name, Spouse Name and details, Children details, Wedding Day, Personal Interests
& other details if any.


Training for Employee
          a) Internal Training for Employees
          b) External Training: Request is taken from the Party. The request will be
             forwarded to ED. ED will approve and will forward to concerned officers.


Mails Management: Both IN/OUT mails handling is done by Admin department. Details are
entered in respective registers in the Admin. Dept and forwarded to ED. ED will return back
to Admin department. Admin will send the mails to corresponding departments.


Other Activities: Telephone Bill, Water Bill & Electricity Bill payments, AMC details
management, Automobile Insurance details, Car/Building Maintenance management,
Petrol/Diesel bill settlements, Taxi bills settlements etc. Newspaper reimbursement to
officers based on eligibility. Conveyance allowance reimbursement to employees.


Superannuation Procedure: When the employee reaches superannuation at the age of 58
years, the Admin Dept. will collect the “no dues” certificate from library and calculate the
Earned leave balance and forward to the Accounts Dept for releasing the cheques for Earned
leave surrender if any & Gratuity for the employee. (The PF Trust makes PF calculation of
the employee & cheque may be separately given to the employee.)



Files/Registers Involved


   1. Inward Mail Register

                                        Page 75 of 87
   2. Outward Mail Register

   3. Inventory Register

   4. Maintenance Register

   5. Movement Register

   6. Attendance Register

   7. Leave registers(casual leave, commuted leave and earned leave)

   8. Medical reimbursement registers

   9. Telephone reimbursement registers

   10. Newspaper reimbursement registers



Proposed System Requirements

Use Case Diagram – HR & Admin




                                        Page 76 of 87
                                                       HR & Admin


                                                      Leave Management
                                          *                                          *                        *
                                                                                                                  *


                                          *               Medical
                                                       Reimbursement                                                  Dept Head
                                                                                 *


                                                                                         *
                                                      Tour reimbursement

                                              *                                      *

                                                                                                              *
         *       *                                                                                        *
                                                          Employee                                            *
                                                         Recruitment                                          **
                                                                                                              *
                  **                      *
                  *
                 **
             *
                                                                                     *                                Accounts Dept
                                                          Training for
 Admin Dept                                               Employee
                                          *


                                                                                 *                                    *
                                                                                     *
                                                        Employee Loan
                                          *


                                                                             *
                                              *
                                                                                                                          Legal Dept
                                                      Employee Appraisal



                                                  *                          *

                                                             Store




Requirements List
Req.             Requirement                                             Must                Desired   Remarks
No                                                                       Have?
R.14.1           The proposed system should manage and                   Y
                 maintain the Leave Management System.
R.14.2           Provision for updating/maintaining all the              Y
                 leave types.
R.14.3           Provisions for    updating/viewing          each        Y
                 leave balances.



                                                  Page 77 of 87
R.14.4    Provision for submitting and maintaining       Y
          Leave Applications.
R.14.5    Provision for Leave approvals at different     Y
          levels.
R.14.6    Provision for viewing the leave status.        Y
R.14.7    Existing Punching system should           be   Y
          integrated with the new system.
R.14.8    Provision for generating various reports       Y
          related to attendance.
R.14.9    The attendance details should be               Y
          available with Account Department and
          Admin Department
R.14.10   The proposed system should manage and          Y
          maintain Medical Reimbursement details
R.14.11   Provision for generating various reports       Y
          related to Medical Reimbursement.
R.14.12   The Medical Reimbursement details              Y
          should  be available with    Account
          Department and Admin Department.
R.14.13   The proposed system should manage and          Y
          maintain Tour Reimbursement details
R.14.14   Provision for generating various reports       Y
          related to Tour Reimbursement.
R.14.15   The Tour Reimbursement details should          Y
          be available with Account Department
          and Admin Department
R.14.16   The proposed system should have facility       Y
          to manage and maintain the Store
          Management details.
R.14.17   The proposed system should manage              Y
          Minimum level, Maximum level and
          Reorder level of Store Item
R.14.18   Provision for generating various reports       Y
          like Purchase details, Items distributed to
          each Employee, Current Stock, Item wise
          reports on Minimum level, Maximum
          level and Reorder level.
R.14.19   The proposed system should have facility       Y
          to manage item request and distribution.
R.14.20   The proposed system should manage and          Y
          maintain    the     Employee     Loan
          Management System.
R.14.21   The proposed system should manage              Y

                                         Page 78 of 87
          Loan eligibility calculation
R.14.22   Provision for generating various reports       Y
          like previous loan details, recovery
          details
R.14.23   The proposed system should manage and          Y
          maintain the Employee Appraisal details.
R.14.24   Provision for generating various reports       Y
          related to Employee Appraisal.
R.14.25   The proposed system should have facility       Y
          to add/update/search employee details.
R.14.26   The proposed system should manage the          Y
          Maintenance activity details of office
          equipments, Requested date, action
          taken, current status, issue closed date
          etc. Alerts required for various bill
          payments, AMC & Insurance renewal
          details etc
R.14.27   The proposed system should have                Y
          provision for updating/maintaining all the
          details of new appointment.
R.14.28   The proposed system should have                Y
          provision    for    sending     various
          correspondences to various departments
          regarding new appointment.
R.14.29   The proposed system should generate            Y
          alerts/reports for pending applications
          (eg: leave, Medical Reimbursement, Loan
          applications etc)
R.14.30   The proposed system should have                Y
          provision    for   maintaining    Training
          conducted details. The details like Date,
          Subject,     External/Internal,    Trainer
          details, Attendee details etc should be
          stored in system.
R.14.31   The proposed system should have                Y
          provision for maintaining IN/OUT mails
          details.
R.14.31   The proposed system should have                Y
          provision for maintaining various utility
          bill payment details with proper alert
          facility based on due dates.
R.14.32   Punching system should be integrated           Y
          with the Payroll module of the new
          accounting system and Provision for
          generating various reports related to
          attendance.

                                         Page 79 of 87
R.14.33   The proposed system should have                  Y
          provision to generate Greetings mails for
          Birthday, Anniversary etc
R.14.34   The proposed system should have                  Y
          provision for   maintaining   various
          Newspaper   reimbursement   (officers)
          details.
R.14.35   The proposed system should have                  Y
          provision for maintaining Conveyance
          allowance reimbursement details for
          employees


16    MIS

MIS Information Required - Internal


   1. KSIDC Fund position and details like Amount, Date, Bank Name, Maturity details etc
      information to MD & ED

   2. Sanction, Recovery & Disbursement details.

   3. Project with their Profit details.

   4. List of Court Cases with details like Advocate Name, Due Date, hearing details,
      Status etc.

   5. Project details with Status, Next Action , Next Action Date etc.

   6. Employee details like Personal details, Educational details, Payroll details, Leave
      details, Leave history, Date of join, Date of join, Employee number etc should be
      available.

   7. Company details with Payment details like due date, amount etc.

   8. IGC details like Sketch, allotment details, pending for allotment, Cost details etc
      should be available.

   9. Disbursement and monitoring summary details of various projects

   10. Fund request status for Mega Projects

   11. Share investments details like date of purchase, purchase value, current value, profit
      or loss, dividend details, etc.

   12. Employees Present/Absent/Travel List – Daily report

   13. Punch In/Out Time of each Employees List (Monthly/Daily) & Employees Punctuality
      Report (Leave History)


                                           Page 80 of 87
   14. Details of files Pending with PIC – Project Implementation Committee.

   15. Companies Loan Status like, Loan Amount, Principal received, Interest received,
      Principal pending, Interest pending etc




MIS Information Required - External


  1. Party/Company should be able to see the payment and due details of the loan availed
     by them.

  2. Mega Project details like Status, Date, Project Cost, and Expected Completion Date
     etc. with Search facility.

  3. Interface to Company for entering their Quarterly financial information



Link/Interface to external systems like (KSEB, ROC-Registrar Of Companies, DIC) are
required to fetch information‟s.



17    Existing Software and Hardware Details

     Department/Section           Existing          Description
                                  Software
     Financial Accounting         ASP/SQL           The software is currently under
                                                    implementation. Detailed module
                                                    structure is given below.

     Pay Section                  ASP/SQL           The software is currently under
                                                    implementation.

     Legal Division               Excel System      A small application which contains the
                                                    details of Legal
                                                    activities/Cases/Parties




                                            Page 81 of 87
Financial Accounting Module Structure




                               Page 82 of 87
Hardware and Software Details Cochin Office
                Make / Model            Processor             RAM        HDD                     Nos.
Server

             IBM NETFINITY
   1         3000                 PII @ 350MHz              64MB       40 GB      Win NT 4.0       1
   2         IBM Xseries 232      PIII @ 1.3GHz             2GB        60 GB      Win 2000         1

Desktop


                                  CORE 2 DUO @ 2.53                               Win Vista
   1         DELL Optiplex 360    GHz                       2 GB       160 GB     Professional    17
                                  CORE 2 DUO @ 2.93                               Win 7
   2         DELL Optiplex 380    GHz                       4 GB       450 GB     Professional     2
                                                                                  Win XP
   3         IBM Netvista         PIV4 @ 1.8 GHz            256 MB     80 GB      Professional     6

Laptop

                                                                                  Win XP
   1         Toshiba Tecra A8     PIV @ 1.67 GHz            1 GB       60 GB      Professional     1
                                  CORE 2 DUO @ 2.2                                Win 7
   2         Dell Vostro 1320     Ghz                       4 GB       320 GB     Professional     3


Software

         *      All the Operating System S/W except server OS are OEM Licensed versions.
         *      Win 2000 server has 25 user licenses.
         *      Internet security S/W is ESET Smart Security with 25 user licenses.
         *      Malayalam scripting software Script Easy - 4 user licenses.
         *      19 licenses of MS Office 2007 Professional
         *      25 licenses of MS Office XP Professional




                                           Page 83 of 87
Hardware and Software Details Trivandrum Office


Sl             PC                   PROCESSOR          RAM    HD     MAKE
     IBM SERVER EDP         P3 WITH DUAL PROCESSOR @          60
 1                          1.26 GHz                   2 GB   GB    IBM
 2   SEVER DELL (WEB        INTEL XEON QUAQD CORE 2    16     144   DELL
     ENABLED)               Ghz                        GB     x3
                                                              GB
 3   SEVER DELL DUAL (WEB   INTEL CORE 2 DUO 2.0       8 GB   500   DELL
     ENABLED)                                                 x2
                                                              GB
                                                              160
 1   PC                     CORE 2 DUO 2.0 GHz         2 GB   GB    APPLE
                                                              160
 2   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                       512    160
 3   PC                     P4 @ 3.0 GHz               MB     GB    ACER
                                                              160
 4   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
 5   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                       256    80
 6   PC                     P4 @ 3.0 GHz               MB     GB    KEL PC
                                                              160
 7   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
 8   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
 9   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
10   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
11   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
12   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
13   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
14   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
15   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
16   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
17   PC                     CORE 2 DUO 2.2 GHz         2 GB   GB    LENOVO
                                                              160
18   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
19   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
                                                              160
20   PC                     CORE 2 DUO 2.53 GHz        2 GB   GB    DELL
21   PC                     CORE 2 DUO 2.53 GHz        2 GB   160   DELL

                                 Page 84 of 87
                                       GB
                                       160
22   PC   CORE 2 DUO 2.2 GHz    2 GB   GB    LENOVO
                                       160
23   PC   CORE 2 DUO 2.2 GHz    2 GB   GB    LENOVO
                                       160
24   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                256    80
25   PC   P4 @ 1.7 GHz          MB     GB    IBM
                                256    80
26   PC   P4 @ 2.66GHz          MB     GB    KEL PC
                                256    80
27   PC   P4 @ 2.40 GHz         MB     GB    IBM
                                256    80
28   PC   P4 @ 3.0 GHz          MB     GB    KEL PC
                                       160
29   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                       80
30   PC   P4 @ 1.7 GHz          1 GB   GB    IBM
                                       250
31   PC   CORE 2 DUO 2.93 GHz   2 GB   GB    HP
                                       250
32   PC   CORE 2 DUO 2.93 GHz   2 GB   GB    HP
                                       160
33   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                       160
34   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                       160
35   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                       160
36   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                       160
37   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                       160
38   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                256    80
39   PC   P4 @ 1.7 GHz          MB     GB    IBM
                                       500
40   PC   CORE 2 DUO 2.93 Ghz   4 GB   GB    DELL
                                       160
41   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                       160
42   PC   CORE 2 DUO 2.40 GHz   2 GB   GB    COMPQ
                                       500
43   PC   CORE 2 DUO 2.93 Ghz   4 GB   GB    DELL
                                       160
44   PC   CORE 2 DUO 2.2 GHz    2 GB   GB    LENOVO
                                       160
45   PC   CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                256    80
46   PC   P4 @ 3.0 GHz          MB     GB    KEL PC
                                256    80
47   PC                         MB     GB    KEL PC
                                128    40
48   PC   P4 @ 1.7 GHz          MB     GB    IBM
49   PC   CORE 2 DUO 2.53 GHz   2 GB   160   DELL

               Page 85 of 87
                                                          GB
                                                          160
50   PC                      CORE 2 DUO 2.53 GHz   2 GB   GB    DELL
                                                   256    80
51   PC                      P4 @ 1.8 GHz          MB     GB    IBM
                                                   256    80
52   PC                      P4 @ 2.6 GHz          MB     GB    KEL PC
                                                   256    80
53   PC                      P4 @ 3.0 GHz          MB     GB    KEL PC
                                                   256    80
54   PC                      P4 @ 3.0 GHz          MB     GB    KEL PC
                                                   256    80
55   PC                      P4 @ 3.0 GHz          MB     GB    KEL PC
                                                   256    80
56   PC                      P4 @ 1.8 GHz          MB     GB    KEL PC
                                                          250
57   MD RES                  CORE 2 DUO LSERJET    2 GB   GB    HP
                                                   256    80
 1   LAPTOP (NATHAPURAM)     P4 @ 1.7 GHz          MB     GB    IBM
                                                          200
 2   LAPTOP (OFFICE)         CORE 2 DUO 2.1        2 GB   GB    SONY
                                                          250
 3   LAPTOP (MD)             CORE 2 DUO 2.0        4 GB   GB    DELL
                                                          160
 4   LAPTOP (OFF)            CORE 2 DUO 2.0        2 GB   GB    DELL
                                                          320
 5   LAPTOP (MRK)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
 6   LAPTOP (TAK)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
 7   LAPTOP (PSV)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
 8   LAPTOP (MRS)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
 9   LAPTOP (MAL)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
10   LAPTOP (ACR)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
11   LAPTOP (KPN)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
12   LAPTOP (NSU)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
13   LAPTOP (JJR)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
14   LAPTOP (BJK)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                          320
15   LAPTOP (SEC)            CORE 2 DUO 2.2 Ghz    4 GB   GB    DELL
                                                   64     2
     WIPRO NT SERVER (EDP)   P @ 133 MHz           MB     GB    WIPRO
     WIPRO NT SERVER                               64     2
     (ACCOUNTS)              P @ 133 MHz           MB     GB    WIPRO
                                                   32     40
 1   PC                      P @ 133 MHz           MB     MB    WIPRO
                                                   32     40
 2   PC                      P @ 133 MHz           MB     MB    WIPRO
 3   PC                      P @ 133 MHz           32     40    WIPRO

                                  Page 86 of 87
                                                                MB     MB




Connectivity Details

Details of connectivity/network details between various departments and with Cochin office

Connectivity through Airtel dedicated leased line. All PCs locally connected to
respective common server placed at TVM & CHN offices. End to end connection
between TVM & CHN offices for new servers for new accounting Software




                                       Page 87 of 87

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:345
posted:1/4/2011
language:English
pages:87