UM_D_MIN_TERMS - Student Minimum Terms

 

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

This View was built for the Discoverer Tool which has been retired,  The view remains valid and is available for use. 
It includes the first and the most recent admit terms, both with and without credits for each student.​​ using the Source Tables listed.

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

Source Tables

ACAD_PROG - Student Academic Program
ADM_APPL_PROG - Admission Applicant Program
STDNT_CAR_TERM - Student Career Term Table

View SQL Code
Download SQL Code

Join this table to another table containing information about the student such as the UM_STUD_EXT_VW - Student Reporting Extract to find out when a student first enrolled. This could be useful, for instance, to determine whether or not someone is a First-Time student. 

Key Record.Fieldname Format XLAT Heading Text Source Table
Key ACAD_CAREER
 - Academic Career		 Char4 N Career ADM_APPL_PROG 
  ADMIT_TERM
 - First Admit Term		 Char4   First Admit Ter ADM_APPL_PROG 
Key EMPLID - Empl ID Char11   ID ADM_APPL_PROG 
Key INSTITUTION
 - Academic Institution		 Char5   Institution ADM_APPL_PROG 
  STRM - First Term Char4   First Term STDNT_CAR_TERM
  UM_MAX_ADMIT_TERM
 - Maximim Admit Term		 Char4   Max Admit_term STDNT_CAR_TERM
  UM_MAX_TERM
 - Maximum Term		 Char4   Max Term STDNT_CAR_TERM
  UM_MAX_TERM_NOCRED
 - MAX STRM no credit hour check		 Char4   MAX TERM NOCRED STDNT_CAR_TERM
  UM_MIN_STRM_NOCRED
 - Min STRM no credit hour check		 Char4   Min STRM no chk STDNT_CAR_TERM

 

Submit an Inquiry or Request to DARTS Print Article

Details

Article ID: 158874
Created
Fri 5/10/24 4:27 AM
Modified
Tue 9/17/24 9:37 AM
Applies To
Faculty
Staff
Community

Related Services / Offerings (1)

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