Guardian News & Media
GNM RCS
Calendar
Technical specification
Prepared by O3 Team Limited
Authors Nigel Robson
Creation date 13/12/2013
Document Ref. GNM_RCS_Calendar_TS.docx
Version draft for review
Introduction
Purpose
The document GNM_RCS_System_Configuration_FS.docx is the functional specification that describes what features RCS has in relation to the configuration of the system.
This document is one of a set of technical specifications that provide details of how those functions are implemented in RCS.
Scope
This document focusses on the calendar. Separate documents deal with all other aspects of the system’s configuration.
This document is intended as a high-level technical document outlining how the relevant business functions are implemented in terms of software modules.
Importantly, this document does not aim to provide the level of detail that would be required in a programming specification in areas such as program structure, detailed business rules, data integrity, validation, locking considerations, data security, and calls to/from other software modules, performance considerations, and so forth.
For details of program logic and coding, the reader should refer to the program files themselves.
Calendar
A basic calendar is maintained in RCS primarily to distinguish working days from non-working days.
Populating the calendar
The calendar is populated with dates into the future by a daily database job. This database job executes a packaged procedure called CDAY.POPULATE
This package identifies which dates are bank holidays, with the most complex processing working out when Easter falls each year thereby identifying Good Friday and Easter Monday.
Amending the calendar
Additional working days can be marked on the calendar via the Calendar screen. The Calendar screen is accessible from the menu option: Housekeeping → Calendar
This opens the Oracle Form named rcs_cday_010_pc.fmb as shown below.
This screen is only accessible to RCS Administrators.
Weekends are highlighted with a blue font colour whilst bank holidays have a green font colour.
.
Calendar on date fields
When a user double-clicks on a date field in the RCS application a calendar window is shown:
If the date field is defined to be non-updatable then the “OK” button will be disabled, leaving only a “Cancel” button. For updatable fields the “OK” button is enabled and the user can click on it to pass the date value highlighted in the calendar to the field.
This calendar is integrated with the Calendar described in the previous section to identify bank holidays and highlight them with a yellow background colour, as shown above.
Time periods
When the calendar is populated 48 entries per day (of ½ hour periods) are inserted into the PICTURE_ASSIGNMENTS table. This is used as the basis of the Picture diary. (See the separate documentation relating to the Picture diary.)
End of Document