How to Determine the Application Locking Code of a Function

If you need to find out what type of locking code has been assigned to a function, connect to the database through SQLTalk using the User ID of DELTEK.

Then, issue the following command:

SELECT S_LOCK_MTHD_CD FROM S_APPL_FUNC WHERE FUNC_TITLE_NAME = 'function title';

'function title' must match exactly the name of the function as it appears on the Navigate screen. That means entering the exact spacing and upper- and lower-case letters.

S_LOCK_MTHD_CD must be one of the following:

  • N for no locking
  • S for single locking
  • U for user locking
  • R for restart locking