EIS Student CUBE Documentation - Registration.
- Michael Harvey (Deactivated)
Owned by Michael Harvey (Deactivated)
Mar 13, 2019
9 min read
Loading data...
Dimensions.
| Cube Name | Dimension Unique Name | Description |
|---|---|---|
| Registration | Course Level | Identifies the leve of the course. |
| Registration | Course Level Group | Course level identified as undegraduate or graduate level. Undergraduate course have a course number <= 4999. Graduate courses have a course number >= 5000 |
| Registration | Course Level Hierarchy | |
| Registration | Course Level Title | Course Level Title |
| Registration | Course Org Department Hierarchy | |
| Registration | Course Org Unit College Hierarchy | |
| Registration | Flag Org Unit Academic | Identifies if the course unit is academic or not. |
| Registration | Org Unit Campus | Unique campus name, for cross system use |
| Registration | Org Unit College | Unique College Code, similar to banner for College by campus |
| Registration | Org Unit College Group | Grouping to identify Health vs Non-Health colleges |
| Registration | Org Unit Department | Unique College Department Code |
| Registration | Course CIP | Course CIP Code. Classification associated with the major emphasis of the course program category or other activity. The codes are based on the Classification of Instructional Programs (CIP) compiled by the National Center for Educational Statistics (NCES). |
| Registration | Course CIP Group | Course CIP group identified by using the leading two characters of the entire program CIP. |
| Registration | Course CIP Hierarchy | |
| Registration | Course CIP Title | Course CIP Title. Classification associated with the major emphasis of the course program category or other activity. The codes are based on the Classification of Instructional Programs (CIP) compiled by the National Center for Educational Statistics (NCES). |
| Registration | Course Days In Week Meeting | Course Days In Week Meeting |
| Registration | Course Delivery Method | A classification of a course based on the delivery of direct instruction. Full Distance Learning Course. Full Distance Learning Course - 100% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space, or both. All special course components (exams, internships, practica, clinicals, labs, etc) that cannot be completed online can be completed off-campus.Primarily Classroom Course - Primarily Classroom Course - Less than 50% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both. This designation can include activities that do not occur in a classroom (ie, labs, internships, practica, clinicals, labs, etc).Hybrid Course - 50-79% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both.Primarily Distance Learning Course - 80-99% of the direc |
| Registration | Course Detail | Complete course identifier in the format of Course Prefix - Course Number - Course Section Course sectiontype (course reference number) |
| Registration | Course ID | Synthetic key designed to identify unique courses at the section level |
| Registration | Course Identifier | Course identifier in the format CoursePrefix CourseNumber CourseSection |
| Registration | Course Level Group | Course level identified as undegraduate or graduate level. Undergraduate course have a course number <= 4999. Graduate courses have a course number >= 5000 |
| Registration | Course Number | A code which includes the level of a course and which is assigned to identify the course in a systematic manner |
| Registration | Course Prefix | The alpha abbreviation which is assigned to a course, by Common Course Numbering. |
| Registration | Course Prefix Number Title | Course identifier in the format of CoursePrefix - Course number Course Title |
| Registration | Course Ref Number | Unique identifier to distinguish courses down to its lowermost granularity. |
| Registration | Course Section | A unique identifier assigned by the institution for each section of a course offered during the term reported. |
| Registration | Course Section Type | The means by which instruction is predominantly delivered for this course section as reported on the Student Data Course File. |
| Registration | Course Session ID | An indicator used by the universities to uniquely identify a session of less than 10 weeks within a summer term OR less than full term for fall and spring terms. |
| Registration | Course Site | The official number or other identifier that serves to uniquely identify the site within the university. |
| Registration | Course Site Address | Address of the site where the course if offered. |
| Registration | Course Site County | County of the site where the course is being offered. |
| Registration | Course Title | Course Title |
| Registration | Flag Education Abroad | Identifies courses that are education abroad. Specifically courses which have a Session_Code = 1 in SSBSECT table in Banner |
| Registration | Flag FKL | Identifies general education courses. Also called foundation of knowledge and learning courses. |
| Registration | Flag Maymester | Identifies courses offered in the special maymester time frame |
| Registration | Flag Winter Session | Identifies courses offered in the special winter session time frame |
| Registration | Funding Source | A code to indicate the budget entity of the department offering the course section. |
| Registration | Instructor Primary Name | Name of the primary instructor associated with the course |
| Registration | Instructor Primary PID | ID of the primary instructor associated with the course. |
| Registration | Address State | State Address |
| Registration | Admission Type | Identifies student admission type. Various values include - 1 -FTIC, 2 - College System Transfers, 3 - Other Transfers, 3.5 - Post Bac. Degree Seeking, 4 - Masters/Ed.S., 5 - Doctoral Research, 6 - Doctoral Professional, 7 - Other Non Degree Seeking |
| Registration | County Of Residence | County Of Residence |
| Registration | Date Student Recent Admit | The year and month of the student's most recent admission or readmission to the institution. This element should reflect the most recent admission date to the institution. It should be updated each time the student proceeds through the admission process, (I.E. An unclassified student who is formally admitted to the institution; or a native student who is admitted to a graduate program.) |
| Registration | Degree Level Sought | The level of degree that will be awarded pending successful completion of the student's current degree program. |
| Registration | Degree Level Sought Detail | Detailed information about the level of degree that will be awarded pending successful completion of the student's current degree program. |
| Registration | Degree Type Highest Student | The highest educational degree, certificate or diploma held by the individual. The code reported here should be the highest degree, certificate or diploma held by the student at the beginning of the term being reported. |
| Registration | Education Abroad Status | Identifies if a student participated in an education abroad program and specifies the credit nature. Based off data in the SERDTSR table with codes of EAOC, EAON & EAOU. |
| Registration | Flag Housing | Identifies students registered for oncampus housing or affiliated housing. |
| Registration | Flag IPEDS Graduate Student | Identifies students who qualify as graduate students according to IPEDS classification. |
| Registration | Flag IPEDSFTIC | Identifies students who qualify as an FTIC according to IPEDS classification. Criteria include - Full time only, not withdrawn or deceased, not FSR, not invalid gender. |
| Registration | Flag Person International | Indicates if a person is counted as an international based on the State and Federal definition that uses ethnicity code of Non-resident alien. |
| Registration | Flag Person International USF | Identifies a person as an international based on USF World definiction which uses citizenship code of F-Foreign national. |
| Registration | Flag Student Employed | Identifies a student as employed based on their GEMS appointment status |
| Registration | Flag Student Full Fee Paying | Identifies a student as having paid full fees based on not having any received any stipends or waivers. |
| Registration | Flag Student Honors | Identifies a student as belonging to a Honors program. |
| Registration | Flag Student Into | Identifies a student as being a part of the INTO program both currently enrolled or having matriculated from it. |
| Registration | Flag Student New | Identifies a student as a new student based on the students most recent admit term. |
| Registration | Flag Student Part Time | Identifies a student as a part time student based on the cummulative credit hours enrolled in a particular term.For Undergraduates in spring and fall terms, if course load is < 12 credits then part time.For Undergraduates in summer terms, if course load is < 8 credits then part time.For Graduates in spring and fall terms, if course load is < 9 then part time.For Graduates in summer terms, if course load is < 6 then part time. |
| Registration | Flag Student Prepaid Contract | Identifies students who have signed up for prepaid contracts (FPP). |
| Registration | Flag Student Received Fin Aid | Identifies students who have received financial aid. |
| Registration | Flag Student Received Stipend | Identifies students who have received stipends |
| Registration | Flag Student Received Waiver | Identifies students who have received waivers. |
| Registration | Flag Student Summer Fall | Identifies students who started in summer term and continued only the fall term. |
| Registration | Funding Source | code to indicate the budget entity of the department/college of the student. |
| Registration | International Status | Indicates whether or not an International Student |
| Registration | INTO Group | Identifies the INTO group to which the person is currently belonging to. |
| Registration | INTO Term Admit | Identifies the intial term of entry into the INTO program. |
| Registration | Org Unit Major Hierarchy | |
| Registration | Person Age | Age of the person |
| Registration | Person Citizenship Code | Citizenship code of the person |
| Registration | Person Gender | Gender |
| Registration | Person Name | Name of person |
| Registration | Person Nationality | Country of Nationality |
| Registration | Person Race | Race/Ethnicity of person |
| Registration | Person Residency Type | For students this denotes the student's domicile, within or outside of the State of Florida, identified for the purpose of assessing fees at the institution. Values include - I- Instate Residents and O-Out of state residents |
| Registration | Student Academic Standing | Academic standing of student |
| Registration | Student CIP | Student CIP or discipline or Program Category, CIP is the Classification of Instructional Program |
| Registration | Student CIP Group | Student CIP group identified by using the leading two characters of the entire program CIP. |
| Registration | Student CIP Hierarchy | |
| Registration | Student CIP Title | Student CIP Title. Classification associated with the major emphasis of the course program category or other activity. The codes are based on the Classification of Instructional Programs (CIP) compiled by the National Center for Educational Statistics (NCES). |
| Registration | Student Class Code Group | Class code group of student based on their GEMS appointment record. |
| Registration | Student Class Code Group Detail | Identifies the detailed nature of student class code |
| Registration | Student Class Code Hierarchy | |
| Registration | Student Class Code Title | Identifies the title of the detailed nature of student class code |
| Registration | Student Classfication | Student Classfication |
| Registration | Student Classification Hierarchy | |
| Registration | Student Concentration | Identifies the concentration if available for the students enrollment record |
| Registration | Student Dual Enrolled Status | A code used to indicate a student who is undertaking course work in two separate institutions during the same term when known by the institution. |
| Registration | Student Entry Type | Type of student at time of first registration for credit courses at this institution.This element does not change after the first term the student is registered for credit courses |
| Registration | Student Fee Class Kind | The classification of the type of registration fees (money charged by the university for instruction) and other payments made by the student to the university for educational purposes. The three classifications are: 1) All general instruction including IFAS (Institute of Food and Agriculture Science), Health Center, Medical Center and audits. 2) Student registered for no credit (graduating student, exams, etc.) 3) Student not registered, degree posted only. |
| Registration | Student First Generation Indicator | For in-state, degree-seeking students taking at least 6 credit hours and that completed a Free Application for Federal Student Aid (FAFSA), this field indicates whether or not the student was determined to be needy and indicated on the FAFSA that, for both parents, the highest school completed was high school or less. |
| Registration | Student Grouping Accountability | Grouping of students based on accountability reports |
| Registration | Student High School Attended | High school attended by student |
| Registration | Student High School Attended City | City of location of high school attended by student |
| Registration | Student High School Attended State | State of location of high school attended by student |
| Registration | Student Housing Status | Identifies students registered for oncampus housing or affiliated housing. |
| Registration | Student ID | OASIS PIDM identifier of person |
| Registration | Student Institutional Classification | The categorization of the student's progress, as defined by the institution, at the beginning of the term toward a specific degree program, as anticipated after all transcript evaluation and transfer hours are posted. These categories are: Freshman, Sophomore, Junior, Senior, Graduate, Unclassified, First Professional, and Correspondence Course Students. |
| Registration | Student Last Institution Attended | The Office of Postsecondary Education Identifier (OPEID) code for the student's most recent post-secondary educational training previous to this institution. |
| Registration | Student Level | Advanced Graduate--a graduate student who has been formally admitted to a recognized Doctoral or Post-Masters's degree program.; Beginning Graduate--a graduate student who has been formally admitted to a graduate degree program and is not an advanced graduate student.; Upper Division--a student who has earned 60 or more credit hours or has an associate of arts degree and has completed requirements in English and Mathematics as prescribed by FAC 6A-10.030 or is working toward an additional baccalaureate degree. ; Lower Division--a student who has earned less than 60 credit hours, or a student who has not been admitted to the upper division. ; Unclassified--a student not admitted to a degree program. |
| Registration | Student Major Title | Title of students primary major |
| Registration | Student Minor | Identifies the students primary minor |
| Registration | Student Minor2 | Identifies the students secondary minor |
| Registration | Student Termination Status | Code indicating termination of student's enrollment in the institution by withdrawing during the term, suspension during the term, suspension at the end of the term or death. |
| Registration | Student Type | Identifies students as graduate, undergraduate or non-degree. |
| Registration | Student Type Hierarchy | |
| Registration | Student Veteran Status | On the Admissions submission this is a self reported response to the admission application Veteran Status questions "Are you a veteran of the U.S. Military? If yes, did you serve on or after 09/11/2001?" and "Are you eligible to receive VA educational benefits as the spouse or dependent child of a veteran?" The Active Duty status comes from the Information for Residency Classification form. On the Final Student Information (SIF) Enrollments table this information has been verified by the university for accuracy. |
| Registration | Visa Type | Identifies students visa type if applicable. |
| Registration | Measures | |
| Registration | City | City of Nationality |
| Registration | Nation | Country of Nationality |
| Registration | Region | Region according to groups specified by International Admissions. The various regions include - 1.China, Hong Kong, and Macau , 2.East Asia, 3.ECA, 4.MEASA, 5.NCSA, 6.Other |
| Registration | Region Hierarchy | |
| Registration | State | State within country of nationality |
| Registration | Territory | Sub area grouping as identified by International Admissions to reside within each region. |
| Registration | Student Grade Course | Grade awarded to the student for the particular course |
| Registration | Flag Fall | Identifies fall terms. |
| Registration | Flag Fall Spring | Identfies fall and spring terms. |
| Registration | Flag Summer Fall | Identifies summer and fall terms. |
| Registration | Term | Term of record. |
| Registration | Term Academic Year Hierarchy | Term Academic Year Hierarchy |
| Registration | Term Calendar Year Hierarchy | Term Calendar Year Hierarchy |
| Registration | Term Title | Term Title of record. |
| Registration | Year Academic | Academic year as identified by Summer + Fall + Spring. |
| Registration | Year Calendar | Calendar year as identified by Spring + Summer + Fall. |
| Registration | Latest Benchmark | This field provides the latest benchmark for which data has been loaded by term |
| Registration | Year Stu Fin Aid | Financial Aid year as identified by Fall + Spring + Summer. |
| Registration | Org College Hierarchy | Org College Hierarchy |
| Registration | Org Department Hierarchy | Org Department Hierarchy |
| Registration | Org Unit Campus | Unique campus name, for cross system use |
| Registration | Org Unit College | Unique College Code, similar to banner for College by campus |
| Registration | Org Unit Department | Department that is funding the course. |
FACTS/MEASURES.
| Cube Name | Measure Name | Measure Description | EXPRESSION |
|---|---|---|---|
| Registration | % Count of Total for Col | Case when isempty([Count Course Enrollment]) then null else iif(isempty(Axis(0).Item(0).Item(0).Dimension.CurrentMember.Parent),1,[Count Course Enrollment]/(Axis(0).Item(0).Item(0).Dimension.CurrentMember.Parent,Measures.[Count Cou | |
| Registration | % Count of Total for Row | Case when isempty([Count Course Enrollment]) then null else iif(isempty(Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent),1,[Count Course Enrollment]/(Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent,Measures.[Count Cou | |
| Registration | Count Course Enrollment | Count of Enrolled heads within Courses at the section level | |
| Registration | Count Student Enrollment Distinct | Count of distinct students enrolled within courses at the section level | |
| Registration | Credit Hours Fundable | The number of State Fundable Hours based on Student Section Funding Flag, type of Course Section and/or Fee Waiver Kind | |
| Registration | Credit Hours Fundable AAR | The number of State Fundable Hours based on Student Section Funding Flag, type of Course Section and/or Fee Waiver Kind as per BOG Accountability methodology | |
| Registration | Credit Hours Gross | A quantitative measurement, stated in semester hours, which is the number of hours for which a student may be enrolled for credit for this course section | |
| Registration | FTE Federal Fundable Student | Undergraduate FTE = (UG Fundable SCH/30) ; Graduate FTE = (GR Fundable SCH/24) | |
| Registration | FTE Federal Gross Student | Undergraduate FTE = (UG Gross SCH/30) ; Graduate FTE = (GR Gross SCH/24) | |
| Registration | FTE Fundable | Undergraduate FTE = (UG Fundable SCH/40) ; Graduate FTE = (GR Fundable SCH/32) | |
| Registration | FTE Fundable AAR | Undergraduate FTE = (UG Fundable AAR SCH/40) ; Graduate FTE = (GR Fundable AAR SCH/32) | |
| Registration | FTE Gross | Undergraduate FTE = (UG Gross SCH/40) ; Graduate FTE = (GR Gross SCH/32) |