SSR_RS_CANDIDAT (SQL Table)	Index Back
Student Candidature Record This table is the header for all candidature records for a student in research management.

SSR_RS_CANDIDAT

(SQL Table)

Student Candidature Record

This table is the header for all candidature records for a student in research management.

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

3 SSR_RS_NEED_REVIEW Character(1) VARCHAR2(1) NOT NULL This field is used to track if a student's candidature records need review because of some major changes to their data.
Y/N Table Edit
Default Value: N

4 SSR_RS_ND_REV_DTTM DateTime(26) TIMESTAMP This field is used to track the date and time that the research candidature review needed flag is set to Y.

#	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	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
3	SSR_RS_NEED_REVIEW	Character(1)	VARCHAR2(1) NOT NULL	This field is used to track if a student's candidature records need review because of some major changes to their data. Y/N Table Edit Default Value: N
4	SSR_RS_ND_REV_DTTM	DateTime(26)	TIMESTAMP	This field is used to track the date and time that the research candidature review needed flag is set to Y.