System Credits Report (INTRC110) New for Release 10.1

Introduction

This report is part of Callista Staff Connect and is used to display students' and sponsors' available system credit amounts, with a range of criteria to search by to obtain the results.

After logging onto Staff Connect, the Report is accessed from the main screen. The report (System Credits Report) can be found from a list under the Reports heading on the left-hand side of the main screen.

The user has the choice of viewing the report in DELIMITEDDATA, PDF or XML.

Different information entered into the fields determines what is in the report. Although the reports have a uniform appearance, the data determines the size and content of the report.

The screen information is based on the existing System Credits Report (INTR0110) in SMS (also known as Unmatched Credit Report).

Refer to the Job Control and Scheduling Subsystem for details on scheduling and running immediate and batch jobs.

The different sections are:

 

 

Example of Screen Layout

example of screen layout

 

Fields

Unmatched Credits Report (INTRC110)

Run Details

 

Field Attributes

Prompt

Field Type

Data Type, Length & Format Mask

Comments

Lower Credit Range

Input Field

Number(10) 99999990.0

Field set in S_JOB_PARAMETER

Upper Credit Range

Input Field

Number(10) 99999990.0

Field set in S_JOB_PARAMETER

Person ID

Input Field with lookup

Number(10) 999999999

Field set in S_JOB_PARAMETER

Sponsor  Code

Input Field with lookup

VARCHAR(30)

Field set in S_JOB_PARAMETER

Minimum Age of Credit (Days)

Input Field

Number(10) 99999990.0

Field set in S_JOB_PARAMETER

Course Attempt Status

Checkboxes, Multiple selection

 

Field set in S_JOB_PARAMETER

Student Status

Poplist

VARCHAR(70)

Field set in S_JOB_PARAMETER

and

Poplist

VARCHAR(70)

Field set in S_JOB_PARAMETER

and

Poplist

VARCHAR(70)

Field set in S_JOB_PARAMETER

Fee Category

Input Field with lookup

VARCHAR(10)

Field set in S_JOB_PARAMETER

and

Input Field with lookup

VARCHAR(10)

Field set in S_JOB_PARAMETER

and

Input Field with lookup

VARCHAR(10)

Field set in S_JOB_PARAMETER

Citizenship Code

Poplist

VARCHAR(70)

Field set in S_JOB_PARAMETER

and

Poplist

VARCHAR(70)

Field set in S_JOB_PARAMETER

and

Poplist

VARCHAR(70)

Field set in S_JOB_PARAMETER

Output Format

Poplist

VARCHAR(10)

This field is populated from table  JOB_OUTPUT_TYPE.S_OUTPUT_TYPE, the default value is the first alphabetical sort order value in this column

 

Validations include:

 

 

Example of a Report

This is an example from only one page of the report produced as a pdf. There are other pages to the report, and depending on selected criteria, what is displayed. Delimited or XML reports will have different layouts.

 

example of print out

 

Last Modified on 20 December, 2007 12:57 PM

History Information

Release Information Project Change to Document
10.1.0.0.0.0 1345 - Change Report Output Format New Document