Delivered PDL Templates

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:

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

Delivered Transaction Code: SAD_IELTS

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:

Not needed

Context Definition Template: SAD_IELTS

Review the delivered template and determine if any records need to be added. Modify this delivered definition. 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_IELTS_TESTRESULTS

This file mapping definition can be used to post IELTS 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:

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the IELTS 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_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_COMPONENT – Five rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Five rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Six rows

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

• 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_TESTCMP.SCORE - Looks at the incoming score value for ListeningTestScore, ReadingTestScore, WritingTestScore, SpeakingTestScore or OverallScore (depending on the application class ID populated). If the incoming value is 0 or -1, population of the row is skipped.

Common Attribute Framework:

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

• IELTS_DOWNLOADID for DownloadID

• IELTS_PARTNO for PartNo

• IELTS_CENTRENUMBER for CentreNumber

• IELTS_CANDIDATENUMBR for CandidateNumber

• IELTS_CANDIDATEID for CandidateID

• IELTS_TRFNUMBER for TRFNumber

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 record context. 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 include:

• StartDate

• EndDate

See Setting Up Filtering for Common Attributes

Delivered Transaction Code: SAD_PTE

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_PTE

Conversion examples have been delivered for the following fields:

• Academic Career based on incoming Program Receiving Scores values.

• Academic Plan based on incoming Program Receiving Scores values.

• Academic Program based on incoming Program Receiving Scores values.

• STATE/PROVINCE/COUNTY based on incoming Country Of Residence and State/Province/County values. Used with a delivered calculated field.

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_PTE

Review the delivered template and determine if any records need to be added. Modify this delivered definition. 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_PTE_TESTRESULTS

This file mapping definition can be used to post PTE test scores only. 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:

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the PTE 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_EMAIL.E_ADDR_TYPE

• SCC_STG_PHONE.PHONE TYPE – Two rows

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_COMPONENT – Eleven rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Eleven rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Five rows

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

• 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 - Concatenates the incoming values for Country of Residence and State/Province/County and compares them to the Field Conversion Definition for STATE/PROVINCE/COUNTY to determine the value to populate.

File Mapping Definition Template: SAD_PTE_TESTPROSPECT

This file mapping definition can be used to post PTE test scores and create a prospect record. 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: Modify context definition and conversion definition to those you have created. Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the PTE 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_EMAIL.E_ADDR_TYPE

• SCC_STG_PHONE.PHONE TYPE – Two rows

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_COMPONENT – Eleven rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE– Eleven rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Five rows

• SAD_PRS_CAR_STG.INSTITUTION

• SAD_PRS_CAR_STG.RECRUITING_STATUS

• SAD_PRS_CAR_STG.ADM_REFRL_SRCE

• SAD_PRS_PRG_STG.INSTITUTION

• SAD_PRS_PRG_STG.RECRUITING_STATUS

• SAD_PRS_PLN_STG.INSTITUTION

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

• 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 - Concatenates the incoming values for the Country of Residence and State/Province/County fields and compares them to the field conversion definition for STATE/PROVINCE/COUNTY to determine the value to populate.

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

Common Attribute Framework:

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

• PTE_DTSCORESAVAIL for Date Scores Available To Program

• PTE_FIRSTTIMETESTTKR for First-Time Test Taker

• PTE_PROGRECSCORES for Program Receiving Scores

• PTE_REGISTRATIONID for Registration Id

• PTE_SCORESVALIDUNTIL for Scores Valid Until

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 record context. 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 include: Irregularity Code

See Setting Up Filtering for Common Attributes

Delivered Transaction Code: SAD_TOEFL

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_TOEFL

Conversion examples have been delivered for the following fields:

• Gender based on incoming Gender values.

• Language Code based on incoming Native Language Code values.

• Academic Career based on incoming Department Code values.

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.

Context Definition Template: SAD_TOEFL

Review the delivered template and determine if any records need to be added. Modify this delivered definition. 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_TOEFL_TESTRESULTS

This file mapping definition can be used to post TOEFL test scores only. 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:

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the TOEFL 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_EMAIL.E_ADDR_TYPE

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_COMPONENT – Ten rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Ten rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Ten rows

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

• 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_NAMES.LAST_NAME, SCC_STG_NAMES.FIRST_NAME and SCC_STG_NAMES.MIDDLE_NAME - Parses the incoming value in Last (Family) Name in position 43 into LAST_NAME, FIRST_NAME and MIDDLE_NAME when the Test Type = P (PBT) in field position 556. If the Test Type is I (IBT), the name parts will appear in the three separate fields Last (Family) Name, First (Given) Name and Middle Name and will populate LAST_NAME, FIRST_NAME and MIDDLE_NAME from the three fields.

• SCC_STG_TESTCMP.SCORE - Looks at the incoming score value for IBT Listening, IBT Speaking, IBT Total Score, P/B Section I Score and Total Score (depending on the application class ID populated). If the incoming value is ** or ***, population of the row is skipped.

• SCC_STG_ADDR.STATE - Validates the incoming country against the values in the country table. If the country exists, it then validates the incoming state-country combination against the state table. If the state-province is found, the state value is populated. If not, the field is left blank.

File Mapping Definition Template: SAD_TOEFL_TESTPROSPECT

This file mapping definition can be used to post TOEFL test scores and create a prospect record. 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: Modify context definition and conversion definition to those you have created. Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the TOEFL 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_EMAIL.E_ADDR_TYPE

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_COMPONENT – Ten rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Ten rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Ten rows

• SAD_PRS_CAR_STG.INSTITUTION

• SAD_PRS_CAR_STG.RECRUITING_STATUS

• SAD_PRS_CAR_STG.ADM_REFRL_SRCE

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

• 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_NAMES.LAST_NAME, SCC_STG_NAMES.FIRST_NAME and SCC_STG_NAMES.MIDDLE_NAME - Parses the incoming value in Last (Family) Name in position 43 into LAST_NAME, FIRST_NAME and MIDDLE_NAME when the Test Type = P (PBT) in field position 556. If the Test Type is I (IBT), the name parts will appear in the three separate fields Last (Family) Name, First (Given) Name and Middle Name and will populate LAST_NAME, FIRST_NAME and MIDDLE_NAME from the three fields.

