SSR_PE_ACTIV_VW

(SQL View)
 Index Back

PE Course item view


SELECT A.INSTITUTION , A.SSR_ITEM_ID , A.EFFDT , E.SSR_AC_CONTENT_ID , F.SSR_AC_ITEM_ID , F.SSR_AC_ITEM_ID_PAR , B.CRSE_ID , B.CRSE_OFFER_NBR , F.SSR_AC_CONTENT_TP , F.DESCR50 , F.SSR_CW_ASMT_CD , F.SSR_CW_WEIGHT , F.SSR_CW_OVRD_GRDMAP , F.SSR_RES_MAP_ID , F.SSR_AC_PASSING_GRD , F.SSR_PASSING_MARK , F.SSR_SHOW_STU_SS , F.SSR_BLIND_GRADED , F.SSR_CALC_STNDRD_CR , F.SSR_STANDARD_UNITS , F.SSR_AC_SVCIMP_OVRD , F.SERVICE_IMPACT , F.SSR_MRK_DISTRIB_ID , F.SSR_AC_GRD_RULE_ID , F.SSR_CALC_MARK_RANK , F.SSR_MANDATORY_PASS , F.SSR_CW_REQ_INST , F.SSR_CALC_MARK_AVG , F.ASSESSED , F.SSR_AC_WKLD_H , F.SSR_AC_WKLD_M , G.SSR_AC_EXAM_ONLY , F.SSR_AC_CONTENT_ID FROM PS_SSR_AIR_HDR A , PS_SSR_AIR_H_CRSE B , PS_CRSE_CATALOG C , PS_CRSE_OFFER D , PS_SSR_AC_CRSEREF E , PS_SSR_AC_CONT_ITM F , PS_SSR_AC_CRSE_EXT G WHERE A.INSTITUTION = B.INSTITUTION AND A.SSR_ITEM_ID = B.SSR_ITEM_ID AND A.EFFDT = B.EFFDT AND B.CRSE_ID=C.CRSE_ID AND %EffdtCheck(CRSE_CATALOG X, C, B.EFFDT) AND C.CRSE_ID = D.CRSE_ID AND C.EFFDT = D.EFFDT AND D.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.INSTITUTION = E.INSTITUTION AND B.CRSE_ID = E.CRSE_ID AND B.CRSE_OFFER_NBR = E.CRSE_OFFER_NBR AND B.CRS_TOPIC_ID = E.CRS_TOPIC_ID AND %EffdtCheck(SSR_AC_CRSEREF Y, E,%currentdatein) AND E.SSR_AC_CONTENT_ID = G.SSR_AC_CONTENT_ID AND A.INSTITUTION = G.INSTITUTION AND %EffdtCheck(SSR_AC_CRSE_EXT Z, G,%currentdatein) AND G.SSR_AC_CONTENT_ID = F.SSR_AC_CONTENT_ID AND G.INSTITUTION = F.INSTITUTION AND G.EFFDT = F.EFFDT AND F.SSR_SHOW_STU_SS = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID

Default Value: 00000000000

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 SSR_AC_CONTENT_ID Character(13) VARCHAR2(13) NOT NULL Activity Registry ID
5 SSR_AC_ITEM_ID Character(10) VARCHAR2(10) NOT NULL Content Item ID
6 SSR_AC_ITEM_ID_PAR Character(10) VARCHAR2(10) NOT NULL Parent Item ID
7 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
8 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

Prompt Table: SSR_CRSE_OFF_V1

9 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type

Prompt Table: SSR_AC_TPEOCVW

10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
11 SSR_CW_ASMT_CD Character(4) VARCHAR2(4) NOT NULL Content Code
12 SSR_CW_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Weighting Multiplier

Default Value: 1

13 SSR_CW_OVRD_GRDMAP Character(1) VARCHAR2(1) NOT NULL Override Result ID

Y/N Table Edit

14 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale

Prompt Table: SSR_RES_MAP_TBL

15 SSR_AC_PASSING_GRD Character(3) VARCHAR2(3) NOT NULL Passing Grade

Prompt Table: SSR_RES_MAP_VW

16 SSR_PASSING_MARK Number(8,3) DECIMAL(7,3) NOT NULL Passing Mark
17 SSR_SHOW_STU_SS Character(1) VARCHAR2(1) NOT NULL Show in Student SS

Y/N Table Edit

18 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

19 SSR_CALC_STNDRD_CR Character(1) VARCHAR2(1) NOT NULL Calculate Standardized Units

Y/N Table Edit

20 SSR_STANDARD_UNITS Number(6,2) DECIMAL(5,2) NOT NULL Standardized Units
21 SSR_AC_SVCIMP_OVRD Character(1) VARCHAR2(1) NOT NULL Override Service Impact

Y/N Table Edit

Default Value: N

22 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact

Prompt Table: SRVC_IMPACT_VW

23 SSR_MRK_DISTRIB_ID Character(11) VARCHAR2(11) NOT NULL Mark Distribution Curve
24 SSR_AC_GRD_RULE_ID Character(10) VARCHAR2(10) NOT NULL Grading Rule ID
25 SSR_CALC_MARK_RANK Character(1) VARCHAR2(1) NOT NULL Calculate Mark Rank

Y/N Table Edit

26 SSR_MANDATORY_PASS Character(1) VARCHAR2(1) NOT NULL Mandatory Pass Required

Y/N Table Edit

27 SSR_CW_REQ_INST Character(1) VARCHAR2(1) NOT NULL Required by Institution

Y/N Table Edit

28 SSR_CALC_MARK_AVG Character(1) VARCHAR2(1) NOT NULL Calculate Mark Average

Y/N Table Edit

29 ASSESSED Character(1) VARCHAR2(1) NOT NULL Assessed

Y/N Table Edit

Default Value: Y

30 SSR_AC_WKLD_H Number(3,0) SMALLINT NOT NULL Workload (hours)
31 SSR_AC_WKLD_M Number(2,0) SMALLINT NOT NULL Workload Minutes
32 SSR_AC_EXAM_ONLY Character(1) VARCHAR2(1) NOT NULL Exam Only Course
33 SSR_AC_CONTENT_ID2 Character(13) VARCHAR2(13) NOT NULL Content Registry ID