Sync Full Name with First Name, Last Name and Middle Name
Hi, we have a Employee who recently changed his/her name.
Originally, She was "Singer, Ms. Britney N" (Note that this is just a sample name, not her real name), but recently changed to "Britney Nicole Moore".
EFFECTIVE_START_DATE | EFFECTIVE_END_DATE | FULL_NAME | FIRST_NAME | LAST_NAME | MIDDLE_NAMES |
6/30/2015 12:00 | 10/1/2017 12:00 | Singer, Ms. Britney N (Britney) | Britney | Singer | N |
4/20/2015 12:00 | 6/29/2015 12:00 | Singer, Ms. Britney N (Britney) | Britney | Singer | N |
10/2/2017 12:00 | 12/31/4712 12:00 | Singer, Ms. Britney N (Britney) | Britney | Moore | Nicole |
Is it possible to change her Full Name to "Moore, Ms. Britney Nicole (Nicole)"?
Thank you very much!
Tagged:
0