Slowly changing dimension Type 2 is a model where the whole history is stored in the database. An additional dimension record is created and the segmenting between the old record values and the new (current) value is easy to extract and the history is clear.

The fields 'effective date' and 'current indicator' are very often used in that dimension and the fact table usually stores dimension key and version number.