SSR_RS_ASSIGNEDTOINSTITUTIONSSR_RS_RQUEST_TYPEPrompt Table: SSR_RS_REQTYPVW
SSR_RS_SRCHRTVW(SQL View) |
Index Back |
|---|---|
Admin Service Requests by TypeAdmin Service Requests by Type |
| SELECT B.ssr_rs_assignedto , B.institution , A.ssr_rs_rquest_type , COUNT(*) SSR_RS_NUM_OF_REQ FROM ps_Ssr_Rs_reqstdtl B JOIN PS_SSR_RS_REQSTHDR A ON A.emplid= B.emplid AND A.institution=B.institution AND A.ssr_Rs_request_id=B.ssr_Rs_request_id 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, A.ssr_rs_rquest_type |
| # | 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_RQUEST_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Service Request Type
Prompt Table: SSR_RS_REQTYPVW |
| 4 | SSR_RS_NUM_OF_REQ | Number(3,0) | SMALLINT NOT NULL | Number of Requests |