SSR_RS_ADMREQVW(SQL View) |
Index Back |
|---|---|
Admin Service Requests |
| SELECT A.emplid , A.institution , B.ssr_Req_sequence , A.ssr_rs_request_id , A.ssr_rs_req_seq , B.ssr_rs_candit_nbr , A.ssr_Rs_request_dt , Cat.ssr_Rs_request_cat , B.ssr_rs_rquest_type , B.ssr_Rs_req_subtype , A.ssr_rs_assignedto , A.ssr_rs_status , A.ssr_rs_action_dt , Emp.name_display SSR_RS_DESCR50 FROM %Table(SSR_RS_REQSTDTL) A JOIN %Table(SSR_RS_REQSTHDR) B ON A.emplid = B.emplid AND A.institution=B.institution AND A.ssr_Rs_request_id = B.ssr_Rs_request_id JOIN %Table(SSR_RS_REQSTTYP) Cat ON B.institution = Cat.institution AND B.ssr_rs_rquest_type = Cat.ssr_Rs_rquest_type JOIN %Table(SCC_PRI_NAME_VW) Emp ON Emp.emplid = A.emplid WHERE %EffdtCheck(SSR_RS_REQSTTYP eff2, Cat, %currentdatein) AND A.ssr_rs_req_seq = ( SELECT MAX(A1.ssr_rs_req_seq) FROM %Table(SSR_RS_REQSTDTL) A1 WHERE A.emplid = A1.emplid AND A.institution=A1.institution AND A.ssr_Rs_request_id = A1.ssr_Rs_request_id) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 3 | SSR_REQ_SEQUENCE | Number(12,0) | DECIMAL(12) NOT NULL | Unique sequence generated ID for a Serive Request |
| 4 | SSR_RS_REQUEST_ID |
Number(5,0) | INTEGER NOT NULL | Service Request ID |
| 5 | SSR_RS_REQ_SEQ | Number(5,0) | INTEGER NOT NULL | Request Sequence |
| 6 | SSR_RS_CANDIT_NBR | Character(12) | VARCHAR2(12) NOT NULL |
Last Candidate Number
Prompt Table: SSR_RS_CND_SRCH |
| 7 | SSR_RS_REQUEST_DT | Date(10) | DATE | Request date |
| 8 | SSR_RS_REQUEST_CAT | Character(10) | VARCHAR2(10) NOT NULL | Service Request Category |
| 9 | SSR_RS_RQUEST_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Service Request Type
Prompt Table: SSR_RS_REQTYPVW |
| 10 | SSR_RS_REQ_SUBTYPE | Character(5) | VARCHAR2(5) NOT NULL |
Service Request Subtype
Prompt Table: SSR_RS_RQSUBTYP |
| 11 | SSR_RS_ASSIGNEDTO | Character(11) | VARCHAR2(11) NOT NULL |
Request Assigned To
Prompt Table: PEOPLE_SRCH |
| 12 | SSR_RS_STATUS | Character(12) | VARCHAR2(12) NOT NULL |
Status associated within the status group code.
Prompt Table: SSR_RS_RQSTSTVW |
| 13 | SSR_RS_ACTION_DT | Date(10) | DATE | Status Date |
| 14 | SSR_RS_DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Student Name |