Open topic with navigation

Export to PowerFAIDS

CAMS Enterprise can export selected student data into a file that is compatible with PowerFAIDS™ importing.  The exported text file is designed to PowerFAIDS External Update Flat File Format (Rev 8.2).  Unit4 Education Solutions, Inc. cannot detail the steps for importing the text file into PowerFAIDS™.  Refer to the PowerFAIDS™ documentation.

Export PowerFAID Student Data

  1. From the CAMS Enterprise Home page, click Tools >Export >Financial Aid >PowerFAIDS.  The Export To PowerFAIDS window opens.
  2. Enter the Export Term.  The student must have a Status record for this term.
  3. Select to export either the Student SSN or the Student ID.
  4. Select the Type of student.  If Returning is selected then the SAT and ACT fields do not display or export.  If New is selected then you must enter the SAT and ACT data.
  5. If necessary, select Graduate GPA Groups and Address type to export.
  6. If New has been selected, select the SAT Test and the Verbal and Math fields to be used.  Select the ACT Test and the Composite field to be used.

Note: If more than one SAT or ACT test is entered for the student the highest score will be used.  Students that do not have these tests will not be exported.

  1. Click Initiate. Records that meet the selected criteria display.
  1. Columns not necessary can be deleted using the Blank out column list.  Select one or more columns to delete and click Initiate.
  2. Click the Export tab and click Export to create the export text file.
  3. Click OK.

Powerfaids.txt

CAMS Enterprise exports the following fields to PowerFaids.txt:

  

Data Element Description

Mnemonic

Start Position

Student SSN

SSNO

1

Student ID

ID-ALT

10

Last Name

NAME-L

20

First Name

NAME-F

36

Middle Initial

NAME-M

47

Address 1

STREET-P1

48

Address 2

STREET-P2

78

City

CITY-P

108

State

STATE-P

125

Country

P-COUNTRY

127

Zip

ZIP-P

142

Housing *

F-HOUSING

334

Admissions Status **

ADMSTAT

341

High School GPA

GPA-HS

346

College GPA

GPA-COL

349

SAT Verbal

SAT-V

352

SAT Math

SAT-M

354

ACT Composite

ACT-COMP

356

Transfer Student ***

TRANSFER

377

Degree ****

USER DEFINED

1443

CUM Attempt Hours

USER DEFINED

1509

CUM Earned Hours

USER DEFINED

1597

Major

USER DEFINED

1641


* Housing is set to “1” if the student has a housing record for the selected term and “2” if they do not.

** Admission Status is determined from the student’s Applicant Status field on their admission’s record and what is defined for that item in the Prospect/Applicant Status reference table UserDefined column.

*** Transfer Student is set to “Y”es if a student has at least one transfer class in their record.

**** Uses Large String 3 and displays the first five characters of the student’s degree.

Note: Use WordPad to display PowerFAIDS.txt, as Notepad truncates the blank fields.