SSR_AC_SR_ITMVW(SQL View) |
Index Back |
|---|---|
Activity Content Item DetailActivity Content Item Record view used in Activity Management (Activity Registry) to prompt for supplemental resit items. |
| SELECT I.SSR_AC_CONTENT_ID , I.INSTITUTION , I.EFFDT , I.SSR_AC_ITEM_ID , I.SSR_AC_CONTENT_TP , I.DESCR50 , I.SSR_AC_ITEM_ID_PAR , I.SSR_CW_ASMT_CD , I.SSR_CW_WEIGHT , I.SSR_CW_OVRD_GRDMAP , I.SSR_RES_MAP_ID , I.SSR_AC_PASSING_GRD , I.SSR_PASSING_MARK , I.SSR_SHOW_STU_SS , I.SSR_BLIND_GRADED , I.SSR_CALC_STNDRD_CR , I.SSR_STANDARD_UNITS , I.SSR_AC_SVCIMP_OVRD , I.SERVICE_IMPACT , I.SSR_MRK_DISTRIB_ID , I.SSR_AC_GRD_RULE_ID , I.SSR_CALC_MARK_RANK , I.SSR_MANDATORY_PASS , I.SSR_CW_REQ_INST , I.SSR_CALC_MARK_AVG , I.ASSESSED , I.SSR_AC_WKLD_H , I.SSR_AC_WKLD_M , I.SSR_AC_DEFAULT FROM PS_SSR_AC_CONT_ITM I , PS_SSR_AC_MAIN_INC M WHERE M.SSR_AC_CONTENT_ID = I.SSR_AC_CONTENT_ID AND M.INSTITUTION = I.INSTITUTION AND M.EFFDT = I.EFFDT AND M.SSR_AC_ITEM_ID = I.SSR_AC_ITEM_ID AND M.SSR_SUP_RESIT = 'Y' |
| # | 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
Default Value: 1 |
| 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_TBL |
| 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 |
| 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 |