SSR_RS_APEAL_VW (SQL View)	Index Back
Thesis Appeal Code Research Tracking Initiative: Record Definition to hold the Active Evaluation Codes (Evaluation Category = Thesis) that institution has defined

SSR_RS_APEAL_VW

(SQL View)

Thesis Appeal Code

Research Tracking Initiative: Record Definition to hold the Active Evaluation Codes (Evaluation Category = Thesis) that institution has defined

SELECT A.SCC_GE_EVALUATN_CD SSR_RS_APPEAL_CD , A.SCC_GE_DESCR , A.SCC_GE_DESCRSHORT FROM %Table(SCC_GE_EC_DEFN) A WHERE A.SCC_GE_EVAL_CATGRY = '2' AND %EffdtCheck(SCC_GE_EC_DEFN B, A, %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SSR_RS_APPEAL_CD Character(10) VARCHAR2(10) NOT NULL Thesis Management - Appeal code.

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 SCC_GE_DESCRSHORT Character(25) VARCHAR2(25) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_RS_APPEAL_CD	Character(10)	VARCHAR2(10) NOT NULL	Thesis Management - Appeal code.
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	SCC_GE_DESCRSHORT	Character(25)	VARCHAR2(25) NOT NULL	Short Description