Reporting View Target: Z_NEU_CENSUS_STUDENT_ACCTS_VW

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Neu Student Accounts Reporting Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: Z_NEU_CENSUS_STUDENT_ACCTS_VW - Student Account Census

Description The view provides a snapshot of tuition revenue along with student data on a term basis

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACADEMIC_PERIOD Academic_Term Each currently active academic term according to events calendar. VARCHAR2(10 CHAR)

ACADEMIC_PERIOD_DESC Academic_Term_Desc Description for Academic Period Nufreeze VARCHAR2(100 CHAR)

ACADEMIC_YEAR Academic_Year Academic year associated with academic Period Nufreeze VARCHAR2(63 CHAR)

ACADEMIC_YEAR_DESC Academic_Year_Desc Description for Academic Year VARCHAR2(255 CHAR)

ACCOUNT_1 Account_1 Identifies the type of revenue or expense used in the transaction VARCHAR2(63 CHAR)

ACCOUNT_2 Account_2 Identifies the type of revenue or expense used in the transaction VARCHAR2(63 CHAR)

ACCOUNT_3 Account_3 Identifies the type of revenue or expense used in the transaction VARCHAR2(63 CHAR)

ACCOUNT_4 Account_4 Identifies the type of revenue or expense used in the transaction VARCHAR2(63 CHAR)

ACCOUNT_5 Account_5__ Identifies the type of revenue or expense used in the transaction VARCHAR2(63 CHAR)

ACCOUNT_DESC_1 Account_Desc_1 Description of the revenue or expense value VARCHAR2(255 CHAR)

ACCOUNT_DESC_2 Account_Desc_2 Description of the revenue or expense value VARCHAR2(255 CHAR)

ACCOUNT_DESC_3 Account_Desc_3 Description of the revenue or expense value VARCHAR2(255 CHAR)

ACCOUNT_DESC_4 Account_Desc_4 Description of the revenue or expense value VARCHAR2(255 CHAR)

ACCOUNT_DESC_5 Account_Desc_5 Description of the revenue or expense value VARCHAR2(255 CHAR)

ACCOUNT_INDEX_1 Account_Index_1 6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry VARCHAR2(63 CHAR)

ACCOUNT_INDEX_2 Account_Index_2 6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry VARCHAR2(63 CHAR)

ACCOUNT_INDEX_3 Account_Index_3 6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry VARCHAR2(63 CHAR)

ACCOUNT_INDEX_4 Account_Index_4 6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry VARCHAR2(63 CHAR)

ACCOUNT_INDEX_5 Account_Index_5 6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry VARCHAR2(63 CHAR)

ACCOUNT_INDEX_DESC_1 Account_Index_Desc_1 Description of the index value VARCHAR2(255 CHAR)

ACCOUNT_INDEX_DESC_2 Account_Index_Desc_2 Description of the index value VARCHAR2(255 CHAR)

ACCOUNT_INDEX_DESC_3 Account_Index_Desc_3 Description of the index value VARCHAR2(255 CHAR)

ACCOUNT_INDEX_DESC_4 Account_Index_Desc_4 Description of the index value VARCHAR2(255 CHAR)

ACCOUNT_INDEX_DESC_5 Account_Index_Desc_5 Description of the index value VARCHAR2(255 CHAR)

AMOUNT_TRANS_1 Amount_Trans_1 Total amount summed by detail code by term by student NUMBER(12,2)

AMOUNT_TRANS_2 Amount_Trans_2 Total amount summed by detail code by term by student NUMBER(12,2)

AMOUNT_TRANS_3 Amount_Trans_3 Total amount summed by detail code by term by student NUMBER(12,2)

AMOUNT_TRANS_4 Amount_Trans_4__ Total amount summed by detail code by term by student NUMBER(12,2)

AMOUNT_TRANS_5 Amount_Trans_5 Total amount summed by detail code by term by student NUMBER(12,2)

BIRTH_DATE BIRTH_DATE Date of birth of the person. DATE

CITIZENSHIP_TYPE Citizenship_Type_Ind Indicated whether the person has been identified as a citizen of the United States. VARCHAR2(63 CHAR) STVCITZ

CITIZENSHIP_TYPE_DESC Citizenship_Type_Ind_Desc__ Description for Citizenship Type VARCHAR2(255 CHAR)

COHORT_1 Cohort_1 First Cohort tracking group assigned VARCHAR2(63 CHAR)

COHORT_1_DESC Cohort_1_Desc Description for Cohort 1 VARCHAR2(255 CHAR)

COHORT_2 COHORT_2 Second Cohort tracking group assigned(currently athletic cohort only) VARCHAR2(63 CHAR)

COHORT_2_DESC Cohort_2_Desc Description for Cohort 2 VARCHAR2(255 CHAR)

COLLEGE Student_College_Code This field identifies the college associated with the primary curriculum for the effective term. VARCHAR2(63 CHAR)

COLLEGE_DESC Student_College_Desc Description for College VARCHAR2(63 CHAR)

