Created by Corina C Larsen, last modified by Miki Yanagi on Apr 27, 2023

View of the extracted table of student information updated only on the census dates, February 15th, August 15th and October 15th, from the UM_STUD_EXT_ARC view. Since the UM_STUD_EXT_ARC is based off the UM_STUD_EXTRACT, the same tables are referenced.

This table returns a vast array of student demographics based on census date results quickly, and is very good for doing historical reporting based on census figures. It does not include current or end of term data.

*When using this table, please note that ROW_CHECK is always Y, and is returning only actively enrolled students. Students with ACAD_CAREER = 'NCRD' are excluded.

KeyRecord.FieldnameFormatXLATHeading TextNotes

ACADEMIC_LOAD - Academic LoadChar1NAcad Load

ACADEMIC_LOAD_DT - Academic Load Change DateDate
Load Date
→ACAD_CAREER - Academic CareerChar4NCareer

ACAD_CAREER_FIRST - First Time in CareerChar1
First Time Car

ACAD_GROUP - Academic GroupChar5
Acad Group

ACAD_GROUP_ADVIS - Academic Group of AdvisorChar5
Group

ACAD_LEVEL_BOT - Academic Level - Term StartChar3
Strt Level

ACAD_LEVEL_EOT - Academic Level - Term EndChar3
End LevelDo Not Use

ACAD_LEVEL_PROJ - Academic Level - ProjectedChar3
Proj Level

ACAD_LOAD_APPR - Approved Academic LoadChar1NAcad Load
→ACAD_PLAN - Academic PlanChar10
Acad Plan

ACAD_PLAN_TYPE - Academic Plan TypeChar3NPlan Type
→ACAD_PROG - Academic ProgramChar5
Acad Prog

ACAD_PROG_DESCR - Academic ProgramChar30
Program

ACAD_PROG_DUAL - Dual Academic ProgramChar5
Dual Prog

ACAD_PROG_PRIMARY - Primary Academic ProgramChar5
Prim Prog

ACAD_SUBPLAN_TYPE - Academic Sub-Plan TypeChar3NSub-Pl Typ

ACAD_SUBPLAN - Academic Sub-PlanChar10
Sub-Plan

ACAD_YEAR - Academic YearChar4
Acad Year

ACTION_DT - Action DateDate
Action Date

ADDRESS1 - Address Line 1Char55
Address 1

ADDRESS2 - Address Line 2Char55
Address 2

ADDRESS3 - Address Line 3Char55
Address 3

ADDRESS4 - Address Line 4Char55
Address 4

ADMISSION_EXCPT - Admission Residency ExceptionChar5
Adm Excpt

ADMISSION_RES - Admissions ResidencyChar5
Admissions

ADMIT_TERM - Admit TermChar4
Admit Term

ADMIT_TYPE - Admit TypeChar3
Admit Type

ADM_APPL_CTR - Application CenterChar4
Appl Ctr
→ADM_APPL_NBR - Application NbrChar8
Appl Nbr

ADVISOR_ID - Academic AdvisorChar11
Advisor

ADVIS_STATUS - Advisement StatusChar4NStatus

BILLING_CAREER - Billing CareerChar4
Bill Car

BIRTHDATE - Date of BirthDate
Birthdate

BIRTHPLACE - Birth LocationChar30
Birthplace

BIRTHSTATE - Birth StateChar6
State

BIRTH_COUNTRY - BIRTH_COUNTRYChar4
BIRTH_COUNTRY

CAMPUS - CampusChar5
Campus

CENSUS_DT - Census DateDate
Census Dt

CITIZENSHIP_STATUS - Citizenship StatusChar1
Status

CITY - CityChar30
City

CLASS_RANK_NBR - Class Rank NbrNum5.0
Class Rank

CLASS_RANK_TOT - Class Rank TotalNum5.0
Of

COMPLETION_TERM - Completion TermChar4
Compl Term

COUNTRY - CountryChar3
Country

COUNTRY_DESCR1 - Country DescriptionChar30
Country

COUNTY - CountyChar30
County

CUM_GPA - Cumulative GPANum6.3
GPA

CUM_RESIDENT_TERMS - Cumulative In Residence TermsNum4.3
Cum Res

CUR_GPA - Current GPANum6.3
GPA

CUR_RESIDENT_TERMS - Current In Residence TermsNum4.3
Cur Res

DECLARE_DT - Declare DateDate
Decl Date

DEGREE - DegreeChar8
Degree

