Scholastic Aptitude Test (SAT)

Note:

Refer Doc ID 1997021.1 on My Oracle Support for detailed information on updated PDL templates based on the redesigned SAT layout effective from October 2015. The 2015 SAT Mapping Workbook contains all of the following information, updated for the revised SAT layout.

Delivered Transaction Code: SAD_SAT

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_SAT

Conversion examples are delivered for the following fields:

  • Academic Interest based on incoming First Choice Major, Other Major 1, Other Major 2, Other Major 3 and Other Major 4 values.

  • Academic Level based on incoming Academic Level value.

  • Academic Plan based on incoming First Choice Major value.

  • Academic Program based on incoming First Choice Major value.

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

  • Art (College Activity Description) based on incoming Art value.

  • Athletics: Intramural/Club (College Activity Description) based on incoming Athletics: Intramural or Club Sports value.

  • Athletics: Varsity Sports (College Activity Description) based on incoming Athletics: Varsity Sports value.

  • Citizenship based on incoming Citizenship value.

  • Community/Service Organization (College Activity Description) based on incoming Community or Service Organization value.

  • Cooperative Work/Internship (College Activity Description) based on incoming Cooperative Work or Internship Program value.

  • Country based on incoming Country value.

  • Dance (College Activity Description) based on incoming Dance value.

  • Debating or Public Speaking (College Activity Description) based on incoming Debating or Public Speaking value.

  • Departmental Organization (College Activity Description) based on incoming Departmental Organization value.

  • Drama or Theater (College Activity Description) based on incoming Drama or Theater value.

  • Environmental/Ecology Activity (College Activity Description) based on incoming Environmental or Ecology Activity value.

  • Ethnic Activity or Clubs (College Activity Description) based on incoming Ethnic Activity or Clubs

  • Ethnicity based on incoming Ethnic value in position 994.

  • Financial Aid based on incoming Financial Aid value.

  • Foreign Study or Study Abroad (College Activity Description) based on incoming Foreign Study or Study Abroad Program value.

  • Fraternity Sorority/Social Club (College Activity Description) based on incoming Fraternity, Sorority, or Social Club value.

  • Gender based on incoming Sex value.

  • Honors Prog/Independent Study (College Activity Description) based on incoming Honors Program or Independent Study value.

  • Instrumental Music (College Activity Description) based on incoming Instrumental Music Performance value.

  • Journalism/Literary Activity (College Activity Description) based on incoming Journalism/Literary Activity value.

  • Planned Housing based on incoming Planned Housing value.

  • ROTC (College Activity Description) based on incoming ROTC value.

  • Religious Activity (College Activity Description) based on incoming Religious Activity value.

  • Religious Preference based on incoming Religion value.

  • Student Government (College Activity Description) based on incoming Student Government value.

  • Test Component based on incoming Subject Test Code.

  • Vocal Music (College Activity Description) based on incoming Vocal Music Performance 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_SAT

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

Important:

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

If needed, change the delimiter based on your file characteristics.

File Layout Tab:

Review this tab to ensure that fields appear in the exact order as that of the SAT 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 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_STG_PRS_CAF.ACAD_CAREER – Six rows

  • SAD_STG_PRS_CAF.INSTITUTION – Six rows

  • 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

  • SCC_STG_ADMIHD.ACAD_CAREER

  • SCC_STG_ADMINT.ACAD_CAREER – Five rows

  • SCC_STG_ADMINT.LS_DATA_SOURCE – Five rows

  • SCC_STG_TEST.TEST_ID – Two rows

  • SCC_STG_TESTCMP.TEST_ID – Forty Eight Rows

  • SCC_STG_TESTCMP.TEST_COMPONENT – Thirty rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Forty Eight rows

  • SCC_STG_TESTDT.TEST_ID

  • SAD_STG_TST_CAF.TEST_ID – Seven rows

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

  • 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 – Interrogates Foreign Address Indicator in position 135. If ‘Y’ then populates COUNTRY from field conversion COUNTRY, otherwise uses USA.

  • SCC_STG_ADDR.STATE – Populates STATE position 92-93 if Country = CAN or USA. For all other countries, STATE is not populated.

  • SCC_STG_ADDR.POSTAL – Populates POSTAL position 95 – 103 only if Country = USA.

  • 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 1016 to determine the EXT_ORG_ID to populate based on the EXT_ORG_TBL_ADM.ACT_CODE.

  • SCC_STG_ADMINT.DESCR – Derives the academic interest description DESCR based on the incoming First Choice Major starting at position 933, Other Major 1 starting at position 937, Other Major 2 starting at position 940, Other Major 3 starting at position 943, Other Major 4 starting at position 946, from table EXT_SUBJECT_TBL.

  • SCC_STG_TEST.CHKLST_ITM_UPDT for second row where Test ID = SATII – Interrogates incoming Subject Test Codes to determine if this row of SCC_STG_TEST should be created. If codes are not present, the row is not created.

