About Common Application Set up
...
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 |
...