...
Records | Fields from the Record |
---|---|
CLASS_TBL_SE_VW | EMPLID,SUBJECT,CATALOG_NBR, DESCR,CLASS_SECTION, SESSION_CODE,CLASS_NBR, ACAD_GROUP, GRADE_DT |
CU_BIO_VW | FIRST_NAME, LAST_NAME, MIDDLE_NAME |
CLASS_TBL_SE_VW | SUPPORT CLASS_TBL_SE_VW ABOVE |
Expressions:
Few One 'Expressions' have been added to find 'Academic Level' have described the prompt as null and define the value of 'ACP' and 'APS'. Reference for Service Indicator: Service IndicatorsPrevious Attempts (R, W, WU)' to count the previous attempts of this particular class.
Prompt:
Institution, Term have been mandatory for an user to input to extract data
Criteria:
A.CRSE_ID - Course ID = '090828' (This is specifically looking for the course 'CSTM 120' attribute )
A.STDNT_ENRL_STATUS - Student Enrollment Status = 'E' (the report is based on enrolled students)
in progressC.CRSE_GRADE_OFF - Official Grade in list ('R','W','WU') (the result is filtering only 'R','W','WU' grades)
Query Output Image:
SQL Summery:
...