UM_STD_ENR_C_VW - Student Enrollment Table

Body

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

This is a view of  UM_STD_ENR_CENS table. It contains the same fields as UM_D_STD_ENR_VW.

Detailed Information

Data Systems

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

View SQL Build Code

Download SQL Build Code

This view also contains the UM_INST_HOST field used for Cross-listed Course Reporting.

Key Record.Fieldname Format XLAT Heading Text Notes
Key ACAD_CAREER - Academic Career Char4   Career  
  ACAD_GROUP - Academic Group Char5   Acad Group  
  ACAD_ORG - Academic Organization Char10   Acad Org  
  ACAD_PROG - Academic Program Char5   Acad Prog  
  ASSOCIATED_CLASS - Associated Class Num4.0   Assoc  
  ASSOCIATION_99 - Association 99 Char1   Assoc 99  
  AUDIT_GRADE_BASIS - Audit Grading Basis Char1   Audit  
  CAMPUS - Campus Char5   Campus  
  CATALOG_NBR - Catalog Nbr Char10   Catalog  
Key CLASS_NBR - Class Nbr Num5.0   Class Nbr  
Key CLASS_SECTION - Class Section Char4   Section  
  CLASS_STAT - Class Status Char1 N Class Stat  
  CLASS_TYPE - Class Type Char1 N Class Type  
  CRSE_CAREER - Course Career Char4   Course Car  
  CRSE_COUNT - Course Count Num3.2   Crse Count  
  CRSE_GRADE_INPUT - Grade Input Char3   Grade In  
  CRSE_GRADE_OFF - Official Grade Char3   Grade  
Key CRSE_ID - Course ID Char6   Course ID  
Key CRSE_OFFER_NBR - Course Offering Nbr Num2.0   Offer Nbr  
  DESCR - Description Char30   Descr  
  DESCR_LOCATION - Location Description Char30   Description  
  DROP_CLASS_IF_ENRL - Drop This Class if Enrolled Num5.0   Drop if Enroll  
  DYN_CLASS_NBR - Dynamic Class Nbr Num5.0   Dyn Class Nbr  
  EARN_CREDIT - Earn Credit Char1   EarnCredit  
Key EMPLID - Empl ID Char11   ID  
  ENRL_ACTION_LAST - Last Enrollment Action Char2   Last Act  
  ENRL_ACTN_PRC_LAST - Last Enrollment Action Process Char2   Process  
  ENRL_ACTN_RSN_LAST - Last Enrl Action Reason Char4   Reason  
  ENRL_ADD_DT - Enrollment Add Date Date   Add Dt  
  ENRL_CAP - Enrollment Capacity Num4.0   Cap Enrl  
  ENRL_DROP_DT - Enrollment Drop Date Date   Drop Dt  
  ENRL_REQ_SOURCE - Enrollment Request Source Char2 N Source  
  ENRL_STAT - Enrollment Status Char1 N Enrl Stat  
  ENRL_STATUS_REASON - Enrollment Status Reason Char4 N Reason  
  FIRST_NAME - First Name Char30   First Name  
  GRADE_CATEGORY - Grade Category Char4 N Grade Category  
  GRADE_DT - Grade Date Date   Grade Dt  
  GRADE_POINTS - Grade Points Num7.3   Grd Points  
  GRADE_POINTS_FA - Financial Aid Grade Points Num7.3   FA Grd Pt  
  GRADING_BASIS_DT - Grading Basis Date Date   Basis Dt  
  GRADING_BASIS_ENRL - Grading Basis Char3   Grade Base  
  GRADING_SCHEME_ENR - Field is not active yet Char3   Field not activ  
  GRD_PTS_PER_UNIT - Grade Points Per Unit Num7.3   Grd Pt/Unt  
  INCLUDE_IN_GPA - Include in GPA Char1   Incl GPA  
Key INSTITUTION - Academic Institution Char5   Institution  
  INSTRUCTION_MODE - Instruction Mode Char2   Mode  
  INSTRUCTOR_ID - Instructor ID Char11   Instructor  
  LAST_DROP_DT_STMP - Last Drop Date Stamp Date   Last Drop Date  
  LAST_DROP_TM_STMP - Last Drop Time Stamp Time   Last Drop Time  
  LAST_ENRL_DT_STMP - Last Enrollment Date Stamp Date   Last Enrl Date  
  LAST_ENRL_TM_STMP - Last Enrollment Time Stamp Time   Last Enrl Time  
  LAST_NAME - Last Name Char30   Last  
  LAST_UPD_DT_STMP - Last Update Date Stamp Date   Last Upd Date  
  LAST_UPD_ENREQ_SRC - Enrollment Request Source Char2 N Source  
  LAST_UPD_TM_STMP - Last Update Time Stamp Time   Last Upd Time  
  LOCATION - Location Code Char10   Location  
  MANDATORY_GRD_BAS - Mandatory Grading Basis Char1   Mandatory  
  MIDDLE_NAME - Middle Name Char30   Middle  
  NAME_PREFIX - Name Prefix Char4   Prefix  
  NAME_SUFFIX - Name Suffix Char15   Suffix  
  NOTIFY_STDNT_CHNG - Notify Student of Change Char2 N Notify Student  
  OVRD_GRADING_BASIS - Override Grading Basis Char1   Grading Basis  
  RELATE_CLASS_NBR_1 - Field is not active yet Num5.0   Field not activ  
  RELATE_CLASS_NBR_2 - Field is not active yet Num5.0   Field not activ  
  REPEAT_CANDIDATE - Repeat Candidate Flag Char1   Rpt Candidat  
  REPEAT_CODE - Repeat Code Char4   Repeat  
  REPEAT_DT - Repeat Date Date   Repeat Dt  
  SCTN_COMBINED_ID - Combined Sections ID Char4   Comb Sects ID  
  SEL_GROUP - Tuition Group Char10   Group  
  SESSION_CODE - Session Char3 N Session  
  SSR_COMPONENT - Course Component Char3 N Component The translation is on psxlatitem. (fieldname ='SSR_COMPONENT')
  STATUS_DT - Status Date Date   Stat Dt  
  STDNT_ENRL_STATUS - Student Enrollment Status Char2 N Status  
  STDNT_SPEC_PERM - Student Specific Permissions Char1   Stdnt Spec  
