| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 2 |
SSR_RS_TASK_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Service ID
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
SSR_RS_TASK_LABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Label
|
| 5 |
SSR_RS_TAB_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Service Tab
Prompt Table:
SSR_RS_TSKTABS
|
| 6 |
SSR_RS_READYUSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ready for Use
Y/N Table Edit
Default Value: N
|
| 7 |
SSR_RS_PRE_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre-applicant
Y/N Table Edit
Default Value: N
|
| 8 |
SSR_RS_POST_MATR |
Character(1) |
VARCHAR2(1) NOT NULL |
Post matriculation
Y/N Table Edit
Default Value: N
|
| 9 |
SSR_RS_ADM_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Admissions applicant
Y/N Table Edit
Default Value: N
|
| 10 |
SSR_RS_TASK_USER |
Character(4) |
VARCHAR2(4) NOT NULL |
User
ADMN=Administrator
CAND=Candidate
PROJ=Project
|
| 11 |
SSR_RS_UPD_ENTITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Update Entity
CONS=Submission
OTRQ=Assignment
SERV=Service Request
SUPR=Supervisor
THES=Thesis
TOPC=Topic
|
| 12 |
SSR_RS_STATUSGRPCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Status Group Codes to define the statuses for each of the areas of functionality within Research and Enrollment Tracking.
Prompt Table:
SSR_RS_STGRPVW
|
| 13 |
SSR_RS_STATUS |
Character(12) |
VARCHAR2(12) NOT NULL |
Status associated within the status group code.
Prompt Table:
SSR_RS_STATUS_D
|
| 14 |
SSR_RS_STATUS_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Status level associated with the status. Used to denote a hierarchy.
Prompt Table:
SSR_RS_REQLVLVW
|
| 15 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
PSMSGSETDEFN
|
| 16 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
PSMSGCATDEFN
|
| 17 |
SSR_RS_TASK_ORDER |
Number(2,0) |
SMALLINT NOT NULL |
Item Order
|
| 18 |
SSR_RS_RQUEST_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Request Type
Prompt Table:
SSR_RS_REQTYVW1
|
| 19 |
SSR_RS_REQ_SUBTYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Request Subtype
Prompt Table:
SSR_RS_RQSUBTYP
|
| 20 |
SSR_RS_NTF_TMPL_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Notification Template
Prompt Table:
SCC_TM_NTFTMPVW
|
| 21 |
SSR_RS_NTF_RECP |
Character(11) |
VARCHAR2(11) NOT NULL |
Notification Recipient
P=Primary Supervisor Only
S=Supervisor
Prompt Table:
PEOPLE_SRCH
|
| 22 |
SCC_RULE_CATEGORY |
Character(40) |
VARCHAR2(40) NOT NULL |
Rule Category for the Rules Engine
Prompt Table:
SCC_RTR_CAT_VW
|
| 23 |
SCC_RULE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is the Rule ID for rules used in the Rules Engine
Prompt Table:
SCC_RULE_PT
|
| 24 |
SSR_RS_ALLOW_ADD |
Character(1) |
VARCHAR2(1) NOT NULL |
Create a new Topic Sequence
Y/N Table Edit
Default Value: N
|
| 25 |
SSR_RS_USE_SRCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Topic Search
Y/N Table Edit
Default Value: N
|
| 26 |
SSR_RS_USE_ATTACH |
Character(1) |
VARCHAR2(1) NOT NULL |
Attachments Support
Y/N Table Edit
Default Value: N
|
| 27 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 28 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 29 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 30 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|