Reporting View Target: Z_NEU_COLLEGE_FINAID

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Neu Financial Aid Reporting Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: Z_NEU_COLLEGE_FINAID_VW

Description View shows accounts receivable disbursement transactions for each student based on fund, sourced from Banner AR.

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

ACADEMIC_PERIOD_NUFREEZE ACADEMIC_PERIOD_NUFREEZE Academic term describes when course/class data was frozen corresponding to event in academic calendar (defined by student level). VARCHAR2(10 CHAR)

ACADEMIC_PERIOD_NUFREEZE_DESC ACADEMIC_PERIOD_NUFREEZE_DESC Description for Academic Term Code VARCHAR2(255 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(63 CHAR)

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

AMOUNT_TRANS AMOUNT_TRANS Total amount summed by detail code by term by student NUMBER

A_ACCOUNT A_ACCOUNT Identifies the type of revenue or expense used in the transaction VARCHAR2(6 CHAR)

A_ACCOUNT_DESC A_ACCOUNT_DESC Description of the A_Account VARCHAR2(255 CHAR)

A_FUND A_FUND Funds are 6 digit codes that represent a source of funding. The first digit of the fund code will identify the type of fund: 2xxxxx = Current Fund 3xxxxx = Designated 4xxxxx = Endowment 5xxxxx = Grants & Contracts 6xxxxx = Restricted 7xxxxx = Plant Funds 8xxxxx = SABO VARCHAR2(6 CHAR)

A_FUND_DESC A_FUND_DESC Description of the Fund code VARCHAR2(255 CHAR)

A_ORGANIZATION A_ORGANIZATION The organization code identifies a unit of budgetary responsibility and/or departments within an institution. Organizations are 6 digit codes that always begin with the number 1. VARCHAR2(6 CHAR)

A_ORGANIZATION_DESC A_ORGANIZATION_DESC Description of the organization value VARCHAR2(255 CHAR)

A_PROGRAM A_PROGRAM Programs are four digit codes used for financial statement purposes. VARCHAR2(6 CHAR)

A_PROGRAM_DESC A_PROGRAM_DESC Description of the program value VARCHAR2(255 CHAR)

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

COLLEGE_DESC COLLEGE_DESC Description for College VARCHAR2(255 CHAR)

DEGREE DEGREE Degree or award code associated with the academic study. VARCHAR2(252)

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

DEGREE_IPED_CODE DEGREE_IPED_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(12)

DEGREE_IPED_CODE_DESC DEGREE_IPED_CODE_DESC Description for Degree_IPEDS_Code. VARCHAR2(1020)

DETAIL_CODE DETAIL_CODE 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 DETAIL_CODE_DESC Description of the detail code value VARCHAR2(255 CHAR)

DIVISION_CODE DIVISION_CODE Level 3 organization within this organization hierarchy. VARCHAR2(63 CHAR)

DIVISION_DESC DIVISION_DESC Descriptor for DIVISION_CODE

DUAL_MAJOR_IND COMBINED_MAJOR_IND Flag indicating that the student is pursuing two majors. VARCHAR2(1 CHAR)

ENROLLED_IND ENROLLED_IND Indicates whether the student's enrollment status includes them in headcounts. VARCHAR2(4)

ENROLLMENT_STATUS ENROLLMENT_STATUS Identifies student enrollment code VARCHAR2(252)

ENROLLMENT_STATUS_DESC ENROLLMENT_STATUS_DESC Description for student Enrollment Status VARCHAR2(1020)

EVENT EVENT a description of the predefined freeze event as one of stat date freeze, degree data freeze, end of term freeze, etc. VARCHAR2(255 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)

FISCAL_YEAR FISCAL_YEAR The year terminology in Financial Aid refers to a year associated with the application for financial aid of a student. Typically this follows the traditional Northeastern academic calendar (Fall through Summer), but deviates from that schedule based upon certain academic requirements. The Summer terms start the award year for CPS and second- and third-year students in the School of Law. Their award year therefore runs Summer through Spring. Please note that the financial aid for full summer terms spans over two fiscal years, and the dollar amounts are split in half for each term in each fiscal year. VARCHAR2(10 CHAR)

FISCAL_YEAR_DESC FISCAL_YEAR_DESC Description of Fiscal Year VARCHAR2(255 CHAR)

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(10 CHAR)

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

MAJOR_DESC_NU1 MAJOR_DESC_NU1 Description for Major 1 VARCHAR2(1020)

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

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

NEU_HBM_PROGRAM_GROUP_CD NEU_HBM_PROGRAM_GROUP_CD A derived field that identifies the record as one of Doctoral, Professional Practice/Masters/Other Graduate, or Non-Degree based on the students Degree IPEDS Code. VARCHAR2(3 CHAR)

NEU_HBM_PROGRAM_GROUP_DESC NEU_HBM_PROGRAM_GROUP_DESC Description of NEU_HBM_PROGRAM_GROUP_CD VARCHAR2(255 CHAR)

NU_FREEZE_DATE NU_FREEZE_DATE Actual date the data was frozen DATE

PERSON_UID PERSON_UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER(8)

PROGRAM_DESC_NU1 PROGRAM_DESC_NU1 Description for primary program. VARCHAR2(1020)

PROGRAM_DESC_NU2 PROGRAM_DESC_NU2 Description for Program 2. VARCHAR2(1020)

PROGRAM_NU1 PROGRAM_NU1 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(252)

PROGRAM_NU2 PROGRAM_NU2 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(252)

REGISTERED_IND REGISTERED_IND Flag that indicates student is registered in at least one term. VARCHAR2(4)

STUDENT_DEPARTMENT_CODE STUDENT_DEPARTMENT_CODE Department responsible for the student's academic study. VARCHAR2(252)

STUDENT_DEPARTMENT_DESC STUDENT_DEPARTMENT_DESC Description for Student Department_Code VARCHAR2(255 CHAR)

STUDENT_LEVEL STUDENT_LEVEL 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), US(Undergraduate Specialty Programs), GS(Graduate Specialty Programs) VARCHAR2(63 CHAR)

