Created by Corina C Larsen, last modified by Miki Yanagi on Mar 22, 2022

DARTS SQR Reports in CSRPT

Each report contains a table beginning UM_RUN which stores run control data. Additional run control data is held in UM_R tables which follow the UM_RUN table.

Migrated 10/5/2017 from H:\ReportingGroup\BillG\General Reporting Info\CS Reporting Info.xlsx

Functional AreaSQRDescriptionCreation DateTables UsedNotes
Admissionsumadmavg.sqrApplicant Quality Report
PS_ACAD_PLAN_TBL,  PS_ACAD_PROG_TBL, PS_ADM_APPLCTR_TBL,  PS_EXT_ACAD_SUM, PS_STDNT_TEST_COMP, PS_UM_APPL_EXTRACT,  SYSADM.PS_ACAD_PROG_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_RUN_UMADMAVG
Admissionsumadmcen.sqrAdmissions Term Comparison Report
PS_ACAD_CAR_TBL,  PS_ACAD_PROG_TBL, PS_ADMIT_TYPE_TBL,  PS_ADM_APPLCTR_TBL, PS_ADM_APPL_PROG, PS_TERM_VAL_TBL,  PS_UM_APPL_EXTRACT, PS_UM_STUD_EXT_ARC, SYSADM.PS_ACAD_CAR_TBL,  SYSADM.PS_ACAD_PROG_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_RUN_UMADMCEN,  SYSADM.PS_UM_STUD_EXT_ARC
Admissionsumadmcmp.sqrAdmission Resid. & Term Report

PS_ACAD_PLAN_TBL,  PS_ACAD_CAR_TBL, PS_ACAD_PROG_TBL,  PS_ADMIT_TYPE_TBL, PS_ADM_APPLCTR_TBL, PS_ADM_APPL_PROG, PS_TERM_VAL_TBL, PS_UM_APPL_EXTRACT,  SYSADM.PS_ACAD_CAR_TBL, SYSADM.PS_UM_RUN_UMADMCMP


Admissionsumadmhs1.sqrFirst Yr Applicants by High School
PS_ACAD_PLAN_TBL,  PS_ACAD_PROG_TBL, PS_ADM_APPL_CMP,  PS_ADM_APPL_PLAN, PS_ADM_APPL_PROG, PS_ADM_APPL_SBPLAN,  PS_COUNTRY_TBL, PS_EXT_ACAD_SUM, PS_EXT_ORGSCHL_VW, PS_EXT_ORG_TBL,  PS_STATE_TBL, PS_UM_APPL_EXTRACT, SYSADM.PS_ACAD_PROG_TBL, SYSADM.PS_RESIDENCY_OFF,  SYSADM.PS_UM_RUN_ADMT_TYP, SYSADM.PS_UM_RUN_UMADMHS1
Admissionsumadmsta.sqrWeekly Admissions Status Report
PS_ACAD_PROG_TBL,  PS_ACAD_PLAN_TBL, PS_ADMIT_TYPE_TBL,  PS_ADM_APPLCTR_TBL, PS_ADM_APPL_PROG, PS_UM_APPL_EXTRACT,  PS_UM_RUN_ADM_TRMS, SYSADM.PS_UM_RUN_UMADMSTA
Admissionsumadmsum.sqrAdmissions Summary Report
PS_ADMIT_TYPE_TBL,  PS_ADM_APPLCTR_TBL, PS_ADM_APPL_PROG,  PS_UM_APPL_EXTRACT, SYSADM.PS_UM_RUN_ADM_TRMS, SYSADM.PS_UM_RUN_UMADMSUM
Admissionsumaplyld.sqrApplicant Yield Reports
PS_ACAD_PLAN_TBL,  PS_ACAD_PROG_TBL, PS_ACAD_SUBPLN_TBL,  PS_ADMIT_TYPE_TBL, PS_ADM_APPLCTR_TBL, PS_ADM_APPL_PLAN,  PS_ADM_APPL_PROG, PS_ADM_APPL_SBPLAN, PS_UM_APPL_EXTRACT, SYSADM.PS_ACAD_PROG_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_RUN_UMAPPYLD
Admissionsumappdup.sqrMulti-Campus Applicant Report
PS_UM_APPL_EXTRACT,  SYSADM.PS_UM_RUN_UMAPPDUP
Admissionsumepsmkt.sqrEPS Market Prospect Report
PS_ADM_PRSPCT_CAR,  PS_ACAD_CAR_TBL, PS_ADM_RECRCTR_TBL,  PS_COUNTRY_TBL, PS_DIVERS_ETHNIC, PS_EPS_ZIPMRKT_TBL,  PS_EXT_ORG_CODES, PS_PERSONAL_DATA, PS_STATE_TBL, PS_TERM_VAL_TBL, SYSADM.PS_ACAD_CAR_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_RUN_EPSMARKT
Admissionsumgrdavg.sqrGraduate Applicant Quality Report
PS_ACAD_PLAN_TBL,  PS_ACAD_PROG_TBL, PS_ADM_APPLCTR_TBL,  PS_ADM_APPL_PLAN, PS_ADM_APPL_PROG, PS_EXT_ACAD_SUM,  PS_UM_APPL_EXTRACT, SYSADM.PS_ACAD_PROG_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_RUN_UMGRDAVG, SYSADM.PS_UM_TEST_SCORE_V
Admissionsumpostal.sqrPostal Region Prospect Report
PS_ADDRESSES_SA,  PS_ACAD_CAR_TBL, PS_ADM_PRSPCT_CAR,  PS_ADM_RECRCTR_TBL, PS_DIVERS_ETHNIC, PS_PERSONAL_DATA, PS_STATE_TBL, PS_TERM_VAL_TBL,  SYSADM.PS_ACAD_CAR_TBL, SYSADM.PS_RESIDENCY_OFF,SYSADM.PS_UM_RUN_POSTALRG
Admissionsumadmwek.sqr

