UM_APPL_EXTRACT - Applicant Reporting Extract

Body

 

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

Extracted table of applicant information by admit term, institution, and student

Detailed Information

Data Systems

PeopleSoft Campus Solutions  CSPRD
PeopleSoft Campus Solutions Reporting CSRPT

The SQR code is located in S:\STUDENT\SQR\PROD\umappext.sqr

View SQR Build Code

Download SQR Build Code

Key Record.Fieldname Format XLAT Heading Text Notes/ Sources
  ACADEMIC_LEVEL - Academic Level Char3 N Acad Level ADM_APPL_DATA
Key ACAD_CAREER - Academic Career Char4 N Career ADM_APPL_DATA
  ACAD_GROUP - Academic Group Char5   Acad Group

ACAD_PROG_TBL
  ACAD_LOAD_APPR - Approved Academic Load Char1 N Acad Load ADM_APPL_PROG
  ACAD_PLAN - Academic Plan Char10   Acad Plan  
  ACAD_PLAN_TYPE - Academic Plan Type Char3 N Plan Type  
  ACAD_PROG - Academic Program Char5   Acad Prog ADM_APPL_PROG or ACAD_PROG
  ACAD_PROG_DESCR - Academic Program Char30   Program  
  ACAD_SUBPLAN_TYPE - Academic Sub-Plan Type Char3 N Sub-Pl Typ  
  ACAD_SUB_PLAN - Academic Sub-Plan Char10   Sub-Plan  
  ACTION_DT - Action Date Date   Action Date ADM_APPL_PROG
  ADDRESS1 - Address Line 1 Char55   Address 1 PERSONAL_DATA
  ADDRESS2 - Address Line 2 Char55   Address 2 PERSONAL_DATA
  ADDRESS3 - Address Line 3 Char55   Address 3 PERSONAL_DATA
  ADDRESS4 - Address Line 4 Char55   Address 4 PERSONAL_DATA
  ADMISSION_EXCPT - Admission Residency Exception Char5   Adm Excpt  
  ADMISSION_RES - Admissions Residency Char5   Admissions  
Key ADMIT_TERM - Admit Term Char4   Admit Term ADM_APPL_PROG
  ADMIT_TYPE - Admit Type Char3   Admit Type ADM_APPL_DATA
  ADM_APPL_CMPLT_DT - Completed Date Date   Date ADM_APPL_DATA
  ADM_APPL_COMPLETE - Application Complete Char1   Complete

ADM_APPL_DATA 
"Y" for completed application
  ADM_APPL_CTR- Application Center Char4   Appl Ctr ADM_APPL_DATA
  ADM_APPL_DT - Application Date Date   Appl Dt ADM_APPL_DATA
  ADM_APPL_METHOD - Application Method Char3 N Appl Meth ADM_APPL_DATA
Key ADM_APPL_NBR - Application Nbr Char8   Appl Nbr

ADM_APPL_DATA 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application Program Data
  ADM_CREATION_BY - Admission Data Created By Char30   Created By ADM_APPL_DATA
  ADM_CREATION_DT - Admission Data Creation Date Date   Created On

ADM_APPL_DATA
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application Data
  ADM_UPDATED_BY - Last Updated By Char30   Updated By

ADM_APPL_DATA
  ADM_UPDATED_DT - Last Updated On Date   Updated On

ADM_APPL_DATA
  APPL_FEE_TYPE - Application Fee Type Char3 N Fee Type

 ADM_APPL_DATA
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application Data
Key APPL_PROG_NBR - Application Program Nbr Num3.0   Prog Nbr

ADM_APPL_PROG
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application Program Data
  BIRTHDATE - Date of Birth Date   Birthdate

PERSONAL_DATA
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Biographical Details
  BIRTHPLACE - Birth Location Char30   Birthplace PERSONAL_DATA
  BIRTHSTATE - Birth State Char6   State PERSONAL_DATA
  BIRTH_COUNTY - Birth County Char5   Birth County PERSONAL_DATA
  CAMPUS - Campus Char5   Campus ADM_APPL_PROG
  CITIZENSHIP_STATUS - Citizenship Status Char1   Status  
  CITY - City Char30   City PERSONAL_DATA
  COUNTRY - Country Char3   Country PERSONAL_DATA
  COUNTY - County Char30   County PERSONAL_DATA
  DATA_SOURCE - Data Source Char2 N Data source  
