Overview

You have a new employee and need to map user initials to EKEY_ID (Employee Number).

Information

Input information

To get these records eliminated from the database, you must first reunite the following information:

• Full Name 
• Initials (Will be called <INITIALS> from now on)
• Employee Number (Will be called <EKEY_ID> from now on)

Query to add

To map users to their initials, complete the following steps:

1. Connect to the Database using SSMS.
2. On the left side of the screen, look for the SQL Server Agent menu, and open it.
   
   If you don't see this option in such a menu, make sure you follow the Cannot see the SQL Server Agent section displayed in the SSMS left panel KB Article.
3. Expand the Jobs folder and look for the MMU Job you will affect.
4. Add the following scripts to each step:
   
   

   Step #	Line to add
   37	Update CTExternal_Source..[DDA_Personal_Savings] set Banker = '<EKEY_ID>' where Banker = '<INITIALS>'
   	Update CTExternal_Source..[DDA_Personal_Savings] set Officer = '<EKEY_ID>' where Officer = '<INITIALS>'
   38	Update CTExternal_Source..[DDA_Business_Checking] set Banker = '<EKEY_ID>' where Banker = '<INITIALS>'
   	Update CTExternal_Source..[DDA_Business_Checking] set Officer = '<EKEY_ID>' where Officer = '<INITIALS>'
   39	Update CTExternal_Source..[CD_IRA] set Banker = '<EKEY_ID>' where Banker = '<INITIALS>'
   	Update CTExternal_Source..[CD_IRA] set Officer = '<EKEY_ID>' where Officer = '<INITIALS>'
   40	Update CTExternal_Source..[DDA_Business_Savings] set Banker = '<EKEY_ID>' where Banker = '<INITIALS>'
   	Update CTExternal_Source..[DDA_Business_Savings] set Officer = '<EKEY_ID>' where Officer = '<INITIALS>'
   41	Update CTExternal_Source..[DDA_Personal_Checking] set Banker = '<EKEY_ID>' where Banker = '<INITIALS>'
   	Update CTExternal_Source..[DDA_Personal_Checking] set Officer = '<EKEY_ID>' where Officer = '<INITIALS>'
   42	Update CTExternal_Source..[Loans_PR2_Consumer_Installment] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   43	Update CTExternal_Source..[Loans_PR1_Consumer_Term] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   44	Update CTExternal_Source..[Loans_AG1_Agriculture] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   45	Update CTExternal_Source..[Loans_CM1_Commercial_Term] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   46	Update CTExternal_Source..[Loans_CM2_Commercial_Installment] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   47	Update CTExternal_Source..[Loans_CM4_Commercial_Other] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   48	Update CTExternal_Source..[Loans_CM5_Commercial_Other] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   49	Update CTExternal_Source..[Loans_CM6_Commercial_Other] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   50	Update CTExternal_Source..[Loans_RECM1_RE_Commercial_Construction] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   51	Update CTExternal_Source..[Loans_RECM2_RE_Commercial_Land] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   52	Update CTExternal_Source..[Loans_RECM3_RE_Commercial_Land_Development] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   53	Update CTExternal_Source..[Loans_RECM4_RE_Commercial] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   54	Update CTExternal_Source..[Loans_REPR1_RE_Personal_Construction] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   55	Update CTExternal_Source..[Loans_REPR4_RE_Personal_Land] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   56	Update CTExternal_Source..[Loans_REPR5_RE_Personal_1_4_Family] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   57	Update CTExternal_Source..[Loans_REPR6_RE_Mortgage] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   58	Update CTExternal_Source..[Loans_SPBHG] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   59	Update CTExternal_Source..[Loans_CM3_Commercial_Other] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'
   60	Update CTExternal_Source..[Loans_REPR3_RE_Personal_HI_Construction] set Officer_Code = '<EKEY_ID>' where Officer_Code = '<INITIALS>'

Contacting Support

If you want support to execute this backend modification on your behalf, please contact the Support staff and provide them with the information described in the Input information section.  A customer support representative will contact you back with the result of the execution of the aforementioned task.