CREDIT_EARNED Hours_Earned Overall Hours Earned for the level of course taken.(Student Cumulative earned hours(include transfer hours) NUMBER(11,3)

CURRENT_TIME_STATUS Attendance_Status This field identifies whether the student is a full or part-time student based on credit hours, student level. VARCHAR2(63 CHAR)

CURRENT_TIME_STATUS_DESC Attendance_Status_Desc Description for Attendance Status VARCHAR2(255 CHAR)

DEGREE Degree_Sought Degree or award code associated with the academic study. VARCHAR2(63 CHAR)

DEGREE_DESC Degree_Sought_Desc Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc VARCHAR2(255 CHAR)

DETAIL_CODE_1 Detail_Code_1 Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc VARCHAR2(4 CHAR)

DETAIL_CODE_2 Detail_Code_2 Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc VARCHAR2(4 CHAR)

DETAIL_CODE_3 Detail_Code_3 Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc VARCHAR2(4 CHAR)

DETAIL_CODE_4 Detail_Code_4 Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc VARCHAR2(4 CHAR)

DETAIL_CODE_5 Detail_Code_5 Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc VARCHAR2(4 CHAR)

DETAIL_CODE_DESC_1 Detail_Code_Desc_1 Description of the detail code value VARCHAR2(30 CHAR)

DETAIL_CODE_DESC_2 Detail_Code_Desc_2 Description of the detail code value VARCHAR2(30 CHAR)

DETAIL_CODE_DESC_3 Detail_Code_Desc_3 Description of the detail code value VARCHAR2(255 CHAR)

DETAIL_CODE_DESC_4 Detail_Code_Desc_4 Description of the detail code value VARCHAR2(255 CHAR)

DETAIL_CODE_DESC_5 Detail_Code_Desc_5 Description of the detail code value VARCHAR2(255 CHAR)

ELIGIBILITY_1 Sports_Eligibility_One Identifies the person is eligible to participate in an official sport. VARCHAR2(63 CHAR)

ELIGIBILITY_DESC_1 Sports_Eligibility_One_Desc Description for ELIGIBILITY_1 VARCHAR2(255 CHAR)

ENROLLMENT_STATUS Enrollment_Status Identifies student enrollment code VARCHAR2(63 CHAR)

ENROLLMENT_STATUS_DESC Enrollment_Status_Desc Description for student Enrollment Status VARCHAR2(255 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_1 First_Concentration_Code First concentration attached to the primary major. VARCHAR2(63 CHAR)

FIRST_CONCENTRATION_DESC_1 First_Concentration_Desc First Concentration Description VARCHAR2(255 CHAR)

FIRST_MAJOR_DESC_NU2 Primary_Maj_2nd_Curr_Desc Description for First Major 2 VARCHAR2(255 CHAR)

FIRST_MAJOR_NU2 Primary_Maj_2nd_Curr_Code This field identifies the primary major within the secondary curriculum for the effective term. VARCHAR2(63 CHAR)

FIRST_MINOR_DESC_NU1 First_Minor_Description Description for First Minor VARCHAR2(255 CHAR)

FIRST_MINOR_NU1 First_Minor_Code First Minor attached to a primary program VARCHAR2(63 CHAR)

FIRST_NAME First_Name The first name given to a person at birth, baptism, another naming ceremony or through legal change. VARCHAR2(63 CHAR)

FUND_1 Fund_1 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63 CHAR)

FUND_2 Fund_2 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63 CHAR)

FUND_3 Fund_3 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63 CHAR)

FUND_4 Fund_4 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63 CHAR)

FUND_5 Fund_5 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63 CHAR)

FUND_DESC_1 Fund_Desc_1 Description of the Fund code VARCHAR2(255 CHAR)

FUND_DESC_2 Fund_Desc_2 Description of the Fund code VARCHAR2(255 CHAR)

FUND_DESC_3 Fund_Desc_3 Description of the Fund code VARCHAR2(255 CHAR)

FUND_DESC_4 Fund_Desc_4 Description of the Fund code VARCHAR2(255 CHAR)

FUND_DESC_5 Fund_Desc_5 Description of the Fund code VARCHAR2(255 CHAR)

GENDER Gender The gender of a person, e.g. Male, Female. VARCHAR2(63 CHAR)

GENDER_DESC Gender_Desc Description for Gender VARCHAR2(255 CHAR)

GPA GPA_for_Level GPA for the level. Calculated by dividing quality points by GPA credit hours for the level of course taken. NUMBER(11,3)

GPA_CREDITS GPA_Hours_for_Level Hours used to compute student's GPA per level of course taken NUMBER(11,3)

GRAD_YEAR_INTENDED Graduation_Year_Intended Intended year of graduation. VARCHAR2(63 CHAR)

GRAD_YEAR_INTENDED_DESC Graduation_Year_Intnd_Desc Description for Grad Year Intended VARCHAR2(255 CHAR)

HIGH_SCHOOL_CODE High_School_Code Students high school code VARCHAR2(63 CHAR)

HOLD_DESC_NU1 Hold_One_Desc Description for function responsible for hold. VARCHAR2(255 CHAR)

HOLD_DESC_NU2 Hold_Two_Desc Description for function responsible for hold. VARCHAR2(255 CHAR)

HOLD_DESC_NU3 Hold_Three_Description Description for function responsible for hold. VARCHAR2(255 CHAR)

HOLD_DESC_NU4 Hold_Four_Desc__ Description for function responsible for hold. VARCHAR2(255 CHAR)

HOLD_DESC_NU5 Hold_Five_Desc Description for function responsible for hold. VARCHAR2(255 CHAR)

HOLD_NU1 Hold_One Function responsible for hold. VARCHAR2(63 CHAR)

HOLD_NU2 Hold_Two Function responsible for hold. VARCHAR2(63 CHAR)

HOLD_NU3 Hold_Three_ Function responsible for hold. VARCHAR2(63 CHAR)

HOLD_NU4 Hold_Four Function responsible for hold. VARCHAR2(63 CHAR)

HOLD_NU5 Hold_Five Function responsible for hold. VARCHAR2(63 CHAR)

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)

LAST_NAME Last_Name The last name by which a person is known. VARCHAR2(63 CHAR)

LEAVE_REASON Leave_Reason Leave code of the student for this academic period. VARCHAR2(63 CHAR)

LEAVE_REASON_DESC Leave_Reason_Desc Description for Leave Reason VARCHAR2(255 CHAR)

MAJOR_DESC_NU1 Primary_Major_Desc Description for Major 1 VARCHAR2(255 CHAR)

MAJOR_NU1 Primary_Major_Code This field identifies the primary major within the primary curriculum for the effective term. VARCHAR2(63 CHAR)

MIDDLE_NAME Middle_Name A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change. VARCHAR2(63 CHAR)

NATION_OF_CITIZENSHIP Nation_of_Citizenship First country code of the nation where the person maintains citizenship. VARCHAR2(63 CHAR)

NATION_OF_CITIZENSHIP_DESC Nation_of_Citizenship_Desc Description for Nation Of Citizenship VARCHAR2(255 CHAR)

NEW_STUDENT_IND New_Student_Indicator Indicates that this is the first academic period for the student and they are a new admit to the institution. VARCHAR2(63 CHAR)

ORGANIZATION_1 Organization_1 Unit of budgetary responsibility and or department VARCHAR2(63 CHAR)

ORGANIZATION_2 Organization_2_ Unit of budgetary responsibility and or department VARCHAR2(63 CHAR)

ORGANIZATION_3 Organization_3 Unit of budgetary responsibility and or department VARCHAR2(63 CHAR)

ORGANIZATION_4 Organization_4_ Unit of budgetary responsibility and or department VARCHAR2(63 CHAR)

ORGANIZATION_5 Organization_5_ Unit of budgetary responsibility and or department VARCHAR2(63 CHAR)

ORGANIZATION_DESC_1 Organization_1_Desc Description of the organization value VARCHAR2(255 CHAR)

ORGANIZATION_DESC_2 Organization_Desc_2 Description of the organization value VARCHAR2(255 CHAR)

ORGANIZATION_DESC_3 Organization_Desc_3 Description of the organization value VARCHAR2(255 CHAR)

ORGANIZATION_DESC_4 Organization_Desc_4 Description of the organization value VARCHAR2(255 CHAR)

ORGANIZATION_DESC_5 Organization_Desc_5 Description of the organization value VARCHAR2(255 CHAR)

PERSON_UID System generated, unique, internal identification number assigned to the person. NUMBER(8)

PRIMARY_ETHNICITY Primary_Ethnicity This field identifies the ethnic code defined as one of defined by NU. Prior to Fall 2010. VARCHAR2(63 CHAR)

PRIMARY_ETHNICITY_DESC Primary_Ethnicity_Desc Description for Primary Ethnicity. VARCHAR2(255 CHAR)

PROGRAM_1 Program_1 Classification used for Financial Statement Reporting Purposes VARCHAR2(63 CHAR)

PROGRAM_2 Program_2 Classification used for Financial Statement Reporting Purposes VARCHAR2(63 CHAR)

PROGRAM_3 Program_3 Classification used for Financial Statement Reporting Purposes VARCHAR2(63 CHAR)

PROGRAM_4 Program_4 Classification used for Financial Statement Reporting Purposes VARCHAR2(63 CHAR)

PROGRAM_5 Program_5 Classification used for Financial Statement Reporting Purposes VARCHAR2(63 CHAR)

PROGRAM_DESC_1 Program_Desc_1 Description of the program value VARCHAR2(255 CHAR)

PROGRAM_DESC_2 Program_Desc_2 Description of the program value VARCHAR2(255 CHAR)

PROGRAM_DESC_3 Program_Desc_3 Description of the program value VARCHAR2(255 CHAR)

PROGRAM_DESC_4 Program_Desc_4 Description of the program value VARCHAR2(255 CHAR)

PROGRAM_DESC_5 Program_Desc_5 Description of the program value VARCHAR2(255 CHAR)

PROGRAM_DESC_NU1 Primary_Program_Desc Description for primary program. VARCHAR2(255 CHAR)

PROGRAM_DESC_NU2 Secondary_Program_Desc Description for Program 2 VARCHAR2(255 CHAR)

PROGRAM_NU1 Primary_Program_Code Classification of academic breakdown defined as a primary combination of program, student level, course, degree, and level. May also contain majors, minors, and concentrations. VARCHAR2(63 CHAR)

PROGRAM_NU2 Secondary_Program_Code Classification of academic breakdown defined as a secondary combination of program, student level, course, degree, and level. May also contain majors, minors, and concentrations. VARCHAR2(63 CHAR)

QUALITY_POINTS Quality_Points Total number of points per course level NUMBER(11,3)

REGISTERED_IND Registered_Indicator Flag that indicates student is registered in at least one term VARCHAR2(1 CHAR)

