The %Eff Dt Check construct expands into an effective date subquery suitable for a Where clause. recordname: Specify the record name to use as the record in the effective-date checking. This can be bind variable, a record object, or a record name in the form recname.correlation_id1: (Optional) Specify the letter used inside the effective-dating subselect. WHERE %Eff Dt Check(recordname correlation_id, as_of_date) The example code resolves into the following: SELECT .
Choose False if your intention is to add or change these items (because past items cannot be changed).
It is also possible to have multiple effective-dated items having the same effective date.
In this situation, an additional property, Effective Sequence (EFFSEQ), must also be provided.
[Unless specifically noted, the content in this topic applies to Biz Talk Server 20 R2.]People Soft Enterprise provides the ability to schedule and keep track of planned items by using a special property called Effective Date (abbreviated EFFDT).
Such items are either in effect or merely planned, depending on whether their date is before or after the People Soft current date.
If the properties of a component interface contain such effective-dated items (that is, a field with a name of EFFDT), the adapter makes it possible for callers to retrieve the complete set of values or only those values not yet effective—those that can still be changed.
parameter is set to False, only the current and future effective-dated items are returned.
This can be a bind variable, a variable, or a hard-coded date.
The value for as_of_date is automatically wrapped in%Date In unless as_of_date is already wrapped in %Date In or refers to other database columns.