EMPLIDRETR_MSG_EMP_VW(SQL View) |
Index Back |
|---|---|
Retro EmplID prompt viewRetro EmplID prompt view |
| SELECT A.EMPLID FROM PS_RETROPAY_RQST A WHERE EXISTS ( SELECT 'X' FROM PS_RETROPAY_MSG B WHERE A.RETROPAY_SEQ_NO = B.RETROPAY_SEQ_NO) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |