Data Element Definition Description Codes Data Type MSU Source
STUDENT_CAMPUS Student's campus affiliation and location

University identifies whether the campus where the student is enrolled is a UM campus or an MSU campus.

Main Campus refers to the individual campus where the student is enrolled. 

Student Location indicates the physical location of the student - either one of the MUS campuses or off campus taking distance-delivered courses.

3 characters:

University
U=UM
M=MSU

Main Campus
Z=Bozeman
L=Billings
V=Havre
F=Great Falls
C=Billings COT
M=UM Missoula
T=College of Technology at Missoula
W=Western Montana College
H=Helena College of Technology
N=Montana Tech
S=College of Technology at Butte

Student Location
Main Campus code or
D=distance

For example, MVF = Montana State University, Northern, Great Falls campus
VARCHAR2(3) Programmed
TERM Completion term Year and term of student's degree application.

6 characters:
4-digit year, plus
00-19=Winter
20-39=Spring
40-69=Summer
70-99=Fall

VARCHAR2(6) shrdgmr_term_code
PIDM Banner internal identifier Student's Banner-generated internal identifier, unique within each database. 8-digit number NUMBER(8) shrdgmr_pidm
ID Banner student identifier Student's ID number used on campus, unique within each database. 9 characters VARCHAR2(9) spriden_id
MUSIC MUS identifier Student's Montana University System Identification C ode, intended to be a unique identifier for each student in the MUS.  If available, the student's Social Security Number is used.  If not, an identifier is created based  on campus and PIDM. 10 characters VARCHAR2(10) SSN or
main campus ID or
main campus code plus campus PIDM
EVENT Data extract type Indicates whether data extract is current (previous day), 15th day, or end of term. 15 characters:
Term+Current
Term+15th
Term+EOT
VARCHAR2(15) Programmed
SSN Social Security Number Student's Social Security Number. 9 characters VARCHAR2(9) spbpers_ssn
CONF Confidential information Indicates whether student has requested that directory information be kept confidential.  Directory information includes name, address, phone, major, class, attendance dates, and degrees awarded. Y or null VARCHAR2(1) spbpers_confid_ind
LAST_NAME Last name Student's last name. 60 characters VARCHAR2(60) spriden_last_name
FIRST_NAME First name Student's first name. 15 characters

VARCHAR2(15)

spriden_first_name
MIDDLE_NAME Middle name Student's middle name. 15 characters VARCHAR2(15) spriden_mi
NAME_SUFFIX Name suffix Student's name suffix, such as 'Jr' or 'III' 20 characters VARCHAR2(20) spbpers_name_suffix
GENDER Gender Student's declared gender. F=Female
M=Male
N=Not reported
VARCHAR2(1) spbpers_sex
ETHNIC_CODE Ethnicity code Code for student's declared race/ethnicity, if reported. Students are not required to report race/ethnicity. 1=White
2=Black
3=Hispanic
4=Asian
5=Indian
6=Other
7 or null=Missing
VARCHAR2(1) substr(spbpers_ethn_code,1,1)
ETHNIC Ethnicity Race/ethnicity description, as above. 30 characters VARCHAR2(30) Programmed as above
TRIBE_CODE Tribal affiliation code Code for regional tribe with which student is affiliated, if any.  Tribes are specified by the OCHE for their TRACKS project, which studies the academic progress of Native American students. A=Blackfeet-no reservation
B=Blackfeet-Blackfeet res
C=Crow-no reservation
D=Crow-Crow res
E=Salish-no reservation
F=Salish-Salish/Kootenai res
G=Kootenai-no reservation
H=Kootenai-Salish/Kootenai res
I=Assiniboine-no reservation
J=Assiniboine-Fort Belknap res
K=Gros Ventre-no reservation
L=Gros Ventre-Fort Belknap res
M=Assiniboine-Fort Peck res
N=Sioux-no reservation
O=Sioux-Fort Peck res
P=Northern Cheyenne-no reservation
Q=Northern Cheyenne-Nor Cheyenne res
R=Chippewa-no reservation
S=Chippewa-Rocky Boy res
T=Chippewa-Little Shell band
U=Cree-no reservation
V=Cree-Rocky Boy res
W=Chippewa-Turtle Mountain res
X=Other tribal affilitation
VARCHAR2(1) substr(spbpers_ethn_code,2,1)
TRIBE Tribal affiliation

Tribal affiliation description, as above.

