SSR_RS_THSFLDVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_RS_THESIS_TITL	Long Character(254)	VARCHAR2(254)	Thesis Title
2	SSR_RS_STATUS	Character(12)	VARCHAR2(12) NOT NULL	Status associated within the status group code.
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	SSR_RS_INTD_SUB_DT	Date(10)	DATE	Thesis Intended Submission Date
5	SSR_RS_ACT_SUB_DT	Date(10)	DATE	Thesis Intended Submission Date - Date, when the thesis was actually delivered to the Research Administrator, ready to be examined.
6	SSR_PROJ_DATE	Date(10)	DATE	Oral Defense Date
7	SSR_RS_NBR_SUBMIT	Number(3,0)	SMALLINT NOT NULL	The number of copies of the thesis submitted for examination, for information only.
8	SSR_RS_CERT_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Certificate Approver
9	SSR_RS_NOITS_APRVL	Character(1)	VARCHAR2(1) NOT NULL	This field reflects the supervisor�s approval (or otherwise) of the candidate's NOITS, and is used to trigger background 3C processes. A=Approved R=Rejected
10	SSR_RS_CERTINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	This checkbox indicated whether the candidate had submitted their examination certificate or not, and is used to trigger 3C events and update the thesis stage field
11	SSR_RS_RETURN_FLG	Character(1)	VARCHAR2(1) NOT NULL	When checked, this checkbox indicates that the candidate has requested the return of their thesis after examination.
12	SSR_RS_DECLARE_FLG	Character(1)	VARCHAR2(1) NOT NULL	On the Self Service NOITS form the candidate declares they are ready to submit their thesis for examination or will be by the Intended Submission Date by selecting this checkbox
13	SSR_RS_CERT_SAPRVL	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether the candidate�s supervisor has approved or rejected their examination certificate, and is used to trigger 3C processes A=Approved R=Rejected
14	SSR_RS_COMPSEM_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field serves as a flag to the Head of Department to schedule the seminar via the Events module
15	SSR_RS_EMBARGO_TYP	Character(4)	VARCHAR2(4) NOT NULL	This field indicates if the thesis is subject to an embargo ETHC=Ethical Considerations IPC=Intellectual Property NONE=Unembargoed SCTY=National Security
16	SSR_RS_EMB_STRT_DT	Date(10)	DATE	Embargo Start Date
17	SSR_RS_EMB_END_DT	Date(10)	DATE	Embargo End Date
18	SSR_RS_EX_PYMT_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field indicated that the thesis examiners payments have been processed because thesis management does not currently handle payment processing.
19	SSR_RS_LIB_DEP_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field indicates that the archival copy of the final thesis has been sent to the University Library
20	SSR_RS_CND_ADV_FLG	Character(1)	VARCHAR2(1) NOT NULL	When the candidate has been or is about to be advised of the outcome of their thesis examination and overall grade, this checkbox is selected. This prompts 3C communications to the candidate and others.
21	SSR_RS_GRDTN_FLG	Character(1)	VARCHAR2(1) NOT NULL	The prescribed authority indicates this candidate is ready to be processed for graduation
22	COMMENTS	Long Character	CLOB	Comment