Issue
Active flag is set as True when a new user(sys_user) record is created. In the OOB data dictionary for the sys_user table, have an active column where the default value is set as "true". You can change as per your needs. Please go to the below link, click the Default Value tab to set the desired value.
https://<instance-name>.service-now.com/sys_dictionary_list.do?sysparm_query=nameSTARTSWITHsys_user%5EelementSTARTSWITHactive%5Ename%3Dsys_user
