EMPLIDPrompt Table: RETR_MSG_EMP_VW
EMPL_RCDRETROPAY_SEQ_NORETROMSG_EMPLID(SQL View) |
Index Back |
|---|---|
Retropay Error Message Empl IDRetropay Error Message Empl ID view |
| SELECT A.EMPLID , A.EMPL_RCD , A.RETROPAY_SEQ_NO , C.NAME_DISPLAY FROM PS_RETROPAY_MSG B , PS_RETROPAY_RQST A , PS_NAMES C WHERE B.RETROPAY_SEQ_NO = A.RETROPAY_SEQ_NO AND C.EMPLID = A.EMPLID AND C.NAME_TYPE = 'PRI' AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_NAMES D WHERE D.EMPLID = C.EMPLID AND D.NAME_TYPE = C.NAME_TYPE AND D.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: RETR_MSG_EMP_VW |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | RETROPAY_SEQ_NO |
Character(15) | VARCHAR2(15) NOT NULL | Retro Pay Sequence Number |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |