Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
|
Business Definition
Academic period or time frame associated with this outcome or degree record.
Valid Values
Sample
201515
201510
201530
201510
201340
|
VARCHAR2(63 CHAR)
|
|
|
|
ACADEMIC_PERIOD_ADMITTED
|
Academic_Period_Admitted
|
Business Definition
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
|
Business Definition
Description for Academic Period Admitted
|
VARCHAR2(255 CHAR)
|
|
|
|
ACADEMIC_PERIOD_DESC
|
|
Business Definition
Academic period description.
Valid Values
Sample
Fall 2014 Semester
Fall 2015 CPS Quarter
Fall 2015 CPS Quarter
Fall 2013 Semester
Fall 2015 Law Quarter
|
VARCHAR2(255 CHAR)
|
|
|
|
ACADEMIC_PERIOD_GRADUATION
|
Academic_Period_Graduation
|
Business Definition
Academic period when graduation requirements were or will be completed.
Valid Values
Sample
201660
201655
201655
201660
201658
|
VARCHAR2(63 CHAR)
|
|
|
|
ACADEMIC_PERIOD_GRAD_DESC
|
Academic_Period_Grad_Desc
|
Business Definition
Academic period description.
Valid Values
Sample
Summer 2 2016 Semester
Summer 2016 CPS Quarter
Summer 2016 CPS Quarter
Summer 2 2016 Semester
Summer 2016 Law Quarter
|
VARCHAR2(255 CHAR)
|
|
|
|
ACADEMIC_YEAR_GRADUATION
|
Academic_Grad_Year
|
Business Definition
Academic year associated with this graduation date. This is the traditional academic year (fall-summer) and NOT the degree year (July-June).
Valid Values
Sample
2016
|
VARCHAR2(63 CHAR)
|
|
|
|
ACADEMIC_YEAR_GRADUATION_DESC
|
Academic_Grad_Year_Desc
|
Business Definition
Academic year description.
Valid Values
Sample
2015-2016
|
VARCHAR2(255 CHAR)
|
|
|
|
AFRICAN_AMERICAN_IND
|
|
Business Definition
Indicates that the student has self-identified as being of a race categorized as Black or African-American.
|
VARCHAR2(1 CHAR)
|
|
|
|
AMERICAN_INDIAN_IND
|
|
Business Definition
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
|
|
Business Definition
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.
Valid Values
Sample
N
|
VARCHAR2(1 CHAR)
|
|
|
|
ASIAN_IND
|
|
Business Definition
Indicates that the student has self-identified as being of a race categorized as Asian.
|
VARCHAR2(1 CHAR)
|
|
|
|
AWARD_CATEGORY
|
Award_Category
|
Business Definition
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.
Valid Values
Sample
42
24
24
42
42
|
VARCHAR2(63 CHAR)
|
|
|
|
AWARD_CATEGORY_DESC
|
Award_Category_Desc
|
Business Definition
Award category description.
Valid Values
Sample
Masters Degree
Masters Degree
Baccalaureate Degree
Baccalaureate Degree
Masters Degree
|
VARCHAR2(255 CHAR)
|
|
|
|
CAMPUS
|
|
Business Definition
Campus associated to where the academic outcome requirements were completed.
|
VARCHAR2(63 CHAR)
|
|
|
|
CAMPUS_DESC
|
|
Business Definition
Institution campus name.
|
VARCHAR2(255 CHAR)
|
|
|
|
COHORT1
|
Cohort1
|
Business Definition
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
|
Business Definition
Description for Cohort 1
|
VARCHAR2(250 CHAR)
|
|
|
|
COLLEGE
|
Student_College
|
Business Definition
College, faculty or school to which the academic study for the student is associated.
Valid Values
Sample
BA
PS
PS
EN
LW
|
VARCHAR2(63 CHAR)
|
|
|
|
COLLEGE_DESC
|
Student_College_Desc
|
Business Definition
College, faculty or school name.
Valid Values
Sample
Bouve College of Hlth Sciences
D'Amore-McKim School Business
Coll of Professional Studies
College of Engineering
School of Law
|
VARCHAR2(255 CHAR)
|
|
|
|
CURRICULUM_ORDER
|
|
Business Definition
Unique sequence number that identifies this academic study or program for the student.
Valid Values
Sample
1
1
1
1
1
|
NUMBER(2)
|
|
|
|
CURRICULUM_PRIORITY_NUMBER
|
|
Business Definition
Identifies the significant ranking for a curricula.
Valid Values
Sample
1
1
1
1
1
|
NUMBER(2)
|
|
|
|
DEGREE
|
Degree
|
Business Definition
Degree or award code associated with the academic study.
Valid Values
Sample
MBA
MS
MS
MSEM
LLM
|
VARCHAR2(63 CHAR)
|
|
|
|
DEGREE_DESC
|
Degree_Desc
|
Business Definition
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
Valid Values
Sample
Master of Business Admin
Master of Science
Master of Science
M.S. Engineering Management
Master of Laws
|
VARCHAR2(255 CHAR)
|
|
|
|
DEPARTMENT
|
Student_Department
|
Business Definition
Department responsible to verify that the academic outcome requirements have been completed.
Valid Values
Sample
BUSN
CPS
CPS
GSEN
LAW
|
VARCHAR2(63 CHAR)
|
|
|
|
DEPARTMENTAL_HONORS_COUNT
|
|
Business Definition
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
|
Business Definition
Department name.
Valid Values
Sample
Business Administration
Col of Professional Studies
Col of Professional Studies
Graduate Engineering Programs
Law
|
VARCHAR2(255 CHAR)
|
|
|
|
DOB
|
|
Business Definition
Date of birth of the person.
Valid Values
Sample
9/23/1991 0:00
10/12/1988 0:00
3/29/1992 0:00
1/1/1989 0:00
4/28/1987 0:00
|
DATE
|
|
|
|
DUAL_MAJOR_FLAG
|
Dual_Major_Ind
|
Business Definition
Flag indicating that the student is pursuing two majors.
|
VARCHAR2(1 CHAR)
|
|
|
|
EVENT
|
Event
|
Business Definition
A description of the predefined freeze event as one of stat date freeze, degree data freeze, end of term freeze, etc.
Valid Values
Sample
22-SEP-16 graduation date freeze
22-SEP-16 graduation date freeze
22-SEP-16 graduation date freeze
|
VARCHAR2(100 CHAR)
|
|
|
|
FIRST_CONCENTRATION
|
First_Concentration
|
Business Definition
Concentration or study emphasis attached to the major for the student's academic study.
Valid Values
Sample
ACCT
FINA
COFN
LEAD
LEAD
|
VARCHAR2(63 CHAR)
|
|
|
|
FIRST_CONCENTRATION_DESC
|
First_Concentration_Desc
|
Business Definition
Concentration or study emphasis description.
Valid Values
Sample
Accounting
Finance
Corporate Finance
Leadership
Leadership
|
VARCHAR2(255 CHAR)
|
|
|
|
FIRST_MINOR
|
First_Minor
|
Business Definition
Minor subject area of the person's academic study.
|
VARCHAR2(63 CHAR)
|
|
|
|
FIRST_MINOR_DESC
|
First_Minor_Desc
|
Business Definition
Minor subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FIRST_NM
|
First_Name
|
Business Definition
The first name given to a person at birth, baptism, another naming ceremony or through legal change.
Valid Values
Sample
Jonathan
Chenzi
Minshu
Stephen
Ethel
|
VARCHAR2(100 CHAR)
|
|
|
|
FOURTH_DEPARTMENT
|
|
Business Definition
Department responsible for this major subject area of academic instruction.
|
VARCHAR2(63 CHAR)
|
|
|
|
FOURTH_DEPARTMENT_DESC
|
|
Business Definition
Department name.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MAJOR
|
|
Business Definition
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63 CHAR)
|
|
|
|
FOURTH_MAJOR_CONC_1
|
|
Business Definition
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
|
|
Business Definition
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MAJOR_CONC_2
|
|
Business Definition
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
|
|
Business Definition
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MAJOR_CONC_3
|
|
Business Definition
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
|
|
Business Definition
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MAJOR_DESC
|
|
Business Definition
Major or subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_MINOR
|
|
Business Definition
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
|
|
Business Definition
Minor area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FOURTH_PROGRAM_CLASSIFICATION
|
|
Business Definition
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
|
|
Business Definition
Program classification code description.
|
VARCHAR2(255 CHAR)
|
|
|
|
FREEZE_DATE
|
Freeze_Date
|
Business Definition
Actual date the data was frozen. Data in this Academic Outcome view is frozen on an annual basis in August.
Valid Values
Sample
9/26/2016 0:00
9/26/2016 0:00
9/26/2016 0:00
|
DATE
|
|
|
|
GENDER
|
Gender
|
Business Definition
The gender of a person, e.g. Male, Female.
Valid Values
Sample
M
F
|
VARCHAR2(5 CHAR)
|
|
|
|
GENDER_DESC
|
Gender_Desc
|
Business Definition
Description for Gender
Valid Values
Sample
Male
Female
|
VARCHAR2(100 CHAR)
|
|
|
|
GRADUATED_IND
|
|
Business Definition
Indicates whether the person has earned this degree or other award from the institution. Should always be "Y" in freeze view.
Valid Values
Sample
Y
|
VARCHAR2(1 CHAR)
|
|
|
|
GRADUATION_STATUS
|
|
Business Definition
Identifies that an academic outcome is completed or still being sought, etc.
Valid Values
Sample
EG
|
VARCHAR2(3 CHAR)
|
|
|
|
GRADUATION_STATUS_DESC
|
|
Business Definition
Current graduation status description.
Valid Values
Sample
Expected Graduation
|
VARCHAR2(255 CHAR)
|
|
|
|
GRAD_AUTHORIZED_ADDS_CHGS
|
|
Business Definition
Identifies that the student is authorized to add or drop based on graduation requirements.
Valid Values
Sample
N000178528EG
|
VARCHAR2(63 CHAR)
|
|
|
|
HISPANIC_LATINO_IND
|
|
Business Definition
Indicates that the student has self-identified as being of Hispanic or Latino origin
|
VARCHAR2(1 CHAR)
|
|
|
|
HONORS_COUNT
|
|
Business Definition
Count of all honors recorded for the student.
Valid Values
Sample
0
1
|
NUMBER(2)
|
|
|
|
ID
|
Student_NUID
|
Business Definition
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
Valid Values
Sample
21637
1744299
1770958
428863
1616989
|
VARCHAR2(9 CHAR)
|
|
|
|
INSTITUTIONAL_HONORS_COUNT
|
Institutional_Honors_Count
|
Business Definition
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.
Valid Values
Sample
0
1
|
NUMBER(2)
|
|
|
|
IPEDS_AWARD_LEVEL
|
Degree_IPEDS_Code
|
Business Definition
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
|
|
Business Definition
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
|
|
Business Definition
Description of IPEDS_RACE_CD Note: Corresponds to IPEDS_Ethnicity_Race_Name for IPEDS reporting.
|
VARCHAR2(255 CHAR)
|
|
|
|
LAST_NM
|
Last_Name
|
Business Definition
The last name by which a person is known.
Valid Values
Sample
Ingrisani
Hu
Zhou
Kelly
Namatovu
|
VARCHAR2(100 CHAR)
|
|
|
|
MAJOR
|
Primary_Major
|
Business Definition
First subject area or major focus recorded for the student's curriculum. This may not be blank.
Valid Values
Sample
BSAD
PMGT
PMGT
ENGM
LAW
|
VARCHAR2(63 CHAR)
|
|
|
|
MAJOR_DESC
|
Primary_Major_Desc
|
Business Definition
Name of the student's major subject area.
Valid Values
Sample
Business Administration
Project Management
Project Management
Engineering Management
Law
|
VARCHAR2(255 CHAR)
|
|
|
|
NEU_CREDITS_ATTEMPTED
|
|
Business Definition
Sum of hours for all classes in which a student has enrolled.
|
NUMBER(11,2)
|
|
|
|
NEU_CREDITS_EARNED
|
|
Business Definition
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
|
|
Business Definition
Sum of hours for classes a student has enrolled in and passed.
|
NUMBER(11,2)
|
|
|
|
NEU_GPA
|
|
Business Definition
Calculated grade point average or average for the set of courses completed.
|
NUMBER(11,2)
|
|
|
|
NEU_GPA_CREDITS
|
|
Business Definition
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
|
|
Business Definition
Quality points used to calculate the grade point average for this academic outcome.
|
NUMBER(11,2)
|
|
|
|
OFFICIAL_DOCUMENT_NAME
|
|
Business Definition
Name of the person as it appears on the outcome document.
Valid Values
Sample
Jonathan C Ingrisani
Chenzi Hu
Minshu Zhou
Stephen John Kelly
Ethel C Namatovu
|
VARCHAR2(500 CHAR)
|
|
|
|
OUTCOME_APPLICATION_DATE
|
Outcome_Application_Date
|
Business Definition
Date that the student applied for graduation in this academic outcome.
Valid Values
Sample
2/2/2016 17:19
2/16/2016 15:18
2/29/2016 22:09
3/3/2016 7:26
3/25/2016 13:51
|
DATE
|
|
|
|
OUTCOME_AWARDED_IND
|
|
Business Definition
Identifies whether the academic outcome, award or degree has been officially awarded to the person. Should always be "A" in freeze view.
Valid Values
Sample
A
|
VARCHAR2(1 CHAR)
|
|
|
|
OUTCOME_GRADUATION_DATE
|
Outcome_Graduation_Date
|
Business Definition
Date for the formal graduation for this academic outcome. This is the date that the completion of this degree or award is confirmed.
Valid Values
Sample
8/31/2016 0:00
9/22/2016 0:00
9/22/2016 0:00
8/31/2016 0:00
8/31/2016 0:00
|
DATE
|
|
|
|
OUTCOME_NUMBER
|
|
Business Definition
Degree or award sequence number for this academic outcome for the student.
Valid Values
Sample
2
1
1
2
1
|
NUMBER
|
|
|
|
PACIFIC_ISLDR_IND
|
|
Business Definition
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
|
Business Definition
System generated Banner unique ID which gets assigned to all person and non-person records within Banner.
Valid Values
Sample
821,228
1,303,737
1,297,462
773,986
1,396,749
|
NUMBER
|
|
|
|
PRIMARY_ETHNICITY
|
|
Business Definition
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
|
|
Business Definition
Description for Primary Ethnicity
|
VARCHAR2(255 CHAR)
|
|
|
|
PROGRAM
|
Program
|
Business Definition
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.
Valid Values
Sample
MBA-BSAD-E
P-MS-PMGT
P-MS-PMGT
MSEM-ENGM
LLM-LAW
|
VARCHAR2(63 CHAR)
|
|
|
|
PROGRAM_CLASSIFICATION
|
Program_Classification
|
Business Definition
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.
Valid Values
Sample
520101
521301
521301
140101
220101
|
VARCHAR2(63 CHAR)
|
|
|
|
PROGRAM_CLASSIFICATION_DESC
|
Program_Classification_Desc
|
Business Definition
Program classification description.
Valid Values
Sample
Bus./Commerce
Mgt Sce
Mgt Sce
Engr
Law (LL.B.)
|
VARCHAR2(255 CHAR)
|
|
|
|
PROGRAM_DESC
|
Program_Desc
|
Business Definition
Program or course of study description.
Valid Values
Sample
MBA Business Admin-Evening
MS Project Management (CPS)
MS Project Management (CPS)
MSEM Engineering Management
LLM Law
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_CONCENTRATION
|
Second_Concentration
|
Business Definition
Concentration or study emphasis attached to the major for the student's academic study.
Valid Values
Sample
ACCT
FINA
INVS
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_CONCENTRATION_DESC
|
Second_Concentration_Desc
|
Business Definition
Concentration or study emphasis description.
Valid Values
Sample
Accounting
Finance
Investments
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_DEPARTMENT
|
Second_Department
|
Business Definition
Department responsible for the second major or subject area of academic instruction.
|
VARCHAR2(63 CHAR)
|
|
|
|
SECOND_DEPARTMENT_DESC
|
Second_Department_Desc
|
Business Definition
Department name.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MAJOR
|
Second_Major
|
Business Definition
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
|
Business Definition
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
|
Business Definition
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MAJOR_CONC_2
|
|
Business Definition
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
|
|
Business Definition
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MAJOR_CONC_3
|
|
Business Definition
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
|
|
Business Definition
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MAJOR_DESC
|
Second_Major_Desc
|
Business Definition
Major or subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_MINOR
|
Second_Minor
|
Business Definition
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
|
Business Definition
Minor subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
SECOND_PROGRAM_CLASSIFICATION
|
|
Business Definition
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
|
|
Business Definition
Program classification code description.
|
VARCHAR2(255 CHAR)
|
|
|
|
STATUS
|
Student_Status
|
Business Definition
Current status of the academic outcome. For example, pending, awarded, etc. Should always be "AW" in freeze view.
Valid Values
Sample
AW
|
VARCHAR2(63 CHAR)
|
|
|
|
STATUS_DESC
|
Student_Status_Desc
|
Business Definition
Outcome or award status description.
Valid Values
Sample
Awarded
|
VARCHAR2(255 CHAR)
|
|
|
|
STUDENT_LEVEL
|
Student_Level
|
Business Definition
Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.
Valid Values
Sample
UG
GP
GR
LW
|
VARCHAR2(63 CHAR)
|
|
|
|
STUDENT_LEVEL_DESC
|
Student_Level_Desc
|
Business Definition
Student level description.
Valid Values
Sample
Undergraduate
Graduate
CPS - Graduate
Law
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_CONCENTRATION
|
|
Business Definition
Concentration or study emphasis attached to the major for the student's academic study.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_CONCENTRATION_DESC
|
|
Business Definition
Concentration or study emphasis description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_DEPARTMENT
|
|
Business Definition
Department responsible for the major or subject area of academic instruction.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_DEPARTMENT_DESC
|
|
Business Definition
Department name.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MAJOR
|
|
Business Definition
Subject area or major focus recorded for the student's academic study. This may be blank.
|
VARCHAR2(63 CHAR)
|
|
|
|
THIRD_MAJOR_CONC_1
|
|
Business Definition
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
|
|
Business Definition
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MAJOR_CONC_2
|
|
Business Definition
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
|
|
Business Definition
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MAJOR_CONC_3
|
|
Business Definition
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
|
|
Business Definition
Student's concentration description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MAJOR_DESC
|
|
Business Definition
Major or subject area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_MINOR
|
|
Business Definition
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
|
|
Business Definition
Minor area of study description.
|
VARCHAR2(255 CHAR)
|
|
|
|
THIRD_PROGRAM_CLASSIFICATION
|
|
Business Definition
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
|
|
Business Definition
Program classification code description.
|
VARCHAR2(255 CHAR)
|
|
|
|
TRANSFER_WORK_EXISTS_IND
|
|
Business Definition
Indicates whether any transfer credits are recorded for the student that apply to this academic outcome.
Valid Values
Sample
Y
N
|
VARCHAR2(1 CHAR)
|
|
|
|
WHITE_IND
|
|
Business Definition
Indicates that the student has self-identified as being of a race categorized as White.
|
VARCHAR2(1 CHAR)
|
|
|
|