EMPLIDPrompt Table: SSR_RS_THS_SRCE
INSTITUTIONPrompt Table: SSR_RS_THS_SRCI
SSR_RS_CANDIT_NBRSSR_RS_THS_SRCC(SQL View) |
Index Back |
|---|---|
Thesis ManagementSearch record for Thesis-related data for candidate Used for Candidate Nbr lookup |
| SELECT A.EMPLID ,A.INSTITUTION ,A.SSR_RS_CANDIT_NBR FROM PS_SSR_RS_CAND_HDR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: SSR_RS_THS_SRCE |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: SSR_RS_THS_SRCI |
| 3 | SSR_RS_CANDIT_NBR |
Character(12) | VARCHAR2(12) NOT NULL | Last Candidate Number |