How do I fix a Source code record that was created with the wrong Effort?

I created a SOURCE code 'AHQMK18AKAD100' (in Source Code Entry) with the wrong EFFORT  'AA'.  

I am trying to create it with the correct EFFORT = 'AD', but it keeps saying the SOURCE code already exists.

I set the STS =  'D' on the existing record, but when I go to create the correct SOURCE code (with EFFORT 'AD'), an error states that it already exists.
 
In this example, the SOURCE code string 'AHQMK18AKAD100' looks like it already contained the correct EFFORT = 'AD' (in positions 10,11).  It was the EFFORT field that contained the incorrect value 'AA'.

The issue is that the SOURCE code field is the key to the SOURCES table and cannot be changed.  Even when changing the STS to 'D'.  It still exists in the table and a duplicate record cannot be created.

To fix the record:
Since the value of the SOURCE code field already contains the correct EFFORT (in positions 10,11), all that is needed is the correct the value of the EFFORT field to 'AD'.

1.  If the record was set to STS = 'D', then change the STS to 'A'.
2.  Change the value of the EFFORT field to 'AD'.

Environment

 Team Approach

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.