| # |
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_AC_CONTENT_TP |
Character(20) |
VARCHAR2(20) NOT NULL |
Academic Content Type
Prompt Table:
%EDITTABLE10
|
| 6 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 7 |
SSR_AC_ITEM_ID_PAR |
Character(10) |
VARCHAR2(10) NOT NULL |
Parent Item ID
Prompt Table:
SSR_AC_CONT_VW
|
| 8 |
SSR_CW_ASMT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Content Code
|
| 9 |
SSR_CW_WEIGHT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Weighting Multiplier
|
| 10 |
SSR_CW_OVRD_GRDMAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Result ID
Y/N Table Edit
|
| 11 |
SSR_RES_MAP_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Result Scale
Prompt Table:
SSR_RES_MAP_VW5
|
| 12 |
SSR_AC_PASSING_GRD |
Character(3) |
VARCHAR2(3) NOT NULL |
Passing Grade
Prompt Table:
SSR_RES_MAP_VW
|
| 13 |
SSR_PASSING_MARK |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Passing Mark
|
| 14 |
SSR_SHOW_STU_SS |
Character(1) |
VARCHAR2(1) NOT NULL |
Show in Student SS
Y/N Table Edit
Default Value: Y
|
| 15 |
SSR_BLIND_GRADED |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if blind grading is active
N=Do not Use
Y=Override Display Values
Y/N Table Edit
|
| 16 |
SSR_CALC_STNDRD_CR |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Standardized Units
Y/N Table Edit
|
| 17 |
SSR_STANDARD_UNITS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Standardized Units
|
| 18 |
SSR_AC_SVCIMP_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Service Impact
Y/N Table Edit
Default Value: N
|
| 19 |
SERVICE_IMPACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impact
Prompt Table:
SRVC_IMPACT_VW
|
| 20 |
SSR_MRK_DISTRIB_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Mark Distribution Curve
|
| 21 |
SSR_AC_GRD_RULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Grading Rule ID
|
| 22 |
SSR_CALC_MARK_RANK |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Mark Rank
Y/N Table Edit
|
| 23 |
SSR_MANDATORY_PASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandatory Pass Required
Y/N Table Edit
|
| 24 |
SSR_CW_REQ_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Required by Institution
Y/N Table Edit
|
| 25 |
SSR_CALC_MARK_AVG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Mark Average
Y/N Table Edit
|
| 26 |
ASSESSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Assessed
Y/N Table Edit
Default Value: Y
|
| 27 |
SSR_AC_WKLD_H |
Number(3,0) |
SMALLINT NOT NULL |
Workload (hours)
|
| 28 |
SSR_AC_WKLD_M |
Number(2,0) |
SMALLINT NOT NULL |
Workload Minutes
|
| 29 |
SSR_AC_DEFAULT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Mark
Y/N Table Edit
Default Value: N
|
| 30 |
SSR_INCL_IN_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Calculation
Y/N Table Edit
Default Value: Y
|
| 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_ANID_WKC_DEF |
Character(4) |
VARCHAR2(4) NOT NULL |
Work Center default ID display
ANON=Anonymous ID
STID=Do not Display in Workcenter
|
| 36 |
SSR_ANID_ARR_DEF |
Character(4) |
VARCHAR2(4) NOT NULL |
Activity Result Roster default ID display
ANON=Anonymous ID only
BOTH=Anonymous, Student ID and Name
STUD=Student ID and Name only
|
| 37 |
SSR_ANID_IAM_DEF |
Character(4) |
VARCHAR2(4) NOT NULL |
Individual Activity Manager default ID display
ANON=Anonymous ID
BOTH=Anonymous, Student ID and Name
STUD=Student ID and Name only
|
| 38 |
OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Method
|