Set up Common Application

About Common Application Set up

Campus Café provides Common Application data upload in the form of an import utility. The Common Application is used by over 400 member institutions, both public and private, large and small, and support for this universally accepted admissions process can streamline the application process.

The Campus Cafe import process imports only the standard data associated with the application; it does not import any documents or attachments.

Applications from other sources can potentially be uploaded using this utility as long as the data is in the Common Application upload format.

Create Admissions Portal

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.

Once set up, enter the name of the form in Custom Control (Admin > Custom Control Maintenance) COMMONAPP, Sequence 1, Parameter 2.

Create STPARM Mappings

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.

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	C, G, H	Student Type	College/Transfer, GED, 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

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

Other Codes

The Common Application allows you to select multiple activity codes. The OTH activity code is a special case where you can select the same code multiple times if your activity is not listed. Therefore, the activity1 column may contain OTH as well as activity 2 and 3 and so forth... Adjacent columns to each activity code column allow the prospect to add text descriptions to include explanations of their activity.

Currently our admissions portal only allows you to select each trigger once. This makes sense as if you selected "I am interested in baseball" 3 times it would only express your interest once.

However, in the common app upload this is a problem since we also need to capture comments for each time you select it. This is especially an issue since there is an activity called "Other" coded as OTH. An applicant could conceivably select "other" up to 12 times with 12 different comments, and we would need to capture that information each time.

The solution is to create 12 records in table ADFMRQ:
Record 1 would have COMMON_APP_CODE of OTH and TRIGGER_NAME most likely of OTHER.
Record 2 would have COMMON_APP_CODE of OTH2 and TRIGGER_NAME most likely of OTHER2.
Record 3 would have COMMON_APP_CODE of OTH3 and TRIGGER_NAME most likely of OTHER3.

Etc…

The triggers can be named whatever you want, as long as they are all different. As stated above, if the same trigger is selected multiple times then only one of them is captured.

Also, 12 Workflows need to be created, one for each REQUEST_TRIGGER.

Campus Café assumes that each activity could only be selected once, and that the OTH is a special case.

Common App Codes for Majors, States, Countries, and Activities

Common App Major Codes

Export Code column = value that should go in our STMAJR common_app_code column. Customer should pick export code value closest to their own major code. The latest mappings for these tables can be found at www.commonapp.org

