SSR_RS_REQTSRCH(SQL View) |
Index Back |
---|---|
Change Requests HeaderChange Request Header Record |
SELECT b.SSR_REQ_SEQUENCE ,a.emplid , b.institution ,a.name , H.ssr_Rs_candit_nbr , h.acad_career , h.descrshort , h.ssr_rs_descrshort ,b.ssr_Rs_rquest_type ,b.ssr_rs_request_id , d.ssr_rs_req_seq ,d.ssr_rs_status , d.ssr_rs_action_dt ,a.national_id ,a.national_id_msk ,a.campus_id ,a.last_name_srch ,a.first_name_srch , d.ssr_rs_assignedto FROM %Table(people_srch) a LEFT OUTER JOIN %Table(ssr_rs_cnd_srch) h ON h.emplid= a.emplid JOIN %Table(SSR_RS_REQSTHDR) b ON B.EMPLID= A.EMPLID LEFT OUTER JOIN %Table(SSR_RS_REQSTDTL) d ON B.EMPLID= D.EMPLID AND B.INSTITUTION= D.INSTITUTION AND b.ssr_rs_request_id= d.ssr_rs_request_id WHERE ( d.ssr_rs_req_seq IS NULL OR ( d.ssr_rs_req_seq= ( SELECT MAX(r.ssr_rs_req_seq) FROM PS_SSR_RS_REQSTDTL r WHERE r.emplid= d.emplid AND r.institution= d.institution AND r.ssr_rs_request_id= d.ssr_rs_request_id) AND d.emplid = a.emplid ) ) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SSR_REQ_SEQUENCE | Number(12,0) | DECIMAL(12) NOT NULL | Unique sequence generated ID for a Serive Request |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
5 | SSR_RS_CANDIT_NBR | Character(12) | VARCHAR2(12) NOT NULL |
Last Candidate Number
Prompt Table: SSR_RS_CNDHDRVW |
6 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
8 | SSR_RS_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Academic Plan |
9 | SSR_RS_RQUEST_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Service Request Type
Prompt Table: SSR_RS_REQSTTYP |
10 | SSR_RS_REQUEST_ID | Number(5,0) | INTEGER NOT NULL | Service Request ID |
11 | SSR_RS_REQ_SEQ | Number(5,0) | INTEGER NOT NULL | Request Sequence |
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 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
15 | NATIONAL_ID_MSK | Character(20) | VARCHAR2(20) NOT NULL | National ID |
16 | CAMPUS_ID | Character(16) | VARCHAR2(16) NOT NULL | Campus ID |
17 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
18 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
19 | SSR_RS_ASSIGNEDTO | Character(11) | VARCHAR2(11) NOT NULL |
Request Assigned To
Prompt Table: PEOPLE_SRCH |