DEGR_CHKOUT_STAT - Degree Checkout StatusChar2NChkoutStat

DT_OF_DEATH - Date of DeathDate
Death Date

EDUCATION_LVL - Education LevelChar2NEducation

EFFECTIVE_TERM - Effective TermChar4
Effective

ELIG_TO_ENROLL - Eligible to EnrollChar1
Elig Enrl

EMAIL_ADDR - Email AddressChar70
Email
→EMPLID - Empl IDChar11
ID

END_DATE - End DateDate
End Date

ENRL_ON_TRANS_DT - Show Enrollment on TranscriptDate
Enrl Trans

ETHNIC_CATEGORY - Ethnic Category (this field has no data)Char1NEthnic Cat

ETHNIC_GROUP - Ethnic GroupChar1NEthnic Grp

ETHNIC_GRP_CD - Ethnic GroupChar8
Ethnic Grp

EXP_GRAD_TERM - Expected Graduation TermChar4
Exp Grad

EXT_ORG_ID - External Org IDChar11
Org ID

FA_ELIGIBILITY - Program Eligibility FlagChar1
Eligible

FA_LOAD - Financial Aid LoadChar1NFA Load

FA_STATS_CALC_DTTM - FA Stats Calc Date TimeDateTm
FA DTTM

FA_STATS_CALC_REQ - FA Stats Calculation RequiredChar1
FA Calc

FIRST_NAME - First NameChar30
First Name

FORM_OF_STUDY - Form of StudyChar4NStudy Form

FULLY_ENRL_DT - Fully Enrolled DateDate
Full Enrl

FULLY_GRADED_DT - Fully Graded DateDate
Full Grded

GRADE_POINTS - Grade PointsNum7.3
Grd Points

GRADE_POINTS_FA - Financial Aid Grade PointsNum7.3
FA Grd Pt

GRADUATION_DT - Graduation DateDate
Grad DtHigh school graduation date

HISP_LATINO - Person is Hispanic or LatinoChar1
Hisp or Latin
→INSTITUTION - Academic InstitutionChar5
Institution

INSTITUTION_DESCR - InstitutionChar30
Institution

JOINT_PROG_APPR - Joint Program ApprovedChar1
Joint Program

LAST_DATE_ATTENDED - Last Date of AttendanceDate
Last Date

LAST_NAME - Last NameChar30
Last

LEVEL_LOAD_RULE - Academic Level RuleChar5
Level Rule

LOCK_IN_AMT - Lock In AmountSNm15.2
Amount

LOCK_IN_DT - Lock In DateDate
Date

MAR_STATUS - Marital StatusChar1NMar Status

MAR_STATUS_DT - Marital Status DateDate
Mar StatDt

MAX_AUDIT_UNIT - Max Audit UnitsNum4.2
Max Audit

MAX_CRSE_COUNT - Max Total CoursesNum3.0
Total Crse

MAX_NOGPA_UNIT - Max No GPA UnitsNum4.2
Max Grd Pt

MAX_TOTAL_UNIT - Max Total UnitsNum4.2
Max Units

MAX_WAIT_UNIT - Max Wait List UnitsNum4.2
Max Wait

MIDDLE_NAME - Middle NameChar30
Middle

MIN_TOTAL_UNIT - Min Total UnitsNum4.2
Min Units

NAME - NameChar50
Name

NAME_PREFIX - Name PrefixChar4
Prefix

NAME_SUFFIX - Name SuffixChar15
Suffix

NSLDS_LOAN_YEAR - NSLDS Loan YearChar1NLoan Year

OVRD_ACAD_LVL_ALL - Override All Academic LevelsChar1
Ovrd Lvls

OVRD_ACAD_LVL_PROJ - Override Projected LevelChar1
Ovrd Level

OVRD_BILL_UNITS - Override Billing UnitsChar1
Ovrd Bill

OVRD_INIT_ADD_FEE - Override Initial Add FeesChar1
Override Fee

OVRD_INIT_ENR_FEE - Override Initial Enroll FeeChar1
Override Fee

OVRD_MAX_UNITS - Override Maximum UnitsChar1
Ovrd Units

OVRD_TUIT_GROUP - Override Tuition GroupChar10
Ov Tuit Gp

OVRD_WDRW_SCHED - Override Withdrawal ScheduleChar8
Ov Wd Schd

PHONE - TelephoneChar24
Phone

PIN_NUM - PIN NumberNum8.0
PIN Number

PLAN_SEQUENCE - Plan SequenceNum2.0
Plan Seq

