EMPLIDSCC_DA_PROXY_COMPSCC_DA_PROXY_MENUOPRIDSCC_DA_SRCH_VW(SQL View) |
Index Back |
|---|---|
DA Search ViewSearch View to override in Delegated Accesses Menu |
| SELECT DISTINCT P.EMPLID , TC.SCC_DA_PROXY_COMP , TC.SCC_DA_PROXY_MENU , O.OPRID , N.NAME_DISPLAY FROM PS_SCC_PERS_SA_VW P , PSOPRDEFN O , PS_PERSON_NAME N , PS_SCC_DA_PROXY D , PS_SCC_DA_PRXY_TXN T , PS_SCC_DA_PCOMP_VW TC WHERE P.EMPLID = D.EMPLID AND P.EMPLID = N.EMPLID AND O.OPRID=D.SCC_DA_PRXY_OPRID AND T.EMPLID=P.EMPLID AND T.SCC_DA_TXN_CD=TC.SCC_DA_TXN_CD AND T.SCC_DA_TXN_STATUS='AG' AND D.SCC_DA_PRXY_ID = T.SCC_DA_PRXY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SCC_DA_PROXY_COMP |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 3 | SCC_DA_PROXY_MENU |
Character(30) | VARCHAR2(30) NOT NULL | Pop Select tool menu name field. Used for transfering to the tool's edit page. |
| 4 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | SCC_DA_DELEG_NAME | Character(200) | VARCHAR2(200) NOT NULL | DA Delegator Name |