Key DATE1 - Date 1 Date   Date 1  
  DEGREE - Degree Char8   Degree  
  DT_OF_DEATH - Date of Death Date   Death Date PERSONAL_DATA
  EFFECTIVE_TERM - Effective Term Char4   Effective  
Key EFFSEQ - Effective Sequence Num3.0   Sequence

 

 

ADM_APPL_PROG
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application Program Data
  EMAIL_ADDR - Email Address Char70   Email Main menu > Student Admissions > Application Maintenance > Maintain Applications , Biographical Details
Key EMPLID - Empl ID Char11   ID

PERSONAL_DATA
  ETHNIC_CATEGORY - Ethnic Category
(this field has no data)		 Char1 N Ethnic Cat  
  ETHNIC_GROUP - Ethnic Group Char1 N Ethnic Grp Main menu > Student Admissions > Application Maintenance > Maintain Applications , Regional
  ETHNIC_GRP_CD- Ethnic Group Char8   Ethnic Grp Main menu > Student Admissions > Application Maintenance > Maintain Applications , Regional
  EXP_GRAD_TERM - Expected Graduation Term Char4   Exp Grad

ADM_APPL_PROG
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application Program Data
  EXT_ORG_ID - External Org ID Char11   Org ID  
  FIN_AID_INTEREST - Financial Aid Interest Char1   Fin Aid

 

ADM_APPL_PROG 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application Data
  FIRST_NAME - First Name Char30   First Name PPERSONAL_DATA
  GRADUATION_DT - Graduation Date Date   Grad Dt

ADM_APPL_DATA 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application School/ Recruiting
  HISP_LATINO - Person is Hispanic or Latino (Y or N) Char1   Hisp or Latin  ADM_APPL_DATA 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Regional
  HOUSING_INTEREST - Housing Interest Char1 N Housing

ADM_APPL_DATA 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application Data
  INPUT_DT - Input Date Date   Input Dt  
Key INSTITUTION - Academic Institution Char5   Institution ADM_APPL_DATA
  LAST_NAME - Last Name Char30   Last PERSONAL_DATA
  LAST_SCH_ATTEND - Last School Attended  Char11   Lst School

ADM_APPL_DATA 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application School/ Recruiting
  MAR_STATUS - Marital Status Char1 N Mar Status

PERSONAL_DATA 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Biographical Details
  MAR_STATUS_DT - Marital Status Date Date   Mar StatDt

PERSONAL_DATA 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Biographical Details
  MIDDLE_NAME - Middle Name Char30   Middle PERSONAL_DATA
  NAME - Name Char50   Name PERSONAL_DATA
  PHONE - Telephone Char24   Phone ADM_APPL_DATA 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Biographical Details
  POSTAL - Postal Code Char12   Postal PERSONAL_DATA
  PROG_ACTION - Program Action Char4 N Prog Actn ADM_APPL_PROG 
  PROG_REASON - Action Reason Char4   Action Rsn ADM_APPL_PROG 
  PROG_STATUS - Academic Program Status Char4 N Status ADM_APPL_PROG 
  RECRUITER_ID - Recruiter ID Char11   Recruiter

ADM_APPL_DATA 
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Application School/ Recruiting
  REGION - Region Char10   Region ADM_APPL_DATA
Key REQ_TERM - Requirement Term Char4   Req Term

ADM_APPL_PROG
  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  
  SEX - Gender Char1 N Sex

PERSONAL_DATA
Main menu > Student Admissions > Application Maintenance > Maintain Applications , Biographical Details
  STATE- State Char6   State PERSONAL_DATA
  STATE2 - State Char6   St  
