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 Current term Year and term when the student is enrolled.

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

VARCHAR2(6) sfbetrm_term_code
PIDM Banner internal identifier Student's Banner-generated internal identifier, unique within each database. 8-digit number NUMBER(8) sfbetrm_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 Code, 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
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
DISABILITY Claims disability Student's declaration of disability.  MSU has not yet entered this indicator for all disabled students. Y or null VARCHAR2(1) sprmedi_medi_code in
('D1','D2','D3','D4')
VETERAN Claims veteran status Student's declaration of eligibility for Veteran's benefits. Y or null VARCHAR2(1) sgrvetn_vetc_code is not null
COUNTY_CODE Code for Montana county of origin Two-digit license plate code indicating student's Montana county of residence when admitted.  Null for students from outside Montana. Montana license plate codes; see stvcnty VARCHAR2(2) spraddr_cnty_code where
spraddr_atyp_code='OR' and
spraddr_to_date is null
COUNTY Montana county name Montana county name. 30 characters VARCHAR2(30) stvcnty_desc
STATE_CODE Code for state of origin Postal code indicating student's U.S. state or Canadian province of residence when admitted. Postal state codes; see stvstat VARCHAR2(3) spraddr_stat_code where
spraddr_atyp_code='OR' and
spraddr_to_date is null
STATE State name State name. 30 characters VARCHAR2(30) stvstat_desc
COUNTRY_CODE Code for country of origin Code for the student's country of residence when admitted.  Codes were developed by the International Standards Organization. ISO 3-character country codes; see stvnatn VARCHAR2(5) spraddr_natn_code where
spraddr_atyp_code='OR' and
spraddr_to_date is null
COUNTRY Country name Country name. 30 characters VARCHAR2(30) stvnatn_nation
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
NATN_CODE Code for nation of citizenship Code for nation of citizenship for noncitizens and permanent residents. Codes were developed by the International Standards Organization. ISO 3-character country codes; see stvnatn VARCHAR2(5) sprintl_natn_code_legal
NATIONALITY Nation of citizenship Name of nation of citizenship. 30 characters VARCHAR2(30) stvnatn_nation
ADMIT_CODE Admission type code Code indicating the student's type of admission. FT=Freshman Traditional
FN=Freshman Non-Trad
FE=Freshman Early Admit
TR=Transfer
GR=Graduate
ND=Nondegree
VARCHAR2(2) Crosswalked from saradap_admt_code
ADMIT_DESC Admission type Description of student's type of admission, as above. 30 characters  VARCHAR2(30) Programmed as above
ADMIT_TERM Term student admitted Year and term when the student was admitted. 6 characters:
4-digit year, plus
00-19=Winter
20-39=Spring
40-69=Summer
70-99=Fall
VARCHAR2(6) saradap_term_code_entry
PREV_COLLEGE_CODE Code for previous college attended Code for the college most recently attended by a tranfer student or graduate student. Codes were developed by ACT. 4 characters; see stvsbgi for MT college codes
UC=Other US College
FC=Foreign College
VARCHAR2(4)

sordegr_sbgi_code where
max(sordegr_attend_to) and stvsbgi_type_ind='C':
Montana colleges: sobsbgi_stat_code='MT'
other US colleges:sobsbgi_stat_code <>'MT' and ((sobsbgi_natn_code is null or sobsbgi_natn_code='USA') and not (sobsbgi_sbgi_code like 'CN%' or sobsbgi_sbgi_code like 'FC%' or sobsbgi_sbgi_code like 'GC%'))
foreign colleges: ((sobsbgi_natn_code is not null and sobsbgi_natn_code <>'USA') or (sobsbgi_sbgi_code like 'CN%' or sobsbgi_sbgi_code like 'FC%' or sobsbgi_sbgi_code like 'GC%'))

PREV_COLLEGE_DESC Previous college Name of college most recently attended. 30 characters VARCHAR2(4) stvsbgi_desc
PREV_COLLEGE_STATE Code for state of previous college State code for college most recently attended. Postal state codes; see stvstat VARCHAR2(3) sobsbgi_stat_code
HIGH_SCHOOL_CODE Code for previous high school attended High school previously attended by new freshmen student. Codes developed by ACT are used for Montana high schools, 6 characters; see stvsbgi for MT school codes
UH=Other US High School
FH=Foreign High School
VARCHAR2(6) sorhsch_sbgi_code where
max(sorhsch_graduation_date)and stvsbgi_type_ind='H':
Montana schools: sobsbgi_stat_code='MT'
other US schools: (sobsbgi_stat_code <>'MT' and sobsbgi_stat_code is not null) and (sobsbgi_natn_code ='USA' or stvsbgi_code not like 'ZH%' and not like '82%')
foreign schools: (sobsbgi_stat_code <>'MT' or sobsbgi_stat_code is null) and (sobsbgi_natn_code <>'USA' or stvsbgi_code like 'ZH%' or like '82%')
HIGH_SCHOOL_DESC High school Name of high school most recently attended. 30 characters VARCHAR2(30) stvsbgi_desc
HIGH_SCHOOL_STATE State code for previous high school State code for high school most recently attended. Postal state codes; see stvstat VARCHAR2(3) sobsbgi_stat_code
HS_GRAD_DATE High school graduation date Date of high school graduation. Date DATE sorhsch_graduation_date
HS_GPA High school GPA High school grade point average (GPA). 0-4.00 (may be higher if converted from another system) VARCHAR2(14) sorhsch_gpa
HS_RANK High school class rank Rank in high school graduating class. 4-digit number: 1 - maximum class size NUMBER(4) sorhsch_class_rank
HS_SIZE High school class size Number of students in high school graduating class. 4-digit number NUMBER(4) sorhsch_class_size
HS_PERCENTILE High school class percentile Percentile ranking in high school graduating class. 0-100 NUMBER(5,2) sorhsch_class_percentile
ACT_COMP ACT composite score ACT comprehensive score, if submitted. 1-36 NUMBER(5) sortest_test_score where
sortest_tesc_code='A05'
for max(A05)
ACT_ENGLISH ACT English score ACT English score, if submitted. 1-36 NUMBER(5) sortest_test_score where
sortest_tesc_code='A01'
for max(A05)
ACT_MATH ACT math score ACT math score, if submitted. 1-36 NUMBER(5) sortest_test_score where
sortest_tesc_code='A02'
for max(A05)
GED GED score General Eduational Development (GED) score, if submitted. 1-99 NUMBER(5) sortest_test_score where
sortest_tesc_code='GED'
GMAT GMAT score

Graduate Management Admission Test (GMAT) score, if submitted.

0-800 NUMBER(5) sortest_test_score where
sortest_tesc_code='G05'
GRE_VERBAL GRE verbal score

Graduate Record Examination (GRE) verbal score, if submitted.

200-800 NUMBER(5) sortest_test_score where
sortest_tesc_code='GR01'
for max(GR04)
GRE_QUANT GRE quantitative score

Graduate Record Examination (GRE) quantitative score, if submitted.

200-800 NUMBER(5) sortest_test_score where
sortest_tesc_code='GR02'
for max(GR04)
GRE_ANALYTIC GRE analytic score

Graduate Record Examination (GRE) analytic score, if submitted.

200-800 NUMBER(5) sortest_test_score where
sortest_tesc_code='GR03'
for max(GR04)
GRE_TOTAL GRE total score

Graduate Record Examination (GRE) total score, if submitted.

700-999 NUMBER(5) sortest_test_score where
sortest_tesc_code='GR04'
for max(GR04)
GRE_SUBJECT GRE subject score

Graduate Record Examination (GRE) subject area score, if submitted.

100-999 NUMBER(5) sortest_test_score where
sortest_tesc_code='GR05'
for max(GR05)
GRE_WRITING GRE writing score

Graduate Record Examination (GRE) writing score, if submitted.

100-999 NUMBER(5) sortest_test_score where
sortest_tesc_code='GR06'
for max(GR06)
SAT_VERBAL SAT verbal score

SAT verbal score, if submitted.

200-800 NUMBER(5) sortest_test_score where
sortest_tesc_code='S01'
for max(S01+S02)
SAT_MATH SAT math score

SAT math score, if submitted.

200-800 NUMBER(5) sortest_test_score where
sortest_tesc_code='S02'
for max(S01+S02)
TOEFL TOEFL score Test of English as a Foreign Language (TOEFL) score, if submitted. 1-999 NUMBER(5) sortest_test_score where
sortest_tesc_code='T02'
ASSET_NUMBERS Asset numbers score

