When using EDM business rules can be constructed using one of five methods:
WHERE
SET
INLINE
LOOP
FULL
In this section we will describe how to create a business rule using each type, and why one type would be used versus another.
To implement business rules you must first determine what the functional business requirement is, and then identify what the technical representation of that requirement is. The technical representation of the requirement is a SQL statement.
In our example the business rule is INVOICE IS NOT CLOSED. The technical representation of this requirement may be:
select invoice_header_id from ap_invoice_header where invoice_status <> ‘ CLOSED’;
Our sample interim table would have the following columns:
INVOICE_HEADER_ID
PURGEABLE_FLAGINVOICE_IS_NOT_CLOSED
We will use this example to describe how to use the different condition types.