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

SCC_PS_THES_BND

(SQL View)

PopSel Bind record for THES

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

SELECT A.EMPLID ,A.ssr_rs_candit_nbr ,A.ssr_rs_submssn_nbr ,A.INSTITUTION ,B.name FROM PS_SSR_RS_THESIS 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_SUBMSSN_NBR Number(3,0) SMALLINT NOT NULL This field indicates the number of times the thesis has been resubmitted for examination

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_SUBMSSN_NBR	Number(3,0)	SMALLINT NOT NULL	This field indicates the number of times the thesis has been resubmitted for examination
4	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name