SECOND_CONCENTRATION_1 Second_Concentration_Code Second Concentration attached to the primary major. VARCHAR2(63 CHAR)

SECOND_CONCENTRATION_DESC_1 Second_Concentration_Desc__ Second Concentration Description VARCHAR2(255 CHAR)

SECOND_MINOR_DESC_NU1 Second_Minor_Description Description for Second Minor VARCHAR2(255 CHAR)

SECOND_MINOR_NU1 Second_Minor_Code Second Minor attached to a primary program VARCHAR2(63 CHAR)

SNAPSHOT_FREEZE_DATE Freeze_Date actual date the data was frozen DATE

STUDENT_ATTRIBUTE_DESC_NU1 Student_Attribute_One_Desc Description for Student Attribute Nu1 VARCHAR2(255 CHAR)

STUDENT_ATTRIBUTE_DESC_NU2 Student_Attribute_Two_Desc Description for Student Attribute Nu2 VARCHAR2(255 CHAR)

STUDENT_ATTRIBUTE_DESC_NU3 Student_Attribute_Three_Desc Description for Student Attribute Nu3 VARCHAR2(255 CHAR)

STUDENT_ATTRIBUTE_DESC_NU4 Student_Attribute_Four_Desc Description for Student Attribute Nu4 VARCHAR2(255 CHAR)

STUDENT_ATTRIBUTE_NU1 Student_Attribute_One Identifies a student first attribute to be tracked for the person and used for reporting groups of students timely correlated with student record VARCHAR2(63 CHAR)

STUDENT_ATTRIBUTE_NU2 Student_Attribute_Two_ Identifies a student second attribute to be tracked for the person and used for reporting groups of students timely correlated with student record VARCHAR2(63 CHAR)

STUDENT_ATTRIBUTE_NU3 Student_Attribute_Three Identifies a student third attribute to be tracked for the person and used for reporting groups of students timely correlated with student record VARCHAR2(63 CHAR)

STUDENT_ATTRIBUTE_NU4 Student_Attribute_Four Identifies a student forth attribute to be tracked for the person and used for reporting groups of students timely correlated with student record VARCHAR2(63 CHAR)

STUDENT_CLASSIFICATION Student_Classification_Code Identifies the student classification (i.e. year in school) after grades have been processed for this academic period. For example, first year, second year or freshman, sophomore, etc. Derived from number of credits completed including transfer credits. VARCHAR2(63 CHAR)

STUDENT_CLASSIFICATION_DESC Student_Classification_Desc Description for student classification VARCHAR2(255 CHAR)

STUDENT_DEPARTMENT_CODE Student_Department_Code Department responsible for the student's academic study. VARCHAR2(63 CHAR)

STUDENT_DEPARTMENT_DESC Student_Department_Desc Student Department name. VARCHAR2(255 CHAR)

STUDENT_LEVEL Student_Level_Code This field identifies the level of the student for the effective term as one of CP(Continuing Education CPS), UP(CPS - Undergraduate), GP(CPS - Graduate), UG(Undergraduate Day), GR(Graduate Day), LW(Law) VARCHAR2(63 CHAR)

STUDENT_LEVEL_DESC Student_Level_Desc Description for Student Level VARCHAR2(255 CHAR)

STUDENT_POPULATION Student_Population_Code This field identifies the student type for the effective term. VARCHAR2(255 CHAR)

STUDENT_POPULATION_DESC Student_Population_Desc Description for Student Population VARCHAR2(255 CHAR)

STUDENT_RESIDENCY Student_Residency_Code Residency of the student as one of full-time, full-time international, part-time, part-time international. VARCHAR2(63 CHAR)

STUDENT_RESIDENCY_DESC Student_Residency_Desc Description for Student Residency VARCHAR2(255 CHAR)

STUDENT_STATUS Student_Status_Code Student's current status for the academic period. May include active, inactive due to graduation or withdrawal. VARCHAR2(63 CHAR)

STUDENT_STATUS_DESC Student_Status_Desc Description for Student Status VARCHAR2(255 CHAR)

THIRD_CONCENTRATION_1 Third_Concentration_Code Third Concentration VARCHAR2(63 CHAR)

THIRD_CONCENTRATION_DESC_1 Third_Concentration_Desc Third Concentration Description VARCHAR2(255 CHAR)

TRANSFER_CREDIT_EARNED Transfer_Credit_Hours_Earned Transfer credit hours earned with another institution. NUMBER(11,3)

VISA_TYPE Visa_Type Most current visa type recorded for the academic period. Selection is made based on the start date and end date being within the academic period for this record. VARCHAR2(63 CHAR)

VISA_TYPE_DESC Visa_Type_Desc Description for Visa Type VARCHAR2(255 CHAR)

WITHDRAWAL_REASON_DESC_NEU Withdrawal_Reason_Desc Description for Withdrawal Reason NEU VARCHAR2(255 CHAR)

WITHDRAWAL_REASON_NEU Withdrawal_Reason Student's withdrawal reason VARCHAR2(63 CHAR)

Ver: 9.0

