Approval Process and Approver Where clauses#
A where clause may be defined in IMWC or IMDAO. Once a where clause is defined it may be used to control what gets approved and by whom when using it at two levels. The first is by the approval process itself and the second is by each approver. In both cases the where clause must be relative to the approval entity as the base table.
It is important to note that approval/approver where clauses for Personnel Actions which make use of assignments must be defined differently than Personnel Actions that do not use assignments. Personnel Actions that do not make use of assignments would have a where clause condition that starts from the EEM_ID column, where as Personnel Actions that use assignments would have a where clause condition that starts from the EAS_ID column.
Example:
Personnel Action where clause for PEEI:
Type | Pedefined | Column | Operator | Value |
---|---|---|---|---|
Ad Hoc | EEM_ID.EAS_ID_PRIME.ID.DPS_ID.POSITION_CODE | Equals | JPT_0015a |
Example:
Personnel Action where clause for PEAS:
Type | Pedefined | Column | Operator | Value |
---|---|---|---|---|
Ad Hoc | EAS_ID.ID.DPS_ID.POSITION_CODE | Equals | JPT_0015a |