Space Details:

Key	DARTS
Name	DARTS
Description
Created by	john.h.brown (Oct 24, 2016)

Available Pages:

Data, Analytics & Reporting Technology Services
- UMS Index of Reports
  - UMS Certified Reports
  - Human Resources Reports
    - Benefits & Payroll
      - Active Employees by Campus
      - Active Job has Benefits Primary Job Flag of "N"
      - Current Distributions
      - Full- and Part- Time Faculty for Delaware Study
      - Paid Wages/ Distribution Reviews
      - Pay & Accounts by Employee ID
      - UMF & USM Wages with Fund Source and Hours Worked
      - UMS IT Student Employee Earnings
      - USM Student Employee Hours and Departments
      - UMS Special Distribution Tracking Pages Updates
      - Instructor Teaching - Class Assignments in each of 5 possible Load Levels
    - Position Management
      - Budget Reports
        
        Base Budget List
        
        Budget List
        
        Budget Report
        
        Budget Report - DEPTID
        
        Budget Report - Fund Code
        
        Budget Report - Salary
        
        Budget Review for Trustees
        
        Budgets Less Than $0
      - Campus Specific Budget Reports
        
        UMS01 (UMA) Budget List
        
        UMS01 (UMA) Part-time & Overload Budget Changes
        
        UMS05 (UM) NSFA Budget List
        
        UMS05 (UM) NSFA Employee List
        
        UMS08 Procurement Budget Report
      - Employee Class History
      - Position vs. Job Data
      - Vacant Positions
    - Employee Addresses with Supervisor
    - Census Dates for UM_F_EMP_CENSVW Updates
    - Years of Service
  - Finance Reports
    - Finance Query Logic Templates
      - UMS_DTS_SPAN_FISCAL_YR_PROMPTS - Template query to span fiscal years in finance
    - Benefits & Payroll (Finance)
      - Faculty Salary and Student Wages Summary Tables
      - Faculty Wages Variance
      - Federal Work Study Wage Summary by Emplid
      - GLM - Benefits Distribution
      - OFBRI Wages Variance
      - UMS05 (UM) NSFA GL Summary
      - UMS05 (UM) NSFA HR Detail - Journal Entries
    - Budget Analysis
      - Department Budget and Actuals by Month
        
        Department Budget and Actuals by Fiscal Year and Accounting Period - USM Academic Affairs
        
        UMS05 (UM) NSFA Report
        
        UMS05 (UM) NSFA Balance for All Funds
        
        UMS05 (UM) NSFA Base Budget
        
        UMS05 (UM) NSFA Current Budget Detail
        
        UMS05 (UM) NSFA Farm Reports
        
        UMS05 (UM) NSFA Journal Detail
      - Expense for Fund 23
      - GL Inquiry Travel & Expense Report Detail
      - ITS Financial Summary Report
      - Journal Activity
      - Multiple Year Budget Report
      - Operating Detail
      - Part-time & Overload Budget
      - Revenue & Expense Report
      - SFA - Reserve for Doubtful Accounts
      - Transfer Check
      - UMS01 (UMA) Instate Academic Travel Fund 00
      - UMS06 (USM) Auxiliary Services Reports (Formerly University Outreach)
        
        UMS06 (USM) UO Accounts
        
        UMS06 (USM) UO Budget Worksheet
        
        UMS06 (USM) UO Monthly Transaction
        
        UMS06 (USM) UO Revenue/ Expense Summary
    - Facilities
      - Board of Trustees Project Status Report
      - Capital and Maintenance Projects Expense
      - Facilities Base Budget
      - Facilities Functional Expense
      - Facilities Operating Expense Budgets
      - Integrated Work Management System Project
      - Repairs and Maintenance GL Detail (Year End)
      - UBIT Capital Projects Expense
      - UMS05 Facilities Budget Analysis
      - UMS05 Facilities Budget Projection- Fund 00
      - UMS05 Facilities YTD Transactions
      - UMS08 Facilities by Month
      - UM Year End Deficits - Construction Projects
      - Year End Deficits - Campus Projects
    - Financial Aid (Finance)
      - Direct Loans
      - Federal Work Study
      - IPEDS Scholarships and Waivers
      - Loan Fund Cash Balance
      - Racino Scholarships
      - Scholarships Account Balance
      - SEOG Match
      - Tuition Waivers
      - UM Foundation Balance
      - UM Scholarships Master Report
    - Gifts and Endowments
      - Advancement Report - Campus Program Balances
      - Charitable Gift Annuities
      - Endowment Income
      - Endowment Non-Gift Activity
      - Endowment Revenue - Fund 50
      - Quasi Endowment Revenue
      - UMS06 (USM) Advancement Report- Journal Entries
      - UMS06 (USM) Endowment Share, Values, and Balance
      - Year End Deficits - Gifts
    - Grants & Contracts
      - Journal for Non-Comp Expenditures by Project ID & Fund Code
      - List of Grants and Contracts
      - MEIF (Maine Economic Improvement Fund)
        
        MEIF - Actual Expenditures
        
        MEIF - Compensation Funding
        
        MEIF - Match
        
        MEIF - R&D Transfers
        
        MEIF - Revenue & Expense
        
        MEIF - State Appropriation
        
        MEIF - Unused Funds
        
        MEIF - YE Balance/Deficits
      - UMS05 (UM) NSFA Grants & Contracts
      - Year End Deficits - Cost Share
      - Year End Deficits - LOC Grants & Contracts
      - Year End Deficits - Nonc LOC Grants & Contracts
      - Year End Deficits - SFA Projects
    - Position Management (Finance)
      - Regular vs Temporary Salary Review
    - Year End
      - Year End Deficits - Designated
        
        Year End Expense Analysis
    - nVision Reports
    - Description Tables for ChartField Components
      - Chartfield Detail by Any Prompt
  - Student Data (Campus Solutions) Reports
    - Financial Aid Reports
      - NCAA Division III Financial Aid Reports
      - Credit Hours for In-State Pell Grant Recipients
      - Annual IPEDS Report for Financial Aid - Current
      - Financial Aid Blank Item Clean-up Query
      - Scholarship by Item Type
      - List of Financial Aid
    - Admissions Reports
      - Admitted Veteran Course Registration
      - Deferred Student Admission Audit Query
      - Nursing Program Applicants, Admissions, and Enrollments
      - Prior Learning Assessment (PLA) Credits
      - Retention Update Reports
      - SAT Scores: Traditional With Translation to New Values
      - Tuition Waivers & Native American Room & Board Scholarships
      - UM Accepted (Admitted & Matriculated) Student Report
      - UMS05 Admissions Funnel
      - UMS_IR_APP_ADM_ENR_FUNNEL_RNL - Admission Funnel Data for RNL
      - UMS Admissions 5 Yr Comparison
      - UMS Admissions Incoming Athletes
      - UMS Admissions Major Feeder School
      - UMS Admissions Status by Program and Plan
    - Enrollment (Including Census) Reports
      - Academic Plans Associated with CIP Codes - All Campuses
      - Admitted but not Enrolled
      - CIP Codes in Course Catalog and Subject Tables
      - Class Section List - Delaware Study
      - Class Summary
      - Credit Hours for Majors
      - Current Students, Faculty and Staff
      - Enrollment by CIP Category for Computer and IT Fields
      - Enrollment Headcount from Archive
      - Enrollment Summaries with IS and OS Subtotals
      - First Generation Enrollment Report
      - First Generation Fix
      - First Generation Missing Student Groups
      - FTE Enrollment Headcounts
      - Institutional Research Class Section List Data
      - Institutional Research Course Info Data
      - Institutional Research Student Data: Stdnt Enrl Status = 'E' OR Enrl Action Last = 'D'
      - Institutional Research Student Data: Stdnt Enrl Status = 'E', Enrl Drop Dt IS NULL
      - IPEDS Distance Ed Report (Prior to Fall 2021)
      - Maine Community College System Transfers Report
      - Major/Double Major Credit Hour Split
      - Nursing Enrollment System-wide Total
      - On-campus Housing all Four Years
      - Records and Enrollment SQR Reports
      - Retention Rates & Graduation Rates
      - Student and Faculty Email Addresses by Term
      - Student Contact Data
      - Student Enrollment Census Reports
        
        Enrollment Summaries (UM Enrollment Census Report)
        
        Miscellaneous Reports
        
        Class Unit Location Report
        
        First Time Student Report
        
        Multiple Term Report
        
        Student Profile Report
        
        Term Count Comparison
        
        Tuition Report
        
        Student (Primary) Plan Report
        
        Duplicate Registration Report (Student Multiple Registration Report)
        
        Student Residence Report
        
        Student Summary Report (Census)
        
        IPEDS Fall Enrollment Report
        
        IPEDS 12-month Enrollment Report
        
        Distance Education Report (Census)
        
        Class Unit Location Report - Power BI
      - Student Summary Report
      - UMS Early College Report
      - USM IPEDS Enrollment Data
      - Veteran Enrollment in Nursing Programs
      - Census Reporting Changes - Fall 2020: Instruction Mode & Residency
      - Census Reporting Changes - Summer 2021: Instruction Mode
    - Academic Affairs Reports
      - Campus Solutions Security Roles by User
      - Full Time vs Part Time Instructor Teaching Load
      - New Faculty Report
      - UMS Missing Faculty Security Roles
  - Reports by Department
    - UMS01 (UMA) Finance Reports
    - UMS05 (UM) Athletics Report
    - UMS05 (UM) Budget Office Reports
    - UMS05 (UM) Facilities Reports
    - UMS05 (UM) Finance Office and Colleges Reports
    - UMS05 (UM) Financial Aid Reports
    - UMS05 (UM) NSFA Reports
    - UMS07 (UMPI) Finance Reports
    - UMS Accounting Reports
    - UMS Facilities Reports
    - USM Auxiliary Services Reports (Formerly University Outreach)
    - USM Foundation Reports
  - System-wide Reports
  - Public Institutional Research & Campus Reports
