GP_UDELT_EMP_VW(SQL View) |
Index Back |
---|---|
Unprocesed Deltas-PayeeThis view selects payees with unprocessed retro deltas. |
SELECT DISTINCT %Sql(SCRTY_SEL_PKEY,SEC,SEC) , SEC.NAME FROM PS_GP_RSLT_DELTA A , PS_GP_CAL_RUN B , PS_EMPLMT_SRCH_GBL SEC WHERE A.CAL_RUN_ID=B.CAL_RUN_ID AND B.RUN_FINALIZED_TS IS NOT NULL AND A.FORWARD_IND = 'Y' AND A.FWD2_CAL_RUN_ID = ' ' AND A.RTO_MATCH_ACTN <> 'N' AND A.EMPLID = SEC.EMPLID AND A.EMPL_RCD = SEC.EMPL_RCD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |