SCC_PS_RREQ_BND (SQL View)	Index Back
PopSel Bind record for RREQ PopSel Bind record for RREQ admin function used by 3C Engine

SCC_PS_RREQ_BND

(SQL View)

PopSel Bind record for RREQ

PopSel Bind record for RREQ admin function used by 3C Engine

SELECT A.EMPLID ,A.ssr_rs_candit_nbr , a.ssr_Rs_rquire_type ,A.INSTITUTION ,B.name FROM PS_SSR_RS_OTHR_REQ A ,PS_SCC_PRI_NAME_VW B WHERE A.EMPLID = B.EMPLID AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_SCC_PRI_NAME_VW X WHERE X.EMPLID = B.EMPLID AND X.EFFDT <= %CurrentDateIn)

# 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 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number

3 SSR_RS_RQUIRE_TYPE Character(2) VARCHAR2(2) NOT NULL Field to hold Research Assignment Types

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	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	SSR_RS_CANDIT_NBR	Character(12)	VARCHAR2(12) NOT NULL	Last Candidate Number
3	SSR_RS_RQUIRE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Field to hold Research Assignment Types
4	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name