• SCC_STG_TESTCMP.SCORE - Looks at the incoming score value for IBT Listening, IBT Speaking, IBT Total Score, P/B Section I Score and Total Score (depending on the application class ID populated). If the incoming value is ** or ***, population of the row is skipped.

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

• SCC_STG_ADDR.STATE - Validates the incoming country against the values in the country table. If the country exists, it then validates the incoming state-country combination against the state table. If the state-province is found, the state value is populated. If not, the field is left blank.

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:

• TOEFL_REG_NBR for Registration or Appointment Number

• TOEFL_TESTCTR_CD for Test Center Code

• TOEFL_LIST_IND for Listening Indicator

• TOEFL_SPK_IND for Speaking Indicator

• TOEFL_REASON_TKN for Reason for taking TOEFL

• TOEFL_DEGREE for Degree

• TOEFL_INTINFO_YEAR for Interpretive Info Year

• TOEFL_NBR_TAKEN for Number of times taken

• TOEFL_IBT_TESTCTR for IBT Test Center Code

• TOEFL_TSTCTR_CNTRY for Test Center Country

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 record context. 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 include:

• Institution Code

• Department Code

• Address Country Name

• Native Country Name

• Test Type

• No Resp/Off Topic

See Setting Up Common Attribute Framework

See Setting Up Filtering for Common Attributes

Delivered Transaction Code: SAD_GMAT

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_GMAT

Conversion examples have been delivered for the following fields:

• Admit Term based on incoming Graduation Date values.

• Gender based on incoming Gender values.

• STATE/PROVINCE based on incoming Country Of Residence and State/Province values. Used with a delivered calculated field.

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.

Context Definition Template: SAD_GMAT

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_GMAT_TESTPROSPECT

This file mapping definition can be used to create prospects in addition to populating 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:

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the GMAT layout you are using. Modify default values on the Date Day column for the fields:

• Administration Date

• Administration Date2

• Administration Date3

• Graduation Date

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

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_ID – Fifteen rows

• SCC_STG_TESTCMP.TEST_COMPONENT – Fifteen rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Fifteen rows

• SCC_STG_TESTDT.TEST_ID – Three rows

• SAD_STG_TST_CAF.TEST_ID – Eight 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.ACAD_CAREER

• SAD_PRS_PRG_STG.INSTITUTION

• SAD_PRS_PRG_STG.ACAD_PROG

• SAD_PRS_PRG_STG.RECRUITING_STATUS

• SAD_PRS_PLN_STG.ACAD_CAREER

• SAD_PRS_PLN_STG.INSTITUTION

• SAD_PRS_PLN_STG.ACAD_PROG

• SAD_PRS_PLN_STG.ACAD_PLAN

• SAD_STG_PRS_CAF.ACAD_CAREER – Three rows.

• SAD_STG_PRS_CAF.INSTITUTION – Three rows.

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

• 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 - Concatenates the incoming values for the Country of Residence and State/Province/County fields and compares them to the field conversion definition for STATE/PROVINCE to determine the value to populate.

• SCC_STG_TESTCMP.SCORE - Looks at the incoming score value for the Verbal Converted Score, Quantitative Converted Score, Total Converted Score, Analytical Writing Converted Score and Integrated Reasoning Converted Score (depending on the application class ID populated). If the incoming value is ++ or +++ or ~~~, population of the row is skipped.

• SCC_STG_TESTCMP.PERCENTILE - Looks at the incoming percentile value for the Verbal Percentage Below, Quantitative Percentage Below, Total Score Percentage Below, Analytical Writing Percentage Below or Integrated Reasoning Percentage (depending on the application class ID populated). If the incoming value is ++ or ~~, population of the field is skipped.

• 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 Attending Institution Code to determine the EXT_ORG_ID to populate based on the EXT_ORG_TBL_ADM.ATP_CODE.

File Mapping Definition Template: SAD_GMAT_TESTRESULTS

This file mapping definition can be used to post GMAT 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:

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the GMAT layout you are using. Modify default values on the Date Day column for the fields:

• Administration Date

• Administration Date2

• Administration Date3

• Graduation Date

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

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_ID – Fifteen rows

• SCC_STG_TESTCMP.TEST_COMPONENT – Fifteen rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Fifteen rows

• SCC_STG_TESTDT.TEST_ID – Three rows

• SAD_STG_TST_CAF.TEST_ID – Eleven rows

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

• 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 - Concatenates the incoming values for the Country of Residence and State/Province/County fields and compares them to the field conversion definition for STATE/PROVINCE to determine the value to populate.

• SCC_STG_TESTCMP.SCORE - Looks at the incoming score value for the Verbal Converted Score, Quantitative Converted Score, Total Converted Score, Analytical Writing Converted Score and Integrated Reasoning Converted Score (depending on the application class ID populated). If the incoming value is ++ or +++ or ~~~, population of the row is skipped.

• SCC_STG_TESTCMP.PERCENTILE - Looks at the incoming percentile value for the Verbal Percentage Below, Quantitative Percentage Below, Total Score Percentage Below, Analytical Writing Percentage Below or Integrated Reasoning Percentage (depending on the application class ID populated). If the incoming value is ++ or ~~, population of the field is skipped.

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:

• GMAT_DT_SCORE - Date Scores Published to Program.

• GMAT_EDU_LVL - Education Level.

• GMAT_ID_NBR - GMAT ID Number.

• GMAT_IN_GRD_STUDY - Intended Graduate Study.

• GMAT_IRR_CD - Irregularity Code.

• GMAT_PROG_CD - GMAT Program Code.

• GMAT_REG_NBR - Registration/Appt Number.

• GMAT_UGRD_MJCD - Undergraduate Major Code.

• GMAT_UGRD_PTAVG - Undergraduate Grade Point Average.

These attributes should be associate with the ADM_PRSPCT_CAR Record Context:

• GMAT_EDU_LVL - Education Level.

• GMAT_UGRD_MJCD - Undergraduate Major Code.

