HRMH_NAME_VW

(SQL View)
Index Back

Matrix Employee Name View

Matrix Employee Name View used in Fluid Approvals

SELECT A.HRMH_MATRIX_ID , A.EFFDT , A.EMPLID , N.NAME_DISPLAY FROM PS_HRMH_MATRX_MEMB A , PS_NAMES N WHERE A.EMPLID = N.EMPLID AND N.EFFDT = ( SELECT MAX (NM1.EFFDT) FROM PS_NAMES NM1 WHERE N.EMPLID = NM1.EMPLID AND NM1.NAME_TYPE = 'PRI' AND NM1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HRMH_EMPLID_VW

4 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country