Key STDNT_CAR_NBR - Student Career Nbr Num3.0   Career Nbr  
  UM_ACAD_GRP_DESCR - Academic Group Descr Char30   Academic Group  
  UM_ACAD_PLAN_APPL - Academic Plan Applied For Char10   Acad Plan Appl  
  UM_ACAD_PLAN_DESCR - Academic Plan Description Char30   Acad Plan Descr  
  UM_ACAD_PROG_APPL - Academic Program Applied For Char5   Acad Plan Appli  
  UM_ACAD_SUBPLN_DSC - Academic Sub Plan Description Char30   Acad Sub Descr  
  UM_ADMIT_DATE - Admit Date Date   Admit Date  
  UM_ADMT_PROG1 - ADMT PROG! Char1 N ADMT PROG!  
  UM_ADMT_PROG2 - UM_ADMT_PROG2 Char1 N UM_ADMT_PROG2  
  UM_ADMT_PROG3 - UM_ADMT_PROG3 Char1 N UM_ADMT_PROG3  
  UM_ADMT_PROG4 - UM_ADMT_PROG4 Char1 N UM_ADMT_PROG4  
  UM_APPL_PROG1 - UM_APPL_PROG1 Char1 N UM_APPL_PROG1  
  UM_APPL_PROG2 - UM_APPL_PROG2 Char1 N UM_APPL_PROG2  
  UM_APPL_PROG3 - UM_APPL_PROG3 Char1 N UM_APPL_PROG3  
  UM_APPL_PROG4 - UM_APPL_PROG4 Char1 N UM_APPL_PROG4  
  UM_APP_DATE - Applied Date Date   Applied Date  
  UM_CITIZEN_STAT_OT - Citizenship Status Other Char1   Citizn Stat Oth  
  UM_CITY1 - City Char30   City  
  UM_CITY10 - City Char30   City  
  UM_CITY2 - City Char30   City  
  UM_CITY3 - City Char30   City  
  UM_CITY4 - City Char30   City  
  UM_CITY5 - City Char30   City  
  UM_CITY6 - City Char30   City  
  UM_CITY7 - City Char30   City  
  UM_CITY8 - City Char30   City  
  UM_CITY9 - City Char30   City  
  UM_CLASS_RANK1 - Class Rank Num5.0   Class Rank EXT_ACAD_SUM
  UM_CLASS_RANK10 - Class Rank Num5.0   Class Rank  
  UM_CLASS_RANK2 - Class Rank Num5.0   Class Rank  
  UM_CLASS_RANK3 - Class Rank Num5.0   Class Rank  
  UM_CLASS_RANK4 - Class Rank Num5.0   Class Rank  
  UM_CLASS_RANK5 - Class Rank Num5.0   Class Rank  
  UM_CLASS_RANK6 - Class Rank Num5.0   Class Rank  
  UM_CLASS_RANK7 - Class Rank Num5.0   Class Rank  
  UM_CLASS_RANK8 - Class Rank Num5.0   Class Rank  
  UM_CLASS_RANK9 - Class Rank Num5.0   Class Rank  
  UM_CLASS_SIZE1 - Class Size Num5.0   Class Size EXT_ACAD_SUM
  UM_CLASS_SIZE10 - Class Size Num5.0   Class Size  
  UM_CLASS_SIZE2 - Class Size Num5.0   Class Size  
  UM_CLASS_SIZE3 - Class Size Num5.0   Class Size  
  UM_CLASS_SIZE4 - Class Size Num5.0   Class Size  
  UM_CLASS_SIZE5 - Class Size Num5.0   Class Size  
  UM_CLASS_SIZE6 - Class Size Num5.0   Class Size  
  UM_CLASS_SIZE7 - Class Size Num5.0   Class Size  
  UM_CLASS_SIZE8 - Class Size Num5.0   Class Size  
  UM_CLASS_SIZE9 - Class Size Num5.0   Class Size  
  UM_COMPLETE_DATE - Complete Date Date   Complete Date  
  UM_COND_PROG1 - UM_COND_PROG1 Char1 N UM_COND_PROG1  
  UM_COND_PROG2 - UM_COND_PROG2 Char1 N UM_COND_PROG2  
  UM_COND_PROG3 - UM_COND_PROG3 Char1 N UM_COND_PROG3  
  UM_COND_PROG4 - UM_COND_PROG4 Char1 N UM_COND_PROG4  
  UM_CONVERT_GPA1 - Converted GPA Num4.3   Conv GPA EXT_ACAD_SUM
  UM_CONVERT_GPA10 - Converted GPA Num4.3   Conv GPA  
  UM_CONVERT_GPA2 - Converted GPA Num4.3   Conv GPA  
  UM_CONVERT_GPA3 - Converted GPA Num4.3   Conv GPA  
  UM_CONVERT_GPA4 - Converted GPA Num4.3   Conv GPA  
  UM_CONVERT_GPA5 - Converted GPA Num4.3   Conv GPA  
  UM_CONVERT_GPA6 - Converted GPA Num4.3   Conv GPA  
  UM_CONVERT_GPA7 - Converted GPA Num4.3   Conv GPA  
  UM_CONVERT_GPA8 - Converted GPA Num4.3   Conv GPA  
  UM_CONVERT_GPA9 - Converted GPA Num4.3   Conv GPA  
  UM_COUNTRY1 - Country Char3   Cntry  
  UM_COUNTRY10 - Country Char3   Cntry  
  UM_COUNTRY2 - Country Char3   Cntry  
  UM_COUNTRY3 - Country Char3   Cntry  
  UM_COUNTRY4 - Country Char3   Cntry  
  UM_COUNTRY5 - Country Char3   Cntry  
  UM_COUNTRY6 - Country Char3   Cntry  
  UM_COUNTRY7 - Country Char3   Cntry  
  UM_COUNTRY8 - Country Char3   Cntry  
  UM_COUNTRY9 - Country Char3   Cntry  
  UM_COUNTRY_OTH - Country Other Char3   Country Oth  
  UM_COUNTRY_USA - Country is USA Char3   Country USA  
  UM_DEFER_DATE - Defer Date Date   Defer Date  
  UM_DEIN_DATE - Prematriculation Date Date   Premat Date  
  UM_DEIN_PROG1 - UM_DEIN_PROG1 Char1 N UM_DEIN_PROG1  
  UM_DEIN_PROG2 - UM_DEIN_PROG2 Char1 N UM_DEIN_PROG2  
  UM_DEIN_PROG3 - UM_DEIN_PROG3 Char1 N UM_DEIN_PROG3  
  UM_DEIN_PROG4 - UM_DEIN_PROG4 Char1 N UM_DEIN_PROG4  
  UM_DENY_DATE - Deny Date Date   Deny Date  
  UM_DENY_PROG1 - UM_DENY_PROG1 Char1 N UM_DENY_PROG1  
  UM_DENY_PROG2 - UM_DENY_PROG2 Char1 N UM_DENY_PROG2  
  UM_DENY_PROG3 - UM_DENY_PROG3 Char1 N UM_DENY_PROG3  
  UM_DENY_PROG4 - UM_DENY_PROG4 Char1 N UM_DENY_PROG4  
  UM_DISCONTINUE_DT - Discontinue Date Date   Disc Date  
  UM_EMAIL_HOM_ADDR - Email Home Address Char70   Email Home Addr  
  UM_ENROLL_DATE - Enroll Date Date   Enroll Date FULLY_ENRL_DT field in the STDNT_CAR_TERM table
  UM_ETHNIC_DESCR - Ethnic Description Char50   Ethic Descr  
  UM_ETH_GRP_DESCR- Ethnic Group Descr Char30   Eth Grp Descr  
  UM_EXT_ACADLEVEL1 - External Academic Level Char4   Acad Level EXT_ACAD_SUM
  UM_EXT_ACADLEVEL10 - External Academic Level Char4   Acad Level  
  UM_EXT_ACADLEVEL2 - External Academic Level Char4   Acad Level  
  UM_EXT_ACADLEVEL3 - External Academic Level Char4   Acad Level  
  UM_EXT_ACADLEVEL4 - External Academic Level Char4   Acad Level  
  UM_EXT_ACADLEVEL5 - External Academic Level Char4   Acad Level  
  UM_EXT_ACADLEVEL6 - External Academic Level Char4   Acad Level  
  UM_EXT_ACADLEVEL7 - External Academic Level Char4   Acad Level  
  UM_EXT_ACADLEVEL8 - External Academic Level Char4   Acad Level  
  UM_EXT_ACADLEVEL9 - External Academic Level Char4   Acad Level  
  UM_EXT_CAREER1 - External Career Char4   Career here

