HRMH_MATRIX_IDEMPLIDPrompt Table: HRMH_EMPLID_VW
EFFDTDefault Value: %date
LANGUAGE_CDHRMH_FA_DTLS_L(SQL View) |
Index Back |
|---|---|
Matrix FA Dtls Lang ViewMatrix FA Dtls Lang View |
| SELECT A.HRMH_MATRIX_ID , B.EMPLID , A.EFFDT , D.LANGUAGE_CD , D.DESCR FROM PS_HRMH_MATRX_DEFN A , PS_HRMH_MATRX_MEMB B , PS_PERSON_NAME C , PS_HRMH_MTRX_DEF_L D , PSXLATITEM X WHERE A.HRMH_MATRIX_ID = B.HRMH_MATRIX_ID AND A.HRMH_MATRIX_ID = D.HRMH_MATRIX_ID AND A.HRMH_OWNER_EMPLID = C.EMPLID AND %EffdtCheck(HRMH_MATRX_DEFN E,B,%CurrentDatein) AND A.EFFDT = B.EFFDT AND B.HRMH_MEMBER_ACTION=X.FIELDVALUE AND X.FIELDNAME='HRMH_MEMBER_ACTION' AND %EffdtCheck(PSXLATITEM X1,X,%CurrentDatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRMH_MATRIX_ID |
Character(15) | VARCHAR2(15) NOT NULL | Matrix Identifier |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HRMH_EMPLID_VW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |