| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SSR_AC_CONTENT_ID |
Character(13) |
VARCHAR2(13) NOT NULL |
Activity Registry ID
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
SSR_AC_ITEM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Content Item ID
|
| 5 |
SSR_CW_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandatory
Y/N Table Edit
Default Value: Y
|
| 6 |
SSR_CW_TOPIC_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Topic Approval Required
Y/N Table Edit
Default Value: N
|
| 7 |
SSR_ALLOW_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Override or Substitution
Y/N Table Edit
|
| 8 |
SSR_NO_MARK_DEF |
Character(1) |
VARCHAR2(1) NOT NULL |
No Mark Option
I=Blank Mark - Include
T=Below Threshold - Exclude
X=Blank Mark - Exclude
Default Value: I
|
| 9 |
SSR_CW_NO_MRK_VAL |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Minimum points for an assignment.
|
| 10 |
SSR_CW_NO_MRKTHRES |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Minimum points for an assignment.
|
| 11 |
INCL_IN_MID_TERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Include for Mid Term Grade
Y/N Table Edit
Default Value: N
|
| 12 |
SSR_RESITS_ALLOWED |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if resits are allowed.
Y/N Table Edit
|
| 13 |
SSR_RESIT_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Resit Rule ID
|
| 14 |
SSR_SUP_RESIT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if resits are allowed.
Y/N Table Edit
Default Value: N
|
| 15 |
SSR_AC_RS_ITEMID |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplemental Resit Item
Prompt Table:
SSR_AC_SR_ITMVW
|
| 16 |
SSR_CW_TOT_ATMPT |
Number(3,0) |
SMALLINT NOT NULL |
Allowable Number of Attempts
Default Value: 0
|
| 17 |
SSR_RESIT_RFSL_OK |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if resits are allowed.
Y/N Table Edit
Default Value: N
|
| 18 |
SSR_RESIT_CALC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if resits are allowed.
A=Average All Marks
H=Highest Mark
L=Most Recent Mark
Default Value: A
|
| 19 |
SSR_AC_RST_PRD_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Resit Period Option
NE=Next Exam Period
NP=Next Exam Regular Period
NR=Next Exam Resit Period
RE=Rules Engine
SS=Student Selection
|
| 20 |
SSR_EXAMPRD_REG |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular Exam
Y/N Table Edit
Default Value: Y
|
| 21 |
SSR_EXAMPRD_RESIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Resit Exam
Y/N Table Edit
Default Value: N
|
| 22 |
SSR_AC_MAX_PRD_DSP |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Period to Display
NE=Next Exam Period
NR=Next Exam Resit Period
RE=Rules Engine
SS=Student Selection
|
| 23 |
SSR_CW_RELDAYS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Relative Days Option
C=Class Start Date
S=Session Start Date
T=Term Start Date
Default Value: C
|
| 24 |
SSR_CW_REL_GRADE |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Grading Days
|
| 25 |
SSR_CW_REL_DUE |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Due Days
|
| 26 |
SSR_CW_REQ_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Required by Institution
Y/N Table Edit
|
| 27 |
SSR_CW_REL_START |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Start Days
|
| 28 |
SSR_PENALTY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Penalty Type
C=Capped
D=Daily Penalty
F=Fixed
N=No Penalty
O=One Time
W=Weekly
Default Value: N
|
| 29 |
SSR_LATE_PENALTY |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Late Penalty
|
| 30 |
SSR_PENALTY_MAX |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Penalty Maximum
|
| 31 |
SSR_PENALTY_MARK |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Penalty Mark
|
| 32 |
SSR_AC_PNLTY_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Penalty Type
Y/N Table Edit
Default Value: N
|
| 33 |
SSR_AC_PNLTY_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Days
|
| 34 |
SSR_RESIT_DURATION |
Number(3,0) |
SMALLINT NOT NULL |
Resit Attempt Window Expires
|
| 35 |
SSR_CW_RST_EXP_OP |
Character(1) |
VARCHAR2(1) NOT NULL |
Resit Expiration Date Options
F=First Due Date
L=Most Recent Due Date
N=No Expiration
S=Session End Date
T=Term End Date
Default Value: N
|
| 36 |
SSR_CW_YR_ATMPT |
Number(3,0) |
SMALLINT NOT NULL |
Allowable Attempts Per Year
|
| 37 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 38 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 39 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 40 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|