DARTS : CS Replacement Queries

Type your task here, using "@" to assign to a user and "//" to select a due date

Documentation	Discoverer Report Name	User	Department/Campus	Prompts/Notes	JIRA ticket	Query Name
Corina C Larsen Document with report below First Generation Enrollment Report	BILL.SR-Enrollment Summary with First Gen	Bill - Admin		Prompt: Term Universal	DM-213 - SR - Enrollment Summary with First Gen Closed	UMS_DTS_FIRST_GEN_SUM
	NGRANT.UMS. SR-Enrollment Summary with First Gen Admit Type	Grant, Nathan	IR, UMS02	Prompts: Term, Institution Universal	DM-213 - SR - Enrollment Summary with First Gen Closed	UMS_DTS_FIRST_GEN_RAW_DATA UMS_DTS_FIRST_GEN_LEG
	SR - First Gen Enrollment Summary by Campus	System IR	IR, UMS08	Prompts: Term, Institution Universal	DM-209 - SR - First Gen Enrollment Summary by Campus Closed	UMS_DTS_FIRST_GEN_CAMPUS
	Masterreport is created based on these Discoverer reports	System IR	IR, UMS08	Prompts: Admit term, Enrolled Term, Institution Universal	DM-209 - SR - First Gen Enrollment Summary by Campus Closed	UMS_DTS_FIRST_GEN
Document Tamara Saarinen to update	SF - Acctg Line Waivers Detailed Custom Tuition Waivers & Native American Room & Board Scholarships	Grant, Nathan	IR, UMS02	Prompts: JOURNAL_DATE from (MMDDYYY), JOURNAL_DATE to (MMDDYYY) This Report runs for all campuses - must be run in the Scheduler - Universal	DM-241 - SF - Acctng Line Waivers Custom Closed	UMS_DTS_SF_ACCT_LINE_WAIVERS
Document Corina C Larsen Emma Lavonne Gelsinger to make changes first	1720 IR - USM IPEDS	Davis, Pat	IR, UMS06	This is a USM specific report and if someone would like to change it they must save a copy under a new name first.	DM-11 - 1720 IR - USM IPEDS Closed	USM_RSS_ENROLLMENT_SNAP
Document	NCAA Division III Annual Financial Aid Reporting USM, UMF, UMPI	Davis, Pat	IR, UMS06	The complex aggregate logic requires hard coding of dates - this requires the annual creation of a new query for each year, duplicating the build process in Discoverer. For only 3 campuses	DM-12 - NCAA Division III Annual Financial Aid Reporting USM, UMF, UMPI Reopened	UM_DTS_NCAA_DIV_III_2017_UMS02 - New Admits Academic Year UM_DTS_NCAA_2017_ALL_UMS06 - All Active Academic Year UM_DTS_NCAA_DIV_III_2017_UMS06 - New Admits Academic Year UM_DTS_NCAA_DIV_III_2017_UMS07 - All Active Academic Year
Document Emma Lavonne Gelsinger to prompt	Enrollment by CIP Category for Computer and IT fields Enrollment by CIP Category for Computer and IT Fields		IR, UMS08	Prompts: Term, Institution Universal - but CIP codes are not necessarily accurate across institutions	DM-199 - Enrollment by CIP Category for Computer and IT fields Closed	UMS_DTS_ENRL_CIP_COMP_IT
Document w scheduling warning	Stud Ext Archive Date Subquery Enrollment Watch Enrollment Headcount from Archive		IR, UMS08	Prompts:None. Should be scheduled Universal	DM-200 - Stud Ext Archive Date Subquery Enrollment Watch Closed	UMS_DTS_STUD_EXT_ARC_WATCH
Document Emma Lavonne Gelsinger who's responsibility is this? Make CIP category w catalog first Academic Plans Associated with CIP Codes - All Campuses	Academic Plan Academic Plans Associated with CIP Codes - All Campuses	White, Miriam	Finance, UMS08	Prompts: None, returns systemwide CIP info Universal	DM-201 - Academic Plan Closed	UMS_DTS_ACAD_PLAN_CIP
	Convert Academic Plan Report for Miriam White	White, Miriam	Finance, UMS08	returns systemwide CIP info	DM-205 - Convert Academic Plan Report for Miriam White Closed DM-201 and DM-205 are duplicates, so the query from DM-205 is deleted.	~~UMS_DTS_ACADEMIC_PLAN~~
Document	Enrollment - CH, FTE, Headcount	White, Miriam	Finance, UMS08	Prompts: Term, Institution Universal	DM-202 - Enrollment - CH, FTE, Headcount Closed	UMS_DTS_ENROLL_CH_FTE_HEADCNT
Emma Lavonne Gelsinger to check and see if relevant	SR - Class Section List	Davis, Pat	IR, UMS06	Prompts: Term, Institution Universal	DM-210 - SR - Class Section List Closed	UMS_DTS_CLASS_SEC_LIST_DEL
Document Class Summary	SR - Class Summary Class Summary	System IR	IR, UMS08	Prompts: Term, Institution Universal	DM-211 - SR - Class Summary Closed	UMS_DTS_CLASS_SUMMARY
Document Maine Community College System Transfers Report	SR - Transfer MCCS Stud Ext Archive Date Subquery Maine Community College System Transfers Report	Young, Justin	IR, UMS08	Prompts: Term, As_of_date Universal (gives all campus data)	DM-271 - SR - Transfer MCCS Stud Ext Archive Date Subquery Closed	UMS_DTS_MCCS_TRANSFERS_REPORT
Document Credit Hours for In-State Pell Grant Recipients	FA - Credit Hours for In-State Pell Grant Recipients Credit Hours for In-State Pell Grant Recipients	White, Miriam (Hope Eaton)	Finance, UMS08	Prompts: Term Universal (gives all campus data) If the criteria are not fixed, this report can be used for wide variety of financial aid report.	DM-285 - FA - Credit Hours for In-State Pell Grant Recipients Closed	UMS_DTS_FA_PELL_HOURS

DARTS : CS Replacement Queries

First Generation Enrollment Report

Class Summary

Maine Community College System Transfers Report

Credit Hours for In-State Pell Grant Recipients