Application Data Import

Use the Application Data Import process to import ISIRs and Error Response Files. The Application Data Import process automatically matches records in the import files to records in the database.

ISIR matching uses the following criteria:

  1. The school code must be listed on the student's FAFSA/ISIR.

  2. The ISIR is matched based on the student's SSN and Name.

After ISIRs have been imported into the system, the ISIR Matching process is available to manually change any automatically matched ISIR records after the Application Data Import process.

Anthology Student also supports the automated import of ISIRs and Error Report files. Based on schedules defined by users, the import service finds available import files in the EDE path and passes them to the Application Data Import process.

  • On the Process tab, specify the data selection criteria and manually queue an import job. The queued job will run in the background.

    The Process tab is not used when the import process is automated via schedules.

  • On the History tab, review the results of manually queued jobs and scheduled jobs. You can also view details about the records within the batch and access the student profiles.

  • On the Schedule tab, create, edit, activate, deactivate, delete schedules, and specify import options (selection criteria). You can also view detailed information on the last 5 runs of a scheduled import process and manually trigger an import process.

To view the process report, go to Regulatory Process Results. Find the batch and inspect the records included in the batch.

Financial Aid Processes File Management

Use Processes > System Administration > Financial Aid Processes File Management to upload and download files in Azure File Storage. This functionality allows you to place files where financial aid processes, such as Application Data Import/Export, Clearinghouse, and NSLDS Reports, expect them. Refer to Financial Aid Processes File Management.

Prerequisites

Authorizations:

  • Common - Processes - View

  • Financial Aid - Processes - Application Data Import - Import Student ISIRs

You should also be familiar with Background for Application Data Import.

Configure campus-level security for Application Data Import so users see only records for their assigned campus on the History tab:

  1. In Settings > System > Campuses > Campus Groups, create or select a Campus Group containing only the campus that the user can access.

  2. In Settings > System > Staff, select the staff member and assign that Campus Group on the General tile.

Access

Processes > Financial Aid > Application Data Import

Import Application Data

Process Tab

Use the Process tab to specify the selection criteria for manually queued import jobs. For automated imports, use the Schedule tab to specify the import options.

  1. Select an Award Year or accept the session default.

  2. Select a File Type.

    • Select ISIRs (default) to import any ISIR file type (e.g., IDAPxxOP, IDNRxxOP, IDRExxOP, IDSAxxOP, IGCOxxOP, IGNRxxOP, IGRExxOP, IGSAxxOP, IGSGxxOP, and ISRFxxOP; where xx represents the award year)

    • Select Error Report File to import files sent from the FPS to inform the institution that ISIR corrections submitted by the institution are not accepted. An error report file may indicate that an entire batch was rejected or any detail records were rejected.

    Refer to Export and Import File Types.

  3. When importing ISIR files, select Yes (default) or No in the Update Now drop-down list.

    Importing ISIRs involves two phases. In the first phase, the ISIR records are inserted into the Anthology Student database. In the second phase, the ISIR data is matched and student records are updated.

    • Select Yes if you want both phases of the ISIR import to be executed immediately.

    • Select No if you want the second phase to run as a background process using a Windows service that runs during school-defined off-hours, typically at night.

  4. For award years 2023-24 and earlier, the EDE path for the user's default campus is displayed in the Campus EDE Path (TG)Closed The introduction of the FTI-SAIG Mailbox and FT Numbers for 2024-25 and later required a new Application Data EDE Path (FT) to import ISIR files. The system uses the Campus EDE Path (TG) for all award years for the import/export of COD files, export of correction files, etc.

    For award years 2024-25 and later, the EDE path for the user's default campus is displayed in the Application Data EDE Path (FT)Closed The introduction of the FTI-SAIG Mailbox and FT Numbers for 2024-25 and later required a new Application Data EDE Path (FT) to import ISIR files. The system uses the Campus EDE Path (TG) for all award years for the import/export of COD files, export of correction files, etc.

  5. Select the search icon (Search icon) in the Selected File field and select the files you want to import.

    The available files list shows only ISIR files even though the EDE path may contain other files. When multiple ISIR files are available, you can select and process multiple files.

    Do not alter the file names of the ISIR files to be imported; otherwise Anthology Student may not recognize the files as ISIRs.

  6. Select Queue Import.

    The Submit Batch window displays the default Batch Name. You can edit the Batch Name.

  7. Select Submit in the Submit Batch window.

    This starts the background job to process the data and create batches from the selection criteria. For each file to import, one job is created.

    The selected file is read from the local Campus EDE path and copied to the System EDE Path.

  8. When the job is submitted successfully, the following message is displayed: “The Application Data Import records were successfully queued.

    The processed import files are renamed to BK.

    Example: IDAP18OP.001 will be renamed to IDAP18BK.001.

    The extension of the import file (e.g., 001) indicates the transaction sequence number.

    Tip: Use Notepad++ to view the raw text files.

  9. When the job is completed, a notification appears in the command bar. The number of failed jobs will be indicated in red (Notification).

