SSR_ACO_TREE_VW(SQL View) |
Index Back |
|---|---|
Academic Item Reg Header |
| SELECT C.SSR_AC_CONTENT_ID , C.INSTITUTION , C.EFFDT , C.SSR_AC_ITEM_ID , C.SSR_AC_CONTENT_TP , C.DESCR50 , C.SSR_AC_ITEM_ID_PAR , C.SSR_AC_CONTENT_TP , C.SSR_CW_ASMT_CD , C.SSR_CW_WEIGHT , C.SSR_CW_OVRD_GRDMAP , C.SSR_RES_MAP_ID , C.SSR_PASSING_MARK , C.SSR_SHOW_STU_SS , C.SSR_BLIND_GRADED , C.SSR_CALC_STNDRD_CR , C.SSR_STANDARD_UNITS , C.SSR_AC_SVCIMP_OVRD , C.SERVICE_IMPACT , C.SSR_MRK_DISTRIB_ID , C.SSR_AC_GRD_RULE_ID , C.SSR_CALC_MARK_RANK , C.SSR_MANDATORY_PASS , C.SSR_CW_REQ_INST , C.SSR_CALC_MARK_AVG , C.ASSESSED , C.SSR_AC_WKLD_H , C.SSR_AC_WKLD_M , 0 , 0 , 0 , 'N' , ' ' , 0 , C.SSR_AC_DEFAULT , 'N' , ' ' , D.SSR_AC_RS_ITEMID , D.SSR_PENALTY_TYPE , D.SSR_RESITS_ALLOWED , D.SSR_RESIT_CALC_OPT , D.SSR_CW_REQUIRED , D.SSR_SUP_RESIT FROM PS_SSR_AC_CONT_ITM C LEFT OUTER JOIN PS_SSR_AC_MAIN_INC D ON C.SSR_AC_CONTENT_ID = D.SSR_AC_CONTENT_ID AND C.INSTITUTION = D.INSTITUTION AND C.EFFDT = D.EFFDT AND C.SSR_AC_ITEM_ID = D.SSR_AC_ITEM_ID |
| # | 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: SSR_AC_ITEMTPVW |
| 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_AC_CNT_TP_PAR | Character(20) | VARCHAR2(20) NOT NULL | Parent Content Type |
| 9 | SSR_CW_ASMT_CD | Character(4) | VARCHAR2(4) NOT NULL | Content Code |
| 10 | SSR_CW_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL |
Weighting Multiplier
Default Value: 1 |
| 11 | SSR_CW_OVRD_GRDMAP | Character(1) | VARCHAR2(1) NOT NULL |
Override Result ID
Y/N Table Edit |
| 12 | SSR_RES_MAP_ID | Character(12) | VARCHAR2(12) NOT NULL |
Result Scale
Prompt Table: SSR_RES_MAP_TBL |
| 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 |
| 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 |
| 16 | SSR_CALC_STNDRD_CR | Character(1) | VARCHAR2(1) NOT NULL | Calculate Standardized Units |
| 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 |
| 19 | SERVICE_IMPACT | Character(5) | VARCHAR2(5) NOT NULL | Service Impact |
| 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 |
| 24 | SSR_CW_REQ_INST | Character(1) | VARCHAR2(1) NOT NULL | Required by Institution |
| 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 |
| 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_SEQ_NBR | Number(4,0) | SMALLINT NOT NULL | Sequence Number |
| 30 | SSR_SEQ_NBR7 | Number(7,0) | INTEGER NOT NULL | Sequence Number |
| 31 | SSR_ACO_TREE_LVL | Number(3,0) | SMALLINT NOT NULL | Level 1 Row |
| 32 | SSR_ACO_CHLD_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Child Content Grading Options |
| 33 | SSR_ACTIVITY_ID | Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 34 | CRS_TOPIC_ID | Number(3,0) | SMALLINT NOT NULL | Course Topic ID |
| 35 | SSR_AC_DEFAULT | Character(1) | VARCHAR2(1) NOT NULL |
Default Mark
Y/N Table Edit |
| 36 | SSR_ACO_CONNECT_OR | Character(1) | VARCHAR2(1) NOT NULL | Connect OR condition |
| 37 | SSR_AC_SPCL_CHAR | Character(15) | VARCHAR2(15) NOT NULL | Special Characters |
| 38 | SSR_AC_RS_ITEMID | Character(10) | VARCHAR2(10) NOT NULL | Supplemental Resit Item |
| 39 | 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 |
| 40 | SSR_RESITS_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL | This field indicates if resits are allowed. |
| 41 | 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 |
| 42 | SSR_CW_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Mandatory |
| 43 | SSR_SUP_RESIT | Character(1) | VARCHAR2(1) NOT NULL | This field indicates if resits are allowed. |