AccessibilitySkip to Top NavigationSkip to Main ContentHome  |  Contact IRS  |  About IRS  |  Site Map  |  Español  |  Help  

Part 7. Rulings and Agreements

Chapter 21. Exempt Organizations Automated Processing Procedures

Section 9. Exempt Organizations Management Information System

7.21.9  Exempt Organizations Management Information System

7.21.9.1  (01-01-2003)
Overview

  1. This section provides instructions for Managers and employees responsible for generating reports on the Management Information System (MIS).

  2. MIS is a subsystem of EDS that generates inventory and employee roster reports. The same reports EACS generated in the service center can be generated and printed in MIS as often as needed. EACS no longer supplies these reports.

  3. The reports are selected and printed from the MIS Main Menu. See the EDS User Manual for instructions for using the system.

7.21.9.2  (01-01-2003)
Specific Instructions

  1. The inventory reports are generated from the MIS Main Menu.

7.21.9.2.1  (01-01-2003)
Case Inventory Listings

  1. Five different inventory listings can be selected. All reports list the cases in control date and alpha order. See Exhibits 9–1 for the format of these reports.

    1. The division report lists ALL cases in the division and is further divided by group and unassigned cases. Review cases are listed in each group.

    2. The group report lists cases in the group from the group number entered with status 32, 33, 38, 52, 53 and 55. This report is further divided by specialist. Any unassigned inventory held at the group level will be listed under a "dummy" specialist number (a number that is not assigned to any individual) which is assigned to each group.

    3. The review report lists cases in review with status 31, 34, 37, 54 and 56.

    4. The specialist report lists overage cases in the specialist’s inventory with status 32, 33, 52 and 53. The specialist number is entered to generate the report.

    5. The unassigned report lists only those cases that are in status 50,51, and 60 and the cases that have been assigned to a "dummy specialist" . The report is separated by technical screening unassigned inventory and by group with the "dummy specialist" number.

