Skip to end of metadata
Go to start of metadata

When a row is edited, the system adds an inactive row with the same effective date as the new row added.  This will inactivate the old values and the new values will be in place as of the effective date.  A key is established which then allows the search to know which rows are prior edited rows vs new rows.

Show History: The purpose of this radio button is to allow you to see the highest effective dated row only for a record, or the entire history of a record.

Show History= No: The results will be the highest effective dated row as of the system date and any future rows. 

Show History=Yes:  The results will be all rows in the database for the values entered.

 Active: The purpose of this radio button is to allow you to filter rows based on their active status.

               

 **To find the row which is in effect as of today search for active=both, show history=no.

NOTE: This is not working correctly on all the searches yet.  This is being worked on as of 6/15/2011.

  • No labels