Course Data Report Extended

Course Data Report Extended (CRSRC625) New for Release 10.1

Introduction

This report is part of Callista Staff Connect and is used to list detailed information about courses for the purpose of review on an annual basis

After logging onto Staff Connect, the Report is accessed from the main screen. The report (Course Data Report Extended) 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 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 Course Data Report - Extended (CRSR0625) in SMS.

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

The different sections are:

Introduction
Example of Screen Layout
Fields
Field Attributes
Example of Report

Example of Screen Layout

example of screen layout

Fields

Course Data Report - Extended (CRSRC625)

Academic Period (Pop)
Org Unit Member Type (Pop)
Responsible Organisational Unit (Find Organisational Unit)
Course Status (Pop)
and (Pop)
and (Pop)
Course Type (Pop)
Location (Pop)
Attendance Mode (Pop)
Attendance Type (Pop)
Owning Organisational Unit (Find Organisational Unit)
Sort By (Pop)

Run Details

Output Format (Pop)
Run Mode (Immediate) (Batch)

Field Attributes

Prompt	Field Type	Data Type, Length & Format Mask	Comments
Academic Period	Poplist	VARCHAR2(10)	Field set in s_job_parameter
Org Unit Member Type	Poplist	VARCHAR(60)	Field set in S_JOB_PARAMETER
Responsible Organisational Unit	Input Field with lookup	VARCHAR(10)	Field set in S_JOB_PARAMETER The Find Organisational Unit will take the user to SCCVOUPLST application in a pop up. This will return an org unit and org unit start date.
Course Status	Poplist	VARCHAR(60)	Field set in S_JOB_PARAMETER
and	Poplist	VARCHAR(60)	Field set in S_JOB_PARAMETER
and	Poplist	VARCHAR(60)	Field set in S_JOB_PARAMETER
Course Type	Poplist	VARCHAR(60)	Field set in S_JOB_PARAMETER
Location	Poplist	VARCHAR(60)	Field set in S_JOB_PARAMETER
Attendance Mode	Poplist	VARCHAR(10)	Field set in S_JOB_PARAMETER
Attendance Type	Poplist	VARCHAR(10)	Field set in S_JOB_PARAMETER
Owning Organisational Unit	Input Field with lookup	VARCHAR(10)	Field set in S_JOB_PARAMETER The Find Organisational Unit will take the user to SCUOOUPLST application in a pop up. This will return an org unit and org unit start date.
Sort By	Poplist	VARCHAR(49)	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
Immediate	Button	N/A	Run Oracle Report crsr0625 in immediate mode with the page parameters and selected report output format type
Batch	Button	N/A	Run Oracle Report crsr0625 in batch mode with the page parameters and selected report output format type

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 a report

Last Modified on 20 December, 2007 12:56 PM

History Information

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