Target Column	Business Name	Business Definition	Database Data Type	Domain Value
ACADEMIC_PERIOD	Academic_Term	Each currently active academic term according to events calendar.	VARCHAR2(10 CHAR)
ACADEMIC_PERIOD_DESC	Academic_Term_Desc	Description for Academic Period Nufreeze	VARCHAR2(100 CHAR)
ACADEMIC_YEAR	Academic_Year	Academic year associated with academic Period Nufreeze	VARCHAR2(63 CHAR)
ACADEMIC_YEAR_DESC	Academic_Year_Desc	Description for Academic Year	VARCHAR2(255 CHAR)
ACCOUNT_1	Account_1	Identifies the type of revenue or expense used in the transaction	VARCHAR2(63 CHAR)
ACCOUNT_2	Account_2	Identifies the type of revenue or expense used in the transaction	VARCHAR2(63 CHAR)
ACCOUNT_3	Account_3	Identifies the type of revenue or expense used in the transaction	VARCHAR2(63 CHAR)
ACCOUNT_4	Account_4	Identifies the type of revenue or expense used in the transaction	VARCHAR2(63 CHAR)
ACCOUNT_5	Account_5__	Identifies the type of revenue or expense used in the transaction	VARCHAR2(63 CHAR)
ACCOUNT_DESC_1	Account_Desc_1	Description of the revenue or expense value	VARCHAR2(255 CHAR)
ACCOUNT_DESC_2	Account_Desc_2	Description of the revenue or expense value	VARCHAR2(255 CHAR)
ACCOUNT_DESC_3	Account_Desc_3	Description of the revenue or expense value	VARCHAR2(255 CHAR)
ACCOUNT_DESC_4	Account_Desc_4	Description of the revenue or expense value	VARCHAR2(255 CHAR)
ACCOUNT_DESC_5	Account_Desc_5	Description of the revenue or expense value	VARCHAR2(255 CHAR)
ACCOUNT_INDEX_1	Account_Index_1	6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry	VARCHAR2(63 CHAR)
ACCOUNT_INDEX_2	Account_Index_2	6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry	VARCHAR2(63 CHAR)
ACCOUNT_INDEX_3	Account_Index_3	6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry	VARCHAR2(63 CHAR)
ACCOUNT_INDEX_4	Account_Index_4	6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry	VARCHAR2(63 CHAR)
ACCOUNT_INDEX_5	Account_Index_5	6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry	VARCHAR2(63 CHAR)
ACCOUNT_INDEX_DESC_1	Account_Index_Desc_1	Description of the index value	VARCHAR2(255 CHAR)
ACCOUNT_INDEX_DESC_2	Account_Index_Desc_2	Description of the index value	VARCHAR2(255 CHAR)
ACCOUNT_INDEX_DESC_3	Account_Index_Desc_3	Description of the index value	VARCHAR2(255 CHAR)
ACCOUNT_INDEX_DESC_4	Account_Index_Desc_4	Description of the index value	VARCHAR2(255 CHAR)
ACCOUNT_INDEX_DESC_5	Account_Index_Desc_5	Description of the index value	VARCHAR2(255 CHAR)
AMOUNT_TRANS_1	Amount_Trans_1	Total amount summed by detail code by term by student	NUMBER(12,2)
AMOUNT_TRANS_2	Amount_Trans_2	Total amount summed by detail code by term by student	NUMBER(12,2)
AMOUNT_TRANS_3	Amount_Trans_3	Total amount summed by detail code by term by student	NUMBER(12,2)
AMOUNT_TRANS_4	Amount_Trans_4__	Total amount summed by detail code by term by student	NUMBER(12,2)
AMOUNT_TRANS_5	Amount_Trans_5	Total amount summed by detail code by term by student	NUMBER(12,2)
BIRTH_DATE	BIRTH_DATE	Date of birth of the person.	DATE
CITIZENSHIP_TYPE	Citizenship_Type_Ind	Indicated whether the person has been identified as a citizen of the United States.	VARCHAR2(63 CHAR)	STVCITZ
CITIZENSHIP_TYPE_DESC	Citizenship_Type_Ind_Desc__	Description for Citizenship Type	VARCHAR2(255 CHAR)
COHORT_1	Cohort_1	First Cohort tracking group assigned	VARCHAR2(63 CHAR)
COHORT_1_DESC	Cohort_1_Desc	Description for Cohort 1	VARCHAR2(255 CHAR)
COHORT_2	COHORT_2	Second Cohort tracking group assigned(currently athletic cohort only)	VARCHAR2(63 CHAR)
COHORT_2_DESC	Cohort_2_Desc	Description for Cohort 2	VARCHAR2(255 CHAR)
COLLEGE	Student_College_Code	This field identifies the college associated with the primary curriculum for the effective term.	VARCHAR2(63 CHAR)
COLLEGE_DESC	Student_College_Desc	Description for College	VARCHAR2(63 CHAR)
CREDIT_EARNED	Hours_Earned	Overall Hours Earned for the level of course taken.(Student Cumulative earned hours(include transfer hours)	NUMBER(11,3)
CURRENT_TIME_STATUS	Attendance_Status	This field identifies whether the student is a full or part-time student based on credit hours, student level.	VARCHAR2(63 CHAR)
CURRENT_TIME_STATUS_DESC	Attendance_Status_Desc	Description for Attendance Status	VARCHAR2(255 CHAR)
DEGREE	Degree_Sought	Degree or award code associated with the academic study.	VARCHAR2(63 CHAR)
DEGREE_DESC	Degree_Sought_Desc	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc	VARCHAR2(255 CHAR)
DETAIL_CODE_1	Detail_Code_1	Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc	VARCHAR2(4 CHAR)
DETAIL_CODE_2	Detail_Code_2	Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc	VARCHAR2(4 CHAR)
DETAIL_CODE_3	Detail_Code_3	Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc	VARCHAR2(4 CHAR)
DETAIL_CODE_4	Detail_Code_4	Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc	VARCHAR2(4 CHAR)
DETAIL_CODE_5	Detail_Code_5	Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, Housing, Meals, etc	VARCHAR2(4 CHAR)
DETAIL_CODE_DESC_1	Detail_Code_Desc_1	Description of the detail code value	VARCHAR2(30 CHAR)
DETAIL_CODE_DESC_2	Detail_Code_Desc_2	Description of the detail code value	VARCHAR2(30 CHAR)
DETAIL_CODE_DESC_3	Detail_Code_Desc_3	Description of the detail code value	VARCHAR2(255 CHAR)
DETAIL_CODE_DESC_4	Detail_Code_Desc_4	Description of the detail code value	VARCHAR2(255 CHAR)
DETAIL_CODE_DESC_5	Detail_Code_Desc_5	Description of the detail code value	VARCHAR2(255 CHAR)
ELIGIBILITY_1	Sports_Eligibility_One	Identifies the person is eligible to participate in an official sport.	VARCHAR2(63 CHAR)
ELIGIBILITY_DESC_1	Sports_Eligibility_One_Desc	Description for ELIGIBILITY_1	VARCHAR2(255 CHAR)
ENROLLMENT_STATUS	Enrollment_Status	Identifies student enrollment code	VARCHAR2(63 CHAR)
ENROLLMENT_STATUS_DESC	Enrollment_Status_Desc	Description for student Enrollment Status	VARCHAR2(255 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_1	First_Concentration_Code	First concentration attached to the primary major.	VARCHAR2(63 CHAR)
FIRST_CONCENTRATION_DESC_1	First_Concentration_Desc	First Concentration Description	VARCHAR2(255 CHAR)
FIRST_MAJOR_DESC_NU2	Primary_Maj_2nd_Curr_Desc	Description for First Major 2	VARCHAR2(255 CHAR)
FIRST_MAJOR_NU2	Primary_Maj_2nd_Curr_Code	This field identifies the primary major within the secondary curriculum for the effective term.	VARCHAR2(63 CHAR)
FIRST_MINOR_DESC_NU1	First_Minor_Description	Description for First Minor	VARCHAR2(255 CHAR)
FIRST_MINOR_NU1	First_Minor_Code	First Minor attached to a primary program	VARCHAR2(63 CHAR)
FIRST_NAME	First_Name	The first name given to a person at birth, baptism, another naming ceremony or through legal change.	VARCHAR2(63 CHAR)
FUND_1	Fund_1	Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet	VARCHAR2(63 CHAR)
FUND_2	Fund_2	Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet	VARCHAR2(63 CHAR)
FUND_3	Fund_3	Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet	VARCHAR2(63 CHAR)
FUND_4	Fund_4	Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet	VARCHAR2(63 CHAR)
FUND_5	Fund_5	Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet	VARCHAR2(63 CHAR)
FUND_DESC_1	Fund_Desc_1	Description of the Fund code	VARCHAR2(255 CHAR)
FUND_DESC_2	Fund_Desc_2	Description of the Fund code	VARCHAR2(255 CHAR)
FUND_DESC_3	Fund_Desc_3	Description of the Fund code	VARCHAR2(255 CHAR)
FUND_DESC_4	Fund_Desc_4	Description of the Fund code	VARCHAR2(255 CHAR)
FUND_DESC_5	Fund_Desc_5	Description of the Fund code	VARCHAR2(255 CHAR)
GENDER	Gender	The gender of a person, e.g. Male, Female.	VARCHAR2(63 CHAR)
GENDER_DESC	Gender_Desc	Description for Gender	VARCHAR2(255 CHAR)
GPA	GPA_for_Level	GPA for the level. Calculated by dividing quality points by GPA credit hours for the level of course taken.	NUMBER(11,3)
GPA_CREDITS	GPA_Hours_for_Level	Hours used to compute student's GPA per level of course taken	NUMBER(11,3)
GRAD_YEAR_INTENDED	Graduation_Year_Intended	Intended year of graduation.	VARCHAR2(63 CHAR)
GRAD_YEAR_INTENDED_DESC	Graduation_Year_Intnd_Desc	Description for Grad Year Intended	VARCHAR2(255 CHAR)
HIGH_SCHOOL_CODE	High_School_Code	Students high school code	VARCHAR2(63 CHAR)
HOLD_DESC_NU1	Hold_One_Desc	Description for function responsible for hold.	VARCHAR2(255 CHAR)
HOLD_DESC_NU2	Hold_Two_Desc	Description for function responsible for hold.	VARCHAR2(255 CHAR)
HOLD_DESC_NU3	Hold_Three_Description	Description for function responsible for hold.	VARCHAR2(255 CHAR)
HOLD_DESC_NU4	Hold_Four_Desc__	Description for function responsible for hold.	VARCHAR2(255 CHAR)
HOLD_DESC_NU5	Hold_Five_Desc	Description for function responsible for hold.	VARCHAR2(255 CHAR)
HOLD_NU1	Hold_One	Function responsible for hold.	VARCHAR2(63 CHAR)
HOLD_NU2	Hold_Two	Function responsible for hold.	VARCHAR2(63 CHAR)
HOLD_NU3	Hold_Three_	Function responsible for hold.	VARCHAR2(63 CHAR)
HOLD_NU4	Hold_Four	Function responsible for hold.	VARCHAR2(63 CHAR)
HOLD_NU5	Hold_Five	Function responsible for hold.	VARCHAR2(63 CHAR)
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)
LAST_NAME	Last_Name	The last name by which a person is known.	VARCHAR2(63 CHAR)
LEAVE_REASON	Leave_Reason	Leave code of the student for this academic period.	VARCHAR2(63 CHAR)
LEAVE_REASON_DESC	Leave_Reason_Desc	Description for Leave Reason	VARCHAR2(255 CHAR)
MAJOR_DESC_NU1	Primary_Major_Desc	Description for Major 1	VARCHAR2(255 CHAR)
MAJOR_NU1	Primary_Major_Code	This field identifies the primary major within the primary curriculum for the effective term.	VARCHAR2(63 CHAR)
MIDDLE_NAME	Middle_Name	A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change.	VARCHAR2(63 CHAR)
NATION_OF_CITIZENSHIP	Nation_of_Citizenship	First country code of the nation where the person maintains citizenship.	VARCHAR2(63 CHAR)
NATION_OF_CITIZENSHIP_DESC	Nation_of_Citizenship_Desc	Description for Nation Of Citizenship	VARCHAR2(255 CHAR)
NEW_STUDENT_IND	New_Student_Indicator	Indicates that this is the first academic period for the student and they are a new admit to the institution.	VARCHAR2(63 CHAR)
ORGANIZATION_1	Organization_1	Unit of budgetary responsibility and or department	VARCHAR2(63 CHAR)
ORGANIZATION_2	Organization_2_	Unit of budgetary responsibility and or department	VARCHAR2(63 CHAR)
ORGANIZATION_3	Organization_3	Unit of budgetary responsibility and or department	VARCHAR2(63 CHAR)
ORGANIZATION_4	Organization_4_	Unit of budgetary responsibility and or department	VARCHAR2(63 CHAR)
ORGANIZATION_5	Organization_5_	Unit of budgetary responsibility and or department	VARCHAR2(63 CHAR)
ORGANIZATION_DESC_1	Organization_1_Desc	Description of the organization value	VARCHAR2(255 CHAR)
ORGANIZATION_DESC_2	Organization_Desc_2	Description of the organization value	VARCHAR2(255 CHAR)
ORGANIZATION_DESC_3	Organization_Desc_3	Description of the organization value	VARCHAR2(255 CHAR)
ORGANIZATION_DESC_4	Organization_Desc_4	Description of the organization value	VARCHAR2(255 CHAR)
ORGANIZATION_DESC_5	Organization_Desc_5	Description of the organization value	VARCHAR2(255 CHAR)
PERSON_UID		System generated, unique, internal identification number assigned to the person.	NUMBER(8)
PRIMARY_ETHNICITY	Primary_Ethnicity	This field identifies the ethnic code defined as one of defined by NU. Prior to Fall 2010.	VARCHAR2(63 CHAR)
PRIMARY_ETHNICITY_DESC	Primary_Ethnicity_Desc	Description for Primary Ethnicity.	VARCHAR2(255 CHAR)
PROGRAM_1	Program_1	Classification used for Financial Statement Reporting Purposes	VARCHAR2(63 CHAR)
PROGRAM_2	Program_2	Classification used for Financial Statement Reporting Purposes	VARCHAR2(63 CHAR)
PROGRAM_3	Program_3	Classification used for Financial Statement Reporting Purposes	VARCHAR2(63 CHAR)
PROGRAM_4	Program_4	Classification used for Financial Statement Reporting Purposes	VARCHAR2(63 CHAR)
PROGRAM_5	Program_5	Classification used for Financial Statement Reporting Purposes	VARCHAR2(63 CHAR)
PROGRAM_DESC_1	Program_Desc_1	Description of the program value	VARCHAR2(255 CHAR)
PROGRAM_DESC_2	Program_Desc_2	Description of the program value	VARCHAR2(255 CHAR)
PROGRAM_DESC_3	Program_Desc_3	Description of the program value	VARCHAR2(255 CHAR)
PROGRAM_DESC_4	Program_Desc_4	Description of the program value	VARCHAR2(255 CHAR)
PROGRAM_DESC_5	Program_Desc_5	Description of the program value	VARCHAR2(255 CHAR)
PROGRAM_DESC_NU1	Primary_Program_Desc	Description for primary program.	VARCHAR2(255 CHAR)
PROGRAM_DESC_NU2	Secondary_Program_Desc	Description for Program 2	VARCHAR2(255 CHAR)
PROGRAM_NU1	Primary_Program_Code	Classification of academic breakdown defined as a primary combination of program, student level, course, degree, and level. May also contain majors, minors, and concentrations.	VARCHAR2(63 CHAR)
PROGRAM_NU2	Secondary_Program_Code	Classification of academic breakdown defined as a secondary combination of program, student level, course, degree, and level. May also contain majors, minors, and concentrations.	VARCHAR2(63 CHAR)
QUALITY_POINTS	Quality_Points	Total number of points per course level	NUMBER(11,3)
REGISTERED_IND	Registered_Indicator	Flag that indicates student is registered in at least one term	VARCHAR2(1 CHAR)
SECOND_CONCENTRATION_1	Second_Concentration_Code	Second Concentration attached to the primary major.	VARCHAR2(63 CHAR)
SECOND_CONCENTRATION_DESC_1	Second_Concentration_Desc__	Second Concentration Description	VARCHAR2(255 CHAR)
SECOND_MINOR_DESC_NU1	Second_Minor_Description	Description for Second Minor	VARCHAR2(255 CHAR)
SECOND_MINOR_NU1	Second_Minor_Code	Second Minor attached to a primary program	VARCHAR2(63 CHAR)
SNAPSHOT_FREEZE_DATE	Freeze_Date	actual date the data was frozen	DATE
STUDENT_ATTRIBUTE_DESC_NU1	Student_Attribute_One_Desc	Description for Student Attribute Nu1	VARCHAR2(255 CHAR)
STUDENT_ATTRIBUTE_DESC_NU2	Student_Attribute_Two_Desc	Description for Student Attribute Nu2	VARCHAR2(255 CHAR)
STUDENT_ATTRIBUTE_DESC_NU3	Student_Attribute_Three_Desc	Description for Student Attribute Nu3	VARCHAR2(255 CHAR)
STUDENT_ATTRIBUTE_DESC_NU4	Student_Attribute_Four_Desc	Description for Student Attribute Nu4	VARCHAR2(255 CHAR)
STUDENT_ATTRIBUTE_NU1	Student_Attribute_One	Identifies a student first attribute to be tracked for the person and used for reporting groups of students timely correlated with student record	VARCHAR2(63 CHAR)
STUDENT_ATTRIBUTE_NU2	Student_Attribute_Two_	Identifies a student second attribute to be tracked for the person and used for reporting groups of students timely correlated with student record	VARCHAR2(63 CHAR)
STUDENT_ATTRIBUTE_NU3	Student_Attribute_Three	Identifies a student third attribute to be tracked for the person and used for reporting groups of students timely correlated with student record	VARCHAR2(63 CHAR)
STUDENT_ATTRIBUTE_NU4	Student_Attribute_Four	Identifies a student forth attribute to be tracked for the person and used for reporting groups of students timely correlated with student record	VARCHAR2(63 CHAR)
STUDENT_CLASSIFICATION	Student_Classification_Code	Identifies the student classification (i.e. year in school) after grades have been processed for this academic period. For example, first year, second year or freshman, sophomore, etc. Derived from number of credits completed including transfer credits.	VARCHAR2(63 CHAR)
STUDENT_CLASSIFICATION_DESC	Student_Classification_Desc	Description for student classification	VARCHAR2(255 CHAR)
STUDENT_DEPARTMENT_CODE	Student_Department_Code	Department responsible for the student's academic study.	VARCHAR2(63 CHAR)
STUDENT_DEPARTMENT_DESC	Student_Department_Desc	Student Department name.	VARCHAR2(255 CHAR)
STUDENT_LEVEL	Student_Level_Code	This field identifies the level of the student for the effective term as one of CP(Continuing Education CPS), UP(CPS - Undergraduate), GP(CPS - Graduate), UG(Undergraduate Day), GR(Graduate Day), LW(Law)	VARCHAR2(63 CHAR)
STUDENT_LEVEL_DESC	Student_Level_Desc	Description for Student Level	VARCHAR2(255 CHAR)
STUDENT_POPULATION	Student_Population_Code	This field identifies the student type for the effective term.	VARCHAR2(255 CHAR)
STUDENT_POPULATION_DESC	Student_Population_Desc	Description for Student Population	VARCHAR2(255 CHAR)
STUDENT_RESIDENCY	Student_Residency_Code	Residency of the student as one of full-time, full-time international, part-time, part-time international.	VARCHAR2(63 CHAR)
STUDENT_RESIDENCY_DESC	Student_Residency_Desc	Description for Student Residency	VARCHAR2(255 CHAR)
STUDENT_STATUS	Student_Status_Code	Student's current status for the academic period. May include active, inactive due to graduation or withdrawal.	VARCHAR2(63 CHAR)
STUDENT_STATUS_DESC	Student_Status_Desc	Description for Student Status	VARCHAR2(255 CHAR)
THIRD_CONCENTRATION_1	Third_Concentration_Code	Third Concentration	VARCHAR2(63 CHAR)
THIRD_CONCENTRATION_DESC_1	Third_Concentration_Desc	Third Concentration Description	VARCHAR2(255 CHAR)
TRANSFER_CREDIT_EARNED	Transfer_Credit_Hours_Earned	Transfer credit hours earned with another institution.	NUMBER(11,3)
VISA_TYPE	Visa_Type	Most current visa type recorded for the academic period. Selection is made based on the start date and end date being within the academic period for this record.	VARCHAR2(63 CHAR)
VISA_TYPE_DESC	Visa_Type_Desc	Description for Visa Type	VARCHAR2(255 CHAR)
WITHDRAWAL_REASON_DESC_NEU	Withdrawal_Reason_Desc	Description for Withdrawal Reason NEU	VARCHAR2(255 CHAR)
WITHDRAWAL_REASON_NEU	Withdrawal_Reason	Student's withdrawal reason	VARCHAR2(63 CHAR)