Financial Aid Import from PowerFAIDS

Awards packaged in the PowerFAIDS application can be exported to a file which will be saved on the network in the CAMS Enterprise >Import folder and then imported into CAMS so that pending financial aid can be represented on pre-billing statements.

In order to import awards from PowerFAIDS, minimal setup must first be completed in the CAMS Manager and Financial Aid modules. Click here to view Minimal Setup in CAMS for PowerFAIDs Award Import.

To import PowerFAIDS awards:

From CAMS Enterprise Home page, click Tools >Import >Financial Aid >PowerFAIDS. The PowerFaids Import form opens.
Click Browse to open the Choose File to Upload window.

Note: The import file must be located on a share and you must browse through Network Places, even if the file is on the local machine, to the file so that a Universal Naming Convention (UNC) path is listed in the File field. Example: \\MyComputer\MyFolder. It cannot use a drive:\filename format such as C:\importfile.txt

Select the appropriate file and then click Open.
Click Initiate. CAMS compares the social security numbers, fund codes (assigned to awards in Financial Aid >Setup >Award Reference), and POE Token (assigned to terms in CAMS Manager >Lookup Table Options >Table Maintenance >Reference tab >Term Calendar Lookup Table) of the student records being imported to records in the CAMS database. The list of records appears.
The top data grid of the window displays awards that have matched all the criteria listed in item 4 above and can be imported into CAMS Enterprise. The bottom section of the window displays an exception list of awards that have not met all the criteria and will not be imported.
In the top data grid, scroll all the way to the right to view the following fields:

PowerfaidsAmount field lists the amount that PowerFaids is awarding.
CAMSTotal field is the total amount already existing in CAMS Enterprise for this term.
AmountToImport field is the amount CAMS Enterprise will import as a separate transaction.

The Print button below the data grid will display an exception report, which can be used to analyze those awards that do not import.

Note: If an award is imported a subsequent time with a different amount CAMS Enterprise will create an additional transaction with an adjustment amount for the award. Example: If the award was originally $500 and subsequently it is now importing as $600, a $100 adjustment transaction will appear for the term. CAMS will NOT import awards more than once if the award amount has not changed.

Click the Import tab. The Import Awards form displays.
Select the Academic Year and Financial Aid Year for the imported awards. This determines the Origination Fee Percent and Interest Rebate Percent for DLSUB, DLUNSUB, and DLPLUS COD Award Types as set in Financial Aid >Setup >Award Reference.
Select Yes to Show Awards on Billing Statement (Pending AID). This value overwrites the designation in Financial Aid >Setup >Award Reference table. For example, if No is selected here, then all awards imported in this process will NOT show on a billing statement, even if the designation in the award reference table is set to Yes.
Select whether the Award Status Determination is Manual or whether it will be Determined by Awards Reference table. If the Manual option is selected then values for the Award Status, Credit Status, Code 1 and Code 2 fields can be determined here. If Determined by Awards Reference table is selected, then the values for the Award Status, Credit Status, Code 1 and Code 2 fields will be set based on the default values in those fields for each award in the Award Reference table.
Select the appropriate value for the Update Awards Flags (statuses/showonstatement) On field. This determines which award status values will be updated based on the Award Status Determination if Manual is selected. Available values are as follows:

All Awards Even awards for which no amount will be imported will have statuses changed based on these selections.
Inserts/Updates Only new awards and awards which will have an adjusting amount imported will have statuses defined or changed based on these selections.
Inserts Only Only NEW awards will have statuses defined based on these selections. Existing awards for which adjusting amounts will be imported will retain the statuses defined during the original import.

Click Import. CAMS imports new awards and adjusting amounts on existing awards according to the specifications defined for the import process.
For COD awards, the Origination Fee Amount and Interest Rebate Amount will be calculated based on the amounts entered in Award Reference for the selected Academic year. A Financial Aid Status record will be created and linked to any new awards imported based on the set up in Financial Aid >Setup >Yearly Setup for the Academic Year and Financial Aid Year selected.
During re-import, if a different Academic Year and/or Financial Aid Year is selected other than what was selected during the original import a pop-up displays indicating this.
Click Yes to import any new awards using the Academic Year/Financial Aid Year selected and update any previously imported awards without changing their Academic Year/Financial Aid Year. Click No to cancel the import then select a different Academic Year/Financial Aid Year.

Note: If an award is deleted in PowerFaids CAMS Enterprise will not automatically delete the award. It must be manually deleted from CAMS Enterprise.