HRMH_TRN_CTL_VW

(SQL View)
 Index Back

Matrix Transaction Control Tab

This lists the components that can be used as actions with any matrix. It is system data and we will deliver it with no online interface. It drives the transactions available.

SELECT DISTINCT PNLGRPNAME , PTCS_INSTANCELBL , DESCR254 FROM PSPTCSSRVDEFN A ,PSPTCSSRVCONF C WHERE A.PTCS_SERVICEID = C.PTCS_SERVICEID AND C.PORTAL_OBJNAME = (CASE WHEN EXISTS( SELECT 'X' FROM PSPNLDEFN WHERE PNLNAME='HR_EE_MTRX_FL') THEN 'HC_HRMH_MTRX_TRAN_FL' ELSE 'HC_HRCD_CO_DIRECTORY_GBL' END) AND PNLGRPNAME IN ( SELECT PNLGRPNAME FROM PS_HR_DR_UI_CFG)

  • Related Language Record: HRMH_TRN_CTLLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 PTCS_INSTANCELBL Character(50) VARCHAR2(50) NOT NULL Service Label
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254