*APPLICATION_ID |
Varchar2(11) |
ID number assigned by Datatel system to be used internally. A unique identifier for each
application. |
PERSON_ID |
Varchar2(7) |
A unique identifier for a person (applicant, student, instructor,
etc.) assigned by Datatel system and will never be changed throughout the
individual’s relationship with the University. This is not the same as Campus_ID. |
PERSON_ORIGIN |
Varchar2(6) |
Code indicating how the recruit was referred to the institution.
WALK Walk-in
PHNE Phone
WEF Wisconsin
Education Fairs
MPLS Mpls Nat
College Fair
MILW Milw Nat
College Fair
FAC Faculty/Staff Referral
ALUM Alumni Referral
ACT ACT
Tape
SAT SAT Tape
PRVW Preview Day
NMSF Nat Merit Semi-Final
TRANS Transcript
EOS EOS ACT Tape
COACH Athletic
Coach
REPLY Reply
Card (Stout)
MAIL Mail Request
HSV High
School Visit
EMPL Employee
OTHR Other
Referral
COLL College
Day/Night
EM E-Mail Request
GRE GRE
Tape
TOEFL TOEFL
Tape
HLP UW-System
HELP Office
APPN Application
PD Program
Director
MREG Mail-In
Registration
WREG Walk-In
Registration
CER Cont
Ed Registration
CEI Cont
Ed Intent
ALB Albert
Lee PHSPP
RVR Riverland PHSPP
WIN Winona
PHSPP
ROCH Rochester
PHSPP
NORM Normandale PHSPP
ANKA Anoka-Ramsey
PHSPP
INVR Inver
Hill PHSPP
CVT Conversion
PSV Post-Secondary
Visit
PREC Pre-College
STEPS STEPS
UPBND Upward
Bound
WHO Who's
Who
AUS Austin
PHSPP
FAFSA FAFSA
Results
LIB Library
Learning Center
IRS Instr Resources
Services
RDS Residence
Dining Serv
FEL Fin Aid Electronic Loan
ALEX Alexandria
PHSPP
BRND Brainerd PHSPP
STCL St Cloud PHSPP
PINE Pine City PHSPP
DLTH Duluth
PHSPP
HIBB Hibbing
PHSPP
GRRP Grand Rapids PHSPP
HTN Hometown
Newspapers
DRV Driver Authorization
CENT Century College PHSPP |
PERSON_ORIGIN_DATE |
Date(19) |
Date the person origin code as entered into the system |
PERSON_ORIGIN_DESC |
Varchar2(10) |
Description of the person origin code. See Person Origin Code above. |
PROSPECT_CREATE_DATE |
Date(19) |
Date the recruit was entered into the system. |
ADMIT_TERM |
Varchar2(8) |
Term the applicant applied for. |
ADMIT_STATUS |
Varchar2(5) |
Code indicating the type of admission.
DL Dual-Level Grad
FR New Freshman
GA Add'l Program, Grad
GR First-Time Grad
RE Re-Entry
RT Transfer-Reentry
SC Special, Cont Ed
UG
SG Special, Grad
SH Special, HS/PSEO
SP Special, UG
TR Transfer |
ADMIT_STATUS_DESC |
Varchar2(30) |
Description of the applicant’s admit type. See Admit Status above. |
ADMIT_APPL_DATE |
Date(19) |
Date the application was entered. |
APPL_STUDENT_TYPE |
Varchar2(5) |
Applicant status.
UG – Undergraduate,
UL – Undergraduate Level –Laptop,
ULE – Undergrad MSEP Participant,
GR – Graduate,
GL – Graduate Per Credit
GLE _ Grad MSEP Participant |
APPL_COLLEGE |
Varchar2(4) |
Code of the UW-Stout
College to which the applicant
has applied
5200 College
of Arts and Sciences
5300 College
of Human Development
5400 College
of Technology, Engineering and
Management |
APPL_COLLEGE_DESC |
Varchar2(30) |
Description of the UW-Stout
College to which the applicant
has applied. See Appl College
Code above. |
APPL_ACAD_PROGRAM |
Varchar2(15) |
Applicant major and concentration combined.
ADM BS in Apparel
Design/Manufacturing
ADM.ADS BS in Apparel Design/Manufacturing/Apparel Design
ADM.AMF **BS in
Apparel Design/Manufacturing/Apparel Manufacturing
ADM.APRD BS in Apparel
Design/Manufacturing/Apparel Production
ART BFA in Art
ART.GD BFA in
Art/Graphic Design
ART.INDD BFA in
Art/Industrial Design
ART.INTD BFA in Art/Interior
Design
ART.MMD BFA in Art/Multimedia Design
ART.SA BFA in Art/Studio Concentration
ARTED BS in Art Education
AT **BS in Applied Technology
CDFL **BS in Child Development and Family
Life
CONS BS in Construction
CTD **BS in Clothing, Textiles &
Design
DIET BS in Dietetics
EC BS in Early Childhood
EC.CER BS in Early Childhood/Certification
EC.GEN BS in Early Childhood/General
ECE **BS in Early Childhood Education
EDCPS EdS in Counseling & Psychological Services
EDSGC **EdS in
Guidance and Counseling
EDSIV EdS in
Industrial & Vocational Education
EDSIV.IT EdS in
Industrial & Vocational Education/Industry & Technology
EDSIV.PE EdS in
Industrial & Vocational Education/Professional Education
EDSSPS EdS in
School Psychology
FACE BS in Family and Consumer Educational
Services
FACE.CA BS in Family and Consumer Ed
Svc/Consumer Affairs
FACE.FEE BS in Family and Consumer Ed
Svc/Family Extension Education
FACE.K12 BS in Family
and Consumer Ed Svc/K-12 Home Ec Ed/Family Life
FCSE BS in Family and Consumer Sciences
Education/Consumer Affairs
FCSE.CA BS in Family and Cons Sciences
Ed/Family Extension Education
FCSE.FEE BS in Family and Cons Sciences
Ed/Family Extension Education
FCSE.K12 BS in Family and Cons Sciences Ed/K-12
Home Ec Ed/Family Life
FM **BS in Fashion Merchandising
FSA **BS in Foodservice Administration
FST BS in Food Systems and Technology
FST.FCM BS in Food Systems and Technology/Food
Communication
FST.FMD BS in Food Systems and Technology/Food Merch & Distribution
FST.FSC BS in Food Systems and Technology/Food
Science
FST.FSM BS in Food Systems and Technology/Food
Systems Mgmt
GBA BS in General Business Administration
GCM BS
in Graphic Communications Management
GRCO Graduate Certification Only
GRCO.DIET Dietetics Internship
GRCO.GCK12 Graduate
Certification Only/K-12 Guidance & Counseling
GRCO.GCMH Graduate
Certification Only/Mental Health Guidance & Counseling
GRCO.SPCERT Graduate
Certification Only/School Psychology
GRNMJ Graduate No
Major
GRPHD.TEC Graduate
PH.D/Technology ManagementGRSS Graduate
Special Student
HDFS BS in Human
Development & Family Studies
HDFS.CDFS **BS in Human Devel & Fam Studies/Child Devel & Family Svc
HEES **BS in Home
Economics Education
HEIB **BS in Home
Economics in Business
HRM **BS in Hotel
and Restaurant Management
HRTM BS in Hotel,
Restaurant, and Tourism Management
HTM **BS in
Hospitality and Tourism Management
IM BS in
Industrial Management
IT BS in
Industrial Technology
IT.AS BS in
Industrial Technology/Automation Systems
IT.ELCT **BS in
Industrial Technology/Electronics & Computer Technology
IT.FAC BS in
Industrial Technology/Facilities
IT.FMGT BS in
Industrial Technology/Facilities Management
IT.GAMGT BS in
Industrial Technology/Graphic Arts Management
IT.INDIST **BS in
Industrial Technology/Industrial Distribution
IT.MD BS in
Industrial Technology/Mechanical Design
IT.MFMGT **BS in
Industrial Technology/Manufacturing Management
IT.PKG BS in
Industrial Technology/Packaging
IT.PLAS BS in
Industrial Technology/Plastics
IT.PO BS in
Industrial Technology/Production Operations
IT.PRDV **BS in
Industrial Technology/Product Development
IT.QTEC **BS in
Industrial Technology/Quality Technology
IT.SPDE BS in
Industrial Tech/Special Program (Distance Ed)
IT.SPRG **BS in
Industrial Technology/Special
Program
IT.TCM **BS in
Industrial Technology/Technical Communications
IT.TSYS BS in
Industrial Technology/Telecommunication Systems
MATH BS in Applied
Mathematics
MATH.AD **BS in
Applied Mathematics/Architectural Design
MATH.AP **BS in
Applied Mathematics/Applied Physics
MATH.AR **BS in
Applied Mathematics/Applied Research
MATH.AS BS in Applied
Mathematics/Actuarial Science
MATH.BM BS in Applied
Mathematics/Business Management
MATH.CG BS in Applied
Mathematics/Computer Graphics
MATH.CSI BS in Applied
Math/Computer Systems Integration
MATH.FPQ **BS in
Applied Math/Food Production Quality Control
MATH.IM **BS in
Applied Mathematics/Industrial Management
MATH.MDD **BS in
Applied Mathematics/Mechanical Design Drafting
MATH.MDS BS in Applied
Mathematics/Mechanical Design
MATH.NC **BS in
Applied Mathematics/Numerical Control
MATH.SD BS in Applied
Mathematics/Software Development
MATH.SP **BS in
Applied Mathematics/Scientific Programming
ME BS in
Manufacturing Engineering
MKTED BS in
Marketing Education
MKTED.BUS BS in
Marketing Education/Business Education
MSAP MS in Applied Psychology
MSAP.HP MS in Applied Psychology/Health
Psychology
MSAP.IOP MS in Applied
Psychology/Industrial/Organizational
MSAP.PE MS in Applied Psychology/Program
Evaluation
MSCT **MS in Clothing, Textiles and Related
Art
MSED MS in Education
MSED.GE MS in Education/Gifted Education
MSED.MT MS in Education/Master Teacher
MSFNS MS in Food & Nutritional Sciences
MSFNS.FST MS Food & Nutritional Sciences
MSFNS.HNS MS Food &
Nutritional Sciences
MSFNS.MM MS Food &
Nutritional Sciences
MSFSN **MS in Food Science and Nutrition
MSFSN.F **MS in Food Science & Nutrition
MSFSN.FA **MS in Food Science & Nutrition
MSFSN.FN **MS in Food Science & Nutrition
MSFSN.N **MS in Food Science & Nutrition
MSFSN.NFA **MS in Food
Science & Nutrition
MSGC MS in Guidance
and Counseling
MSGC.ADA **MS in
Guidance & Counseling/Alcohol & Drug Abuse Counseling
MSGC.EAHP MS in Guidance
& Counseling/Employee Assist & Health Promotion
MSGC.ELM MS in Guidance
& Counseling/Elementary Counseling
MSGC.EMP **MS in
Guidance & Counseling/Employment Counseling
MSGC.K12 MS in Guidance
& Counseling/K-12 School
Counseling
MSGC.MH MS in Guidance &
Counseling/Mental Health Counseling
MSGC.SEC MS in Guidance
& Counseling/Secondary Counseling
MSGC.VT **MS in Guidance
& Counseling/Voc-Tec School
Counseling
MSHE MS in Home
Economics
MSHE.ADMR MS in Home
Economics/Apparel Design, Mfg & Retailing
MSHE.EC MS in Home
Economics/Early Childhood
MSHE.FCE MS in Home
Economics/Family Consumer Education
MSHE.FSHD MS in Home
Economics/Family Studies & Human Development
MSHT MS in
Hospitality & Tourism
MSHT.GHM MS in
Hospitality & Tourism/Global Hospitality Management
MSHT.H MS in
Hospitality & Tourism/Hospitality
MSHT.T MS in
Hospitality & Tourism/Tourism
MSITE MS in
Industrial/Technology Education
MSITE.CERT MS in
Industrial/Technology Education Certif Pgrm Ind/Tech
Ed
MSMFT MS in Marriage
and Family Therapy
MSMGT M S in Management
Technology
MSMT **MS in Media
Technology
MSRC MS in Risk
Control
MSSF **MS in Safety
MSSPS MSEd in School Psychology
MSSPS.CERT MSEd in School Psychology/Certification
MSSPS.W/OCERT MSEd in School Psychology/Without Certification
MSTD MS in Training and Development
MSVE **MS in Vocational Education
MSVR MS in Vocational Rehabilitation
MSVR.RC MS in Vocational
Rehabilitation/Rehabilitation Counseling
MSVR.RFA MS
in Vocational Rehabilitation/Rehab Facility Administration
MSVR.STW MS in Vocational Rehabilitation/School
to Work Transition
MSVR.VE MS in
Vocational Rehabilitation/Vocational Evaluation
MSVR.WA **MS in
Vocational Rehabilitation/Work Adjustment
MSVTE MS in
Vocational and Technical Education
MSVTE.A MS in
Vocational & Technical Education/Administration
MSVTE.LVEC MS in
Vocational & Technical Education/Local Voc Ed Coord
MSVTE.ME MS in
Vocational & Technical Education/Marketing Education
MSVTE.SN MS in
Vocational & Technical/Special Needs
MSVTE.T MS in
Vocational & Technical/Teaching
NOMJ Accepted
Without Major
NOMJ.ADM Accepted
Without Major/Apparel Design & Mfg
NOMJ.AM Accepted
Without Major/Applied Math
NOMJ.ARTED Accepted
Without Major/Art Education
NOMJ.ARTGD Accepted
Without Major/Art-Graphic Design
NOMJ.ARTINDD Accepted
Without Major/Art-Industrial Design
NOMJ.ARTINTD Accepted
Without Major/Art-Interior Design
NOMJ.ARTMMD Accepted
Without Major/Art-Multimedia Design
NOMJ.ARTST Accepted
Without Major/Art-Studio Concentration
NOMJ.CONS Accepted
Without Major/Construction
NOMJ.DIET Accepted
Without Major/Dietetics
NOMJ.EC Accepted
Without Major/Early Childhood
NOMJ.FACE **Accepted
Without Major/Family & Consumer Education
NOMJ.FCSE Accepted
Without Major/Family & Consumer Ed Services
NOMJ.FST Accepted
Without Major/Food Systems Technology
NOMJ.GAME Accepted
Without Major/Gen’l Advisement for Mfg Eng
NOMJ.GBA Accepted
Without Major/General Business Administration
NOMJ.GCM Accepted
Without Major/Graphic Communications Management
NOMJ.HDFS Accepted
Without Major/Human Development & Family Studies
NOMJ.HRTM Accepted
Without Major/Hotel, Restaurant, & Tourism Management
NOMJ.HT **Accepted
Without Major/Hospitality & Tourism Mgmt
NOMJ.IT Accepted
Without Major/Industrial Technology
NOMJ.ME Accepted
Without Major/Manufacturing Engineering
NOMJ.MKTED Accepted
Without Major/Marketing Education
NOMJ.PKG Accepted
Without Major/Packaging
NOMJ.PSYC Accepted
Without Major/Psychology
NOMJ.RMM Accepted
Without Major/Retail Merchandising & Management
NOMJ.SVM Accepted
Without Major/Service Management
NOMJ.TE Accepted
NOMJ.TSYS Accepted
Without Major/Telecommunication Systems
NOMJ.VR Accepted
Without Major/Vocational Rehabilitation
NOMJ.VTAE Accepted
Without Major/Vocational, Technical and Adult Education
NOTOFF Program Not
Offered At Stout
PKG BS in
Packaging
PSYC BA in
Psychology
RMM BS in Retail
Merchandising and Management
RMM.BMGT BS in Retail
Merchandising & Mgmt/Business Management
RMM.FM BS in Retail
Merchandising & Mgmt/Fashion Marketing
RMM.HRM BS in Retail
Merchandising & Mgmt/Human Resource Management
RMM.IDEC BS in Retail Merchandising
& Mgmt/Interior Decorating
SVM BS in Service
Management
SVM.FP BS in Service
Management/For-Profit
SVM.IND BS in Service
Management/Individualized
SVM.NP BS in Service
Management/Non-Profit
TCOM BS in
Technical Communications
TE BS in Technology Education
TS BS in
Telecommunication Systems
UND Undeclared
UND.ARCH Preprofessional/Pre-Architecture
UND.CHP Preprofessional/Pre-Chiropractic
UND.DN Preprofessional/Pre-Dentistry
UND.ENG Preprofessional/Pre-Engineering
UND.LAW Preprofessional/Pre-Law
UND.MED Preprofessional/Pre-Medicine
UND.MEDTEC Preprofessional/Pre-Medical Technician
UND.MORSC Preprofessional/Pre-Mortuary
UND.OCCT Preprofessional/Pre-Occupational Therapy
UND.OPTM Preprofessional/Pre-Optometry
UND.PA Preprofessional/Pre-Physical Therapy
UND.PHAR Preprofessional/Pre-Pharmacy
UND.SP Undergrad
Special/Nondegree
VR BS in
Vocational Rehabilitation
VR.BUS BS in
Vocational Rehabilitation/Business
VR.CBR BS in
Vocational Rehabilitation/Community-Based Rehabilitation
VR.ILV BS in
Vocational Rehabilitation/Independent Living
VR.IND BS in
Vocational Rehabilitation/Individualized
VR.PE **BS in
Vocational Rehabilitation/Physical Education
VR.RCN BS in
Vocational Rehabilitation/Rehabilitation Counseling
VR.ROP BS in
Vocational Rehab/Rehabilitation of Older Person
VR.RR **BS in
Vocational Rehabilitation/Recreational Rehabilitation
VR.RTEC BS in
Vocational Rehabilitation/Rehabilitation Technology
VR.SE BS in
Vocational Rehabilitation/Special Education
VTAE BS in
Vocational, Technical, and Adult Education
VTAE.OCDEG BS in
Vocational, Technical, and Adult Ed/Off-Campus Degree
** - Program is Inactive or Discontinued |
APPL_ACAD_PROGRAM_DESC |
Varchar2(60) |
Description of the academic program. See Academic Program above |
APPL_ACAD_PROGRAM_LEVEL |
Varchar2(2) |
Program Level
GR
UG |
APPL_MAJOR |
Varchar2(10) |
Applicant’s major only.
ADM Apparel Design/Manufacturing
ART Art
ARTED Art Education
AT **Applied
Technology
CDFL **Child
Development-Family Life
CONS Construction
CTD **Clothing,
Textiles
DIET Dietetics
EC Early Childhood
ECE **Early Childhood Education
EDCPS Counseling & Psychological
Services
EDSGC Guidance and Counseling
EDSIV Industrial & Vocational Education
EDSPS EdS in
School Psychology
FACE Family & Consumer Educational
Services
FCSE Family & Consumer Sciences
Education
FSA **Foodservice Administration
FST Food Systems & Technology
GBA General Business Administration
GCM Graphic Communication
GRCO Graduate Certification Only
GRNMJ Graduate No Major
GRPHD Ph.D. Partnership
GRSS Special Student
HDFS Human Development & Family Studies
HEES **Home Economics Educational Services
HEIB **Home Economics in Business
HRM **Hotel & Restaurant Mgmt
HRTM Hotel, Restaurant & Tourism Mgmt
HTM Hospitality & Tourism Mgmt
IM Industrial Management
IT Industrial Technology
MATH Applied Mathematics
ME Manufacturing Engineering
MKTED Marketing Education
MSAP MS in Applied Psychology
MSCT **Clothing, Textiles
MSED Education
MSFNS MS in Food & Nutritional Sciences
MSFSN Food Science & Nutrition
MSGC Guidance & Counseling
MSHE Home Economics
MSHT Hospitality and Tourism
MSITE Industrial/Technology Education
MSMFT Marriage & Family Therapy
MSMGT Management
Technology
MSMT Media Technology
MSRC Risk Control
MSSF **Safety
MSSPS School Psychology
MSTD Training and Development
MSVE **Vocational Education
MSVR Vocational
Rehabilitation
MSVTE Vocational & Technical Education
NOMJ Accepted W/O Major
PKG Packaging
PSYC Psychology
RMM Retail Merchandising & Mgmt
SVM Service Management
TCOM Technical Communication
TE Technology Education
TS Telecommunication Systems
UND Undecided
VR Vocational Rehabilitation
VTAE Vocational, Technical, Adult Education
** - Major is Inactive or Discontinued |
APPL_MAJOR_DESC |
Varchar2(30) |
Description of Major. See
Major above. |
CURR_APPL_STATUS |
Varchar2(6) |
Code indicating the status of an application.
AD Admitted, Moved To
Student
ADCO Admit Conditionally
ADGD Admit Good Standing
ADPC Admit Probation
& Conditional
ADPR Admit On Probation
ADSO Admit-Summer Only
ADSP Admit-Summer Only
Probation
ADTR Admit On Trial
APPL Applied
BACK Backdated
Application
CANC Cancel Before
Decision
CAWL Cancel After Wait
List
CHAS Changed Admit Status
CHNG Changed Major
COMP Complete, Pending
Review
DFER Defer To Later Term
DNAC Deny, Academic
Standing
DNDF Deny, Deficiency
DNEM Deny, Enroll Limit
DNIN Denied, Incomplete
DNSC Deny, Screening
DNWL Denied After Wait
List
INCM Incomplete
INCS Inc-Short Credit
INQU Inquired
NOCM Not Coming
NOSH No Show
WLAC Wait List, Academic
WLEM Wait List, Enroll |
CURR_APPL_STATUS_DESC |
Varchar2(30) |
Description of the code for the applicant’s current program action.
See above. |
CURR_APPL_STATUS_DATE |
Date(19) |
Date that the most recent program action was taken. |
APPL_ADMIT_STATUS |
Varchar2(6) |
Code indicating the status of admission
ADCO Admit Conditionally
ADGD Admit Good Standing
ADPC Admit Probation
& Conditional
ADPR Admit On Probation
ADSO Admit-Summer Only
ADSP Admit-Summer Only
Probation |
APPL_ADMIT_STATUS_DESC |
Varchar2(30) |
Description of the code for the applicants admission. See above. |
APPL_ADMIT_STATUS_DATE |
Date(19) |
Date the the applicant is admitted. |
CURR_APPL_REMARKS_TYPE |
Varchar2(3) |
Code indicating the reason associated with the applicant’s current
program action.
ACC Cleared Conditions
ADC Admit Conditions
ATH Athletic
EXC Appeal/Exception
PER Personal |
CURR_APPL_REMARKS_DESC |
Varchar2(30) |
Description of the code for the reason associated with the
applicant’s current program action. |
ADMIT_CATEGORY |
Varchar2(2) |
Code of the MAAD category under which the applicant was admitted
D Discretionary
E Exception
O Older, Non-Traditional
S Standard |
ADMIT_CRITERIA |
Varchar2(2) |
Code of the CDR criteria under which the applicant was admitted
A High School Rank
B ACT/SAT Test Score
C Quantifiable Factors
D Talent
E International Application
F GED
G Grades as Special
Student
H Preparatory Courses
I Positive Recommendations
J Increased Maturity (Category O only) K Veteran
L Disability
M Minority
N Incarcerated
O Director’s Discretion |
SECOND_DEGREE |
Varchar2(2) |
Code indicating that the applicant is pursuing a second degree or
second major
PD Second Degree
PM Second Major/Minor/Certification |
COMPETENCY_BASED_ADMIT |
Varchar2(2) |
Code indicating the number of competencies submitted by applicant in
lieu of traditional transcript, and if competencies were used as an admission
decision factor.
1N One Competency/No Factor
2N Two Competencies/No Factor
3N Three Competencies/No Factor
4N Four Competencies/No Factor
5N Five Competencies/No Factor
1Y One Competency/Decision
Factor
2Y Two Competencies/Decision Factor
3Y Three Competencies/Decision Factor
4Y Four Competencies/Decision Factor
5Y Five Competencies/Decision Factor |
APPL_TUITION_RESIDENCY_STATUS |
Varchar2(1) |
Code of the residency status for tuition purposes assigned to the
applicant.
N NON-RESIDENT
R RESIDENT
S MINNESOTA COMPACT |
APPL_FEE_TYPE |
Varchar2(3) |
Code indicating the type of application fee assessed to the
applicant. |
APPL_FEE_AMT |
Number(6,2) |
The fee amount paid by the applicant. |
APPL_FEE_DATE |
Date(19) |
Date on which the application fee payment was received. |
APPL_FEE_STATUS |
Varchar2(3) |
Code indication the current status of the applicant’s fee.
N NOT PAID
P PAID
R PARTIALLY PAID
W WAIVED |
LAST_PS_INST_CODE |
Varchar2(11) |
ID number of the post-secondary institution an applicant most
recently attended. ID number assigned
by Datatel system to be used internally. A unique identifier for each institution. |
LAST_PS_INST_DESC |
Varchar2(40) |
Name of the post-secondary institution an applicant most recently
attended. |
LAST_PS_INST_GPA |
Number(4,3) |
GPA of the applicant from the post-secondary institution most
recently attended |
LAST_PS_INST_GRAD_YEAR |
Number(4) |
The year that the applicant graduated from post-secondary institution
most recently attended. |
LAST_PS_CUM_TRANSFER_CREDITS |
Number(5,2) |
The calculated total number of transfer credits toward a program for
an applicant, from the post-secondary institution most recently attended. |
HIGH_SCHOOL_CODE |
Varchar2(11) |
ID number of the high school an applicant attended. ID number assigned by Datatel system to be
used internally. A unique identifier
for each institution. |
HIGH_SCHOOL_DESC |
Varchar2(40) |
Name of the high school an applicant attended. |
HIGH_SCHOOL_RANK |
Number(15) |
Numerical rank of the applicant within the high school attended. |
HIGH_SCHOOL_CLASS_SIZE |
Number(15) |
Numerical size of the class from the high school the applicant
attended. |
HIGH_SCHOOL_PCNTL |
Number(4,2) |
Calculated applicant’s percentile within the high school
attended. Percentile equals the high
school rank divided by high school size, subtracted from 100. |
HIGH_SCHOOL_GPA |
Number(4,3) |
GPA of the applicant from the post-secondary institution most
recently attended. |
HIGH_SCHOOL_GRAD_YEAR |
Number(15) |
The year that the applicant graduated from post-secondary institution
most recently attended. |
INTEREST_1 |
Varchar2(6) |
Code indicating the extracurricular activity in which an applicant
was involved in high school or would be interested in at the college level.
BAND Band
BASE Baseball
CHER Cheerleading
CHOR Choir
DECA DECA
FOOT Football
FOR Forensics
GOVT Student
Government
GYM Gymnastics
HOCK Hockey
HONR Honor
Society
INTL Study
Abroad
MBB Men's
Basketball
MCC Men's
Cross Country
MTRK Men's
Track
NEWS Student
Newspaper
POM Pom-Pons/Dance Line
SOCC Soccer
SOFT Softball
TENN Tennis Volleyball
WBB Women's Basketball WCC Women's
Cross Country WTRK Women's
Track |
INTEREST_2 |
Varchar2(6) |
Code indicating the extracurricular activity in which an applicant
was involved in high school. See
Interest 1. |
INTEREST_3 |
Varchar2(6) |
Code indicating the extracurricular activity in which an applicant
was involved in high school. See Interest 1. |
INTEREST_4 |
Varchar2(6) |
Code indicating the extracurricular activity in which an applicant was
involved in high school. See Interest 1. |
INTEREST_5 |
Varchar2(6) |
Code indicating the extracurricular activity in which an applicant
was involved in high school. See Interest 1. |
STOUT_INPROGRESS_CREDITS |
Number(7,2) |
Total number of credits currently in-progress at Stout. |
STOUT_COLLEGE_CREDITS_TAKEN |
Number(7,2) |
Total number of credits attempted at Stout. |
STOUT_COLLEGE_CREDITS_PASSED |
Number(7,2) |
Total number of credits completed at Stout. |
STOUT_COLLEGE_GRADE_POINTS |
Number(7,2) |
Total grade points earned at Stout. |
STOUT_COLLEGE_CUM_GPA |
Number(4,3) |
Cumulative GPA earned at Stout |
TOTAL_TRANSFER_CREDITS |
Number(7,2) |
The calculated total number of transfer credits for an applicant,
from all post-secondary institutions attended. |
HOUSING_DEPOSIT_PAID |
Varchar2(1) |
Code indicating whether or not the housing deposit has been
paid. Y/N Field. |
HOUSING_DEPOSIT_PAID_DATE |
Date(19) |
Date the housing deposit was received and recorded on Datatel. |
APPL_SPECIAL_SERVICES |
Varchar2(5) |
Special Services (ASPIRE) code for applicants.
D Disabled Only
DFG Disabled
& First Generation
DFGLI Disabled/First Generation/Low Income
DLI Disabled
& Low Income
FG First
Generation Only
FGLI First
Generation & Low Income
LI Low
Income Only
NE Info
Received-Not Eligible |
HIGH_SCHOOL_TRANS_TYPE_CODE |
Varchar2(5) |
Code for High School Transcript
HS High School
PS Post Secondary |
HIGH_SCHOOL_TRANS_TYPE_DESC |
Varchar2(25) |
Description for High School transcript. See above. |
HIGH_SCHOOL_TRANS_STAT_CODE |
Varchar2(4) |
Code for status of High School Transcript
NR Not Required
OF Official Final
OP Official Partial
OT Official-Trans Only
UN Unofficial |
HIGH_SCHOOL_TRANS_STAT_DESC |
Varchar2(25) |
Description for High School Transcript Code. See Above. |
HIGH_SCHOOL_TRANS_DATE |
Date(19) |
Date of High School Transcript |
LAST_PS_TRANS_TYPE_CODE |
Varchar2(5) |
Code for Post Secondary Transcript
HS High School
PS Post Secondary |
LAST_PS_TRANS_TYPE_DESC |
Varchar2(25) |
Description for Post Secondary Transcript Code. See Above. |
LAST_PS_TRANS_STAT_CODE |
Varchar2(4) |
Code for post secondary transcript status
NR Not Required
OC Official Cert Only
OF Official Final
OP Official Partial
OT Official-Trans Only
UN Unofficial |
LAST_PS_TRANS_STAT_DESC |
Varchar2(25) |
Description for post secondary transcript status. See above. |
LAST_PS_TRANS_DATE |
Date(19) |
Date of post secondary transcript. |
EXTL_DEGREE_CODE |
Varchar2(5) |
Code for external degree
AA Associate of Arts
AAA Associate of Applied
Arts
AAS Associate of Applied
Science
AASC Associate of Arts and
Science
AE Artium Baccalaureus
AM Artium Magister
AOS Associate in
Occupational Studies
AS Associate Degree
ASSOC Associate (two year)
BA Bachelor or Arts
BACH Bachelor Degree
BAED Bachelor or Arts in
Education
BBA Bachelor of Business
Administration
BD Bachelor of Design
BE Bachelor of Education
BED Bachelor of Elementary
Education
BEQ Bachelor Equivalent
BFA Bachelor of Fine Arts
BLS Bachelor or Liberal
Studies
BM Bachelor of Music
BME Bachelor of Music
Education
BS Bachelor of Science
BSAS Bachelor of Sci-Applied Sci
BSE Bachelor of Sci-Ed/Bach Sci-Engin
BSED Bachelor of Science
Education
BSEPH Bach of Sci-Envr Pub Health
BSN Bachelor of
Science-Nursing
BSW Bachelor of Social
Work
CAS Certificate of
Advanced Study
DMIN Doctor of Ministry
DP1 Diploma 1-year
DP2 Diploma 2-year
EDM Master of Education
JD Doctor of Law (Juris Doctor)
MA Master of Arts
MAST Master’s Degree
MAT Master of Art
Teaching
MBA Master of
Business-Admin
MED Master of Education
MS Master of Science
MSE Master of Science
in Education
MSN Master of
Science-Nursing
PHD Doctor of
Philosophy
|
EXTL_DEGREE_DESC |
Varchar2(30) |
Description of External Degree Code. See Above. |
EXTL_DEGREE_DATE |
Date(19) |
Date of external |
EXTL_MAJOR_CODE |
Varchar2(5) |
0101Z Agri Bus & Mgmt, Other
01041 Agri & Fd Prd Prcs Oper & Mgmt
01057 Eques/Equi Stu,Horse Mgmt & Tr
02011 Agriculture/Agri Sciences, Gen
02026 Dairy Science
02031 Food Sciences
& Technology
02043 Horticulture Science
0299Z Agriculture/Agri Sci, Other
03012 Environmental
Science/Studies
03052 Forestry
Sciences
03061 Wildlife & Wildlands Mgmt
0399Z Cons & Renew Natrl Resrcs Other
04021 Architecture
04051 Interior Architecture
04061 Landscape
Architecture
04071 Architectural
Urban Design & Pln
0499Z Archi & Related Progs,
Other
05012 American
Studies/Civilization
05027 Women’s Studies
0802Z Bus&Pers Serv Mrktng Oper, Oth
08091 Hsptlty & Rec Mrktng Oper, Gen
08092 Hotel/Motel Serv Mrktng Oper
08093 Rec Prod/Serv Mrktng Operation
08114 Tourism
Promotion Operations
0811Z Tour&Trav Srv Mrktng Oper,Oth
0899Z Mrktng Opera/Mrktng & Dist Oth
09011 Communications,
General
09021 Advertising
09041 Journalism
09043 Mass
Communications
0904Z Journalism &
Mass Comm, Oth
09051 Public Relations
& Org Comm
09071 Radio & Television Broadcast
0999Z Communications,
Other
11011 Computer &
Info Sci, General
11041 Info Sciences
& Systems
11071 Computer Science
1199Z Computer &
Info Sciences, Other
12053 Culinary
Arts/Chef Training 1205Z Culinary Arts&Related Srv, Other
13.04 Educational
Admin/Suprv
13.10 Special
Education/Teaching
13.11 Student Couns & Personnel Serv
13.13 Teach Ed & Prog Dev, Spec Subj
13011 Education, General
13031 Curriculum & Intruction
13041 Education Admin
& Supr, Gen
13045 Elem,
Middle& Secondary Edu Adm
13101 Special
Education, General
13104 Edu of the Gifted & Talented
13106 Edu of the
Mentally handicapped
1310Z Special
Education, Other
13111 Couns Edu Couns&
Guidance Serv
13121 Adult&Cont Teacher Education
13122 Elementary
Teacher Education
13125 Secondary
Teacher Education
13126 Teacher Edu, Multiple Levels
13131 Agri Teacher Edu (Voc)
13132 Art Teacher
Education
13133 Bus Teacher Edu (Vocational)
13134 Driver&Safety Teacher Education
13135 English Teacher
Education
13137 Health Teacher Education
13138 Home Econ
Teacher Edu (voc)
13139 Tech Tchr Edu/Inds Art Tchr Ed
1313D Phys Edu Teacher & Coaching
1313H Social Studies
Teacher Edu
1399Z Education,Other
14.04 Architecutral Engineering
14011 Engineering,
General
14021 Aero, Aeron&Astron Engineering
14031 Agricultural
Engineering
14081 Civil
Engineering, General
1408Z Civil
Engineering, Other
14091 Computer Engineering
14101 Elec Electronics & Commun Eng
14111 Engineering
Mechanics
14131 Engineering
Sciences
14171 Industrial/Manuf Engineering
14191 Mechanical
Engineering
14281 Textile Sciences
& Engineering
14301 Engineering/Industrial Mgmt
14311 Materials
Science
1499Z Engineering,
Other
15.03 Electrical Eng
Technologies
15033 Elec, Elec & Comm Engnrg Tec/T
15063 Indst/Manuf Technology/Technic
1506Z Ind Production Tech/Tech, Other
15071 Occup Safety& Health Tech/Tech
1599Z Engnr-Related Tech/Tech other
16032 Japanese
Language & Literature
16051 Germanic
Language & Literature
16095 Spanish Language
& Lit
19011 Home Economics,
General
19031 Family &
Community Studies
19041 Family Resource
Mgmt Studies
1904Z Family/Consumer Resrc Mgmt Other
19051 Foods &
Nutrition Studies, Gen
19052 Foods &
Nutrition Science
19053 Dietetics/Human Nutri Services
1905Z Foods &
Nutrition Studies, Other
19071 Individual&
Family Devl Stu,Gen
19074 Family Life
& Relations Studies
19076 Child Growth,
Care & Devl STu
1907Z Individual&
Family Devl Stu, Other
1999Z Home Economics,
Other
20012 Child Devel, Care & Guidance
20018 Food &
Nutrition
22011 Law (LL.B.,
J.D.)
22013 Paralegal/Legal
Assistant
2201Z Law & Legal
Studies, Other
23.10 Speech &
Rhetorical Studies
23011 English Lang
& Lt. General
23041 English
Composition
23101 Speech &
Rhetorical Studies
2399Z English Lang
& Lit/Letters, Other
24011 Liberal Arts
& Sci/Lib Studies
24012 General Studies
24013 Humanities/Humanistic Studies
2599Z Library Science,
Other
26011 Biology, General
26022 Biochemistry
27011 Mathematics
31055 Exercise Sci/Physi & Movem stu
36010 Art
36011 Leisure & Rec Activities, Gen
36018 Sports &
Exercise
3601E Music
3601G Theatre
3601H Writing
38011 Philosophy
38021 Religion/Religious Studies
39021 Bible/Biblical
Studies
39062 Divinity/Ministry(B.D.,M.DIV.)
40051 Chemistry,
General
40081 Physics,
General
42011 psychology,
General
42041 Community Psychology
42091 Indust & Organizational Psych
42161 Social Psychology
4299Z Psychology, Other
43013 Criminal Justice/Law Enfor Adm
43014 Crimial Justice Studies
43017 Law Enf/Police
Science
4301Z Criminal Justice & Correc, Oth
43023 Fire Science/Firefighting
4302Z Fire Protection, Other
44021 Community Organ, Resources&Ser
44041 Public Administration
44071 Social Work
4499Z Public Admin & Services, Other
45.04 Criminology
45.11 Sociology
45011 Social Sciences, General
45021 Anthropology
45031 Archeology
45041 Criminology
45061 "Economics,
General"
45065 International Economics
4506Z "Economics,
Other"
45071 Geography
45081 "History,
General"
45091 International Rel & Affairs
45101 "Political Science,
General"
45111 Sociology
4599Z "Social Sciences
& History, Oth"
4604Z "Const&Build Finishers&Mngr,Oth"
4699Z "Construction Trades,
Other"
47064 Auto/Automotive Mech/Technicia
47069 Aviation Sys&avionics Main T/T
48011 "Drafting,
General"
48028 Printing Press Operator
48051 Machinist/Machine
Technologist
4899Z "Precision Prod
Trades, Other"
49011 Aviation & Airway
Science
50.07 Fine & Studio Arts
50031 Dance
50042 "Graphic Design, Com
Art& Illus"
50044 Industrial Design
50048 Interior Design
50065 Photography
50070 Printmaking
50071 "Art, General"
50073 "Art History, Ciriticism&Conser"
5007Z "Fine Arts & Art
Studies, Other"
50091 "Music, General"
51021 "Communication
Disorders, Gener"
51023 Speech-Language Pathology
5102Z "Commun Disordres Sci&Serv, Oth"
51031 Community Health Liaison
51061 Dental Assistant
51062 Dental Hygienist
51071 Heath Sys/Health Serv Admin
51081 Medical Assistant
51086 Physical Therapy Assistant
51095 Nuclear Medical Tech/Technicia
51105 Medical Technology
51121 Medicine (M.D.)
51151 Alcohol/Drug Abuse
Counseling
5115Z "Mental Health
Services, Other"
51161 Nursing (RN Training)
51162 Nursing Admin(post-RN)
51165 "Nursing, Family Prac(post RN)"
5116Z "Nursing, Other"
51201 "Pharmacy (B.Pharm.,Pharm.D.)"
5120Z "Pharmacy,
Other"
51221 "Public Health,
General"
51222 Environmental Health
51227 Public Health Edu & Promotion
51235 Music Therapy
51236 Occupational Therapy
51238 Physical Therapy
51239 Recreational Therapy
5123Z "Rehab/Therapeutic
Ser, Other"
51251 "Veterinary Clin Sci(MS,PhD)"
51272 Medical Dietician
5199Z "Health Prof&Related Sci,
Other"
52.02 "Business Admin, Mgmt
& Operati"
52.12 Mgmt Info Systems &
Services
52.14 Marketing
52.99 "Bus, Mgmt, Mrktg & Rel Supp SE"
52011 "Business,
General"
52021 "Bus Admin &
Mgmt, General"
52025 Operations Mgmt &
Supervision
5202Z "Bus Admin &
Mgmt, Other"
52031 Accounting
5203Z "Accounting,
Other"
52061 Business/Managerial
Economics
52081 "Finance,
General"
52083 Banking& Financial
Support Ser
52091 Hospitality/Admin Mgmt
52092 Hotel/Motel &
Restaurant Mgmt
52093 Travel-Tourism Mgmt
5209Z "Hospitality Serv Mgmt, Other"
52101 Human Resources Management
52102 Labor/Personnel
Relations& Stu
52103 Organizational Behavior Studie
5210Z "Human Resources
Mgmt, Other"
52111 International Business
52121 "Mgt Info Sys&Bus Data Proc,Gen"
52125 Bus Computer Facilities Operat
5212Z "Bus Info & Data
Proc Serv, Oth"
52131 Management Science
5213Z "Bus Quant Methods&Mgmt Sci,Oth"
52142 Marketing Research
52143 International Bus
Marketing
5214Z "Marketing Mgmt &
Research, Oth"
5299Z "Bus Mgmt & Admin Serv, Other"
ART Art |
EXTL_MAJOR_DESC |
Varchar2(30) |
Description for External Major Code. See above. |
INSTA_CITY_STATE |
Varchar2(30) |
Institution Attended City
and state |
INSTA_ZIP |
Varchar2(10) |
Institution Attended Zip Code |
INSTA_ADDRESS_LINE1 |
Varchar2(30) |
Institution Attended Address Line 1 |
INSTA_ADDRESS_LINE2 |
Varchar2(30) |
Institution Attended Address Line 2 |
ADVISOR_PERSON_ID |
Varchar2(7) |
ID number of the advisor for this applicant |
LAST_UPDATE_DATE_TIME |
Date(19) |
Date the data was last extracted from the operational system. Format : YYYYMMDD HH24:MI:SS |