For Financial Aid - Revision history

WikiSysop at 15:52, 8 March 2016

2016-03-08T15:52:47Z

2016-03-07T23:11:07Z

‎Enabling Applications

2016-03-07T20:49:05Z

‎Need Workbook

2016-03-07T20:45:09Z

‎Financial Aid items

2016-03-07T20:16:43Z

‎Consolidated PDFs

2016-03-07T20:06:24Z

‎Print/File and Move

2016-03-07T20:05:31Z

‎EAS Financial Aid Need Importing

2016-03-07T19:30:44Z

‎EAS Financial Aid Receiving

2016-03-07T16:41:12Z

2016-03-07T16:36:56Z

New page: -- EAS Financial Aid Setup -- -- EAS Financial Aid Processing --

New page

-- EAS Financial Aid Setup --

-- EAS Financial Aid Processing --

← Older revision		Revision as of 15:52, 8 March 2016
Line 37:		Line 37:

	Assessment form contains all the formulas. Should there be a calculation required the change should be made in the first data column and copied across.		Assessment form contains all the formulas. Should there be a calculation required the change should be made in the first data column and copied across.
		+
		+	== Clearing Old Applications ==
		+
		+	This is best done in a database tool (Data Architect) and requires zapping two tables. FAPPLICS.DBF (FAPPLICS.NTX) holds the application data except for selected aid items and statements. FAPPITEM.DBF (FAPPITEM.NTX) holds the selected items.
		+
		+	FAPPNOTE.DBF (FAPPNOTE.NTX) holds the various statements submitted by applicants. This could be zapped as well, but if it is left intact, students can reuse prior year statements.

	== Enabling Applications ==		== Enabling Applications ==

← Older revision		Revision as of 23:11, 7 March 2016
Line 39:		Line 39:

	== Enabling Applications ==		== Enabling Applications ==
		+
		+	EAS Applications, Release Editing, change the following to the appropriate values:
		+
		+	FINAID.REL -- two CrossRoad standard date in a tilde delimited list as the start and end of the application period. 01/02/2016~31/03/2016~
		+	FINAPPNM.REL - The name for the financial aid application.
		+	FINSTMT.REL - a pipe (\|) and tilde delimited lists of possible statements. The left of the pipe is the field name; the right is the html description.
		+	FINTAB.REL - a list of the Tabs and icons associated with the tabs of the financial aid application.
		+
		+	CHECKLST.REL - FIN2016/17~
		+	StuMenu.rel - FIN2016/17~
		+
		+	EAS Applications, HTML Editing, update the following to the appropriate values:
		+	FinApp.htm - Financial aid application head note.
		+	FinDecl.htm - Declaration for the financial aid application.
		+	FinExp.htm - note explaining our use of PoA values in our calculations.

	= EAS Financial Aid Receiving =		= EAS Financial Aid Receiving =

← Older revision		Revision as of 20:49, 7 March 2016
Line 22:		Line 22:

	== Need Workbook ==		== Need Workbook ==
		+
		+	These are kept in u:\crossroad\needform and have the year inserted in the name.
		+
		+	The last two tabs are data exchange tabs. Data should have all but the extra row numbers blanked out.
		+
		+	The following tabs need to have updated values added each year:
		+
		+	Tuition, Fees, Books
		+	Moderate Standard of Living
		+	Minimum Student Contributions
		+	Childcare
		+	Return Transportation
		+	Allowable Monthly Costs
		+
		+	Assessment form contains all the formulas. Should there be a calculation required the change should be made in the first data column and copied across.

	== Enabling Applications ==		== Enabling Applications ==

← Older revision		Revision as of 20:45, 7 March 2016
Line 2:		Line 2:

	== Financial Aid items ==		== Financial Aid items ==
		+
		+	EAS Applications, Web Aid editing is how these are modified.
		+
		+	The type and typesequen fields are used to order the presentation of the items.
		+
		+	The title and descript fields are usually abbreviated versions of what appears in the Calendar.
		+
		+	Criteria are derived from the Calendar entry.
		+
		+	Requires is intended to indicate the additional materials or statements needed for the item.
		+
		+	Finaidid is the link to the CrossRoad item. This means that all the items must exist in CrossRoad prior to being added in Web Aid.
		+
		+	FORMFIELD is a name for the html field. These must be unique.
		+
		+	SUBFIELDOF and PARENTOF is allows the specification of parent and child awards; currently King's has none of these.
		+
		+	Requirefld specifies fields that must be present when this award is selected. Most common are statements (OTHER:nameofstatement), financial information (FININFO:NONEED!~FININFO:SAVINGS). Note that these are preceded by the section of the application, are in a tilde delimited list, and a ! means that it absent.

	== Need Workbook ==		== Need Workbook ==

← Older revision		Revision as of 20:16, 7 March 2016
Line 32:		Line 32:

	= Consolidated PDFs =		= Consolidated PDFs =
		+
		+	The copies of the applications for consolidation can be merged into a single pdf (using a PDF merge tool). The arrangement of these should be in a useable order.
		+
		+	Alternatively, it would also be possible to place these documents into a SharePoint folder for use during meetings. I suggest a separate library so that searching can be isolated to that library.

← Older revision		Revision as of 20:06, 7 March 2016
Line 16:		Line 16:

	The applications are next to be printed and moved. The printing is to a PDF; the move is taking the data from the application and moving it into CrossRoad. In that process the financial need file is exported.		The applications are next to be printed and moved. The printing is to a PDF; the move is taking the data from the application and moving it into CrossRoad. In that process the financial need file is exported.
		+
		+	The resulting PDFs should be a) copied to a temporary folder for consolidation and b) filed in CrossRoad.

	== Import to Need Workbook ==		== Import to Need Workbook ==

← Older revision		Revision as of 20:05, 7 March 2016
Line 24:		Line 24:

	= EAS Financial Aid Need Importing =		= EAS Financial Aid Need Importing =
		+
		+	The Financial Need Workbook calculates the need values for each student. This needs to be audited for errors (such as incorrect province codes, or non-numeric in numeric fields).
		+
		+	Once these are fixed, then the data on the NeedToCr tab needs to be sent to a CSV file. That file is imported into the need2cr.dbf (need2cr.ntx) table. That table then needs to have its values overwrite those in scholars.dbf.

	= Consolidated PDFs =		= Consolidated PDFs =

@@ Line 8: / Line 8: @@
 = EAS Financial Aid Receiving =
 == Print/File and Move ==
 == Import to Need Workbook ==
 = EAS Financial Aid Need Importing =
 = Consolidated PDFs =

← Older revision		Revision as of 16:41, 7 March 2016
Line 1:		Line 1:
−	-- EAS Financial Aid Setup --	+	= EAS Financial Aid Setup =

−	-- EAS Financial Aid ~~Processing --~~	+	== Financial Aid items ==
		+
		+	== Need Workbook ==
		+
		+	== Enabling Applications ==
		+
		+	= EAS Financial Aid Receiving =
		+
		+	== Print/File and Move ==
		+
		+	== Import to Need Workbook ==
		+
		+	= EAS Financial Aid Need Importing =
		+
		+	= Consolidated PDFs =