Table of Contents

Introduction

The Row 01 Entries - Colour Definitions

The Row 02 Entries - Screen Definitions

The Row 03 Entries - The Tab Definitions

The Row 04 Entries - The Screen Objects

The Row 05 Entries - Columns Updateable

The Row 06 Entries - Column Pull Down Lists

The Row 07 Entries - Permissions

The Row 08 Entries - The Non-Default Parameter Values

Appendix A - The Screen Set

Appendix B - The Valid Security Data Set

Appendix C - The Non-Default Parameter Values

Introduction

The Scheduler FE system is more then a front end for the Scheduling module of the Oracle database. It is a front end that can be tailored to the individual requirements. There are two aspects of the Scheduler FE that can be tailored. These are :-

• The Display of the System
• The Functionality of the System

The system uses a flat file, SchedFileData.csv, that contains the parameter data. Each row in the file contains a key that occupies the first two characters. These two characters define the row and categorise it into the following row type entries :-

• 01 - Colour Definitions
• 02 - Screen Definitions
• 03 - Tab Definitions
• 04 - Screen Object Definitions
• 05 - Columns Updateable
• 06 - Column Pull Down Lists

For each of the row types a section has been written that describes the function of that row type and the entries that make up the row entry.

The Row 01 Entries - Colour Definitions

The row 01 entries in the flat file are those that define the colours that are used in the different screen displays. Each colour is uniquely defined by a number, the Colour No. The actual colour is made up of the next four values, the red, green, blue and alpha. The final value is a description of the colour and is there for documentation purposes.

Row types 02 and 04 reference the Colour No. from this row type, type 01.

The Row 02 Entries - Screen Definitions

The row 02 entries in the flat file are the entries that define a distinct screen. Each row entry defines a separate screen and the first value is an id that uniquely defines that screen. The complete list of screens is given in Appendix A together with its screen id and the database view where its data is accessed from if applicable.

The foreground, background and tab colour numbers are numbers that uniquely identify a colour from the 01 row type rows.

The Row 03 Entries - The Tab Definitions

For each of the Tab entries, the screen_id identifies the screen to which it applies and the tab_id identifies the tab within that screen. The screen_id/tab_id must uniquely identify the row. The tab_description is the text that appears on the tab at the top of the data section of the screen.

For each row in this table there is a tab in the specified screen. If there are three rows identified by one screen id then there will be three tabs for that screen. The tab entries only apply to the screen ids 2 to 16, the screens that display the data from the database views. Any entries for the data input screens will be ignored.

The Row 04 Entries - The Screen Objects

The 04 entries relate to the objects found on the screen. Each row corresponds to a screen object, either a label, a test item or a text area.

The table scheduling_pages is the most complex of the setup tables. There is an entry in this table for each item on the screen. The screen_id column identifies the screen no. The column row_type identify whether the item is a label, value 1, or a text item, value 2 or a text area, value 3. The tab id column identifies the tab page that the item is located on. The screen id/tab id must match the screen id/tab id in the row 03 type entry. The object id column must contain a number that is unique for this object on this screen. The following column is not used.

The columns x_point, y_point identify where on the screen the object is position. The columns x_pixels, y_pixels, define the height and width of the individual item. The column description will contain the value displayed on the screen if the entry is a label, otherwise it is used solely for documenting the item. The columns font, font_size and font_style define the font characteristics. The column font_style can contain the values, 1(standard), 2(italic) or 3(bold).

The columns fgrnd_colour and bgrnd_colour define the colour ot the item, both background and foreground colour. The value entered must be a numeric number that corresponds with a colour in the table scheduler_colors. The column format_type should be set to 0 (zero) if the item is a text item and 1 if it is numeric. It will cause the item to be right justified as you would expect a number to be. The column button is set to "Y" when a zoom button is to be displayed to the right of the text. This allows a dialogue showing a far greater amount of text to be displayed. The final two columns display relate to the display of pull down lists. If the Pull Down List column is set to Y then a pull down list is displayed when the column is updated. The number of the pull down list is given in the final column. If this number is below 50 then the pull down list is created from the Row 06 entries. If it is 50 or over then one of the following standard pull down lists is used.

The columns fgrnd_colour and bgrnd_colour define the colour ot the item, both background and foreground colour. The value entered must be a numeric number that corresponds with a colour in the table scheduler_colors. The column format_type should be set to 0 if the item is a text item and 0 (zero) if it is numeric. It will cause the item to be right justified as you would expect a number to be. The column button is set to "Y" when a zoom button is to be displayed to the right of the text. This allows a dialogue showing a far greater amount of text to be displayed. The final two columns display relate to the display of pull down lists. If the Pull Down List column is set to Y then a pull down list is displayed when the column is updated. The number of the pull down list is given in the final column. If this number is below 50 then the pull down list is created from the Row 06 entries. If it is 50 or over then one of the following standard pull down lists is used.

The Row 05 Entries - Columns Updateable

The Row 05 entries define the text items that can be updated. The screen Id and item id define the item and the table name and column name link that item to an entry within a scheduler view. Only the items entered in the 05 entries can be updated. To restrict the user further then the specific entries can be removed from the parameter file.

The Row 06 Entries - Column Pull Down Lists

The row 06 entries define the pull down lists and the values within the pull down lists that the user can select from when a value is being updated or inserted. The pull down list number is the number of the pull down list identified in the row type 04 when associating a pull down list with a displayable text item. The list id is the number of the list item and the pull down list id and list id uniquely identify the entry. The description is the description is the value displayed in the pull down list. It is possible to restrict values entered into a column by editing the pull down list.

The Row 07 Entries - Permissions

The 07 row entries are a security feature that prevent the user accessing functionality. Entries with this row type restrict a user from performing a specific function. In the default parameter file there are no 07 row entries and this is because there is no restrictions within Scheduler FE for the default user. Should you wish to prevent a user from carrying out specific functions then entering 07 type rows can achieve this. The combination of screen no. and option no together with a description of the restriction is given in Appendix B. The third entry in the row, the description is solely for descriptive purposes and serves no function.

The Row 08 Entries - The Non-Default Parameter Values

The 08 row entries are for when there exist the need to change the default values of certain parameters.

When you wish to change the default value of a parameter then a row for the entry can be entered. Appendix C gives the details of the parameters that can be set. It also gives the default value if the entry is not set. An example of a row entry would be as follows:-

08,02,c:\Work\SchedErrors.log,Entry to reset the Error file

This entry would reset the directory of the error file but retain the existing default name of the file.

Appendix A - The Screen Set

The table below identifies the Screen name together with the screen no. and gives the database view that the data is obtained from.

Appendix B - The Valid Security Data Set

Appendix C - The Non-Default Parameter Values