HRMH_MATRIX_IDPrompt Table: HRBP_MTRX_NONBP
LANGUAGE_CDHRBP_BP_SRCHL(SQL View) |
Index Back |
|---|---|
Rel Lang for HRBP_BP_SRCHRelated language record for HRBP_BP_SRCH. |
| SELECT A.HRMH_MATRIX_ID , L.LANGUAGE_CD , COALESCE(( SELECT ML.DESCR FROM PS_HRMH_MTRX_DEF_L ML WHERE ML.HRMH_MATRIX_ID = A.HRMH_MATRIX_ID AND ML.LANGUAGE_CD = L.LANGUAGE_CD AND ML.EFFDT = ( SELECT MAX(ML1.EFFDT) FROM PS_HRMH_MTRX_DEF_L ML1 WHERE ML1.HRMH_MATRIX_ID = ML.HRMH_MATRIX_ID AND ML1.EFFDT <= %CurrentDateIn )), ( SELECT M.DESCR FROM PS_HRMH_MATRX_DEFN M WHERE M.HRMH_MATRIX_ID = A.HRMH_MATRIX_ID AND M.EFFDT = ( SELECT MAX(M1.EFFDT) FROM PS_HRMH_MATRX_DEFN M1 WHERE M1.HRMH_MATRIX_ID = M.HRMH_MATRIX_ID AND M1.EFFDT <= %CurrentDateIn )), ' ') , COALESCE(( SELECT XL.XLATLONGNAME FROM PSXLATITEMLANG XL WHERE XL.FIELDNAME = 'HRBP_PARTNER_TYPE' AND XL.FIELDVALUE = A.HRBP_PARTNER_TYPE AND XL.LANGUAGE_CD = L.LANGUAGE_CD AND XL.EFFDT = ( SELECT MAX(XL1.EFFDT) FROM PSXLATITEMLANG XL1 WHERE XL1.FIELDNAME = XL.FIELDNAME AND XL1.FIELDVALUE = XL.FIELDVALUE AND XL1.EFFDT <= %CurrentDateIn )), ( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'HRBP_PARTNER_TYPE' AND X.FIELDVALUE = A.HRBP_PARTNER_TYPE AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn )), ' ') FROM PS_HRBP_CONFIG_TBL A , PSLANGUAGES L WHERE L.INSTALLED = 1 AND L.LANGUAGE_CD <> ( SELECT O.LANGUAGE_CD FROM PSOPTIONS O) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRMH_MATRIX_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Matrix Identifier
Prompt Table: HRBP_MTRX_NONBP |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | HRBP_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Business Partner Type Description |