Answers - Configuration Challenge #R1
Challenge
Answers
- First code block
- The business purpose is to exclude transactions whose policy ID is strictly more than 8797.
- This logic could also be moved to a transaction saved query as an alternative since it's quite simple.
- The ToDecimal() call ensures 8797 is always compared with a numeric value.
- For example, should the field value be NULL, $id would become 0.
- For example, should the field value be "123", $id would become 123.
- Without this call, we could get an error comparing a non-numeric value to 8797.
- The call to ToDecimal() is defensive in nature - it's possible that we'll always get numeric values, but it's best to have some safety.
- Second code block
- The business purpose is to reduce the number of false positive crediting alerts.
- Assume that many users are tagged as either "1099" or "W2" but not both.
- Assume that the current plan is for "1099" users only.
- Assume that we have the following crediting alert level.
- Each time we encounter a transaction assigned to a "W2 Agent", we are going to generate an alert (ex: "Failed to credit user 'John The W2 Agent' because it is not a target of this plan"). This can be a bit annoying. It's also quite different from a scenario where we cannot credit ANY user (in which case we'd like to have a crediting alert so we can take action).
- If we know that the transaction can be credited to a "W2 Agent", we know that this isn't a true crediting problem - the owner field "resolves" to a user.
- So, if the owner is a "W2 Agent", we can skip over the transaction and avoid a false positive crediting alert.
- An improved version would be the following:
Related Articles
Answers - Configuration Challenge #R2
Challenge Here is a link to the original challenge. Answers The GetDate() function gets the day component of the calculation's start date (ex: the day component of 2021-10-15 is 15). The business purpose is to use a lower quota of 8000 when the ...Answers - Configuration Challenge #R3
Challenge Here is a link to the original challenge. Answers The business purpose is to calculate a recoverable draw repayment amount. A recoverable draw consists of advances which need to be repaid. A recoverable reward with a positive value is an ...Configuration Challenge #R3
Goal The goal of this configuration challenge is to get your familiar with various formulas. For this challenge, you will analyze formulas and try to determine why they were added. Comments were removed to make the task more difficult. Difficulty ...Configuration Challenge #R2
Goal The goal of this configuration challenge is to get your familiar with various formulas. For this challenge, you will analyze formulas and try to determine why they were added. Comments were removed to make the task more difficult. Difficulty ...Configuration Challenge #R1
Goal The goal of this configuration challenge is to get your familiar with various formulas. For this challenge, you will analyze formulas and try to determine why they were added. Comments were removed to make the task more difficult. Difficulty ...