Report writing provides functional areas with capabilities of creating reports that pertain to their area for better informed decisions. The types of report writing that we support are:
Argos
Cool Query
ApEx
SQR
Service Users
Administrative Department
Staff
Faculty
FSA
User Services
The report writing functions will give the campus community quick access to institutional data from various sources.
Business Services
Ad hoc queries
Dashboards
Technical Services
Backups, upgrades and maintenance
New data block creation
Account loads and security schemas
Requirements
Functional areas may request the creation of new reports/data blocks and provide a list of user who will need access to the reports.
Rates / Cost of Use
The regular use of this service does not require a fee.
Users can expect a response within 1 business day for new requests and changes.
What is not included:
List what is not included in the service
Informal support
Business Procedures
Documentation for this service is stored within the systems share on fredshare.
Change Procedures
Changes to the service (transition, additions, and discontinuations) must be reviewed and approved by the CIO.
Assigned Primary Support
Sally Crist, Teresa Dodge, Linda Ippolito, Charles Reed
Assigned Secondary Support
Sally Crist, Teresa Dodge, Linda Ippolito, Charles Reed
RACI Chart
Name: Argos
Description: Argos is a reporting tool used to simplify data retrieval from our institutional databases.
Level
Responsible
Accountable
Consulted
Informed
Primary
Charles Reed
Sally Crist
DBA
End User
Secondary
Teresa Dodge
CIO
End User
Tertiary
Linda Ippolito
Provost
Name: Cool Query
Description: Cool Query is a home-grown reporting mechanism for a Banner Oracle database.
Level
Responsible
Accountable
Consulted
Informed
Primary
Linda Ippolito
Sally Crist
DBA
End User
Secondary
Charles Reed
CIO
End User
Tertiary
Teresa Dodge
Provost
Name: ApEx
Description: ApEx is a tool for developing web applications with SQL and PL/SQL. ApEX resides on the development environment. The COE NYSTCE score processing is used for production data purposes.
Level
Responsible
Accountable
Consulted
Informed
Primary
Charles Reed
Sally Crist
DBA
College of Ed
Secondary
Teresa Dodge
CIO
Tertiary
Provost
Name: SQR
Description: Structured Query Reporter is a programming language designed for generating reports from a database management system.