- UMS Index of Reporting Tables
  - Human Resources Tables
    - Recommended Tables for Reporting in HR
    - ACCT_CD_TBL - Account Codes
    - ADDL_PAY_DATA - Additional Pay Detail
    - EMPLOYEES - Non terminated Employees
    - EMPLOYMENT - EE General Employment Data
    - HEALTH_BENEFIT - EE Health Benefit Elections
    - HR_GENDER_DAT - Gender Identity Staging Record
    - JOB - EE Job History
    - PAY_CHECK- Pay Check
    - PAY_CHECK_EARNS - Pay Check Earnings
    - PERSONAL_DATA - PERSONAL_DATA for Rpting (HR)
    - PERSON_GENDER - Person Gender Details
    - PERSON_NAME - Current Primary Name View
    - POSITION_VIEW - Posn Descr - Employment Titles
    - UM_CLS_SCH_FCL
    - UM_DISTRIB_TBL - Clone of DEPT_BUDGET
    - UM_EARN_ACCT_VW
    - UM_F_ANNUAL_DIS - Account Distributions
    - UM_F_EMP_CENSVW - Employee Census Table VW
    - UM_F_EMPLOYE_VW - Employee Flat Table
    - UM_F_EMPL_VW - Employee Flat Table
    - UM_F_POS_BUD_VW - view of Posi & Budget extract
    - UM_FRINGE_RATE - Fringe Percentage Rates
    - UM_PATFA_DTL
    - UM_PATFA_LOAD - Staging record to load PATFA
    - UM_PAYEARNS_VW
    - VALID_COMBO_TBL - Valid Combination Codes
  - Finance Tables
    - APPR_INST_VW - Approval Instance Log View
    - BUS_UNIT_TBL_FS - PS/Financials Business Units
    - CAL_DETP_TBL - Detail Calendar Periods
    - CF_ATTRIB_TBL - CFs and Attribute values
    - CF_ATTRIB_VALUE - Valid CF Attrib values
    - CLASS_CF_TBL - Class of Trade Table
    - DEPT_TBL - Departments
    - EX_TAUTH_HDR - Travel Authorization Header
    - FUND_TBL - Fund Table
    - GL_ACCOUNT_TBL - Accounts
    - JRNL_APPR_WL - Journal Approval Worklist Rec
    - JRNL_HEADER - Journal Header Data
    - JRNL_LN - Journal Line Data
    - KK_ACTIVITY_LOG - KK budget activity record
    - KK_LIQUIDATION - Comm. Cntrl. Liquidation Table
    - KK_SOURCE_HDR - Comm. Cntrl. Source Hdr Table
    - LEDGER - Ledger Data
    - LEDGER_BUDG - Budget Ledger Data
    - LEDGER_KK - Ledger Data
    - OPER_UNIT_TBL - Operating Unit
    - PERSONAL_DATA - EE Personal Data
    - PO_HDR - Purchase Order Header
    - PROGRAM_TBL - Program Table
    - PROJECT - Projects
    - PROJECT_MGR - Project Manager
    - PROJECT_STATUS - Project Status
    - PROJECT_VW - Operational Projects View
    - PSTREELEAF - Tree Leaf
    - PSTREENODE - Tree Node
    - TREE_NODE_TBL - Tree Nodes
    - UM_AIM_ACCTG_LN - AiM Work Order Accounting Line
    - UM_CC_ACCTG_LN - UM ProCard Accounting Line
    - UM_DIST_CAT - UM Work Study Distrib Category
    - UM_DIST_RULES - UM Work Study Distrib Rules
    - UM_FAST_XLAT_VW
    - UM_FGLALLJOB_VW (FIN)
    - UM_FGLEMPLOY_VW
    - UM_GLINQ_AP_VW
    - UM_GLINQ_EX_VW
    - UM_GLINQ_HR_VW
    - UM_GLQ_ACCTA - GL reporting account attribute
    - UM_GLQ_REPRTING - Ledger Data
      - Tree: UMS_DEPT_F
      - Tree: UMS_DEPT_ORG
      - Tree: UMS_PROJECT
      - Tree: UMS_PROGRAM
    - UM_GLQ_REPRT_VW - Ledger Data
      - Code behind PS_UM_GLQ_REPRT_VW
    - UM_HR_ACCTG_LN - Payroll Accounting Line
      - GL Inquiry & UM_HR_ACCTG_LN
    - UM_HR_ACCTG_VW - HR Acctg Line with cf descr
    - UM_HR_XREF - HR Dept Reference
    - UM_JOURNAL_VW - Journal header - line details
      - GL Inquiry & journal source
    - UM_JRNL_APPR_VW - Journal, approval, cf descr
    - UM_OBJ_XLAT
    - UM_PROJECT_STAT - UM Project Status
    - UM_SF_ACCTG_VW
    - VENDOR - Supplier Header Table
  - Student Data (Campus Solutions) Tables
    - ACAD_LEVEL_TBL - Academic Level Table
    - ACAD_ORG_TBL - Academic Organization Table
    - ACAD_PLAN - Student Academic Plan Table
    - ACAD_PLAN_TBL - Academic Plan Table
    - ACAD_PROG - Student Academic Program
    - ACAD_PROG_TBL - Academic Program Table
    - ACAD_SUBPLAN - Student Academic Subplan Table
    - ACAD_SUBPLN_TBL - Academic Sub Plan Table
    - ADDRESSES - Address Type
      - New address type hierarchy in UM_STUD_EXTRACT
    - ADDRESS_TYP_TBL - Address Type Table
    - ADM_APPL_CMP - Adm Application Componet
    - ADM_APPL_DATA - Admission Application Data
    - ADM_APPL_PROG - Admission Applicant Program
    - ADM_APPL_VW - Adm Application View
    - CIP_CODE_TBL - CIP Codes
    - CLASS_ATTRIBUTE - Class Attribute Table
    - CLASS_INSTR - Class Instructor Table
    - CLASS_MTG_PAT - Class Meeting Pattern Table
    - CLASS_TBL - Class Table
    - CLASS_TBL_SE_VW- Class Table Student Enrl View
    - CRSE_ATTR_TBL - Course Print Attribute Table
    - CRSE_ATTR_VALUE - Course Attribute Value Tbl
    - CRSE_CATALOG - Course Catalog Data
    - CRSE_OFFER - Course Catalog Offerings
    - DEGREE_TBL
    - DIVERS_ETHNIC - Ethnic Diversity
    - ETHNIC_GRP_TBL - Ethnic Group Table
    - ETHNICITY_DTL - Ethnicity Detail
    - EXT_ORG_TBL_ADM - External Org Admissions
    - EXT_DEGREE - External Degrees
    - FACILITY_TBL - Facility Table
    - ISIR_COMPUTED - Computed Data from INAS/DOE
    - ISIR_CONTROL - ISIR Internals/Control Data
    - ISIR_PARENT - Fed Parent Application Data
    - ISIR_STUDENT - Fed Student Application Data
    - ITEM_LINE_SF
    - ITEM_SF - Item Record
    - ITEM_TYPE_FA - FA Item Type Table
    - ITEM_TYPE_FA_VW - Item Type Search Record for FA
    - LOCATION_TBL - Company Site Locations
    - PERSON_NAME - Current Primary Name View (CS)
    - PERSONAL_DATA - PERSONAL_DATA for Rpting
    - PERSONAL_DTSAVW - SA Personal Data View
    - RELATION_VW - Relationships View
    - RELATIONSHIPS - Relationships
    - RESIDENCY_OFF - Official Residency Data
    - RL_STDNT_ROOM - ResLife - Student Room Assignm
    - SA_TCMP_REL_TBL - Test Component Relationships
    - SCC_CITIZEN_QVW - Citizenship Query View & CITIZENSHIP - EE/Dependent Citizenship
    - SCC_EMAIL_QVW - Email Address Query View & EMAIL_ADDRESSES - Email Addresses
    - SCC_PERDATA_QVW - PERSONAL_DATA Query View
    - SCC_PERS_BIOG - Gender ID Record
    - SCC_PERS_PH_QVW- Phone Numbers Query View
    - SF_ACCTG_LN - SF Accounting Line
    - STDNT_AWARDS - Student Awards
    - STDNT_AWD_PER - Student Award PeriodTable
    - STDNT_AWRD_ACTV - Student Award Activity
    - STDNT_AWRD_DISB - Student Award Disbursements
    - STDNT_CAR_TERM - Student Career Term Table
    - STDNT_ENRL - Student Enrollment Table
    - STDNT_EQUTN_VAR - Student Equation Variables
    - STDNT_GROUP_TBL - Student Group TBL
    - STDNT_GRPS - Student Groups
    - STDNT_GRPS_HIST - Student Groups History
    - STDNT_TEST_COMP - Student Test Components
    - SUBJECT_TBL - Subject Table
    - TERM_TBL - Term Definition Table
    - TERM_VAL_TBL - Term Value Table
    - TRNS_OTHR_DTL - Student Other Credit Detail
    - UM_AGGR_LOAN_VW
    - UM_APPL_EXT_VW - Applicant Reporting Extract
    - UM_APPL_EXTRACT - Applicant Reporting Extract
      - Issues for UM_APPL_EXTRACT
    - UM_CLSS_SCH_FCL - Class Schedule and Facility Vw
    - UM_CNS_RPT_VW
    - UM_COHORT_TBL - Student Cohort
    - UM_D_APPL_PG_VW - Admission Applicant Program
    - UM_DEGREES_COMP
    - UM_DLY_RPT_VW
    - UM_D_MIN_TERMS
    - UM_D_STD_ENR_VW - Student Enrollment Table
    - UM_FERPA_VW
    - UM_FGLALLJOB_VW
    - UM_FGLEMPL_ACVW
    - UM_FGLEMPLOY_VW - Human Resources employee data flat file (CS)
    - UM_FIN_AID
    - UM_FIN_AID_DTVW
    - UM_FLAT_ADVISOR
    - UM_FLAT_CMPT_VW
    - UM_FLAT_PRGPLAN
      - Program/Plan View Comparison Chart
    - UM_FLT_PRGPLN
      - Change Request for UM_FLT_PRGPLN
    - UM_GRAD_APPL_HD
    - UM_GRAD_APPL_VW - Student Acad Prog Prompt Vw
    - UM_HOME_INST_VW
    - UM_ITYP_FA_VW - FA view of Item Types
    - UM_LOCATION_DTL - Distance Education Locations
    - UM_NAMES_PRF_VW
    - UM_NAMES_VW - Person Names Query View
    - UM_NEBHE_SETUP
    - UM_NEBHE_STATE
    - UM_NEBHE_ST_TBL
    - UM_ORIG_ADDR_VW
    - UM_PRAXCUR_DTL
    - UM_PRGPLAN_CENS & UM_PRGPLAN_STRM
    - UM_RETENTION_FS
    - UM_SAT_CONCORD
    - UM_SFA_VA_BENES - SFA VA Benefits Certification
    - UM_STD_ENR_CENS - Student Course Census Table
    - UM_STD_ENR_C_VW - Student Enrollment Table
    - UM_STDNT_COHORT - Student Cohort
    - UM_STUD_CENSUS - Student Reporting Extract Arch
    - UM_STUD_CENS_VW - Student Reporting Extract
    - UM_STUD_EXTRACT - Student Reporting Extract
      - Code behind UM_STUD_EXTRACT
      - Issues on UM_STUD_EXTRACT
    - UM_STUD_EXT_ARC - Student Reporting Extract Arch
    - UM_STUD_EXT_VW - Student Reporting Extract
    - UM_TEST_SCORE_V
    - UM_TRIBE_TBL - UM Tribe Table
    - Financial Aid Tables
    - Recommended Tables for Reporting in CS
    - Retention related tables and views
    - UM_RETENT_FS_IN - Non continuous Fall & Spring
  - Prompt Tables
    - Campus Solutions Prompt Tables
    - Finance Prompt Tables
    - Human Resources Prompt Tables
  - PeopleSoft Table Changes
