HRMH_MTXSRCH_VW

(SQL View)
 Index Back

Matrix Teams Search Prompt

Used by Org Chart Viewer > Company Directory advanced search. Prompt view which returns all active matrices available to HRCD_ORGVIEW_TYPE=CDOV.

SELECT MD.HRMH_MATRIX_ID , MD.DESCR %Concat ' (' %Concat MD.HRMH_MATRIX_ID %Concat ')' FROM PS_HRMH_MATRX_DEFN MD , PS_HRMH_ORG_ACCESS OA WHERE MD.EFF_STATUS = 'A' AND %EffdtCheck(HRMH_MATRX_DEFN MDE, MD, %CurrentDateIn) AND MD.HRMH_MATRIX_ID = OA.HRMH_MATRIX_ID AND MD.EFFDT = OA.EFFDT AND OA.HRCD_ORGVIEW_TYPE = 'CDOV' AND OA.HRMH_ORGTYP_ACCESS = 'Y'

  • Related Language Record: HRMH_MTXSRC_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRCD_KEY_01 Character(20) VARCHAR2(20) NOT NULL Generic Key Field
    2 HRCD_ADV_SRCH_FLDP Character(70) VARCHAR2(70) NOT NULL Company Directory