DARTS : Federal Work Study

Report Purpose

Provides actual YTD amount for federal work study by department, account, fund code, and program code.

These two queries are both for federal work study, however, the criteria used are very different. Please review the criteria below carefully when you run the query.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer

Report Name

• UMS_DTS_FEDERAL_WORK_STUDY
• UMS_DTS_FEDERAL_CWS_MATCH (for PROGRAM= 57530 only)

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

UMS_DTS_FEDERAL_WORK_STUDY:

• Fiscal Year
• Accounting Period 
• Business Unit (Leave it blank if you want to see data from all business unit)

UMS_DTS_FEDERAL_CWS_MATCH:

• Fiscal Year
• Accounting Period 

Data Fields Generated

UMS_DTS_FEDERAL_WORK_STUDY:

UMS_DTS_FEDERAL_CWS_MATCH:

Tables Used

• UM_GLQ_REPRTING - Ledger Data

Criteria Used

UMS_DTS_FEDERAL_WORK_STUDY:

• FUND_CODE <> '90'
• ACCOUNT BETWEEN 52999 AND 53090

UMS_DTS_FEDERAL_CWS_MATCH:

• FUND_CODE in list ('00','03','23')
• ACCOUNT BETWEEN 53000 AND 53291
• PROGRAM_CODE ='57530'