- UMS Index of Data Marts
  - Finance Data Mart
    - Finance Data Mart Composition
      - Finance data model in Power BI
        
        Finance Data Model : Account
        
        Finance Data Model : Business Unit
        
        Finance Data Model : Calendar
        
        Finance Data Model : Class, Fund, & Operating Unit
        
        Finance Data Model : Department
        
        Finance Data Model : GLQ
        
        Finance Data Model : Program & Project
  - Student Data (Campus Solutions) Data Marts
    - Admissions Applicant Data Mart
      - Admissions Applicant Data Mart Composition
- Data Dictionary
  - UMS Reporting Terminology
    - Academic Career
    - Academic Group
    - Academic Level
    - Academic Plan
    - Academic Program
    - Academic Sub-Plan
    - Admissions Type
    - Advisement Status
    - Application Program Data
    - Basic Process Status
    - Business Unit
    - Business Unit MCV09
    - Certificate
    - Citizenship Status
    - Campus
    - Country
    - Country and Citizenship Status Historical Information
    - County
    - Credit Hour Reporting Information
    - Cross-listed Course Reporting Information
    - Data Verification
    - Degree
    - Degree Checkout Status
    - Degree/Non-Degree Coding - Current
    - Distance Education
      - Distance Education Calculations
      - Distance Education Course Coding - Current
      - Online Courses on Campus Websites, March 2019
    - Education Level
    - Employee Classification
    - Ethnicity
      - Ethnicity and Race Reporting - Historical Documentation
      - PSXLATITEM for ETHNIC_GROUP to UM_ETH_GRP_DESCR
      - Calculation for UM_ETHNIC_GRP_DESC field
    - First Generation
      - First Generation - prior to Fall 2021
      - First Generation - Summer 2021 change for Spring 2022 admits
    - First-Time and First-Year Students
    - Fund Code Descriptions
    - Highest Education Level
    - Official Grade
    - People Relation & Guardian Relation
    - Plan Type
    - Post-Baccalaureate - Data Consistency
    - Program Action
      - Program Actions & Reasons
    - Program (Action) Reason
    - Program Status
    - Salary Administration Plan
    - SAT Concordance Tables
    - State
    - Study Abroad Data Entry Directions
    - Academic Partnerships
  - Calculated Fields & Expressions
    - HR Calculated Fields & Expressions
      - UM_F_EMP_CENSVW
      - UM_F_POS_BUD_VW
    - FN Calculated Fields & Expressions
      - UM_HR_ACCTG_LN & UM_HR_ACCTG_VW
      - UM_GLQ_REPRTING
    - CS Calculated Fields & Expressions
      - Financial Aid Calculations and Translations
      - Sort by Semester When STRM is Not Available
