EFFDT and Its behavior in different modes

Effective Date 

> An Effective date is a column in a table , It is a key.

> Effective -dated table contain three types of rows

•  Future
•  Current
•  History

 Here        

   

Future : Data rows that are having date value above to the sysdate

Current : Data rows that are having date value which is near to sysdate

Past : Data rows that are having date value which is less than today's date

Action Types

We are having 4 types of action modes , They are 

 Add  
 Update/Display
 Include History
 Correct History

Effective date & Behavior in diff modes

Add : Just adding a new row of information to the database

Update/Display : You can view the current and future information ,cannot view past information .You can correct future dated rows

Include History : You can view the information of all the modes. But you can edit only future dated rows 

Correction Mode: You can view all the information of all the modes. And at the same time you can edit the information.

	Current	Future	Past
Update/Display	Yes	Yes / Edit	No
Include History	Yes	Yes /Edit	Yes
Correction Mode	Yes /Edit	Yes /Edit	Yes /Edit