EG_CASE_SRCH(SQL View) |
Index Back |
|---|---|
Case Review Security ViewEG_CASE_SCRTY_V uses Department Security to restrict access of the Review Path panel based on the current review Department. |
| SELECT CR.EMPLID ,CR.EG_CASE_ID ,SEC.OPRID ,CR.EG_CASE_TYPE ,CR.EG_CASE_STATUS ,RP.EG_DEPTID_REVIEW ,A.NAME ,A.LAST_NAME_SRCH ,SEC.SETID FROM PS_EG_CASE_REVIEW CR ,PS_EG_REVIEW_PATH RP ,PS_PERSON_NAME A ,PS_DEPT_SEC_SRCH SEC WHERE RP.EG_DEPTID_REVIEW = SEC.DEPTID AND CR.EMPLID = RP.EMPLID AND CR.EG_CASE_ID = RP.EG_CASE_ID AND RP.EMPLID = A.EMPLID AND RP.EG_REVIEW_STEP = ( SELECT MAX(RP1.EG_REVIEW_STEP) FROM PS_EG_REVIEW_PATH RP1 WHERE RP1.EMPLID = RP.EMPLID AND RP1.EG_CASE_ID = RP.EG_CASE_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
EG_CASE_REVIEW
|
| 2 | EG_CASE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Case ID |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | EG_CASE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Case Type
FTE=FTE Review MIX=Mixed RNK=Rank Review TEN=Tenure Review TTL=Title Review |
| 5 | EG_CASE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Case Status
A=Approved D=Disapproved I=In Appeal O=Open |
| 6 | EG_DEPTID_REVIEW | Character(10) | VARCHAR2(10) NOT NULL | Current Review Department |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 8 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 9 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|