- UMS Data Standards
  - Student Data (Campus Solutions) Data Standards
    - Classification of Instructional Programs - CIP_CODE Data Standards
    - Deferred Student Admission Data Standards
    - Early College Academic Program Coding Data Standards
    - Early College Class Section Coding Data Standards
    - Instruction Mode Data Standards
    - Instructor Load Factor Data Standards
    - Military Leave Data Standards
  - Finance Data Standards
  - Human Resources Data Standards
  - Enterprise Data Standards
  - Collections
    - UMS Admissions Funnel
  - First Generation Data Standards
- Training Materials & Resources
  - Admissions Resources
  - Financials Resources
    - Reporting Tool Comparison
  - Financial Aid Resources
    - IR & Reporting Access to Financial Aid Data
    - Financial Aid Item Types
      - Financial Aid Item Type Definitions
  - UMS IT Data Resources
  - External Education & Reporting Resources
    - IPEDS Reporting Resources
    - EAB
    - NC-SARA
    - Delaware
  - Data Responsible Use & Best Practices
    - Report Sharing Guidance
    - UMS Data Classifications
  - Power BI Overview
    - Power BI for Consumers
      - Opening Power BI Reports
        
        Viewing Power BI Census Reports
      - Explore Power BI Reports
        
        Anatomy of a Power BI Report
      - Explore Power BI Reports on a Public Website
      - Explore Paginated Reports
    - Power BI for Report Authors
      - Got a Pro License? What's next?
      - Power BI Report Publication Decision Tree
      - Report Creation Workflow
      - Sync SharePoint User Libraries to Your Computer
      - Connect to Data Source file
      - Connect to Multiple Data Source Files
      - Connect to Dataset on Workspace
      - Managing Dataset Permissions
      - Publishing an App
      - PBI Troubleshooting
        
        Connection Error Troubleshooting
      - Power BI File Storage Best Practices
      - Data Visualization Best Practices
      - Templates
      - Accessibility Standards in Power BI
      - Publish to Web
      - Calculate Prior Year Change
      - Dynamic Title
      - Adding Data Refresh Date and Time
      - Paginated Report - Intro and Best Practices
      - UMS Accounting Office PBI Report Creation Workflow
      - UMS Accounting Office PBI Report - Fields
    - Power BI for Data Modelers
      - Data Modeling Best Practices
      - Tips for Refining Your Data Model
        
        Organize your model
      - Publishing Dataset to Data Workspace
      - Transforming Data
      - Create Date/ Calendar table
      - Row Level Security in Power BI
      - Data Model Troubleshooting
      - Data Model Optimization with DAX Studio
      - Flat file to dimension model example
      - Scheduled Refresh in Power BI Service
    - Power BI for IT Administrators
      - Build Reports using IT Managed Datasets
      - Set Up Parameters for Database
      - PBI Governance Team Role
      - Power BI HUB Access
        
        Create User Library in Power BI HUB
        
        User Library Administrator (Owner) Access in Power BI HUB
      - When PBI Requests Come...
      - Workspace Creation
      - Assign a Gateway in the Power BI Service
      - Data Privacy Settings
      - UMS Accounting - PBI Workflow
      - Workspace Owner Roles
      - ALM Toolkit
      - Update Credentials for Gateway
    - Power BI Resources
      - Installing Power BI Desktop
      - Power BI Licenses
      - Power BI Workspaces & Apps
      - Power BI Service & Premium Capacity
      - Power BI Permissions
      - Power BI Workspace Roles
      - Managing UMS Power BI HUB SharePoint Library Access
        
        Power BI HUB User Library Administrators list
      - Power BI Meeting Materials
      - IR Power BI Group
      - Power BI FAQs
      - Power BI Governance Team
  - PeopleSoft® Query
    - Beginner PS Query
      - Running Reports with Query Viewer & Query Manager
      - Saving & Organizing Queries
      - Maintaining a Private Query Library
      - Editing Queries
      - Changing a Selection for Variables in a Criteria
      - Adding a New Prompt
    - Intermediate PS Query
      - Finding Your Data
      - Creating a New Query
      - Creating Record (Table) Join
      - Join Types
      - Effective Date
    - Advanced PS Query
      - Creating Expressions
        
        Aggregate and Analytic Functions- Partition Over/Partition By etc.
        
        Flattening a File - Multiple Rows to Single Row
        
        Expression Libraries
      - Having
      - SQL Syntax & Distinct
      - Subqueries & Unions
    - Data Access Requests
    - PS Query Best Practices
    - Troubleshooting PS Query
      - Why won't my query run?
      - Allowing Pop-ups for MaineStreet
      - Clearing Your Browser's Cache
      - Scheduling Queries
      - Query Limits
      - PS Voodoo
      - Log-in page keeps spinning
      - Using a Blank Prompt to Return all Institutions
    - Training for Functional Areas
      - Campus Solutions Query
        
        CSPRD Exercise: Modify Course Query (Easy to moderate)
        
        CSRPT Exercise: Modify Enrollment Query (Easy to moderate)
      - Finance Query
        
        Exercise: Modify GL Query Exercise (Easy to moderate)
        
        Replacing DEPT_CRx with "in tree" logic
      - Human Resources Query
  - Institutional Research (IR)
    - Creating and Managing a Retention Cohort Group
      - Batch Cohort Upload Process Detail
      - Proposed new retention cohort view- UM_RETEN_COHT_VW
        
        Cohort process and UM_RETEN_COHT_VW discussion with IR group
    - Handling Retroactive Withdrawals in Cohort Table
    - Institutional Research, Reporting, and Assessment Knowledgebase
    - Reporting Standards & Practices
      - Administrative Practice Letter (APL) VI-C - Information Security
      - Data Dictionary (Glossary)
        
        Degree/Certificate-seeking Students
      - Family Education Rights and Privacy Act (FERPA)
  - Process Documents
    - Deferred Student Admission Coding
    - Academic Interests
    - Academic Test Summary
    - Financial Aid: Importing a Federal Data File-032608
    - Instruction Modes Documentation
      - Accessible Guide for Choosing Instruction Modes
      - Instruction Modes Documentation - UMPI
    - Load Factor Introduction
      - Entering Instructor Load Factor in MaineStreet
      - Instructor Workload Set Up
    - MaineStreet Access to Student Data (Campus Solutions)
      - MaineStreet Access to Student Data (Campus Solutions) FAQs
      - UMS - Campus Solutions Security Liaisons
    - Military Leave & Return Procedures
    - COVID-19 Withdrawals & Registration Holds
    - Preventing Duplicate IDs in MaineStreet Campus Solutions using Search/Match
    - Preventing Duplicate IDs in MaineStreet Human Resources using Add a Person
    - Course Component Documentation
    - COVID-19 Withdrawals & Registration Holds (Prior Information for 2021-2022 Academic Year)
    - Course Facility ID Documentation
  - Excel Tips
  - DARTS Consultant Outcomes
  - Functional Area Outreach
    - Campus Solutions Outreach
      - 2019-10-02 Meeting notes
    - Financials Outreach
    - Human Resources Outreach
  - Data Cookbook Resources
    - How to Interact with Definitions in Data Cookbook
    - Documenting Processes and Procedures with Data Cookbook & Confluence
    - How to Manage Your Data Cookbook Account
  - Personalize your MaineStreet CS 9.2 Experience
  - How to Run SQR Runner Job
  - How to Run an SQR Report
  - IPEDS System Coordinator
    - UMS IPEDS Keyholders and Responsible Parties
  - Install Oracle Components and Connecting to Database in sqldeveloper
