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 . The rate of change to table values is dependent on the business. For example, a new code will be added to the Location Table only when a new location, not previously occupied by a government office, is occupied.