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

SCC_PS_TOPC_BND

(SQL View)

PopSel Bind record for TOPC

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

SELECT A.EMPLID ,A.ssr_rs_candit_nbr ,a.ssr_rs_topic_seq ,A.INSTITUTION ,B.name FROM PS_SSR_RS_TOPC_HDR 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_TOPIC_SEQ Number(3,0) SMALLINT NOT NULL This field is used to create a unique key when multiple topics exist for a research project.

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_TOPIC_SEQ	Number(3,0)	SMALLINT NOT NULL	This field is used to create a unique key when multiple topics exist for a research project.
4	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name