Choice Group Name	Order	Label	Export Code	Label Length	Code Length
Career interest	1	Undecided	Undecided	9	9
Career interest	2	Accounting	Accounting	10	10
Career interest	3	Agriculture	Agriculture	11	11
Career interest	4	Architecture	Architecture	12	12
Career interest	5	Area, ethnic, cultural and gender studies	Area_Ethnic_Cultural_Gender_Studies	41	35
Career interest	6	Art History	Art_History	11	11
Career interest	7	Arts - Performing	Arts_Performing	17	15
Career interest	8	Arts - Performing (Dance)	Arts_Performing_Dance	25	21
Career interest	9	Arts - Performing (Drama/Theater)	Arts_Performing_Drama_Theater	33	29
Career interest	10	Arts - Performing (Music -Instrumental/Theory and Composition)	Arts_Performing_Music_Instrumental_Theory_Composition	62	53
Career interest	11	Arts - Performing (Vocal Music)	Arts_Performing_Vocal_Music	31	27
Career interest	12	Arts - Visual	Arts_Visual	13	11
Career interest	13	Arts - Visual (Film/Cinematography)	Arts_Visual_Film_Cinematography	35	31
Career interest	14	Arts - Visual (Studio Art)	Arts_Visual_Studio_Art	26	22
Career interest	15	Biological and biomedical sciences	Biological_Biomedical_Sciences	34	30
Career interest	16	Biology	Biology	7	7
Career interest	17	Business	Business	8	8
Career interest	18	Chemistry	Chemistry	9	9
Career interest	19	Communication	Communication	13	13
Career interest	20	Computer and information sciences	Computer_Information_Sciences	33	29
Career interest	21	Economics	Economics	9	9
Career interest	22	Education	Education	9	9
Career interest	23	Elementary education and teaching	Elementary_education_and_teaching	33	33
Career interest	24	Engineering	Engineering	11	11
Career interest	25	Engineering - Chemical	Engineering_Chemical	22	20
Career interest	26	Engineering - Civil	Engineering_Civil	19	17
Career interest	27	Engineering - Computer	Engineering_Computer	22	20
Career interest	28	Engineering - Mechanical	Engineering_Mechanical	24	22
Career interest	29	Engineering technologies/technicians	Engineering_technologies_technicians	36	36
Career interest	30	English language and literature	English_language_and_literature	31	31
Career interest	31	Environmental Studies and Natural Resources	Environmental_Studies_and_Natural_Resources	43	43
Career interest	32	Finance	Finance	7	7
Career interest	33	Foreign languages, literatures, and linguistics	Foreign_languages,_literatures,_and_linguistics	47	47
Career interest	34	Health professions and related clinical services	Health_professions_and_related_clinical_services	48	48
Career interest	35	History	History	7	7
Career interest	36	Home Economics	Home_Economics	14	14
Career interest	37	International Relations	International_Relations	23	23
Career interest	38	Journalism	Journalism	10	10
Career interest	39	Language and Literature	Language_and_Literature	23	23
Career interest	40	Liberal arts and sciences, general studies, and humanities	Liberal_arts_and_sciences,_general_studies,_and_humanities	58	58
Career interest	41	Library sciences/librarianship	Library_sciences_librarianship	30	30
Career interest	42	Marketing	Marketing	9	9
Career interest	43	Mathematics and statistics	Mathematics_and_statistics	26	26
Career interest	44	Mechanic and repair technologies/technician	Mechanic_and_repair_technologies_technician	43	43
Career interest	45	Military sciences	Military sciences	17	17
Career interest	46	Nursing	Nursing	7	7
Career interest	47	Other	Other	5	5
Career interest	48	Philosophy	Philosophy	10	10
Career interest	49	Physical Sciences	Physical_Sciences	17	17
Career interest	50	Physics	Physics	7	7
Career interest	51	Political Science	Political_Science	17	17
Career interest	52	Pre-law	Pre-law	7	7
Career interest	53	Pre-medicine	Pre-medicine	12	12
Career interest	54	Psychology	Psychology	10	10
Career interest	55	Public affairs and services	Public_affairs_and_services	27	27
Career interest	56	Religious Studies/Theology	Religious_Studies_Theology	26	26
Career interest	57	Social Sciences	Social_Sciences	15	15

Common App US States

Export Code column = value that should go in our STPARM XXSTAT common_app_code column.

Choice Group Name	Order	Label	Export Code	Label Length	Code Length
US State list	1	Armed Forces Americas	AA	21	2
US State list	2	Armed Forces Europe	AE	19	2
US State list	3	Alaska	AK	6	2
US State list	4	Alabama	AL	7	2
US State list	5	Armed Forces Pacific	AP	20	2
US State list	6	Arkansas	AR	8	2
US State list	7	American Samoa	AS	14	2
US State list	8	Arizona	AZ	7	2
US State list	9	California	CA	10	2
US State list	10	Colorado	CO	8	2
US State list	11	Connecticut	CT	11	2
US State list	12	District of Columbia	DC	20	2
US State list	13	Delaware	DE	8	2
US State list	14	Florida	FL	7	2
US State list	15	Federated States of Micronesia	FM	30	2
US State list	16	Georgia	GA	7	2
US State list	17	Guam	GU	4	2
US State list	18	Hawaii	HI	6	2
US State list	19	Iowa	IA	4	2
US State list	20	Idaho	ID	5	2
US State list	21	Illinois	IL	8	2
US State list	22	Indiana	IN	7	2
US State list	23	Kansas	KS	6	2
US State list	24	Kentucky	KY	8	2
US State list	25	Louisiana	LA	9	2
US State list	26	Massachusetts	MA	13	2
US State list	27	Maryland	MD	8	2
US State list	28	Maine	ME	5	2
US State list	29	Marshall Islands	MH	16	2
US State list	30	Michigan	MI	8	2
US State list	31	Minnesota	MN	9	2
US State list	32	Missouri	MO	8	2
US State list	33	Northern Mariana Islands	MP	24	2
US State list	34	Mississippi	MS	11	2
US State list	35	Montana	MT	7	2
US State list	36	North Carolina	NC	14	2
US State list	37	North Dakota	ND	12	2
US State list	38	Nebraska	NE	8	2
US State list	39	New Hampshire	NH	13	2
US State list	40	New Jersey	NJ	10	2
US State list	41	New Mexico	NM	10	2
US State list	42	Nevada	NV	6	2
US State list	43	New York	NY	8	2
US State list	44	Ohio	OH	4	2
US State list	45	Oklahoma	OK	8	2
US State list	46	Oregon	OR	6	2
US State list	47	Pennsylvania	PA	12	2
US State list	48	Puerto Rico	PR	11	2
US State list	49	Palau	PW	5	2
US State list	50	Rhode Island	RI	12	2
US State list	51	South Carolina	SC	14	2
US State list	52	South Dakota	SD	12	2
US State list	53	Tennessee	TN	9	2
US State list	54	Texas	TX	5	2
US State list	55	Utah	UT	4	2
US State list	56	Virginia	VA	8	2
US State list	57	Virgin Islands	VI	14	2
US State list	58	Vermont	VT	7	2
US State list	59	Washington	WA	10	2
US State list	60	Wisconsin	WI	9	2
US State list	61	West Virginia	WV	13	2
US State list	62	Wyoming	WY	7	2

Common App Country Codes

Export Code column = value that should go in our STPARM XXXXCN common_app_code column.

Choice Group Name	Order	Label	Export Code	Label Length	Code Length
Country	1	United States of America	USA	24	3
Country	2	Canada	CAN	6	3
Country	3	Afghanistan	AFG	11	3
Country	4	Aland Islands	ALA	13	3
Country	5	Albania	ALB	7	3
Country	6	Algeria	DZA	7	3
Country	7	American Samoa	ASM	14	3
Country	8	Andorra	AND	7	3
Country	9	Angola	AGO	6	3
Country	10	Anguilla	AIA	8	3
Country	11	Antarctica	ATA	10	3
Country	12	Antigua And Barbuda	ATG	19	3
Country	13	Argentina	ARG	9	3
Country	14	Armenia	ARM	7	3
Country	15	Aruba	ABW	5	3
Country	16	Australia	AUS	9	3
Country	17	Austria	AUT	7	3
Country	18	Azerbaijan	AZE	10	3
Country	19	Bahamas	BHS	7	3
Country	20	Bahrain	BHR	7	3
Country	21	Bangladesh	BGD	10	3
Country	22	Barbados	BRB	8	3
Country	23	Belarus	BLR	7	3
Country	24	Belgium	BEL	7	3
Country	25	Belize	BLZ	6	3
Country	26	Benin	BEN	5	3
Country	27	Bermuda	BMU	7	3
Country	28	Bhutan	BTN	6	3
Country	29	Bolivia	BOL	7	3
Country	30	Bosnia And Herzegovina	BIH	22	3
Country	31	Botswana	BWA	8	3
Country	32	Bouvet Island	BVT	13	3
Country	33	Brazil	BRA	6	3
Country	34	British Indian Ocean Territory	IOT	30	3
Country	35	Brunei Darussalam	BRN	17	3
Country	36	Bulgaria	BGR	8	3
Country	37	Burkina Faso	BFA	12	3
Country	38	Burundi	BDI	7	3
Country	39	Cambodia	KHM	8	3
Country	40	Cameroon	CMR	8	3
Country	41	Cape Verde	CPV	10	3
Country	42	Cayman Islands	CYM	14	3
Country	43	Central African Republic	CAF	24	3
Country	44	Chad	TCD	4	3
Country	45	Chile	CHL	5	3
Country	46	China	CHN	5	3
Country	47	Christmas Island	CXR	16	3
Country	48	Cocos (Keeling) Islands	CCK	23	3
Country	49	Colombia	COL	8	3
Country	50	Comoros	COM	7	3
Country	51	Congo	COG	5	3
Country	52	Congo, The Democratic Republic Of The	COD	37	3
Country	53	Cook Islands	COK	12	3
Country	54	Costa Rica	CRI	10	3
Country	55	Cote D'Ivoire	CIV	13	3
Country	56	Croatia	HRV	7	3
Country	57	Cuba	CUB	4	3
Country	58	Cyprus	CYP	6	3
Country	59	Czech Republic	CZE	14	3
Country	60	Denmark	DNK	7	3
Country	61	Djibouti	DJI	8	3
Country	62	Dominica	DMA	8	3
Country	63	Dominican Republic	DOM	18	3
Country	64	Ecuador	ECU	7	3
Country	65	Egypt	EGY	5	3
Country	66	El Salvador	SLV	11	3
Country	67	Equatorial Guinea	GNQ	17	3
Country	68	Eritrea	ERI	7	3
Country	69	Estonia	EST	7	3
Country	70	Ethiopia	ETH	8	3
Country	71	Faroe Islands	FRO	13	3
Country	72	Falkland Islands (Malvinas)	FLK	27	3
Country	73	Fiji	FJI	4	3
Country	74	Finland	FIN	7	3
Country	75	France	FRA	6	3
Country	76	French Guiana	GUF	13	3
Country	77	French Polynesia	PYF	16	3
Country	78	French Southern Territories	ATF	27	3
Country	79	Gabon	GAB	5	3
Country	80	Gambia, The	GMB	11	3
Country	81	Georgia	GEO	7	3
Country	82	Germany	DEU	7	3
Country	83	Ghana	GHA	5	3
Country	84	Gibraltar	GIB	9	3
Country	85	Greece	GRC	6	3
Country	86	Greenland	GRL	9	3
Country	87	Grenada	GRD	7	3
Country	88	Guadeloupe	GLP	10	3
Country	89	Guatemala	GTM	9	3
Country	90	Guernsey	GGY	8	3
Country	91	Guinea	GIN	6	3
Country	92	Guinea-Bissau	GNB	13	3
Country	93	Guyana	GUY	6	3
Country	94	Haiti	HTI	5	3
Country	95	Heard Island And Mcdonald Islands	HMD	33	3
Country	96	Holy See (Vatican City State)	VAT	29	3
Country	97	Honduras	HND	8	3
Country	98	Hong Kong	HKG	9	3
Country	99	Hungary	HUN	7	3
Country	100	Iceland	ISL	7	3
Country	101	India	IND	5	3
Country	102	Indonesia	IDN	9	3
Country	103	Iran, Islamic Republic Of	IRN	25	3
Country	104	Iraq	IRQ	4	3
Country	105	Ireland	IRL	7	3
Country	106	Isle of Man	IMN	11	3
Country	107	Israel	ISR	6	3
Country	108	Italy	ITA	5	3
Country	109	Jamaica	JAM	7	3
Country	110	Japan	JPN	5	3
Country	111	Jersey	JEY	6	3
Country	112	Jordan	JOR	6	3
Country	113	Kazakhstan	KAZ	10	3
Country	114	Kenya	KEN	5	3
Country	115	Kiribati	KIR	8	3
Country	116	Korea, Democratic People's Republic Of	PRK	38	3
Country	117	Korea, Republic Of	KOR	18	3
Country	118	Kuwait	KWT	6	3
Country	119	Kyrgyzstan	KGZ	10	3
Country	120	Lao	LAO	3	3
Country	121	Latvia	LVA	6	3
Country	122	Lebanon	LBN	7	3
Country	123	Lesotho	LSO	7	3
Country	124	Liberia	LBR	7	3
Country	125	Libya	LBY	5	3
Country	126	Liechtenstein	LIE	13	3
Country	127	Lithuania	LTU	9	3
Country	128	Luxembourg	LUX	10	3
Country	129	Macao	MAC	5	3
Country	130	Macedonia, The Former Yugoslav Republic Of	MKD	42	3
Country	131	Madagascar	MDG	10	3
Country	132	Malawi	MWI	6	3
Country	133	Malaysia	MYS	8	3
Country	134	Maldives	MDV	8	3
Country	135	Mali	MLI	4	3
Country	136	Malta	MLT	5	3
Country	137	Marshall Islands	MHL	16	3
Country	138	Martinique	MTQ	10	3
Country	139	Mauritania	MRT	10	3
Country	140	Mauritius	MUS	9	3
Country	141	Mayotte	MYT	7	3
Country	142	Mexico	MEX	6	3
Country	143	Moldova, Republic Of	MDA	20	3
Country	144	Monaco	MCO	6	3
Country	145	Mongolia	MNG	8	3
Country	146	Montenegro	MNE	10	3
Country	147	Montserrat	MSR	10	3
Country	148	Morocco	MAR	7	3
Country	149	Mozambique	MOZ	10	3
Country	150	Myanmar	MMR	7	3
Country	151	Namibia	NAM	7	3
Country	152	Nauru	NRU	5	3
Country	153	Nepal	NPL	5	3
Country	154	Netherlands	NLD	11	3
Country	155	Netherlands Antilles	ANT	20	3
Country	156	New Caledonia	NCL	13	3
Country	157	New Zealand	NZL	11	3
Country	158	Nicaragua	NIC	9	3
Country	159	Niger	NER	5	3
Country	160	Nigeria	NGA	7	3
Country	161	Niue	NIU	4	3
Country	162	Norfolk Island	NFK	14	3
Country	163	Northern Mariana Islands	MNP	24	3
Country	164	Norway	NOR	6	3
Country	165	Oman	OMN	4	3
Country	166	Pakistan	PAK	8	3
Country	167	Palau	PLW	5	3
Country	168	Palestinian Territory, Occupied	PSE	31	3
Country	169	Panama	PAN	6	3
Country	170	Papua New Guinea	PNG	16	3
Country	171	Paraguay	PRY	8	3
Country	172	Peru	PER	4	3
Country	173	Philippines	PHL	11	3
Country	174	Pitcairn	PCN	8	3
Country	175	Poland	POL	6	3
Country	176	Portugal	PRT	8	3
Country	177	Qatar	QAT	5	3
Country	178	Reunion	REU	7	3
Country	179	Romania	ROU	7	3
Country	180	Russian Federation	RUS	18	3
Country	181	Rwanda	RWA	6	3
Country	182	Saint Helena	SHN	12	3
Country	183	Saint Kitts And Nevis	KNA	21	3
Country	184	Saint Lucia	LCA	11	3
Country	185	Saint Pierre And Miquelon	SPM	25	3
Country	186	Saint Vincent And The Grenadines	VCT	32	3
Country	187	Saint-Barthelemy	BLM	16	3
Country	188	Saint-Martin (French Part)	MAF	26	3
Country	189	Samoa	WSM	5	3
Country	190	San Marino	SMR	10	3
Country	191	Sao Tome and Principe	STP	21	3
Country	192	Saudi Arabia	SAU	12	3
Country	193	Senegal	SEN	7	3
Country	194	Serbia	SRB	6	3
Country	195	Seychelles	SYC	10	3
Country	196	Sierra Leone	SLE	12	3
Country	197	Singapore	SGP	9	3
Country	198	Slovakia	SVK	8	3
Country	199	Slovenia	SVN	8	3
Country	200	Solomon Islands	SLB	15	3
Country	201	Somalia	SOM	7	3
Country	202	South Africa	ZAF	12	3
Country	203	South Georgia And The South Sandwich Islands	SGS	44	3
Country	204	Spain	ESP	5	3
Country	205	Sri Lanka	LKA	9	3
Country	206	Sudan	SDN	5	3
Country	207	Suriname	SUR	8	3
Country	208	Svalbard And Jan Mayen	SJM	22	3
Country	209	Swaziland	SWZ	9	3
Country	210	Sweden	SWE	6	3
Country	211	Switzerland	CHE	11	3
Country	212	Syrian Arab Republic	SYR	20	3
Country	213	Taiwan, Province Of China	TWN	25	3
Country	214	Tajikistan	TJK	10	3
Country	215	Tanzania, United Republic Of	TZA	28	3
Country	216	Thailand	THA	8	3
Country	217	Timor-Leste	TLS	11	3
Country	218	Togo	TGO	4	3
Country	219	Tokelau	TKL	7	3
Country	220	Tonga	TON	5	3
Country	221	Trinidad and Tobago	TTO	19	3
Country	222	Tunisia	TUN	7	3
Country	223	Turkey	TUR	6	3
Country	224	Turkmenistan	TKM	12	3
Country	225	Turks And Caicos Islands	TCA	24	3
Country	226	Tuvalu	TUV	6	3
Country	227	Uganda	UGA	6	3
Country	228	Ukraine	UKR	7	3
Country	229	United Arab Emirates	ARE	20	3
Country	230	United Kingdom	GBR	14	3
Country	231	United States Minor Outlying Islands	UMI	36	3
Country	232	Uruguay	URY	7	3
Country	233	Uzbekistan	UZB	10	3
Country	234	Vanuatu	VUT	7	3
Country	235	Venezuela	VEN	9	3
Country	236	Viet Nam	VNM	8	3
Country	237	Virgin Islands, British	VGB	23	3
Country	238	Wallis And Futuna	WLF	17	3
Country	239	Western Sahara	ESH	14	3
Country	240	Yemen	YEM	5	3
Country	241	Zambia	ZMB	6	3
Country	242	Zimbabwe	ZWE	8	3
Country	243	Taiwan	TWN	6	3
Country	244	Curacao	CUW	7	3
Country	245	Sint Maarten (Dutch part)	SXM	25	3
Country	246	Bonaire, Saint Eustatius and Saba	BES	33	3
Country	247	Kosovo	XKX	6	3
Country	248	South Sudan	SSD	11	3
Country	249	Micronesia, Federated States of	FSM	31	3

