2010-05-31

PSAUTHITEM.AUTHORIZEDACTIONS Codes indicating the Authorized Actions

In Table PSAUTHITEM

AUTHORIZEDACTIONS Codes : the Authorized Actions
1: Add
2: Update Display
3: Add/Update/Display
4: Update/Display All
5: Add/Update/Display All
6: Update/Display/Update/Display All
7: Add/Update/Display/Update/Display All
8: Correction
9: Add/Correction
10: Update/Display / Correction
11: Add/Update/Display/Correction
12: Update/Display All/Correction
13: Add/Update/Display All/Correction
14: Update/Display/Update/Display All/Correction
15: Add/Update/Display/Update/Display All/Correction
128: Data Entry

For all the authorized actions for a given menu item for a given operator, these numbers are added together and stored in the authorizedactions column.

For example, if the value for authorizedactions column is 143, the operator is authorized for all the actions. (1+2+4+8+128) .

As another example, if the value is 7, the operator is authorized for the actions Add, Update/Display, Update/Display All (1+2+4).

1 comment:

Alphonse PROFFIT said...

Here is a SQL order for this information

select classid, MENUNAME, barname, baritemname, PNLITEMNAME, DISPLAYONLY,AUTHORIZEDACTIONS
,BITAND(AUTHORIZEDACTIONS,1) as add_
,BITAND(AUTHORIZEDACTIONS,2)/2 as update_display_
,BITAND(AUTHORIZEDACTIONS,4)/4 as update_display_all
,BITAND(AUTHORIZEDACTIONS,8)/8 as correction_
from PSAUTHITEM;