• GMAT_UGRD_PTAVG - Undergraduate Grade Point Average.

See Setting Up Common Attribute Framework

See Setting Up Filtering for Common Attributes

Delivered Transaction Code: SAD_GRE

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_GRE

Conversion examples have been delivered for the following fields:

• ACAD CAREER based on incoming Department Code value.

• ACAD_PROG based on incoming Department Code value.

• ACAD PLAN based on incoming Intended Graduate Major Field value.

• GENDER based on incoming Gender 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.

Context Definition Template: SAD_GRE

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_GRE_TESTPROSPECT

This file mapping definition can be used to create prospects, populate test scores and supporting data such as academic interests. 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:

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the GRE 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_EMAIL.E_ADDR_TYPE

• SCC_STG_PHONE.PHONE TYPE

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_ID – Twenty-one rows

• SCC_STG_TESTCMP.TEST_COMPONENT – Twenty-one rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Twenty-one rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Seven rows

• SAD_PRS_CAR_STG.INSTITUTION

• SAD_PRS_CAR_STG.RECRUITING_STATUS

• SAD_PRS_CAR_STG.ADM_REFRL_SRCE

• SAD_PRS_PRG_STG.INSTITUTION

• SAD_PRS_PRG_STG.RECRUITING_STATUS

• SAD_PRS_PLN_STG.INSTITUTION

• SCC_STG_ADMINT.LS_DATA_SOURCE

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

• 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_TESTCMP.SCORE - Twenty one rows. Formats the incoming score.

  • Verbal Reasoning Score: If Test Code is 02 and Score Type is V, then Scaled Score should be populated.

  • Quantitative Reasoning Score: If Test Code is 02 and Score Type is Q, then Scaled Score should be populated.

  • New Verbal Reasoning Score: If Test Code is 03 and Score Type is V, then Scaled Score should be populated. OR If Test Code is 02 and Score Type is V, then Estimated Current Score should be populated.

  • New Quantitative Reasoning Score: If Test Code is 03 and Score Type is Q, then Scaled Score should be populated. OR If Test Code is 02 and Score Type is Q, then Estimated Current Score should be populated.

  • Analytical Writing Score: If Test Code is 02 or 03 and Score Type is W, then Scaled Score should be populated.

  • Biochemistry, Cell, Molecular Biology Score: If Test Code is 22 and Score Type is S, then Scaled Score should be populated.

  • Biochemistry Subscore: If Test Code is 22 and Score Type is 1, then Scaled Score should be populated.

  • Cell Biology Subscore: If Test Code is 22 and Score Type is 2, then Scaled Score should be populated.

  • Molecular Bio & Genetics Subscore: If Test Code is 22 and Score Type is 3, then Scaled Score should be populated.

  • Biology Score: If Test Code is 24 and Score Type is S, then Scaled Score should be populated.

  • Cellular & Molecular Bio Subscore: If Test Code is 24 and Score Type is 1, then Scaled Score should be populated.

  • Organismal Biology Subscore: If Test Code is 24 and Score Type is 2, then Scaled Score should be populated.

  • Ecology & Evolution Subscore: If Test Code is 24 and Score Type is 3, then Scaled Score should be populated.

  • Chemistry Score: If Test Code is 27 and Score Type is S, then Scaled Score should be populated.

  • Computer Science Score: If Test Code is 29 and Score Type is S, then Scaled Score should be populated.

  • Literature in English Score: If Test Code is 64 and Score Type is S, then Scaled Score should be populated.

  • Mathematics Score: If Test Code is 68 and Score Type is S, then Scaled Score should be populated.

  • Physics Score: If Test Code is 77 and Score Type is S, then Scaled Score should be populated .

  • Psychology Score: If Test Code is 81 and Score Type is S, then Scaled Score should be populated.

  • Experimental Psychology Subscore: If Test Code is 81 and Score Type is 1, then Scaled Score should be populated.

  • Social Psychology Subscore: If Test Code is 81 and Score Type is 2, then Scaled Score should be populated.

• SCC_STG_TESTCMP.PERCENTILE - Twenty One rows. Formats the incoming percentile.

  • Verbal Reasoning Percentage: If Test Code is 02 and Score Type is V, then Percentage Rank should be populated.

  • Quantitative Reasoning Percentage: If Test Code is 02 and Score Type is Q, then Percentage Rank should be populated.

  • New Verbal Reasoning Percentage: If Test Code is 03 and Score Type is V, then Percentage Rank should be populated.

  • New Quantitative Reasoning Percentage: If Test Code is 03 and Score Type is Q, then Percentage Rank should be populated.

  • Analytical Writing Percentage: If Test Code is 02 or 03 and Score Type is W, then Percentage Rank should be populated.

  • Biochemistry, Cell, Molecular Biology Percentage: If Test Code is 22 and Score Type is S, then Percentage Rank should be populated.

  • Biochemistry Percentage: If Test Code is 22 and Score Type is 1, then Percentage Rank should be populated.

  • Cell Biology Percentage: If Test Code is 22 and Score Type is 2, then Percentage Rank should be populated.

  • Molecular Bio & Genetics Percentage: If Test Code is 22 and Score Type is 3, then Percentage Rank should be populated.

  • Biology Percentage: If Test Code is 24 and Score Type is S, then Percentage Rank should be populated.

  • Cellular & Molecular Bio Percentage: If Test Code is 24 and Score Type is 1, then Percentage Rank should be populated.

  • Organismal Biology Percentage: If Test Code is 24 and Score Type is 2, then Percentage Rank should be populated.

  • Ecology & Evolution Percentage: If Test Code is 24 and Score Type is 3, then Percentage Rank should be populated.

  • Chemistry Percentage: If Test Code is 27 and Score Type is S, then Percentage Rank should be populated.

  • Computer Science Percentage: If Test Code is 29 and Score Type is S, then Percentage Rank should be populated.

  • Literature in English Percentage: If Test Code is 64 and Score Type is S, then Percentage Rank should be populated.

  • Mathematics Percentage: If Test Code is 68 and Score Type is S, then Percentage Rank should be populated.

  • Physics Percentage: If Test Code is 77 and Score Type is S, then Percentage Rank should be populated.

  • Psychology Percentage: If Test Code is 81 and Score Type is S, then Percentage Rank should be populated.

  • Experimental Psychology Percentage: If Test Code is 81 and Score Type is 1, then Percentage Rank should be populated.

  • Social Psychology Percentage: If Test Code is 81 and Score Type is 2, then Percentage Rank should be populated.

