9.2 Importing SAS Files

Purpose:  To upload and import SAS files in ctcLink.

Audience:  Financial Aid staff.

Below is a description of the File Mappings available to better understand the functionality of the Import SAS File Page and the reports that are being uploaded.  

  • Pell SAS Import: A monthly statement, similar to a bank statement, which summarizes your school's processing activity for that month and/or Year-to-Date (YTD). This statement can be used as a reconciliation tool to compare to both your financial aid and business office records.
  • Pell SAS On Demand Import: An on-demand report retrieved from requests made through the Reports Request page on the COD Website. The report is limited to the Disbursement Level Detail Section.

Importing School Account Statement Files

Upload File

Navigation:  NavBar > Navigator > PeopleTools > CTC Custom > Extensions > Upload/Download Files

  1. The File Upload/Download search page displays.
  2. Enter the Academic Institution.
  3. Enter the Functional Area.
  4. Enter the Business Process Name.
  5. Select the Search button.
File Upload/Download search
  1. The Upload Files tab displays.
  2. Upload the PGSMxxOP.xxx files.
  3. Using the Pell 20xx file path, select the Upload File button.  
Upload Files tab
  1. The File Attachment pagelet displays.
  2. Choose desired file from computer by selecting the Browse button.  
  3. Once the file is loaded, select the Upload button.
File attachment browse pagelet
  1. The process to upload the SAS file is now complete.
  2. The next step will import the uploaded file.

Import SAS Files Page

Navigation:  NavBar > Navigator > Financial Aid > Pell Payment > Cash Management Reports > SAS Reports > Import SAS Files

 

  1. The Import SAS Files search page displays.
  2. Enter a new or existing Run Control ID.
  3. Select the Add or Search button.  
Import SAS Files run control search
  1. The Import SAS Files page displays.
  2. Choose PELL SAS IMPORT for the Pell SAS file from the File Mapping ID field.
  3. In the File Path List section:
    • Enter the File Path and Name used during the Upload/Download process from prior section.
    • If uploading multiple files insert a new row and enter the file path and name for the next file.
  4. Select the Run button.  
Import SAS Files run page
  1. The Process Scheduler Request page displays.
  2. Select the Import SAS Files box.
  3. Select the OK button.  
  4. The Import SAS Files page displays.
  5. Note the Process Instance number for reference.
  6. Select the Process Monitor link.  
  7. The Process List tab displays.
  8. Select the Refresh button until the identified process runs to Success and Posted.
  9. The process to import a School Account Statement file is now complete.
  10. End of procedure.

0 Comments

Add your comment

E-Mail me when someone replies to this comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.