Common App Activity/Interest Codes

(Must be mapped to a trigger in ADFMRQ)

Choice Group Name	Order	Label	Export Code	Label Length	Code Length
Activity type	1	Academic	Acad	8	4
Activity type	2	Art	ART	3	3
Activity type	3	Athletics: Club	Athletics_Club	15	14
Activity type	4	Athletics: JV/Varsity	Athletics_Varsity	21	17
Activity type	4	Career Oriented	Career	15	6
Activity type	5	Community Service (Volunteer)	Volunteer	29	9
Activity type	6	Computer/Technology	Computer	19	8
Activity type	7	Cultural	Cultural	8	8
Activity type	8	Dance	Dance	5	5
Activity type	9	Debate/Speech	Debate	13	6
Activity type	10	Environmental	Environmental	13	13
Activity type	11	Family Responsibilities	Family	23	6
Activity type	12	Foreign Exchange	Foreign_Exchange	16	16
Activity type	13	Foreign Language	Foreign_Lang	16	12
Activity type	14	Journalism/Publication	Journalism	22	10
Activity type	15	Junior R.O.T.C.	Jr_ROTC	15	7
Activity type	16	LGBT	LGBT	4	4
Activity type	17	Music: Instrumental	Instrumental	19	13
Activity type	18	Music: Vocal	Vocal	12	5
Activity type	19	Religious	Religious	9	9
Activity type	20	School Spirit	School_Spirit	13	13
Activity type	21	Science/Math	Science_Math	12	12
Activity type	22	Student Govt./Politics	Politics	22	8
Activity type	23	Theater/Drama	Drama	13	5
Activity type	24	Work (Paid)	Work	11	4
Activity type	25	Other Club/Activity	Other_Club	19	10
Activity name	1	Archery	Archery	7	7
Activity name	2	Badminton	Badminton	9	9
Activity name	3	Baseball	Baseball	8	8
Activity name	4	Basketball	Basketball	10	10
Activity name	5	Bowling	Bowling	7	7
Activity name	6	Boxing	Boxing	6	6
Activity name	7	Cheerleading	Cheerleading	12	12
Activity name	8	Cricket	Cricket	7	7
Activity name	9	Cross-country	Cross_country	13	13
Activity name	10	Diving	Diving	6	6
Activity name	11	Equestrian	Equestrian	10	10
Activity name	12	Fencing	Fencing	7	7
Activity name	13	Field Hockey	Field_Hockey	12	12
Activity name	14	Football	Football	8	8
Activity name	15	Football (non-tackle)	Non_tackle_football	21	19
Activity name	16	Golf	Golf	4	4
Activity name	17	Gymnastics	Gymnastics	10	10
Activity name	18	Handball	Handball	8	8
Activity name	19	Ice Hockey	Ice_Hockey	10	10
Activity name	20	Indoor Track	Indoor_Track	12	12
Activity name	21	Judo	Judo	4	4
Activity name	22	Lacrosse	Lacrosse	8	8
Activity name	23	Outdoor Track	Outdoor_Track	13	13
Activity name	24	Racquetball	Racquetball	11	11
Activity name	25	Rifle	Rifle	5	5
Activity name	26	Rodeo	Rodeo	5	5
Activity name	27	Rowing (Crew)	Rowing	13	6
Activity name	28	Rugby	Rugby	5	5
Activity name	29	Sailing	Sailing	7	7
Activity name	30	Skiing	Skiing	6	6
Activity name	31	Skin Diving	Skin_Diving	11	11
Activity name	32	Soccer	Soccer	6	6
Activity name	33	Softball	Softball	8	8
Activity name	34	Squash	Squash	6	6
Activity name	35	Swim	Swim	4	4
Activity name	36	Sync. swimming	Sync_Swim	14	9
Activity name	37	Table Tennis	Table_Tennis	12	12
Activity name	38	Tennis	Tennis	6	6
Activity name	39	Track and field	Track_ field	15	12
Activity name	40	Triathalon	Triathalon	10	10
Activity name	41	Volleyball	Volleyball	10	10
Activity name	42	Water polo	Water polo	10	10
Activity name	43	Weight lifting	Weight_lifting	14	14
Activity name	44	Wrestling	Wrestling	9	9
Activity name	45	Other Sport	OTH	11	3

