College Fair Automation (CFA)

Delivered Transaction Code: SAD_CFA

Modify the delivered transaction as follows:

  • Update the data update rule with one defined by your institution based on your constituent data update policies.

  • Search/Match Setup: Update the search parameter, search result codes and update rules based on your institution’s needs.

File Parser Field Conversion Definition Template: SAD_CFA

Conversion examples have been delivered for the following fields:

  • Academic Plan based on incoming AcademicInterestCD1 values.

  • Academic Program based on incoming AcademicInterestCD1 values.

  • Citizenship Status based on incoming Citizenship values.

  • Ethnicity based on incoming Ethnicity values.

  • Admit Type based on incoming FreshmanTransfer values.

  • Admit Term based on incoming StartingTerm values.

Each of these conversions will need to be modified based upon your internal values. Either create a new field conversion definition or copy the delivered definition and modify as needed.

Context Definition Template: SAD_CFA

Review the delivered template and determine if any records need to be added. Modify this delivered version. It will be used on the File Mapping Definition component. Create a copy before doing so to keep an original version. If you choose to use a copy of a delivered context definition and reference the copied version in your file mapping definition, the system forces you to redefine the file layout and file mapping setup.

File Mapping Definition Template: SAD_CFA_PROSPECTS

This file mapping definition can be used to create prospects and populate supporting data such as academic interests and extracurricular activities. You will need to make changes to this delivered template to reflect institution defined default values. Before doing so, make a copy of the delivered template.

File Definition Tab:

Important:

Leave the context definition as SAD_CFA. If you change this, all the file layout and mapping setup will disappear.

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Depending upon which college fair (NACAC, Regional, and so on) you are loading data for, the file layout may differ from the layout defined. Review this tab to ensure the fields appear in the exact order as that of the CFA layout you are using. Modify default values on the Date Day and Date Month columns for the field HSGradYear.

Mapping Tab:

The default values for the following fields will need to be reviewed and probably modified depending upon your institution’s business practices:

  • SCC_STG_NAMES.NAME_TYPE

  • SCC_STG_ADDR.ADDRESS_TYPE

  • SCC_STG_EMAIL.E_ADDR_TYPE

  • SCC_STG_PHONE.PHONE TYPE – Two rows

  • SCC_STG_EXTRACU.INSTITUTION – Twelve rows

  • SCC_STG_STD_CAR.ACAD_CAREER

  • SAD_PRS_CAR_STG.ACAD_CAREER

  • SAD_PRS_CAR_STG.INSTITUTION

  • SAD_PRS_CAR_STG.RECRUITING_STATUS

  • SAD_PRS_CAR_STG.ADM_REFRL_SRCE

  • SAD_PRS_PRG_STG.RECRUITING_STATUS

  • SAD_STG_PRS_CAF.ACAD_CAREER – Seven rows

  • SAD_STG_PRS_CAF.INSTITUTION – Seven rows

  • SCC_STG_ADMIHD.ACAD_CAREER

  • SCC_STG_ADMINT.ACAD_CAREER – Three rows

Calculated Fields: The following calculated fields have been delivered for CFA:

  • SCC_STG_NAMES.LAST_NAME_SRCH - Removes all special characters and puts the field into upper case.

  • SCC_STG_NAMES.FIRST_NAME_SRCH - Removes all special characters and puts the field into upper case.

  • SAD_PRS_CAR_STG.ADM_RECR_CTR - Looks at the prospect setup you have defined to determine recruiting center. If you don’t set up the Prospect Setup page, you will need to change this to a default recruiting center.

  • SAD_PRS_CAR_STG. LAST_SCH_ATTEND - Uses the incoming value from CEEBCode to determine the EXT_ORG_ID to populate based on the EXT_ORG_TBL_ADM.ATP_CODE.

  • SAD_PRS_PRG_STG.ADM_RECR_CTR - Looks at the prospect setup you have defined to determine recruiting center. If you don’t set up the Prospect Setup page, you will need to change this to a default recruiting center.

  • SCC_STG_ACADHST.EXT_ORG_ID - Uses the incoming value from CEEBCode to determine the EXT_ORG_ID to populate based on the EXT_ORG_TBL_ADM.ATP_CODE.

Common Attribute Framework:

The following sample common attributes have been delivered for the incoming field indicated:

  • CFA_CLASSRANK for ClassRank

  • CFA_PARENTSCOLLEGE for ParentSiblingCollege

  • CFA_PARENTSGRAD for ParentsGrad

  • CFA_SCHLINOUTSTPREF for SchoolInOutOfState

  • CFA_SCHLSETTINGPREF for SchoolSetting

  • CFA_SCHLSIZEPREF for SchoolSize

  • CFA_TEXTOK for TextOK

Set up additional common attributes for other fields that have not been mapped on the File Mapping Definition component. In addition to creating the common attribute and adding them to the record context for ADM_PRSPCT_CAR, you will need to add rows for each common attribute on the File Mapping Definition component. Additional fields that were not mapped include:

  • Religion

  • TransferFrom

  • LastCompletedSemester

  • SocialMediaLink

  • CanMessage

  • DrivingTime

  • RateSchoolSetting

  • RateSchoolInOutOfState

  • RateSchoolSize

  • RateSDrivingTime