HRMH_OWNOPR_LVW

(SQL View)
 Index Back

Matrices By Owner OPRID

Prompt view which returns all active matrices where the owner matches the EMPLID assigned to the current user profile.

SELECT A.OPRID , MD.HRMH_MATRIX_ID , MDL.LANGUAGE_CD , MDL.DESCR FROM PSOPRDEFN A , PSOPRALIAS B , PS_HRMH_MATRX_DEFN MD , PS_HRMH_MTRX_DEF_L MDL , PS_HRMH_ORG_ACCESS OA WHERE A.OPRID = B.OPRID AND B.OPRALIASTYPE = 'EMP' AND MD.EFF_STATUS = 'A' AND %EffdtCheck(HRMH_MATRX_DEFN MDE, MD, %CurrentDateIn) AND B.OPRALIASVALUE = MD.HRMH_OWNER_EMPLID AND MD.HRMH_MATRIX_ID = MDL.HRMH_MATRIX_ID AND MD.EFFDT = MDL.EFFDT 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 for HRMH_OWN_OPR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 HRCD_KEY_01 Character(20) VARCHAR2(20) NOT NULL Generic Key Field
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 HRCD_ADV_SRCH_FLDP Character(70) VARCHAR2(70) NOT NULL Company Directory