STUDENT_LEVEL_DESC STUDENT_LEVEL_DESC Description for Student Level VARCHAR2(255 CHAR)

STUDENT_POPULATION STUDENT_POPULATION This field identifies the student type for the effective term. VARCHAR2(252)

STUDENT_POPULATION_DESC STUDENT_POPULATION_DESC Description for Student Population VARCHAR2(1020)

STUDENT_STATUS STUDENT_STATUS 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

Ver: 9.0

Target Column	Business Name	Business Definition	Database Data Type
ACADEMIC_PERIOD_NUFREEZE	ACADEMIC_PERIOD_NUFREEZE	Academic term describes when course/class data was frozen corresponding to event in academic calendar (defined by student level).	VARCHAR2(10 CHAR)
ACADEMIC_PERIOD_NUFREEZE_DESC	ACADEMIC_PERIOD_NUFREEZE_DESC	Description for Academic Term Code	VARCHAR2(255 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(63 CHAR)
ACCOUNT_INDEX	ACCOUNT_INDEX	6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry	VARCHAR2(6 CHAR)
AMOUNT_TRANS	AMOUNT_TRANS	Total amount summed by detail code by term by student	NUMBER
A_ACCOUNT	A_ACCOUNT	Identifies the type of revenue or expense used in the transaction	VARCHAR2(6 CHAR)
A_ACCOUNT_DESC	A_ACCOUNT_DESC	Description of the A_Account	VARCHAR2(255 CHAR)
A_FUND	A_FUND	Funds are 6 digit codes that represent a source of funding. The first digit of the fund code will identify the type of fund: 2xxxxx = Current Fund 3xxxxx = Designated 4xxxxx = Endowment 5xxxxx = Grants & Contracts 6xxxxx = Restricted 7xxxxx = Plant Funds 8xxxxx = SABO	VARCHAR2(6 CHAR)
A_FUND_DESC	A_FUND_DESC	Description of the Fund code	VARCHAR2(255 CHAR)
A_ORGANIZATION	A_ORGANIZATION	The organization code identifies a unit of budgetary responsibility and/or departments within an institution. Organizations are 6 digit codes that always begin with the number 1.	VARCHAR2(6 CHAR)
A_ORGANIZATION_DESC	A_ORGANIZATION_DESC	Description of the organization value	VARCHAR2(255 CHAR)
A_PROGRAM	A_PROGRAM	Programs are four digit codes used for financial statement purposes.	VARCHAR2(6 CHAR)
A_PROGRAM_DESC	A_PROGRAM_DESC	Description of the program value	VARCHAR2(255 CHAR)
COLLEGE	COLLEGE	This field identifies the college associated with the student's primary curriculum for the effective term.	VARCHAR2(63 CHAR)
COLLEGE_DESC	COLLEGE_DESC	Description for College	VARCHAR2(255 CHAR)
DEGREE	DEGREE	Degree or award code associated with the academic study.	VARCHAR2(252)
DEGREE_DESC	DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc	VARCHAR2(252)
DEGREE_IPED_CODE	DEGREE_IPED_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(12)
DEGREE_IPED_CODE_DESC	DEGREE_IPED_CODE_DESC	Description for Degree_IPEDS_Code.	VARCHAR2(1020)
DETAIL_CODE	DETAIL_CODE	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	DETAIL_CODE_DESC	Description of the detail code value	VARCHAR2(255 CHAR)
DIVISION_CODE	DIVISION_CODE	Level 3 organization within this organization hierarchy.	VARCHAR2(63 CHAR)
DIVISION_DESC	DIVISION_DESC	Descriptor for DIVISION_CODE
DUAL_MAJOR_IND	COMBINED_MAJOR_IND	Flag indicating that the student is pursuing two majors.	VARCHAR2(1 CHAR)
ENROLLED_IND	ENROLLED_IND	Indicates whether the student's enrollment status includes them in headcounts.	VARCHAR2(4)
ENROLLMENT_STATUS	ENROLLMENT_STATUS	Identifies student enrollment code	VARCHAR2(252)
ENROLLMENT_STATUS_DESC	ENROLLMENT_STATUS_DESC	Description for student Enrollment Status	VARCHAR2(1020)
EVENT	EVENT	a description of the predefined freeze event as one of stat date freeze, degree data freeze, end of term freeze, etc.	VARCHAR2(255 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)
FISCAL_YEAR	FISCAL_YEAR	The year terminology in Financial Aid refers to a year associated with the application for financial aid of a student. Typically this follows the traditional Northeastern academic calendar (Fall through Summer), but deviates from that schedule based upon certain academic requirements. The Summer terms start the award year for CPS and second- and third-year students in the School of Law. Their award year therefore runs Summer through Spring. Please note that the financial aid for full summer terms spans over two fiscal years, and the dollar amounts are split in half for each term in each fiscal year.	VARCHAR2(10 CHAR)
FISCAL_YEAR_DESC	FISCAL_YEAR_DESC	Description of Fiscal Year	VARCHAR2(255 CHAR)
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(10 CHAR)
LAST_NAME	LAST_NAME	The last name by which a person is known.	VARCHAR2(63 CHAR)
MAJOR_DESC_NU1	MAJOR_DESC_NU1	Description for Major 1	VARCHAR2(1020)
MAJOR_NU1	MAJOR_NU1	This field identifies the primary major within the primary curriculum for the effective term.	VARCHAR2(252)
MIDDLE_NAME	MIDDLE_NAME	A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change.	VARCHAR2(63 CHAR)
NEU_HBM_PROGRAM_GROUP_CD	NEU_HBM_PROGRAM_GROUP_CD	A derived field that identifies the record as one of Doctoral, Professional Practice/Masters/Other Graduate, or Non-Degree based on the students Degree IPEDS Code.	VARCHAR2(3 CHAR)
NEU_HBM_PROGRAM_GROUP_DESC	NEU_HBM_PROGRAM_GROUP_DESC	Description of NEU_HBM_PROGRAM_GROUP_CD	VARCHAR2(255 CHAR)
NU_FREEZE_DATE	NU_FREEZE_DATE	Actual date the data was frozen	DATE
PERSON_UID	PERSON_UID	System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	NUMBER(8)
PROGRAM_DESC_NU1	PROGRAM_DESC_NU1	Description for primary program.	VARCHAR2(1020)
PROGRAM_DESC_NU2	PROGRAM_DESC_NU2	Description for Program 2.	VARCHAR2(1020)
PROGRAM_NU1	PROGRAM_NU1	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(252)
PROGRAM_NU2	PROGRAM_NU2	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(252)
REGISTERED_IND	REGISTERED_IND	Flag that indicates student is registered in at least one term.	VARCHAR2(4)
STUDENT_DEPARTMENT_CODE	STUDENT_DEPARTMENT_CODE	Department responsible for the student's academic study.	VARCHAR2(252)
STUDENT_DEPARTMENT_DESC	STUDENT_DEPARTMENT_DESC	Description for Student Department_Code	VARCHAR2(255 CHAR)
STUDENT_LEVEL	STUDENT_LEVEL	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), US(Undergraduate Specialty Programs), GS(Graduate Specialty Programs)	VARCHAR2(63 CHAR)
STUDENT_LEVEL_DESC	STUDENT_LEVEL_DESC	Description for Student Level	VARCHAR2(255 CHAR)
STUDENT_POPULATION	STUDENT_POPULATION	This field identifies the student type for the effective term.	VARCHAR2(252)
STUDENT_POPULATION_DESC	STUDENT_POPULATION_DESC	Description for Student Population	VARCHAR2(1020)
STUDENT_STATUS	STUDENT_STATUS	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