• It is common practice to include both RowStartDate, RowEndDate, and RowIsCurrent. Here is Kimball Group's (Warren Thornwaite) thinking regarding "RowChangedReason" along with the code to do it:

    http://www.kimballgroup.com/2006/06/01/design-tip-80-adding-a-row-change-reason-attribute/