File Mapping Definition Template: SAD_SAT_TESTRESULTS

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

If needed, change the delimiter based on your file characteristics.

File Layout Tab:

Review this tab to ensure the fields appear in the exact order as that of the SAT 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_ETH_DTL.HISP_LATINO

  • SCC_STG_TEST.TEST_ID – Two rows

  • SCC_STG_TESTCMP.TEST_ID – Forty Eight Rows

  • SCC_STG_TESTCMP.TEST_COMPONENT – Thirty rows

  • SCC_STG_TESTCMP.LS_DATA_SOURCE – Forty Eight rows

  • SCC_STG_TESTDT.TEST_ID

  • SAD_STG_TST_CAF.TEST_ID – Seven rows

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

  • 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 – Interrogates Foreign Address Indicator in position 135. If ‘Y’ then populates COUNTRY from field conversion COUNTRY, otherwise uses USA.

  • SCC_STG_ADDR.STATE – Populates STATE position 92-93 if Country = CAN or USA. For all other countries, STATE is not populated.

  • SCC_STG_ADDR.POSTAL – Populates POSTAL position 95 – 103 only if Country = USA.

  • SCC_STG_TEST.CHKLST_ITM_UPDT for second row where Test ID = SATII. – Interrogates incoming Subject Test Codes to determine if this row of SCC_STG_TEST should be created. If no codes are present, the row is not created.

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:

  • SAT_REV_SC_IND1 for SAT Revised Score Indicator 1

  • SAT_LAT_ESS_ID for Latest SAT Essay ID

  • SAT_ESS_ID_AD2 for SAT Essay ID Admin 2

  • SAT_ESS_ID_AD3 for SAT Essay ID Admin 3

  • SAT_READ_ST_PCT for Reading State Percentile

  • SAT_MATH_ST_PCT for Mathematics State Percentile

  • SAT_WR_ST_PCT for Writing State Percentile

