Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
|
Academic period or time frame associated with this outcome or degree record.
|
VARCHAR2(63 CHAR)
|
|
|
|
ACADEMIC_PERIOD_ADMITTED
|
Academic_Period_Admitted
|
Academic period the student was admitted to the university. Student changing majors or levels that do not require a separate admission process do not get a new value (for example, a student moving to the graduate portion of a +1 program). Each separate admissions process a student goes through will generate a new date.
|
VARCHAR2(50)
|
|
|
|
ACADEMIC_PERIOD_ADMITTED_DESC
|
Academic_Period_Admitted_Desc
|
Description for Academic Period Admitted
|
VARCHAR2(255 CHAR)
|
|
|
|
ACADEMIC_PERIOD_DESC
|
|
Academic period description.
|
VARCHAR2(255 CHAR)
|
|
|
|
ACADEMIC_PERIOD_GRADUATION
|
Academic_Period_Graduation
|
Academic period when graduation requirements were or will be completed.
|
VARCHAR2(63 CHAR)
|
|
|
|
ACADEMIC_PERIOD_GRAD_DESC
|
Academic_Period_Grad_Desc
|
Academic period description.
|
VARCHAR2(255 CHAR)
|
|
|
|
ACADEMIC_YEAR_GRADUATION
|
Academic_Grad_Year
|
Academic year associated with this graduation date. This is the traditional academic year (fall-summer) and NOT the degree year (July-June).
|
VARCHAR2(63 CHAR)
|
|
|
|
ACADEMIC_YEAR_GRADUATION_DESC
|
Academic_Grad_Year_Desc
|
Academic year description.
|
VARCHAR2(255 CHAR)
|
|
|
|
AFRICAN_AMERICAN_IND
|
|
Indicates that the student has self-identified as being of a race categorized as Black or African-American
|
VARCHAR2(1 CHAR)
|
|
|
|
AMERICAN_INDIAN_IND
|
|
Indicates that the student has self-identified as being of a race categorized as American Indian or Alaska
|
VARCHAR2(1 CHAR)
|
|
|
|
APPLIED_FOR_OUTCOME_IND
|
|
Indicates whether the person has applied to officially receive this specific degree or award as an academic outcome.
Should always be "N" in freeze view.
|
VARCHAR2(1 CHAR)
|
|
|
|
ASIAN_IND
|
|
Indicates that the student has self-identified as being of a race categorized as Asian.
|
VARCHAR2(1 CHAR)
|
|
|
|
AWARD_CATEGORY
|
Award_Category
|
Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.
|
VARCHAR2(63 CHAR)
|
|
|
|
AWARD_CATEGORY_DESC
|
Award_Category_Desc
|
Award category description.
|
VARCHAR2(255 CHAR)
|
|
|
|
CAMPUS
|
|
Campus associated to where the academic outcome requirements were completed.
|
VARCHAR2(63 CHAR)
|
|
|
|
CAMPUS_DESC
|
|
Institution campus name.
|
VARCHAR2(255 CHAR)
|
|
|
|
COHORT1
|
Cohort1
|
A specific group of students that have a common attribute(s). NU generally uses a start date as a common attribute. For IPEDS reporting, as well as management reports, a student cohort is commonly defined as a collective group of first-time entrants to our institution who enrolled at the census date in programs leading to a certificate, associate or baccalaureate, or other degree. This cohort is first-time full-time freshmen & first-time full-time transfers. Example: 201310FN (New student as of Fall 2013 term)
|
VARCHAR2(50 CHAR)
|
|
|
|
COHORT1_DESC
|
Cohort1_Desc
|
Description for Cohort 1
|
VARCHAR2(250 CHAR)
|
|
|
|
COLLEGE
|
Student_College
|
College, faculty or school to which the academic study for the student is associated.
|
VARCHAR2(63 CHAR)
|
|
|
|
COLLEGE_DESC
|
Student_College_Desc
|
College, faculty or school name.
|
VARCHAR2(255 CHAR)
|
|
|
|
CURRICULUM_ORDER
|
|
Unique sequence number that identifies this academic study or program for the student.
|
NUMBER(2)
|
|
|
|
CURRICULUM_PRIORITY_NUMBER
|
|
Identifies the significant ranking for a curricula.
|
NUMBER(2)
|
|
|
|
DEGREE
|
Degree
|
Degree or award code associated with the academic study.
|
VARCHAR2(63 CHAR)
|
|
|
|
DEGREE_DESC
|
Degree_Desc
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2(255 CHAR)
|
|
|
|
DEPARTMENT
|
Student_Department
|
Department responsible to verify that the academic outcome requirements have been completed.
|
VARCHAR2(63 CHAR)
|
|
|
|
DEPARTMENTAL_HONORS_COUNT
|
|
UNDER REVIEW.
Count of all honors recorded for the student. Indicates the honor was approved by the department.
|
NUMBER(2)
|
|
|
|
DEPARTMENT_DESC
|
Student_Department_Desc
|
Department name.
|
VARCHAR2(255 CHAR)
|
|
|
|
DOB
|
|
Date of birth of the person.
|
DATE
|
|
|
|
DUAL_MAJOR_FLAG
|
Dual_Major_Ind
|
Flag indicating that the student is pursuing two majors.
|
VARCHAR2(1 CHAR)
|
|
|
|
EVENT
|
Event
|
a description of the predefined freeze event as one of stat date freeze, degree data freeze, end of term freeze, etc.
|
VARCHAR2(100 CHAR)
|
|
|
|
FIRST_CONCENTRATION
|
First_Concentration
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63 CHAR)
|
|
|
|
FIRST_CONCENTRATION_DESC
|
First_Concentration_Desc
|
Concentration or study emphasis description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FIRST_MINOR
|
First_Minor
|
Minor subject area of the person's academic study.
|
VARCHAR2(63 CHAR)
|
|
|
|
FIRST_MINOR_DESC
|
First_Minor_Desc
|
Minor subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FIRST_NM
|
First_Name
|
The first name given to a person at birth, baptism, another naming ceremony or through legal change.
|
VARCHAR2(100 CHAR)
|
|
|
|
FOURTH_DEPARTMENT
|
|
Department responsible for this major subject area of academic instruction.
|
VARCHAR2(63 CHAR)
|
|
|
|
FOURTH_DEPARTMENT_DESC
|
|
Department name.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MAJOR
|
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63 CHAR)
|
|
|
|
FOURTH_MAJOR_CONC_1
|
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63 CHAR)
|
|
|
|
FOURTH_MAJOR_CONC_1_DESC
|
|
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MAJOR_CONC_2
|
|
Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63 CHAR)
|
|
|
|
FOURTH_MAJOR_CONC_2_DESC
|
|
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MAJOR_CONC_3
|
|
Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63 CHAR)
|
|
|
|
FOURTH_MAJOR_CONC_3_DESC
|
|
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MAJOR_DESC
|
|
Major or subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MINOR
|
|
Fourth minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63 CHAR)
|
|
|
|
FOURTH_MINOR_DESC
|
|
Minor area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_PROGRAM_CLASSIFICATION
|
|
Program classification associated with the major subject area of study for this academic outcome. This may be Classification of Institutional Program (CIP) codes used for reporting outcomes to the federal government.
|
VARCHAR2(63 CHAR)
|
|
|
|
FOURTH_PROGRAM_CLASSIF_DESC
|
|
Program classification code description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FREEZE_DATE
|
Freeze_Date
|
Actual date the data was frozen. Data in this Academic Outcome view is frozen on an annual basis in August.
|
DATE
|
|
|
|
GENDER
|
Gender
|
The gender of a person, e.g. Male, Female.
|
VARCHAR2(5 CHAR)
|
|
|
|
GENDER_DESC
|
Gender_Desc
|
Description for Gender
|
VARCHAR2(100 CHAR)
|
|
|
|
GRADUATED_IND
|
|
Indicates whether the person has earned this degree or other award from the institution.
Should always be "Y" in freeze view.
|
VARCHAR2(1 CHAR)
|
|
|
|
GRADUATION_STATUS
|
|
Identifies that an academic outcome is completed or still being sought, etc.
|
VARCHAR2(3 CHAR)
|
|
|
|
GRADUATION_STATUS_DESC
|
|
Current graduation status description.
|
VARCHAR2(255 CHAR)
|
|
|
|
GRAD_AUTHORIZED_ADDS_CHGS
|
|
Identifies that the student is authorized to add or drop based on graduation requirements.
|
VARCHAR2(63 CHAR)
|
|
|
|
HISPANIC_LATINO_IND
|
|
Indicates that the student has self-identified as being of Hispanic or Latino origin
|
VARCHAR2(1 CHAR)
|
|
|
|
HONORS_COUNT
|
|
Count of all honors recorded for the student.
|
NUMBER(2)
|
|
|
|
ID
|
Student_NUID
|
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
|
VARCHAR2(9 CHAR)
|
|
|
|
INSTITUTIONAL_HONORS_COUNT
|
Institutional_Honors_Count
|
Count of all honors recorded for the student. Indicate that the honor was approved at the institution level, including honors such as Cum Laude, Summa Cum Laude, First Class, etc.
|
NUMBER(2)
|
|
|
|
IPEDS_AWARD_LEVEL
|
Degree_IPEDS_Code
|
IPEDS Code associated with student degree
Examples:
2 - Cert between 1 and 2 years
3 - Associate
4 - Postsecondary award, certificate, or diploma of (at least 2 but less than 4 academic years)
5 - Bachelors
6 - Post baccalaureate certificate
7 - Masters
8 - Post-master's certificate
9 - Doctorate (Retired as of Fall 2010)
17 -Doctor-Research/Scholarship
18 - Doctor - Professional Practice
19 - Doctor Other
99 - No Degree
|
VARCHAR2(6 CHAR)
|
|
|
|
IPEDS_ETHNICITY_RACE_CD
|
|
Race / Ethnicity based on requirements from the "Integrated Postsecondary Education Data System (IPEDS) Example: 1 - Hispanic of any race 2 - American Indian or Alaska Native 3 - Asian 4- Black or African American 5 - Native Hawaiian or Other Pacific Islander 6 - White 7 - Two or more races 8 - Nonresident Alien 9 - Race and Ethnicity unknown
*This code is only valid beginning Fall 2010.
Note: Corresponds to IPEDS_Ethnicity_Race_Cd for IPEDS reporting. This information is used for statistical purposes only and is aggregated and submitted to the federal government as may be required by law. The University also uses the aggregated data to develop government-mandated reports/plans. This means the information is reported in total numbers only, without any identifying information. Personally identifiable information will remain confidential.
|
VARCHAR2(63 CHAR)
|
|
|
|
IPEDS_ETHNICITY_RACE_NAME
|
|
Description of IPEDS_RACE_CD Note: Corresponds to IPEDS_Ethnicity_Race_Name for IPEDS reporting.
|
VARCHAR2(255 CHAR)
|
|
|
|
LAST_NM
|
Last_Name
|
The last name by which a person is known.
|
VARCHAR2(100 CHAR)
|
|
|
|
MAJOR
|
Primary_Major
|
First subject area or major focus recorded for the student's curriculum. This may not be blank.
|
VARCHAR2(63 CHAR)
|
|
|
|
MAJOR_DESC
|
Primary_Major_Desc
|
Name of the student's major subject area.
|
VARCHAR2(255 CHAR)
|
|
|
|
NEU_CREDITS_ATTEMPTED
|
|
Sum of hours for all classes in which a student has enrolled.
|
NUMBER(11,2)
|
|
|
|
NEU_CREDITS_EARNED
|
|
Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.
|
NUMBER(11,2)
|
|
|
|
NEU_CREDITS_PASSED
|
|
Sum of hours for classes a student has enrolled in and passed.
|
NUMBER(11,2)
|
|
|
|
NEU_GPA
|
|
Calculated grade point average or average for the set of courses completed.
|
NUMBER(11,2)
|
|
|
|
NEU_GPA_CREDITS
|
|
Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements.
|
NUMBER(11,2)
|
|
|
|
NEU_QUALITY_POINTS
|
|
Quality points used to calculate the grade point average for this academic outcome.
|
NUMBER(11,2)
|
|
|
|
OFFICIAL_DOCUMENT_NAME
|
|
Name of the person as it appears on the outcome document.
|
VARCHAR2(500 CHAR)
|
|
|
|
OUTCOME_APPLICATION_DATE
|
Outcome_Application_Date
|
Date that the student applied for graduation in this academic outcome.
|
DATE
|
|
|
|
OUTCOME_AWARDED_IND
|
|
Identifies whether the academic outcome, award or degree has been officially awarded to the person.
Should always be "A" in freeze view.
|
VARCHAR2(1 CHAR)
|
|
|
|
OUTCOME_GRADUATION_DATE
|
Outcome_Graduation_Date
|
Date for the formal graduation for this academic outcome. This is the date that the completion of this degree or award is confirmed.
|
DATE
|
|
|
|
OUTCOME_NUMBER
|
|
Degree or award sequence number for this academic outcome for the student.
|
NUMBER
|
|
|
|
PACIFIC_ISLDR_IND
|
|
Indicates that the student has self-identified as being of a race categorized as Native Hawaiian or Pacific Islander
|
VARCHAR2(1 CHAR)
|
|
|
|
PERSON_UID
|
Person_UID
|
System generated Banner unique ID which gets assigned to all person and non-person records within Banner.
|
NUMBER
|
|
|
|
PRIMARY_ETHNICITY
|
|
This field identifies the ethnic code defined as one of defined by NU. This information is used for statistical purposes only and is aggregated and submitted to the federal government as may be required by law. The University also uses the aggregated data to develop government-mandated reports/plans. This means the information is reported in total numbers only, without any identifying information. Personally identifiable information will remain confidential.
*This code is only valid prior to Fall 2010.
|
VARCHAR2(63 CHAR)
|
|
|
|
PRIMARY_ETHNICITY_DESC
|
|
Description for Primary Ethnicity
|
VARCHAR2(255 CHAR)
|
|
|
|
PROGRAM
|
Program
|
Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.
|
VARCHAR2(63 CHAR)
|
|
|
|
PROGRAM_CLASSIFICATION
|
Program_Classification
|
Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government.
|
VARCHAR2(63 CHAR)
|
|
|
|
PROGRAM_CLASSIFICATION_DESC
|
Program_Classification_Desc
|
Program classification description.
|
VARCHAR2(255 CHAR)
|
|
|
|
PROGRAM_DESC
|
Program_Desc
|
Program or course of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_CONCENTRATION
|
Second_Concentration
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_CONCENTRATION_DESC
|
Second_Concentration_Desc
|
Concentration or study emphasis description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_DEPARTMENT
|
Second_Department
|
Department responsible for the second major or subject area of academic instruction.
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_DEPARTMENT_DESC
|
Second_Department_Desc
|
Department name.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MAJOR
|
Second_Major
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_MAJOR_CONC_1
|
Second_Major_Conc_1
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_MAJOR_CONC_1_DESC
|
Second_Major_Conc_1_Desc
|
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MAJOR_CONC_2
|
|
Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_MAJOR_CONC_2_DESC
|
|
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MAJOR_CONC_3
|
|
Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_MAJOR_CONC_3_DESC
|
|
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MAJOR_DESC
|
Second_Major_Desc
|
Major or subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MINOR
|
Second_Minor
|
Second minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_MINOR_DESC
|
Second_Minor_Desc
|
Minor subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_PROGRAM_CLASSIFICATION
|
|
Program classification associated with the major subject area of study for this outcome. This may be the Classification of Program (CIP) codes used for reporting outcomes to the federal government.
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_PROGRAM_CLASSIF_DESC
|
|
Program classification code description.
|
VARCHAR2(255 CHAR)
|
|
|
|
STATUS
|
Student_Status
|
Current status of the academic outcome. For example, pending, awarded, etc.
Should always be "AW" in freeze view.
|
VARCHAR2(63 CHAR)
|
|
|
|
STATUS_DESC
|
Student_Status_Desc
|
Outcome or award status description.
|
VARCHAR2(255 CHAR)
|
|
|
|
STUDENT_LEVEL
|
Student_Level
|
Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.
|
VARCHAR2(63 CHAR)
|
|
|
|
STUDENT_LEVEL_DESC
|
Student_Level_Desc
|
Student level description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_CONCENTRATION
|
|
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_CONCENTRATION_DESC
|
|
Concentration or study emphasis description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_DEPARTMENT
|
|
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_DEPARTMENT_DESC
|
|
Department name.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MAJOR
|
|
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_MAJOR_CONC_1
|
|
First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_MAJOR_CONC_1_DESC
|
|
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MAJOR_CONC_2
|
|
Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_MAJOR_CONC_2_DESC
|
|
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MAJOR_CONC_3
|
|
Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_MAJOR_CONC_3_DESC
|
|
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MAJOR_DESC
|
|
Major or subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MINOR
|
|
Third minor for the student within this academic study. This may be blank when no minor has been specified.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_MINOR_DESC
|
|
Minor area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_PROGRAM_CLASSIFICATION
|
|
Program classification associated with the major subject area of study for this academic outcome. This may be the classification of Institutional Program (CIP) codes used for reporting outcomes to the federal government.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_PROGRAM_CLASSIF_DESC
|
|
Program classification code description.
|
VARCHAR2(255 CHAR)
|
|
|
|
TRANSFER_WORK_EXISTS_IND
|
Transfer_Work_Exists_Ind
|
Indicates whether any transfer credits are recorded for the student that apply to this academic outcome.
|
VARCHAR2(1 CHAR)
|
|
|
|
WHITE_IND
|
|
Indicates that the student has self-identified as being of a race categorized as White.
|
VARCHAR2(1 CHAR)
|
|
|
|