HRMH_MBR_NAME_L(SQL View) |
Index Back |
---|---|
Manual Matrix Members andLanaguage record of manual matrix members joined to get members' names. |
SELECT M.HRMH_MATRIX_ID , M.EFFDT , M.EMPLID , L.LANGUAGE_CD , M.HRMH_TITLE FROM PS_HRMH_MATRX_MEMB M , PS_PERSON_NAME N ,PS_HRMH_MTRX_MEM_L L WHERE M.EMPLID = N.EMPLID AND M.HRMH_MATRIX_ID = L.HRMH_MATRIX_ID AND M.EMPLID = L.EMPLID |
# | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | HRMH_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Hierarchy Member Employee Id |