Law School Admission Test (LSAT)

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.

Note:

The following incoming Ethnic Super Categories values were not mapped: CD - Canadian Aboriginal, AT - Aboriginal or Torres Strait Islander Australian and NI - Not Indicated.

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:

Important:

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

Modify the conversion definition to the one you have created.

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

Important:

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

Modify the conversion definition to the one you have created.

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

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