About Common Application Set up
...
An admissions portal in Campus Cafe must be configured to receive the incoming Common Application data. Campus Cafe recommends the name of this form not contain spaces.
Refer to the admissions portal documentation for information on setting up a form.
...
Some values in the Common Application are delivered while others must be mapped.
Here is a table of the STPARM codes and the corresponding columns in the Common Application file that can be mapped. Please note that if a column is not mapped in the STPARM table, it will not be uploaded to the student’s record.
| Note |
|---|
It is the responsibility of the customer to create all relevant field mappings. |
Please note all values are “,” separated with the exception that we us [] to separate values that contain the “,” character.
TABLE.FIELDNAME | STPARM CODE | STPARM VALUE | COMMON APP COLUMN | COMMON APP VALUE (or example value) |
STBIOS.TRANSFER_CODE | SBTRCD | TC, G, FH | Student Type | College/Transfer, First-YearGED, High School |
STBIOS.ADMISSIONS_ENT_SEM | WBIQSM | 201310 (example of Fall 2012) | Two possible columns: “preferred start term” (if first time freshman) “TR Preferred start term” (only for transfer students) | Fall 2012 |
STBIOS.ADMISSIONS_RES_CODE | SBRSCD | R, C, blank | Two possible columns: “Preferred residence” (if first time freshman) “TRPreferred residence” (only for transfer students) | Commuter, Resident, Blank (defaults to C) |
STBIOS.SEX | SBSTSX | M,F,U | Sex | M,F |
STBIOS.US_CITIZENSHIP | SBUSCD | Customizable | Citizenship Status | “U.S. Citizen or U.S. National” |
ADMAST.ACTION_TYPE | ACACTY | Customizable | Two possible columns: “Admission Plan” and “TRAdmission Plan” | Examples: Regular Decision, Rolling Admission, Early Action, Early Action 2 |
STBIOS.FIN_AID_CODE
| SBFACD | Y,N | financial aid, TR Financial aid | Examples: Yes, No OR Y,N |
STBIOS.HOME_COUNTRY | XXXXCN | See STPARM table | Perm Country Current Country Parent 1 and 2 Country | Common app country codes listed in Appendix A |
Common App Columns requiring Triggers
| Info |
|---|
The customer must configure the below triggers. |
Trigger Name | WORKFLOW Name | Use | Common App Column (depends on transfer or non-transfer student. Multiple Columns in upload file) | ADFMRQ.COMMON_APP_CODE |
TRANHS01-08 | TRANHS01-08 | Track previous high schools. Adds TRK_ACTIVITY_TRACKING corresponding TRANHSXX record and updates STBIOS.SCHOOL_CODE ( updates STBIOS only from first previous high school) | Multiple Columns “School lookup – CeebCode” “TR School lookup – CeebCode” | Not needed |
TRANCOL01-03 | TRANCOL01-03 | Track previous Colleges. Adds TRK_ACTIVITY_TRACKING corresponding TRANCOLXX record and updates STBIOS.PREV_COLLEGE_ATTED (only first previous college will update STBIOS) | Multiple Columns “TR College 1 lookup – CeebCode” “TR College 2 lookup – CeebCode” “TR College 3 lookup – CeebCode”
| Not needed |
OTH | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 1 Name | OTH |
OTHER2 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 2 Name | OTH2 |
OTHER3 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 3 Name | OTH3 |
OTHER4 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 4 Name | OTH4 |
OTHER5 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 5 Name | OTH5 |
OTHER6 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 6 Name | OTH6 |
OTHER7 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 7 Name | OTH7 |
OTHER8 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 8 Name | OTH8 |
OTHER9 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 9 Name | OTH9 |
OTHER10 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 10 Name | OTH10 |
OTHER11 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 11 Name | OTH11 |
OTHER12 | Customizable | Adds first instance of OTH values from common app to TRK_ACTIVITY_TRACKING | Activity 12 Name | OTH12 |
(Activity Codes) | Customizable | Adds TRK_ACTIVITY_TRACKING record mapped to custom TRK_TEMPLATE_HEADER and ADFMRQ Records | Various | See valid list in Appendix A |
...