Advanced Placement (AP)

Delivered Transaction Code: SAD_AP

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_AP

Conversion examples have been delivered for the following fields:

  • Academic Level based on incoming Educational Level value; used to populate the academic level for each test component.

  • Admit Term based on incoming Expected College Entrance value.

  • Canadian (CAN) Provinces based on incoming Country Code value.

  • Country based on incoming Country Code value.

  • Ethnicity based on incoming Ethnic Group value.

  • Exam Code based on incoming Exam Code; used to populate test component.

  • Gender based on incoming Sex value.

Each of these conversions may 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.

Note:

Not all Country Codes have been mapped. Add rows as needed for the following incoming country values: 348 - Macedonia, The Former Yugoslav Republic of; 377 - Midway Islands; 550 - Tahiti; 625 - Montenegro or Serbia; 660 - Bonaire, Sint Eustatius and Saba; 665 - Curacao; 681 - Timor-Leste and 685 - South Sudan.

Note:

The following incoming Ethnicity values were not mapped: 0 - Not Stated and 8 - Other.

Context Definition Template: SAD_AP

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_AP_TESTPROSPECT

This file mapping definition can be used to create prospects and populate test scores. 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_AP. If you change this, all the file layout and mapping setup will disappear.

Modify the conversion definition to the one you have created.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the AP layout you are using.

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_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_CAR_STG.CAMPUS

  • SAD_PRS_PRG_STG.ACAD_CAREER

  • SAD_PRS_PRG_STG.INSTITUTION

  • SAD_PRS_PRG_STG.ACAD_PROG

  • SAD_PRS_PRG_STG.RECRUITING_STATUS

  • SAD_PRS_PRG_STG.CAMPUS

  • SAD_PRS_PLN_STG.ACAD_CAREER

  • SAD_PRS_PLN_STG.INSTITUTION

  • SAD_PRS_PLN_STG.ACAD_PROG

  • SAD_PRS_PLN_STG.ACAD_PLAN

  • SCC_STG_TEST.TEST_ID

  • SCC_STG_TEST.CHKLST_ITM_UPDT

  • SCC_STG_TESTCMP.TEST_ID – Thirty Rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Thirty rows

  • SCC_STG_TESTDT.TEST_ID

  • SAD_STG_TST_CAF.TEST_ID – Eight rows

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

  • SCC_STG_CONSTIT.BIRTHDATE - Removes zeros from birthdate which are delivered if the Date of Birth in position 142 is blank or invalid.

  • 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.

  • SCC_STG_ADDR.STATE - Populates incoming State field value starting at position 127 when the country is USA. When country is CAN, the field is populated based on the Field Conversion definition CAN Provinces. For other countries, the STATE field is not populated.

  • 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 High School Code in position 213 to determine the EXT_ORG_ID to populate based on the EXT_ORG_TBL_ADM.ACT_CODE.

File Mapping Definition Template: SAD_AP_TESTRESULTS

This file mapping definition can be used to post AP test scores. 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_AP. If you change this, all the file layout and mapping setup will disappear.

Modify the conversion definition to the one you have created.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the AP layout you are using.

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_TEST.TEST_ID

  • SCC_STG_TEST.CHKLST_ITM_UPDT

  • SCC_STG_TESTCMP.TEST_ID – Thirty Rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Thirty rows

  • SCC_STG_TESTDT.TEST_ID

  • SAD_STG_TST_CAF.TEST_ID – Eight rows

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

  • SCC_STG_CONSTIT.BIRTHDATE - Removes zeros from birthdate which are delivered if the Birthdate in position 142 is blank or invalid.

  • 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.

  • SCC_STG_ADDR.STATE - Populates incoming State field value starting at position 127 when the country is USA. When country is CAN, the field is populated based on the Field Conversion definition CAN Provinces. For other countries, the STATE field is not populated.

Common Attribute Framework

The following sample common attributes have been delivered for the incoming field indicated. These attributes should be associated with the SAD_TESTDT record context:

  • AP_BEST_LANG for Best Language

  • AP_DT_GRD_RTC for Date Grades Released to College

  • AP_DT_LAST_STUP for Date of Last Student Update

  • AP_DT_REPORT for Date of this report

  • AP_NBR for AP Number

  • AP_ORDER_IKEY for Ordering Institution Key

  • AP_SERVICE_CODE for Service Code

  • AP_SERVICE_TYPE for Service Type

Set up additional common attributes for other fields that have not been mapped on the File Mapping Definition component. Add each new attribute to the SAD_TESTDT or ADM_PRSPCT_CAR record context depending on your business process. In addition to creating the common attribute and adding them to the record context, you will need to add rows for each common attribute on the File Mapping Definition component. Additional fields that were not mapped upon initial delivery of the AP File Mapping Definitions include:

  • Student Search

  • Applying for Sophomore Standing

  • Previous AI Year1

  • Previous AI Code1

  • Previous AI Year2

  • Previous AI Code2

  • Award Type1

  • Award Year1

  • Award Type2

  • Award Year2

  • Award Type3

  • Award Year3

  • Award Type4

  • Award Year4

  • Award Type5

  • Award Year5

  • Award Type6

  • Award Year6

  • High School Contact Name

  • High School Name

  • High School Address #1

  • High School Address #2

  • High School Address #3

  • High School State

  • High School ZIP Code

  • College Code

  • College Contact Name

  • College Name

  • College Address #1

  • College Address #2

  • College Address #3

  • College State

  • College ZIP Code

  • The following fields are not mapped for each of the thirty exam sets:

    • Irregularity Code #1

    • Irregularity Code #2

    • Exam Suppression Flag

    • Class Section Code

To complete the setup for the delivered common attributes, see: