DARTS : Scholarships Account Balance

Report Purpose

This report provides current budget, actual YTD expenses, and current account balance for certain scholarships. Criteria differentiating each report is listed at the bottom of the page. This report is for certain department only. 

Report Location

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

Report Names

See criteria below to differentiate between queries.

• UMS_DTS_SCHOL_ACCT_BAL
  
• UMS_DTS_SCHOL_ACCT_BAL_5150987
  
• UMS_DTS_SCHOL_ACCT_BAL_SYSWIDE
  

Report Type

Query

Prompts Required

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

• Fiscal Year
• Accounting Period 
• Business Unit (Leave blank to return data from all business units)

Data Fields Generated

Tables Used

UM_GLQ_REPRTING - Ledger Data

Criteria Used

UMS_DTS_SCHOL_ACCT_BAL:

• FUND_CODE NOT in list ('31','11','21')
• DEPTID in list  ('5150987','5150988','5850985') OR 
  PROGRAM_CODE  in list ('55027', '52884', '52794', '52555', '52820', '52533', '52354', '52643', '52748', '52963', '52462', '52822', '50317', '50534', '52991', '52849', '54825', '50526', '52883', '53021', '54647', '54865', '55197', '52854', '55225')

UMS_DTS_SCHOL_ACCT_BAL_5150987:

• FUND_CODE NOT in list ('31','11','21')
• DEPTID in list  ('5150987','5150988','5850985') 

UMS_DTS_SCHOL_ACCT_BAL_SYSWIDE:

• FUND_CODE = '31'
• DEPTID = '8100113' OR 
  PROGRAM_CODE  in list ('10001', '10002', '14401', '16001', '16010', '20001', '20002', '24401', '30001', '30002', '34401', '40001', '40002', '60001', '60002', '60131', '64401', '64458', '64611', '64613', '70001', '70002', '74401')