Common Application Header Mappings

Common App Header Mappings	NOTE: header beginning with "tr" are alternates if corresponding header' data value is blank except for activity# which are always used
Last modified: 4/21/2016
Header Text	Domain	Table	Column	Helper Table/CODE	Note
student type	Person transfer code	STBIOS
preferred residence	Person admission residence code	STBIOS			Expected values Commuter & Resident
trpreferred residence	Person admission residence code	STBIOS
preferred start term	Person inquiry semester	STBIOS		STPARM/SMDESC
tr preferred start term	Person inquiry semester	STBIOS		STPARM/SMDESC
admission plan	Applicant action type	ADMAST		STPARM/ACACTY
tr admission plan	Applicant action type	ADMAST		STPARM/ACACTY
academics1 question1	Inquiry & App Major 1	STBIOS/ADMAST		STMAJR
tr academics1 question1	Inquiry & App Major 1	STBIOS/ADMAST		STMAJR
financial aid	Person financial aid code	STBIOS		STPARM/SBFACD
tr financial aid	Person financial aid code	STBIOS		STPARM/SBFACD
first name	Person first name	STBIOS
middle name	Person middle name	STBIOS
last name	Person last name	STBIOS
suffix	Person suffix	STBIOS			no validation
sex	Person sex	STBIOS		STPARM/SBSTSX
preferred name	Person nickname	STBIOS
date of birth	Person date of birth	STBIOS
ssn	Person social security number	STBIOS
religious preference	Person religious preference code	STBIOS		STPARM/SBRLPR
preferred phone	phone type				Expected values Home, Cell or Work
preferred phone number	Person/ExternalAddress phone	STBIOS/STADDR
alternate phone available	phone type				Expected values Home, Cell or Work
alternate phone number	Person/ExternalAddress phone	STBIOS/STADDR
email address	email address	STMAIL
permanent address - address1	Person home address	STBIOS
permanent address - address2	Person home address	STBIOS
permanent address - address3	Person home address	STBIOS
permanent address - city	Person home address	STBIOS
permanent address - state	Person home address	STBIOS		STPARM/XXSTAT
permanent address - zip	Person home address	STBIOS
permanent address - country	Person home address	STBIOS		STPARM/XXXXCN
current address - address1	Person local address	STBIOS
current address - address2	Person local address	STBIOS
current address - address3	Person local address	STBIOS
current address - city	Person local address	STBIOS
current address - state	Person local address	STBIOS		STPARM/XXSTAT
current address - zip	Person local address	STBIOS
current address - country	Person local address	STBIOS		STPARM/XXXXCN
citizenship status	Person citizenship status	STBIOS		STPARM SBUSCD
background	Person ethnicity	SBETNC			Supported values: Indian, Alaska, Asian, Black, African, Hawaiian, Pacific, White
hispanic latino	Person hispanic	SBETNC			Non-blank = true
first gen	Applicant first generation college	ADMAST			Expected value: First = true. If transfer always false
parent 1 first name	Parent1 first name	STBIOS/ALRELA
parent 1 last name	Parent1 last name	STBIOS/ALRELA
parent 1 email	Parent1 email	STMAIL/ALRELA
parent 1 address - address1	Parent1 home address	STBIOS/ALRELA
parent 1 address - address2	Parent1 home address	STBIOS/ALRELA
parent 1 address - address3	Parent1 home address	STBIOS/ALRELA
parent 1 address - city	Parent1 home address	STBIOS/ALRELA
parent 1 address - state	Parent1 home address	STBIOS/ALRELA		STPARM/XXSTAT
parent 1 address - zip	Parent1 home address	STBIOS/ALRELA
parent 1 address - country	Parent1 home address	STBIOS/ALRELA		STPARM/XXXXCN
parent 2 first name	Parent2 first name	STBIOS/ALRELA
parent 2 last name	Parent2 last name	STBIOS/ALRELA
parent 2 email	Parent2 email	STMAIL/ALRELA
parent 2 address - address1	Parent2 home address	STBIOS/ALRELA
parent 2 address - address2	Parent2 home address	STBIOS/ALRELA
parent 2 address - address3	Parent2 home address	STBIOS/ALRELA
parent 2 address - city	Parent2 home address	STBIOS/ALRELA
parent 2 address - state	Parent2 home address	STBIOS/ALRELA		STPARM/XXSTAT
parent 2 address - zip	Parent2 home address	STBIOS/ALRELA
parent 2 address - country	Parent2 home address	STBIOS/ALRELA		STPARM/XXXXCN
school lookup - ceebcode	Person secondary school CEEB code	STBIOS/TRK_ACTIVITY_TRACKING		Tracking possible	Person high school
tr school lookup - ceebcode	Person secondary school CEEB code	STBIOS/TRK_ACTIVITY_TRACKING		Tracking possible
school 2 lookup - ceebcode	Person secondary school CEEB code	STBIOS/TRK_ACTIVITY_TRACKING		Tracking possible
school 3 lookup - ceebcode	Person secondary school CEEB code	STBIOS/TRK_ACTIVITY_TRACKING		Tracking possible
tr college 1 lookup - ceebcode	Person post-secondary CEEB code	STBIOS/TRK_ACTIVITY_TRACKING		Tracking possible	Person college
tr college 2 lookup - ceebcode	Person post-secondary CEEB code	STBIOS/TRK_ACTIVITY_TRACKING		Tracking possible
tr college 3 lookup - ceebcode	Person post-secondary CEEB code	STBIOS/TRK_ACTIVITY_TRACKING		Tracking possible
activity 1 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 1 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 1 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
activity 2 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 2 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 2 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
activity 3 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 3 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 3 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
activity 4 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 4 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 4 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
activity 5 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 5 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 5 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
activity 6 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 6 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 6 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
activity 7 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 7 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 7 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
activity 8 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 8 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 8 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
activity 9 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 9 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 9 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
activity 10 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
activity 10 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
activity 10 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 1 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 1 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 2 type	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 1 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 2 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 2 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 3 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 3 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 3 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 4 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 4 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 4 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 5 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 5 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 5 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 6 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 6 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 6 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 7 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 7 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 7 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 8 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 8 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 8 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 9 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 9 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 9 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
tr activity 10 type	Tracking	TRK_ACTIVITY_TRACKING	comment_5	ADFMRQ
tr activity 10 name	Tracking	TRK_ACTIVITY_TRACKING		ADFMRQ	Triggers tracking on match of ADFMRQ common app code
tr activity 10 continue in college	Tracking	TRK_ACTIVITY_TRACKING	comment_6	ADFMRQ
parent 1 title	Person salutation	STBIOS
parent 2 title	Person salutation	STBIOS

Upload the Common App File

The standard data file, which does not include optional supplemental data or uploaded documents, is uploaded into Campus Café through the Common App Upload screen.

Navigate to Admissions > Common App Upload
Click the Browse button and select the Common App file In the Admissions Form drop down choose the Admissions Portal configured to accept the Common App data.
In the Application Source drop down choose COMMONAPP
Click Submit