This document provides information on how reports are organized in the CIT Executive section on this web site and terminology used to defined the data presented.

Report Description

Dynamic and Static Reports

Reports are further classified as Dynamic or Static.

Static reports provide a snapshot of the data on the date the report is processed. These reports are manually posted to the web site and the data is only valid for the date processed. Static reports are presented on the web page as Monthly, Quarterly, and Fiscal Year.

Dynamic reports data is pulled directly from the database and is current as of “yesterday”. These reports are presented on the web page as Date Range. The Date Range drop-down list consist of such date ranges as, Last Week, Last Month, Last Quarter, Last Fiscal Year, FY To Last Month, Yesterday, Last Monday, etc., or you can Specify a date.

Category and Source Summary

The Executive Summary reports have been summarized. Reports with more detailed information can be found in the DCS Section.

Some of the reports provide NIH Help Desk ticket categories and sources statistics. On the Executive Summary reports, the categories and sources have been grouped to simplify the presentation of the data. Report charts that are using grouped category and source data will be titled Category Summary and Sources Summary.

Below is a breakdown of the Category and Source groupings.

Category Summary

Sources Summary

Selection Criteria

The Executive Summary report shows all tickets processed by the NIH Help Desk only, and the data is selected based on a database view.

By using the view, we are assured the reports will contain only tickets that have been processed by the NIH Help Desk.

The query used in the view to define the service tickets processed by the NIH Help Desk is:

WHERE
(dbo.CIT_Service_Ticket.S_Unit IN ('DCS-TASC', 'WEB', 'DCS-NAISMC')) AND
(dbo.Remedy_Status.Status_Description <> 'Delete') AND
(dbo.CIT_Service_Ticket.Category + dbo.CIT_Service_Ticket.Sub_Cat +
dbo.CIT_Service_Ticket.Source <> 'TrainingRegistrationWWW-Train') AND
(NOT (dbo.CIT_Service_Ticket.Source IN ('MVSDUMP', 'WWW-ASB'))) AND
(dbo.CIT_Service_Ticket.Category + dbo.CIT_Service_Ticket.Source <>
'EOSWWW-EOS')

OR
(dbo.Remedy_Status.Status_Description <> 'Delete') AND
(dbo.CIT_Service_Ticket.Category + dbo.CIT_Service_Ticket.Sub_Cat +
dbo.CIT_Service_Ticket.Source <> 'TrainingRegistrationWWW-Train') AND
(dbo.CIT_Service_Ticket.Source IN ('WWW-Sponsor', 'WWW-BORG')) AND
(dbo.CIT_Service_Ticket.Category + dbo.CIT_Service_Ticket.Source <>
'EOSWWW-EOS') AND
(NOT (dbo.CIT_Service_Ticket.Source IN ('MVSDUMP', 'WWW-ASB')))

OR
(dbo.CIT_Service_Ticket.S_Unit IN ('DCS-DE', 'DCS-DSTEAM', 'DCS-ISG', 'DCS-OD',
'DCS-PDM', 'DCS-TR')) AND
(dbo.Remedy_Status.Status_Description <> 'Delete') AND
(dbo.CIT_Service_Ticket.Category + dbo.CIT_Service_Ticket.Sub_Cat +
dbo.CIT_Service_Ticket.Source <> 'TrainingRegistrationWWW-Train') AND
(NOT (dbo.CIT_Service_Ticket.Source IN ('MVSDUMP', 'WWW-ASB'))) AND
(dbo.CIT_Service_Ticket.Category + dbo.CIT_Service_Ticket.Source <>
‘EOSWWW-EOS') AND
(dbo.CIT_Service_Ticket.Create_date < CONVERT(DATETIME, '2004-04-01
00:00:00', 102)) AND
(dbo.CIT_Service_Ticket.After_Hours = '0')

Below is a literal definition of the query.

The Status is not ‘Delete’; and Category is not ‘Training’, Sub Category is not
‘Registration’, and Source is not ’WWW-Train’; and Submitter Unit is either 'DCS-TASC',
'WEB', or 'DCS-NAISMC'; and Source is not 'MVSDUMP' or 'WWW-ASB';
and Category is not ‘EOS’, and Source is not ’WWW-EOS’

OR
The Status is not ‘Delete’; and Category is not
‘Training’, Sub Category is not ‘Registration’, and Source is not ’WWW-Train’; and Source is 'WWW-Sponsor' or
'WWW-BORG'; and Category is not ‘EOS’, and
Source is not ’WWW-EOS’; and Source is not 'MVSDUMP' or 'WWW-ASB'

OR
Submitter Unit is 'DCS-DE', 'DCS-DSTEAM', 'DCS-ISG', 'DCS-OD', 'DCS-PDM', or
'DCS-TR'; and Status is not ‘Delete’; and Category is not ‘Training’, Sub Category is
not ‘Registration’, and Source is not ’WWW-Train’; and Source is not 'MVSDUMP'
or 'WWW-ASB'; and Category is not ‘EOS’, and Source is not ’WWW-EOS’; and
Create Date is less than April 1, 2004 and is After Hours