UM_STUD_CENSUS - Student Reporting Extract Arch

 

WARNING: Field Name Definitions are Linked to the UMS Data Cookbook - this requires a University of Maine System ID and password

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.

Detailed Information 

Databases

PeopleSoft Campus Solutions Production: CSPRD
PeopleSoft Campus Solutions Reporting: CSRPT

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.

Notes for Developers - It is created by Application Engine Program called UM_STCENSUS.

Key Record.Fieldname Format XLAT Heading Text Notes
  ACADEMIC_LOAD - Academic Load Char1 N Acad Load  
  ACADEMIC_LOAD_DT - Academic Load Change Date Date   Load Date  
Key ACAD_CAREER - Academic Career Char4 N Career  
  ACAD_CAREER_FIRST - First Time in Career Char1   First Time Car  
  ACAD_GROUP - Academic Group Char5   Acad Group  
  ACAD_GROUP_ADVIS - Academic Group of Advisor Char5   Group  
  ACAD_LEVEL_BOT - Academic Level - Term Start Char3   Strt Level  
  ACAD_LEVEL_EOT - Academic Level - Term End Char3   End Level Do Not Use
  ACAD_LEVEL_PROJ - Academic Level - Projected Char3   Proj Level  
  ACAD_LOAD_APPR - Approved Academic Load Char1 N Acad Load  
Key ACAD_PLAN - Academic Plan Char10   Acad Plan  
  ACAD_PLAN_TYPE - Academic Plan Type Char3 N Plan Type  
Key ACAD_PROG - Academic Program Char5   Acad Prog  
  ACAD_PROG_DESCR - Academic Program Char30   Program  
  ACAD_PROG_DUAL - Dual Academic Program Char5   Dual Prog  
  ACAD_PROG_PRIMARY - Primary Academic Program Char5   Prim Prog  
  ACAD_SUBPLAN_TYPE - Academic Sub-Plan Type Char3 N Sub-Pl Typ  
  ACAD_SUBPLAN - Academic Sub-Plan Char10   Sub-Plan  
  ACAD_YEAR - Academic Year Char4   Acad Year  
  ACTION_DT - Action Date Date   Action Date  
  ADDRESS1 - Address Line 1 Char55   Address 1  
  ADDRESS2 - Address Line 2 Char55   Address 2  
  ADDRESS3 - Address Line 3 Char55   Address 3  
  ADDRESS4 - Address Line 4 Char55   Address 4  
  ADMISSION_EXCPT - Admission Residency Exception Char5   Adm Excpt  
  ADMISSION_RES - Admissions Residency Char5   Admissions  
  ADMIT_TERM - Admit Term Char4   Admit Term  
  ADMIT_TYPE - Admit Type Char3   Admit Type  
  ADM_APPL_CTR - Application Center Char4   Appl Ctr  
Key ADM_APPL_NBR - Application Nbr Char8   Appl Nbr  
  ADVISOR_ID - Academic Advisor Char11   Advisor  
  ADVIS_STATUS - Advisement Status Char4 N Status  
  BILLING_CAREER - Billing Career Char4   Bill Car  
  BIRTHDATE - Date of Birth Date   Birthdate  
  BIRTHPLACE - Birth Location Char30   Birthplace  
  BIRTHSTATE - Birth State Char6   State  
  BIRTH_COUNTRY - BIRTH_COUNTRY Char4   BIRTH_COUNTRY  
  CAMPUS - Campus Char5   Campus  
  CENSUS_DT - Census Date Date   Census Dt  
  CITIZENSHIP_STATUS - Citizenship Status Char1   Status  
  CITY - City Char30   City  
  CLASS_RANK_NBR - Class Rank Nbr Num5.0   Class Rank  
  CLASS_RANK_TOT - Class Rank Total Num5.0   Of  
  COMPLETION_TERM - Completion Term Char4   Compl Term  
  COUNTRY - Country Char3   Country  
  COUNTRY_DESCR1 - Country Description Char30   Country  
  COUNTY - County Char30   County  
  CUM_GPA - Cumulative GPA Num6.3   GPA  
  CUM_RESIDENT_TERMS - Cumulative In Residence Terms Num4.3   Cum Res  
  CUR_GPA - Current GPA Num6.3   GPA  
  CUR_RESIDENT_TERMS - Current In Residence Terms Num4.3   Cur Res  
  DECLARE_DT - Declare Date Date   Decl Date  
  DEGREE - Degree Char8   Degree  
  DEGR_CHKOUT_STAT - Degree Checkout Status Char2 N ChkoutStat  
  DT_OF_DEATH - Date of Death Date   Death Date  
  EDUCATION_LVL - Education Level Char2 N Education  
  EFFECTIVE_TERM - Effective Term Char4   Effective  
  ELIG_TO_ENROLL - Eligible to Enroll Char1   Elig Enrl  
  EMAIL_ADDR - Email Address Char70   Email  
