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 highly recommended that properly built where clauses be used on both the approval process and approver levels. If the refining of approval processes and approvers is not properly done performance will be an issue
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 |
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation