SSR_RS_ASSIGNEDTOINSTITUTIONSSR_RS_STATUSSSR_RS_SRSCHRVW(SQL View) |
Index Back |
|---|---|
Admin Service Request by StatuAdmin Service Request by Status |
| SELECT B.ssr_rs_assignedto , B.institution , B.ssr_rs_status , COUNT(*) SSR_RS_NUM_OF_REQ FROM PS_SSR_RS_REQSTDTL B WHERE B.ssr_rs_req_seq = ( SELECT MAX(C.ssr_Rs_req_seq) FROM PS_SSR_RS_REQSTDTL C WHERE C.emplid= B.emplid AND C.institution=B.institution AND C.ssr_Rs_request_id=B.ssr_Rs_request_id ) GROUP BY B.ssr_rs_assignedto ,B.institution, B.ssr_rs_status |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_RS_ASSIGNEDTO |
Character(11) | VARCHAR2(11) NOT NULL | Request Assigned To |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | SSR_RS_STATUS |
Character(12) | VARCHAR2(12) NOT NULL | Status associated within the status group code. |
| 4 | SSR_RS_NUM_OF_REQ | Number(3,0) | SMALLINT NOT NULL | Number of Requests |