File Layouts

The following list contains the file layouts as well as sample files for all data import processes currently available in PowerFAIDS that are not controlled by other parties. In addition to these file layouts, data can also be input into PowerFAIDS through the PowerFAIDS API.

Latest version: 1.0

The Anticipated Aid process is used to record pending financial aid (not disbursed) on students’ accounts.

Download File Layout
Download Sample File

For more information including additional detailed sample files, see Anticipated Aid Export File Layout.

Latest version: 1.0

The Disbursement Authorization process is used to disburse financial aid in PowerFAIDS and creates a file of those disbursements for use in other campus systems.

Download File Layout
Download Sample File

Tip: Once you've run your Disbursement Authorization Export process (whether in real mode or simulation mode), a results report is available at the end of the process. The results report provides you with the status of each disbursement and, if applicable, the reason(s) it wasn't successful.

 

Download Sample File - Authorize
Download Sample File - Negate

 

Latest version: 3.0

The Disbursement Reconciliation process is used to import disbursement transactions from the business office back into PowerFAIDS for reconciliation.

Download File Layout
Download Sample File

Caution: When generating a file, be sure to choose the CSV UTF-8 (Comma delimited) (*csv) format and not the generic CSV (Comma delimited) (*csv) format, or you may receive an error message stating that the file is not valid.

Latest version: 3.0

The Fund Import is used to batch import funds from external information systems. This is a helpful way to setup your funds without having to individually create them in PowerFAIDS.

You can use the sample file below and replace the data with your own.

Download File Layout
Download Sample File

Caution: When generating a file, be sure to choose the CSV UTF-8 (Comma delimited) (*csv) format and not the generic CSV (Comma delimited) (*csv) format, or you may receive an error message stating that the file is not valid.

Tip: Once you've imported your funds, the system will display whether each fund was Created or Not Created. If the fund is Not Created, you need to revisit your file and ensure that the file layout is correct. The most common reason a fund is Not Created is because there is an error in the file layout. For example, a fund won't be created if the file is missing a required field, such as 'Disbursable' or 'Display Sequence.'

Latest version: 2.0

The Program Import is used to batch import programs from external information systems. This is a helpful way to setup your programs without having to individually create them in PowerFAIDS.

You can use the sample file below and replace the data with your own, noting that all eleven fields are required for your programs to be imported successfully.

Download File Layout
Download Sample File

Caution: When generating a file, be sure to choose the CSV UTF-8 (Comma delimited) (*csv) format and not the generic CSV (Comma delimited) (*csv) format, or you may receive an error message stating that the file is not valid.

Tip: Once you've imported your programs, the system will display whether each program was Created or Not Created. If the program is Not Created, you need to revisit your file and ensure that the file layout is correct. The most common reason a program is Not Created is because there is an error in the file layout. Specifically, be sure to double check the Department of Education's CIP code for the associated program is input correctly.

Tip: When manually building a program file or opening the program file generated by a reporting tool, Excel will strip away the leading and trailing zeros in CIP codes upon save of Program Import CSV files. If the leading or trailing zeros are removed from the CIP codes, the file will not import to PowerFAIDS and the programs will not be created.

This issue can be resolved in multiple ways:

  • Manually create programs that have CIP codes starting or ending in zeros
  • Open the CSV file in Notepad to manually find and update any CIP codes missing leading or trailing zeros
  • Change the format of the CIP code column to text and save as UTF8 encoded then do NOT open in Excel again

Latest version: 4.0

The Student Information Import can be used in a variety of different ways to update various details on student records from your student information system (SIS).

Download File Layout
Download Sample File

Caution: When generating a file, be sure to choose the CSV UTF-8 (Comma delimited) (*csv) format and not the generic CSV (Comma delimited) (*csv) format, or you may receive an error message stating that the file is not valid.

For more information including additional detailed sample files, see Student Information Import File Layout.