30 characters VARCHAR2(30) stvethn_ethn_desc where
substr(spbpers_ethn_code,2,1) is not null
CITIZEN US citizen Indicates whether the student is a US citizen.  Noncitizens and permanent residents are coded 'N.' Y=Citizen
N=Noncitizen
VARCHAR2(1) spbpers_citz_code (R=N)
VISA_TYPE Visa type code Federal codes indicating the type of visa held by noncitizens and permanent residents. 00=To be determined
B2=Tourist
F1=Academic student
F2=Dependent of academic student
H1=Special
H2=Dependent of special
J1=Exchange scholar
J2=Dependent of exchange scholar
M1=Vocational student
M2=Dependent of vocational student
OT=Other
PR=Permanent resident
VARCHAR2(2) sprintl_vtyp_code_current
BIRTH_DATE Birth date Student's date of birth Date DATE spbpers_birth_date
AGE Current age Student's current age 3-digit number NUMBER(3) Calculated from spbpers_birth_date
RESD_STATUS Residency status Student's residency status for fee assessment.  In-state students must satisfy residency requirements established by the Board of Regents.  Criteria for WUE (Western Undergraduate Exchange) status vary by institution. I=In State
O=Out of State
U=WUE
VARCHAR2(1) sgbstdn_resd_code
STU_LEVL Student level Academic level at which the student is enrolled. UG=Undergraduate
GR=Graduate
FP=First Professional
CE=Continuing Education
VARCHAR2(2) shrdgmr_levl_code
INST_GPA Institutional GPA Grade point average (GPA) based on credits earned by the student at the current school. 16-digit number (10 decimals) NUMBER(16,10) shrlgpa_gpa where
shrlgpa_type_ind='I'
INST_CREDITS Institutional credits earned Total credits earned by the student at the current school. 7-digit number (4 decimals) NUMBER(7,4) shrlgpa_hours_earned where
shrlgpa_type_ind='I'
TOTAL_CREDITS Total credits earned Total credits earned by the student at the current school and any credits transferred from other schools. 7-digit number (4 decimals) NUMBER(7,4) shrlgpa_hours_earned where
shrlgpa_type_ind='O'
SUBSIDIZED_CREDITS State subsidized credits Number of state-subsidized credits earned by the student at end of the current term. 0-170 (may be higher in rare cases) VARCHAR2(3) sortest_test_score where
sortest_tesc_code='SUB'
less
sortest_test_score
where sortest_tesc_code='SUBA'
AWARD_CAT_CODE Award category code Code for category of student's certificate or degree. 21=Postsec cert <1 yr
22=Postsec cert >1<2 yr
23=Associate degree
24=Baccalaureate degree
25=Postsec cert>2<4 yr
31=First prof degree
32=Post prof degree
41=Postbacc cert
42=Masters degree
43=Post Masters cert
44=Doctoral degree
VARCHAR2(2) shrdgmr_degc_code->
stvdegc_acat_code
AWARD_CAT_DESC Award category Description of student's certificate or degree category, as above. 30 characters VARCHAR2(30) stvacat_desc
DEGREE Degree code Code for degree awarded to the student. 4 characters; see stvdegc VARCHAR2(4) shrdgmr_degc_code
DEGREE_DESC Degree Name of student's degree. 30 characters VARCHAR2(30) stvdegc_desc
COLLEGE1 Code for college of  primary major Code for the college within the institution offering the student's primary degree 4 characters; see stvcoll VARCHAR2(2) shrdgmr_coll_code_1
COLLEGE1_DESC College Name of the college. 30 characters VARCHAR2(30) stvcoll_desc
MAJOR1 Primary major code Code for the primary major with which the student graduated. 4 characters; see stvmajr VARCHAR2(4) shrdgmr_majr_code_1
MAJOR1_DESC Primary major Name of student's primary major. 30 characters VARCHAR2(30) stvmajr_desc
MAJOR1_CIP CIP code for primary major Federal CIP (Classification of Instructional Programs) code for the student's primary major. 4 characters; see stvcipc VARCHAR2(6) stvmajr_majr_cipc_code
CONC1 Concentration code for primary major Code for the primary concentration with which the student graduated, if any. 4 characters; see stvmajr or null VARCHAR2(4) shrdgmr_majr_code_conc_1
CONC1_DESC Primary concentration Name of the student's primary concentration. 30 characters VARCHAR2(30) stvmajr_desc
DEPT1 Department code for primary major

Code for the department offering the student's primary major; this information is not recorded by UM-Missoula.

4 characters; see stvdept VARCHAR2(4) shrdgmr_dept_code
DEPT1_DESC Department Name of the student's primary department. 30 characters VARCHAR2(30) stvdept_desc
COLLEGE2 College code for second major Code for the college within the institution offering the student's second major, if any. 2 characters; see stvcoll or null VARCHAR2(2) shrdgmr_coll_code_2
COLLEGE2_DESC College Name of the college. 30 characters VARCHAR2(30) stvcoll_desc
MAJOR2 Second major code Code for the secondary major with which the student graduated, if any. 4 characters; see stvmajr or null VARCHAR2(4) shrdgmr_majr_code_1_2 or shrdgmr_majr_code_2
MAJOR2_DESC Second major Name of student's secondary major. 30 characters VARCHAR2(30) stvmajr_desc
MAJOR2_CIP CIP code for second major Federal CIP (Classification of Instructional Programs) code for the student's secondary major, if any. 6 characters; see stvcipc or null VARCHAR2(6) stvmajr_cipc_code
CONC2 Concentration code for second major Code for the secondary concentration with which the student graduated, if any. 4 characters; see stvmajr or null VARCHAR2(4) shrdgmr_majr_code_conc_1_2 or
shrdgmr_majr_code_conc_2
CONC2_DESC Second concentration Name of the student's secondary concentration. 30 characters  VARCHAR2(30) stvmajr_desc
DEPT2 Department code for second major

Code for the department offering the student's secondary major, if any; this information is not recorded by UM-Missoula.

4 characters; see stvdept or null VARCHAR2(4) shrdgmr_dept_code_1_2 or
shrdgmr_dept_code_2
DEPT2_DESC Department Name of the student's secondary department. 30 characters VARCHAR2(30) stvdept_desc
MINOR1 First minor code Code for the first minor with which the student graduated, if any. 4 characters; see stvmajr or null VARCHAR2(4) shrdgmr_majr_code_minr_1
MINOR1_DESC First minor Name of first minor. 30 characters VARCHAR2(30) stvmajr_desc
MINOR2 Second minor code Code for the second minor with which the student graduated, if any. 4 characters; see stvmajr or null VARCHAR2(4) shrdgmr_majr_code_minr_1_2 or
shrdgmr_majr_code_minr_2 or
shrdgmr_majr_code_minr_2_2
MINOR2_DESC Second minor Name of second minor. 30 characters VARCHAR2(30) stvmajr_desc