Add 2FA account into CAMIS

1. Connect using TWOFA@TTSXP18

2. Get next value from sequence: SELECT AC040_STAKEHOLDER_ID_SEQ.nextval FROM dual;

3. Create record in the TWOFA.AC040_STAKEHOLDER table - use an existing record as a template
   **Note: GLOBAL_USERID_LBL is just a random string of 12 alphanumeric characters. You can use sites like https://passwordsgenerator.net/ to generate the string

   INSERT INTO TWOFA.AC040_STAKEHOLDER (STAKEHOLDER_ID, STAKEHOLDER_TYPE_CD, NAME_FIRST_NM, NAME_LAST_NM, STAKEHOLDER_CREATED_ID, GLOBAL_USERID_LBL, USER_LAST_UPDATE_ID)
   VALUES (:value_from_step_2, 1, 'First Name', 'Last Name', 1, :12_chars_alphanumeric, 1);

4. Create a record in the TWOFA.AC043_INTERNAL_STAKEHOLDER table - use existing record as a template

   INSERT INTO TWOFA.AC043_INTERNAL_STAKEHOLDER
   VALUES (:value_from_step_2, 1, :12_chars_alphanumeric, 1, :tc_user_id, SYSDATE, NULL, SYSDATE, 1);

5. Copy the string from TWOFA.AC040_STAKEHOLDER.GLOBAL_USERID_LBL into CAMIS database CAMIS.AA008_APPLICATION_USER.TWOFA_USERID_LBL for the newly created TWOFA account.

   UPDATE CAMIS.AA008_APPLICATION_USER 
   SET TWOFA_USERID_LBL = :12_chars_alphanumeric
   WHERE TC_USER_ID = :tc_user_id;

6. Create in the TWOFA.AC002_XREF_APPLICATION_USER table - use existing record as a template
   ** BE SURE TO SET ROLE_CD = 2

Example:
User: Michelle Le (LEMI)

INSERT INTO TWOFA.AC040_STAKEHOLDER (STAKEHOLDER_ID, STAKEHOLDER_TYPE_CD, NAME_FIRST_NM, NAME_LAST_NM, STAKEHOLDER_CREATED_ID, GLOBAL_USERID_LBL, USER_LAST_UPDATE_ID)
VALUES (2491, 1, 'Michelle', 'Le', 1, 'J5MBODB0SAJM', 1);

INSERT INTO TWOFA.AC043_INTERNAL_STAKEHOLDER
VALUES (2491, 1, 'J5MBODB0SAJM', 1, 'LEMI', SYSDATE, NULL, SYSDATE, 1);

UPDATE CAMIS.AA008_APPLICATION_USER 
SET TWOFA_USERID_LBL = 'J5MBODB0SAJM' 
WHERE TC_USER_ID = 'LEMI';