Created by Corina C Larsen, last modified by Cori Schneider on Sep 24, 2019
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.
Key | Record.Fieldname | Format | XLAT | Heading Text |
---|---|---|---|---|
ACADEMIC_LEVEL - Academic Level | Char3 | N | Acad Level | |
→ | 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 | |
→ | 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 | ||
→ | 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 | ||
→ | 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 |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.