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 |
...
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 Record 3 would have COMMON_APP_CODE of OTH3 and TRIGGER_NAME most likely of OTHER3.
...
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 |
...
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 |
...
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 |
...
(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 |
...