OPRIDEMPLIDPY_MOD_SS_SVW(SQL View) |
Index Back |
|---|---|
Paycheck Modeling SearchPaycheck Modeling Self Service Search View |
| SELECT DISTINCT A.OPRID , A.EMPLID , A.NAME FROM PS_PY_IC_PI_SUM_VW A , PS_PY_MOD_PAYGRP B WHERE B.COMPANY = A.COMPANY AND B.PAYGROUP = A.PAYGROUP AND ( (B.PY_MOD_ACCES_CNTRL = 'E') OR (B.PY_MOD_ACCES_CNTRL = 'T' AND NOT EXISTS ( SELECT 'Y' FROM PS_PY_MOD_PGRP_PRD C WHERE C.COMPANY = B.COMPANY AND C.PAYGROUP = B.PAYGROUP AND (%CurrentDateTimeIn BETWEEN %Dttm(C.START_DT, C.START_TIME) AND %Dttm(C.END_DT, C.END_TIME))))) |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |