SIS Reports Change Log

Add college code DP to list of college codes, as well as remove college codes that are not active and do not have any students sitting in them. 

College codes to be removed:

• ST, FM, AR, OO, JP, SP, AM, SM

Decommission COPH: Application Detail Report and add fields to College: Application Detail Report. 

Fields to be added:

• APP FEE
• AFEE_DATE
• TRANSF_GPA_2
• PCOL_BACHR_GPA
• PCOL_MASTR_GPA
• GRE VERBAL PERCENT
• GRE QUANT PERCENT
• GRE ANALYT WRIT PERCENT
• DOB 
• HS_CODE 
• HS_DESC 

• Start Term
• Grad Term
• OLGA
• Concentration
• Degree
• Credit Hours

6/3/2024

Remove logic that constrains the report to only Degree Status codes of ('AW','AP', 'SO'), allowing the report to show all applicants regardless of Degree Status code

Add a parameter for Degree Status code 

Add " Instructor Name"

Add " Instructor Email"

Add " Graduation Date"

Add " Graduation Status"

Add " Graduation Level"

Report Name Change " ROTC Active and Enrolled Students By Term Including Majors, Course and Instructor Information"

• Added logic to handle student attribute restrictions

• Added a Listagg funtion to "USER_DESC"

• Added a parameter for Admit Term
• Add a filter on Admit Term

• Added “COLL_DESC”, ” SECTION_TYPE_DESC”, “SPECIAL_APPROVAL_DESC”, “COURSE_SECTION_CONTRACT_DESC”
• Column name changes:
  1. “COLL” → “COLL_CODE”
  2. “DEPT” → “DEPT_CODE”
  3. “CAMPUS” → “CAMPUS_CODE”
  4. “INSTRUCTION_CODE” → “INSTRUCTIONAL_METHOD_CODE”
  5. “INSTRUCTION_DESC” → “INSTRUCTIONAL_METHOD_DESC”
  6. “TYPE” → “SECTION_TYPE_CODE”
  7. “SAPR” → “SPECIAL_APPROVAL_CODE”
  8. “CRSE_TEXT” → “COURSE_COMMENTS”
  9. “COURSE_STATUS” → “COURSE_STATUS_CODE”
  10. “OPEN/CLOSED” → “COURSE_STATUS_DESC_2”
  11. “SCCD_CODE” → “COURSE_SECTION_CONTRACT_CODE”
  12. “XL” → “CROSS_LISTED_COURSE”
• Column moved
  1. “CRSE_LEVL”
  2. “CRSE_SECT”
  3. “COURSE_STATUS”
  4. “COURSE_STATUS_DESC”
  5. “COURSE_STATUS_DESC_2”