Add 2FA account into CAMIS

2FA account creation so that the CAMIS administrator can assign eMER status to CAME.
This assumes that record in CAMIS has already been created.

Connect using TWOFA@TTSXP18
Get next value from sequence: SELECT AC040_STAKEHOLDER_ID_SEQ.nextval FROM dual;

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, '[Random 12 chars alphanumeric]', 1);

Example:

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);

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

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

Copy the random characters from TWOFA.AC040_STAKEHOLDER.GLOBAL_USERID_LBL into CAMIS database CAMIS.AA008_APPLICATION_USER.TWOFA_USERID_LBL for the newly created TWOFA account
Create in the TWOFA.AC002_XREF_APPLICATION_USER table - use existing record as a template
** BE SURE TO SET ROLE_CD = 2