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