Effective Dates add the dimension of time to the Oracle HR application. The Effective Date enables you to change your view of the information forward or backward in time to see how the information has changed.
If you query special information in Oracle HR with your effective date set to today you may get a different result than if you query the same specialist information with the effective date set to one year ago. The special information could have had any number of changes, for example ‘Special Information Type’.
The Effective Date also enables you to create information backward or forward in time (you can determine when these changes take effect from).
Within the Special Information Wizard there is an Effective Date set on the ribbon. The Effective Date will default to ‘Today’, which you can change by using the calendar button or selecting a previously used session value from the dropdown list.
The Effective Date on the ribbon affects the List of Values available in the Special Information Form. Values will only be listed if they are valid as at the Effective Date.
The Effective Date on the ribbon also affects the records that are downloaded into the worksheet. Special Information will be downloaded as at the Effective Date on the ribbon.
The ribbon effective date can be used against a single record, a selection of records or all records on the current sheet. Note: The ribbon effective date can only apply the one set date to multiple records.