Asset numbers score, if submitted.

0-99 NUMBER(5) sortest_test_score where
sortest_tesc_code='AAN'
ASSET_ALGEBRA Asset algebra score

Asset algebra score, if submitted.

0-99 NUMBER(5) sortest_test_score where
sortest_tesc_code='AAA'
ASSET_READING Asset reading score

Asset reading score, if submitted.

0-99 NUMBER(5) sortest_test_score where
sortest_tesc_code='AAR'
ASSET_WRITING Asset writing score

Asset writing score, if submitted.

0-99 NUMBER(5) sortest_test_score where
sortest_tesc_code='AAW'
COMPASS_ENGLISH Compass English score

Compass English score, if submitted.

0-999 NUMBER(5) sortest_test_score where
sortest_tesc_code='CMPE'
COMPASS_MATH Compass math score

Compass math score, if submitted.

0-999  NUMBER(5) sortest_test_score where
sortest_tesc_code='CMPM'
COMPASS_ALGEBRA Compass pre-algebra score

Compass pre-algebra score, if submitted.

0-999  NUMBER(5) sortest_test_score where
sortest_tesc_code='CMPA'
COMPASS_READING Compass reading score

Compass reading score, if submitted.

0-999  NUMBER(5) sortest_test_score where
sortest_tesc_code='CMPR'
COMPASS_WRITING Compass writing score

Compass writing score, if submitted.

0-999  NUMBER(5) sortest_test_score where
sortest_tesc_code='CMPW'
STU_LEVL Student level Academic level at which the student is enrolled. UG=Undergraduate
GR=Graduate
FP=First Professional
CE=Continuing Education
VARCHAR2(2) sgbstdn_levl_code
FT_PT Full-time/part-time status Indicates whether  student is enrolled full time or part time.  Full-time undergraduates and all nondegree students carry 12 or more credits, and full-time graduate students carry 9 or more credits. F=Full time
P=Part time
Null for continuing education
VARCHAR2(1) calculated from sfrstcr_credits; full time is 12 or more for undergraduates and nondegree students, 9 or more for graduate students
MATRIC_TERM Matriculation term Year and term the student enrolled. 4-digit year, plus
00-19=Winter
20-39=Spring
40-69=Summer
70-99=Fall
VARCHAR2(6) sgbstdn_term_code_matric
STU_TYPE Student type code Indicates student's type for the current term; see codes for further explanation. 0=Undeclared
C=Continuing E=Adult/Continuing Education
N=New First Time
R=Returning
S=Special
T=Transfer
X=Transient
VARCHAR2(1) sgbstdn_styp_code
STU_DESC Student type Description of student's type, as above. 30 characters VARCHAR2(30) stvstyp_desc
STU_CAT Student category code Student's current enrollment category; distinguishes degree-seeking from non-degree-seeking students and identifies degree-seeking students by class. NU=Nondegree Undergraduate
EA=Early Admit
FR=Freshman
SO=Sophomore
JR=Junior
SR=Senior
PB=Postbaccalaureate
NG=Nondegree Graduate
GM=Graduate Masters
LW=Law
SP=Specialist
GD=Graduate Doctoral
VARCHAR2(3) Programmed from
sgbstdn_levl_code
sgbstdn_degc_code
f_calc_class
sgbstdn_admt_code
STU_CAT_DESC Student category Description of student's current category, as above. 30 characters VARCHAR2(30) Programmed as above
STU_CAT_SORT Sort order for student category Numerical field which sorts student categories from lowest to highest. 1=Nondegree Undergraduate
2=Early Admit
3=Freshman
4=Sophomore
5=Junior
6=Senior
7=Postbaccalaureate
8=Nondegree Graduate
9=Graduate Masters
10=Law
11=Specialist
12=Graduate Doctoral
NUMBER(2) Programmed
STATE_CREDITS State-funded credits attempted for term Credits funded by state appropriations. 6-digit number (2 decimals) NUMBER(6,2) sum(sfrstcr_credit_hr) where
stvrsts_incl_sect_enrl='Y' and
ssbsect_tuiw_ind is null or 'N'
OTHER_CREDITS Continuing education and other credits attempted for term Credits funded by non-state sources, such as continuing education. 6-digit number (2 decimals) NUMBER(6,2) sum(sfrstcr_credit_hr) where
stvrsts_incl_sect_enrl='Y' and
ssbsect_tuiw_ind='Y'
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'
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
FEE_CODE Fee code by level Code indicating upper- or lower-division standing for fee assessment at UM-Missoula.  Null for other campuses.