- About DARTS
- UMS Data Marts Project
  - Admissions Research
    - Dean's list and GPA Calculation
  - Athena & DARTS Communication
  - Data Architecture
  - Data Model
    - Data Mart Wishlist
    - Data Modeling Tool Comparison
    - ER/Studio Data Architect Installation Instructions
    - Physical Modeling on ER Studio
  - Git for Developers
  - Meeting with End Users
    - 2019-06-12 Power BI to SSAS Data Models
    - Applicant Extract: Ethnicity Fields
    - Applicant Extract: External Org Fields
    - Finance Access Roles Meeting notes
    - Proposed Changes: Applicant Extract: External Org Fields
    - UMS Applicant Extract Usage, Contents, Evolution (2/6/19)
  - Power BI Pilot
    - Data Source for Admission Dashboard
    - Data Issues for Admission Dashboard
    - Power BI Implementation Resources
    - Power BI Implementation Questions
    - Power BI Implementation: On-Prem & Cloud Questions/Answers
    - Applicant Extract SQR Procedures
    - 2019-05-14 Power BI Report Server Univ. of Tennessee
    - Meeting with BlueGranite
  - Staging Jobs
    - Finance (FN)
      - FNSTG001 (FN Staging Job)
        
        FNSTG001
        
        FNS00_dbConnect
        
        FNS00_dbConnect - screenshots
        
        FNS01_Main_Loop
        
        FNS02_UM_GLQ_REPRTING
        
        FNS03_UM_GLQ_ACCTA
  - Talend/git Workflow
    - 2019-09-12 Meeting notes
  - Talend Training