UMS Admissions 5 Yr Comparison

10/ 2017 JAJPS_UM_APPL_EXT_VW,  PS_ADM_APPL_PROG, PS_TERM_VAL_TBL,  PS_UM_STUD_EXT_ARC, SYSADM.PS_UM_RUN_UMADMWEK
Admissionsummjrfdr.sqrUMS Admissions Major Feeder School10/ 2017 JAJPS_ADMIT_TYPE_TBL,  PS_EXT_ORGSCHL_VW, PS_LS_SCHL_TYP_TBL,  PS_TERM_VAL_TBL, PS_UM_APPL_EXT_VW, PS_UM_RUN_UMMJRFDR,  PS_UM_R_UMMJRFDR1, PS_UM_R_UMMJRFDR2, PS_UM_R_UMMJRFDR3, PS_UM_R_UMMJRFDR4, PS_UM_STUD_EXTRACT
Admissionsumincath.sqrUMS Admissions Incoming Athletes11/ 2017 JAJPS_ADMIT_TYPE_TBL,  PS_EXTRACUR_ACTVTY, PS_EXTR_ACTVTY_TBL,  PS_EXT_ORGSCHL_VW, PS_LS_SCHL_TYP_TBL, PS_UM_APPL_EXT_VW,  PS_UM_RUN_UMINCATH, PS_UM_R_UMINCATH1, PS_UM_R_UMINCATH2, PS_UM_R_UMINCATH3, PS_UM_R_UMINCATH4, PS_UM_STUD_EXTRACT
Admissionsumprgpln.sqr

UMS Admissions Status by Program and Plan

11/ 2017 JAJPS_ACAD_PLAN_TBL,  PS_TERM_VAL_TBL, PS_UM_APPL_EXT_VW,  PS_UM_RUN_UMPRGPLN, PS_UM_R_UMPRGPLN1, PS_UM_STUD_EXTRACT
Recruitingumcommrf.sqrCommunications Referral Report
PS_ACAD_CAR_TBL,  PS_ADM_PRSPCT_CAR,  PS_ADM_PRSPCT_PROG, PS_ADM_RECRCTR_TBL, PS_COMMUNICATION, PS_COMM_CATG_TBL, PS_COMM_CTXT_TBL,  PS_PERSONAL_DATA, PS_TERM_VAL_TBL, SYSADM.PS_ACAD_CAR_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_RUN_UMPROCST
Recruitingumprocst.sqrCountry/State Prospect Report
PS_ADDRESSES,  PS_ACAD_CAR_TBL,  PS_ADDRESSES, PS_ADM_PRSPCT_CAR, PS_ADM_PRSPCT_PROG, PS_ADM_RECRCTR_TBL, PS_COUNTRY_TBL, PS_PERSONAL_DATA, PS_STATE_TBL,  PS_TERM_VAL_TBL, SYSADM.PS_ACAD_CAR_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_RUN_UMPROCST
Recruitingumintref.sqrInitial Referral Source Report
PS_ACAD_CAR_TBL,  PS_ADM_PRSPCT_CAR,  PS_ADM_PRSPCT_PROG, PS_ADM_RECRCTR_TBL,  PS_PERSONAL_DATA, PS_REFERL_SRCE_TBL, PS_TERM_VAL_TBL,  SYSADM.PS_ACAD_CAR_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_RUN_UMPROCST
Student Recordsumipdstu.sqr

