Wednesday, 2 March 2016

PeopleSoft Access Related SQL's

Access to Component:

Select AUTH.CLASSID As PERMISSION_LIST
, MNUI.MENUNAME
, PNLG.PNLGRPNAME As COMPONENT
, AUTH.DISPLAYONLY
, AUTH.AUTHORIZEDACTIONS

From PSAUTHITEM AUTH
, PSPNLGROUP PNLG
, PSMENUITEM MNUI

Where PNLG.PNLGRPNAME = 'Component Name'
AND AUTH.PNLITEMNAME = PNLG.ITEMNAME
AND AUTH.MENUNAME = MNUI.MENUNAME
AND AUTH.BARNAME = MNUI.BARNAME
AND AUTH.BARITEMNAME = MNUI.ITEMNAME
AND PNLG.PNLGRPNAME = MNUI.PNLGRPNAME

PeopleSoft Toolbar Setup Migration

Tables need to be migrated are following

1) Toolbar Definition:

SELECT * FROM PS_EOTL_TB_DEFN WHERE EOTL_TOOLBAR_ID= 'Toolbar id';
SELECT * FROM PS_EOTL_TB_DISP WHERE EOTL_TOOLBAR_ID=  'Toolbar id';
SELECT * FROM PS_EOTL_TB_FFLD WHERE EOTL_TOOLBAR_ID= 'Toolbar id';
SELECT * FROM PS_EOTL_TB_BTNS WHERE EOTL_TOOLBAR_ID= 'Toolbar id';

2) Toolbar Button:

SELECT * FROM PS_EOTL_BTN_DEFN WHERE EOTL_TB_BTN_ID = 'Button Id';