In simple terms, an MIS Class represents a type of entity based on which you want your reporting to be done. An MIS Class will be the most general definition for MIS reporting, under which you can have several entities.
For example, if you want reports on the profitability of accounts officers, you would define Accounts Officer as an MIS Class. Accounts Officers in your bank would report to this MIS Class. Similarly, you define Cost Center as an MIS Class if you want reports based on the cost centers in your bank. You can have the various cost centers in your bank linked to the MIS Class of Cost Center. Business Segment, Industry Segments are other examples of an MIS Class.
The definition of MIS Class renders the entire MIS reporting absolutely flexible. By defining a class of your choice, and linking several entities to it, you can generate management information as per your requirement.
In a centralized database architecture, an MIS Class is defined in the Head Office branch of your bank, and is used by all the branches on the database.
This chapter contains the following section:
This section contains the following topics:
You can invoke the ‘MIS Class Maintenance’ screen by typing ‘GLDCLSMT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
If you are creating a new MIS Class, select ‘New’ from the Actions Menu in the Application toolbar or click new icon. The ‘MIS Class Maintenance’ screen is displayed without any details.
If you are calling an MIS Class that has already been defined, double-click on an MIS Class from the summary screen.
The most basic attribute of an MIS class is the ‘type’ of its class. An MIS class can belong to one of the following types:
The MIS type helps you classify your reporting based on either, a customer or a transaction. An MIS Class belonging to the Customer class type helps you generate your profitability for a customer. Similarly, MIS Class belonging to the Transaction class type helps you generate your profitability report based on transactions. A Composite class type, as the name indicates, would help you group a Customer and Transaction type classes. Choose an MIS Type for an MIS Class using the option button beside it.
Transaction Class
A Cost Centre would be a typical transaction type of MIS class. For a cost centre, you would want to generate reports for the kind of costs incurred for processing a transaction. For example, ‘short term loans’ may be a cost centre. For this cost centre, you can generate a report that gives the details of the cost of processing each transaction.
All the cost centres of your bank, would ideally be the different departments of your bank like short term loans, long term loans, teller, bills, etc. Each of these can be defined as MIS Codes, and linked to it.
Customer Class
You may want a profitability report based on the type of industry (manufacturing, agriculture, mining, financial institutions, etc.) to which a customer belongs. For achieving this, you would define Industries as an MIS class, and have various MIS codes linked to the class for each type of industry: manufacturing, agriculture, mining, financial institution, etc. This MIS class would be of Customer class type.
Composite Class
A ‘composite’ class is simply, a combination of a customer and a transaction type of MIS class. Typically, an Accounts Officer would be handling several customers, and you would want a report of the profitability of each customer. Occasionally, a customer may begin with one Accounts Officer and use a product or service that folds under some other Accounts Officer.
In such a requirement, you work backwards and create an MIS Class called Accounts Officer. All the accounts officers of your bank will be created as MIS Codes under this MIS Class. When you are generating your profitability reports, you can choose to get the figures for all the accounts officers, or for a selected few. Also, you can change the Accounts Officer that is picked up by default.
Allocation Class
You may want to view details of the expenses incurred by your bank. To do this, you can maintain Allocation Classes by which you can allocate the various expenses to different entities within your bank.
For instance, let us assume that your organization has over 2000 employees spread across four different locations (Delhi, Mumbai, Chennai, and Calcutta) in India. You would like to have a location-wise break-up of the salary amount disbursed to each of these locations. Additionally, you would also like to view a break-up of balances for individual departments within each location.
To meet these requirements in Oracle FLEXCUBE firstly, define an MIS Class called Locations. All the four location of your organization - Delhi, Mumbai, Chennai, Calcutta, will be created as MIS Codes under this MIS Class.
Similarly, create another MIS Class called Departments. All the departments within your organization (Administration, Financial Control, Products Division, IT Solutions etc) will be created as MIS Codes under this MIS Class.
Consequently, details of salary expenses incurred across-locations will be available under the MIS Class called Locations. The department-wise salary disbursement details will be available under the MIS Class called Departments. Both these MIS classes will be of the Allocation Class type.
Fund Class
Your bank may float a number of funds like Mutual Funds, Growth Funds, and Income Funds etc. You may want to view details on each of the funds. You can achieve this by defining Funds as an MIS Class and have the various funds reporting to it. Each of these funds would be defined as an MIS Code and then linked to the MIS Class ‘Funds’. This is a Fund type of MIS Class.
An MIS Code can be called an entity for which you want profitability reports. Each MIS Code will report to an MIS Class. Consider the following examples:
In these examples, Elizabeth Towers, Sam Brown, and Connie Beckwith will each have an MIS Code, all under the MIS Class 'Accounts Officer'.
Similarly, Short Term Loans, Incoming Bills, and Import Letters of Credit will have an MIS Code each, under the MIS Class 'Cost Centre'. The same concept applies to Industry Segments also.
An MIS Code is added on to an MIS Class either through the New operation on the MIS Class screen or through the ‘Amend’ option on an existing MIS Class record. Once an MIS Class has been stored, you can add MIS Codes to it by unlocking the MIS Class record and adding the required MIS Code.
The ‘MIS Code’ list contains the MIS Codes attached to the selected MIS Class. To add a new record to the ‘MIS Code’ list, click add icon.
To delete an MIS Code(s) from the list, choose the MIS code(s) using the checkbox next to it and then click delete icon.
On an existing MIS Class record, you can perform the following operations (if any function under the Actions Menu is disabled, it means that the function is not allowed for the record):
Please refer to the manual on common procedures for details of these operations.
You can maintain MIS Code restriction maintenance for MIS Class, Product or Account Class, and Branch.
This section contains the following topic:
You can maintain a list of allowed MIS codes for a given MIS class, product or account class combination for a branch in the ‘MIS Code Allowed For MIS Class and Product/Account Class’ screen.The MIS call forms would pick only the MIS codes that are allowed for the product or account class and MIS class combination. You can invoke the 'MIS Code Restriction Maintenance' screen by typing ‘MIDPRDMN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following details:
Branch Code
Specify the branch code. Alternatively, you can select the branch code from the option list. The list displays all the branch code for which the MIS code restrictions are maintained.
Branch Name
The system displays the name of the branch maintained in the system.
MIS Class
Specify the MIS class for which the allowed list of MIS codes are maintained. Alternatively, you can select the class code from the option list. The list displays all the MIS classes maintained in the system. The customer MIS classes are not part of the list.
MIS Class Description
The system displays the MIS class description maintained in the system.
Product / Account Class Code
Specify the product code or account class code for which the allowed lists are maintained. Alternatively, you can select the code from the option list. The list displays all the products or account class code maintained in the system.
Product Or Account Class Description
The system displays the product or account class description respectively maintained in the system.
MIS Code
Specify the MIS code maintained. Alternatively, you can select the MIS code from the option list. The list displays all the MIS codes maintained in the system.
MIS Code Description
The system displays the MIS code description maintained in the system.
Allowed
Check this box to allow the MIS code for a given MIS class, product or account class combination for a branch.
Note
The MIS call forms attached to a transaction input or an account creation screen populates the MIS codes that are allowed for a given MIS class, product or account class combination for a branch. If you do not perform maintenance for a given branch, account class/product code and MIS class combination, then all MIS Classes linked to the account class/product code will be available.
You can view the MIS code restriction summary in the ‘MIS Code Restriction Summary’ screen. It displays the status of the records maintained, whether it is authorized, unauthorized or rejected.
You can invoke this screen by typing ‘MISPRDMN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In the above screen, you can base your queries on any or all of the following parameters and fetch records:
Click ‘Search’ button. The system identifies all records satisfying the specified criteria and displays the following details for each one of them: