If this option is set when a particular user is created, that user is marked with QA_USER_FLAGS_WELCOME_NOTICE=64 in their flags column as requiring the notice to be displayed. The notice will be displayed as the pink banner at the top of the page, until the user dismissed it. It's not based on any characteristic of the user like time since registration or points - just the presence of this flag in the database.