These attributes should be associated with the ADM_PRSPCT_CAR record context:

  • SAT_GRD_PT_AVG for Grade Point Average

  • SAT_HS_CLASSRANK for High School Class Rank

  • SAT_DEGR_GOAL for Degree Goal

  • SAT_PART_TM_JOB for Part-Time Job

  • SAT_FIRST_LANG for First Language

  • SAT_BEST_LANG for Best Language

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

  • College Code

  • Residence Code

  • EPS Market

  • Foreign Address Indicator

  • SAT Revised Score Indicator 2

  • SAT Revised Score Indicator 3

  • SAT Revised Score Indicator 4

  • SAT Revised Score Indicator 5

  • SAT Revised Score Indicator 6

  • Revised Score Indicator 1

  • Subject Test 1-1 Subscore 1

  • Subject Test 1-1 Subscore 2

  • Subject Test 1-1 Subscore 3

  • Subject Test 1-2 Subscore 1

  • Subject Test 1-2 Subscore 2

  • Subject Test 1-2 Subscore 3

  • Subject Test 1-3 Subscore 1

  • Subject Test 1-3 Subscore 2

  • Subject Test 1-3 Subscore 3

  • Subject Test 2-1 Subscore 1

  • Subject Test 2-1 Subscore 2

  • Subject Test 2-1 Subscore 3

  • Subject Test 2-2 Subscore 1

  • Subject Test 2-2 Subscore 2

  • Subject Test 2-2 Subscore 3

  • Subject Test 2-3 Subscore 1

  • Subject Test 2-3 Subscore 2

  • Subject Test 2-3 Subscore 3

  • Subject Test 3-1 Subscore 1

  • Subject Test 3-1 Subscore 2

  • Subject Test 3-1 Subscore 3

  • Subject Test 3-2 Subscore 1

  • Subject Test 3-2 Subscore 2

  • Subject Test 3-2 Subscore 3

  • Subject Test 3-3 Subscore 1

  • Subject Test 3-3 Subscore 2

  • Subject Test 3-3 Subscore 3

  • Subject Test 4-1 Subscore 1

  • Subject Test 4-1 Subscore 2

  • Subject Test 4-1 Subscore 3

  • Subject Test 4-2 Subscore 1

  • Subject Test 4-2 Subscore 2

  • Subject Test 4-2 Subscore 3

  • Subject Test 4-3 Subscore 1

  • Subject Test 4-3 Subscore 2

  • Subject Test 4-3 Subscore 3

  • Subject Test 5-1 Subscore 1

  • Subject Test 5-1 Subscore 2

  • Subject Test 5-1 Subscore 3

  • Subject Test 5-2 Subscore 1

  • Subject Test 5-2 Subscore 2

  • Subject Test 5-2 Subscore 3

  • Subject Test 5-3 Subscore 1

  • Subject Test 5-3 Subscore 2

  • Subject Test 5-3 Subscore 3

  • Subject Test 6-1 Subscore 1

  • Subject Test 6-1 Subscore 2

  • Subject Test 6-1 Subscore 3

  • Subject Test 6-2 Subscore 1

  • Subject Test 6-2 Subscore 2

  • Subject Test 6-2 Subscore 3

  • Subject Test 6-3 Subscore 1

  • Subject Test 6-3 Subscore 2

  • Subject Test 6-3 Subscore 3

  • Reading State Percentile

  • Mathematics State Percentile

  • Writing State Percentile

  • Subject Test 1 Subscore 1 %ile

  • Subject Test 1 Subscore 2 %ile

  • Subject Test 1 Subscore 3 %ile

  • Subject Test 2 Subscore 1 %ile

  • Subject Test 2 Subscore 2 %ile

  • Subject Test 2 Subscore 3 %ile

  • Subject Test 3 Subscore 1 %ile

  • Subject Test 3 Subscore 2 %ile

  • Subject Test 3 Subscore 3 %ile

  • Arts and Music Years

  • English Years

  • Foreign and Classical Languages Years

  • Mathematics Years

  • Natural Sciences Years

  • Social Sciences and History Years

  • Chinese Years

  • French Years

  • German Years

  • Greek Years

  • Hebrew Years

  • Italian Years

  • Japanese Years

  • Korean Years

  • Latin Years

  • Russian Years

  • Spanish Years

  • Other Language Course Years

  • Algebra Years

  • Geometry Years

  • Trigonometry Years

  • Precalculus Years

  • Calculus Years

  • Computer Math (no longer reported) Years

  • Other Math Course Years

  • Biology Years

  • Chemistry Years

  • Environmental, Earth, or Space Science Years

  • Physics Years

  • Other Science Course Years

  • U.S. History Years

  • U.S. Gov’t/Civics Years

  • European History Years

  • World History Years

  • Ancient History Years

  • Anthropology (no longer reported) Years

  • Economics Years

  • Geography Years

  • Psychology Years

  • Sociology Years

  • Other Social Science or History Course Years

  • Arts and Music GPA

  • English GPA

  • Foreign and Classical Languages GPA

  • Mathematics GPA

  • Natural Sciences GPA

  • Social Sciences and History GPA

  • American Literature

  • British Literature

  • Composition

  • English Language Arts

  • Literature (other than US or British)

  • Communications

  • Public Speaking

  • English as a Second Language

  • Art/Music no experience

  • Acting/Production of a Play

  • Art Hist. or Appreciation

  • Dance

  • Drama or Theater for Appreciation

  • Music History, Theory, or Appreciation

  • Music, Instrumental or Vocal Performance

  • Photography or Filmmaking

  • Studio Art and Design

  • Computer No Experience

  • Computer Basic Concepts

  • Computer Word Processing

  • Computer Programming

  • Computer Use Spreadsheets/Databases

  • Computer Graphics

  • Computer Internet Activities

  • High School/Community/Activities

  • H.S. Activity Designator 1

  • 9th Grade Activity 1

  • 10th Grade Activity 1

  • 11th Grade Activity 1

  • 12th Grade Activity 1

  • Office/Award Activity 1

  • H.S. Activity Designator 2

  • 9th Grade Activity 2

  • 10th Grade Activity 2

  • 11th Grade Activity 2

  • 12th Grade Activity 2

  • Office/Award Activity 2

  • H.S. Activity Designator 3

  • 9th Grade Activity 3

  • 10th Grade Activity 3

  • 11th Grade Activity 3

  • 12th Grade Activity 3

  • Office/Award Activity 3

  • H.S. Activity Designator 4

  • 9th Grade Activity 4

  • 10th Grade Activity 4

  • 11th Grade Activity 4

  • 12th Grade Activity 4

  • Office/Award Activity 4

  • H.S. Activity Designator 5

  • 9th Grade Activity 5

  • 10th Grade Activity 5

  • 11th Grade Activity 5

  • 12th Grade Activity 5

  • Office/Award Activity 5

  • H.S. Activity Designator 6

  • 9th Grade Activity 6

  • 10th Grade Activity 6

  • 11th Grade Activity 6

  • 12th Grade Activity 6

  • Office/Award Activity 6

  • H.S. Activity Designator 7

  • 9th Grade Activity 7

  • 10th Grade Activity 7

  • 11th Grade Activity 7

  • 12th Grade Activity 7

  • Office/Award Activity 7

  • H.S. Activity Designator 8

  • 9th Grade Activity 8

  • 10th Grade Activity 8

  • 11th Grade Activity 8

  • 12th Grade Activity 8

  • Office/Award Activity 8

  • H.S. Activity Designator 9

  • 9th Grade Activity 9

  • 10th Grade Activity 9

  • 11th Grade Activity 9

  • 12th Grade Activity 9

  • Office/Award Activity 9

  • H.S. Activity Designator 10

  • 9th Grade Activity 10

  • 10th Grade Activity 10

  • 11th Grade Activity 10

  • 12th Grade Activity 10

  • Office/Award Activity 10

  • Sports

  • Sport Designator 1

  • Sport Designator 2

  • Sport Designator 3

  • Sport Designator 4

  • Sport Designator 5

  • Sport Designator 6

  • 4-Year College or University

  • 2-Year Community or Junior College

  • Vocational/Technical School

  • 2 or 4 Year Undecided

  • Public University or College

  • Private University or College (not religiously affiliated)

  • Private, Religiously Affiliated University or College

  • Private, Public Undecided

  • Fewer than 2,000 Students

  • 2,000–5,000 Students

  • 5,000–10,000 Students

  • 10,000–20,000 Students

  • More than 20,000 Students

  • Size Undecided

  • Large City or Metropolitan Area

  • Medium-Size City

  • Small City or Town

  • Suburban Community

  • Rural

  • Setting Undecided

  • Close to Home

  • In My Home State

  • In States Bordering Mine

  • Beyond States Bordering Mine

  • Outside of the U.S

  • Location Undecided

  • All Women or All Men

  • Coeducational

  • Type Undecided

  • Art AP or Exempt

  • Biology AP or Exempt

  • Chemistry AP or Exempt

  • Computer Science AP or Exempt

  • English AP or Exempt

  • Foreign Language AP or Exempt

  • Humanities AP or Exempt

  • Mathematics AP or Exempt

  • Music AP or Exempt

  • Physics AP or Exempt

  • Social Studies AP or Exempt

  • No Plans to Apply AP or Exempt

  • Educational Plans Requested Services

  • Career Plans Requested Services

  • Study Skills Requested Services

  • Math Skills Requested Services

  • Reading Skills Requested Services

  • Writing Skills Requested Services

  • No Plans for Help Requested Services

  • High School Name

  • High School Address 1

  • High School Address 2

  • High School Address 3

  • High School Telephone Number

  • High School Type

  • Senior Class Size

  • Percent of Seniors Going to College

  • Location of High School

  • Number of Advanced Placement Program® Courses Offered

  • Honors Courses Offered

  • Units to Graduate

  • Date of Report

To complete setup for the delivered common attributes, see: