| # |
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_CANDIT_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Last Candidate Number
Prompt Table:
SSR_RS_CND_SRCH
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 6 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 7 |
SSR_RS_SUBMSSN_NBR |
Number(3,0) |
SMALLINT NOT NULL |
This field indicates the number of times the thesis has been resubmitted for examination
Default Value: 1
|
| 8 |
SSR_RS_STATUS |
Character(12) |
VARCHAR2(12) NOT NULL |
Status associated within the status group code.
Prompt Table:
%EDITTABLE
|
| 9 |
SSR_RS_INTD_SUB_DT |
Date(10) |
DATE |
Thesis Intended Submission Date
|
| 10 |
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
Y/N Table Edit
Default Value: N
|
| 11 |
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
Y/N Table Edit
Default Value: N
|
| 12 |
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.
Y/N Table Edit
Default Value: N
|
| 13 |
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
|
| 14 |
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
Y/N Table Edit
Default Value: N
|
| 15 |
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
|
| 16 |
SSR_RS_CERT_APPRVL |
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
|
| 17 |
SSR_RS_CERT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Certificate Approver
Prompt Table:
PEOPLE_SRCH
|
| 18 |
SSR_RS_COMM_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Comment Author
Prompt Table:
PEOPLE_SRCH
|
| 19 |
SSR_RS_NBR_SUBMIT |
Number(3,0) |
SMALLINT NOT NULL |
The number of copies of the thesis submitted for examination, for information only.
Default Value: 0
|
| 20 |
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.
|
| 21 |
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
|
| 22 |
SSR_RS_EMB_STRT_DT |
Date(10) |
DATE |
Embargo Start Date
|
| 23 |
SSR_RS_EMB_END_DT |
Date(10) |
DATE |
Embargo End Date
|
| 24 |
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.
Y/N Table Edit
Default Value: N
|
| 25 |
SSR_RS_PRIZE_AWARD |
Character(6) |
VARCHAR2(6) NOT NULL |
This field shows the honors and awards available in the Honors/Awards table, and the Prescribed Authority will review the Prize Nominations and identify the prize awarded to the candidate here (usually following a determination by the relevant committee).
Prompt Table:
HONOR_AWARD_TBL
|
| 26 |
SSR_RS_GRDTN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
The prescribed authority indicates this candidate is ready to be processed for graduation
Y/N Table Edit
Default Value: N
|
| 27 |
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.
Y/N Table Edit
Default Value: N
|
| 28 |
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
Y/N Table Edit
Default Value: N
|
| 29 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 30 |
SSR_DISPLAY_SS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display in Self Service
Y/N Table Edit
|
| 31 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 32 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 33 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 34 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|
| 35 |
SSR_PROJECT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Project Type
Prompt Table:
SSR_PROJ_TYPE
|
| 36 |
SSR_RS_THESIS_TITL |
Long Character(254) |
VARCHAR2(254) |
Thesis Title
|
| 37 |
SSR_RS_TOPIC_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is a sequential code used to create unique table entries to pre-define topics to be used in research management.
|
| 38 |
SSR_DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Topic
|
| 39 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_TBL
|
| 40 |
SESSION_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
Prompt Table:
SESSION_TBL_VW
|
| 41 |
CLASS_NBR |
Number(5,0) |
INTEGER NOT NULL |
Class Nbr
Prompt Table:
CLASS_DESCR_VW
|
| 42 |
SSR_PROJ_DATE |
Date(10) |
DATE |
Oral Defense Date
|
| 43 |
GRADING_SCHEME |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table:
GRADESCHEME_TBL
|
| 44 |
GRADING_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
ANC=ABC/NC Grading
AUD=Audit
BMT=Multi-Term Course: Not Graded
CNC=Credit / No Credit
EQV=Equivalent
GRD=Graded
HSC=Hundred Point Scale (NLD)
LAW=Law
MED=Medical School Grades
NOG=No Grade Associated
NON=Non-Graded Component
NQF=NQF Scale
OPT=Student Option
PNP=Pass/Not Pass
SUS=Satisfactory/Unsatisfactory
TRN=Transfer Grading Basis
TSC=Ten Point Scale (NLD)
Prompt Table:
GRADE_BASE_D_VW
|
| 45 |
CRSE_GRADE_INPUT |
Character(3) |
VARCHAR2(3) NOT NULL |
Grade Input
A=A
Prompt Table:
GRADE_REAL_VW
|
| 46 |
TRANSCRIPT_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Transcript level
00=Never Print
20=Print on Official
40=Print on Unofficial
60=Print on Student Life
80=Print on Degree Progress
|
| 47 |
SSR_PRINT_TSCRPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print on Transcript
Y/N Table Edit
Default Value: N
|