History Tab

The History tab displays the results of manually queued jobs and scheduled jobs.

When Enable Campus Level Security On BatchesClosed Select "Yes" if you want Anthology Student to enable campus-level security for batches based on the logged-in user’s permissions for the session default campus. The user will only be able to access batches created for campuses that they can access. If a batch has been created for multiple campuses and the user cannot access at least one of the campuses, the batch will NOT be visible to the user. If you select "No," the logged-in user can view batches from multiple campuses, even if they do not have permission to access the batch details for some students. This setting is enabled by default. A script ensures that batches on the History tab that were created before the implementation of the campus-level security are also filtered based on the new campus-level security. is turned on in Settings > System > General, the records on the History tab will be filtered based on the logged-in user and the campus groups associated with the user. Record filtering is based on the SyCampusId. Records with a NULL value in the CampusID field will be visible to all users. CampusID = NULL is assigned to records that are not in Succeeded status (e.g., Completed, Enqueued).

A clean-up script ensures that batches are also filtered if they were created before the implementation of the campus-level security feature. The script runs at the batch level per process and assigns SyCampusId values to the records in the batch.

A clean-up script ensures that batches on the History tab that were created before the implementation of the campus-level security feature are also filtered based on the new campus-level security. The script runs at the batch level per process and assigns SyCampusId values to the records in the batch.

For the Application Data Import process, the clean-up script updates student records with a valid ISIR based on the student’s latest active enrollment campus. When a student has multiple enrollments, the script updates the CampusID to the latest enrollment campus even if the student record was originally imported for a different campus.

For Application Data Exports, the clean-up script retains the Campus Name of the original record.

Unmatched student records, failed batches, and error reports for ISIR imports are visible to all users, including users with limited campus access. For users with limited access, the record numbers in the batches grid (top) and details grid (bottom) may not always match.

If the feature is turned off, the History tab will load the records based on the default campus setting (Session Defaults).

Schedule Tab

