Populating Assignment Type Details

To populate the Assignment Type details, select any of the below Assignment Type option from the drop-down list and do the following:

• No Assignment: This assignment is selected by default and does not have any target column update, but the message details are pushed.
• Direct Value: Enter the Assigned Value. You can specify numeric, decimal, string (Varchar /char), and negative values as required. If the specified Assigned Value characters length exceeds the base column length, then a system alert message is displayed.
• Another Column: Select the required Column as Assigned Value from the drop-down list.
• Code: If any code / leaf values exist for the selected base column, select the required Code as Assigned Value from the drop-down list. If not, you are alerted with a message indicating that No Code values exist for the selected base column.
• Expression: Click button in the Assignment Value column and specify an expression using Specify Expression window. For more information, see Specify Expression.

Note:

The Expression you define in an Assignment Type field basically derives the Assignment value and is not a filter condition as defined for Additional Condition field. Therefore, you need to specify an expression to derive only the resultant value, which needs to be updated into the base column.

For example, the expression “STG_NON_SEC_EXPOSURES.n _accrued_interest * 1.34” on validation, will update the base column with the derived value after multiplying “n_accrued_interest” value by 1.34. Therefore, expressions such as “STG_NON_SEC_EXPOSURES.n_accrued_interest = 1.34” are considered as invalid.