HRMH_TRN_CTLLVW

(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 , A.LANGUAGE_CD , C.PTCS_INSTANCELBL , A.DESCR254 FROM PSPTCSSRVDEFNLG A ,PSPTCSSRVDEFN B , PSPTCSSRVCONFLG C WHERE A.PTCS_SERVICEID = C.PTCS_SERVICEID AND A.PTCS_SERVICEID = B.PTCS_SERVICEID AND A.LANGUAGE_CD = C.LANGUAGE_CD

  • Related Language Record for HRMH_TRN_CTL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 PTCS_INSTANCELBL Character(50) VARCHAR2(50) NOT NULL Service Label
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254