Oracle® Insurance Rules Palette
The Date field is used to provide the user with a way to capture date information.
Date Field in Palette Window
Drag and drop the Date field from the Palette window onto the Fields Pane. The Field Properties window will open, which provides the means for configuring the field. Enter the field information such as field name, display name, etc., by clicking in the field and typing the information.
The Format property in the FieldProperties window allows a user to specify a date display format. The format must first exist in the AsTranslation table so it can be referenced in the Format field. If the format does not already exist, a record can be added to the AsTranslation table through the Localization Editor.
The Calendar property allows a user to specify a calendar to use for the date field. The Imperial and Gregorian calendars are the only calendars which are supported by the system so the translation value on the AsTranslation table must be either Japanese or Gregorian stored in English only.
Date Format in Localization Editor
Specific dates can be calculated using the Calculated property in the FieldProperties Window. Click the button to the right of that property and the Date Field-Calculated window will open. Select the type of calculation, the method and then enter any necessary statements in the box provided. The Test button is an additional tool that can be used to run through a SQL statement to see if any errors occur. Select OK when the calculated information is complete.
Calculated Option in Field Properties and Date Field-Calculated Window
Copyright © 2009, 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices