Is there a term for a table that has an "effective date" column?
Temporal Table or History Table are probably the terms you are looking for. Often you will see a nullable "end date" column in the table as well.