- DARTS Team Tools
  - Onboarding & Information Security Resources
  - DARTS Reports
    - DARTS SQR Reports
      - SQR Usage Report
    - Discoverer Migration Replacement Queries
      - CS Replacement Queries
      - Finance Replacement Queries
      - HR Replacement Queries
    - Power BI Reports Preparation
      - CS New BI Tool Reports
      - Finance New BI Tool Reports
      - HR New BI Tool Reports
  - DARTS Tables, Fields and Logic
    - Dynamic table reference within SQR select
    - Employee Benefits Rate by Account (Fringe Rate)
    - FA Table Research
    - GL Chart of Accounts Field Lengths
    - Issues to be discussed after CS92 upgrade
    - PL/SQL Set Default Schema - add SYSADM.
    - PS_UM_CLASSREV_VW - Class Revenue Table
    - Time Reformat Expressions
    - UM_GLQ_REPRT Table and Views
  - DARTS Documentation
    - How-to Articles
      - CLOB Large Data Fields - Retrieving The Data
      - Creation of Monthly Financial Reports to CIO
      - Daily Extract Maintenance
        
        Check daily extracts status
        
        CSRPT Daily Extract Overview
        
        Jobsets (CSPRD) : Type and Sources
        
        Jobsets (CSRPT) : Type and Sources
        
        Maintaining email address for automated batch process
      - Determining SQR Report Usage
      - ECSI Loan Table Instruction & Documentation
      - ECSI Loan Tax Setoff Instructions
      - HR Census Tables
      - Identifying Source & Query Use Data
        
        Query Usages
      - Migrating SQRs to CSDEV, CSTST, etc.
      - PL/SQL Developer (including Oracle Client install)
      - Query Manager Checklist
      - Retention Cohort Request
      - Using the "US:IT Service Desk" Project in JIRA
      - App Designer
      - Database Access Instructions
    - Datamarts Project Concerns
    - Student Census Documentation
      - Census Reminder
      - Enrollment Reports Folder Checklist & Process
      - Student Census "Bill" Fields
      - Student Enrollment Census "Bill" Fields
      - Power BI Census Report
    - Software Licenses
    - Discoverer
      - Creating a New Updated View in Discoverer
      - Discoverer Installation
      - Discoverer User & Report Inventory
      - Exporting SQL From Discoverer
    - SPSS
      - Organizing Student Tracker (NSC) Results Using SPSS
    - Viscosity
    - Label Index
    - DARTS Inquiries
    - Oracle License Verification Form
  - DARTS Training & Resources
    - Oracle PeopleSoft
      - PeopleSoft Query Administrator
      - PeopleSoft Query Mover
    - Oracle SQR and SQL
    - LISTSERV
    - Power BI Blue Granite Resources
  - Subject Matter Experts Contacts
  - DARTS Photo Gallery
  - Meeting notes
  - Discoverer Migration Project
    - Discoverer Usage Report
  - Finance Data Marts Implementation
  - Power BI Implementation
  - Applicant Data Mart Pilot
  - Applicant Data Mart Implementation
- Sitemap Text
REVIEW Resources for Functional Areas