| 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 |
|
| |
- 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_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 |
|