About Common Application Set up
...
Here is a table of the STPARM codes and the corresponding columns in the Common Application file that can be mapped. Please note that if a column is not mapped in the STPARM table, it will not be uploaded to the student’s record.
Note |
---|
It is the responsibility of the customer to create all relevant field mappings. |
Please note all values are “,” separated with the exception that we us [] to separate values that contain the “,” character.
TABLE.FIELDNAME | STPARM CODE | STPARM VALUE | COMMON APP COLUMN | COMMON APP VALUE (or example value) |
STBIOS.TRANSFER_CODE | SBTRCD | T, F | Student Type | Transfer , First-Year |
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 |
...