Key EMPLID - Empl ID Char11   ID  
  END_DATE - End Date Date   End Date  
  ENRL_ON_TRANS_DT - Show Enrollment on Transcript Date   Enrl Trans  
  ETHNIC_CATEGORY - Ethnic Category (this field has no data) Char1 N Ethnic Cat  
  ETHNIC_GROUP - Ethnic Group Char1 N Ethnic Grp  
  ETHNIC_GRP_CD - Ethnic Group Char8   Ethnic Grp  
  EXP_GRAD_TERM - Expected Graduation Term Char4   Exp Grad  
  EXT_ORG_ID - External Org ID Char11   Org ID  
  FA_ELIGIBILITY - Program Eligibility Flag Char1   Eligible  
  FA_LOAD - Financial Aid Load Char1 N FA Load  
  FA_STATS_CALC_DTTM - FA Stats Calc Date Time DateTm   FA DTTM  
  FA_STATS_CALC_REQ - FA Stats Calculation Required Char1   FA Calc  
  FIRST_NAME - First Name Char30   First Name  
  FORM_OF_STUDY - Form of Study Char4 N Study Form  
  FULLY_ENRL_DT - Fully Enrolled Date Date   Full Enrl  
  FULLY_GRADED_DT - Fully Graded Date Date   Full Grded  
  GRADE_POINTS - Grade Points Num7.3   Grd Points  
  GRADE_POINTS_FA - Financial Aid Grade Points Num7.3   FA Grd Pt  
  GRADUATION_DT - Graduation Date Date   Grad Dt High school graduation date
  HISP_LATINO - Person is Hispanic or Latino Char1   Hisp or Latin  
Key INSTITUTION - Academic Institution Char5   Institution  
  INSTITUTION_DESCR - Institution Char30   Institution  
  JOINT_PROG_APPR - Joint Program Approved Char1   Joint Program  
  LAST_DATE_ATTENDED - Last Date of Attendance Date   Last Date  
  LAST_NAME - Last Name Char30   Last  
  LEVEL_LOAD_RULE - Academic Level Rule Char5   Level Rule  
  LOCK_IN_AMT - Lock In Amount SNm15.2   Amount  
  LOCK_IN_DT - Lock In Date Date   Date  
  MAR_STATUS - Marital Status Char1 N Mar Status  
  MAR_STATUS_DT - Marital Status Date Date   Mar StatDt  
  MAX_AUDIT_UNIT - Max Audit Units Num4.2   Max Audit  
  MAX_CRSE_COUNT - Max Total Courses Num3.0   Total Crse  
  MAX_NOGPA_UNIT - Max No GPA Units Num4.2   Max Grd Pt  
  MAX_TOTAL_UNIT - Max Total Units Num4.2   Max Units  
  MAX_WAIT_UNIT - Max Wait List Units Num4.2   Max Wait  
  MIDDLE_NAME - Middle Name Char30   Middle  
  MIN_TOTAL_UNIT - Min Total Units Num4.2   Min Units  
  NAME - Name Char50   Name  
  NAME_PREFIX - Name Prefix Char4   Prefix  
  NAME_SUFFIX - Name Suffix Char15   Suffix  
  NSLDS_LOAN_YEAR - NSLDS Loan Year Char1 N Loan Year  
  OVRD_ACAD_LVL_ALL - Override All Academic Levels Char1   Ovrd Lvls  
  OVRD_ACAD_LVL_PROJ - Override Projected Level Char1   Ovrd Level  
  OVRD_BILL_UNITS - Override Billing Units Char1   Ovrd Bill  
  OVRD_INIT_ADD_FEE - Override Initial Add Fees Char1   Override Fee  
  OVRD_INIT_ENR_FEE - Override Initial Enroll Fee Char1   Override Fee  
  OVRD_MAX_UNITS - Override Maximum Units Char1   Ovrd Units  
  OVRD_TUIT_GROUP - Override Tuition Group Char10   Ov Tuit Gp  
  OVRD_WDRW_SCHED - Override Withdrawal Schedule Char8   Ov Wd Schd  
  PHONE - Telephone Char24   Phone  
  PIN_NUM - PIN Number Num8.0   PIN Number  
  PLAN_SEQUENCE - Plan Sequence Num2.0   Plan Seq  
  POSTAL - Postal Code Char12   Postal  
  PROG_ACTION - Program Action Char4 N Prog Actn  
  PROG_REASON - Action Reason Char4   Action Rsn  
  PROG_STATUS - Academic Program Status Char4 N Status  
  PROJ_BILL_UNT - Projected Bill Units Num3.0   Bill Units  
  PRO_RATA_ELIGIBLE - Pro-Rata Eligible Char1   Eligible  
  REFUND_PCT - Refund Percentage Num4.2   Refund %  
  REFUND_SCHEME - Refund Scheme Char8   Scheme  
  REGISTERED - Registered Char1 N Registered  
  REG_CARD_DATE - Registration Card Date Date   Reg Card  
  REQ_TERM - Requirement Term Char4   Req Term  
  RESET_CUM_STATS - Reset Cum Stats at Term Start Char1   Cum Reset  
  RESIDENCY - Tuition Residency Char5   Tuition Resid  
  RESIDENCY_DT - Residency Date Date   Res Date  
  RESPONSE_DT - Response Date Date   Date  
  RESPONSE_REASON - Response Reason Char4   Reason  
  ROW_CHECK - ROW CHECK* Char1   ROW CHECK  
  SEL_GROUP - Tuition Group Char10   Group  
  SEX - Gender Char1 N Sex  
  SSR_ACTIVATION_DT - Term Activation Date Date   Activation Date  
  START_DATE - Start Date for Gen Standing PO Date   Start Date  
  STATE - State Char6   State  
  STATE_DESCR1 - State Description Char30   State  
  STATS_ON_TRANS_DT - Show Statistics on Transcript Date   Stat Trans  
