EIS Admissions Mart CUBE Documentation - Admissions Mart.
- Michael Harvey (Deactivated)
Owned by Michael Harvey (Deactivated)
Mar 13, 2019
6 min read
Loading data...
Dimensions.
| Cube Name | Dimension Unique Name | Description |
|---|---|---|
| AdmissionsMart | Admissions Deposit Indicator | This indicates whether the admissions deposit requirement has been fulfilled. Valid values are not paid, paid, waived or not assessed. It is only required of freshmen. BANNER Logic: CASE WHEN SARADAP_STYP_CODE<>'B' THEN 'Not Assessed' WHEN C0.SARCHKL_RECEIVE_DATE IS NOT NULL THEN 'Deposit Paid' WHEN C1.SARCHKL_ADMR_CODE='DNON' THEN 'Not Assessed' WHEN C2.SARCHKL_ADMR_CODE='DREF' THEN 'Deposit Refunded' WHEN C3.SARCHKL_ADMR_CODE='DWAV' THEN 'Deposit Waived' WHEN C0.SARCHKL_RECEIVE_DATE IS NULL THEN 'Deposit Not Paid' ELSE 'Not Assessed' END AS "DEPOSIT" |
| AdmissionsMart | Applicant Admit Type | Identifies the applicant admit type (values: Values: Freshmen, Transfer, Masters, PhD Professional, or PhD Research) BANNER Field: SARADAP_STYP_CODE |
| AdmissionsMart | Applicant Level | Identifies the applicant level associated with the applicant level code. Valid values are Undergraduate and Graduate. |
| AdmissionsMart | Applicant Level Hierarchy | |
| AdmissionsMart | Applicant Transfer Source | Identifies the applicant transfer source; indicates whether student is transfering in from a institution withing the Florida College System or other two/four year institution(Values: FCS or Other) BANNER Field: SARADAP_ADMT_CODE |
| AdmissionsMart | Applicant Transfer Type | Identifies the applicant transfer type (Values: Lower level, Upper level, or FSR - FormerStudentReturning) |
| AdmissionsMart | Applicant Type Hierarchy | |
| AdmissionsMart | Citizenship Status | Citizenship Status |
| AdmissionsMart | Gender | Gender |
| AdmissionsMart | Race Ethnicity | Race - Ethnicity |
| AdmissionsMart | Applicant Nation | Nationality of Applicant |
| AdmissionsMart | Orientation Registered Flag | Identifies whether or not the admitted student has fulfilled the mandatory orientation requirement. Flag indicates whether the registered or not, and whether the student attended or not. BANNER field: SGBSTDN_ORSN_CODE . Note: This data is not used for the graduate admissions process. |
| AdmissionsMart | Flag In State | Identifies in-state students |
| AdmissionsMart | Flag Out Of State | Identifies out of state students |
| AdmissionsMart | Residency | The description of the residency code for the applicant. Values include - Florida Resident;Res Alien, Fl Res (Non USA);Non-Resident Alien (Non USA);Non-Florida Resident (USA);Res Alien, Non-Fl Res(Non USA);Undeclared;Florida Resident - Spec Cat;Florida Resident (Pending) |
| AdmissionsMart | Academic Success Factor | Number of Academic Success Factors asocciated with an freshman application. Based on an evaluation of the applicant's transcript and test scores, valid values are 0-7 or E (Exempt). Students with international transcripts, GED's or who are home-schooled are exempt. ASF's are predictors of a student's success at the post-secondary level. For the 2011-12 academic year, ASF points are awarded for the following: (a) AP, IB or AICE Coursework (3 or more courses)* (b) One or more math courses at the Pre-Calculus, Calculus, or higher math level. See list of specific math courses (c) Additional natural science course(s) (with lab)* (d) Additional foreign language course(s)* (e) An SAT Writing score of at least 550 or ACT English/Writing score of at least 24 (f) College level dual enrollment coursework (2 or more courses) (g) A postsecondary GPA of 3.0 or higher in dual enrollment coursework attempted *NOTE: All grades earned for advanced or additional coursework must be C or higher to earn the Academic Success Factor |
| AdmissionsMart | Application Seq NBR | Identifies the application number of the admissions record for a specific term. |
| AdmissionsMart | Highest Degree Institution | Post-secondary institution from which the applicant earned highest degree prior to applying and/or admission to USF. |
| AdmissionsMart | Last Institution Attended | Refers to the most recent post-secondary institution attended by a transfer applicant |
| AdmissionsMart | StudentID PIDM | OASIS PIDM identifier |
| AdmissionsMart | StudentID U-Number | UID of applicant |
| AdmissionsMart | CIP Code | CIP code associated with program |
| AdmissionsMart | College | Program College |
| AdmissionsMart | College-Major-Conc Hierarchy | |
| AdmissionsMart | Concentration | Program concentration |
| AdmissionsMart | Concentration Code | Program concentration code |
| AdmissionsMart | Degree Code | This is the base curriculum degree code. |
| AdmissionsMart | Major | Specifies the major area of study associated with the major code. |
| AdmissionsMart | Major Code | Specifies the major area of study associated with the major code. |
| AdmissionsMart | Campus of Application | Unique campus name, for cross system use |
| AdmissionsMart | County of Admission | Identifies the county at time of admission |
| AdmissionsMart | Measures | |
| AdmissionsMart | State Descr | Identifies the state at time of admission |
| AdmissionsMart | Academic Year Sort | |
| AdmissionsMart | Flag Spring | Identifies spring terms. |
| AdmissionsMart | Flag Summer | Identifies summer terms. |
| AdmissionsMart | Term Academic Year Hierarchy | Identifies fall terms |
| AdmissionsMart | Term Title | Term Title of record. |
| AdmissionsMart | Year Academic | Academic year as identified by Summer + Fall + Spring. |
| AdmissionsMart | Week Of Term | Identifies the week of the term associated with the data snapshot. |
FACTS/MEASURES.
| Cube Name | Measure Name | Measure Description | Expression |
|---|---|---|---|
| AdmissionsMart | Total Pre Decision | Application does not carry a significant decision, meaning it has not been given a decision of admitted, cancelled, or denied | |
| AdmissionsMart | Decision Ready | An application is decision ready if all of the following conditions are met (Graduate only; for all campuses):1. No significant admissions action has been taken (admitted, cancelled, or denied) 2. Conduct record with a C or N code 3. Application status code = 'C' An application is decision ready if all of the following conditions are met (Undergraduate only; Tampa campus only):1. No significant admissions action has been taken (admitted, cancelled, or denied) 2. Conduct record with a C or N code 3. All CTR checklist rows for mandatory items have a receive date or a CTR checklist row with a null receive date has a matching SOAPCOL record with a non-null receive date 4. FEE checklist row has a receive date or (FNON or FWAV) row for same application 5. HSTP checklist row has a receive date 6. Test score checklist row(s) has a receive date | |
| AdmissionsMart | Wait Listed | Identifies that an application is "waitlisted" and no decision has been made. Used on in conjunction with freshman applications. SARAPPD_APDC_CODE=RW and SARADAP_APST_CODE=L. Note: Waitlisted is not used in the graduate admissions process | |
| AdmissionsMart | Deferred | Identifies that an application is "deferred" and no final decision has been made. Applications are placed in a deferred status until student submits additional academic information (test scores, grades) for evaluation. SARAPPD_APDC_CODE=RR . Identifies that an application is "deferred" and no final decision has been made. Applications are placed in a deferred status until student submits additional academic information (test scores, grades) for evaluation. SARAPPD_APDC_CODE=RR Identifies that an application is "deferred" and no final decision has been made. Applications are placed in a deferred status until student submits additional academic information (test scores, grades) for evaluation. SARAPPD_APDC_CODE=RR Note: This data is only is used at the undergraduate level. | |
| AdmissionsMart | Referred | For Graduates - Identifies that an application is "referred" and no decision has been made. Referred decision codes SARAPPD_APDC_CODE ="RG, RP, RO, RN, RX, RE" (D002291) ; For Undergraduates - Identifies that an application is "referred" and no decision has been made. Application is pending review by another university unit or entity. SARAPPD_APDC_CODE LIKE R% BUT NOT EQUAL TO RM or RR | |
| AdmissionsMart | Application Incomplete | If no significant admissions action has been taken (Admitted [D002281], Cancelled [D002280], or Denied [D002279]), and the application is not Decision Ready [D002273], Waitlisted [D002274], Deferred [D002275], or Referred [D002276], it is considered incomplete. | |
| AdmissionsMart | Total Post Decision | Application carries a significant decision (admitted, cancelled, denied). | |
| AdmissionsMart | Total Admitted | For Graduates - Identifies that a decision of "Admitted" was made on an application, which includes applications admitted on an exception and those cancelled after admission. SARAPPDAPDC_CODE = CA OR "GD" (same as D002291) OR SARAPPD_APDC_CODE=STVAPDC_CODE AND STVAPDC_INST_ACC_IND=Y ; For Undergraduates - Identifies that a decision of "Admitted" was made on an application, which includes applications admitted on an exception and those cancelled after admission. SARAPPDAPDC_CODE = CA OR SARAPPD_APDC_CODE=STVAPDC_CODE AND STVAPDC_INST_ACC_IND=Y | |
| AdmissionsMart | Accepted | For Graduates - Indicates whether or not an application decision caused a record to be created in the Student Base Table (SGBSTDN) (i.e. STVAPDC_INST_ACC_IND = 'Y' means a record has been created in SGBSTDN). ; For Undergraduates - Indicates whether or not an application decision caused a record to be created in the Student Base Table (SGBSTDN) (i.e. STVAPDC_INST_ACC_IND = 'Y' means a record has been created in SGBSTDN) and the student remains active and eligible to enroll. | |
| AdmissionsMart | Cancelled After Admit | For Graduates - Identifies that a decision of "cancelled after admitted" was made on an application. cancelled after admitted decision codes SARAPPD_APDC_CODE ="CA, GD" (D002291) ; For Undergraduates - Identifies that an application was cancelled after the student was admitted. Cancellation inactivates the student record, taking person out of eligible to register population. SARAPPD_APDC_CODE='CA' | |
| AdmissionsMart | Enrolled | Indicates whether or not an applicant is enrolled. Enrollment is calculated based on the term of entry, level, campus, degree program (graduate only), and the existence of fee liable credit hours | |
| AdmissionsMart | Denied | For Graduates - Identifies that a decision of "denied" was made on an application. Denied decision codes SARAPPD_APDC_CODE ="D%" (D002291) ; For Undergraduates - Application for admission is denied. SARAPPD_APDC_CODE=STVAPDC_CODE AND STVAPDC_REJECT_IND='Y' | |
| AdmissionsMart | Cancelled Prior To Admit | For Graduates - Identifies that an application was cancelled prior to being either admitted or denied. Cancellations may be student-initiated or posted by the Office of Admissions when an application is not completed within a designated time (e.g. fee not paid, documents not submitted) SARAPPD_APDC_CODE LIKE C% or GU or AE, BUT NOT EQUAL TO CA. ; For Undergraduates - Identifies that an application was cancelled prior to being either admitted or denied. Cancellations may be student-initiated or posted by the Office of Admissions when an application is not completed within a designated time (e.g. fee not paid, documents not submitted) SARAPPD_APDC_CODE LIKE C% BUT NOT EQUAL TO CA | |
| AdmissionsMart | Total Applications | Total Applications |