Descriptions for UM_EXT_CAREER fields can be found in the PSXLATITEM table with Fieldname = 'EXT_CAREER'.
Navigate to the screen in PeopleSoft by Main menu > Student Admissions > Application Maintenance > Maintain Applications > Education

CODE - VALUE
AGRD - Graduate (Augusta)        
 AHS - High School (Augusta)        
AUGD - Undergraduate (Augusta)        
FGRD - Graduate (Farmington)        
 FHS - High School (Farmington)        
FUGD - Undergraduate (Farmington)        
GRAD - Graduate        
  HS - High School        
IGRD - Graduate (Presque Isle)        
IHS - High School (Presque Isle)        
IUGD - Undergraduate (Presque Isle)        
KGRD - Graduate (Fort Kent)        
 KHS - High School (Fort Kent)        
KUGD - Undergraduate (Fort Kent)        
 LAW - Law        
LGRD - Graduate (Law)        
 LHS - High School (Law)        
LUGD - Undergraduate (Law)        
 MED - Medical        
MGRD - Graduate (Machias)        
 MHS - High School (Machias)        
MLAW - Medical (Law)        
MUGD - Undergraduate (Machias)        
OGRD - Graduate (UM)        
 OHS - High School (UM)        
OUGD - Undergraduate (UM)        
PGRD - Graduate (USM)        
 PHS - High School (USM)        