POSTAL - Postal CodeChar12
Postal

PROG_ACTION - Program ActionChar4NProg Actn

PROG_REASON - Action ReasonChar4
Action Rsn

PROG_STATUS - Academic Program StatusChar4NStatus

PROJ_BILL_UNT - Projected Bill UnitsNum3.0
Bill Units

PRO_RATA_ELIGIBLE - Pro-Rata EligibleChar1
Eligible

REFUND_PCT - Refund PercentageNum4.2
Refund %

REFUND_SCHEME - Refund SchemeChar8
Scheme

REGISTERED - RegisteredChar1NRegistered

REG_CARD_DATE - Registration Card DateDate
Reg Card

REQ_TERM - Requirement TermChar4
Req Term

RESET_CUM_STATS - Reset Cum Stats at Term StartChar1
Cum Reset

RESIDENCY - Tuition ResidencyChar5
Tuition Resid

RESIDENCY_DT - Residency DateDate
Res Date

RESPONSE_DT - Response DateDate
Date

RESPONSE_REASON - Response ReasonChar4
Reason

ROW_CHECK - ROW CHECK*Char1
ROW CHECK

SEL_GROUP - Tuition GroupChar10
Group

SEX - GenderChar1NSex

SSR_ACTIVATION_DT - Term Activation DateDate
Activation Date

START_DATE - Start Date for Gen Standing PODate
Start Date

STATE - StateChar6
State

STATE_DESCR1 - State DescriptionChar30
State

STATS_ON_TRANS_DT - Show Statistics on TranscriptDate
Stat Trans
→STDNT_CAR_NBR - Student Career NbrNum3.0
Career Nbr

STDNT_DEGR - Student Degree NbrChar2
Degree Nbr
→STRM - TermChar4
Term

STUDY_AGREEMENT - Study AgreementChar10
Agreement

TC_UNITS_ADJUST - TC Units AdjustmentNum6.3
TC Units Adjust

TERM_TYPE - Term Unit TypeChar1NTerm Type

TOT_AUDIT - Total AuditedNum6.3
Audit

TOT_CUMULATIVE - Total Cumulative UnitsNum6.3
Total

TOT_GRADE_POINTS - Total Grade PointsNum7.3
Grade Points

TOT_GRD_POINTS_FA - Total Fin Aid Grade PointsNum7.3
Tot FA Grd

TOT_INPROG_GPA - Total In Progress - GPANum6.3
In Pr GPA

TOT_INPROG_NOGPA - Total In Progress -Not for GPANum6.3
InPr NoGPA

TOT_OTHER - Total from Other CreditNum6.3
Other

TOT_PASSD_FA - Total Fin Aid Units PassedNum6.3
Pass FA

TOT_PASSD_GPA - Total Passed Toward GPANum6.3
Pass GPA

TOT_PASSD_NOGPA - Total Passed Not Toward GPANum6.3
PassNoGPA

TOT_PASSD_PRGRSS - Total Passed for ProgressNum6.3
Pass Prgrs

TOT_TAKEN_FA - Total Fin Aid Units TakenNum6.3
Take FA

TOT_TAKEN_FA_GPA - Total Fin Aid Taken Toward GPANum6.3
Tot FA GPA

TOT_TAKEN_GPA - Total Taken Toward GPANum6.3
Take GPA

TOT_TAKEN_NOGPA - Total Taken Not Toward GPANum6.3
TakeNoGPA

TOT_TAKEN_PRGRSS - Total Taken for ProgressNum6.3
Take Prgrs

TOT_TEST_CREDIT - Total From Test CreditNum6.3
Test

TOT_TRNSFR - Total TransferredNum6.3
Transfer

TRF_GRADE_POINTS - Transfer Grade PointsNum7.3
Trnsfr Grd Pts

TRF_PASSED_GPA - Transfer Passed for GPANum6.3
TrnPasGPA

TRF_PASSED_NOGPA - Transfer Passed Not for GPANum6.3
TrnPasNGPA

TRF_RESIDENT_TERMS - Transfer In Residence TermsNum4.3
Trf Res

TRF_TAKEN_GPA - Transfer Taken for GPANum6.3
TrnTakGPA

TRF_TAKEN_NOGPA - Transfer Taken Not for GPANum6.3
TrnTakNGPA

TUITION_RES_TERMS - Tuition ResidencyNum4.3
Tuition Res.

TUIT_CALC_DTTM - Tuit Calc Date TimeDateTm
TuitDTTM