• SAD_PRS_CAR_STG.ADM_RECR_CTR - Derives the Recruiting Center based on the incoming Institution, Career, Program, and Plan.

File Mapping Definition Template: SAD_GRE_TESTRESULTS

This file mapping definition can be used to post GRE 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:

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the GRE 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_EMAIL.E_ADDR_TYPE

• SCC_STG_PHONE.PHONE TYPE

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_ID – Twenty-one rows

• SCC_STG_TESTCMP.TEST_COMPONENT – Twenty-one rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Twenty-one rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Seven rows

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

• 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_TESTCMP.SCORE - Twenty one rows. Formats the incoming score.

  • Verbal Reasoning Score: If Test Code is 02 and Score Type is V, then Scaled Score should be populated.

  • Quantitative Reasoning Score: If Test Code is 02 and Score Type is Q, then Scaled Score should be populated.

  • New Verbal Reasoning Score: If Test Code is 03 and Score Type is V, then Scaled Score should be populated. OR If Test Code is 02 and Score Type is V, then Estimated Current Score should be populated.

  • New Quantitative Reasoning Score: If Test Code is 03 and Score Type is V, then Scaled Score should be populated. OR If Test Code is 02 and Score Type is Q, then Estimated Current Score should be populated.

  • Analytical Writing Score: If Test Code is 02 or 03 and Score Type is W, then Scaled Score should be populated.

  • Biochemistry, Cell, Molecular Biology Score: If Test Code is 22 and Score Type is S, then Scaled Score should be populated.

  • Biochemistry Subscore: If Test Code is 22 and Score Type is 1, then Scaled Score should be populated.

  • Cell Biology Subscore: If Test Code is 22 and Score Type is 2, then Scaled Score should be populated.

  • Molecular Bio & Genetics Subscore: If Test Code is 22 and Score Type is 3, then Scaled Score should be populated.

  • Biology Score: If Test Code is 24 and Score Type is S, then Scaled Score should be populated.

  • Cellular & Molecular Bio Subscore: If Test Code is 24 and Score Type is 1, then Scaled Score should be populated.

  • Organismal Biology Subscore: If Test Code is 24 and Score Type is 2, then Scaled Score should be populated.

  • Ecology & Evolution Subscore: If Test Code is 24 and Score Type is 3, then Scaled Score should be populated.

  • Chemistry Score: If Test Code is 27 and Score Type is S, then Scaled Score should be populated.

  • Computer Science Score: If Test Code is 29 and Score Type is S, then Scaled Score should be populated.

  • Literature in English Score: If Test Code is 64 and Score Type is S, then Scaled Score should be populated.

  • Mathematics Score: If Test Code is 68 and Score Type is S, then Scaled Score should be populated.

  • Physics Score: If Test Code is 77 and Score Type is S, then Scaled Score should be populated.

  • Psychology Score: If Test Code is 81 and Score Type is S, then Scaled Score should be populated.

  • Experimental Psychology Subscore: If Test Code is 81 and Score Type is 1, then Scaled Score should be populated.

  • Social Psychology Subscore: If Test Code is 81 and Score Type is 2, then Scaled Score should be populated.

• SCC_STG_TESTCMP.PERCENTILE - Twenty one rows. Formats the incoming percentile.

  • Verbal Reasoning Percentage: If Test Code is 02 and Score Type is V, then Percentage Rank should be populated.

  • Quantitative Reasoning Percentage: If Test Code is 02 and Score Type is Q, then Percentage Rank should be populated.

  • New Verbal Reasoning Percentage: If Test Code is 03 and Score Type is V, then Percentage Rank should be populated.

  • New Quantitative Reasoning Percentage: If Test Code is 03 and Score Type is Q, then Percentage Rank should be populated.

  • Analytical Writing Percentage: If Test Code is 02 or 03 and Score Type is W, then Percentage Rank should be populated.

  • Biochemistry, Cell, Molecular Biology Percentage: If Test Code is 22 and Score Type is S, then Percentage Rank should be populated.

  • Biochemistry Percentage: If Test Code is 22 and Score Type is 1, then Percentage Rank should be populated.

  • Cell Biology Percentage: If Test Code is 22 and Score Type is 2, then Percentage Rank should be populated.

  • Molecular Bio & Genetics Percentage: If Test Code is 22 and Score Type is 3, then Percentage Rank should be populated.

  • Biology Percentage: If Test Code is 24 and Score Type is S, then Percentage Rank should be populated.

  • Cellular & Molecular Bio Percentage: If Test Code is 24 and Score Type is 1, then Percentage Rank should be populated.

  • Organismal Biology Percentage: If Test Code is 24 and Score Type is 2, then Percentage Rank should be populated.

  • Ecology & Evolution Percentage: If Test Code is 24 and Score Type is 3, then Percentage Rank should be populated.

  • Chemistry Percentage: If Test Code is 27 and Score Type is S, then Percentage Rank should be populated.

  • Computer Science Percentage: If Test Code is 29 and Score Type is S, then Percentage Rank should be populated.

  • Literature in English Percentage: If Test Code is 64 and Score Type is S, then Percentage Rank should be populated.

  • Mathematics Percentage: If Test Code is 68 and Score Type is S, then Percentage Rank should be populated.

  • Physics Percentage: If Test Code is 77 and Score Type is S, then Percentage Rank should be populated.

  • Psychology Percentage: If Test Code is 81 and Score Type is S, then Percentage Rank should be populated.

  • Experimental Psychology Percentage: If Test Code is 81 and Score Type is 1, then Percentage Rank should be populated.

  • Social Psychology Percentage: If Test Code is 81 and Score Type is 2, then Percentage Rank should be 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:

• GRE_LAST4_SSN - Social Security Number – Last 4 Digits

• GRE_REG_NBR - Registration Number

• GRE_TEST_NAME - Test Name

• GRE_EXAM_SEQ_NO - Examinee Sequence No.

• GRE_REC_SRL_NBR - Record Serial Number

• GRE_CYCLE_NO - Cycle Number

• GRE_PROC_DT - Process Date

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 record context. 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 include:

• Institution Name

• Department Name

• Country

• Test Code

See Setting Up Common Attribute Framework

See Setting Up Filtering for Common Attributes

Delivered Transaction Code: SAD_EOS

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_EOS

Conversion examples have been delivered for the following fields:

• Gender based on incoming Gender value.

• Racial/Ethnicity based on incoming Racial/Ethnicity value.

• Admit Term based on incoming Year of H.S. Graduation value.

• Academic Program based on incoming Intended College Major value.

• Academic Plan based on incoming Intended College Major value.

• Academic Interest based on incoming Intended College Major 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.

Context Definition Template: SAD_EOS

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_EOS_PROSPECTS

This file mapping definition can be used to create prospects, populate test scores and supporting data such as academic interests. 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:

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the EOS 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_CONSTIT.SCC_TRANSAC_CD

• SCC_STG_NAMES.NAME_TYPE

• SCC_STG_ADDR.ADDRESS_TYPE

• SCC_STG_EMAIL.E_ADDR_TYPE

• SAD_PDL_HDR_STG.SCC_TRANSAC_CD

• SCC_STG_STD_CAR.ACAD_CAREER

• SAD_PRS_CAR_STG.ACAD_CAREER

• SAD_PRS_CAR_STG.INSTITUTION

• SAD_PRS_CAR_STG.ADM_REFRL_SRCE

• SAD_PRS_CAR_STG.RECRUITING_STATUS

• SAD_PRS_PRG_STG.ACAD_CAREER

• SAD_PRS_PRG_STG.INSTITUTION

• SAD_PRS_PRG_STG.RECRUITING_STATUS

• SAD_PRS_PLN_STG.ACAD_CAREER

• SAD_PRS_PLN_STG_PRG.INSTITUTION

• SAD_STG_PRS_CAF.ACAD_CAREER

• SAD_STG_PRS_CAF.INSTITUTION

• SCC_STG_ADMIHD.ACAD_CAREER

• SCC_STG_ADMINT.ACAD_CAREER

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

• SCC_STG_CONSTIT.BIRTHDATE - Removes zeros from birthdate which are delivered if the Birthdate in position 160 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.COUNTRY - Uses the incoming value from Country Code in position 127 to determine the three character Country value to populate from COUNTRY_TBL.

• SCC_STG_ADDR.STATE - Populates incoming State field value starting at position 116 when the country is USA. Populates incoming Canadian Province field value starting at position 130 when the country is CAN. For other countries, the STATE field is not populated.

• SCC_STG_ADDR.POSTAL - Populates incoming ZIP Code + 4 field starting at position 118 when the country is USA. Populates incoming Non U.S. Postal Code field starting at position 132 when the country is CAN or other countries.

• SAD_PRS_CAR_STG.ADM_RCR_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 Number in position 175 to determine the EXT_ORG_ID to populate based on the EXT_ORG_TBL_ADM.ACT_CODE.

• SCC_STG_ADMINT.DESCR - Derive the academic interest description based on the External Subject Area populated.

Common Attribute Framework:

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

• EOS_MOBILITY_INDEX - Mobility Index

• EOS_PERRANK_MOBINDEX - Percentile Rank Mobility Index

• EOS_INST_TYPE_INDEX - Institution Type Index

• EOS_PERRANK_INSTINDEX - Percentile Rank Inst Type Index

• EOS_SEL_INDEX - Selectivity Index

• EOS_PERRANK_SELINDEX - Percentile Rank Selectivity Index

• EOS_INST_SIZE_INDEX - Institution Size Index

• EOS_PERRANK_INSTSZINDEX - Percentile Rank Inst Size Index

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 record context. 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 include:

• Purchase ID

• Occupational Choice

• State Code

See Setting Up Common Attribute Framework

See Setting Up Filtering for Common Attributes

Delivered Transaction Code: SAD_ACT

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_ACT

Conversion examples have been delivered for the following fields:

• Citizenship based on incoming Citizenship value.

• Gender based on incoming Gender Alpha value.

• Phone Type based on incoming Type of Telephone value.

• NID Country based on incoming Country Code value.

• Ethnicity based on incoming Race Background values in position 609-615.

• Hispanic/Latino based on incoming Hispanic or Latino Background value.

• Academic Interest based on incoming Major Plan value.

• Academic Program based on incoming Major Plan value.

• Academic Plan based on incoming Major Plan value.

• Academic Level based on incoming Academic Level value.

• Academic Load based on incoming Academic Load value.

• Admit Term based on incoming Year of H.S. Graduation value.

• Planned Housing based on incoming Planned Housing value.

• Financial Aid based on incoming Financial Aid value.

• Campus or community service (Extracurricular Activity Description) based on incoming Campus or community service value.

• Debate (Extracurricular Activity Description) based on incoming Debate value.

• Dramatics, theater (Extracurricular Activity Description) based on incoming Dramatics, theater value.

• Fraternity or sorority (Extracurricular Activity Description) based on incoming Fraternity or sorority value.

• Instrumental music (Extracurricular Activity Description) based on incoming Instrumental music value.

• Political organizations (Extracurricular Activity Description) based on incoming Political organizations value.

• Publications (Extracurricular Activity Description) based on incoming Publications value.

• Racial or ethnic organizations (Extracurricular Activity Description)based on incoming Racial or ethnic organizations value.

• Radio-TV (Extracurricular Activity Description) based on incoming Radio-TV value.

• Religious organizations (Extracurricular Activity Description) based on incoming Religious organizations value.

• Student government (Extracurricular Activity Description) based on incoming Student government value.

• Varsity athletics (Extracurricular Activity Description) based on incoming Varsity athletics value.

• Vocal music (Extracurricular Activity Description) based on incoming Vocal music value.

• Test Location (Used to derive test day for Test Date) based on incoming Test Location 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.

Context Definition Template: SAD_ACT

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_ACT_TESTPROSPECT

This file mapping definition can be used to create prospects, populate test scores 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:

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the ACT layout you are using. Also modify the default Date Day and Date Month values for Year of H.S. Graduation.

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

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

• SAD_PRS_CAR_STG.CAMPUS

• SAD_PRS_PRG_STG.ACAD_CAREER

• SAD_PRS_PRG_STG.INSTITUTION

• SAD_PRS_PRG_STG.RECRUITING_STATUS

• SAD_PRS_PRG_STG.CAMPUS

• SAD_PRS_PLN_STG.ACAD_CAREER

• SAD_PRS_PLN_STG.INSTITUTION

• SAD_STG_PRS_CAF.ACAD_CAREER – Nine rows

• SAD_STG_PRS_CAF.INSTITUTION – Nine rows

• SCC_STG_ADMIHD.ACAD_CAREER

• SCC_STG_ADMINT.ACAD_CAREER

• SCC_STG_EXTRACU.INSTITUTION – Thirteen rows

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_ID – Seven Rows

• SCC_STG_TESTCMP.TEST_COMPONENT – Seven rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Seven rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Eight rows

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

• SCC_STG_CONSTIT.BIRTHDATE - Removes zeros from birthdate which are delivered if the Birthdate in position 155 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.COUNTRY - Uses the incoming value from Country Code in position 85 to determine the three character Country value to populate from COUNTRY_TBL.

• SCC_STG_ADDR.POSTAL - Populates incoming ZIP Code + 4 field starting at position 146 when the country is USA. Populates incoming Non U.S. Postal Code field starting at position 253 when the country is CAN or other countries.

• SCC_STG_ADDR.STATE - Populates incoming State field value starting at position 142 when the country is USA. Populates incoming Canadian Province field value starting at position 250 when the country is CAN. For other countries, the STATE field is not populated nor is the STATE field populated if the value is FN or CN when country is USA.

• SCC_STG_NID.NATIONAL_ID - Populates National ID only when the incoming Social Security Number or ACT ID starting at position 91 doesn’t start with the value - and length is equal to 9.

• 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 Number in position 205 to determine the EXT_ORG_ID to populate based on the EXT_ORG_TBL_ADM.ACT_CODE.

• SCC_STG_ADMINT.DESCR - Derive the academic interest description based on the External Subject Area populated.

• SCC_STG_TESTCMP.TEST_DT, SCC_STG_TESTDT.TEST_DT and SAD_STG_TST_CAF.TEST_DT - Determine the Test Date based on the incoming MMYYYY value for Expanded Test Date in position 227 plus the converted value for Test Location in position 249. The converted Test Location Value will produce the day. The converted value for Test Location (DD) should be combined with the Expanded Test Date (MMYYYY) to provide the full TEST_DT value (MMDDYYYY).

• SCC_STG_TESTCMP.PERCENTILE - Per the ACT Layout, the value -- will be populated for the National Norm if the score is not reported. If the percentile is populated with the value -- the field is not populated for the following fields:

  • Natl Norms – English in position 773

  • Natl Norms – Math in position 775

  • Natl Norms – Reading in position 777

  • Natl Norms – Science Reasoning in position 779

  • Natl Norms – Composite in position 781

• SCC_STG_TESTCMP.SCORE - Per the ACT Layout, the value -- will be populated for the score if it is not administered. If the score is populated with the value --, the row is not created for the following scores:

  • English Scaled Score in position 261

  • Math Scaled Score in position 263

  • Reading Scaled Score in position 265

  • Science Scaled Score in position 267

  • Composite Scaled Score in position 269

  • Combined English Writing Score in position 163

  • Writing Sub-score in position 165

File Mapping Definition Template: SAD_ACT_TESTRESULTS

This file mapping definition can be used to post ACT 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:

Modify the conversion definition to the one you have created.

Change the delimiter if needed based on your file characteristics.

File Layout Tab: Review this tab to ensure the fields appear in the exact order as that of the ACT 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_EMAIL.E_ADDR_TYPE

• SCC_STG_PHONE.PHONE TYPE

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_ID – Seven Rows

• SAD_STG_TST_CAF.TEST_ID – Eight rows

• SCC_STG_TESTCMP.TEST_COMPONENT – Seven rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Seven rows

• SCC_STG_TESTDT.TEST_ID

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

• SCC_STG_CONSTIT.BIRTHDATE - Removes zeros from birthdate which are delivered if the Birthdate in position 155 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.COUNTRY - Uses the incoming value from Country Code in position 85 to determine the three character Country value to populate from COUNTRY_TBL.

• SCC_STG_ADDR.POSTAL - Populates incoming ZIP Code + 4 field starting at position 146 when the country is USA. Populates incoming Non U.S. Postal Code field starting at position 253 when the country is CAN or other countries.

• SCC_STG_ADDR.STATE - Populates incoming State field value starting at position 142 when the country is USA. Populates incoming Canadian Province field value starting at position 250 when the country is CAN. For other countries, the STATE field is not populated nor is the STATE field populated if the value is FN or CN when country is USA.

• SCC_STG_NID.NATIONAL_ID - Populates National ID only when the incoming Social Security Number or ACT ID starting at position 91 doesn’t start with the value - and length is equal to 9.

• SCC_STG_TESTCMP.TEST_DT, SCC_STG_TESTDT.TEST_DT and SAD_STG_TST_CAF.TEST_DT - Determine the Test Date based on the incoming MMYYYY value for Expanded Test Date in position 227 plus the converted value for Test Location in position 249. The converted Test Location Value will produce the day. The converted value for Test Location (DD) should be combined with the Expanded Test Date (MMYYYY) to provide the full TEST_DT value (MMDDYYYY).

• SCC_STG_TESTCMP.PERCENTILE - Per the ACT Layout, the value -- will be populated for the National Norm if the score is not reported. If the percentile is populated with the value -- the field is not populated for the following fields:

  • Natl Norms – English in position 773

  • Natl Norms – Math in position 775

  • Natl Norms – Reading in position 777

  • Natl Norms – Science Reasoning in position 779

  • Natl Norms – Composite in position 781

• SCC_STG_TESTCMP.SCORE - Per the ACT Layout, the value -- will be populated for the score if it is not administered. If the score is populated with the value --, the row is not created for the following scores:

  • English Scaled Score in position 261

  • Math Scaled Score in position 263

  • Reading Scaled Score in position 265

  • Science Scaled Score in position 267

  • Composite Scaled Score in position 269

  • Combined English Writing Score in position 163

  • Writing Sub-score in position 165

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:

• ACT_TEST_LOCATION for Test Location

• ACT_ESSAYCOMMENT1 for Essay Comment 1

• ACT_ESSAYCOMMENT2 for Essay Comment 2

• ACT_ESSAYCOMMENT3 for Essay Comment 3

• ACT_ESSAYCOMMENT4 for Essay Comment 4

• ACT_SCALESCORES_SUM for Sum of Scale Scores

• ACT_STATE_STUDENTID for State-Assigned Student ID

• ACT_CORRECTED_IND for Corrected Report Indicator

These attributes should be associated with the ADM_PRSPCT_CAR record context

• ACT_CLG_CHOICE_NBR for College Choice Number

• ACT_HS_CLASSRANK for High School Class Rank

• ACT_HS_GPA for High School GPA

• ACT_HS_CLASS_SIZE for High School Class Size

• ACT_CLG_TYPE_PREF for College Type Preference

• ACT_CLG_TYPE_RANK for Ranking College Type

• ACT_INSTTYPE_PREDINDEX for Pred Modeling Institution Type Index

• ACT_MOMGRD1_EDLEVEL for Mother/Guardian 1 Ed Level

• ACT_DADGRD2_EDLEVEL for Father/Guardian 2 Ed Level

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 ACT File Mapping Definitions include:

• Reporting Year Identifier

• English Score before Oct 1989

• Math Score before Oct 1989

• Social Science Score before Oct 1989

• Natural Sciences Score before Oct 1989

• Composite Score before Oct 1989

• English GPA

• Math GPA

• Social Studies GPA

• Natural Sciences GPA

• H.S. Average

• Science Int Inv

• Arts Int Inv

• Social Service Int Inv

• Business Contact Int Inv

• Business Operations Int Inv

• Technical Int Inv

• Map Region 1

• Map Region 2

• Map Region 3

• College Code

• Usage/Mech Subscore

• Elem Algebra Subscore

• Soc Stud/Sci Subscore

• Rhetorical Skills Subscore

• Alg/Coord Geom Subscore

• Arts/Lit Subscore

• Plane Geom/Trig Subscore

• Usage/Mech National Norms

• Elem Algebra National Norms

• Soc Stud/Sci National Norms

• Rhetorical Skills National Norms

• Alg/Coord Geom National Norms

• Arts/Lit National Norms

• Plane Geom/Trig National Norms

• Usage/Mech Local Norms

• Elem Algebra Local Norms

• Soc Stud/Sci Local Norms

• Rhetorical Skills Local Norms

• Alg/Coord Geom Local Norms

• Arts/Lit Local Norms

• Plane Geom/Trig Local Norms

• Science Int Inv

• Arts Int Inv

• Social Service Int Inv

• Business Contact Int Inv

• Business Operations Int Inv

• Technical Int Inv

• Local ID Number

• Mobility Index

• Selectivity Index

• Institution Size Index

• Interest-Major Fit Score

• Legal Resident of State

• Disability

• Vocation Choice

• Confidence in College Major

• Confidence in Vocation

• Expected Highest Educ Level

• ROTC

• Decide Educ/Occup Plans

• Express Ideas in Writing

• Improve Reading Speed & Comp

• Improve Student Skills

• Independent Study

• Freshman honors courses

• Study in a foreign country

• Improve Math Skills

• Expect to Work

• Hours Expect to Work

• Total Combined Income

• Distance From College

• English Spoken at Home

• Ethnicity

• Pref College Gender Type

• PrefCollege State(1)

• PrefCollege State(2)

• Pref Max Annual Tuition

• Pref Student Body Size

• Ranking Gender Type

• Ranking Location

• Ranking Tuition

• Ranking Student Body Size

• Ranking Field of Study

• Ranking Other Factor

• High School Descr

• High School Prog Type

• Yrs Study: English

• Yrs Study: Mathematics

• Yrs Study: Social studies

• Yrs Study: Natural sciences

• Yrs Study: Spanish

• Yrs Study: German

• Yrs Study: French

• Yrs Study: Other Language

• Honors Courses English

• Honors Courses Math

• Honors Courses Social Studies

• Honors Courses Natural Sci

• Honors Courses Foreign Lang

• Organized school event

• Elected to student offices

• Leadership award

• Musical group

• Superior rating state music

• 1st/2nd/3rd debate

• Substantial roles in plays

• Appeared on radio or TV

• Exhibited art state/reg show

• High school art award

• City/country/state art award

• Published poems, stories

• Literary award or prize

• Published creative writing

• NSF summer program

• 1st/2nd/3rd reg/state science

• 1st/2nd/3rd school science

• Varsity sports letter

• Athletic honors

• Community service award

• Started business or service

• EOS Release

• Prefer not to respond

• Multiracial (converted records only)

• English 9 Taken or Planned

• English 10 Taken or Planned

• English 11 Taken or Planned

• English 12 Taken or Planned

• English Other Taken or Planned

• Algebra 1 Taken or Planned

• Algebra 2 Taken or Planned

• Geometry Taken or Planned

• Trigonometry Taken or Planned

• Calculus Taken or Planned

• Other Math Taken or Planned

• Computer Taken or Planned

• General Science Taken or Planned

• Biology Taken or Planned

• Chemistry Taken or Planned

• Physics Taken or Planned

• U.S. History Taken or Planned

• World History Taken or Planned

• Other History Taken or Planned

• Government Taken or Planned

• Economics Taken or Planned

• Geography Taken or Planned

• Psychology Taken or Planned

• Spanish Taken or Planned

• French Taken or Planned

• German Taken or Planned

• Other Language Taken or Planned

• Art Taken or Planned

• Music Taken or Planned

• Drama Taken or Planned

• English 9 Grade Earned

• English 10 Grade Earned

• English 11 Grade Earned

• English 12 Grade Earned

• English Other Grade Earned

• Algebra 1 Grade Earned

• Algebra 2 Grade Earned

• Geometry Grade Earned

• Trigonometry Grade Earned

• Calculus Grade Earned

• Other Math Grade Earned

• Computer Grade Earned

• General Science Grade Earned

• Biology Grade Earned

• Chemistry Grade Earned

• Physics Grade Earned

• U.S. History Grade Earned

• World History Grade Earned

• Other History Grade Earned

• Government Grade Earned

• Economics Grade Earned

• Geography Grade Earned

• Psychology Grade Earned

• Spanish Grade Earned

• French Grade Earned

• German Grade Earned

• Other Language Grade Earned

• Art Grade Earned

• Music Grade Earned

• Drama Grade Earned

• Pred Pct English

• Pred Pct Math

• Pred Pct Reading

• Pred Pct Science Reason

• Pred Pct Composite

• Pred Pct Ranking Overall 1

• Pred Pct Ranking Overall 2

• Pred Pct Ranking Overall 3

• Pred Pct Ranking Overall 4

• Pred Pct Ranking Overall 5

• Pred Pct Ranking Specific Courses 1

• Pred Pct Ranking Specific Courses 2

• Pred Pct Ranking Specific Courses 3

• Pred Pct Ranking Specific Courses 4

• Pred Pct Ranking Specific Courses 5

• Prob C or Higher Overall 1

• Prob C or Higher Overall 2

• Prob C or Higher Overall 3

• Prob C or Higher Overall 4

• Prob C or Higher Overall 5

• Prob C or Higher Courses 1

• Prob C or Higher Courses 2

• Prob C or Higher Courses 3

• Prob C or Higher Courses4

• Prob C or Higher Courses 5

• Pred GPA Overall 1

• Pred GPA Overall 2

• Pred GPA Overall 3

• Pred GPA Overall 4

• Pred GPA Overall 5

• Pred GPA Courses 1

• Pred GPA Courses 2

• Pred GPA Courses 3

• Pred GPA Courses4

• Pred GPA Courses 5

• Norms Type

See Setting Up Common Attribute Framework

See Setting Up Filtering for Common Attributes

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.

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:

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:

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

See Setting Up Common Attribute Framework

See Setting Up Filtering for Common Attributes

Delivered Transaction Code: SAD_LSAT

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_LSAT

Conversion examples have been delivered for the following fields:

• Admit Term based on incoming Term Code value.

• Ethnicity based on incoming Ethnic Super Categories values.

• Gender based on incoming Gender 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.

Context Definition Template: SAD_LSAT

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_LSAT_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:

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 LSAT 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 – 2 rows

• SCC_STG_ADDR.ADDRESS_TYPE

• SCC_STG_EMAIL.E_ADDR_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_PRG_STG.ACAD_CAREER

• SAD_PRS_PRG_STG.INSTITUTION

• SAD_PRS_PRG_STG.ACAD_PROG

• SAD_PRS_PRG_STG.RECRUITING_STATUS

• 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 – Twelve Rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Twelve rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Nine rows

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

• SCC_STG_NAMES.LAST_NAME_SRCH - Removes all special characters and puts the field into upper case. There are two calculated fields: one for Primary Name and one for Previous Last Name.

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

File Mapping Definition Template: SAD_LSAT_TESTRESULTS

This file mapping definition can be used to post LSAT 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:

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 LSAT 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_EMAIL.E_ADDR_TYPE

• SCC_STG_NID.NATIONAL_ID_TYPE

• SCC_STG_TEST.TEST_ID

• SCC_STG_TEST.CHKLST_ITM_UPDT

• SCC_STG_TESTCMP.TEST_ID – Twelve Rows

• SCC_STG_TESTCMP.LS_DATA_SOURCE – Twelve rows

• SCC_STG_TESTDT.TEST_ID

• SAD_STG_TST_CAF.TEST_ID – Nine rows

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

• SCC_STG_NAMES.LAST_NAME_SRCH - Removes all special characters and puts the field into upper case. There are two calculated fields: one for Primary Name and one for Previous Last Name.

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

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:

• LSAT_APPL_STATUS for Applicant Status

• LSAT_AVG3D_SCORE for Average 3-digit LSAT Score

• LSAT_LSAC_ACCTNBR for LSAC Account Number

• LSAT_MISCONDUCT for Misconduct Flag

• LSAT_PRIOR_SCHLNM_1 for Name of Law School 1

• LSAT_PRIOR_SCHL_1 for Prior Law School Matriculation 1

• LSAT_SCORE_UPDATE for Score Update

• LSAT_SCRBAND_LOWER for Score band - Lower

• LSAT_SCRBAND_UPPER for Score band - Upper

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 LSAT File Mapping Definitions include:

• Law School Code #

• Date of Transmission

• Time Stamp

• Law School Social Sec/Ins Number

• Law School Last Name

• Law School First Name

• Law School Middle Initial

• Law School Tracking Number

• Age

• Foreign Address (City, Country, Zip)

• State of Permanent Residence

• Date of Future Test

• The following fields are not mapped for each of the twelve scores:

  • Score band - Upper

  • Score band - Lower

  • Irregularity Code

• Number of Valid 3-digit LSAT Scores

• Number of Valid 2-digit LSAT Scores

• Average 2-digit LSAT Score

• Date File Completed

• Misconduct Update

• Prior Matriculation Update

• Prior Matriculation School Code 1

• Prior Law School Matriculation 2

• Prior Matriculation School Code 2

• Name of Law School 2

• Prior Law School Matriculation 3

• Prior Matriculation School Code 3

• Name of Law School 3

• Term Year

• Ethnic Sub Categories

See Setting Up Common Attribute Framework

See Setting Up Filtering for Common Attributes