| # |
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:
INST_CAR_SCTY
|
| 3 |
SSR_RS_CANDIT_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Last Candidate Number
|
| 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_LOAD |
Character(4) |
VARCHAR2(4) NOT NULL |
Consumption load value.
Prompt Table:
SSR_RS_CONSLOAD
|
| 8 |
SSR_RS_DUR_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Default minimum percentage (Duration) used to derive the 'minimum' submission date which is displayed on the transactional pages.
|
| 9 |
SSR_RS_STATUS |
Character(12) |
VARCHAR2(12) NOT NULL |
Status associated within the status group code.
Prompt Table:
SSR_RS_CSTAT_VW
|
| 10 |
SSR_RS_ACTION_DT |
Date(10) |
DATE |
Status Date
Default Value: %Date
|
| 11 |
SSR_RS_BEGIN_DT |
Date(10) |
DATE |
Begin date of the current candidature.
|
| 12 |
SSR_RS_OVRD_BEG_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to designate if the minimum thesis submission date is to be overwritten for a research candidate.
Y/N Table Edit
Default Value: N
|
| 13 |
SSR_RS_BEGIN_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Begin term for tracking research consumption.
Prompt Table:
TERM_TBL
|
| 14 |
SSR_RS_CAN_CNSMPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Research Enrollment Tracking candidate days or term trigger to be used in the calculation of consumption.
D=Days
N=None
|
| 15 |
SSR_RS_CNSMPTN_DAY |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Total Days
|
| 16 |
SSR_RS_OVRD_CNSDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to designate if the minimum thesis submission date is to be overwritten for a research candidate.
Y/N Table Edit
Default Value: N
|
| 17 |
SSR_RS_CNSMPTN_TRM |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Number of term left at this point for comsumption tracking in research management.
|
| 18 |
SSR_RS_DAYS_REMNG |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Days Remaining
|
| 19 |
SSR_RS_DAYS_REM_CL |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Apportioned Remaining Days
|
| 20 |
SSR_RS_TERM_REMNG |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Number of terms remaining for research consumption.
|
| 21 |
SSR_RS_SUB_DT_MIN |
Date(10) |
DATE |
This date is the earliest date for thesis submission for a research candidate.
|
| 22 |
SSR_RS_SUB_DT_MAX |
Date(10) |
DATE |
This date is the latest date for thesis submission for a research candidate.
|
| 23 |
SSR_RS_OVRD_MIN_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to designate if the minimum thesis submission date is to be overwritten for a research candidate.
Y/N Table Edit
Default Value: N
|
| 24 |
SSR_RS_SUBDTMIN_CL |
Date(10) |
DATE |
This field is the earliest date for thesis submission for a research candidate if the calculated date is to be overridden with a different value.
|
| 25 |
SSR_RS_OVRD_MAX_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to designate if the maximum thesis submission date is to be overwritten for a research candidate.
Y/N Table Edit
Default Value: N
|
| 26 |
SSR_RS_SUBDTMAX_CL |
Date(10) |
DATE |
This field is the latest date for thesis submission for a research candidate if the calculated date is to be overridden with a different value.
|
| 27 |
SSR_RS_SUB_TRM_MIN |
Character(4) |
VARCHAR2(4) NOT NULL |
Minimum Submission Term
Prompt Table:
TERM_TBL
|
| 28 |
SSR_RS_OVRD_MIN_TR |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to designate if the minimum thesis submission term is to be overwritten for a research candidate.
Y/N Table Edit
Default Value: N
|
| 29 |
SSR_RS_SUBTRMIN_CL |
Character(4) |
VARCHAR2(4) NOT NULL |
This term is the earliest term for thesis submission for a research candidate if the calculated term is to be overridden with a different value
|
| 30 |
SSR_RS_SUB_TRM_MAX |
Character(4) |
VARCHAR2(4) NOT NULL |
This term is the latest term for thesis submission for a research candidate.
Prompt Table:
TERM_TBL
|
| 31 |
SSR_RS_OVRD_MAX_TR |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to designate if the maximum thesis submission term is to be overwritten for a research candidate.
Y/N Table Edit
Default Value: N
|
| 32 |
SSR_RS_SUBTRMAX_CL |
Character(4) |
VARCHAR2(4) NOT NULL |
This term is the latest term for thesis submission for a research candidate if the calculated term is to be overridden with a different value
|
| 33 |
SSR_RS_HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Consumption Indicator
A=Reset
R=Resume
S=Suspend
|
| 34 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 35 |
SSR_DISPLAY_SS |
Character(1) |
VARCHAR2(1) NOT NULL |
Display in Self Service
Y/N Table Edit
|
| 36 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 37 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 38 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 39 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|