L=Lower division
U=Upper division

VARCHAR2(1)  
CAMPUS_HOUSING Type of campus housing Indicates whether the student lives in a residence hall or in family housing. R=Residence Hall
F=Family Housing
Null otherwise
VARCHAR2(1) Programmed from stvbldg_code (R) or mailing address (F)
TERM_GPA End of term GPA Student's term grade point average (GPA) at end of the current term. 16-digit number (10 decimals) NUMBER(16,10) shrtgpa_gpa where
shrtgpa_type_ind='I'
TERM_CREDITS End of term credits earned Total credits earned by the student at end of the current term. 7-digit number (4 decimals) NUMBER(7,4) shrtgpa_hours_earned where
shrtgpa_type_ind='I'
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'
ACAD_STANDING Most recent academic standing Student's current academic standing; updated at end of term if academic standing has changed. G=Good
D=Dean's List/Honor Roll
P=Probation
S=Suspension
R=Reinstated
A=Admitted on Probation
VARCHAR2(1) Crosswalked from shrttrm_astd_code
TRANSFER_OUT Transferred to other school Indicates whether the student has transferred to another institution.  This information will be obtained from the National Student Loan Clearinghouse at some time in the future. Y or null VARCHAR2(1) Downloaded from NSLC tape (later)
DECEASED Deceased Indicates whether the student died during the current term. Y or null VARCHAR2(1) spbpers_dead_ind
SPORTS Primary sport for GRS Indicates varsity athletic sport if the student is a scholarship athlete. Sport categories are those used by the federal IPEDS Graduation Rate Survey. F=Football
B=Basketball
T=Track/Cross Country
O=Other
VARCHAR2(1) Crosswalked from sgrsprt_actc_code
ATHLETIC_AID Athletic aid recipient Indicates whether the student is an athletic scholarship recipient. Y or null VARCHAR2(1) sgrsprt_athl_aid_ind
DEGREE1 Primary degree code Code for the primary degree for which the student is enrolled. 4 characters; see stvdegc VARCHAR2(4) sgbstdn_degc_code_1
DEGREE1_DESC Primary degree Name of student's primary degree. 30 characters VARCHAR2(30) stvdegc_desc
COLLEGE1 Code for college of primary degree Code for the college within the institution offering the student's primary degree. 2 characters; see stvcoll VARCHAR2(2) sgbstdn_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 in which  the student is enrolled. 4 characters; see stvmajr VARCHAR2(4) sgbstdn_majr_code_1
MAJOR1_DESC Primary major Name of student's primary major. 30 characters VARCHAR2(30) stvmajr_desc
MAJOR1_CIP CIP code of first major Federal CIP (Classification of Instructional Programs) code for the student's primary major. 6 characters; see stvcipc VARCHAR2(6) stvmajr_majr_cipc_code
CONC1 Concentration code for primary major Code for the primary concentration in which the student is enrolled, if any. 4 characters; see stvmajr or null VARCHAR2(4) sgbstdn_majr_code_conc_1
CONC1_DESC Primary concentration Name of student's primary concentration. 30 characters VARCHAR2(30) stvmajr_desc
DEPT1 Department code for first 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) sgbstdn_dept_code
DEPT1_DESC Department Name of the student's primary department. 30 characters VARCHAR2(30) stvdept_desc
DEGREE2 Second degree code Code for the secondary degree in which the student is enrolled, if any. 4 characters; see stvdegc or null VARCHAR2(4) sgbstdn_degc_code_2
DEGREE2_DESC Second degree Name of student's secondary degree. 30 characters VARCHAR2(30) stvdegc_desc
COLLEGE2 College code for second degree Code for the college within the institution offering the student's secondary degree. 2 characters; see stvcoll or null VARCHAR2(2) sgbstdn_coll_code_2
COLLEGE2_DESC College Name of student's secondary college. 30 characters VARCHAR2(30) stvcoll_desc
MAJOR2 Second major code or second degree major code Code for the secondary major in which  the student is enrolled, if any. 4 characters; see stvmajr or null VARCHAR2(4) sgbstdn_majr_code_1_2 or
sgbstdn_majr_code_2
MAJOR2_DESC Second major Name of secondary major. 30 characters VARCHAR2(30) stvmajr_desc
MAJOR2_CIP CIP code for second major or second degree major Federal CIP (Classification of Instructional Programs) code for the student's secondary major 6 characters; see stvcipc or null VARCHAR2(6) stvmajr_cipc_code
CONC2 Concentration  code for second major or second degree major Code for the secondary concentration in which the student is enrolled, if any. 4 characters; see stvmajr or null VARCHAR2(4) sgbstdn_majr_code_conc_1_2 or
sgbstdn_majr_code_conc_2
CONC2_DESC Second concentration Name of student's secondary concentration. 30 characters VARCHAR2(30) stvmajr_desc
DEPT2 Department code for second major or second degree major Code for the department offering the student's secondary major; this information is not recorded by UM-Missoula. 4 characters; see stvdept or null VARCHAR2(4) sgbstdn_dept_code_1_2 or
sgbstdn_dept_code_2
DEPT2_DESC Department Name of student's secondary department. 30 characters VARCHAR2(30) stvdept_desc
MINOR1 First minor code Code for first minor in which student is enrolled, if any. 4 characters; see stvmajr or null VARCHAR2(4) sgbstdn_majr_code_minr_1
MINOR1_DESC First minor Name of student's first minor. 30 characters VARCHAR2(30) stvmajr_desc
MINOR2 Second minor code Code for second minor in which student is enrolled, if any. 4 characters; see stvmajr or null VARCHAR2(4) sgbstdn_majr_code_minr_1_2 or
sgbstdn_majr_code_minr_2 or
sgbstdn_majr_code_minr_2_2
MINOR2_DESC Second minor Name of student's second minor, if any. 30 characters VARCHAR2(30) stvmajr_desc
STREET1_LINE1 Local address, line 1 First line of student's local address. 30 characters VARCHAR2(30) spraddr_street_line1(MA>CA>PR)
STREET1_LINE2 Local address, line 2 Second line of student's local address. 30 characters VARCHAR2(30) spraddr_street_line2(MA>CA>PR)
STREET1_LINE3 Local address, line 3 Third line of student's local address. 30 characters VARCHAR2(30) spraddr_street_line3(MA>CA>PR)
CITY1 Local city City of student's local address. 20 characters VARCHAR2(20) spraddr_city(MA>CA>PR)
STATE1 Local state code State of student's local address. 3 characters VARCHAR2(3) spraddr_stat_code(MA>CA>PR)
ZIP1 Local ZIP code ZIP code of student's local address. 10 characters VARCHAR2(10) spraddr_zip(MA>CA>PR)
NATN1 Local nation Country code for student's local address. 30 characters VARCHAR2(30) spraddr_natn_code ->stvnatn_nation(MA>CA>PR)
PHONE1_AREA Local phone area code Area code associated with student's local address. 3 characters VARCHAR2(3) sprtele_phone_area where
spraddr_atyp_code=sprtele_tele_code
PHONE1_NUMBER Local phone number Phone number associated with student's local address. 7 characters VARCHAR2(7) sprtele_phone_number where
spraddr_atyp_code=sprtele_tele_code
STREET2_LINE1 Away address, line 1 First line of student's permanent address. 30 characters VARCHAR2(30) spraddr_street_line1(PR>MA>CA)
STREET2_LINE2 Away address, line 2 Second line of student's permanent address. 30 characters VARCHAR2(30) spraddr_street_line2(PR>MA>CA)
STREET2_LINE3 Away address, line 3 Third line of student's permanent address. 30 characters VARCHAR2(30) spraddr_street_line3(PR>MA>CA)
CITY2 Away city City of student's permanent address. 20 characters VARCHAR2(20) spraddr_city(PR>MA>CA)
STATE2 Away state code State of student's permanent address. 3 characters VARCHAR2(3) spraddr_stat_code(PR>MA>CA)
ZIP2 Away ZIP code ZIP code of student's permanent address. 10 characters VARCHAR2(10) spraddr_zip(PR>MA>CA)
NATN2 Away nation Country code for student's permanent address. 30 characters VARCHAR2(30) spraddr_natn_code ->stvnatn_nation(PR>MA>CA)