Business history (START_DT, END_DT)

START_DT and END_DT columns in a table indicate that records in that table have an effective time of period.

START_DT is a mandatory field. It indicates the date when this record becomes active.

END_DT must always be equal to or later than the START_DT.

END_DATE is a nullable column. If you set the value of a record’s END_DT column to the current time stamp, you will expire the record. If you want to enable this record, you can set the value in the END_DT column to either a future date or null.