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. 

  1. Navigate to Admissions > Common App Upload 

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

  3. In the Application Source drop down choose COMMONAPP 

  4. Click Submit