SCC_GE_BND_THES

(SQL View)
Index Back

Eval Management Thesis PopSel

Evaluation Management System Thesis Population Selection Bind record.

SELECT A.EMPLID ,A.INSTITUTION ,A.SSR_RS_CANDIT_NBR ,A.SSR_RS_SUBMSSN_NBR FROM PS_SSR_RS_THESIS A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_SSR_RS_THESIS A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.INSTITUTION = A_ED.INSTITUTION AND A.SSR_RS_CANDIT_NBR = A_ED.SSR_RS_CANDIT_NBR AND A_ED.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_SSR_RS_THESIS A_ES WHERE A.EMPLID = A_ES.EMPLID AND A.INSTITUTION = A_ES.INSTITUTION AND A.SSR_RS_CANDIT_NBR = A_ES.SSR_RS_CANDIT_NBR AND A.EFFDT = A_ES.EFFDT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

3 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number
4 SSR_RS_SUBMSSN_NBR Number(3,0) SMALLINT NOT NULL This field indicates the number of times the thesis has been resubmitted for examination