ADM_APPL_DATA - Admission Application Data

 

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

This Table includes Student Admissions Applications detail

Detailed Information

Most of what is in this table comes from the admissions application and is entered at the Shared Processing Center. It does not typically change throughout the admissions process.
Typical changes are generally data entry errors or an admit type changes due to new information.

UMS Data Cookbook Links

Clicking the linked (blue) fields in any table will take you to the UMS Data Cookbook and provide you with more information about that field as well as field values if they are available.

Databases

PeopleSoft Campus Solutions CSPRD and Campus Solutions Reporting CSRPT

Key Fields  Record.Fieldname  Format  XLAT  Heading Text
   ACADEMIC_LEVEL - Academic Level   Char3   N   Acad Level 
 Key   ACAD_CAREER - Academic Career   Char4     Career 
   ADMIT_TYPE - Admit Type   Char3     Admit Type 
   ADM_APPL_CMPLT_DT - Completed Date   Date     Date 
   ADM_APPL_COMPLETE - Application Complete   Char1     Complete 
   ADM_APPL_CTR - Application Center   Char4     Appl Ctr 
   ADM_APPL_DT - Application Date   Date     Appl Dt 
   ADM_APPL_METHOD - Application Method   Char3   N   Appl Meth 
 Key   ADM_APPL_NBR - Application Nbr   Char8     Appl Nbr 
   ADM_CREATION_BY - Admission Data Created By   Char30     Created By 
   ADM_CREATION_DT- Admission Data Creation Date   Date     Created On 
   ADM_UPDATED_BY - Last Updated By   Char30     Updated By 
   ADM_UPDATED_DT - Last Updated On   Date     Updated On 
   APPL_FEE_AMT - Application Fee Amount   SNm16.2     Fee Amount 
   APPL_FEE_DT - Application Fee Date   Date     Date 
   APPL_FEE_PAID - Application Fee Paid   SNm16.2     Fee Paid 
   APPL_FEE_STATUS - Application Fee Status   Char3   N   Status 
   APPL_FEE_TYPE - Application Fee Type   Char3   N   Fee Type 
   APP_FEE_CALC_DTTM - Application Fee Calc DateTime   DateTm     Fee Calc DtTm 
   APP_FEE_STATUS - Application Fee Status   Char1   N   App Fee Status 
   CREDIT_CARD_AUTHCD - Credit Card Authorization Code   Char6     CC Auth Code 
   CREDIT_CARD_DECLND - Credit Card Declined   Char1     CC Declined 
   CREDIT_CARD_ERRMSG - Credit Card Error Message   Char30     CC Error Msg 
   CREDIT_CARD_EXP_DT - Expiration Date   Date     Expir Date 
   CREDIT_CARD_HOLDER - Credit Card Holder   Char30     Holder 
   CREDIT_CARD_ISSUER - Credit Card Issuer   Char20     Issuer 
   CREDIT_CARD_NBR - Card Number   Char44     Card # 
   CREDIT_CARD_STATUS - Credit Card Processing Status   Char2   N   CC Proc Status 
   CREDIT_CARD_TYPE - Credit Card Type   Char2     Card Type 
   CREDIT_CARD_VDAUTH - Credit Card Void Auth Code   Char6     CC Void Auth Cd 
   CURRENCY_CD - Currency Code   Char3     Currency 
   CUR_RT_TYPE - Exchange Rate Type   Char5     Rate Type 
 Key   EMPLID - Empl ID   Char11     ID 
   EXT_ADM_APPL_NBR - External Application Nbr   Char15     Ext Appl 
   FIN_AID_INTEREST - Financial Aid Interest   Char1     Fin Aid 
   GRADUATION_DT - Graduation Date   Date     Grad Dt 
   HOUSING_INTEREST - Housing Interest   Char1   N   Housing 
   INSTITUTION - Academic Institution   Char5     Institution 
   LAST_SCH_ATTEND - Last School Attended   Char11     Lst School 
   NOTIFICATION_PLAN - Notification Plan   Char4   N   Notificatn 
   ORIGNL_APPL_FEE_PD - Application Fee Paid   SNm16.2     Fee Paid 
   ORIGNL_CURRENCY_CD - Currency Code   Char3     Currency 
   OVERRIDE_DEPOSIT - Override Deposit   Char1     Override 
   PRIOR_APPL - Prior Application   Char1     Prior Appl 
   RATE_DIV - Rate Divisor   Num8.8     Divisor 
   RATE_MULT - Rate Multiplier   SNm9.8     Multiplier 
   RECRUITER_ID - Recruiter ID   Char11     Recruiter 
   REGION - Region   Char10     Region 
   REGION_FROM - Region from   Char1   N   From 
   SAD_CONVICTION - Criminal Conviction   Char1     Convicted 
   SAD_ELEC_SIGN - Electronic Signature   Char1     eSign 
   SAD_ERLY_GRAD - Graduated early?   Char1     Early Grad.? 
   SAD_NOTIN_SCH - Not Currently Attending School   Char1     Not Attd School 
   SAD_PREV_ATD - Previous Attendance   Char1     Prev Attendance 
   SAD_PREV_EDT - To Date   Date     To Date 
   SAD_PREV_FDT - From Date   Date     From Date 
   SAD_WAIVER_BASIS - Waiver Basis Code   Char6     Waiver Code 
   SCC_ROW_ADD_DTTM - Created   DateTm     Created 
   SCC_ROW_ADD_OPRID - Created By   Char30     Created By 
   SCC_ROW_UPD_DTTM - Last Update Date/Time   DateTm     Updated 
   SCC_ROW_UPD_OPRID - Updated By   Char30     By 
   SSF_GL_SENT_AMT - Amount Sent to GL   SNm17.3     GL Sent Amt 
   SSF_IHC_PB - Intl Student Health Coverage   Char1     IHC 
 Key   STDNT_CAR_NBR - Student Career Nbr   Num3.0     Career Nbr 
   TENDER_CATEGORY - Tender Category   Char3   N   Category 
   WAIVE_AMT - Waive Amount   SNm16.2     Waive Amt 

Environment

PeopleSoft Campus Solutions

Submit an Inquiry or Request to DARTS Print Article

Details

Article ID: 158807
Created
Fri 5/10/24 4:26 AM
Modified
Wed 7/31/24 10:48 AM
Applies To
Students
Faculty
Staff
Community

Related Services / Offerings (1)

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