HR_MO_MSE_OVR_IDEFFDTDefault Value: %date
HR_MO_EFFDT_VW(SQL View) |
Index Back |
|---|---|
HR Mouse Over TableHR Mouse Over Table that holds the ID and Description. |
| SELECT MO.HR_MO_MSE_OVR_ID , MO.EFFDT , MO.DESCR100 FROM PS_HR_MO_TBL MO WHERE MO.EFFDT = ( SELECT MAX(MO2.EFFDT) FROM PS_HR_MO_TBL MO2 WHERE MO2.HR_MO_MSE_OVR_ID = MO.HR_MO_MSE_OVR_ID AND MO2.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_MO_MSE_OVR_ID |
Character(15) | VARCHAR2(15) NOT NULL | Mouse Over Data: Mouse Over ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |