American College Testing (ACT)

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

Note:

From September 2020, when processing ACT test results, copy your existing SAD_ACT field conversion definition template, then name the copy as SAD_ACT_2020. This template is used in the file mapping definition template SAD_ACT_TESTRESULTS_2020. You have to update SAD_ACT_2020 to map incoming data from the ACT Test File. It’s a Campus Solutions-based setup table. To determine all the new fields in the test file, you must review 2020-2021 ACT College Score Reporting Service Layout.

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 on your internal values. Modify the delivered version as it will be used on the File Mapping Definition component. Before modifying, make sure you create a copy so that you have the original version.

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: Change the delimiter if needed based on your file characteristics.

Important:

Leave the context and conversion definitions as SAD_ACT. If you change this, all the file layout and mapping setup will disappear.

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 on the SAD_ACT Field Conversion Definition 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).

For this calculated field, it is important that the SAD_ACT field conversion definition is used. Modify the delivered version.
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:

Important:

Leave the context and conversion definitions as SAD_ACT. If you change this, all the file layout and mapping setup will disappear.

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 on the SAD_ACT Field Conversion Definition 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).

For this calculated field, it is important that the SAD_ACT field conversion definition is used. Modify the delivered version.
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 for SAD_ACT_TESTRESULTS

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

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

Context Definition Template: SAD_ACT_2020

SAD_ACT_2020 is used in the file mapping definition template SAD_ACT_TESTRESULTS_2020, and is a copy of the context definition template SAD_ACT.

File Mapping Definition Template: SAD_ACT_TESTRESULTS_2020

Important:

You should not make any changes to this definition; any change renders the process unusable.

From September 2020, you must use this file mapping definition to post ACT test scores because the file layout has changed.

File Definition Tab: This definition uses a CSV file, with the comma as a delimiter and double quotation marks as text qualifiers. This uses the context and conversion definitions SAD_ACT_2020.

File Layout Tab: The layout is based on the 2020-2021 ACT College Score Reporting Service Layout.

Mapping Tab: The structure of the mapping here is the same as SAD_ACT_TESTRESULTS with a few changes.

These are additional mapping records in this template:
- SCC_STG_TESTCMP row 4 for Test Component SCI (previously SCIRE)
- SCC_STG_TESTCMP row 6 for Test Component STEM
- SCC_STG_TESTCMP row 8 for Test Component ELA
- SCC_STG_TESTCMP row 9 for Test Component SSCOM
- SCC_STG_TESTCMP row 10 for Test Component SSELA
- SCC_STG_TESTCMP row 11 for Test Component SSENG
- SCC_STG_TESTCMP row 12 for Test Component SSMAT
- SCC_STG_TESTCMP row 13 for Test Component SSREA
- SCC_STG_TESTCMP row 14 for Test Component SSSCI
- SCC_STG_TESTCMP row 15 for Test Component SSTEM
- SCC_STG_TESTCMP row 16 for Test Component SSWRI
- SAD_STG_TST_CAF row 9 for Test Component ACT_SUPER_OTHER_ENG
- SAD_STG_TST_CAF row 10 for Test Component ACT_SUPER_OTHER_MAT
- SAD_STG_TST_CAF row 11 for Test Component ACT_SUPER_OTHER_SCI
- SAD_STG_TST_CAF row 12 for Test Component ACT_SUPER_OTHER_REA
This mapping record has been removed: SCC_STG_NID.
PeopleCode for TestDate, SuperEnglishDate, SuperMathDate, SuperReadingDate, SuperScienceDate and SuperWritingDate: By default, the day of the date is set to “01”.
PeopleCode for SuperEnglishScore, SuperMathScore, SuperReadingScore, SuperScienceScore and SuperWritingScore: If a row is not Super, the process throws a blank value; “Skip if Blank” is triggered.
Because there's no Test Date for Super fields SSCOM, SSELA, SSTEM, ACT_SUPER_OTHER_ENG, ACT_SUPER_OTHER_MAT, ACT_SUPER_OTHER_SCI and ACT_SUPER_OTHER_REA, the Application Class ID TestDate is used.
Make sure to populate the Value Conversion of Gender, Academic Level and Ethnicity based on the field conversion that you created.