IPEDS Student Report


PS_ACAD_PLAN_TBL,  PS_ACAD_PROG_TBL, PS_DIVERS_ETHNIC,  PS_ETHNIC_GRP_TBL, SYSADM.PS_ACAD_PROG_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_CLASS_SELECT,  SYSADM.PS_UM_RUN_UMIPDSTU, SYSADM.PS_UM_STDNT_COHORT,  SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EXT_ARC,  [SYSADM.PS_UM_STD_ENR_ARC, PS_UM_STUD_EXT_ARC, PS_UM_STUD_EX_OARC, SYSADM.PS_UM_ACAD_PLAN_TBL, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STD_ENR_CENS, SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EX_OARCMoved to Power BI
Student Recordsumipdudp.sqrIPEDS Multi Term Report
PS_CITIZENSHIP,  PS_ACAD_PROG_TBL,  PS_DIVERS_ETHNIC, PS_ETHNIC_GRP_TBL,  SYSADM.PS_ACAD_PROG_TBL, SYSADM.PS_RESIDENCY_OFF,  SYSADM.PS_UM_RUN_UMIPDUDP, SYSADM.PS_UM_STUD_CENSUS,  SYSADM.PS_UM_STUD_EXTRACT, SYSADM.PS_UM_STUD_EXT_ARCMoved to Power BI
Student Recordsumipedde.sqr

UM IPEDS Distance Ed Report

10/ 2017

PS_UM_RUN_UMIPEDDE,  PS_ADDRESSES, PS_UM_STD_ENR_C_VW,  PS_UM_STUD_CENS_VW, SYSADM.PS_TERM_VAL_TBL

Moved to Power BI
Student Recordsumstu1st.sqrFirst Time Student Report
PS_EXT_ACAD_DATA,  PS_ACAD_PROG_TBL, PS_EXT_ACAD_DATA,  SYSADM.PS_ACAD_PROG_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_CLASS_SELECT, SYSADM.PS_UM_RUN_UMSTU1ST, SYSADM.PS_UM_STDNT_COHORT, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EXTRACT, SYSADM.PS_UM_STUD_EXT_ARC, [SYSADM.PS_UM_STD_ENR_ARC, PS_UM_STUD_EXT_ARC, PS_UM_STUD_EX_OARC, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STD_ENR_CENS, SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EX_OARCMoved to Power BI
Student Recordsumstudup.sqrDuplicate Registration Report
SYSADM.PS_UM_RUN_UMSTUDUP,  SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EXT_ARC, PS_UM_STUD_EXT_ARC, SYSADM.PS_UM_STUD_CENSUS
Student Recordsumstuloc.sqrClass Unit Location Report
S_INSTITUTION_TBL,  SYSADM.PS_UM_CLASS_SELECT,  SYSADM.PS_UM_RUN_UMSTULOC, SYSADM.PS_UM_STD_ENR_ARC,  SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EXT_ARC, [SYSADM.PS_UM_STD_ENR_ARC, PS_UM_STUD_EXT_ARC, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STD_ENR_CENS, SYSADM.PS_UM_STUD_CENSUS
Student Recordsumstumlt.sqrMultiple Term Report 
PS_ACAD_PROG_TBL,  SYSADM.PS_ACAD_PROG_TBL,  SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_CLASS_SELECT,  SYSADM.PS_UM_RUN_UMSTUMLT, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STD_ENR_CENS,  SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EXT_ARCMoved to Power BI
Student Recordsumstupln.sqrStudent Plan Report
PS_INSTITUTION_TBL,  SYSADM.PS_UM_CLASS_SELECT,  SYSADM.PS_UM_RUN_UMSTUPLN, SYSADM.PS_UM_STD_ENR_ARC,  SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EXT_ARC, SYSADM.PS_UM_STD_ENR_ARC, PS_UM_STUD_EXT_ARC, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STD_ENR_CENS, SYSADM.PS_UM_STUD_CENSUS
Student Recordsumstupro.sqrStudent Profile Report
PS_ACAD_PROG_TBL,  PS_DIVERS_ETHNIC, PS_ETHNIC_GRP_TBL,  SYSADM.PS_ACAD_PROG_TBL, SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_CLASS_SELECT, SYSADM.PS_UM_RUN_UMSTUPRO, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EXT_ARC, [SYSADM.PS_UM_STD_ENR_ARC, PS_UM_STUD_CENSUS, PS_UM_STUD_EXT_ARC, PS_UM_STUD_EX_OARC, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STD_ENR_CENS, SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EX_OARCMoved to Power BI
Student Recordsumstursd.sqrStudent Residence Report
PS_INSTITUTION_TBL,  PS_COUNTRY_TBL, PS_STATE_TBL,  SYSADM.PS_UM_CLASS_SELECT, SYSADM.PS_UM_RUN_UMSTURSD, SYSADM.PS_UM_STDNT_COHORT, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EXT_ARC, [SYSADM.PS_UM_STD_ENR_ARC, PS_UM_STUD_EXT_ARC, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STD_ENR_CENS, SYSADM.PS_UM_STUD_CENSUS
Student Recordsumsturtk.sqrGraduation Rate Report   
PS_ACAD_DEGR,  PS_DEGREE_TBL, PS_DIVERS_ETHNIC,  PS_ETHNIC_GRP_TBL, PS_EXT_ACAD_DATA,  PS_TERM_TBL, PS_UM_ISIS_TAPE, SYSADM.PS_UM_CLASS_SELECT,  SYSADM.PS_UM_RUN_UMSTURTK, SYSADM.PS_UM_STDNT_COHORT, SYSADM.PS_UM_STD_ENR_ARC,  SYSADM.PS_UM_STUD_EXTRACT, SYSADM.PS_UM_STUD_EXT_ARC, SYSADM.PS_UM_STUD_EX_OARC, PS_HOME
Student Recordsumstusum.sqrStudent Summary Report  
PS_ACAD_PROG_TBL,  SYSADM.PS_ACAD_PROG_TBL,  SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_CLASS_SELECT, SYSADM.PS_UM_RUN_UMSTUSUM, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STUD_CENSUS, PS_UM_STUD_EXT_ARC, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STD_ENR_CENS, SYSADM.PS_UM_STUD_EX_OARCMoved to Power BI
Student Recordsumstutui.sqrTuition  Report  
PS_ACAD_PROG_TBL,  PS_ETHNIC_GRP_TBL, SYSADM.PS_ACAD_PROG_TBL,  SYSADM.PS_RESIDENCY_OFF, SYSADM.PS_UM_CLASS_SELECT,  SYSADM.PS_UM_RUN_UMSTUTUI, SYSADM.PS_UM_STD_ENR_ARC, SYSADM.PS_UM_STUD_CENSUS,  SYSADM.PS_UM_STUD_EXT_ARC, PS_UM_STUD_EXT_ARC, PS_UM_STUD_EX_OARC, SYSADM.PS_UM_STD_ENR_CENS, SYSADM.PS_UM_STUD_CENSUS, SYSADM.PS_UM_STUD_EX_OARCMoved to Power BI
Student Recordsumtrmcmp.sqrTerm Count Comparison
 PS_UM_STUD_CENSUS, PS_UM_STUD_EXT_ARC

Moved to Power BI

Deleted PS_DIVERS_ETHNIC, PS_ETHNIC_GRP_TBL, PS_ACAD_PROG_TBL, PS_CITIZENSHIP and PS_RESIDENCY_OFF table since they are not used even though the code is there.

Student Recordsumstuclr.sqrStudent Clearing House File 
PS_ACAD_DEGR,  PS_ACAD_PLAN, PS_ACAD_PLAN_TBL,  PS_ACAD_PROG, PS_ACAD_PROG_TBL, PS_COUNTRY_TBL, PS_DEGREE_TBL, PS_ETHNIC_GRP_TBL, PS_EXT_ACAD_DATA,  PS_EXT_ACAD_SUM, PS_EXT_ORG_PRS_VW, PS_EXT_ORG_TBL, PS_NAMES,  PS_PERSONAL_DATA, PS_TERM_TBL, PS_UM_STUCLR_STATS, SYSADM.PS_ACAD_PLAN,  SYSADM.PS_ACAD_PLAN_TBL, SYSADM.PS_ACAD_PROG, SYSADM.PS_STDNT_ENRL, SYSADM.PS_TERM_TBL,  SYSADM.PS_UM_RUN_UMSTUCLR, SYSADM.PS_UM_STUCLR_STATS, SYSADM.PS_UM_STUD_EXTRACT, !PS_UM_STUD_EXTRACT, PS_HOME, PS_ACAD_PLAN, PS_ACAD_PROG_TBL, PS_ACAD_PROG
Student Recordsumstucsv.sqrSingle Term CSV File Creator
PS_EXT_ACAD_DATA,  PS_UM_UMSTUCSV_TEMP,  SYSADM.PS_UM_EXT_ORG_VW2, SYSADM.PS_UM_RUN_UMSTUCSV, SYSADM.PS_UM_STDNT_COHORT,  SYSADM.PS_UM_STUD_EXTRACT, SYSADM.PS_UM_STUD_EXT_ARC, PS_HOME
Student Recordsumenrcns.sqrEnrollment Summaries10/ 2017PS_UM_RUN_UMENRCNS,  PS_UM_RUN_UMIPEDDE, PS_UM_STUD_CENS_VW, SYSADM.PS_COUNTRY_TBL, SYSADM.PS_STATE_TBL,  SYSADM.PS_TERM_VAL_TBL, SYSADM.PS_UM_ORIG_ADDR_VW,  SYSADM.PS_UM_ZIP_COUNTYVW
Student Recordsummsccns.sqrMiscellaneous Reports10/ 2017PS_TERM_TBL,  PS_UM_CLSS_SCH_FCL,  PS_UM_RUN_UMENRCNS, PS_UM_RUN_UMMSCCNS,  PS_UM_STD_ENR_C_VW, PS_UM_STUD_CENS_VW, SYSADM.PS_TERM_VAL_TB
Student Recordsumdstedc.sqrDistance Education Summaries10/ 2017PS_UM_RUN_UMDSTEDC,  PS_UM_STD_ENR_C_VW, PS_UM_STUD_CENS_VW,  SYSADM.PS_TERM_VAL_TBL, PS_UM_STD_ENR_C_VW
Student Recordsumerlcol.sqrUMS Early College10/ 2017PS_TERM_TBL,  PS_TERM_TBL, PS_TERM_VAL_TBL,  PS_UM_RUN_UMERLCOL, PS_UM_STUD_CENSUS,  PS_UM_STUD_EXT_ARC
Student Recordsumgrdret.sqr

Retention Rates & Graduation Rates

11/ 2017 PSAPS_DEGREE_TBL,  SYSADM.PS_ACAD_DEGR,  SYSADM.PS_UM_RUN_UMGRDRET, SYSADM.PS_UM_STDNT_COHORT, SYSADM.PS_UM_STUD_CENSUS, PS_HOME
Student Recordsumnsclgd.sqrNSC Formatted L Grade Report 03/ 2018 JAJ

PSDBOWNER, PS_UM_RUN_UMNSCLGD, ps_um_d_std_enr_vw, ps_um_stud_ext_vw, ps_um_lastdate_atn, ps_acad_load_tbl,

Identify students with an "L" grade and determine their final date of attendance. These students need to be updated with the National Student Clearinghouse.
Financial Aidumfaexit.sqr

Process Stafford Exits

(Batch process)

10/2010

Gary Saunders

PS_ACAD_LOAD_TBL,  PS_ACAD_PROG, PS_ACAD_PROG_TBL,  PS_ACAD_STDNG_ACTN, PS_ADDRESSES,  PS_ITEM_SF, PS_ITEM_TYPE_FA, PS_NAMES,  PS_PERSON_COMMENT, PS_SRVC_IND_CD_TBL, PS_SRVC_IND_DATA,  PS_STDNT_AWRD_DISB, PS_STDNT_CAR_TERM, PS_STDNT_ENRL, PS_STDNT_FA_TERM,  PS_TERM_TBL, PS_UM_RUNCTL_EXIT, PS_HOMEIdentify students who:
   -have received a Stafford Loan, and
   -have not been exited, and
   -have dropped below Half-Time enrollment, or
   - been suspended, or applied for graduation
Financial Aidumfaperk.sqr

Process Perkins Exits

(Batch process)

10/2011

Gary Saunders


Identify students who:
 -have received a Stafford Loan, and
-have not been exited, and
 -have dropped below Half-Time enrollment, or
 been dismissed, or
 been suspended, or
 are not term activated, or
applied for graduation
Financial Aidumperkns.sqrPerkins Loans CP Submissions
PS_ADDRESSES_EFFVW,  PS_ITEM_TYPE_FA, PS_NAMES_VW,  PS_PHONE_VW, PS_STDNT_AWRD_ACTV,  PS_TERM_TBL, PS_UM_CP_LOAN, SYSADM.PS_UM_RUN_UMPERKNS,  SYSADM.PS_UM_STUD_EXTRACT, PS_HOME, PS_PERS_NID
Financial Aidumstfext.sqrStafford Exit Interview
PS_ACAD_STDNG_ACTN,  PS_ACAD_PROG, PS_ACAD_STDNG_ACTN,  PS_ADDRESSES, PS_ITEM_SF, PS_ITEM_TYPE_FA,  PS_PERSON_COMMENT, PS_STDNT_CAR_TERM, PS_TERM_TBL,  SYSADM.PS_UM_RUN_UMSTFEXT, PS_HOME, PS_EMAIL_ADDRESSES, PS_ITEM_TYPE_FA, PS_PERSONAL_DATA, PS_UM_STUD_EXTRACT
Financial Aidumtaxoff.sqrTax Setoff Program - Overdue Student Loans
SYSADM.PS_UM_CP_LOAN,  SYSADM.PS_UM_RUN_UMTAXOFF, PS_HOME
Financial Aid
CP Table Builder

Not sure why this is here. It was on the original list from Bill but has no info.
Financial Aidumfaipds.sqr

Annual IPEDS Report for Financial Aid - Current

12/ 2017 PSAPS_STDNT_AWARDS,  PS_STDNT_GRPS, PS_UM_FIN_AID,  PS_UM_STUD_CENSUS, PS_UM_UMGROUP4,  SYSADM.PS_UM_RUN_UMFAIPDS, SYSADM.PS_UM_UMGROUP4, PS_HOME
Financial Aidumfastub.sqrCommon Dataset for Financial Aid3/2011 PSASYSADM.MF_STDNT_SRCHVW,  PS_ACAD_PLAN_TBL,  PS_ACAD_PROG,  PS_ADM_APPL_DATA,  PS_DEGREE_TBL,  PS_ISIR_STUDENT_FLAG,  PS_ITEM_SF,  SYSADM.PS_DEGREE_TBL,  SYSADM.PS_ACAD_DEGR,  SYSADM.PS_ACAD_DEGR_PLAN,  SYSADM.PS_ACAD_PLAN_TBL,  SYSADM.PS_ACAD_PROG,  SYSADM.PS_ADM_APPL_DATA,  SYSADM.PS_ADM_APPL_PROG,  SYSADM.PS_FATRMP_CAR_TRM,  SYSADM.PS_ISIR_STUDENT,  SYSADM.PS_STDNT_GRPS,  SYSADM.PS_TERM_VAL_TBL,  SYSADM.PS_UM_AGGR_LOAN_VW,  SYSADM.PS_UM_FIN_AID,  SYSADM.PS_UM_ITYP_TREENDS,  SYSADM.PS_UM_RUN_UMFASTUB,  SYSADM.PS_UM_STUD_CENSUS, PS_HOME, SYSADM.PS_ITEM_TYPE_FA, SYSADM.PS_STDNT_AWARDS







umsqr.sqronly line in sqr -- #Include 'uminclude.sqc'  !um user sqc



umsqrrun.sqronly line in sqr -- #Include 'umsqrinc.sqc'  !um user sqc



umsqrusr.sqronly line in sqr -- #Include 'umstuink.sqc'  !um user sqc