Key STRM - Term Char4   Term  
  SUBJECT - Subject Area Char8   Subject  
  TSCRPT_NOTE_EXISTS - Transcript Note Exists Flag Char1   Tscrpt Ex  
  TSCRPT_NOTE_ID - Transcript Note ID Char4   Note ID  
  UM_ACAD_ORG_DESCR - Academic Organization Descript Char30   Acad Org Dsecr  
  UM_CENTER_CD - Center Code Char4   Center see Distance Education Course Coding - Current for code
  UM_CENTER_DESCR - Center Description Char25   Center Descr see Distance Education Course Coding - Current for code
  UM_CLASS_DLV_MODE - Class Delivery Mode Char30   Class Dlv Mode see Distance Education Course Coding - Current for code
  UM_CLASS_LEVEL - Class Level Char1   Class Level  
  UM_DISTANCE_FLAG - Distance Flag Char2   Distance Flag see Distance Education Course Coding - Current for code
  UM_DIST_ATTR_FLAG - Distance Attribute Flag Char2 N Dist Attr Flag see Distance Education Course Coding - Current for code
  UM_DIST_ATTR_F_DSC - Dist Attr Flag Description Char30   Dist Attr F Dsc see Distance Education Course Coding - Current for code
  UM_DIST_CLASS - Distance Class Char10   Distance Class see Distance Education Course Coding - Current for code
  UM_DIST_FLG_DESCR - Distribution Flag Description Char30   Dist Flg Descr see Distance Education Course Coding - Current for code
  UM_IMODE - Imode Char10   Imode see Distance Education Course Coding - Current for code
  UM_IMODE_DESCR - Instruction Mode Description Char30   IMODE Descr  
  UM_INSTRUCTOR_NAME - Instructor Name Char50   Instructor Name  
  UM_INST_HOST - UM Host Institution Char5   Host Inst Created for reporting cross-listed course. 
Select for definitions, fields, and field values.
  UM_INST_SHORT - Institution Short Char5   Inst Short  
  UM_IPEDS_DIST_CLSS - IPEDS Distribution Class Char30   IPEDS Dist Clss see Distance Education Course Coding - Current for code
  UM_LOCATION_DESCR - Location Description Char30   Location Descr  
  UM_REGION - Region Char30   Region see Distance Education Course Coding - Current for code
  UM_SITE_CATEGORY - Site Category Char20   Site Category see Distance Education Course Coding - Current for code
  UM_STDNT_ENRL_STAT - Student Enroll Stat Decoded Char30   Stud Enr Stat  
  UM_UNIV_CENTER_DSC - University Center Description Char30   Univ Center Dsc see Distance Education Course Coding - Current for code
  UM_UNIV_CENTER_FLG - University Center Flag Char1   Univ Center Flg see Distance Education Course Coding - Current for code
  UNITS_ACAD_PROG - Academic Progress Units Num4.2   Prgrss Unt  
  UNITS_ATTEMPTED - Units Attempted Char1 N Units Att  
  UNITS_MAXIMUM - Maximum Units Num4.2   Max Units  
  UNITS_MINIMUM - Minimum Units Num4.2   Min Units  
  UNT_BILLING - Billing Units Num4.2   Bill Units  
  UNT_EARNED - Units Earned Num4.2   Units  
  UNT_PRGRSS - Units Taken-Academic Progress Num4.2   Progress  
  UNT_PRGRSS_FA - Units Taken-Fin Aid Progress Num4.2   FA Progress  
  UNT_TAKEN - Units Taken Num4.2   Unit Taken  
  VALID_ATTEMPT - Valid Attempted Grade Char1   Valid Attempt  

Details

Details

Article ID: 158907
Created
Fri 5/10/24 4:27 AM
Modified
Wed 8/21/24 2:13 PM
Applies To
Faculty
Staff
Community

Related Articles

Related Articles (1)

Distance Education Course Coding - Current

Related Services / Offerings

Related Services / Offerings (1)

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

Attachments

Attachments (1) Sort By: Sort Attachments ByName Sort Attachments ByDate

txt

UM_STD_ENR_C_VW SQL Build Code.txt Computer

Tue 8/20/24 4:22 PM
View
;