HRCD_KEY_01LANGUAGE_CDHRMH_MTXSRC_LVW(SQL View) |
Index Back |
|---|---|
Matrices By Owner OPRIDPrompt view which returns all active matrices where the owner matches the EMPLID assigned to the current user profile. |
| SELECT MD.HRMH_MATRIX_ID , MDL.LANGUAGE_CD , MDL.DESCR FROM PS_HRMH_MATRX_DEFN MD , PS_HRMH_MTRX_DEF_L MDL , PS_HRMH_ORG_ACCESS OA WHERE MD.EFF_STATUS = 'A' AND %EffdtCheck(HRMH_MATRX_DEFN MDE, MD, %CurrentDateIn) 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' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRCD_KEY_01 |
Character(20) | VARCHAR2(20) NOT NULL | Generic Key Field |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | HRCD_ADV_SRCH_FLDP | Character(70) | VARCHAR2(70) NOT NULL | Company Directory |