Check the column data contains alphanumeric data in Oracle

select employee_number from per_all_people_f where regexp_like(employee_number,'^[a-zA-Z]');

Output

SC1000
I10001

Effective Date Reminder in Oracle HRMS

Effective Date Reminder

When you are new to DateTrack, you may find it useful to be reminded of your effective date whenever you open a window that contains datetracked information. The reminder appears in a Decision window and asks whether you want to change your effective date. If you choose Yes, the Alter Effective Date window displays.
There is a user profile option called DateTrack:Reminder that determines when the Decision window appears. There are three possible values for this profile option:

• Always

• Never

• Not Today

The Not Today value causes the reminder to appear when you navigate to a datetracked window and your effective date is not today's date.
You can set the value of this profile option in the Personal Profile Values window.