TUIT_CALC_REQ - Tuition Calc RequiredChar1
Calc Req

UM_ACAD_GRP_DESCR - Academic Group DescrChar30
Academic Group

UM_ACAD_LOAD_RC - Calculated Academic LoadChar1NCalc Acad Load

UM_ACAD_LVL_DESCR - Academic Level DescriptionChar30
Acad Level Desc

UM_ACAD_PLAN_DESCR - Academic Plan DescriptionChar30
Acad Plan Descr

UM_ACAD_PROGP_DSC - Acad Prog Primary DescrChar30
Acd Prg Prm Dsc

UM_ACAD_SUBPLN_DSC - Academic Sub Plan DescriptionChar30
Acad Sub Descr

UM_ADVISR_FST_NAME - Advisor First NameChar30
Advisr Fst Name

UM_ADVISR_LST_NAME - Advisor Last NameChar30
Advisr Lst Name

UM_ADVISR_MID_NAME - Advisor Middle NameChar30
Advisr Mid Name

UM_ADVISR_NAME_SFX - Advisor Name SuffixChar15
Advisr Name Sfx

UM_CITIZEN_STAT_OT - Citizenship Status OtherChar1
Citizn Stat OthThis field is essentially unreliable for students with more than 1 foreign country listed in the CITIZENSHIP table.

UM_COUNTRY_OTH - Country OtherChar3
Country OthThis field is essentially unreliable for students with more than 1 foreign country listed in the CITIZENSHIP table.

UM_COUNTRY_USA - Country is USAChar3
Country USA

UM_EMAIL_HOM_ADDR - Email Home AddressChar70
Email Home Addr

UM_ETHNIC_DESCR - Ethnic DescriptionChar50
Ethnic Descr

UM_ETH_GRP_DESCR - Ethnic Group DescrChar30
Eth Grp Descr

UM_EXT_ORGID_DESCR - External Org ID DescriptionChar30
Ext Org ID Desc

UM_FEES_PAID - Fees PaidSNm8.0

Fees Paid - Although this field says "Fees Paid," the values are actually charges calculated from the CHARGES tree per Darren Michael, 10/19/09.



UM_LAST_SCH_DESCR - Last School Attend DescriptionChar30
Lst School Desc

UM_LAST_SCH_TYPE - Last School Attended TypeChar3
Last School Typ

UM_MAX_ACT_COMP - Maximum ACT CompNum5.2
Max ACT Comp - Limited to last 5 years from census date

UM_MAX_ACT_ENGL - Maximum ACT EnglishNum5.2
Max ACT English - Limited to last 5 years from census date

UM_MAX_ACT_MATH - Maximum ACT MathNum5.2
Max ACT Math - Limited to last 5 years from census date

UM_MAX_GRE_QUAN - Maximum Quantitative GRENum5.2
Max GRE QUAN

UM_MAX_GRE_VERB - Maximum GRE VerbalNum5.2
Max GRE VERB

UM_MAX_SAT_ERWS - Max SAT ERWSNum5.2
Max SAT ERWS - Limited to last 5 years from census date

UM_MAX_SAT_MATH - Maximum Sat MathNum5.2
Max Sat Math - Limited to last 5 years from census date

UM_MAX_SAT_MSS - Max SAT MSSNum5.2
Max SAT MSS - Limited to last 5 years from census date

UM_MAX_SAT_VERB - Maximum Sat VerbalNum5.2
Max Sat Verbal - Limited to last 5 years from census date

UM_MAX_SAT_WRIT - Maximum SAT WriteNum5.2
Max SAT Write - Limited to last 5 years from census date

UM_MAX_TOEFL_COMPC - Maximum TOEFL COMPCNum5.2
Max TOEFL COMPC

UM_MAX_TOEFL_COMPI - Maximum TOEFL COMPINum5.2
Max TOEFL COMPI

UM_MAX_TOEFL_COMPP - Maximum TOEFL COMPPNum5.2
Max TOEFL COMPP

UM_MIN_ACAD_PLAN - Academic PlanChar10
Acad Plan

UM_MIN_ACAD_PROG - Academic ProgramChar5
Acad Prog

UM_MIN_ACAD_SUBPLN - Academic Sub-PlanChar10
Sub-Plan

UM_MULTIPLE_ETHNIC - Multiple Ethnic GroupsChar1NMutiple_Ethnic

UM_NID_CAN - National ID CanadaChar20
NID Canada

UM_NID_USA - National Id USAChar20
NID USA

