Exam Attendance Rolls (ASSRC6F0) New for Release 10.1

Introduction

This report is part of Callista Staff Connect and is used by exam supervisors to record the attendance/non-attendance of students at examinations. For example, it can be used during examination periods to record comments about individual students attending or not attending examinations.

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

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 user has the choice of viewing the report in DELIMITEDDATA, PDF or XML.

The screen information is based on the existing Exam Attendance Rolls (ASSR06F0) in SMS.

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

The different sections of this file are:

 

Example of Screen Layout

screen layout

 

 

Fields

Exam Attendance Rolls (ASSRC6F0)

Run Details

 

 

Field Attributes

Prompt

Field Type

Data Type, Length & Format Mask

Comments

Examination Calendar

Input Field with Lookup

VARCHAR2(50)

Field set in s_job_parameter

Centrally Managed Examination Only?

Poplist

VARCHAR2(30)

Field set in s_job_parameter
CENTRAL & NON-CENTRAL
CENTRAL ONLY
NON-CENTRAL ONLY

Unit Code

Input Field with Lookup

VARCHAR2(20)

Field set in s_job_parameter

Assessment Item

Input Field

NUMBER(10) Format 999999999

If NULL assume ‘%’ in report

Internal and External Locations?

Poplist

VARCHAR2(18)

Field set in s_job_parameter
Values displayed are:
INTERNAL & EXTERNAL
INTERNAL ONLY
EXTERNAL ONLY

Examination Location

Poplist

VARCHAR2(60)

Field set in s_job_parameter

Examination Venue

Input Field with Lookup

VARCHAR2(60)

Field set in s_job_parameter
When the Examination Venue is selected call SCVENUE in a popup window. This application passes back a venue code. Examination Calendar must be passed into this popup.

Examination Date

Input Field with Lookup

Date DD/MM/YYYY

Field set in s_job_parameter
When the Examination Venue is selected call SCEXAMDT in a popup window. This application passes back a venue code. Examination Calendar must be passed into this popup.

Examination Session

Input Field with Lookup

NUMBER(10)

Field set in s_job_parameter
When the Examination Venue is selected call SCEXMSESS in a popup window. This application passes back a venue code. Examination Calendar must be passed into this popup and examination date will be passed if it is not null.

Report Sort Options

Poplist

VARCHAR2(81)

Field set in s_job_parameter
Available options are:
EXAM LOCATION, EXAM VENUE, EXAM SESSION DATE/START TIME, EXAM START TIME, UNIT CD
EXAM LOCATION, EXAM VENUE, UNIT CD
DATE OF EXAM, EXAM LOCATION, EXAM VENUE, UNIT CD
DATE OF EXAM, EXAM SESSION DATE/START TIME, EXAM LOCATION, EXAM VENUE

Report Body Sort Options

Poplist

VARCHAR2(81)

Field set in s_job_parameter
Available options are:
SURNAME/GIVEN NAME
PERSON ID
SEAT NUMBER

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 ASSR06F0 in Immediate mode with the page parameters and selected report output format type

Batch

Button

N/A

Run Oracle Report ASSR06F0 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 report

 

 

Last Modified on 20 December, 2007 12:54 PM

History Information

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