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

SSR_RS_CAND_STG

(SQL Table)

Candidature Record Staging

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 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID

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	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
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.