HRMH_OWN_OPR_VW (SQL View)	Index Back
Matrices By Owner OPRID Used by Org Chart Viewer > Company Directory advanced search. Prompt view which returns all active matrices where the owner matches the EMPLID assigned to the current user profile and are available to HRCD_ORGVIEW_TYPE=CDOV.

HRMH_OWN_OPR_VW

(SQL View)

Matrices By Owner OPRID

Used by Org Chart Viewer > Company Directory advanced search. Prompt view which returns all active matrices where the owner matches the EMPLID assigned to the current user profile and are available to HRCD_ORGVIEW_TYPE=CDOV.

SELECT DISTINCT A.OPRID , MD.HRMH_MATRIX_ID , MD.DESCR FROM PSOPRDEFN A , PSOPRALIAS B , PS_HRMH_MATRX_DEFN MD , 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 = 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_OWNOPR_LVW

# 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 HRCD_ADV_SRCH_FLDP Character(70) VARCHAR2(70) NOT NULL Company Directory

#	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	HRCD_ADV_SRCH_FLDP	Character(70)	VARCHAR2(70) NOT NULL	Company Directory