This ensures that wherever found throughout the system, only the same values can be chosen. In many cases, they will be found under the 'Setup' menu in any module, versus the 'Use' menu, which typically relates to a data entry panel. It is critical as a data entry user and a report developer to understand the linkages between the various tables and how changes to tables will impact other areas of the system. Each effective dated entry on the table symbolizes some change to the data on those records. Generally, this is done in comparison to the current system date.
Data rows that have effective dates less than the current data row.
The data row with the most recent effective date closest to the current system date, but not a future date. Only one row is the current row. Data rows that have effective dates greater than the current system date. Each effective dated row on the table, for each code, will have an effective status. Effective status is either 'Active' or 'Inactive'.