Calendar Date Report

Calendar Date Report (CALRC620) New for Release 10.1

Introduction

This report is part of Callista Staff Connect and is used to provide a list of Date Aliases for review for Calendar Instances within a specified Date Range.

After logging onto Staff Connect, the Report is accessed from the main screen. The Report (Calendar Date Reportl) 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 Calendar Date Report (CALR0620) 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

Calendar Date Report (CALRC620)

Date Alias Category (Pop)
Calendar Period (Find Calendar Period)
Calendar Status (Pop)
Range Start Date (Find Start Date) dd/mm/yyyy
Range End Date (Find End Date) dd/mm/yyyy
Included Sub Cal Type (Find Included Sub Cal Type)

Run Details

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

Field Attributes

Prompt	Field Type	Data Type, Length & Format Mask	Comments
Date Alias Category	Poplist	VARCHAR2(60)	Field set in s_job_parameter
Calendar Period	Input field with look up	VARCHAR2(10)	Field set in s_job_parameter. The Find Calendar Period Button calls the SCCALTYPE application in a pop up box passing in p_open_only as Y. This returns the selected cal type to this application
Calendar Status	Poplist	VARCHAR2(60)	Field set in s_job_parameter
Range Start Date	Input Field	DATE DD/MM/YYYY	Field set in s_job_parameter Use Callista Standard calendar.js for Calendar functionality
Range End Date	Input Field	DATE DD/MM/YYYY	Field set in s_job_parameter Use Callista Standard calendar.js for Calendar functionality
Included Sub Cal Type	Input field with look up	VARCHAR2(10)	Field set in s_job_parameter The Find Sub Cal Type Button calls the SCCALTYPE application in a pop up box passing in p_open_only as Y. This returns the selected cal type to this application
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 CALR0620 in immediate mode with the page parameters and selected report output format type
Batch	Button	N/A	Run Oracle Report CALR0620 in batch mode with the page parameters and selected report output format type

Validations include:

Range Start and End Dates must be in a format of dd/mm/yyyy
Range End Date must not be less than Range Start Date
Range Start and End Dates cannot be blank

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:55 PM

History Information

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