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