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'. When a code's status is 'Active', the code is considered to be in use, in relation to the effective date . When on a data entry panel that has a field referenced by a table, the code will appear in a prompt list. When a code's status is 'Inactive', the code is considered to no longer be in use, in relation to the effective date .