PUGD - Undergraduate (USM)        
QGRD - Graduate (UM Grad)        
 QHS - High School (UM Grad)        
QMED - Medical (UM Grad)        
QUGD - Undergraduate (UM Grad)        
UGRD - Undergraduate        
XGRD - Graduate (USM Grad)        
 XHS - High School (USM Grad        
XMED - Medical (USM Grad)        
XUGD - Undergraduate (USM Grad)
  UM_EXT_CAREER10 - External Career Char4   Career  
  UM_EXT_CAREER2 - External Career Char4   Career  
  UM_EXT_CAREER3 - External Career Char4   Career  
  UM_EXT_CAREER4 - External Career Char4   Career  
  UM_EXT_CAREER5 - External Career Char4   Career  
  UM_EXT_CAREER6 - External Career Char4   Career  
  UM_EXT_CAREER7 - External Career Char4   Career  
  UM_EXT_CAREER8 - External Career Char4   Career  
  UM_EXT_CAREER9 - External Career Char4   Career  
  UM_EXT_GPA1 - External GPA Num4.3   Ext GPA EXT_ACAD_SUM
  UM_EXT_GPA10 - External GPA Num4.3   Ext GPA  
  UM_EXT_GPA2 - External GPA Num4.3   Ext GPA  
  UM_EXT_GPA3 - External GPA Num4.3   Ext GPA  
  UM_EXT_GPA4 - External GPA Num4.3   Ext GPA  
  UM_EXT_GPA5 - External GPA Num4.3   Ext GPA  
  UM_EXT_GPA6 - External GPA Num4.3   Ext GPA  
  UM_EXT_GPA7 - External GPA Num4.3   Ext GPA  
  UM_EXT_GPA8 - External GPA Num4.3   Ext GPA  
  UM_EXT_GPA9 - External GPA Num4.3   Ext GPA  
  UM_EXT_ORGID_DESCR - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSC10 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSCR1 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSCR2 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSCR3 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSCR4 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSCR5 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSCR6 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSCR7 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSCR8 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORGID_DSCR9 - External Org ID Description Char30   Ext Org ID Desc  
  UM_EXT_ORG_ID1 - External Org ID Char11   Org ID  
  UM_EXT_ORG_ID10 - External Org ID Char11   Org ID  
  UM_EXT_ORG_ID2 - External Org ID Char11   Org ID  
  UM_EXT_ORG_ID3 - External Org ID Char11   Org ID  
  UM_EXT_ORG_ID4 - External Org ID Char11   Org ID  
  UM_EXT_ORG_ID5 - External Org ID Char11   Org ID  
  UM_EXT_ORG_ID6 - External Org ID Char11   Org ID  
  UM_EXT_ORG_ID7 - External Org ID Char11   Org ID  
  UM_EXT_ORG_ID8 - External Org ID Char11   Org ID  
  UM_EXT_ORG_ID9 - External Org ID Char11   Org ID  
  UM_EXT_SUMM_TYPE1 - Summary Type Char4   Sum Type EXT_ACAD_SUM
  UM_EXT_SUMM_TYPE10 - Summary Type Char4   Sum Type  
  UM_EXT_SUMM_TYPE2 - Summary Type Char4   Sum Type  
  UM_EXT_SUMM_TYPE3 - Summary Type Char4   Sum Type  
  UM_EXT_SUMM_TYPE4 - Summary Type Char4   Sum Type  
  UM_EXT_SUMM_TYPE5 - Summary Type Char4   Sum Type  
  UM_EXT_SUMM_TYPE6 - Summary Type Char4   Sum Type  
  UM_EXT_SUMM_TYPE7 - Summary Type Char4   Sum Type  
  UM_EXT_SUMM_TYPE8 - Summary Type Char4   Sum Type  
  UM_EXT_SUMM_TYPE9 - Summary Type Char4   Sum Type  
  UM_FROM_DT1 - From Date Date   From  
  UM_FROM_DT10 - From Date Date   From  
  UM_FROM_DT2 - From Date Date   From  
  UM_FROM_DT3 - From Date Date   From  
  UM_FROM_DT4 - From Date Date   From  
  UM_FROM_DT5 - From Date Date   From  
  UM_FROM_DT6 - From Date Date   From  
  UM_FROM_DT7 - From Date Date   From  
  UM_FROM_DT8 - From Date Date   From  
  UM_FROM_DT9 - From Date Date   From  
  UM_FST_PROG_ACTION - FIirst Program Action Char4   First Prog Acti  
  UM_GPA_TYPE1 - GPA Type Char4   GPA Type EXT_ACAD_SUM
  UM_GPA_TYPE10 - GPA Type Char4   GPA Type  
  UM_GPA_TYPE2 - GPA Type Char4   GPA Type  
  UM_GPA_TYPE3 - GPA Type Char4   GPA Type  
  UM_GPA_TYPE4 - GPA Type Char4   GPA Type  
  UM_GPA_TYPE5 - GPA Type Char4   GPA Type  
  UM_GPA_TYPE6 - GPA Type Char4   GPA Type  
  UM_GPA_TYPE7 - GPA Type Char4   GPA Type  
  UM_GPA_TYPE8 - GPA Type Char4   GPA Type  
  UM_GPA_TYPE9 - GPA Type Char4   GPA Type  
  UM_GROSSCONFIRM_DT - Gross Confirm Date Date   Gross Confrm Dt  
  UM_LAST_SCH_DESCR - Last School Attend Description Char30   Lst School Desc  
  UM_LAST_SCH_TYPE - Last School Attended Type Char3   Last School Typ

from the  LAST_SCH_ATTEND - Last School Attended field in the ADM_APPL_DATA - Admission Application Data table
  UM_LST_PROG_ACTION - Last Program Action Char4   Last Prog Actio  
  UM_LS_SCHOOL_TYP1 - School Type Char3   School Type Descriptions for UM_LS_SCHOOL_TYPE fields can be found in the LS_SCHL_TYP_TBL table.
Navigate to the screen in PeopleSoft by following Main menu > Student Admissions > Application Maintenance > Maintain Applications
  UM_LS_SCHOOL_TYP10 - School Type Char3   School Type  
  UM_LS_SCHOOL_TYP2 - School Type Char3   School Type  
  UM_LS_SCHOOL_TYP3 - School Type Char3   School Type  
  UM_LS_SCHOOL_TYP4 - School Type Char3   School Type  
  UM_LS_SCHOOL_TYP5 - School Type Char3   School Type  
  UM_LS_SCHOOL_TYP6 - School Type Char3   School Type  
  UM_LS_SCHOOL_TYP7 - School Type Char3   School Type  
  UM_LS_SCHOOL_TYP8 - School Type Char3   School Type  
  UM_LS_SCHOOL_TYP9 - School Type Char3   School Type  
  UM_MATRIC_DATE - Matriculation Date Date   Matric Date  
  UM_MAX_ACT_COMP - Maximum ACT Comp Num5.2   Max ACT Comp  
  UM_MAX_ACT_ENGL - Maximum ACT English Num5.2   Max ACT English  
  UM_MAX_ACT_MATH - Maximum ACT Math Num5.2   Max ACT Math  
  UM_MAX_ACT_READ - Maximum ACT Read Num5.2   Max ACT Read  
  UM_MAX_GMAT_ANALY - Max GMAT ANALY Score Num7.0   Max GMAT ANALY  
  UM_MAX_GMAT_ANALYW - Max GMAT ANALYW Score Num7.0   Max GMAT ANALYW  
  UM_MAX_GMAT_QUAN - Max GMAT QUAN Score Num7.0   Max GMAT QUAN  
  UM_MAX_GMAT_VERB - Max GMAT VERB Score Num7.0   Max GMAT VERB  
  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_MAT_WAC - Max MAT WAC Scoree Num7.0   Max MAT WAC  
  UM_MAX_MAT_WAP - Max MAT WAP Score Num7.0   Max MAT WAP  
  UM_MAX_SAT_ERWS - Max SAT ERWS Num5.2   Max SAT ERWS  
  UM_MAX_SAT_MATH - Maximum Sat Math Num5.2   Max Sat Math  
  UM_MAX_SAT_MSS - Max SAT MSS Num5.2   Max SAT MSS  
  UM_MAX_SAT_VERB - Maximum Sat Verbal Num5.2   Max Sat Verbal  
  UM_MAX_SAT_WRIT - Maximum SAT Write Num5.2   Max SAT Write  
  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_NETCONFIRM_DATE - Net Confirmed Date Date   Net Confirm Dt  
  UM_NID_CAN - National ID Canada Char20   NID Canada  
  UM_NID_USA - National Id USA Char20   NID USA  
  UM_NL_INDEX - Noel-Levitz Academic Index Num3.0   NL Acad Index  
  UM_NODECISION_DATE - No Decision Date Date   No Decision Dt  
  UM_NOSHOW_DATE - No Show Date Date   No Show Date  
  UM_PERCENTILE1 - Percentile Num3.0   Percentile EXT_ACAD_SUM
  UM_PERCENTILE10 - Percentile Num3.0   Percentile  
  UM_PERCENTILE2 - Percentile Num3.0   Percentile  
  UM_PERCENTILE3 - Percentile Num3.0   Percentile  
  UM_PERCENTILE4 - Percentile Num3.0   Percentile  
  UM_PERCENTILE5 - Percentile Num3.0   Percentile  
  UM_PERCENTILE6 - Percentile Num3.0   Percentile  
  UM_PERCENTILE7 - Percentile Num3.0   Percentile  
  UM_PERCENTILE8 - Percentile Num3.0   Percentile  
  UM_PERCENTILE9 - Percentile Num3.0   Percentile  
  UM_PREVIOUS_NAME - Previous Name Char50   Prev Name  
  UM_PROG_DT - Admit Program Action Date Date   Admit Prog Date  
  UM_PROG_RSN_DESCR - Program Reason Description Char30   Prog Rsn De scr  
  UM_RANK_TYPE1 - Rank Type Char3   Rank Type EXT_ACAD_SUM
  UM_RANK_TYPE10 - Rank Type Char3   Rank Type  
  UM_RANK_TYPE2 - Rank Type Char3   Rank Type  
  UM_RANK_TYPE3 - Rank Type Char3   Rank Type  
  UM_RANK_TYPE4 - Rank Type Char3   Rank Type  
  UM_RANK_TYPE5 - Rank Type Char3   Rank Type  
  UM_RANK_TYPE6 - Rank Type Char3   Rank Type  
  UM_RANK_TYPE7 - Rank Type Char3   Rank Type  
  UM_RANK_TYPE8 - Rank Type Char3   Rank Type  
  UM_RANK_TYPE9 - Rank Type Char3   Rank Type  
  UM_RECN_PROG1 - UM_RECN_PROG1 Char1 N UM_RECN_PROG1  
  UM_RECN_PROG2 - UM_RECN_PROG2 Char1 N UM_RECN_PROG2  
  UM_RECN_PROG3 - UM_RECN_PROG3 Char1 N UM_RECN_PROG3  
  UM_RECN_PROG4 - UM_RECN_PROG4 Char1 N UM_RECN_PROG4  
  UM_RSP_REASN_DESCR - Response Reason Descriptions Char30   Resp Reason Des  
  UM_STATE1 - State Char6   St  
  UM_STATE10 - State Char6   St  
  UM_STATE3 - State Char6   St  
  UM_STATE4 - State Char6   St  
  UM_STATE5 - State Char6   St  
  UM_STATE6 - State Char6   St  
  UM_STATE7 - State Char6   St  
  UM_STATE8 - State Char6   St  
  UM_STATE9 - State Char6   St  
  UM_TO_DT1 - To Date Date   To  
  UM_TO_DT10 - To Date Date   To  
  UM_TO_DT2 - To Date Date   To  
  UM_TO_DT3 - To Date Date   To  
  UM_TO_DT4 - To Date Date   To  
  UM_TO_DT5 - To Date Date   To  
  UM_TO_DT6 - To Date Date   To  
  UM_TO_DT7 - To Date Date   To  
  UM_TO_DT8 - To Date Date   To  
  UM_TO_DT9 - To Date Date   To  
  UM_WADMADMIT_DATE - Admitted and Withdrawn Date Date   Admit&WD Date  
  UM_WADMINC_DATE - Incomplete Adm withdraw date Date   WADMINC Date  
  UM_WADMTOT_DATE - Total Admin Withdraw Date Date   WADMTOTDATE  
  UM_WADM_PROG1 - UM_WADM_PROG1 Char1 N UM_WADM_PROG1  
  UM_WADM_PROG2 - UM_WADM_PROG2 Char1 N UM_WADM_PROG2  
  UM_WADM_PROG3 - UM_WADM_PROG3 Char1 N UM_WADM_PROG3  
  UM_WADM_PROG4 - UM_WADM_PROG4 Char1 N UM_WADM_PROG4  
  UM_WAIT_DATE - Waitlist Date Date   Waitlist Date  
  UM_WAPPDEF_DATE - Applicant Withdraw Deferral Date   Applicant Wd Df  
  UM_WAPPDEF_PLAN - Withdrawal Deferral Plan Char10   Wappdef Plan  
  UM_WAPPDEF_PRGREAS - Withdrawal Deferral Prog Reasn Char4   Wappdef PrgReas  
  UM_WAPPDEF_PRGSTAT - Withdrawal Defrl Prog_Status Char4   Wappdef PrgStat  
  UM_WAPPDEF_PROGACT - Withdrawal Defr Program Action Char4   Wappdef ProgAct  
  UM_WAPPDEF_SUBPLAN - Withdrawal Deferral SubPlan Char10   Wappdef SubPlan  
  UM_WAPPDEF_TERM - Term of Deferral Char4   Term of Deferra  
  UM_WAPPINC_DATE - Incomplete App Withdrawal Date   WAPPINCDATE  
  UM_WAPPTOTAL_DATE - Total Applicant Withdraw Date Date   Tot App WD Date  
  UM_WAPP_PROG1 - UM_WAPP_PROG1 Char1 N UM_WAPP_PROG1  
  UM_WAPP_PROG2 - UM_WAPP_PROG2 Char1 N UM_WAPP_PROG2  
  UM_WAPP_PROG3 - UM_WAPP_PROG3 Char1 N UM_WAPP_PROG3  
  UM_WAPP_PROG4 - UM_WAPP_PROG4 Char1 N UM_WAPP_PROG4
 

Back to Top

Details

Details

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

Related Articles

Related Articles (1)

UM_APPL_EXT_VW - Applicant Reporting Extract

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_APPL_EXTRACT SQR Build Code.txt Computer

Fri 8/23/24 12:12 PM
View
;