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.

You must have at least one of these local college managed security roles:

  • ZD FA Director
  • ZD FA FISAP Prcs
  • ZZ FA Aid Year Activation
  • ZZ FA Award Processor
  • ZZ FA CTC Reports
  • ZZ FA College Bound Schlrship
  • ZZ FA Direct Loan Processor
  • ZZ FA Funds Manager
  • ZZ FA ISIR Corrections
  • ZZ FA ISIR Processor
  • ZZ FA NSLDS Prcs
  • ZZ FA Pell Processor
  • ZZ FA SAP Prcs
  • ZZ FA Verification Prcs
  • ZZ FA WCG Eligibility
  • ZZ SF Collections
  • ZZ Upload Doc ADM
  • ZZ Upload Doc ADV
  • ZZ Upload Doc SR

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Importing School Account Statement Files

Upload File

Navigation:  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.
  6. The Upload Files tab displays.
  7. Upload the PGSMxxOP.xxx files.
  8. Using the Pell 20xx file path, select the Upload File button.
  9. The File Attachment pagelet displays.
  10. Choose desired file from computer by selecting the Browse button.  
  11. Once the file is loaded, select the Upload button.
  12. The process to upload the SAS file is now complete.
  13. The next step will import the uploaded file.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

View Tutorial Via Panopto

View the external link to Importing SAS Files - Upload File. This link will open in a new tab/window.

Import SAS Files Page

You must have at least one of these local college managed security roles:

  • ZD FA Pell Cash Mgmt
  • ZZ FA Pell Cash Mgmt
  • ZZ FA Pell Processor

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Navigation:  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.  
  4. The Import SAS Files page displays.
  5. Choose PELL SAS IMPORT for the Pell SAS file from the File Mapping ID field.
  6. In the File Path List section:
  7. Enter the File Path and Name used during the Upload/Download process from prior section.
  8. If uploading multiple files insert a new row and enter the file path and name for the next file.
  9. Select the Run button.  
  10. The Process Scheduler Request page displays.
  11. Select the Import SAS Files box.
  12. Select the OK button.  
  13. The Import SAS Files page displays.
  14. Note the Process Instance number for reference.
  15. Select the Process Monitor link.  
  16. The Process List tab displays.
  17. Select the Refresh button until the identified process runs to Success and Posted.
  18. The process to import a School Account Statement file is now complete.
  19. End of procedure.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

View Tutorial Via Panopto

View the external link to Importing SAS Files Page.  This link will open in a new tab/window.

0 Comments

Add your comment

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