| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 2 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
SSR_AC_CONT_XDFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Content Optns Default
Y/N Table Edit
Default Value: N
|
| 5 |
SSR_AC_ATND_XDFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Attendance Default
Y/N Table Edit
Default Value: N
|
| 6 |
SSR_AC_ID_XDFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Forms of ID Defaults
Y/N Table Edit
Default Value: N
|
| 7 |
SSR_AC_SCALE_XDFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Result Scale Defaults
Y/N Table Edit
Default Value: N
|
| 8 |
SSR_AC_ATND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Attendance Tracking Options
M=Number of Allowed Absences
N=Number of Classes Attended
P=Percentage of Classes Attended
|
| 9 |
SSR_AC_ATND_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Required Attendance Days
|
| 10 |
SSR_RES_MAP_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Result Scale
Prompt Table:
SSR_RES_MAP_TBL
|
| 11 |
SSR_PASSING_MARK |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Passing Mark
|
| 12 |
SSR_AC_PASSING_GRD |
Character(3) |
VARCHAR2(3) NOT NULL |
Passing Grade
Prompt Table:
SSR_RES_MAP_VW2
|
| 13 |
SSR_SHOW_STU_SS |
Character(1) |
VARCHAR2(1) NOT NULL |
Show in Student SS
Y/N Table Edit
|
| 14 |
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
|
| 15 |
SSR_CALC_STNDRD_CR |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Standardized Units
Y/N Table Edit
|
| 16 |
SSR_STANDARD_UNITS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Standardized Units
|
| 17 |
SSR_AC_SVCIMP_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Service Impact
Y/N Table Edit
Default Value: N
|
| 18 |
SERVICE_IMPACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Service Impact
Prompt Table:
SRVC_IMPACT_VW
|
| 19 |
SSR_MRK_DISTRIB_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Mark Distribution Curve
|
| 20 |
SSR_AC_GRD_RULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Grading Rule ID
|
| 21 |
SSR_CALC_MARK_RANK |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Mark Rank
Y/N Table Edit
|
| 22 |
SSR_MANDATORY_PASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandatory Pass Required
Y/N Table Edit
|
| 23 |
SSR_CW_REQ_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Required by Institution
Y/N Table Edit
|
| 24 |
SSR_CALC_MARK_AVG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Mark Average
Y/N Table Edit
|
| 25 |
ASSESSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Assessed
Y/N Table Edit
Default Value: Y
|
| 26 |
SSR_AC_WKLD_H |
Number(3,0) |
SMALLINT NOT NULL |
Workload (hours)
|
| 27 |
SSR_AC_WKLD_M |
Number(2,0) |
SMALLINT NOT NULL |
Workload Minutes
|
| 28 |
SSR_ACM_IND_CONT |
Character(1) |
VARCHAR2(1) NOT NULL |
Individualized Content
Y/N Table Edit
Default Value: N
|
| 29 |
SCC_RULE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
This field is the Rule ID for rules used in the Rules Engine
|
| 30 |
SSR_AC_CALC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Result Scale Minimum Mark
Y/N Table Edit
Default Value: N
|
| 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
|