Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD_NUFREEZE	ACADEMIC_PERIOD_NUFREEZE	Business Definition Academic term describes when course/class data was frozen corresponding to event in academic calendar(defined by student level) Valid Values Sample 201625 201628 201630 201632 201638	VARCHAR2(10 CHAR)
ACADEMIC_PERIOD_NUFREEZE_DESC	ACADEMIC_PERIOD_NUFREEZE_DESC	Business Definition Description for Academic term Code Valid Values Sample Spring 2016 Law Quarter Spring 2016 Law Semester Spring 2016 Semester Winter 2016 CPS Quarter Winter 2016 Law Quarter	VARCHAR2(255 CHAR)
ACADEMIC_YEAR	ACADEMIC YEAR	Business Definition Academic year associated with academic Period Nufreeze Valid Values Sample 2016	VARCHAR2(63 CHAR)
ACADEMIC_YEAR_DESC	ACADEMIC_YEAR_DESC	Business Definition Description of Academic Year Valid Values Sample 2015-2016	VARCHAR2(63 CHAR)
ACCOUNT_INDEX	ACCOUNT_INDEX	Business Definition 6 Digit number that represents the Banner Fund, Organization and Program. Indexes are used for ease of data entry. Valid Values Sample 100136 100303 100465 133170 139310	VARCHAR2(6 CHAR)
AMOUNT_TRANS	AMOUNT_TRANS	Business Definition Total amount summed by detail code by term by student Valid Values Sample 550 1,335 5,300 13,250 33,462	NUMBER
B_ACCOUNT	B_ACCOUNT	Business Definition Identifies the type of revenue or expense used inthe transaction Valid Values Sample 12017 50128 50131 50135 50141	VARCHAR2(6 CHAR)
B_ORGANIZATION	B_ORGANIZATION	Business Definition 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. Valid Values Sample 113000 121250 133300 139050 148100	VARCHAR2(6 CHAR)
B_ORGANIZATION_DESC	B_ORGANIZATION_DESC	Business Definition Description of the organization value Valid Values Sample CAMD-Graduate CPS-LPD Program HIgh Tech MBA Seattle-Bioinformatics World Language Center	VARCHAR2(255 CHAR)
COLLEGE	COLLEGE	Business Definition This field identifies the college associated with the primary curriculum for the effective term. Valid Values Sample AM BV EN SC SH	VARCHAR2(63 CHAR)
COLLEGE_DESC	COLLEGE_DESC	Business Definition Description of College Valid Values Sample AM: College of Arts, Media & Design BV: Bouve College of Health Sciences EN: College of Engineering SC: College of Science SH: College of Soc Sci & Humanities	VARCHAR2(255 CHAR)
DEGREE	DEGREE	Business Definition Degree or award code associated with the academic study. Valid Values Sample AE BFA BSIS CERTG MS	VARCHAR2(63 CHAR)
DEGREE_DESC	DEGREE_DESC	Business Definition Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc Valid Values Sample AE: Associate in Engineering BFA: Bachelor of Fine Arts BSIS: B.S. in Information Science CERTG: Graduate Certificate MS: Master of Science	VARCHAR2(63 CHAR)
DEGREE_IPED_CODE	DEGREE_IPED_CODE	Business Definition IPEDs Code associated with student degree Valid Values Sample 2 5 17 19 99	VARCHAR2(3 CHAR)
DEGREE_IPED_CODE_DESC	DEGREE_IPED_CODE_DESC	Business Definition Description for Degree_IPEDS_Code Valid Values Sample 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(255 CHAR)
DETAIL_CODE	DETAIL_CODE	Business Definition Code that determines where financial transactions will be fed into the accounting system. i.e. Tuition, Financial Aid, HOusing, Meals, etc. Valid Values Sample TG01 TG11 TP42 TU23 W007	VARCHAR2(4 CHAR)
DETAIL_CODE_DESC	DETAIL_CODE_DESC	Business Definition Description of the detail code value Valid Values Sample CPS Foundation Year MS Leadership Prog. Tuition-Nursing Tuition Data Science Tuition Data Science Tuition-Engineering	VARCHAR2(255 CHAR)
DIVISION_CODE	DIVISION_CODE	Business Definition Level 3 organization within this organization hierarchy Valid Values Sample DIV20 DIV23 DIV29 DIV34 DIV39	VARCHAR2(63 CHAR)
DIVISION_DESC	DIVISION_DESC	Business Definition Description of Division Code Valid Values Sample DIV20: Bouve College Health Sciences DIV23: College of Engineering DIV29: College Computer+Information Sci. DIV34: International Study Program DIV39: College of Social Sci. + Humanities	VARCHAR2(255 CHAR)
DUAL_MAJOR_IND	DUAL_MAJOR_IND	Business Definition Flag indicating that the student is pursuing two majors Valid Values Sample Y N	VARCHAR2(1 CHAR)
ENROLLED_IND	ENROLLED_IND	Business Definition Flag indicating that the student is pursuing two majors Business Logic If a student has no term header record, no instituional course maintenance term header record, and no open learning additional registration information is found then Enrolled indicator is 'N'(NOt Enrolled).Otherwise,if at least one record is found then 'Y'(Enrolled). Valid Values Sample Y N	VARCHAR2(1 CHAR)
ENROLLMENT_STATUS	ENROLLMENT_STATUS	Business Definition Identifies student enrollment code Valid Values Sample CL CO EL LA SA WD WX	VARCHAR2(255 CHAR)
ENROLLMENT_STATUS_DESC	ENROLLMENT_STATUS_DESC	Business Definition Description for student enrollment status Valid Values Sample CL: Clinical CO: Coop EL: Eligible to Register LA: Leave of Absence SA: Study Abroad WD: Withdrawn After Stats WX: Withdrawn Prior to Stats	VARCHAR2(255 CHAR)
FIRST_NAME	FIRST_NAME	Business Definition The first name given to a person at birth, baptism, another naming ceremony or through legal change. Valid Values Sample A'Keesha Cheryl-Ann John Min Gi Yi	VARCHAR2(63 CHAR)
HOME_DETAIL_CODE_IND	HOME_DETAIL_CODE_IND	Business Definition Indicated whether the detail code for the tuition transaction corresponds to the home college of the student. Valid Values Sample Y N	VARCHAR2(1 CHAR)
ID	ID	Business Definition Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. Valid Values Sample 000022982 001669114 001738485 001943829 001999978	VARCHAR2(10 CHAR)
LAST_NAME	LAST_NAME	Business Definition The last name by which a person is known. Valid Values Sample Abdel-Hadi Bu Dell'Accio Lafuente Scrosoppi Smith	VARCHAR2(63 CHAR)
MAJOR_DESC_NU1	MAJOR_DESC_NU1	Business Definition Description for Major 1 Valid Values Sample Accounting CriminalJustice Higher Education Admin Nonprofit Management Undeclared	VARCHAR2(255 CHAR)
MAJOR_NU1	MAJOR_NU1	Business Definition This field identifies the primary major within the primary curriculum for the effective term Valid Values Sample AIST ECEL INOV PHIL URRP	VARCHAR2(63 CHAR)
MIDDLE_NAME	MIDDLE_NAME	Business Definition A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change. Valid Values Sample A H Elizabeth-Rae Li D'Anthony G.O. Tori	VARCHAR2(63 CHAR)
NEU_HBM_PROGRAM_GROUP_CD	NEU_HBM_PROGRAM_GROUP_CD	Business Definition Identifies the record as one of Doctoral, Professional Practice/Masters/Other Graduate, or Non-Degree based on the students Degree IPEDS Code. Business Logic If Degree IPEDS COde is 6,7,8,or 18 the NEU HBM Program Code is '2'. If Degree IPEDS COde is 17 or 19 the NEU HBM Program Code is '1'. If Degree IPEDS COde is 3,4, or 5 the NEU HBM Program Code is '3'. If Degree IPEDS COde is 99 or 2 the NEU HBM Program Code is '4'. Valid Values Sample 1 2 3 4	VARCHAR2(3 CHAR)
NEU_HBM_PROGRAM_GROUP_DESC	NEU_HBM_PROGRAM_GROUP_DESC	Business Definition Description of NEU_HBM_PROGRAM_GROUP_CD Business Logic If Degree IPEDS COde is 6,7,8,or 18 the NEU HBM Program Description is Professional practice/masters/other graduated. If Degree IPEDS COde is 17 or 19 the NEU HBM Program Description is Doctoral. If Degree IPEDS COde is 3,4, or 5 the NEU HBM Program Description is Undergraduate. If Degree IPEDS COde is 99 or 2 the NEU HBM Program Description is Non-Degree. Valid Values Sample 1: Doctoral 2: Professional practice/masters/other graduated 3: Undergraduate	VARCHAR2(255 CHAR)
PROGRAM_DESC_NU1	PROGRAM_DESC_NU1	Business Definition Description for primary program Valid Values Sample BA History BS Philosophy CERTG Leadership(CPS) MS Health Informatics PhD Physics	VARCHAR2(255 CHAR)
PROGRAM_DESC_NU2	PROGRAM_DESC_NU2	Business Definition Description for Program 2 Valid Values Sample CERTG Data Science Master of Laws ND Special Student GP(CPS) NU/NEC Cert in Music Perf Special College of Sciences GR	VARCHAR2(255 CHAR)
PROGRAM_NU1	PROGRAM_NU1	Business Definition Classification of academic breakdown defined as a primary combination of program, student level, course, degree, and level. May also contain majors, minors, and concentrations. Valid Values Sample BA-CIEN BS-AFRS CERTG-ABA MS-MEDC PHD-POLI	VARCHAR2(63 CHAR)
PROGRAM_NU2	PROGRAM_NU2	Business Definition Classification of academic breakdown defined as a primary combination of program, student level, course, degree, and level. May also contain majors, minors, and concentrations. Valid Values Sample CERTG-BSAD LLM-Law ND-SC-G P-BS-BIOS P-SPEC-PS-G	VARCHAR2(63 CHAR)
REGISTERD_IND	REGISTERD_IND	Business Definition Flag indicates student is registered in ta least one term. Business Logic If no registration record is found and no academic history exists for the current term then Registered Indicator is 'N'(Not Registerd). otherwise, if at least one record is found then 'Y'(Registered). Valid Values Sample Y N	VARCHAR2(1 CHAR)
STUDENT_DEPARTMENT_CODE	STUDENT_DEPARTMENT_CODE	Business Definition Department responsible for the student's academic study Valid Values Sample ACCT CHME NRSG PT UNDE	VARCHAR2(63 CHAR)
STUDENT_DEPARTMENT_DESC	STUDENT_DEPARTMENT_DESC	Business Definition Student Department name Valid Values Sample ACCT: Accounting CHME: Chemical Engineering NRSG: Nursing PT: Phys Therapy/Movemnt/rehab Sci UNDE: Provost Undeclared	VARCHAR2(255 CHAR)
STUDENT_LEVEL	STUDENT_LEVEL	Business Definition 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) Valid Values Sample GR UG US	VARCHAR2(63 CHAR)
STUDENT_LEVEL_DESC	STUDENT_LEVEL_DESC	Business Definition Description for Student Level Valid Values Sample GR: Graduate UG: Undergraduate US: Undergraduate Specialty Semester	VARCHAR2(255 CHAR)
STUDENT_POPULATION	STUDENT_POPULATION	Business Definition This field identifies the student type for the effective term. Valid Values Sample C N S T	VARCHAR2(63 CHAR)
STUDENT_POPULATION_DESC	STUDENT_POPULATION_DESC	Business Definition Description for Student Population Valid Values Sample C: Continuing N: New Student S: Special T: Transfer	VARCHAR2(255 CHAR)
STUDENT_RESIDENCY	STUDENT_RESIDENCY	Business Definition Residency of the students as one of full-time, full-time international, part-time, part-time international. Valid Values Sample F I J P	VARCHAR2(63 CHAR)
STUDENT_RESIDENCY_DESC	STUDENT_RESIDENCY_DESC	Business Definition Description for Student Residency Valid Values Sample F: Full time I: International-Full Time J: International-Part Time P: Part Time	VARCHAR2(255 CHAR)

Ver: 9.0