Key STDNT_CAR_NBR - Student Career Nbr Num3.0   Career Nbr  
  STDNT_DEGR - Student Degree Nbr Char2   Degree Nbr  
Key STRM - Term Char4   Term  
  STUDY_AGREEMENT - Study Agreement Char10   Agreement  
  TC_UNITS_ADJUST - TC Units Adjustment Num6.3   TC Units Adjust  
  TERM_TYPE - Term Unit Type Char1 N Term Type  
  TOT_AUDIT - Total Audited Num6.3   Audit  
  TOT_CUMULATIVE - Total Cumulative Units Num6.3   Total  
  TOT_GRADE_POINTS - Total Grade Points Num7.3   Grade Points  
  TOT_GRD_POINTS_FA - Total Fin Aid Grade Points Num7.3   Tot FA Grd  
  TOT_INPROG_GPA - Total In Progress - GPA Num6.3   In Pr GPA  
  TOT_INPROG_NOGPA - Total In Progress -Not for GPA Num6.3   InPr NoGPA  
  TOT_OTHER - Total from Other Credit Num6.3   Other  
  TOT_PASSD_FA - Total Fin Aid Units Passed Num6.3   Pass FA  
  TOT_PASSD_GPA - Total Passed Toward GPA Num6.3   Pass GPA  
  TOT_PASSD_NOGPA - Total Passed Not Toward GPA Num6.3   PassNoGPA  
  TOT_PASSD_PRGRSS - Total Passed for Progress Num6.3   Pass Prgrs  
  TOT_TAKEN_FA - Total Fin Aid Units Taken Num6.3   Take FA  
  TOT_TAKEN_FA_GPA - Total Fin Aid Taken Toward GPA Num6.3   Tot FA GPA  
  TOT_TAKEN_GPA - Total Taken Toward GPA Num6.3   Take GPA  
  TOT_TAKEN_NOGPA - Total Taken Not Toward GPA Num6.3   TakeNoGPA  
  TOT_TAKEN_PRGRSS - Total Taken for Progress Num6.3   Take Prgrs  
  TOT_TEST_CREDIT - Total From Test Credit Num6.3   Test  
  TOT_TRNSFR - Total Transferred Num6.3   Transfer  
  TRF_GRADE_POINTS - Transfer Grade Points Num7.3   Trnsfr Grd Pts  
  TRF_PASSED_GPA - Transfer Passed for GPA Num6.3   TrnPasGPA  
  TRF_PASSED_NOGPA - Transfer Passed Not for GPA Num6.3   TrnPasNGPA  
  TRF_RESIDENT_TERMS - Transfer In Residence Terms Num4.3   Trf Res  
  TRF_TAKEN_GPA - Transfer Taken for GPA Num6.3   TrnTakGPA  
  TRF_TAKEN_NOGPA - Transfer Taken Not for GPA Num6.3   TrnTakNGPA  
  TUITION_RES_TERMS - Tuition Residency Num4.3   Tuition Res.  
  TUIT_CALC_DTTM - Tuit Calc Date Time DateTm   TuitDTTM  
  TUIT_CALC_REQ - Tuition Calc Required Char1   Calc Req  
  UM_ACAD_GRP_DESCR - Academic Group Descr Char30   Academic Group  
  UM_ACAD_LOAD_RC - Calculated Academic Load Char1 N Calc Acad Load  
  UM_ACAD_LVL_DESCR - Academic Level Description Char30   Acad Level Desc  
  UM_ACAD_PLAN_DESCR - Academic Plan Description Char30   Acad Plan Descr  
  UM_ACAD_PROGP_DSC - Acad Prog Primary Descr Char30   Acd Prg Prm Dsc  
  UM_ACAD_SUBPLN_DSC - Academic Sub Plan Description Char30   Acad Sub Descr  
  UM_ADVISR_FST_NAME - Advisor First Name Char30   Advisr Fst Name  
  UM_ADVISR_LST_NAME - Advisor Last Name Char30   Advisr Lst Name  
  UM_ADVISR_MID_NAME - Advisor Middle Name Char30   Advisr Mid Name  
  UM_ADVISR_NAME_SFX - Advisor Name Suffix Char15   Advisr Name Sfx  
  UM_CITIZEN_STAT_OT - Citizenship Status Other Char1   Citizn Stat Oth This field is essentially unreliable for students with more than 1 foreign country listed in the CITIZENSHIP table.
  UM_COUNTRY_OTH - Country Other Char3   Country Oth This field is essentially unreliable for students with more than 1 foreign country listed in the CITIZENSHIP table.
  UM_COUNTRY_USA - Country is USA Char3   Country USA  
  UM_EMAIL_HOM_ADDR - Email Home Address Char70   Email Home Addr  
  UM_ETHNIC_DESCR - Ethnic Description Char50   Ethnic Descr  
  UM_ETH_GRP_DESCR - Ethnic Group Descr Char30   Eth Grp Descr  
  UM_EXT_ORGID_DESCR - External Org ID Description Char30   Ext Org ID Desc  
  UM_FEES_PAID - Fees Paid SNm8.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 Description Char30   Lst School Desc  
  UM_LAST_SCH_TYPE - Last School Attended Type Char3   Last School Typ  
  UM_MAX_ACT_COMP - Maximum ACT Comp Num5.2   Max ACT Comp - Limited to last 5 years from census date  
  UM_MAX_ACT_ENGL - Maximum ACT English Num5.2   Max ACT English - Limited to last 5 years from census date  
  UM_MAX_ACT_MATH - Maximum ACT Math Num5.2   Max ACT Math - Limited to last 5 years from census date  
  UM_MAX_GRE_QUAN - Maximum Quantitative GRE Num5.2   Max GRE QUAN  
  UM_MAX_GRE_VERB - Maximum GRE Verbal Num5.2   Max GRE VERB  
  UM_MAX_SAT_ERWS - Max SAT ERWS Num5.2   Max SAT ERWS - Limited to last 5 years from census date  
  UM_MAX_SAT_MATH - Maximum Sat Math Num5.2   Max Sat Math - Limited to last 5 years from census date  
  UM_MAX_SAT_MSS - Max SAT MSS Num5.2   Max SAT MSS - Limited to last 5 years from census date  
  UM_MAX_SAT_VERB - Maximum Sat Verbal Num5.2   Max Sat Verbal - Limited to last 5 years from census date  
  UM_MAX_SAT_WRIT - Maximum SAT Write Num5.2   Max SAT Write - Limited to last 5 years from census date  
  UM_MAX_TOEFL_COMPC - Maximum TOEFL COMPC Num5.2   Max TOEFL COMPC  
  UM_MAX_TOEFL_COMPI - Maximum TOEFL COMPI Num5.2   Max TOEFL COMPI  
  UM_MAX_TOEFL_COMPP - Maximum TOEFL COMPP Num5.2   Max TOEFL COMPP  
  UM_MIN_ACAD_PLAN - Academic Plan Char10   Acad Plan  
  UM_MIN_ACAD_PROG - Academic Program Char5   Acad Prog  
  UM_MIN_ACAD_SUBPLN - Academic Sub-Plan Char10   Sub-Plan  
  UM_MULTIPLE_ETHNIC - Multiple Ethnic Groups Char1 N Mutiple_Ethnic  
  UM_NID_CAN - National ID Canada Char20   NID Canada  
  UM_NID_USA - National Id USA Char20   NID USA  
  UM_ORIG_ACAD_PLAN - ORIGINAL_ACAD_PLAN Char10   ORIG_ACAD_PLAN  
  UM_ORIG_ACAD_PROG - ORIGINAL_ACAD_PROG Char5   ORIG_ACAD_PROG  
  UM_PREVIOUS_NAME - Previous Name Char50   Prev Name  
  UM_RSP_REASN_DESCR - Response Reason Descriptions Char30   Resp Reason Des  
  UM_TUITION_PAID - Tuition Paid SNm8.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 Flag Char1   Ums01 Flag  
  UM_UMS01_UNITS - UMS01 Units Num6.3   UMS01 Units  
  UM_UMS02_FLG - UMS02 Registered Flag Char1   UMS02 Flag  
  UM_UMS02_UNITS - UMS02 Units Num6.3   UMS02 Units  
  UM_UMS03_FLG - Ums03 Registered Flag Char1   Ums03 Flag  
  UM_UMS03_UNITS - UMS03 Units Num6.3   Ums03 Units  
  UM_UMS04_FLG - UMS04 Registered Flag Char1   UMS04 Flag  
  UM_UMS04_UNITS - UMS04 Units Num6.3   UMS04 Units  
  UM_UMS05_FLG - Ums05 Registered Flag Char1   Ums05 Flag  
  UM_UMS05_UNITS - UMS05 Units Num6.3   UMS05 Units  
  UM_UMS06_FLG - Ums06 Registered Flag Char1   Ums06 Flag  
  UM_UMS06_UNITS - UMS06 Units Num6.3   UMS06 Units  
  UM_UMS07_FLG - Ums07 Registered Flag Char1   Ums07 Flag  
  UM_UMS07_UNITS - UMS07 Units Num6.3   UMS07 Units  
  UM_UNT_DIST - Units Distance Num10.3   Units Distance  
  UM_UNT_ITV - Itv Receive Units Num10.3   Itv Receive Unt  
  UM_UNT_TAK_CAREER - Units Taken For Career Num6.3   Unt Takn Career  
  UM_UNT_TAK_PRG_RC - Units Taken Progress Row Check Num6.3   Units Taken Prg
 
  UM_UNT_WEB - Web Units Num10.3   Web Units  
  UNIT_MULTIPLIER - Unit Multiplier Num5.4   Multiplier  
  UNTPRG_CHG_NSLC_DT - Unit Progrss Changed Date NSC Date   Unit ChgDt NSC  
  UNT_AUDIT - Units Audited Num6.3   Audit  
  UNT_INPROG_GPA - Units In Progress - GPA Num6.3   InPr GPA  
  UNT_INPROG_NOGPA - Unit In Progress - Not for GPA Num6.3   InPr NoGPA  
  UNT_OTHER - Units from Other Credit Num6.3   Other  
  UNT_PASSD_FA - Fin Aid Progress Units Passed Num6.3   FA Passed  
  UNT_PASSD_GPA - Units Passed Toward GPA Num6.3   Pass GPA  
  UNT_PASSD_NOGPA - Units Passed Not Toward GPA Num6.3   PassNoGPA  
  UNT_PASSD_PRGRSS - Units Passed for Progress Num6.3   Pass Prgrs  
  UNT_TAKEN_FA - Fin Aid Progress Units Taken Num6.3   FA Taken  
  UNT_TAKEN_FA_GPA - FA Units Taken Toward GPA Num6.3   FA Units T  
  UNT_TAKEN_GPA - Units Taken Toward GPA Num6.3   Take GPA  
  UNT_TAKEN_NOGPA - Units Taken Not Toward GPA Num6.3   TakeNoGPA  
  UNT_TAKEN_PRGRSS - Units Taken for Progress Num6.3   Take Prgrs  
  UNT_TERM_TOT - Total Term Units Num6.3   Total  
  UNT_TEST_CREDIT - Units from Test Credit Num6.3   Test  
  UNT_TRNSFR - Units Transferred Num6.3   Transfer  
  VALIDATED - Election Validated Char1   Validated  
  VALIDATED_DT - Date Data Validated Date   Date Validated  
  WITHDRAW_CODE - Withdrawal \ Cancel Char3 N Wdraw Code  
  WITHDRAW_DATE - Withdrawal \ Cancel Date Date   Wdraw Date  
  WITHDRAW_REASON - Withdrawal \ Cancel Reason Char4 N WithdrlRsn  
 
Submit an Inquiry or Request to DARTS Print Article

Details

Article ID: 158910
Created
Fri 5/10/24 4:28 AM
Modified
Mon 8/19/24 11:02 AM
Applies To
Faculty
Staff
Community

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)