UM_ORIG_ACAD_PLAN - ORIGINAL_ACAD_PLANChar10
ORIG_ACAD_PLAN

UM_ORIG_ACAD_PROG - ORIGINAL_ACAD_PROGChar5
ORIG_ACAD_PROG

UM_PREVIOUS_NAME - Previous NameChar50
Prev Name

UM_RSP_REASN_DESCR - Response Reason DescriptionsChar30
Resp Reason Des

UM_TUITION_PAID - Tuition PaidSNm8.0
Tuition Paid - Although this field says "Tuition Paid," the values are actually charges calculated from the CHARGES tree per Darren Michael, 10/19/09.

UM_UMS01_FLG - Ums01 Registered FlagChar1
Ums01 Flag

UM_UMS01_UNITS - UMS01 UnitsNum6.3
UMS01 Units

UM_UMS02_FLG - UMS02 Registered FlagChar1
UMS02 Flag

UM_UMS02_UNITS - UMS02 UnitsNum6.3
UMS02 Units

UM_UMS03_FLG - Ums03 Registered FlagChar1
Ums03 Flag

UM_UMS03_UNITS - UMS03 UnitsNum6.3
Ums03 Units

UM_UMS04_FLG - UMS04 Registered FlagChar1
UMS04 Flag

UM_UMS04_UNITS - UMS04 UnitsNum6.3
UMS04 Units

UM_UMS05_FLG - Ums05 Registered FlagChar1
Ums05 Flag

UM_UMS05_UNITS - UMS05 UnitsNum6.3
UMS05 Units

UM_UMS06_FLG - Ums06 Registered FlagChar1
Ums06 Flag

UM_UMS06_UNITS - UMS06 UnitsNum6.3
UMS06 Units

UM_UMS07_FLG - Ums07 Registered FlagChar1
Ums07 Flag

UM_UMS07_UNITS - UMS07 UnitsNum6.3
UMS07 Units

UM_UNT_DIST - Units DistanceNum10.3
Units Distance

UM_UNT_ITV - Itv Receive UnitsNum10.3
Itv Receive Unt

UM_UNT_TAK_CAREER - Units Taken For CareerNum6.3
Unt Takn Career

UM_UNT_TAK_PRG_RC - Units Taken Progress Row CheckNum6.3
Units Taken Prg

UM_UNT_WEB - Web UnitsNum10.3
Web Units

UNIT_MULTIPLIER - Unit MultiplierNum5.4
Multiplier

UNTPRG_CHG_NSLC_DT - Unit Progrss Changed Date NSCDate
Unit ChgDt NSC

UNT_AUDIT - Units AuditedNum6.3
Audit

UNT_INPROG_GPA - Units In Progress - GPANum6.3
InPr GPA

UNT_INPROG_NOGPA - Unit In Progress - Not for GPANum6.3
InPr NoGPA

UNT_OTHER - Units from Other CreditNum6.3
Other

UNT_PASSD_FA - Fin Aid Progress Units PassedNum6.3
FA Passed

UNT_PASSD_GPA - Units Passed Toward GPANum6.3
Pass GPA

UNT_PASSD_NOGPA - Units Passed Not Toward GPANum6.3
PassNoGPA

UNT_PASSD_PRGRSS - Units Passed for ProgressNum6.3
Pass Prgrs

UNT_TAKEN_FA - Fin Aid Progress Units TakenNum6.3
FA Taken

UNT_TAKEN_FA_GPA - FA Units Taken Toward GPANum6.3
FA Units T

UNT_TAKEN_GPA - Units Taken Toward GPANum6.3
Take GPA

UNT_TAKEN_NOGPA - Units Taken Not Toward GPANum6.3
TakeNoGPA

UNT_TAKEN_PRGRSS - Units Taken for ProgressNum6.3
Take Prgrs

UNT_TERM_TOT - Total Term UnitsNum6.3
Total

UNT_TEST_CREDIT - Units from Test CreditNum6.3
Test

UNT_TRNSFR - Units TransferredNum6.3
Transfer

VALIDATED - Election ValidatedChar1
Validated

VALIDATED_DT - Date Data ValidatedDate
Date Validated

WITHDRAW_CODE - Withdrawal \ CancelChar3NWdraw Code

WITHDRAW_DATE - Withdrawal \ Cancel DateDate
Wdraw Date

WITHDRAW_REASON - Withdrawal \ Cancel ReasonChar4NWithdrlRsn



Data Dictionary Links

Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.


Notes for Developers

It is created by Application Engine Program called UM_STCENSUS.