Required fields, formatted fields, workflow restrictions and data integrity

I need the ability to require data fields to be filled in by a specific user in a workflow before the process can progress. Ideally those fields would be formatted and locked as well after the data is entered.

Agree, required or mandatory fields should be a tool of any mature database management system.