Active Footers and Custom Applications\ In use by Canadian Government

Without programming of any kind, a footer was added to every RoAccess page. "Contact Us" pops up an email to predefined members of their group with the Subject filled out.  "Oracle Documentation Requirements" & "Naming & Description Standards" are pdf documents that contain some of their standards and guidelines.  "Keyword and Abbreviation List" is another pdf document that contains a list of words and their standard abbreviations. Also below, notice how user friendly ItemType names are being used.  Again, no programming was necessary. 8 User Added Applications Below is an example of 8 custom User Applications that were added to RoAccess by this Canadian government organization:   They appear to have come standard with RoAccess.  Below has a description of these buttons: Submit Request - appears on work-request windows. Sends an email to the dba's, the database designer, and the authorizing officer. Email Link - Emails a link to the item. The From and To email addresses are entered by the user. IC Utilities - a list of pre-defined reports that users may find useful. New Oracle Request - Creates a new work-request item. Depending on the user, the authorizing officer, and Dba persons are pre-entered. New Verity Request - Creates a new work-request item. Depending on the user, the authorizing officer, and Dba persons are pre-entered. My Notes - Pops up an edit window of itemtype DBA-NOTE. It opens an item named USERNAME-CurrentMONTH-YEAR (SKJENNAL-APRIL-2002). If the item already exists it opens it, otherwise it creates a new entry. A line is added to the CONTENTS with the date and time. This itemtype is used by the DBA team to keep notes about what's happening. Important Note: integrating these 8 applications to this page (plus three to the ItemList page)  did not require any modification to RoAccess!  You merely make entries into the "configuration file".  Likewise subsequent upgrades of RoAccess will not affect these programs, because they are stored in a "user only" area that is separate from RoAccess so future upgrades will not overwrite them.  Easy to integrate, easy to maintain.