Enterprise Data Management & Analytics

Information Technology Services

Data Collections

Enterprise Data Management and Analytics (EDMA), in partnership with Research and Policy Analysis (RPA), collects, stores, and manages critical data from institutions across the University System of Georgia (USG). This data, organized into four specialized data marts – Academic, Financial Aid, Facilities, and Human Resources – supports state and federal reporting and informs strategic decision-making at all levels. Each data mart has its own collection and follows a designated data submission and reporting schedule determined by data mart sponsors.

  • Academic Data Collection (ADC): This collects student information, including course enrollment, graduation, course and schedule information, and other academic data. The Transfer Course Collection occurs in mid-July during the summer ADC.
  • Financial Aid Data Collection (FADC): This annual collection gathers information on the financial aid students receive, including loans, grants, and scholarships.
  • Facilities Inventory Data Collection (FIDC): This collects information about campus buildings and room inventory.
  • Human Resources Data Collection/Mart (HRDM): This data mart automatically collects institutions' employee information daily from OneUSG Connect.

The Data Collection Process

Step 1: Initial Data Extraction

Institutions use extraction processes to pull relevant data from their source systems.

  • The Academic and Facilities Data Collections require institutions to run the Data Collection Extraction process (ZADMETL) in Banner before extraction.
  • Institutions extract ADC, FADC, and FIDC data through the Data Collection Application (APEX).
  • HRDM data is automatically extracted through OneUSG Connect (PeopleSoft HCM) and loaded daily. 

Step 2: Submission and Initial Validation

The extracted data is reviewed and validated through multiple Cognos reports. 

  • Institutions validate the data in Cognos by reviewing Submission Review reports (ADC), Data Collection Review reports (FADC & FIDC), and Data Validation Reports (HRDM).
  • Error reports are available to review all reported known issues and institutional errors.
  • The errors must be corrected and cleared in the source system before re-extraction.
  • If errors cannot be corrected, institutions can submit an Error Relief Request through the Data Collection Application (APEX).

Step 3: Final Extraction & Submission

Institutions extract and submit the clean data to USG for processing, storage, and reporting.

  • After errors are fixed or approved for Error Relief, institutions must re-run the extraction process.
  • Institutions must recheck Cognos reports to confirm all corrections were applied correctly, and no errors remain.
  • The final step in the submission process is submitting the Data Collection Certification Form, which confirms data accuracy and completeness for official reporting through RPA.