Use this tab to create, edit, activate, deactivate, delete schedules, and specify import options (i.e., selection criteria). You can also view detailed information on the last 5 runs of a scheduled import process and manually trigger the execution of an import process.

  1. Review the grid listing the previously created schedules for the Application Data import.

    ActiveClosed Specifies whether the associated record is active.

    FrequencyClosed Indicates the frequency with which the schedule is run. Selecting from Daily, Specific Date, or Monthly will update the frequency details to be defined.

    Last RunClosed Indicates the last time when the job/schedule was executed by the background processing system.

    NameClosed The name of the item (e.g., data set, batch, job, process, task, person, organization, entity, file).

    Next RunClosed Indicates the time when the job will be executed next (based on the schedule).

  2. To remove a schedule, select the schedule and select Delete.

  3. To activate an inactive schedule, select the schedule and select Activate.

  4. To prevent an active schedule from running, select the schedule and select Deactivate.

  5. To trigger a scheduled import process to run immediately, select an active schedule and select Run Now.

  6. To view details of a previously scheduled job, select the expand icon () in the left column. The following details are displayed:

    CompletedClosed The date when the item was completed.

    Job TriggeredClosed The date and time when the first job within the batch started executing.

    ResultClosed Indicates the processing result for the job. If it was successfully processed, it displays Passed or Succeeded. Otherwise, it displays the reason why it was not processed.

    StatusClosed The status of the job. Enqueued indicates the job is in the queue waiting to be executed. Scheduled indicates the job is scheduled to run at a future time. Processing indicates the job is running. Succeeded indicates the job was completed with no errors. Deleted indicates the job was completed with errors.

  7. To edit a schedule, select the link in the Name column. The Edit Schedule - <Name> form is displayed below the grid.

  8. To create a schedule, select New in the grid toolbar. The New Schedule form is displayed below the grid.

  9. Specify or edit the following Schedule properties:

    ActiveClosed Specifies whether the associated record is active.

    DaysClosed The days of the week. For example, days for which the class is scheduled.

    End DateClosed The last date the item is effective or can be used. Depending on the context of the associated record, the end date can also be the end of a time range, session, or activity (e.g., job, program, course, term, payment period, academic year, enrollment).

    FrequencyClosed Indicates the frequency with which the schedule is run. Selecting from Daily, Specific Date, or Monthly will update the frequency details to be defined.

    NameClosed The name of the item (e.g., data set, batch, job, process, task, person, organization, entity, file).

    Notify StaffClosed Indicates staff members are notified when the batch schedule is run.

    MonthlyClosed The schedule is run every month.

    RecurrenceClosed Select the recurrence pattern of the schedule, either "Occurs every" (Hour) or "Occurs once at" (H:MM:TT).

    Time (H:MM TT)Closed Indicates the time when the scheduled batch is executed. This field is visible when the Recurrence is set to the "Occurs once at" option.

    Specific DateClosed Month/Day/Year or Year-Month-Day

    Start DateClosed The first day the item takes effect or becomes active. Depending on the context of the associated record, the start date can also be the start of a time range, session, or activity (e.g., job, program, course, term, payment period, academic year, enrollment).

    Time ZoneClosed A region that observes a uniform standard time for legal, commercial, and social purposes.

    Application Data Import Options

    Award YearClosed The financial aid award year associated with the record.

    CampusClosed The campus or campuses to which a person or item is assigned. It is filtered to display the campuses to which you have access. In some cases, it is also used to filter a list to only those items for the campus. In some lists, you can select more than one campus or select All. In lists that display columns, if the column contains more than one campus, you cannot sort or filter on that column.

    Campus EDE PathClosed The UNC-compliant file path used for file transfers between Anthology Student and the FPS system. The Campus EDE path is used for campus-specific file transfers. or Application Data EDE Path (FT)Closed The introduction of the FTI-SAIG Mailbox and FT Numbers for 2024-25 and later required a new Application Data EDE Path (FT) to import ISIR files. The system uses the Campus EDE Path (TG) for all award years for the import/export of COD files, export of correction files, etc.

    Created ByClosed The last and first name of the staff member or process that added or created the item.

    File TypeClosed Indicates the imported file type (ISIR or Error Report File).

    Update NowClosed Indicates whether the Update Now option was selected for the ISIR Import.

    The introduction of the FTI-SAIG Mailbox and FT Numbers for 2024-25 and later required a new Campus EDE path in Anthology Student to import ISIR files. The system now provides separate directory paths.

    • Import/Export of COD files, export of correction files, etc., for all award years will continue to use the Campus EDE (TG folder)

    • Import of ISIR Files for award years 2024-25 and later will use the Application Data EDE Path (FT folder)

  10. Save your changes.

  11. To close the New Schedule or Edit Schedule form, select Cancel.

 

This feature applies to U.S. compliance only.