Data Dictionary

ID Number || Field 315

ID Numbers in the eComm (Harris Connect) system are the same ID Numbers that are found in Advance. The only difference is that there are 4 additional zeros preceding the ID Number in the eComm system. For example, if Johnny Appleseed’s ID Number in Advance is 123456, then his ID Number in eComm is 0000123456. This is how the two system ‘talk’ to each other. Typically, ID Numbers are 10 digits, including the preceding four zeros.

Prefix || Field 300

Field 300 is populated with a constituent's prefix, if available. Examples of a prefix are, "Mr." or "Mrs."

Personal Suffix || Field 301

Field 301 is populated with a constituent's personal suffix, if available.  A suffix follows a person's full name and provides additional information about the person. An example of a personal suffix is, "Johnny Appleseed III"

Professional Suffix || Field 302

Field 302 is populated with a constituent's professional suffix, if available.  A suffix follows a person's full name and provides additional information about the person. An example of a professional suffix is, "Johnny Appleseed, M.D." 

Last Name || Field 303

Constituent record's last name or full name of organizations (cuts off at 50 characters).

First Name || Field 304

Constituent record's first name. Organizations will have “Friend of CU” in this field.

Preferred Email Address || Field 305

The email address field is integrated with the Email Marketing tool, so whatever email address is in this field is what the email tool will send to. If a record has an email address in this field but is not receiving emails, the culprit is likely email preferences. Be sure to check the record’s email preferences (User Manager > View/Modify/Register User > (search and drill down into record) > Email Preferences tab. Look to see if the individual is either opted out of your email preference category or opted out of all emails. Email addresses are marked in the Advance Address Table as preferred OR the only email address.

Personal Website || Field 306

This field is populated when the individual updates their CU Link online community profile and adds a website URL to this field.

Record Status || Field 307


We remove records that are flagged as deceased (D) from all eComm admin permissions. This prevents any admin from ever emailing an email address that is tied to someone that is deceased.
We also remove records entirely from the eComm system on a monthly basis that are lost or flagged to be purged.
D = deceased
L = lost
X = to be purged

Date of Birth || Field 309

Data is presented in this format: mm/dd/yyyy Date of Birth information is excluded from all admin accounts for privacy purposes. As well, it is not searchable on the CU Link online community. Constituents can view and modify their date of birth on their CU Link profiles.

Marital Status || Field 310

Advance TableField NumberField CodeShort DescriptionFull Description
Marital Status310DDivorcedDivorced
Marital Status310FFormerly marriedFormerly married
Marital Status310MMarriedMarried
Marital Status310PDomestic PartnerDomestic Partner
Marital Status310RPartner at Time of DeathPartner at Time of Death
Marital Status310SSingleSingle
Marital Status310TWidowed (Partner)Widowed (Partner)
Marital Status310WWidowedWidowed
Marital Status310XSeparatedSeparated
Marital Status310YMarried at Time of DeathMarried at Time of Death


Middle Name || Field 311

Middle name is not always available. This field will be blank if we do not have their Middle Name on record.

Ethnicity/Race || Field 312


This information is used for alumni affinity group e-communications only. Administrators do not see individual records with ethnicity information. Ethnicity data is strictly protected. If information is available in the eComm and Advance systems, it was provided to CU by the constituent.

 

Advance TableField NumberField CodeShort DescriptionFull Description
Ethnicity312AAsianAsian
Ethnicity312BAfrican American/BlackAfrican American/Black
Ethnicity312HHispanic/LatinoHispanic/Latino
Ethnicity312HBHispanic/Latino/BlackHispanic/Latino/Black
Ethnicity312HWHispanic/Latino/WhiteHispanic/Latino/White
Ethnicity312MMulltiracial/MultiethnicMulltiracial/Multiethnic
Ethnicity312NNative American IndianNative American Indian
Ethnicity312PNative Hawaiian/Pacific IslanderNative Hawaiian/Pacific Islander
Ethnicity312WCaucasian/WhiteCaucasian/White


Student ID || Field 313

This information is transferred from the CU Student Information System (ISIS) for student and alumni records. Alumni records may not have student ID numbers if they graduated prior to 1980 (when student ID replaced social security numbers).

Security (Online Community authentication) || 314

This field is populated with one of three different ID numbers and used to authenticate someone when they are registering for the CU Link online community. Alumni, parents, donors, friends of CU and foundation staff members: Constituent record's ID Number. This is a 10-digit number (ie; 0000123456) and the same number that is found in field 315.Students: Student ID.Faculty and Staff: Employee ID.*Note: There are three pieces of information required to authenticate during the registration process.ID Number, F314 – this is not always the Constituent record's ID Number found in field 315 Last Name, F303Date of Birth year or Grad Year (for alumni only), F721

Maiden/Former Last Name || Field 316

Constituent record's maiden/former last name, if available.

Maiden/Former First Name || Field 317

Constituent record's maiden/former first name, if available. 

Display in Directory || Field 318

Constituent record's will display in the CU Link online community directory unless s/he has handling type “No contact,” “A1 Anonymous,” “Dissatisfaction with CU” or “Privacy” or s/he has changed the flag on their CU Link profile.

Email Status || Field 327

Y=Yes (Opt in)
R=Remove (opt out)
B= Bounced

 

Relationship Type || Fields 100, 105, 110, 115, 120, 125, 130, 135, 140, 145, 150

The first set of relationships will always be spouse/partner and fields 105 to 152 are child/grandchild relationships. Children are sorted before grandchildren.

The Relation Type field is a “one-to-many” field. This means that when you (as an eComm administrator), create a query and search for any record that has a grandchild, for example, the query will search ALL the Relation Type fields.

Advance TableField NumberField CodeShort Description
Relationship100; 105; 110; 115; 120; 125; 130; 135; 140; 145; 150FCFather/Child
Relationship100; 105; 110; 115; 120; 125; 130; 135; 140; 145; 150GCGrandparent/Child
Relationship100; 105; 110; 115; 120; 125; 130; 135; 140; 145; 150MCMother/Child
Relationship100; 105; 110; 115; 120; 125; 130; 135; 140; 145; 150PCParent/Child
Relationship100; 105; 110; 115; 120; 125; 130; 135; 140; 145; 150SFStep-Father/Child
Relationship100; 105; 110; 115; 120; 125; 130; 135; 140; 145; 150SMStep-Mother/Child
Relationship100; 105; 110; 115; 120; 125; 130; 135; 140; 145; 150UCGuardian/Child

Relation First and Middle Name || Fields 101, 106, 111, 116, 121, 126, 131, 136, 141, 146, 151

The first set of relationships will always be spouse/partner and fields 105 to 152 are child/grandchild relationships. Children are sorted before grandchildren.

Relation Last Name || Fields 102, 107, 112, 117, 122, 127, 132, 137, 142, 147, 152

The first set of relationships will always be spouse/partner and fields 105 to 152 are child/grandchild relationships. Children are sorted before grandchildren.

Primary Residence Street 1 || Field 201

Constituent record's primary street address 1.

Primary Residence Street 2 || Field 202

Constituent record's primary street address 2.

Primary Residence Foreign City and Postal Code || Field 203

If address is outside of US, Constituent record's primary foreign city and postal code.

Primary Residence City || Field 204

Constituent record's primary city.

Primary Residence State || Field 206 - AND- Secondary Residence State || Field 256

Constituent record's primary state.

Advance TableField NumberField CodeShort DescriptionFull Description
State206; 256; 609AAArmed Forced the AmericasArmed Forces the Americas
State206; 256; 609AEArmed Forces EuropeArmed Forces Europe
State206; 256; 609AKAlaskaAlaska
State206; 256; 609ALAlabamaAlabama
State206; 256; 609APArmed Forces PacificArmed Forces Pacific
State206; 256; 609ARArkansasArkansas
State206; 256; 609ASAmerican SamoaAmerican Samoa
State206; 256; 609AZArizonaArizona
State206; 256; 609CACaliforniaCalifornia
State206; 256; 609COColoradoColorado
State206; 256; 609CTConnecticutConnecticut
State206; 256; 609DCDistrict of ColumbiaDistrict of Columbia
State206; 256; 609DEDelawareDelaware
State206; 256; 609FLFloridaFlorida
State206; 256; 609GAGeorgiaGeorgia
State206; 256; 609GUGuamGuam
State206; 256; 609HIHawaiiHawaii
State206; 256; 609IAIowaIowa
State206; 256; 609IDIdahoIdaho
State206; 256; 609ILIllinoisIllinois
State206; 256; 609INIndianaIndiana
State206; 256; 609KSKansasKansas
State206; 256; 609KYKentuckyKentucky
State206; 256; 609LALouisianaLouisiana
State206; 256; 609MAMassachusettsMassachusetts
State206; 256; 609MDMarylandMaryland
State206; 256; 609MEMaineMaine
State206; 256; 609MHMarshall IslandsMarshall Islands
State206; 256; 609MIMichiganMichigan
State206; 256; 609MNMinnesotaMinnesota
State206; 256; 609MOMissouriMissouri
State206; 256; 609MPNorthern Mariana IslandsNorthern Mariana Islands
State206; 256; 609MSMississipiMississipi
State206; 256; 609MTMontanaMontana
State206; 256; 609NCNorth CarolinaNorth Carolina
State206; 256; 609NDNorth DakotaNorth Dakota
State206; 256; 609NENebraskaNebraska
State206; 256; 609NHNew HampshireNew Hampshire
State206; 256; 609NJNew JerseyNew Jersey
State206; 256; 609NMNew MexicoNew Mexico
State206; 256; 609NVNevadaNevada
State206; 256; 609NYNew YorkNew York
State206; 256; 609OHOhioOhio
State206; 256; 609OKOklahomaOklahoma
State206; 256; 609OROregonOregon
State206; 256; 609PAPennsylvaniaPennsylvania
State206; 256; 609PRPuerto RicoPuerto Rico
State206; 256; 609PWPalauPalau
State206; 256; 609RIRhode IslandRhode Island
State206; 256; 609SCSouth CarolinaSouth Carolina
State206; 256; 609SDSouth DakotaSouth Dakota
State206; 256; 609TNTennesseeTennessee
State206; 256; 609TXTexasTexas
State206; 256; 609UTUtahUtah
State206; 256; 609VAVirginiaVirginia
State206; 256; 609VIVirgin IslandsVirgin Islands
State206; 256; 609VTVermontVermont
State206; 256; 609WAWashingtonWashington
State206; 256; 609WIWisconsinWisconsin
State206; 256; 609WVWest VirginiaWest Virginia
State206; 256; 609WYWyomingWyoming

Primary Residence Country || Field 207 -AND- Secondary Residence Country || Field 257

If outside the US, constituent record's primary country.

Advance TableField CodesTMS CodeShort Description
Country - Non-US207; 257; 610ADAndorra
Country - Non-US207; 257; 610AEUnited Arab Emirates
Country - Non-US207; 257; 610AFAfghanistan
Country - Non-US207; 257; 610AGAntigua and Barbuda
Country - Non-US207; 257; 610AIAnguilla
Country - Non-US207; 257; 610ALAlbania
Country - Non-US207; 257; 610AMArmenia
Country - Non-US207; 257; 610AOAngola
Country - Non-US207; 257; 610AQAntarctica
Country - Non-US207; 257; 610ARArgentina
Country - Non-US207; 257; 610ATAustria
Country - Non-US207; 257; 610AUAustralia
Country - Non-US207; 257; 610AWAruba
Country - Non-US207; 257; 610AZAzerbaijan
Country - Non-US207; 257; 610BABosnia-Herzegovina
Country - Non-US207; 257; 610BBBarbados
Country - Non-US207; 257; 610BDBangladesh
Country - Non-US207; 257; 610BEBelgium
Country - Non-US207; 257; 610BFBurkina Faso
Country - Non-US207; 257; 610BGBulgaria
Country - Non-US207; 257; 610BHBahrain
Country - Non-US207; 257; 610BIBurundi
Country - Non-US207; 257; 610BJBenin
Country - Non-US207; 257; 610BMBermuda
Country - Non-US207; 257; 610BNBrunei
Country - Non-US207; 257; 610BOBolivia
Country - Non-US207; 257; 610BRBrazil
Country - Non-US207; 257; 610BSBahamas
Country - Non-US207; 257; 610BTBhutan
Country - Non-US207; 257; 610BVBouvet Island
Country - Non-US207; 257; 610BWBotswana
Country - Non-US207; 257; 610BYBelarus
Country - Non-US207; 257; 610BZBelize
Country - Non-US207; 257; 610CACanada
Country - Non-US207; 257; 610CCCocos (Keeling) Islands
Country - Non-US207; 257; 610CDDemocratic Republic of the Congo
Country - Non-US207; 257; 610CFCentral African Republic
Country - Non-US207; 257; 610CGRepublic of the Congo
Country - Non-US207; 257; 610CHSwitzerland
Country - Non-US207; 257; 610CIIvory Coast
Country - Non-US207; 257; 610CKCook Islands
Country - Non-US207; 257; 610CLChile
Country - Non-US207; 257; 610CMCameroon
Country - Non-US207; 257; 610CNPeople's Republic China
Country - Non-US207; 257; 610COColombia
Country - Non-US207; 257; 610CRCosta Rica
Country - Non-US207; 257; 610CUCuba
Country - Non-US207; 257; 610CVCape Verde
Country - Non-US207; 257; 610CXChristmas Island
Country - Non-US207; 257; 610CYCyprus
Country - Non-US207; 257; 610CZCzech Republic
Country - Non-US207; 257; 610DEGermany
Country - Non-US207; 257; 610DJDjibouti
Country - Non-US207; 257; 610DKDenmark
Country - Non-US207; 257; 610DMDominica
Country - Non-US207; 257; 610DODominican Republic
Country - Non-US207; 257; 610DZAlgeria
Country - Non-US207; 257; 610ECEcuador
Country - Non-US207; 257; 610EEEstonia
Country - Non-US207; 257; 610EGEgypt
Country - Non-US207; 257; 610EHWestern Sahara
Country - Non-US207; 257; 610EREritrea
Country - Non-US207; 257; 610ESSpain
Country - Non-US207; 257; 610ETEthiopia
Country - Non-US207; 257; 610FIFinland
Country - Non-US207; 257; 610FJFiji
Country - Non-US207; 257; 610FKFalkland Islands (Malvina)
Country - Non-US207; 257; 610FMMicronesia
Country - Non-US207; 257; 610FOFaroe Islands
Country - Non-US207; 257; 610FRFrance
Country - Non-US207; 257; 610GAGabon
Country - Non-US207; 257; 610GDGrenada
Country - Non-US207; 257; 610GEGeorgia
Country - Non-US207; 257; 610GFFrench Guiana
Country - Non-US207; 257; 610GHGhana
Country - Non-US207; 257; 610GIGibraltar
Country - Non-US207; 257; 610GLGreenland
Country - Non-US207; 257; 610GMGambia
Country - Non-US207; 257; 610GNGuinea
Country - Non-US207; 257; 610GPGuadeloupe
Country - Non-US207; 257; 610GQEquatorial Guinea
Country - Non-US207; 257; 610GRGreece
Country - Non-US207; 257; 610GSS. Georgia & S. Sandwich Islands
Country - Non-US207; 257; 610GTGuatemala
Country - Non-US207; 257; 610GWGuinea-Bissau
Country - Non-US207; 257; 610GYGuyana
Country - Non-US207; 257; 610HKHong Kong
Country - Non-US207; 257; 610HMHeard & McDonald Islands
Country - Non-US207; 257; 610HNHonduras
Country - Non-US207; 257; 610HRCroatia
Country - Non-US207; 257; 610HTHaiti
Country - Non-US207; 257; 610HUHungary
Country - Non-US207; 257; 610IDIndonesia
Country - Non-US207; 257; 610IEIreland
Country - Non-US207; 257; 610ILIsrael
Country - Non-US207; 257; 610INIndia
Country - Non-US207; 257; 610IOBritish Indian Ocean Territory
Country - Non-US207; 257; 610IQIraq
Country - Non-US207; 257; 610IRIran
Country - Non-US207; 257; 610ISIceland
Country - Non-US207; 257; 610ITItaly
Country - Non-US207; 257; 610JMJamaica
Country - Non-US207; 257; 610JOJordan
Country - Non-US207; 257; 610JPJapan
Country - Non-US207; 257; 610KEKenya
Country - Non-US207; 257; 610KGKyrgyzstan
Country - Non-US207; 257; 610KHCambodia
Country - Non-US207; 257; 610KIKiribati
Country - Non-US207; 257; 610KMComoros
Country - Non-US207; 257; 610KNSaint Kitts and Nevis
Country - Non-US207; 257; 610KPDemocratic People's Rep of (North) Korea
Country - Non-US207; 257; 610KRRepublic of Korea
Country - Non-US207; 257; 610KWKuwait
Country - Non-US207; 257; 610KYCayman Islands
Country - Non-US207; 257; 610KZKazakhstan
Country - Non-US207; 257; 610LALaos
Country - Non-US207; 257; 610LBLebanon
Country - Non-US207; 257; 610LCSt. Lucia
Country - Non-US207; 257; 610LILiechtenstein
Country - Non-US207; 257; 610LKSri Lanka
Country - Non-US207; 257; 610LRLiberia
Country - Non-US207; 257; 610LSLesotho
Country - Non-US207; 257; 610LTLithuania
Country - Non-US207; 257; 610LULuxembourg
Country - Non-US207; 257; 610LVLatvia
Country - Non-US207; 257; 610LYLibya
Country - Non-US207; 257; 610MAMorocco
Country - Non-US207; 257; 610MCMonaco
Country - Non-US207; 257; 610MDMoldova
Country - Non-US207; 257; 610MGMadagascar
Country - Non-US207; 257; 610MKMacedonia
Country - Non-US207; 257; 610MLMali
Country - Non-US207; 257; 610MMMyanmar
Country - Non-US207; 257; 610MNMongolia
Country - Non-US207; 257; 610MOMacau
Country - Non-US207; 257; 610MQMartinique
Country - Non-US207; 257; 610MRMauritania
Country - Non-US207; 257; 610MSMontserrat
Country - Non-US207; 257; 610MTMalta
Country - Non-US207; 257; 610MUMauritius
Country - Non-US207; 257; 610MVMaldives
Country - Non-US207; 257; 610MWMalawi
Country - Non-US207; 257; 610MXMexico
Country - Non-US207; 257; 610MYMalaysia
Country - Non-US207; 257; 610MZMozambique
Country - Non-US207; 257; 610NANamibia
Country - Non-US207; 257; 610NCNew Caledonia
Country - Non-US207; 257; 610NENiger
Country - Non-US207; 257; 610NFNorfolk Island
Country - Non-US207; 257; 610NGNigeria
Country - Non-US207; 257; 610NINicaragua
Country - Non-US207; 257; 610NLNetherlands
Country - Non-US207; 257; 610NONorway
Country - Non-US207; 257; 610NPNepal
Country - Non-US207; 257; 610NRNauru
Country - Non-US207; 257; 610NUNiue
Country - Non-US207; 257; 610NZNew Zealand
Country - Non-US207; 257; 610OMOman
Country - Non-US207; 257; 610PAPanama
Country - Non-US207; 257; 610PEPeru
Country - Non-US207; 257; 610PFFrench Polynesia
Country - Non-US207; 257; 610PGPapua New Guinea
Country - Non-US207; 257; 610PHPhilippines
Country - Non-US207; 257; 610PKPakistan
Country - Non-US207; 257; 610PLPoland
Country - Non-US207; 257; 610PMSaint Pierre & Miquelon
Country - Non-US207; 257; 610PNPitcairn
Country - Non-US207; 257; 610PSPalestine
Country - Non-US207; 257; 610PTPortugal
Country - Non-US207; 257; 610PUU.S. Miscellaneous Pacific Islands
Country - Non-US207; 257; 610PYParaguay
Country - Non-US207; 257; 610QAQatar
Country - Non-US207; 257; 610REReunion
Country - Non-US207; 257; 610RORomania
Country - Non-US207; 257; 610RURussia
Country - Non-US207; 257; 610RWRwanda
Country - Non-US207; 257; 610SASaudi Arabia
Country - Non-US207; 257; 610SBSolomon Isles
Country - Non-US207; 257; 610SCSeychelles
Country - Non-US207; 257; 610SDSudan
Country - Non-US207; 257; 610SESweden
Country - Non-US207; 257; 610SGSingapore
Country - Non-US207; 257; 610SHSt. Helena
Country - Non-US207; 257; 610SISlovenia
Country - Non-US207; 257; 610SJSvalbard & Jan Mayen Islands
Country - Non-US207; 257; 610SKSlovakia
Country - Non-US207; 257; 610SLSierra Leone
Country - Non-US207; 257; 610SMSan Marino
Country - Non-US207; 257; 610SNSenegal
Country - Non-US207; 257; 610SOSomalia
Country - Non-US207; 257; 610SQSerbia
Country - Non-US207; 257; 610SRSurinam
Country - Non-US207; 257; 610STSao Tome and Principe
Country - Non-US207; 257; 610SVEl Salvador
Country - Non-US207; 257; 610SXSwaziland
Country - Non-US207; 257; 610SYSyria
Country - Non-US207; 257; 610TCTurks & Caicos Islands
Country - Non-US207; 257; 610TDChad
Country - Non-US207; 257; 610TFFrench Southern Territory
Country - Non-US207; 257; 610TGTogo
Country - Non-US207; 257; 610THThailand
Country - Non-US207; 257; 610TJTajikistan
Country - Non-US207; 257; 610TKTokelau
Country - Non-US207; 257; 610TMTurkmenistan
Country - Non-US207; 257; 610TNTunisia
Country - Non-US207; 257; 610TOTonga
Country - Non-US207; 257; 610TRTurkey
Country - Non-US207; 257; 610TTTrinidad & Tobago
Country - Non-US207; 257; 610TVTuvalu
Country - Non-US207; 257; 610TWTaiwan
Country - Non-US207; 257; 610TZTanzania
Country - Non-US207; 257; 610UAUkraine
Country - Non-US207; 257; 610UGUganda
Country - Non-US207; 257; 610UKUnited Kingdom
Country - Non-US207; 257; 610USUnited States
Country - Non-US207; 257; 610UYUruguay
Country - Non-US207; 257; 610UZUzbekistan
Country - Non-US207; 257; 610VAVatican City (Holy See)
Country - Non-US207; 257; 610VCSt. Vincent & the Grenadines
Country - Non-US207; 257; 610VEVenezuela
Country - Non-US207; 257; 610VGBritish Virgin Islands
Country - Non-US207; 257; 610VNVietnam
Country - Non-US207; 257; 610VUVanuatu
Country - Non-US207; 257; 610WFWallis and Futuna Islands
Country - Non-US207; 257; 610WSSamoa
Country - Non-US207; 257; 610YEYemen
Country - Non-US207; 257; 610YTMayotte
Country - Non-US207; 257; 610ZASouth Africa
Country - Non-US207; 257; 610ZMZambia
Country - Non-US207; 257; 610ZWZimbabwe

Primary Residence Zip || Field 209

Constituent record's primary zip code.

Primary Residence Phone Number || Field 210

Primary Residence Phone Number || Field 210

Primary Residence Cell Phone Number || Field 211

Constituent record's cell phone number.

Primary Residence Address Type || Field 212

Constituent record's primary address type.

Primary Residence Seasonal Address Start Date || Field 213

This field relates to secondary address only.

Primary Residence Seasonal Address End Date || Field 214

This field relates to secondary address only.

Secondary Address Street 1 || Field 251

Constituent record's secondary street address 1, if available.

Secondary Address Street 2 || Field 252

Constituent record's secondary street address 2, if available.

Secondary Address Foreign City and Postal Code || Field 253

If outside the US, constituent record's secondary foreign city and postal code, if available.

Secondary Address City || Field 254

Constituent record's secondary city, if available.

Secondary Address Zip || Field 259

Constituent record's secondary zip code, if available.

Secondary Phone Number || Field 260

Constituent record's secondary phone number, if available.

Secondary Cell Phone Number || Field 261

Constituent record's secondary cell phone number, if available.

Secondary Address Type || Field 262

Constituent record's secondary address type, if available.

Secondary Address Seasonal Address Start Date || Field 263

Constituent record's seasonal address start date. This will be tied to secondary address, if available.

Secondary Address Seasonal Address End Date || Field 264

Constituent record's seasonal address end date. This will be tied to secondary address, if available.

Geocodes || Field 215 **AND** County || Field 265


This field that contains both geocode codes and county names. If you want to search by geocode, you’ll need the geocode CODE (ie; BOLDR). If you want to search by county, you’ll enter the actual name of the county (ie; ‘Weld’).

This file is too large to display. Please download.

Geocode | County

Degree Table Overview

Use these spreadsheets for a global view of degree information.

 School, degree, major and department by campus

 School, majors and departments by school or college

Degree Level || Fields 500, 510, 520, 530, 540, 550, 560

e.g. M (Masters).

Advance Table Field Number Field Code Short Description Full Description
Degree Level 500; 510; 520; 530; 540; 550; 560 0 Past 5th-Year Senior Past 5th-Year Senior
Degree Level 500; 510; 520; 530; 540; 550; 560 1 Continuing Freshman Continuing Freshman
Degree Level 500; 510; 520; 530; 540; 550; 560 2 Sophomore Sophomore
Degree Level 500; 510; 520; 530; 540; 550; 560 3 Junior Junior
Degree Level 500; 510; 520; 530; 540; 550; 560 4 Senior Senior
Degree Level 500; 510; 520; 530; 540; 550; 560 5 5th-Year Senior 5th-Year Senior
Degree Level 500; 510; 520; 530; 540; 550; 560 6 Past Freshman Past Freshman
Degree Level 500; 510; 520; 530; 540; 550; 560 7 Past Sophomore Past Sophomore
Degree Level 500; 510; 520; 530; 540; 550; 560 8 Past Junior Past Junior
Degree Level 500; 510; 520; 530; 540; 550; 560 9 Past Senior Past Senior
Degree Level 500; 510; 520; 530; 540; 550; 560 A Associates Associates
Degree Level 500; 510; 520; 530; 540; 550; 560 B Bachelors Bachelors
Degree Level 500; 510; 520; 530; 540; 550; 560 C Certificate Certificate
Degree Level 500; 510; 520; 530; 540; 550; 560 D Doctorate Doctorate
Degree Level 500; 510; 520; 530; 540; 550; 560 G Post Graduate Post Graduate
Degree Level 500; 510; 520; 530; 540; 550; 560 M Masters Masters
Degree Level 500; 510; 520; 530; 540; 550; 560 N Non Degree Non Degree
Degree Level 500; 510; 520; 530; 540; 550; 560 P Professional Professional
Degree Level 500; 510; 520; 530; 540; 550; 560 Q Past Graduate Student Past Graduate Student
Degree Level 500; 510; 520; 530; 540; 550; 560 S Graduate Student Graduate Student
Degree Level 500; 510; 520; 530; 540; 550; 560 U Unknown Unknown
Degree Level 500; 510; 520; 530; 540; 550; 560 W New Freshman New Freshman

Degree Level

Degree 1, 2 & 3 || Fields 404, 405, 406, 501, 511, 521, 531, 541, 551, 561

This file is too large to display. Please download.

Degree

Degree School || Fields 503, 513, 523, 533, 543, 553, 563

Advance Table Field Number Field Code Short Description Full Description
Degree School 503; 513; 523; 533; 543; 553; 563 AM Arts & Media-AM College of Arts and Media
Degree School 503; 513; 523; 533; 543; 553; 563 AP Architecture & Planning-AP Architecture & Planning
Degree School 503; 513; 523; 533; 543; 553; 563 AR Architecture-AR Architecture
Degree School 503; 513; 523; 533; 543; 553; 563 ARG Architecture Grad School-ARG Architecture Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 ARTS Arts-ARTS College of Arts & Sciences
Degree School 503; 513; 523; 533; 543; 553; 563 AS Arts & Sciences-AS College of Arts & Sciences
Degree School 503; 513; 523; 533; 543; 553; 563 ASG Arts & Sciences Grad Sch-ASG College of Arts & Sciences Grad School
Degree School 503; 513; 523; 533; 543; 553; 563 BD Business-BD College of Business & Admin
Degree School 503; 513; 523; 533; 543; 553; 563 BG Business Grad School-BG Business Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 BU Business & Admin-BU College of Business & Admin
Degree School 503; 513; 523; 533; 543; 553; 563 BUG Business Grad School-BUG Grad School of Business Admin
Degree School 503; 513; 523; 533; 543; 553; 563 CN Concurrent Schools Concurrent Schools
Degree School 503; 513; 523; 533; 543; 553; 563 DH Dental Medicine Undergrad-DH Dental Medicine, Undergraduate
Degree School 503; 513; 523; 533; 543; 553; 563 DN Dental Medicine-DN Dental Medicine
Degree School 503; 513; 523; 533; 543; 553; 563 DP Arch & Planning-DP School of Architecture & Planning
Degree School 503; 513; 523; 533; 543; 553; 563 DPG Design & Planning Grad Sch-DPG Design & Planning Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 ED Education-ED School of Education
Degree School 503; 513; 523; 533; 543; 553; 563 EDG Education Grad School-EDG Education Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 EN Eng & Applied Sci-EN College of Engineering & Applied Science
Degree School 503; 513; 523; 533; 543; 553; 563 ENG Eng Grad School-ENG Engineering Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 ES Eng & Applied Sci-ES College of Engineering and Applied Science
Degree School 503; 513; 523; 533; 543; 553; 563 EV Environmental Design-EV College of Environmental Design
Degree School 503; 513; 523; 533; 543; 553; 563 GB Business Grad School-GB Grad School of Business Admin
Degree School 503; 513; 523; 533; 543; 553; 563 GR Graduate School-GR Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 JR Journalism & Mass Comm-JR School of Journalism & Mass Communications
Degree School 503; 513; 523; 533; 543; 553; 563 JRG Journalism Grad School-JRG Journalism Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 LA Liberal Arts & Sciences-LA College of Liberal Arts & Sci
Degree School 503; 513; 523; 533; 543; 553; 563 LAG Graduate Arts & Sci-LAG College of Arts & Sciences Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 LS Letters, Arts & Sciences-LS College of Letters, Arts & Science
Degree School 503; 513; 523; 533; 543; 553; 563 LSG Graduate Arts & Sci-LSG College of Arts & Sciences Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 LW Law-LW School of Law
Degree School 503; 513; 523; 533; 543; 553; 563 MB Music-MB College of Music
Degree School 503; 513; 523; 533; 543; 553; 563 MC Child Health-MC Child Health
Degree School 503; 513; 523; 533; 543; 553; 563 MD Medicine-MD School of Medicine
Degree School 503; 513; 523; 533; 543; 553; 563 MDG Medicine Grad School-MDG Medicine Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 MP Physical Therapy-MP Physical Therapy
Degree School 503; 513; 523; 533; 543; 553; 563 MS Medicine Undergrad-MS School of Medicine, Undergrad
Degree School 503; 513; 523; 533; 543; 553; 563 MT Medical Technician-MT Medical Technician
Degree School 503; 513; 523; 533; 543; 553; 563 MU Music-MU College of Music
Degree School 503; 513; 523; 533; 543; 553; 563 MUG Music Grad School-MUG Music Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 MULT Multi-Disciplinary Multi-Disciplinary
Degree School 503; 513; 523; 533; 543; 553; 563 NG Nursing Grad School-NG Nursing Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 NR Beth El Nursing & Health Sci-NR School of Nursing, Beth El
Degree School 503; 513; 523; 533; 543; 553; 563 NU Nursing-NU School of Nursing
Degree School 503; 513; 523; 533; 543; 553; 563 NUG Nursing Grad School-NUG Nursing Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 PA School of Public Affairs-PA School of Public Affairs
Degree School 503; 513; 523; 533; 543; 553; 563 PH Pharmacy-PH School of Pharmacy
Degree School 503; 513; 523; 533; 543; 553; 563 PHG Pharmacy Grad School-PHG Pharmacy Graduate School
Degree School 503; 513; 523; 533; 543; 553; 563 PL Colo Sch of Public Health-PL Colo School of Public Health
Degree School 503; 513; 523; 533; 543; 553; 563 PU School of Public Affairs-PU School of Public Affairs
Degree School 503; 513; 523; 533; 543; 553; 563 SG Graduate Student-SG Graduate Student
Degree School 503; 513; 523; 533; 543; 553; 563 SU Undergraduate Student-SU Undergraduate Student
Degree School 503; 513; 523; 533; 543; 553; 563 UN Unknown-UN Unknown School
Degree School 503; 513; 523; 533; 543; 553; 563 US Undergrad Student-US Undergraduate Student

School

Degree Major || Fields 410, 411, 412, 504, 506, 514, 516, 524, 526, 534, 536, 544, 546, 554, 556, 564, 566

e.g. PATH (Pathology)

This file is too large to display. Please download.

Major

Degree Minor || Fields 507, 517, 527, 537, 547, 557, 567

This file is too large to display. Please download.

Minor

Degree Honors || Field 509, 519, 529, 539, 549, 559, 569

Advance Table Field Number Field Code Short Description Full Description
Degree Honors 509; 519; 529; 539; 549; 559; 569 COI New Honor Code-COI New Honor Code-COI
Degree Honors 509; 519; 529; 539; 549; 559; 569 DS1 With Distinction With Distinction
Degree Honors 509; 519; 529; 539; 549; 559; 569 DS2 With High Distinction With High Distinction
Degree Honors 509; 519; 529; 539; 549; 559; 569 DS3 With Highest Distinction With Highest Distinction
Degree Honors 509; 519; 529; 539; 549; 559; 569 HM1 Honors in Humanities Honors in Humanities
Degree Honors 509; 519; 529; 539; 549; 559; 569 HN1 With Honors With Honors
Degree Honors 509; 519; 529; 539; 549; 559; 569 HN2 With High Honors With High Honors
Degree Honors 509; 519; 529; 539; 549; 559; 569 HN3 With Highest Honors With Highest Honors
Degree Honors 509; 519; 529; 539; 549; 559; 569 LA1 Cum Laude Cum Laude
Degree Honors 509; 519; 529; 539; 549; 559; 569 LA2 Magna Cum Laude Magna Cum Laude
Degree Honors 509; 519; 529; 539; 549; 559; 569 LA3 Summa Cum Laude Summa Cum Laude
Degree Honors 509; 519; 529; 539; 549; 559; 569 N New Honor Code-N New Honor Code-N
Degree Honors 509; 519; 529; 539; 549; 559; 569 SP1 With Special Honors With Special Honors
Degree Honors 509; 519; 529; 539; 549; 559; 569 UH New Honor Code-UH New Honor Code-UH

Honors.

Degree Campus || Field 518

Anschutz Medical Campus-AMC

Boulder-UCB

Colorado Springs-UCCS

Denver Downtown-UCD

University of Colorado System

This should be a drop down menu. Please tell your eComm specialist if you do not see a drop down menu in this field

Affiliation Campus-School || Field 570, 573, 576, 579, 582, 585, 588

This field can be used when you need to build a query based on a school that may ‘live’ on more than one campus. For example, there is a Business school on both the Boulder and Denver campus. e.g 1-BU (Boulder Business)

Affiliation Campus School

Affiliation Status || Field 571, 574, 577, 580, 583, 586, 589

Advance Table Field Codes TMS Code Short Description Full Description
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 0 Past 5th-Year Senior Past 5th-Year Senior
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 1 Continuing Freshman Continuing Freshman
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 2 Sophomore Sophomore
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 3 Junior Junior
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 4 Senior Senior
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 5 5th-Year Senior 5th-Year Senior
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 6 Past Freshman Past Freshman
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 7 Past Sophomore Past Sophomore
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 8 Past Junior Past Junior
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 9 Past Senior Past Senior
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 C Current Current
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 F Certificate Certificate
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 G Graduate Graduate
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 H Chairman Chairman
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 N Non Degree Non Degree
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 O Voting Voting
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 P Past Past
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 Q Past Graduate Student Past Graduate Student
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 R President President
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 S Graduate Student Graduate Student
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 U Undergraduate Undergraduate
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 V Vice Chairman Vice Chairman
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 W New Freshman New Freshman
Affiliation Status (Level) 571; 574; 577; 580; 583; 586; 589 X Non Voting Non Voting

Affiliation Status

Affiliation Year || Field 575

Year of the affiliation (e.g. yyyy)

Degree Concentration || Field 1908; 1918; 1928; 1938; 1948; 1958; 1968

Non-CU Table Overview

Content Here

Non-CU Degree 1, 2 & 3 || Fields 404, 405, 406, 501, 511, 521, 531, 541, 551, 561

This file is too large to display. Please download.

 Degree

Other Institution || Fields 407, 408 and 409

If this information is available, constituent will provide this information in their CU Link profile.

2125= Hult International Business School
ITA900= The Umbra Institute
UK1080= University of East Anglia
1342= Whittier College

Non-CU Degree Major 1, 2 & 3 || Fields 410, 411 and 412

e.g. PATH (Pathology)

This file is too large to display. Please download.

 Major

Professional Title || Field 600

If available, this field will be populated with constituent's professional title (e.g. President)

Business Name || Field 602

If available, this field will be populated with the constituent's employer's name (e.g. Google)

Business Street 1 || Field 603

If available, this field will be populated with the address of the constituent's employer.

Business Street 2 || Field 604

If available, this field will be populated with a secondary address of the constituent's employer.

Business Street 3 || Field 605

If available, this field will be populated with a tertiary address of the constituent's employer.

Business City || Field 608

If available, this field will be populated with the city of the constituent's employer.

Business State || Field 609

If available, this field will be populated with the state of the constituent's employer. See the Address tab and State field for a list of state codes. 

Business Country || Field 610

If available, this field will be populated with the country of the constituent's employer. See the Address tab and Country field for a list of country codes. 

Business Zip || Field 612

If available, this field will be populated with the zipcode of the constituent's employer.

Business Phone || Field 613

If available, this field will be populated with the constituent's work phone number. 

Field of Work || Field 614, 619

Advance Table Field Number Field Code Short Description Full Description
Field of Work 614; 619 1000 Aviation Aviation
Field of Work 614; 619 1001 Financial Services Financial Services
Field of Work 614; 619 1002 Health Care/Medicine Health Care/Medicine
Field of Work 614; 619 1003 Government Government
Field of Work 614; 619 1007 Non-profit Non-profit
Field of Work 614; 619 1009 Personal Services Personal Services
Field of Work 614; 619 1010 Media Media
Field of Work 614; 619 1011 Science Science
Field of Work 614; 619 1014 Hospitality Hospitality
Field of Work 614; 619 1015 Library Science Library Science
Field of Work 614; 619 1016 Manufacturing Manufacturing
Field of Work 614; 619 1018 Veterinary Medicine Veterinary Medicine
Field of Work 614; 619 1019 Gaming Gaming
Field of Work 614; 619 1020 Pharmeceuticals Pharmeceuticals
Field of Work 614; 619 1021 University Faculty University Faculty
Field of Work 614; 619 1022 University Staff University Staff
Field of Work 614; 619 189 Research/Development Research/Development
Field of Work 614; 619 193 Administer Medicine Administer Medicine
Field of Work 614; 619 301 Farming-Agriculture Farming-Agriculture
Field of Work 614; 619 303 Fish, Game & Wildlife Management Fish, Game & Wildlife Management
Field of Work 614; 619 328 Architecture/Design Architecture/Design
Field of Work 614; 619 351 Computer/Info Sciences Computer/Info Sciences
Field of Work 614; 619 385 Environment/Conservation Environment/Conservation
Field of Work 614; 619 406 Criminal Justice Criminal Justice
Field of Work 614; 619 490 Education/Teaching Education/Teaching
Field of Work 614; 619 512 Entertainment Entertainment
Field of Work 614; 619 514 Producer, Director Producer, Director
Field of Work 614; 619 521 Fine Arts Fine Arts
Field of Work 614; 619 546 Military Services Military Services
Field of Work 614; 619 551 Religious Services Religious Services
Field of Work 614; 619 605 Advertising Advertising
Field of Work 614; 619 611 Telecommunications Telecommunications
Field of Work 614; 619 634 Transportation Transportation
Field of Work 614; 619 668 Engineering Engineering
Field of Work 614; 619 670 Energy Resources (oil, gas, solar, etc.) Energy Resources (oil, gas, alternative, etc.)
Field of Work 614; 619 691 Banking Banking
Field of Work 614; 619 715 Insurance Insurance
Field of Work 614; 619 716 Real Estate Real Estate
Field of Work 614; 619 718 Retail Retail
Field of Work 614; 619 720 Marketing Marketing
Field of Work 614; 619 723 Sales Related-Demonstr,Auct,TechSup Sales Related-Demonstration, Auction, Technical Support
Field of Work 614; 619 773 Human Resources Human Resources
Field of Work 614; 619 794 Athletics/Sports Athletics/Sports
Field of Work 614; 619 814 Homemaker Homemaker
Field of Work 614; 619 815 Not Specified/Other Not Specified/Other
Field of Work 614; 619 857 Business Administration Business Administration
Field of Work 614; 619 877 Construction Construction
Field of Work 614; 619 883 Law/Legal Services Law/Legal Services
Field of Work 614; 619 884 Mining Or Mineral Extraction Mining Or Mineral Extraction
Field of Work 614; 619 885 Utilities Utilities
Field of Work 614; 619 985 Student Student

Field of Work

Field of Specialty || Field 615, 616, 620

Advance Table Field Codes TMS Code Short Description Full Description
Field of Specialty 615; 616; 620 AAD Art Or Antique Dealer Art Or Antique Dealer
Field of Specialty 615; 616; 620 AAE Aerospace/Aeronautical Engineering Aerospace/Aeronautical Engineering
Field of Specialty 615; 616; 620 ABD Medicine-Surgery-Abdominal Abdominal Surgery
Field of Specialty 615; 616; 620 ACC Accounting Accounting
Field of Specialty 615; 616; 620 ACS Athletics-Coach Or Sports Official Athletics-Coach Or Sports Official
Field of Specialty 615; 616; 620 ACT Actuary Actuary
Field of Specialty 615; 616; 620 AD Administrative Administrative
Field of Specialty 615; 616; 620 ADL Medicine-Adolescent Adolescent Medicine
Field of Specialty 615; 616; 620 ADM Administrator-City,Town,County Administrator-City,Town,County
Field of Specialty 615; 616; 620 ADS Advertising Sales Advertising Sales
Field of Specialty 615; 616; 620 AFS Agriculture & Food Scientist Agriculture & Food Scientist
Field of Specialty 615; 616; 620 AGO Agriculture-Other Agriculture-Other
Field of Specialty 615; 616; 620 AH Agronomy & Horticulture Agronomy & Horticulture
Field of Specialty 615; 616; 620 AI Medicine-Allergy and Immunology Allergy and Immunology
Field of Specialty 615; 616; 620 AL Medicine-Allergy Allergy
Field of Specialty 615; 616; 620 ALD Alcohol and Drug Abuse Alcohol and Drug Abuse
Field of Specialty 615; 616; 620 ALP Airline Pilot Airline Pilot
Field of Specialty 615; 616; 620 AM Medicine-Aerospace Aerospace Medicine
Field of Specialty 615; 616; 620 AMB Medicine-Ambulatory Ambulatory Medicine
Field of Specialty 615; 616; 620 AN Medicine-Anesthesiology Anesthesiology
Field of Specialty 615; 616; 620 AOS Artist Or Sculptor Artist Or Sculptor
Field of Specialty 615; 616; 620 ARE Architectural Engineering Architectural Engineering
Field of Specialty 615; 616; 620 ART Architectural Technology Architectural Technology
Field of Specialty 615; 616; 620 ATC Air Traffic Controller Air Traffic Controller
Field of Specialty 615; 616; 620 ATP Athlete-Professional Athlete-Professional
Field of Specialty 615; 616; 620 AUD Audiologist Audiologist
Field of Specialty 615; 616; 620 AUT Automotive Engineering Automotive Engineering
Field of Specialty 615; 616; 620 BBC Biologist, Biochemist Biologist, Biochemist
Field of Specialty 615; 616; 620 BBG Biochem/Biophys/Genetics Biochem/Biophys/Genetics
Field of Specialty 615; 616; 620 BCB Bookkeeper,Cashier,Billing Bookkeeper,Cashier,Billing
Field of Specialty 615; 616; 620 BCR Barbers,Cosmetologist,Related Serv Barbers, Cosmetologist, Related Services
Field of Specialty 615; 616; 620 BE Medicine-Brohcho-Esophagology Brohcho-Esophagology
Field of Specialty 615; 616; 620 BEO Broadcast Equipment Operations Broadcast Equipment Operations
Field of Specialty 615; 616; 620 BIM Biometrics Biometrics
Field of Specialty 615; 616; 620 BLB Bloodbanking Bloodbanking
Field of Specialty 615; 616; 620 BME Bio-Medical Engineering Bio-Medical Engineering
Field of Specialty 615; 616; 620 BR Biomedical Research Biomedical Research
Field of Specialty 615; 616; 620 BRT Broadcasting-Radio,TV Broadcasting-Radio,TV
Field of Specialty 615; 616; 620 BURN Medicine-Burn Medicine-Burn
Field of Specialty 615; 616; 620 CAD College Administration College Administration
Field of Specialty 615; 616; 620 CAE Computer Applications Engineering Computer Applications Engineering
Field of Specialty 615; 616; 620 CBU Contractor/Builder Contractor/Builder
Field of Specialty 615; 616; 620 CCM Credit & Collections Management Credit & Collections Management
Field of Specialty 615; 616; 620 CCS Child Care Services Child Care Services
Field of Specialty 615; 616; 620 CD Medicine-Cardiovascular Diseases Cardiovascular Diseases
Field of Specialty 615; 616; 620 CDS Medicine-Cardiovascular Surgery Cardiovascular Surgery
Field of Specialty 615; 616; 620 CHE Chemical Engineering Chemical Engineering
Field of Specialty 615; 616; 620 CHM Chemist Chemist
Field of Specialty 615; 616; 620 CHP Child Psychiatry Child Psychiatry
Field of Specialty 615; 616; 620 CMG Computer Manager Computer Manager
Field of Specialty 615; 616; 620 CNE Medicine-Child Neurology Child Neurology
Field of Specialty 615; 616; 620 CP Clinical Pharmacology Clinical Pharmacology
Field of Specialty 615; 616; 620 CPM Communications/PR/Media Communications/PR/Media
Field of Specialty 615; 616; 620 CPR Chiropractor Chiropractor
Field of Specialty 615; 616; 620 CR Medicine-Cardiology Cardiology
Field of Specialty 615; 616; 620 CRS Medicine-Surgery-Colon and Rectal Colon and Rectal Surgery
Field of Specialty 615; 616; 620 CUF College/Univ Faculty College/Univ Faculty
Field of Specialty 615; 616; 620 CVE Civil Engineering Civil Engineering
Field of Specialty 615; 616; 620 CVO Civic Volunteer Civic Volunteer
Field of Specialty 615; 616; 620 DH Dental Hygiene Dental Hygiene
Field of Specialty 615; 616; 620 DIA Medicine-Diabetes Diabetes
Field of Specialty 615; 616; 620 DIT Dietician Dietician
Field of Specialty 615; 616; 620 DM Dermatology Dermatology
Field of Specialty 615; 616; 620 DO Dentistry-Orthodontics Dentistry-Orthodontics
Field of Specialty 615; 616; 620 DR Diagnostic Radiology Diagnostic Radiology
Field of Specialty 615; 616; 620 DY Dentistry Dentistry
Field of Specialty 615; 616; 620 ECG Education Counseling & Guidance Education Counseling & Guidance
Field of Specialty 615; 616; 620 ECO Economics Economics
Field of Specialty 615; 616; 620 EDE Environmental Design Environmental Design
Field of Specialty 615; 616; 620 EEN Electrical Engineering Electrical Engineering
Field of Specialty 615; 616; 620 EM Medicine-Emergency Emergency Medicine
Field of Specialty 615; 616; 620 EMC Employment Consultant Employment Consultant
Field of Specialty 615; 616; 620 END Medicine-Endocrinology Endocrinology
Field of Specialty 615; 616; 620 EPA Elementary/Preschool Admin. Elementary/Preschool Admin.
Field of Specialty 615; 616; 620 EPC Elected Represent-City,Town,County Elected Represent-City,Town,County
Field of Specialty 615; 616; 620 EPI Medicine-Epidemiology Epidemiology
Field of Specialty 615; 616; 620 ERA Energy-Renewable/Alternative Energy - Renewable/Alternative
Field of Specialty 615; 616; 620 ERF Elected Representative Fed/State Elected Representative Fed/State
Field of Specialty 615; 616; 620 FAT Flight Attendant Flight Attendant
Field of Specialty 615; 616; 620 FBE Fashion/Beauty Fashion/Beauty
Field of Specialty 615; 616; 620 FP Family Practice Family Practice
Field of Specialty 615; 616; 620 FSE Foreign Service Foreign Service
Field of Specialty 615; 616; 620 FUN Fundraising Fundraising
Field of Specialty 615; 616; 620 GAR Graphic Artist Graphic Artist
Field of Specialty 615; 616; 620 GE Medicine-Gastroenterology Gastroenterology
Field of Specialty 615; 616; 620 GEO Geography Geography
Field of Specialty 615; 616; 620 GER Medicine-Geriatrics Geriatrics
Field of Specialty 615; 616; 620 GGG Geologist,Geophysicist,Geochemist Geologist, Geophysicist, Geochemist
Field of Specialty 615; 616; 620 GP Medicine-General Practice General Practice
Field of Specialty 615; 616; 620 GPM Medicine-General Preventive General Preventive Medicine
Field of Specialty 615; 616; 620 GS Medicine-Surgery-General General Surgery
Field of Specialty 615; 616; 620 GSE Government Services Government Services
Field of Specialty 615; 616; 620 HAD Hospital Administration Hospital Administration
Field of Specialty 615; 616; 620 HEM Medicine-Hematology Hematology
Field of Specialty 615; 616; 620 HRM Hotel/Restaurant Management Hotel/Restaurant Management
Field of Specialty 615; 616; 620 HSA High School Administration High School Administration
Field of Specialty 615; 616; 620 HSM Health Services/Med Technology Health Services/Med Technology
Field of Specialty 615; 616; 620 HST Teaching-High School High School Teaching
Field of Specialty 615; 616; 620 HTM Health Tech-Medical,Dental Health Tech-Medical, Dental
Field of Specialty 615; 616; 620 HYP Hypnosis Hypnosis
Field of Specialty 615; 616; 620 IAI Insurance Adjuster,Investigator Insurance Adjuster, Investigator
Field of Specialty 615; 616; 620 IBA Investment Banker Investment Banker
Field of Specialty 615; 616; 620 IBR Investment Broker Investment Broker
Field of Specialty 615; 616; 620 ID Medicine-Infectious Diseases Infectious Diseases
Field of Specialty 615; 616; 620 IDE Interior Design Interior Design
Field of Specialty 615; 616; 620 IEX Import/Export Import/Export
Field of Specialty 615; 616; 620 IM Medicine-Internal Internal Medicine
Field of Specialty 615; 616; 620 IME Medicine-Industrial Industrial Medicine
Field of Specialty 615; 616; 620 INE Industrial Engineering Industrial Engineering
Field of Specialty 615; 616; 620 INF Medicine-Infertility Infertility
Field of Specialty 615; 616; 620 INT Intelligence Intelligence
Field of Specialty 615; 616; 620 ISD Internet Services/Development Internet Services/Development
Field of Specialty 615; 616; 620 JNE Journalism-Newspaper Journalism - Newspaper
Field of Specialty 615; 616; 620 LAD Law-Administrative Law-Administrative
Field of Specialty 615; 616; 620 LAE Law-Aviation & Aerospace Law-Aviation & Aerospace
Field of Specialty 615; 616; 620 LAG Law-Agricultural Law-Agricultural
Field of Specialty 615; 616; 620 LAP Law-Appellate Practice Law-Appellate Practice
Field of Specialty 615; 616; 620 LAR Medicine-Laryngology Laryngology
Field of Specialty 615; 616; 620 LAT Law-Antitrust & Trade Regulation Law-Antitrust & Trade Regulation
Field of Specialty 615; 616; 620 LBA Law-Banking & Finance Law-Banking & Finance
Field of Specialty 615; 616; 620 LBD Law-Bankruptcy Law-Bankruptcy
Field of Specialty 615; 616; 620 LBI Law-Biotechnology Law-Biotechnology
Field of Specialty 615; 616; 620 LBT Law-Business Transactions Law-Business Transactions
Field of Specialty 615; 616; 620 LC Law-Commercial Law-Commercial
Field of Specialty 615; 616; 620 LCC Law-Construction Law-Construction
Field of Specialty 615; 616; 620 LCL Law-Computer & Technology Law-Computer & Technology
Field of Specialty 615; 616; 620 LCM Law-Communications Law-Communications
Field of Specialty 615; 616; 620 LCN Law-Consumer Law-Consumer
Field of Specialty 615; 616; 620 LCO Law-Corporate Law-Corporate
Field of Specialty 615; 616; 620 LCR Law-Criminal Law-Criminal
Field of Specialty 615; 616; 620 LCT Law-Contracts Law-Contracts
Field of Specialty 615; 616; 620 LCU Law-Constitutional Law-Constitutional
Field of Specialty 615; 616; 620 LCV Law-Civil Rights Law-Civil Rights
Field of Specialty 615; 616; 620 LDC Law-Debtor & Creditor Law-Debtor & Creditor
Field of Specialty 615; 616; 620 LE Law-E-Commerce Law-E-Commerce
Field of Specialty 615; 616; 620 LEC Law Enforce,Correctns,Fire Protect Law Enforce,Correctns,Fire Protect
Field of Specialty 615; 616; 620 LED Law-Education Law-Education
Field of Specialty 615; 616; 620 LEL Law-Elder Law Law-Elder Law
Field of Specialty 615; 616; 620 LEM Law-Eminent Domain Law-Eminent Domain
Field of Specialty 615; 616; 620 LEP Law-Elect., Campaign & Political Law-Elect., Campaign & Political
Field of Specialty 615; 616; 620 LER Law-Energy Law-Energy
Field of Specialty 615; 616; 620 LES Law-Estate Planning/Succession Law-Estate Planning/Succession
Field of Specialty 615; 616; 620 LEV Law-Environmental Law-Environmental
Field of Specialty 615; 616; 620 LFA Law-Family/Domestic Relations Law-Family/Domestic Relations
Field of Specialty 615; 616; 620 LFO Law-Foreign/Offshore Investments Law-Foreign/Offshore Investments
Field of Specialty 615; 616; 620 LFR Law-Franchising Law-Franchising
Field of Specialty 615; 616; 620 LGC Law-Government Contracts Law-Government Contracts
Field of Specialty 615; 616; 620 LGO Law-Government Law-Government
Field of Specialty 615; 616; 620 LGP Law-General Practice Law-General Practice
Field of Specialty 615; 616; 620 LHC Law-Health Care Law-Health Care
Field of Specialty 615; 616; 620 LHO Law-Housing Law-Housing
Field of Specialty 615; 616; 620 LHR Law-Human Rights Law-Human Rights
Field of Specialty 615; 616; 620 LIB Librarian Librarian
Field of Specialty 615; 616; 620 LID Law-Indian & Native Populations Law-Indian & Native Populations
Field of Specialty 615; 616; 620 LIL Law-International Law-International
Field of Specialty 615; 616; 620 LIM Law-Immigration Law-Immigration
Field of Specialty 615; 616; 620 LIN Law-Insurance Law-Insurance
Field of Specialty 615; 616; 620 LIP Law-Intellectual Property Law-Intellectual Property
Field of Specialty 615; 616; 620 LIS Law-Insolvency Law-Insolvency
Field of Specialty 615; 616; 620 LJD Law-Judiciary Law-Judiciary
Field of Specialty 615; 616; 620 LLD Landscaping/Landscape Design Landscaping/Landscape Design
Field of Specialty 615; 616; 620 LLE Law-Legislative Law-Legislative
Field of Specialty 615; 616; 620 LLI Law-Litigation/Dispute Resolution Law-Litigation/Dispute Resolution
Field of Specialty 615; 616; 620 LLL Law-Labor/Emp./Collect. Bargaining Law-Labor/Emp./Collect. Bargaining
Field of Specialty 615; 616; 620 LLT Law Teacher Law Teacher
Field of Specialty 615; 616; 620 LM Law-Medical Law - Medical
Field of Specialty 615; 616; 620 LMA Law-Malpractice Law-Malpractice
Field of Specialty 615; 616; 620 LME Law-Media & Entertainment Law-Media & Entertainment
Field of Specialty 615; 616; 620 LMG Law-Mining & Utilities Law-Mining & Utilities
Field of Specialty 615; 616; 620 LMI Law-Military Law-Military
Field of Specialty 615; 616; 620 LMQ Law-Mergers & Acquisitions Law-Mergers & Acquisitions
Field of Specialty 615; 616; 620 LMU Law-Municipal Law-Municipal
Field of Specialty 615; 616; 620 LNE Law-Negligence/Personal Injury Law-Negligence/Personal Injury
Field of Specialty 615; 616; 620 LNR Law-Natural Resources Law-Natural Resources
Field of Specialty 615; 616; 620 LOC Law-Occupational Safety & Health Law-Occupational Safety & Health
Field of Specialty 615; 616; 620 LPB Law-Public Interest Law-Public Interest
Field of Specialty 615; 616; 620 LPC Law-Patent/Trademark/Copyright Law-Patent/Trademark/Copyright
Field of Specialty 615; 616; 620 LPD Law-Project Development Law-Project Development
Field of Specialty 615; 616; 620 LPF Law-Professional Liability Law-Professional Liability
Field of Specialty 615; 616; 620 LPI Law-Private International Law-Private International
Field of Specialty 615; 616; 620 LPK Law-Public Contract Law-Public Contract
Field of Specialty 615; 616; 620 LPL Law-Product Liability Law-Product Liability
Field of Specialty 615; 616; 620 LPN Law-Pension & Retirement Law-Pension & Retirement
Field of Specialty 615; 616; 620 LPP Law-Private Practice Law-Private Practice
Field of Specialty 615; 616; 620 LPT Law-Private Client Law-Private Client
Field of Specialty 615; 616; 620 LPU Law-Public Utility Law-Public Utility
Field of Specialty 615; 616; 620 LPY Law-Personal Injury Law-Personal Injury
Field of Specialty 615; 616; 620 LRE Law-Real Property Law-Real Property
Field of Specialty 615; 616; 620 LSE Law-Securities Law-Securities
Field of Specialty 615; 616; 620 LSP Law-Sports Law-Sports
Field of Specialty 615; 616; 620 LTA Law-Taxation Law-Taxation
Field of Specialty 615; 616; 620 LTC Law-Telecommunications Law-Telecommunications
Field of Specialty 615; 616; 620 LTL Law-Tort Law-Tort
Field of Specialty 615; 616; 620 LTR Law-Transportation Law-Transportation
Field of Specialty 615; 616; 620 LTS Law-Technology & Science Law-Technology & Science
Field of Specialty 615; 616; 620 LWE Law-Worker Compensation Law-Worker Compensation
Field of Specialty 615; 616; 620 LWO Law-Other Law-Other
Field of Specialty 615; 616; 620 LWP Law-Wills & Probate Law-Wills & Probate
Field of Specialty 615; 616; 620 LZL Law-Zoning & Land Use Law-Zoning & Land Use
Field of Specialty 615; 616; 620 MAC Medicine-Acute care Medicine-Acute care
Field of Specialty 615; 616; 620 MACH Medicine-Alternative & Complementary Medicine-Alternative and Complementary health
Field of Specialty 615; 616; 620 MADD Medicine-Addiction Medicine-Addiction
Field of Specialty 615; 616; 620 MAE Marine Engineering Marine Engineering
Field of Specialty 615; 616; 620 MAND Medicine-Andrology Medicine-Andrology
Field of Specialty 615; 616; 620 MANG Medicine-Angiology  Medicine-Angiology 
Field of Specialty 615; 616; 620 MAPN Nursing-Advanced practice Nursing-Advanced practice
Field of Specialty 615; 616; 620 MAT Mathematics Mathematics
Field of Specialty 615; 616; 620 MAUX Medicine-Auxology Medicine-Auxology
Field of Specialty 615; 616; 620 MBAR Medicine-Bariatrics Medicine-Bariatrics
Field of Specialty 615; 616; 620 MBMS Behavioral medicine/science Behavioral medicine/science
Field of Specialty 615; 616; 620 MCA Museum Curator or Administrator Museum Curator Or Administrator
Field of Specialty 615; 616; 620 MCC Medicine-Critical care Medicine-Critical care
Field of Specialty 615; 616; 620 MCH Mohs Chemosurgery Mohs Chemosurgery
Field of Specialty 615; 616; 620 MCHT Community health Community health
Field of Specialty 615; 616; 620 MCL Minister,Clergy Minister, Clergy
Field of Specialty 615; 616; 620 MCMN Nursing-Case management Nursing-Case management
Field of Specialty 615; 616; 620 MCO Management Consultant Management Consultant
Field of Specialty 615; 616; 620 MCOM Medicine-Conservation Medicine-Conservation
Field of Specialty 615; 616; 620 MCPR Medicine-Cardiopulmonary rehab Medicine-Cardiopulmonary rehabilitation
Field of Specialty 615; 616; 620 MDIS Medicine-Disaster Medicine-Disaster
Field of Specialty 615; 616; 620 ME Medical Education Medical Education
Field of Specialty 615; 616; 620 MEN Mechanical Engineering Mechanical Engineering
Field of Specialty 615; 616; 620 MEND Endodontics Endodontics
Field of Specialty 615; 616; 620 MENT Mental health Mental health
Field of Specialty 615; 616; 620 MENV Medicine-Environmental Medicine-Environmental
Field of Specialty 615; 616; 620 MEPI Medicine-Epileptology Medicine-Epileptology
Field of Specialty 615; 616; 620 MET Meteorologist Meteorologist
Field of Specialty 615; 616; 620 MFS Medicine-Surgery-Maxillofacial Maxillofacial Surgery
Field of Specialty 615; 616; 620 MGB Medicine-Gender-based Medicine-Gender-based
Field of Specialty 615; 616; 620 MGEN Medical genetics Medical genetics
Field of Specialty 615; 616; 620 MGER Medicine-Gerontology  Medicine-Gerontology 
Field of Specialty 615; 616; 620 MGH Global Health Global Health
Field of Specialty 615; 616; 620 MGM Management Management
Field of Specialty 615; 616; 620 MHAT Altitude training Altitude training
Field of Specialty 615; 616; 620 MHEP Medicine-Hepatology Medicine-Hepatology
Field of Specialty 615; 616; 620 MHIV Medicine-HIV/AIDS Medicine-HIV/AIDS
Field of Specialty 615; 616; 620 MHSY Health care systems Health care systems
Field of Specialty 615; 616; 620 MIM Medicine-Microbiology/Immunology Microbiology/Immunology
Field of Specialty 615; 616; 620 MIN Mining & Mineral Engineering Mining & Mineral Engineering
Field of Specialty 615; 616; 620 MKER Medicine-Keraunopathy Medicine-Keraunopathy
Field of Specialty 615; 616; 620 MMA Manufacturing Management Manufacturing Management
Field of Specialty 615; 616; 620 MMAT Medicine-Maternal/child Medicine-Maternal/child
Field of Specialty 615; 616; 620 MME Metallurgical & Materials Engineer. Metallurgical & Materials Engineer.
Field of Specialty 615; 616; 620 MMP Medical Management and Policy Medical Management and Policy
Field of Specialty 615; 616; 620 MNAS Medicine-Nurse anesthetist Medicine-Nurse anesthetist
Field of Specialty 615; 616; 620 MNOC Medicine-Nocturnist Medicine-Nocturnist
Field of Specialty 615; 616; 620 MOH Oral health Oral health
Field of Specialty 615; 616; 620 MOM Medicine-Oral and maxillofacial Medicine-Oral and maxillofacial
Field of Specialty 615; 616; 620 MPAL Medicine-Paleopathology  Medicine-Paleopathology 
Field of Specialty 615; 616; 620 MPER Periodontics Periodontics
Field of Specialty 615; 616; 620 MPHA Pharmaceutics Pharmaceutics
Field of Specialty 615; 616; 620 MPHC Pharmacognosy Pharmacognosy
Field of Specialty 615; 616; 620 MPHO Photomedicine Photomedicine
Field of Specialty 615; 616; 620 MPM Medicine-Pain management Medicine-Pain management
Field of Specialty 615; 616; 620 MPN Nursing-Perioperative Nursing-Perioperative
Field of Specialty 615; 616; 620 MPRD Prosthodontics Prosthodontics
Field of Specialty 615; 616; 620 MPUL Medicine-Pulmonology  Medicine-Pulmonology 
Field of Specialty 615; 616; 620 MRAD Medicine-Radiation therapy Medicine-Radiation therapy
Field of Specialty 615; 616; 620 MRE Mechanics & Repairs Mechanics & Repairs
Field of Specialty 615; 616; 620 MREP Medicine-Reproductive Medicine-Reproductive
Field of Specialty 615; 616; 620 MRES Medical Research Medical Research
Field of Specialty 615; 616; 620 MSC Medical Scientist Medical Scientist
Field of Specialty 615; 616; 620 MSER Medicine-Serology  Medicine-Serology 
Field of Specialty 615; 616; 620 MSEX Medicine-Sexual health Medicine-Sexual health
Field of Specialty 615; 616; 620 MSTA Medical Statistics Medical Statistics
Field of Specialty 615; 616; 620 MSTO Medicine-Stomatology Medicine-Stomatology
Field of Specialty 615; 616; 620 MTEL Medicine-Telemedicine Medicine-Telemedicine
Field of Specialty 615; 616; 620 MTR Medicine-Transplant Medicine-Transplant
Field of Specialty 615; 616; 620 MTRO Medicine-Tropical Medicine-Tropical
Field of Specialty 615; 616; 620 MUC Musician, Composer Musician, Composer
Field of Specialty 615; 616; 620 MWLD Medicine-Wilderness Medicine-Wilderness
Field of Specialty 615; 616; 620 MWOM Medicine-Womens health Medicine-Womens health
Field of Specialty 615; 616; 620 MWOU Medicine-Wound care Medicine-Wound care
Field of Specialty 615; 616; 620 NDI Medicine-Neoplastic Diseases Neoplastic Diseases
Field of Specialty 615; 616; 620 NEN Nuclear Engineering Nuclear Engineering
Field of Specialty 615; 616; 620 NEP Medicine-Nephrology Nephrology
Field of Specialty 615; 616; 620 NM Medicine-Nuclear Nuclear Medicine
Field of Specialty 615; 616; 620 NP Nursing Practitioner Nursing Practitioner
Field of Specialty 615; 616; 620 NPM Medicine-Neonatal-Perinatal Neonatal-Perinatal Medicine
Field of Specialty 615; 616; 620 NR Medicine-Neurology Neurology
Field of Specialty 615; 616; 620 NS Medicine-Neurological Surgery Neurological Surgery
Field of Specialty 615; 616; 620 NTR Nutrition Nutrition
Field of Specialty 615; 616; 620 NU Nursing Nursing
Field of Specialty 615; 616; 620 NUA Nursing-Administration Nursing-Administration
Field of Specialty 615; 616; 620 NUC Nursing-Clinical Nursing-Clinical
Field of Specialty 615; 616; 620 NUE Nursing-Educational Nursing-Educational
Field of Specialty 615; 616; 620 NUHH Nursing-Home Health Care Nursing-Home Health Care
Field of Specialty 615; 616; 620 NUM Nursing-Midwifery Nursing-Midwifery
Field of Specialty 615; 616; 620 NUR Nursing Research Nursing Research
Field of Specialty 615; 616; 620 OBG Medicine-Obstetrics/Gynecology Obstetrics/Gynecology
Field of Specialty 615; 616; 620 OES Other Education Specialist Other Education Specialist
Field of Specialty 615; 616; 620 OM Medicine-Occupational Occupational Medicine
Field of Specialty 615; 616; 620 ON Medicine-Oncology Oncology
Field of Specialty 615; 616; 620 OPH Opthamology Opthamology
Field of Specialty 615; 616; 620 OPT Optometrist Optometrist
Field of Specialty 615; 616; 620 ORA Operational Research or Analyst Operational Research or Analyst
Field of Specialty 615; 616; 620 ORS Medicine-Surgery-Orthopedic Orthopedic Surgery
Field of Specialty 615; 616; 620 OS Medicine-Surgery-Oral Oral Surgery
Field of Specialty 615; 616; 620 OST Medicine-Osteopathy Osteopathy
Field of Specialty 615; 616; 620 OTL Medicine-Otology Otology
Field of Specialty 615; 616; 620 OTO Medicine-Otorhinolaryngology Otorhinolaryngology
Field of Specialty 615; 616; 620 PA Medicine-Pharmacology Pharmacology
Field of Specialty 615; 616; 620 PAA Physicist,Astronomer,Astrophysicist Physicist,Astronomer,Astrophysicist
Field of Specialty 615; 616; 620 PAN Medicine-Pathology-Anatomic Pathology- Anatomic
Field of Specialty 615; 616; 620 PAP Medicine-Physician Asst, Parapro Physician Asst, Paraprofessional
Field of Specialty 615; 616; 620 PAR Performing Arts Performing Arts
Field of Specialty 615; 616; 620 PAT Medicine-Pathology Pathology
Field of Specialty 615; 616; 620 PCL Medicine-Pathology-Clinical Pathology- Clinical
Field of Specialty 615; 616; 620 PCV Peace Corps/Vista Peace Corps/Vista
Field of Specialty 615; 616; 620 PD Medicine-Pediatrics Pediatrics
Field of Specialty 615; 616; 620 PDA Medicine-Pediatrics-Allergy Pediatrics-Allergy
Field of Specialty 615; 616; 620 PDC Medicine-Pediatrics-Cardiology Pediatrics-Cardiology
Field of Specialty 615; 616; 620 PDE Medicine-Pathology-Dermatology Pathology- Dermatology
Field of Specialty 615; 616; 620 PDO Medicine-Pediatrics-Orthopedic Orthopedic Pediatrics
Field of Specialty 615; 616; 620 PDS Medicine-Pediatric Surgery Pediatric Surgery
Field of Specialty 615; 616; 620 PED Publishing/Editing Publishing/Editing
Field of Specialty 615; 616; 620 PEE Petroleum Engineering Petroleum Engineering
Field of Specialty 615; 616; 620 PEN Medicine-Pediatrics-Endocrinology Pediatrics- Endocrinology
Field of Specialty 615; 616; 620 PFO Medicine-Pathology-Forensic Pathology- Forensic
Field of Specialty 615; 616; 620 PH Medicine-Public Health Public Health
Field of Specialty 615; 616; 620 PHA Public Health Administration Public Health Administration
Field of Specialty 615; 616; 620 PHG Photographer Photographer
Field of Specialty 615; 616; 620 PHO Medicine-Pediatrics-Hematology-Oncology Pediatrics- Hematology-Oncology
Field of Specialty 615; 616; 620 PHT Pharmacist Pharmacist
Field of Specialty 615; 616; 620 PHY Medicine-Physician Physician
Field of Specialty 615; 616; 620 PM Medicine-Physical Medicine & Rehab Physical Medicine and Rehabilitation
Field of Specialty 615; 616; 620 PMD Product Management & Development Product Management & Development
Field of Specialty 615; 616; 620 PMG Medicine-Preventative-General Preventative Medicine, General
Field of Specialty 615; 616; 620 PNE Medicine-Pathology-Neuro Pathology- Neuro
Field of Specialty 615; 616; 620 PNP Medicine-Pediatric Nephrology Pediatric Nephrology
Field of Specialty 615; 616; 620 POD Podiatrist Podiatrist
Field of Specialty 615; 616; 620 PPU Medicine-Pediatrics-Pulmonology Pediatrics-Pulmonology
Field of Specialty 615; 616; 620 PR Medicine-Proctology Proctology
Field of Specialty 615; 616; 620 PRI Printer Printer
Field of Specialty 615; 616; 620 PS Medicine-Surgery-Plastic Plastic Surgery
Field of Specialty 615; 616; 620 PSN Medicine-Psychiatry & Neurology Psychiatry & Neurology
Field of Specialty 615; 616; 620 PSO Personal Services-Other Personal Services-Other
Field of Specialty 615; 616; 620 PSY Psychology Psychology
Field of Specialty 615; 616; 620 PUD Pulmonary Diseases Pulmonary Diseases
Field of Specialty 615; 616; 620 PUR Purchasing Purchasing
Field of Specialty 615; 616; 620 PY Medicine-Psychiatry Psychiatry
Field of Specialty 615; 616; 620 PYA Psychoanalysis Psychoanalysis
Field of Specialty 615; 616; 620 PYM Medicine-Psychosomatic Psychosomatic Medicine
Field of Specialty 615; 616; 620 RAI Railroad Railroad
Field of Specialty 615; 616; 620 RAN Ranching Ranching
Field of Specialty 615; 616; 620 RD Medicine-Radiology Radiology
Field of Specialty 615; 616; 620 RDI Medicine-Renal Disease Renal Disease
Field of Specialty 615; 616; 620 RED Real Estate Development/Mgmt Real Estate Development/Mgmt
Field of Specialty 615; 616; 620 REO Research-Other Research-Other
Field of Specialty 615; 616; 620 RHU Medicine-Rheumatology Rheumatology
Field of Specialty 615; 616; 620 RMO Retail Manager/Owner Retail Manager/Owner
Field of Specialty 615; 616; 620 RNU Medicine-Radiology-Nuclear Radiology- Nuclear
Field of Specialty 615; 616; 620 RP Medicine-Resident Physician Resident Physician
Field of Specialty 615; 616; 620 RPE Medicine-Pediatric Radiology Radiology- Pediatric
Field of Specialty 615; 616; 620 RRA Medicine-Radiology-Radioisotopic Radiology- Radioisotopic
Field of Specialty 615; 616; 620 RTA Recreation/Travel Agent Recreation/Travel Agent
Field of Specialty 615; 616; 620 RTH Medicine-Radiology-Therapeutic Radiology- Therapeutic
Field of Specialty 615; 616; 620 SBR Stock Broker Stock Broker
Field of Specialty 615; 616; 620 SCA Medicine-Surgery-Cardiovascular Surgery- Cardiovascular
Field of Specialty 615; 616; 620 SCO Medicine-Surgery-Colon & Rectal Surgery- Colon & Rectal
Field of Specialty 615; 616; 620 SCS Social/Community Services Social/Community Services
Field of Specialty 615; 616; 620 SEC Securities  Securities 
Field of Specialty 615; 616; 620 SFP Medicine-Surgery-Facial Plastic Surgery- Facial Plastic
Field of Specialty 615; 616; 620 SHA Medicine-Surgery-Hand Surgery- Hand
Field of Specialty 615; 616; 620 SHN Medicine-Surgery-Head And Neck Surgery- Head And Neck
Field of Specialty 615; 616; 620 SLS Sales Sales
Field of Specialty 615; 616; 620 SMA Sports Management Sports Management
Field of Specialty 615; 616; 620 SMC Medicine-Surgery-Mohs Chemo Surgery- Mohs Chemo
Field of Specialty 615; 616; 620 SME Medicine-Sports Sports Medicine
Field of Specialty 615; 616; 620 SOT Scientist-Other Scientist- Other
Field of Specialty 615; 616; 620 SSC Secretarial Services/Clerical Secretarial Services/Clerical
Field of Specialty 615; 616; 620 STA Statistician Statistician
Field of Specialty 615; 616; 620 STB Science Tech-Bio.,Chemical Science Tech-Bio.,Chemical
Field of Specialty 615; 616; 620 STR Medicine-Surgery-Traumatic Surgery- Traumatic
Field of Specialty 615; 616; 620 STU Medicine-Surgery-Tumor Surgery- Tumor
Field of Specialty 615; 616; 620 SUR Medicine-Surgery Surgery
Field of Specialty 615; 616; 620 THE Therapist Therapist
Field of Specialty 615; 616; 620 TO Trust Officer Trust Officer
Field of Specialty 615; 616; 620 TOX Toxicology Toxicology
Field of Specialty 615; 616; 620 TRU Trucking Trucking
Field of Specialty 615; 616; 620 TS Medicine-Surgery-Thoracic Thoracic Surgery
Field of Specialty 615; 616; 620 UND Underwriter Underwriter
Field of Specialty 615; 616; 620 UPL Urban Planner Urban Planner
Field of Specialty 615; 616; 620 UR Medicine-Urology Urology
Field of Specialty 615; 616; 620 VCA Venture Capital Venture Capital
Field of Specialty 615; 616; 620 VET Veterinarian Veterinarian
Field of Specialty 615; 616; 620 VS Medicine-Surgery-Vascular Vascular Surgery
Field of Specialty 615; 616; 620 WED Writing/Editing Writing/Editing

Field of Specialty

Field of Sub-Specialty || Field 616

Field of Work ( dictionary unavailable)

Business Email || Field 617

If available, this field will be populated with the constituent's work email address. Note that the email address in this field cannot be used with the eComm (Harris Connect) Email Marketing tool. Field 315 is the email that will be sent-to when using the Email Marketing tool. 

Business Website || Field 618

If available, this field willbe populated with the website of the constituent's employer. 

Medical Field of Study || Field 619

This field is primarily for Anschutz Medical Campus School of Medicine alumni. Employment field of work for employer “Medicine RIF- Non-CU” (for residency/internship).

Medical Field of Study (dictionary unavailable)

Medical Specialty Field of Study || Field 620

This field is primarily for Anschutz Medical Campus School of Medicine alumni. Employment field of specialty for employer “Medicine RIF – Non-CU” (for residency/internship).

Medical Specialty Field of Study (dictionary unavailable)

Faculty/Staff/Retirees- Campus || Field 621

This field is primarily for internal communications with CU faculty and staff and is populated when the Advance database receives data that includes "official" information from the CU HRMS database. A record is considered official when it includes a CU Employee ID (CED). 

Faculty/Staff/Retirees- Job Code || Field 622

This field is primarily for internal communications with CU faculty and staff and is populated when the Advance database receives data that includes "official" information from the CU HRMS database. A record is considered official when it includes a CU Employee ID (CED). 

Job Code

Faculty/Staff/Retirees- CU Department || Field 623

This field is primarily for internal communications with CU faculty and staff and is populated when the Advance database receives data that includes "official" information from the CU HRMS database. A record is considered official when it includes a CU Employee ID (CED). 

Department

Faculty/Staff/Retiree Type || Field 624

This field is primarily for internal communications with CU faculty and staff and is populated when the Advance database receives data that includes "official" information from the CU HRMS database. A record is considered official when it includes a CU Employee ID (CED). 

Field codes are:

FacultyStaffFaculty-Past (indictes retired)Staff-Past (indicates retired)

CU-Boulder || Field 700

Y/N This field is used to display CU-Boulder campus alumni and students in the online community directory (for searching). To add a record that isn’t a CU-Boulder alumnus or student, email

Advancement.Processing@cu.edu with the Constituent record's ID Number (field 315) and ask to have the record coded as ’1HARR’. The record should update overnight.

Anschutz Medical Campus || Field 701

Y/N This field is used to display Anschutz Medical Campus alumni, students, faculty/staff and parents in the online community directory (for searching). To add a record that isn’t an AMC alumnus, student, faculty/staff or parent, email Advancement.Processing@cu.edu with the Constituent record's ID Number and ask to have the record coded as ’2CUMT or 2HARR’. The record should update overnight.

CU Denver || Field 702

Y/N This field is used to display CU Denver alumni, students, faculty/staff and parents in the online community directory (for searching). To add a record that isn’t a CU Denver alumnus, student, faculty/staff or parent, email Advancement.Processing@cu.edu with the Constituent record's ID Number and ask to have the record coded as ’3OLC’. The record should update overnight.

UCCS || Field 703

Y/N This field is used to display UCCS alumni, students, faculty/staff and parents in the online community directory (for searching). To add a record that isn’t a UCCS alumnus, student, faculty/staff or parent, email Advancement.Processing@cu.edu with the Constituent record's ID Number and ask to have the record coded as ’4HARR’. The record should update overnight.

CU-Boulder parents || Field 704

Y/N This field is used to display CU-Boulder parents in the CU-Boulder parents online community directory (for searching). To add a record that isn’t a CU-Boulder parent, email Advancement.Processing@cu.edu with the Constituent record's ID Number and ask to have the record coded as ’4HARP’. The record should update overnight.

CU-Boulder Leeds School of Business || Field 705

Y/N This field is used to display CU-Boulder Leeds School of Business in the online community directory (for searching). To add a record that isn’t a CU-Boulder Leeds School of Business alumnus, email Advancement.Processing@cu.edu with the Constituent record's ID Number and ask to have the record coded as ’1HALL’. The record should update within a few days.

Facebook Profile URL || Field 722

If available, constituent record's updated profile and added their Facebook profile URL.

Twitter Handle || Field 723

If available, constituent record's updated profile and added their Twitter Handle.

LinkedIn Profile URL || Field 724

If available, constituent record's updated profile and added their LinkedIn Profile URL.

Committee Participation Current || Field 725

CU Boards and Committees

Committee Participation Former || Field 726

Former CU Boards and Committees

Executive MBA Alumnus || Field 727

Y/N  for any alumnus of the Executive MBA program

System/Foundation Student Activity || Field 728

Y/N List of student activity codes where the codes begin with an 8 or 9 (8=System Administration, 9=CU Foundation).

System/Fndtn Activity || Field 729

Y/N List of activity codes where the codes begin with an 8 or 9 (8=System Administration, 9=CU Foundation).

Lifetime Gift Club and Annual Gift Club || Fields 731 and 732

List of lifetime/annual gift clubs in which the Constituent record's is a member.

Advance Table Field Number Field Code Short Description Other Info
Gift Clubs 731; 732 1CC UCB Commencement Club Annual
Gift Clubs 731; 732 1CS UCB Chancellor’s Society Annual
Gift Clubs 731; 732 1DA UCB Dean’s Associate Annual
Gift Clubs 731; 732 1DB UCB Dean’s Benefactor Annual
Gift Clubs 731; 732 1DC UCB Dean’s Circle Annual
Gift Clubs 731; 732 2CC Anschutz Commencement Club Annual
Gift Clubs 731; 732 2CS Anschutz Chancellor’s Society Annual
Gift Clubs 731; 732 2DA Anschutz Dean’s Associate Annual
Gift Clubs 731; 732 2DB Anschutz Dean’s Benefactor Annual
Gift Clubs 731; 732 2DC Anschutz Dean’s Circle Annual
Gift Clubs 731; 732 3CC UCDD Commencement Club Annual
Gift Clubs 731; 732 3CS UCDD Chancellor’s Society Annual
Gift Clubs 731; 732 3DA UCDD Dean’s Associate Annual
Gift Clubs 731; 732 3DB UCDD Dean’s Benefactor Annual
Gift Clubs 731; 732 3DC UCDD Dean’s Circle Annual
Gift Clubs 731; 732 4CC UCCS Commencement Club Annual
Gift Clubs 731; 732 4CS UCCS Chancellor’s Society Annual
Gift Clubs 731; 732 4DA UCCS Dean’s Associate Annual
Gift Clubs 731; 732 4DB UCCS Dean’s Benefactor Annual
Gift Clubs 731; 732 4DC UCCS Dean’s Circle Annual
Gift Clubs 731; 732 6HF UCH Friends Annual
Gift Clubs 731; 732 6HP UCH Patrons Annual
Gift Clubs 731; 732 8CC CU System Commencement Club Annual
Gift Clubs 731; 732 8CS CU System Chancellor’s Society Annual
Gift Clubs 731; 732 8DA CU System Dean’s Associate Annual
Gift Clubs 731; 732 8DB CU System Dean’s Benefactor Annual
Gift Clubs 731; 732 8DC CU System Dean’s Circle Annual
Gift Clubs 731; 732 9CC CUF Commencement Club Annual
Gift Clubs 731; 732 9CS CUF Chancellor’s Society Annual
Gift Clubs 731; 732 9DA CUF Dean’s Associate Annual
Gift Clubs 731; 732 9DB CUF Dean’s Benefactor Annual
Gift Clubs 731; 732 9DC CUF Dean’s Circle Annual
Gift Clubs 731; 732 PCG Presidents’ Gold Annual
Gift Clubs 731; 732 PCN Presidents’ Norlin Annual
Gift Clubs 731; 732 PCS Presidents’ Silver Annual
Gift Clubs 731; 732 1HS UCB Heritage Society Lifetime
Gift Clubs 731; 732 2HS Anschutz Heritage Society Lifetime
Gift Clubs 731; 732 3HS UCDD Heritage Society Lifetime
Gift Clubs 731; 732 4HS UCCS Heritage Society Lifetime
Gift Clubs 731; 732 6HS UCH Heritage Society Lifetime
Gift Clubs 731; 732 8HS CU System Heritage Society Lifetime
Gift Clubs 731; 732 9HS CUF Heritage Society Lifetime
Gift Clubs 731; 732 HS Heritage Society Campus Unknown Lifetime
Gift Clubs 731; 732 LIF Presidents’ Lifetime Lifetime
Gift Clubs 731; 732 M1K Donor Milestone 100K Lifetime
Gift Clubs 731; 732 M1M Donor Milestone 1M Lifetime
Gift Clubs 731; 732 PCR President’s Circle Lifetime

CU Advocates Campus || Field 733

List of campus affiliations for the CU Advocates program

1 = CU-Boulder | 2 = Anschutz Medical Campus | 3 = CU Denver | 4 = UCCS | 8 = CU System | 9 = Advancement

CU Advocates Engagement Levels || Field 734

CU Advocates Engagement Levels.

Advance Table Field Number Field Code Short Description Other Info
Advocacy (Volunteer) 734 8AAD CU Advocates-Advocacy Day Attend CU Advocacy Day at the Capitol
Advocacy (Volunteer) 734 8ACS CU Advocates-Career Support Career support (mentoring, internships)
Advocacy (Volunteer) 734 8APE CU Advocates-Program Engagement Get more engaged with a CU program (specify program)
Advocacy (Volunteer) 734 8AHS CU Advocates-Host a Speaker Have a CU expert speak at an event
Advocacy (Volunteer) 734 8AHE CU Advocates-Host an Event Host a CU community event (legislative coffee or alumni gathering)
Advocacy (Volunteer) 734 8ACT CU Advocates-Campus Tour Schedule a tour of a CU campus (specify campus)
Advocacy (Volunteer) 734 8AVO CU Advocates-Volunteer for CU Volunteer for CU (Advocacy Day, events, fundraisers)
Advocacy (Volunteer) 734 PADV CU Advocates-Former Ambassadors Individuals who were part of the Ambassadors program prior to 2011
Advocacy (Volunteer) 734 8AMB CU Advocates-Ambassadors Individuals who were part of the Ambassadors program prior to Advocacy program
Advocacy (Volunteer) 734 8GRN CU Advocates-Government Relations News Receive legislative updates from Government Relations

Advocacy Engagement Levels

CU-Boulder Student Activity || Field 735, 743, 751, 759

List of activities Constituent record's was involved in while a student at CU-Boulder. This field includes codes that begin with 1 (1=CU-Boulder).

Student Activity

CU-Boulder Activity || Field 736, 744, 752, 760

Open in Excel >> CU-Boulder Activities List of activities Constituent record's is currently involved with CU-Boulder. This field includes codes that begin with 1 (1=CU-Boulder).

CU-Boulder Activity

CU-Boulder Sport || Field 737, 745, 753, 761

Open in Excel >> CU-Boulder Membership Type List of programs Constituent record's is a member of – generally for alumni. This field includes codes that begin with 1 (1=CU-Boulder).

 CU-Boulder Sport

CU-Boulder Awards and Honors || Field 738, 746, 754, 762

Open in Excel >> CU-Boulder Awards and Honors List of awards and honors Constituent record's received while a student at CU-Boulder (also applies to current students). This field includes codes that begin with 1 (1=CU-Boulder).

Awards & Honors

CU-Boulder Membership Type || Field 739

Open in Excel >> CU-Boulder Membership Type List of programs Constituent record's is a member of – generally for alumni. This field includes codes that begin with 1 (1=CU-Boulder).

 CU-Boulder Membership Type

CU-Boulder Membership End Date || Field 740 and 748

Open in Excel >> CU-Boulder Membership End Date List of membership end dates that Constituent record's is a member of – generally for alumni. This field includes codes that begin with 1 (1=CU-Boulder).

Parent Status Code || Field 741

C/P C=current parent and P=past parent

President's Leadership Class (PLC) Year || Field 742

Year associated with PLC student activity. If more than one, the latest year populates this field.

Anschutz Student Activity || Field 743

Open in Excel >> Anschutz Medical Campus Student Activities List of activities Constituent record's was involved in while a student at Anschutz Medical Campus. This field includes codes that begin with 2 (2=Anschutz Medical Campus).

Anschutz Student Activity || Field 744

Open in Excel >> Anschutz Medical Campus Activities List of activities Constituent record's is currently involved with CU-Boulder. This field includes codes that begin with 2 (2=Anschutz Medical Campus).

Anschutz Scholarships || Field 745

Open in Excel >> Anschutz Scholarships List of scholarship descriptions where the award honor codes begin with 2 or the allocation codes have 2 in the second character (2=Anschutz Medical Campus).

Anschutz Awards & Honors || Field 746

Open in Excel >> Anschutz Awards & Honors List of awards and honors codes where the codes begin with 2.

Membership Type || Field 747

Open in Excel >> Anschutz Medical Campus Membership Type ist of programs Constituent record's is a member of – generally for alumni. This field includes codes that begin with 2 (2=Anschutz Medical Campus).

advance table field code tms code short description  
Membership Type- Anschutz 747 2A Anschutz SOM Annual Anschutz School of Medicine Annual Membership
Membership Type- Anschutz 747 2B Anschutz SOME Lifetime Anschutz School of Medicine Lifetime Membership
Membership Type- Anschutz 747 2C Anschutz SON Annual Anschutz School of Nursing Annual Membership
Membership Type- Anschutz 747 2D Anschutz SON Lifetime Anschutz School of Lifetime Membership
Membership Type- Anschutz 747 2E Anschutz SOD Annual Anschutz School of Dentistry Annual Membership
Membership Type- Anschutz 747 2F Anschutz SOD Lifetime Anschutz School of Dentistry Lifetime Membership
Membership Type- Anschutz 747 2G Anschutz PT Annual Anschutz Physical Therapy Annual Membership
Membership Type- Anschutz 747 2H Anschutz PT Lifetime Anschutz Physical Therapy Lifetime Membership

Anschutz Medical Campus Membership End Date || Field 748

Open in Excel >> CU-Boulder Membership End Date List of membership end dates that Constituent record's is a member of – generally for alumni. This field includes codes that begin with 2 (2=Anschutz Medical Campus).

Append Project || Field 749

R = REMOVE FROM DATABASE
U = UNSUBSCRIBE
B = BOUNCED 
N = NO EMAIL 
D = DUPLICATE EMAIL 
A = ADDED EMAIL TO DATABASE 
All codes are appended with 313 (3 = Qrtr 3 and 13 = year 2013) for this project. 

Gender || Field 750

M= Male
F = Female
U = Unknown
Blank = Corporation/Business 

CU Denver Student Activity || Field 751

Open in Excel >> CU Denver Student Activities List of activities Constituent record's was involved in while a student at CU Denver. This field includes codes that begin with 3 (3=CU Denver).

CU Denver Activity || Field 752

Open in Excel >> CU Denver Activities List of activities Constituent record's is currently involved with CU Denver. This field includes codes that begin with 3 (3=CU Denver).

CU Denver Sports || Field 753

Open in Excel >> CU Denver Sports List of sports Constituent record's participated in while a student at CU Denver. This field includes codes that begin with 3 (3=CU Denver).

CU Denver Awards and Honors || Field 754

Open in Excel >> CU Denver Awards and Honors List of awards and honors Constituent record's received while a student at CU Denver (also applies to current students). This field includes codes that begin with 3 (3=CU Denver).

UCCS Student Activity || Field 759

Open in Excel >> UCCS Student Activities List of activities Constituent record's was involved in while a student at UCCS. This field includes codes that begin with 4 (4=UCCS).

UCCS Activity || Field 760

Open in Excel >> UCCS Activities List of activities Constituent record's is currently involved with UCCS. This field includes codes that begin with 4 (4=UCCS).

UCCS Sports || Field 761

Open in Excel >> UCCS Sports List of sports Constituent record's participated in while a student at UCCS. This field includes codes that begin with 4 (4=UCCS).

UCCS Awards and Honors || Field 762

Open in Excel >> UCCS Awards and Honors List of awards and honors Constituent record's received while a student at UCCS (also applies to current students). This field includes codes that begin with 4 (4=UCCS).

Do Not Email/Contact || Field 767

Y or blank

Field 767 pulls ‘Do Not Contact’ (email, phone and mail) contact preferences from the Advance database. Your admin permissions should already exclude records that have this field coded with a ‘Y’.

Recent Donor || Field 768

Y or blank Donor has given in the last 5 fiscal years including the current year.

Country of Citizenship || Field 769

Y or blank Country of citizenship if available and non-US.

Scholarship Recipient || Field 770

Y/N Received scholarships – if known

Record Type Description || Field 771, 772, 773

Fields 771, 772 and 773 identify the Constituent record's type (alumnus, donor, parent, student, faculty/staff or friend). Unlike Bruce Enews Unique Record Types field, which only flags primary affiliation/ record type). These fields flag up to 3 record types. Field 771 will contain the Constituent record's primary record type (alumni trumps all), field 772 contains the secondary record type and 773 contains the final record type. There are some records that have more than 3 records types. For example, someone could be a CU alumnus, a faculty member, a parent of a CU student and a donor. However, eComm only tracks the top three record types. If you need a deeper report of record types (beyond the first 3), contact your <a href=”http://ecomm.cu.edu/groups/users/ecomm-program-managers/”>eComm specialist</a>.

Record Type

Admin Name || Field 774

Populated with full name of admin account owner.

All group codes || Field 775

All Mail/Email || Field 776

Field 767 pulls Opt-In email preferences from the Advance database. If you know about a category in the Advance database (not Harris…), please tell your eComm specialist.

All Mail Email

Bruce Enews || Field 777

Field 777 is primarily used for President Benson’s monthly enewsletter. Each record is populated with only 1 record, based on primary affiliation. Alumni status trumps all.

Field Code Description
9SP CUF_Past_Staff
9SF CUF_Staff
9BX CUF_Past Board
9BD CUF_Board
8RG CUF_Regent Current or Past
8FS System Faculty/Staff
8AL System Alumni
4SX UCCS Former Student
4PX UCCS Student
4PA UCCS Past Parent
4FS UCCS Parent
4AL UCCS Faculty/Staff
4AL UCCS Alumni
3SX Denver Former Student
3ST Denver Student
3PX Denver Past Parent
3PA Denver Parent
3FS Denver Faculty/Staff
3AL Denver Alumni
2SX Anschutz Former Student
2ST Anschutz Student
2PX Anschutz Past Parents
2PA Anschutz Parent
2FS Anschutz Faculty/Staff
2AL Anschutz Alumni
1SX Boulder Former Student
1ST Boulder Student
1PX Boulder Past Parent
1PA Boulder Parent
1FS Boulder Faculty/Staff
1AL Boulder Alumni
PA Parent (no campus)
ORG Organization
FSX Past Faculty/Staff
FR Friends (no affiliation)
DNR Donor Friend
ST Former Student (no campus)

Campus Type School || Field 778

Note that the “c” prefix indicates the campus number, and the –ss on Alumni and Students indicates the school code as found in the affiliations information.

Field Code Description
cAL-ss Alumni
cRI RIF's
cFA Current CU Faculty
cSF Current CU Staff
cFX Retired CU Faculty
cSX Retired CU Staff
cPA Parents
cPX Past Parents
cST -ss Current Students
8RG Regents (Past & Present)
9BD Current Fdn Board Members
9BX Past Fdn Board Members
1$$ UCB Donors
2$$ AMC Donors
3$$ DNVR Donors
4$$ UCCS Donors
X$$ Other Donors
XFR Friends