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

SGHE Banner Operational Data Store
Reporting View Target: Z_NEU_GRAD_ACADINFO_DAILY_VW

Description Daily snapshot of a set of the student's academic history attributes(previous college(s), degree(s) and certificate(s) for all given graduate applicants starting from Fall 2008.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD_ENTRY   Entry period for applicant to the program VARCHAR2(10 CHAR)      
APPLICATION_ID   Unique ID assigned to applicant through Apply Yourself VARCHAR2(10 CHAR)      
FIRST_NAME   Applicant's first name given to a person at birth, baptism, another naming ceremony or through legal change. VARCHAR2(63 CHAR)      
FREEZE_DATE   Last date when at least one attribute of the record was updated. DATE      
ID   Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(10 CHAR)      
INST1AREASTUDY   First college area of study from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1AREASTUDYCODE   First college area of study code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1ATTNDFINDATE   First college end date from where the applicant is graduated. DATE      
INST1ATTNDSTDATE   First college start date from where the applicant is graduated. DATE      
INST1CITY   First college city from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1CODE   First college code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1CTRY   First college country name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1CTRYCODE   First college country code from where the applicant is graduated. VARCHAR2(4 CHAR)      
INST1DEGREE   First college degree name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1DEGREECODE   First college degree code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1DEGREEDATE   First college degree awarded date from where the applicant is graduated. DATE      
INST1DEGREETITLE   First college degree title from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1GPA   First college GPA from where the applicant is graduated. NUMBER(11,3)      
INST1GPASCALE   First college GPA scale from where the applicant is graduated. NUMBER(11,3)      
INST1ISDEGREE   First college degree awarded (Y/N) from where the applicant is graduated. VARCHAR2(1 CHAR)      
INST1NAME   First college name from where the applicant is graduated VARCHAR2(63 CHAR)      
INST1NAMEOTHER   First college write-in name from where the applicant is graduated VARCHAR2(63 CHAR)      
INST1PROGRAM   First college program from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1PROGRAMSTUDY   First college program of study from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1PROGRAMSTUDYCODE   First college program of study code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1STATE   First college state from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1VERIFICATION   First college degree verified from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2AREASTUDY   Second college area of study from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2AREASTUDYCODE   Second college area of study code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2ATTNDFINDATE   Second college end date from where the applicant is graduated. DATE      
INST2ATTNDSTDATE   Second college start date from where the applicant is graduated. DATE      
INST2CITY   Second college city from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2CODE   Second college code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2CTRY   Second college country name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2CTRYCODE   Second college country code from where the applicant is graduated. VARCHAR2(4 CHAR)      
INST2DEGREE   Second college degree name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2DEGREECODE   Second college degree code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2DEGREEDATE   Second college degree awarded date from where the applicant is graduated. DATE      
INST2DEGREETITLE   Second college degree title from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2GPA   Second college GPA from where the applicant is graduated. NUMBER(11,3)      
INST2GPASCALE   Second college GPA scale from where the applicant is graduated. NUMBER(11,3)      
INST2ISDEGREE   Second college degree awarded (Y/N) from where the applicant is graduated. VARCHAR2(1 CHAR)      
INST2NAME   Second college name from where the applicant is graduated VARCHAR2(63 CHAR)      
INST2NAMEOTHER   Second college write-in name from where the applicant is graduated VARCHAR2(63 CHAR)      
INST2PROGRAM   Second college program from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2PROGRAMSTUDY   Second college program of study from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2PROGRAMSTUDYCODE   Second college program of study code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2STATE   Second college state from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2VERIFICATION   Second college degree verified from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3AREASTUDY   Third college area of study from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3AREASTUDYCODE   Third college area of study code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3ATTNDFINDATE   Third college end date from where the applicant is graduated. DATE      
INST3ATTNDSTDATE   Third college start date from where the applicant is graduated. DATE      
INST3CITY   Third college city from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3CODE   Third college code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3CTRY   Third college country name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3CTRYCODE   Third college country code from where the applicant is graduated. VARCHAR2(4 CHAR)      
INST3DEGREE   Third college degree name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3DEGREECODE   Third college degree code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3DEGREEDATE   Third college degree awarded date from where the applicant is graduated. DATE      
INST3DEGREETITLE   Third college degree title from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3GPA   Third college GPA from where the applicant is graduated. NUMBER(11,3)      
INST3GPASCALE   Third college GPA scale from where the applicant is graduated. NUMBER(11,3)      
INST3ISDEGREE   Third college degree awarded (Y/N) from where the applicant is graduated. VARCHAR2(1 CHAR      
INST3NAME   Third college name from where the applicant is graduated VARCHAR2(63 CHAR)      
INST3NAMEOTHER   Third college write-in name from where the applicant is graduated VARCHAR2(63 CHAR)      
INST3PROGRAM   Third college program from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3PROGRAMSTUDY   Third college program of study from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3PROGRAMSTUDYCODE   Third college program of study code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3STATE   Third college state from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3VERIFICATION   Third college degree verified from where the applicant is graduated. VARCHAR2(63 CHAR)      
LAST_NAME   The last name by which a applicant is known. VARCHAR2(63 CHAR)      
LAST_UPDATE_DATE   Date when source record was last updated in source data (Apply Yourself). DATE      


Ver: 9.0