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_STUDENT_ACCTS_DAILY_VW - Student Accounts Daily

Description The view provides a daily view 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)      
ACADEMIC_PERIOD_DESC Academic_Term_Desc Description for Academic Period Nufreeze VARCHAR2(100)      
ACADEMIC_YEAR Academic_Year Academic year associated with academic Period Nufreeze VARCHAR2(63)      
ACADEMIC_YEAR_DESC Academic_Year_Desc Description for Academic Year VARCHAR2(255)      
ACCOUNT_1 Account_1 Identifies the type of revenue or expense used in the transaction VARCHAR2(63)      
ACCOUNT_2 Account_2 Identifies the type of revenue or expense used in the transaction VARCHAR2(63)      
ACCOUNT_3 Account_3 Identifies the type of revenue or expense used in the transaction VARCHAR2(63)      
ACCOUNT_4 Account_4 Identifies the type of revenue or expense used in the transaction VARCHAR2(63)      
ACCOUNT_5 Account_5__ Identifies the type of revenue or expense used in the transaction VARCHAR2(63)      
ACCOUNT_DESC_1 Account_Desc_1 Description of the revenue or expense value VARCHAR2(255)      
ACCOUNT_DESC_2 Account_Desc_2 Description of the revenue or expense value VARCHAR2(255)      
ACCOUNT_DESC_3 Account_Desc_3 Description of the revenue or expense value VARCHAR2(255)      
ACCOUNT_DESC_4 Account_Desc_4 Description of the revenue or expense value VARCHAR2(255)      
ACCOUNT_DESC_5 Account_Desc_5 Description of the revenue or expense value VARCHAR2(255)      
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)      
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)      
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)      
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)      
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)      
ACCOUNT_INDEX_DESC_1 Account_Index_Desc_1 Description of the index value VARCHAR2(255)      
ACCOUNT_INDEX_DESC_2 Account_Index_Desc_2 Description of the index value VARCHAR2(255)      
ACCOUNT_INDEX_DESC_3 Account_Index_Desc_3 Description of the index value VARCHAR2(255)      
ACCOUNT_INDEX_DESC_4 Account_Index_Desc_4 Description of the index value VARCHAR2(255)      
ACCOUNT_INDEX_DESC_5 Account_Index_Desc_5 Description of the index value VARCHAR2(255)      
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      
COHORT_1 Cohort_1 First Cohort tracking group assigned VARCHAR2(63)      
COHORT_1_DESC Cohort_1_Desc Description for Cohort 1 VARCHAR2(255)      
COLLEGE Student_College_Code This field identifies the college associated with the primary curriculum for the effective term.. VARCHAR2(63)      
COLLEGE_DESC Student_College_Desc Description for College VARCHAR2(63)      
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)      
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)      
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)      
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)      
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)      
DETAIL_CODE_DESC_1 Detail_Code_Desc_1 Description of the detail code value VARCHAR2(30)      
DETAIL_CODE_DESC_2 Detail_Code_Desc_2 Description of the detail code value VARCHAR2(30)      
DETAIL_CODE_DESC_3 Detail_Code_Desc_3 Description of the detail code value VARCHAR2(255)      
DETAIL_CODE_DESC_4 Detail_Code_Desc_4 Description of the detail code value VARCHAR2(255)      
DETAIL_CODE_DESC_5 Detail_Code_Desc_5 Description of the detail code value VARCHAR2(255)      
ENROLLMENT_STATUS Enrollment_Status Identifies student enrollment code VARCHAR2(63)      
ENROLLMENT_STATUS_DESC Enrollment_Status_Desc Description for student Enrollment Status VARCHAR2(255)      
FIRST_CONCENTRATION_1 First_Concentration_Code First concentration attached to the primary major. VARCHAR2(63)      
FIRST_CONCENTRATION_DESC_1 First_Concentration_Desc First Concentration Description VARCHAR2(255)      
FIRST_NAME First_Name The first name given to a person at birth, baptism, another naming ceremony or through legal change. VARCHAR2(63)      
FUND_1 Fund_1 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63)      
FUND_2 Fund_2 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63)      
FUND_3 Fund_3 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63)      
FUND_4 Fund_4 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63)      
FUND_5 Fund_5 Code that identifies a self-balancing unit that contains assets, liabilities and fund balance i.e. balance sheet VARCHAR2(63)      
FUND_DESC_1 Fund_Desc_1 Description of the Fund code VARCHAR2(255)      
FUND_DESC_2 Fund_Desc_2 Description of the Fund code VARCHAR2(255)      
FUND_DESC_3 Fund_Desc_3 Description of the Fund code VARCHAR2(255)      
FUND_DESC_4 Fund_Desc_4 Description of the Fund code VARCHAR2(255)      
FUND_DESC_5 Fund_Desc_5 Description of the Fund code VARCHAR2(255)      
GENDER Gender The gender of a person, e.g. Male, Female. VARCHAR2(10)      
GENDER_DESC Gender_Desc Description for Gender VARCHAR2(255)      
GRAD_YEAR_INTENDED Graduation_Year_Intended Intended year of graduation. VARCHAR2(63)      
GRAD_YEAR_INTENDED_DESC Graduation_Year_Intnd_Desc Description for Grad Year Intended VARCHAR2(255)      
ID Student_NUID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(9)      
LAST_NAME Last_Name The last name by which a person is known. VARCHAR2(63)      
MAJOR_DESC_NU1 Primary_Major_Desc Description for Major 1 VARCHAR2(255)      
MAJOR_NU1 Primary_Major_Code This field identifies the primary major within the primary curriculum for the effective term. VARCHAR2(63)      
MIDDLE_NAME Middle_Name A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change. VARCHAR2(63)      
ORGANIZATION_1 Organization_1 Unit of budgetary responsibility and or department VARCHAR2(63)      
ORGANIZATION_2 Organization_2 Unit of budgetary responsibility and or department VARCHAR2(63)      
ORGANIZATION_3 Organization_3 Unit of budgetary responsibility and or department VARCHAR2(63)      
ORGANIZATION_4 Organization_4_ Unit of budgetary responsibility and or department VARCHAR2(63)      
ORGANIZATION_5 Organization_5_ Unit of budgetary responsibility and or department VARCHAR2(63)      
ORGANIZATION_DESC_1 Organization_Desc_1 Description of the organization value VARCHAR2(255)      
ORGANIZATION_DESC_2 Organization_Desc_2 Description of the organization value VARCHAR2(255)      
ORGANIZATION_DESC_3 Organization_Desc_3 Description of the organization value VARCHAR2(255)      
ORGANIZATION_DESC_4 Organization_Desc_4 Description of the organization value VARCHAR2(255)      
ORGANIZATION_DESC_5 Organization_Desc_5 Description of the organization value VARCHAR2(255)      
PERSON_UID   System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER(8)      
PROGRAM_1 Program_1 Classification used for Financial Statement Reporting Purposes VARCHAR2(63)      
PROGRAM_2 Program_2 Classification used for Financial Statement Reporting Purposes VARCHAR2(63)      
PROGRAM_3 Program_3 Classification used for Financial Statement Reporting Purposes VARCHAR2(63)      
PROGRAM_4 Program_4 Classification used for Financial Statement Reporting Purposes VARCHAR2(63)      
PROGRAM_5 Program_5 Classification used for Financial Statement Reporting Purposes VARCHAR2(63)      
PROGRAM_DESC_1 Program_Desc_1 Description of the program value VARCHAR2(255)      
PROGRAM_DESC_2 Program_Desc_2 Description of the program value VARCHAR2(255)      
PROGRAM_DESC_3 Program_Desc_3 Description of the program value VARCHAR2(255)      
PROGRAM_DESC_4 Program_Desc_4 Description of the program value VARCHAR2(255)      
PROGRAM_DESC_5 Program_Desc_5 Description of the program value VARCHAR2(255)      
PROGRAM_DESC_NU1 Primary_Program_Desc Description for primary program. VARCHAR2(255)      
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)      
SECOND_CONCENTRATION_1 Second_Concentration_Code Second Concentration attached to the primary major. VARCHAR2(63)      
SECOND_CONCENTRATION_DESC_1 Second_Concentration_Desc__ Second Concentration Description VARCHAR2(255)      
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)      
STUDENT_LEVEL_DESC Student_Level_Desc Description for Student Level VARCHAR2(255)      
STUDENT_POPULATION Student_Population_Code This field identifies the student type for the effective term. VARCHAR2(255)      
STUDENT_POPULATION_DESC Student_Population_Desc Description for Student Population VARCHAR2(255)      
STUDENT_STATUS Student_Status_Code Student's current status for the academic period. May include active, inactive due to graduation, or withdrawal. VARCHAR2(63)      
STUDENT_STATUS_DESC Student_Status_Desc Description for Student Status VARCHAR2(255)      
THIRD_CONCENTRATION_1 Third_Concentration_Code Third Concentration VARCHAR2(63)      


Ver: 9.0