HRMH_MATRIX_TYPEEFFDTDefault Value: %date
PNLGRPNAMEPrompt Table: HRMH_TRN_CTL_VW
HR_MTRX_ACTN_VW(SQL View) |
Index Back |
|---|---|
Matrix Type Action ViewMatrix Type Action View |
| SELECT A.HRMH_MATRIX_TYPE ,A.EFFDT ,A.PNLGRPNAME FROM PS_HR_MTRX_TYP_ACT A WHERE A.EFFDT=( SELECT MAX(B.EFFDT) FROM PS_HR_MTRX_TYP_ACT B WHERE B.HRMH_MATRIX_TYPE=A.HRMH_MATRIX_TYPE AND B.EFFDT<=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRMH_MATRIX_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Matrix Type |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: HRMH_TRN_CTL_VW |