The e-Services Report Engine was developed to give super-users the ability to respond to changing business needs. Reports can be created on demand and shared with one's own department or with other departments to address information needs as rapidly as possible.
Reports Builders allow for quick generation of reports without having to write SQL statements.
Reports can be viewed several ways:
- Web-based version / HTML
- Excel version
- Rich-Text Field RTF version
- Extensible Markup Language XML version
The Report Engine home page is navigated to from the e-Services home page. The Report Engine or Report link is located under almost every Department heading on the left side of the page.
CIS Report Builder can be navigated to from the e-Services home page. The Report Builder link is found under:
- Admission
- Honors Programs
Custom Reports can be created for specific departments or shared between departments. SQL statements can be directly typed in the text box or a SQL Builder Graphic User Interface (GUI) Editor can be used for quicker and easier SQL statement development.
Clusters are pre-built modular query column definitions that can be used in the SELECT portion of a SQL statement. These Clusters allow for re-using SQL code that has already been developed and tested. Using Clusters will decrease the time it takes to create new reports and increase efficiency. Clusters have been designed for:
- ADM - Prospective Students Audiences.
- CS - Current Students Audiences.
Note: When a cluster is inserted into a SQL statement the title of the cluster will be in curly brackets (example: {AD Mailing Cluster Excel}). See Building Content SQL Statements (Using Clusters).
Snippets are pre-built modular query criteria definitions that can be used in the WHERE portion of a SQL statement. These Snippets allow for re-using SQL code that has already been developed and tested. Using Snippets will decrease the time it takes to create new reports and increase efficiency. Snippets have been designed for:
- ADM - Prospective Students Audiences.
- CS - Current Student Audiences.
- DV - Alumni Audiences.
Note: When a snippet is inserted into a SQL statement the title of the snippet will be in curly brackets (example: {Address}). See Building Audience SQL Statements (Using Snippets).
There are several CIS Report Builders within e-Services. These Report Builders allow the user to quickly generate relevant reports without typing the SQL statement. The SQL statement that is generated by the report is displayed within the HTML code. Copying this SQL statement and pasting it into the Reports Engine allows for saving the report for future use.
The Data Dictionary lists all of the tables available for retrieving information. Information on these tables are used when developing SQL statements to generate the desired reports. The following information is listed in the tables:
- Table Name. The Table Name will be used in the SQL statement to select which table to retrieve the information (example: xxad_personmaster_v).
- Column Name. The Column Name lists all the information that may be available for each record stored in the table. Column Name will be used to select what information is to be retrieved from the table. It will also be used to determine what information is to be used when determining the criteria for the data (example: person_id).
- Data Type. This will list the type of data that this field holds.
- Data Length. This is the maximum character length for the field (example: 22).
- Data Precision. This is the number of digits following the decimal point in a numeric field.
- Nullable. When "N" is in this field, this entry in the Column Name is a requirement. This information will always be available for each record. If "Y" is in the field, then the information is optional. The record may or may not have information in the field.
- Description. This will be a brief description of the information contained in this column.
The Reports with the user's security access can be searched via keywords. This allows for quick filtering of the displayed reports.