How to Store Data Pertaining to a Specific Point in Time - Effective Date - EO/VO

In addition to article and docs about how to use Effective Date feature on EO/VO given below,
History column - created on and modified on could be set to start date and end date column of the table, so that when ever a record is created or updated - automatically start date and end dates gets updates. For fetching sysEffectivedate becomes very handy in range fetching.
In Addition to this, version number becomes handy to set its values to EffectiveDateSeq attribute, Each update of record increase version number incrementally.

Note : Refresh After Insert and Refresh After Update flags to be unchecked to see changes of history columns.
effective date.PNG


Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today