7.21.9.2.2  (01-01-2003)
Overage Case

  1. An overage Indicator is entered to select only those cases older than the overage indicator. The overage indicator represents a number of days (i.e 145 days). Because the Overage Indicator is not preset in the program the Area Office has the flexibility of entering any number of days.

  2. Five different overage listings can be selected. All reports list the cases in control date and alpha order. See Exhibits 9–2 for the format of these reports.

    1. The division report lists ALL overage cases in the division and are separated by group and unassigned cases. Review cases are listed under the group inventory.

    2. The group report lists cases in the group with status 32, 33, 38, 52, 53 or 55. The group number is entered to generate the report. The overage listing is further divided by specialist. Any unassigned inventory will be listed under the "dummy" specialist number (see section 9.2.1.(1)b.

    3. The review report lists overage cases in review with status 31, 34, 35, 37, 54 or 56.

    4. The specialist report lists overage cases in the specialist’s inventory with status 32, 33, 52 or 53. The specialist number is entered to generate a report for the specialist.

    5. The unassigned report lists only those cases that are in status 50 and 51 and the cases that have been assigned to a "dummy specialist" . The report is separated by technical screening unassigned inventory and by group with the "dummy specialist" number.

7.21.9.2.3  (01-01-2003)
Overage Percentage Report

  1. The overage percentage report lists:

    1. Total number of cases in unassigned inventory,

    2. Total number of cases in groups and review,

    3. Number of overage cases, and

    4. Number of cases that will be overage in two weeks (14 days).

  2. The reports calculates the overage percentage. The reports also lists the total number of cases in Appeals, Technical Advice and Area Council status and the overage percentage for those cases. See Exhibit 9–3 for the format of this report.

7.21.9.2.4  (01-01-2003)
Inventory Counts Report

  1. Inventory Counts report lists total of cases processed by receipts, closing, etc.

    1. A beginning and ending date is entered to generate a report for a specific period of time.

    2. A report can be generated for a day, a week, a month or for an entire year. See Exhibits 9–4, 9–5, and 9–6 for the format of this report.

7.21.9.2.5  (01-01-2003)
Cycle Time

  1. There are eight different cycle time reports available. These reports must be generated at least once a month and by the fifth workday after the end of the reporting cycle (4/4/5 cycles). Headquarters will download each report from the Area Office on the sixth workday after the end of the reporting cycle. See Exhibit 9–7 for the format of these reports.

    Note:

    EO cases that are closed "Failed to Establish" (Closing Code 11) are included in the Other closing Report. When the organization’s file is reopened (Type Request S) the days to process from the first case are added to the reestablished application. When closing the reestablished application the cycle days are reported in the appropriate report based on the new closing code. The reports available are the following:

    1. Initial/Amendment/Termination Closings 01, 02, 08 and 12.

    2. Technical Screened Closing 06

    3. EO Foundation Follow-up Closings

    4. Appeals/Suspense/Technical Advice

    5. Other Closings 03, 04, 09, 10, 11 and 30

    6. Initial/Amendment Closings 01,02, 08, and 12 from status 52 to Closing.

7.21.9.2.6  (01-01-2003)
Waiting Closing Approval Report

  1. This report lists cases by group that are in 55 status or cases waiting 30 days in Technical Screening. The group number is entered to generate the group report. See Exhibit 9–8 for the format of this report.

  2. This report identifies:

    1. cases waiting for approval and are not in the manager’s possession,

    2. cases the manager has missed approving or those where the 60 days has expired.

7.21.9.2.7  (01-01-2003)
Age of Inventory

  1. This report lists the total number of open cases by case grade and percentage. (See Exhibit 9–9 for the format of this report.

    1. The percentage is generated for cases under 100 days, between 100 to 144, and 145 days and over.

7.21.9.2.8  (01-01-2003)
Age of Disposals

  1. This report lists the total number of closed cases between a beginning and ending period (which must be entered) by case grade. See Exhibit 9–10 for the format of this report.

    1. The percentage is generated for cases under 100 days, between 100 to 144, and 145 days and over.

  2. Headquarters will download this report for each Area Office on the fifth workday after the end of the MIR cycle.

7.21.9.2.9  (01-01-2003)
Age of Disposals By Form

  1. This report lists the total number of closed cases between a beginning and ending period (which must be entered) by form number and age. See Exhibit 9–11 for the formats of these reports.

7.21.9.2.10  (01-01-2003)
Disposal to Receipt Ratio

  1. This report lists the total number of closings and receipts by case grade between a beginning and ending period (which must be entered), and lists a ratio or percentage of closings to receipts.

7.21.9.2.11  (01-01-2003)
Unpostable Listing

  1. This report lists cases that are on the system in an unpostable status from the EDS batch run. See Exhibit 9–11 for the format of this report.

7.21.9.2.12  (01-01-2003)
Employee Roster

  1. This report lists each employee in a division report or group report. The division report is further divided by groups. See Exhibit 9–12 for the format of this report.

7.21.9.3  (01-01-2003)
Information Queries

  1. The data stored as part of EDS in a relational database (Informix). A relational database allows queries to be performed on any item in the database provided an employee has been trained to do so. The queries are done with Structured Query Language (SQL). See your EDS Functional Coordinator to obtain permission to use ISQL which is a part of Informix.

  2. A query screen has been programmed to perform queries for total cases closed by Group, Closing Code, Case Grade, Specialist Grade, Type Request and Form Number. The query reports the total—

    • cases,

    • hours,

    • specialist hours,

    • total reviewer hours,

    • average hours for the query data entered

  3. Access this query screen by selecting Option 20 on the MIS Main Menu.

7.21.9.4  (01-01-2003)
Area Office Reports

  1. The Area Offices may program ACE (Informix) or "C" reports and run them against the EDS database. This MIS Main Menu provides an option to display a "Area Office Report Menu" . The Area Office Report Menu must be developed by the Area Office and have options available to select any of the reports programmed.

Exhibit 7.21.9-1  (01-01-2003)
CASE INVENTORY TOTALS FOR EXEMPT ORGANIZATIONS
 Report Date: Tue Feb 9 2002

Days Entered: 1
Control Date: 02/08/02 and Earlier is Overage
Control Date: 02/22/02 will be Overage in 14 Days
  TOTAL   CASE GRADE
      09 11 12
Group 317000: 3   3 0 0
 Overage: 3   3 0 0
 Overage Percentage: 100.0   100.0 .0 .0
 Overage in 14 Days: 0   0 0 0
 Suspense: 0   0 0 0
 30 Day Suspense: 0   0 0 0
 Proposed Adverse: 0   0 0 0
 Waiting Manager Approval: 1   1 0 0
 Group Unassigned: 0   0 0 0
   Overage: 0   0 0 0
Group 317100: 0   0 0 0
 Overage: 0   0 0 0
 Overage Percentage: .0   .0 .0 .0
 Overage in 14 Days: 0   0 0 0
 Suspense: 0   0 0 0
 30 Day Suspense: 0   0 0 0
 Proposed Adverse: 0   0 0 0
 Waiting Manager Approval: 0   0 0 0
 Group Unassigned: 0   0 0 0
   Overage: 0   0 0 0
Unassigned: 14   2 11 1
 Overage: 14   2 11 1
 Overage Percentage: 100.0   100.0 100.0 100.0
 Overage in 14 Days: 0   0 0 0
 Suspense: 0   0 0 0
 Waiting Mgr Approval: 0   0 0 0
Review: 0   0 0 0
 Overage: 0   0 0 0
 Overage Percentage: .0   .0 .0 .0
 Overage in 14 Days: 0   0 0 0
 Suspense: 0   0 0 0
 Proposed Adverse: 0   0 0 0
 30 Day Suspense: 0   0 0 0
Total Inventory: 19   5 13 1
 Overage: 19   5 13 1
 Overage in 14 Days: 0   0 0 0
 Suspense: 0   0 0 0
 Proposed Adverse: 0   0 0 0
DIVISION OVERAGE PERCENTAGE: 100.0 %   100.00 % 100.00 % 100.00 %
INVENTORY OUTSIDE TE/GE DIVISION  
Appeals: 0  
 Overage: 0  
 Overage in 14 Days: 0  
Tech Advice: 0  
 Overage: 0  
 Overage in 14 Days: 0  
Area Council: 0  
 Overage: 0  
 Overage in 14 Days: 0  
Total Inventory: 0  
 Overage: 0  
 Overage in 14 Days: 0  
Overage Percentage: 00.0 %  

Exhibit 7.21.9-2  (01-01-2003)
TE/GE Division — Exempt Organizations
EDS Table 1A — Receipts

RUN DATE:  Tue Feb 9 2002
Period Beginning Date:  01/01/2002 Period Ending Date:  01/31/2002
Cincinnati
1023 Initial 3,214
  Re-opened FTE 135
  Amendment 29
  Termination 38
  PF Follow-up 417
  Term. of PF Status 14
  Post Review NO 0
Subtotal 3,847
1024 Initial 400
  Re-opened FTE 27
  Amendment 4
  Termination 1
  Post Review NO 0
Subtotal 432
1025 Initial 0
  Re-opened FTE 0
  Amendment 0
  Termination 0
  PF Follow-up 0
  Term. of PF Status 0
  Post Review NO 0
Subtotal 0
1026 Initial 0
  Re-opened FTE 0
  Amendment 9
  Termination 0
  Post Review NO 0
Subtotal 9
1028 Initial 2
  Re-opened FTE 0
  Amendment 0
  Termination 0
  Post Review NO 0
Subtotal 2
Total 4,290

Exhibit 7.21.9-3  (01-01-2003)
TE/GE Division — Exempt Organizations
EDS Table 2A — Receipts

RUN DATE: Tue Feb 9 2002
Cincinnati
Closures
Period Beginning Date: 01/01/2002 Period Ending Date: 01/31/2002
Form Type Request Total Closings Avg. Hrs. Total Closings
1023 Initial 1,655 2.1
  Re-opened FTE 116 2.7
  Amendment 22 2.3
  Termination 32 1.8
  PF Follow-up 720 1.4
  Term. of PF Status 7 4.3
  Post Review NO 0 .0
Subtotal 2,552 2.0
1024 Initial 223 2.0
  Re-opened FTE 14 3.0
  Amendment 4 2.9
  Termination 2 1.3
  Post Review NO 0 .0
Subtotal 243 2.1
1025 Initial 0 .0
  Re-opened FTE 0 .0
  Amendment 0 .0
  Termination 0 .0
  PF Follow-up 0 .0
  Term. of PF Status 0 .0
  Post Review NO 0 .0
Subtotal 0 .0
1026 Initial 0 .0
  Re-opened FTE 0 .0
  Amendment 1 11.0
  Termination 0 .0
  Post Review NO 0 .0
Subtotal 1 11.0
1028 Initial 0 .0
  Re-opened FTE 0 .0
  Amendment 0 .0
  Termination 0 .0
  Post Review NO 0 .0
Subtotal 0 .0
Total 2,796 2.0

Exhibit 7.21.9-4  (01-01-2003)
TE/GE Division — Exempt Organizations
EDS Table 2B — RUN DATE: Tue Feb 18 2002

Cincinnati District
Closures
Period Beginning Date: 01/01/2002 Period Ending Date: 01/31/2002
Form Type Request Merit Closings Avg. Hrs. Merit Closings
1023 Initial 774 .3
  Re-opened FTE 29 .3
  Amendment 5 .6
  Termination 7 .5
  PF Follow-up 356 .3
  Term. of PF Status 0 .0
  Post Review NO 0 .0
Subtotal 1,171 .3
1024 Initial 101 .3
  Re-opened FTE 3 .3
  Amendment 2 .4
  Termination 1 .5
  Post Review NO 0 .0
Subtotal 107 .3
1025 Initial 0 .0
  Re-opened FTE 0 .0
  Amendment 0 .0
  Termination 0 .0
  PF Follow-up 0 .0
  Term. of PF Status 0 .0
  Post Review NO 0 .0
Subtotal 0 .0
1026 Initial 0 .0
  Re-opened FTE 0 .0
  Amendment 0 .0
  Termination 0 .0
  Post Review NO 0 .0
Subtotal 0 .0
1028 Initial 0 .0
  Re-opened FTE 0 .0
  Amendment 0 .0
  Termination 0 .0
  Post Review NO 0 .0
Subtotal 0 .0
Total 1,278 .3

Exhibit 7.21.9-5  (01-01-2003)
TE/GE Division — Exempt Organizations
EDS Table 2C — RUN DATE: Tue Feb 18 2002

Cincinnati
Closures
Period Beginning Date: 01/01/2002 Period Ending Date: 01/31/2002
<
Form Type Request Non Merit Closings Avg. Hrs. Non Merit Closings
1023 Initial 881 3.8
  Re-opened FTE 87 3.5