Before You Begin

Before you begin setting up File Parser to load your external prospect or admissions data, there are a few things that might be helpful to do. You may want to consider doing this with a spreadsheet or data modeling tool:

• Review the external data to determine which staging records and fields will be populated. Utilize the Entity Registry feature to get a clear understanding of the staging table hierarchy.

• Document each record to be populated, the fields within each record that will come from the external data, and which fields need to be populated with default values. Utilize the AAWS Data Mapping and Entity Catalog document or the Entity Registry component’s Entity Properties page to view each of the staging records and their associated fields.

• Determine which incoming fields will need to be converted to internal values.

• Document the non-required incoming data elements so you know which records need to have the Skip if Blank check box selected for the mapped data element.

• Determine which fields require developing a calculated field. Examples include: Recruiting Center, External Organization ID and Degree Description.