Reporting View Target: FTUG_COMB_MAJOR_REV_SHARE

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Argos Custom Data Dictionaries Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: FTUG_COMB_MAJOR_REV_SHARE_RPRT

Description Calculate Hybrid Budget tuition revenue adjustment for inter-college combined majors. The total combined majors adjustment for a given college is the total revenue adjustment where that college is the secondary college minus the total revenue adjustment where that college is the primary college.

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

ACADEMIC_PERIOD_NUFREEZE_DESC Academic Period Description for Academic Term Code VARCHAR2(255 CHAR)

ATTS_CODE Student's general student attribute code. VARCHAR2(4 CHAR) STVATTS

CALCULATED Revenue Adjustment Tuition dollars shared between the primary and secondary colleges for combined majors under the hybrid budget model. For the primary college, this is a negative adjustment to revenue; for the secondary college, this is a positive adjustment to revenue.

COLLEGE_DESC First College The first college, aka the “home” college, is the college that will appear on the student’s transcript, and is also the college that receives the gross undergraduate tuition revenue for students in the combined major. The first college is usually the major listed before the slash (/) in the major description, but this is not always the case as students have the option to select which college will appear as their “home” college. The first college shares tuition revenue with the second college through the combined majors adjustment. VARCHAR2(255 CHAR)

COLLEGE_OWNER_DESC Second College The second college houses one of the majors in the combined major, but is not considered the student’s “home” college and will not be listed on the student’s transcript. The second college is usually the major listed after the slash (/) in the major description, but this is not always the case as students have the option to select which college will appear as their “home” college. The second college receives its share of the undergraduate tuition revenue for the combined major from the first college, who has received the gross tuition revenue. The second college does, however, have to reimburse the first college for any revenue shared via the Hybrid Budget buy/sell adjustment, as the first college is the only college considered in the buy/sell model. VARCHAR2(255 CHAR)

COLL_CODE Student's college code. VARCHAR2(63 CHAR) STVCOLL

COURSE_CREDITS Academic Credits associated with this course, credits which appear on your transcript. NUMBER(11,3)

DETL_CODE Detail code that the determined charges for this rule will be posted to. VARCHAR2(4 CHAR)

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

ENROLLMENT_STATUS_DESC Enrollment Status Description for student enrollment status VARCHAR2(255 CHAR)

ENTRY_TYPE Assessment type. Valid values are 'R'egistration or 'P're-registration assessment. 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(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)

FLAT_FEE_AMOUNT Flat fee amount to charge for students whose course hours are within the flat hour range for the rule. NUMBER(11,3)

FROM_TERM Minimum effective academic period for a particular curriculum offering. VARCHAR2(63 CHAR)

ID NUID 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 Description for Major Nu1 VARCHAR2(255 CHAR)

PROGRAM The combination of student level, course level, college and degree. Tied to (via curriculum rules) majors, minors, and concentrations. VARCHAR2(63 CHAR)

PROGRAM_DESC_NU1 Program Description for Program Nu1 VARCHAR2(255 CHAR)

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)

STYP_CODE Student's general student - student type code. VARCHAR2(1 CHAR) STVSTYP

TERM_CODE Registration term. VARCHAR2(255 CHAR)

TO_TERM Maximum effective academic period for a particular curriculum offering. VARCHAR2(63 CHAR)

TYPE Type of assessment rule. Valid values are STUDENT, LEVEL (course level), CAMPUS (course campus)and ATTR (course attribute). VARCHAR2(63 CHAR)

Ver: 9.0

Target Column	Business Name	Business Definition	Database Data Type	Domain Value
ACADEMIC_PERIOD_NUFREEZE_DESC	Academic Period	Description for Academic Term Code	VARCHAR2(255 CHAR)
ATTS_CODE		Student's general student attribute code.	VARCHAR2(4 CHAR)	STVATTS
CALCULATED	Revenue Adjustment	Tuition dollars shared between the primary and secondary colleges for combined majors under the hybrid budget model. For the primary college, this is a negative adjustment to revenue; for the secondary college, this is a positive adjustment to revenue.
COLLEGE_DESC	First College	The first college, aka the “home” college, is the college that will appear on the student’s transcript, and is also the college that receives the gross undergraduate tuition revenue for students in the combined major. The first college is usually the major listed before the slash (/) in the major description, but this is not always the case as students have the option to select which college will appear as their “home” college. The first college shares tuition revenue with the second college through the combined majors adjustment.	VARCHAR2(255 CHAR)
COLLEGE_OWNER_DESC	Second College	The second college houses one of the majors in the combined major, but is not considered the student’s “home” college and will not be listed on the student’s transcript. The second college is usually the major listed after the slash (/) in the major description, but this is not always the case as students have the option to select which college will appear as their “home” college. The second college receives its share of the undergraduate tuition revenue for the combined major from the first college, who has received the gross tuition revenue. The second college does, however, have to reimburse the first college for any revenue shared via the Hybrid Budget buy/sell adjustment, as the first college is the only college considered in the buy/sell model.	VARCHAR2(255 CHAR)
COLL_CODE		Student's college code.	VARCHAR2(63 CHAR)	STVCOLL
COURSE_CREDITS		Academic Credits associated with this course, credits which appear on your transcript.	NUMBER(11,3)
DETL_CODE		Detail code that the determined charges for this rule will be posted to.	VARCHAR2(4 CHAR)
DUAL_MAJOR_IND		Flag indicating that the student is pursuing two majors.	VARCHAR2(1 CHAR)
ENROLLMENT_STATUS_DESC	Enrollment Status	Description for student enrollment status	VARCHAR2(255 CHAR)
ENTRY_TYPE		Assessment type. Valid values are 'R'egistration or 'P're-registration assessment.	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(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)
FLAT_FEE_AMOUNT		Flat fee amount to charge for students whose course hours are within the flat hour range for the rule.	NUMBER(11,3)
FROM_TERM		Minimum effective academic period for a particular curriculum offering.	VARCHAR2(63 CHAR)
ID	NUID	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	Description for Major Nu1	VARCHAR2(255 CHAR)
PROGRAM		The combination of student level, course level, college and degree. Tied to (via curriculum rules) majors, minors, and concentrations.	VARCHAR2(63 CHAR)
PROGRAM_DESC_NU1	Program	Description for Program Nu1	VARCHAR2(255 CHAR)
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)
STYP_CODE		Student's general student - student type code.	VARCHAR2(1 CHAR)	STVSTYP
TERM_CODE		Registration term.	VARCHAR2(255 CHAR)
TO_TERM		Maximum effective academic period for a particular curriculum offering.	VARCHAR2(63 CHAR)
TYPE		Type of assessment rule. Valid values are STUDENT, LEVEL (course level), CAMPUS (course campus)and ATTR (course attribute).	VARCHAR2(63 CHAR)