NOTE: The CAWIS release of April 2022 gave ADMIN users the ability to Alter existing User-ids under the following conditions :
You cannot change a TC userid (user exists on TC-Directory -or- has an email domain tc.gc.ca)
You cannot change a SYSID ( examples : ccarcsupd, CLIENT, AAIRRUN, AARDG ) A list of SYSIDs can be seen at (Select * from Z980_term_conversion where Term_type_cd = ‘SYSID’)
The New USERID cannot ALREADY exist on A01_user
You cannot change a USERID “BACK” to what it originally was on the same day. An old/previous Userid remains on the A01 table until its deleted by the overnight sync job (synchronize_ccarcs_cawis)
No special characters. Data_compression is applied to New Userid. (A THRU Z, 0 THRU 9 are the only values permitted)
SITUATION #1 - WSDRS USERID CONFLICTS WITH TC USERID
The notes below are retained for backup purposes only. The function described in the introductory notes should be sufficient to perform any cleanups.
...
UPDATE A01_USER SET PARTY_ID = NULL, ACTIVE_IND = 'N'
WHERE USER_ID =
(SELECT TRIM(FROM_TXT) FROM Z980_TERM_CONVERSION WHERE TERM_TYPE_CD = 'USERCHANGE') ;
commit;
SITUATION #2 - ELIMINATION OF INACTIVE WSDRS USERS
The query below identifies inactive WSDRS users having submitted SDR reports.
...