Reporting View Target: Z_NEU_ADM_CPS_WEEKLY

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_ADM_CPS_WEEKLY_VW

Description Weekly view of CPS Admissions data that provides CPS and OSER with reporting capability continue defining and improving the enrollment management strategy. Includes all applications where Applied for Term or Accepted Term is the current term in Apply Yourself. Freeze is created at the beginning of the working day on Mondays. Data released to CPS, OSER, Admissions CPS Office, Financial Aid Office, Institutional Research Office, Provost Office, and Registrar’s Office. Data is not released to Argos. Data is collected for the given term only during so called admission analysis cycle period. CPS Admission analysis cycle is defined as period starting 18 weeks (126 days) prior CPS Academic period start date and ending at CPS Second Half Freeze.

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

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

ACADEMIC_PERIOD_NUFREEZE_DESC Description for Academic Term Code VARCHAR2(255 CHAR)

ACCEPTED_APPLICATION_IND Counter used for reporting purposes to quickly provide counts of admitted applications. NUMBER(1)

ACCEPT_TERM Term applicant has been accepted VARCHAR2(10 CHAR)

ACCEPT_TERM_DESC Term description VARCHAR2(255 CHAR)

ACTIVE_DUTY_MILITARY_IND Based on applicant response (not confirmed), indicates if student is currently on military active duty . VARCHAR2(1 CHAR)

ADMISSION_EVENT Currently Under Review VARCHAR2(50 CHAR)

AFRICAN_AMERICAN_IND Applicant's African-American race status VARCHAR2(1 CHAR)

AGE Applicant's age at application submission NUMBER(4,1)

AMERICAN_INDIAN_IND Applicant's American Indian race status VARCHAR2(1 CHAR)

APPLICANT_CATEGORY The admission type of the applicant VARCHAR2(50 CHAR)

APPLICANT_CATEGORY_DESC Description of applicant category VARCHAR2(255 CHAR)

APPLICATION_ID Unique source system application ID VARCHAR2(50 CHAR)

APPLICATION_TYPE The type of student the applicant will become if admitted (freshman vs. transfer). VARCHAR2(50 CHAR)

APPLICATION_TYPE_DESC Description of the type of student the applicant will become if admitted. VARCHAR2(255 CHAR)

APPLIED_CONCENTRATION Concentration applied to VARCHAR2(50 CHAR)

APPLIED_CONCENTRATION_DESC Description of concentration applied to VARCHAR2(255 CHAR)

APPLIED_DEGREE Degree applicant is applying to VARCHAR2(50 CHAR)

APPLIED_DEGREE_DESC Description of Degree applicant is applying to VARCHAR2(50 CHAR)

APPLIED_MAJOR Major applied to VARCHAR2(50 CHAR)

APPLIED_MAJOR_DESC Description of major applied to VARCHAR2(255 CHAR)

APPLIED_MINOR Minor applied to VARCHAR2(50 CHAR)

APPLIED_MINOR_DESC Description of minor applied to VARCHAR2(255 CHAR)

APPLIED_PROGRAM Program applicant applied to VARCHAR2(50 CHAR)

APPLIED_PROGRAM_DESC Description of Program applicant applied to VARCHAR2(255 CHAR)

APPLY_FINAID_CODE Indicates whether the student is interested in financial aid VARCHAR2(50 CHAR)

APPLY_TERM Once a decision is rendered, then this term indicates the term for which the applicant intends to enroll. If an applicant is accepted but wishes to enroll for a future term, then this field should be updated to reflect the applicant's intention. VARCHAR2(50 CHAR)

APPLY_TERM_DESC Term Description VARCHAR2(255 CHAR)

ASIAN_IND Applicant's Asian race status VARCHAR2(1 CHAR)

BOSTON_RESIDENCE_IND Indicates whether applicant is a resident of Boston VARCHAR2(1 CHAR)

CALENDAR_EVENT Currently Under Review VARCHAR2(50 CHAR)

CAMPUS_PREFERENCE The preferred campus of the applicant. VARCHAR2(255 CHAR)

CITIZENSHIP_STATUS Citizen Indicator.(Y=US, P = perm resident, N=Non-US Citizen) VARCHAR2(50 CHAR)

CITIZENSHIP_STATUS_DESC Citizen Indicator description VARCHAR2(255 CHAR)

COMPLETED_APPLICATION_IND Counter used for reporting purposes to quickly provide counts of completed applications. NUMBER(1)

CONVERT_TO_STUDENT_IND Indicator that shows whether an applicant has been converted to a student based on an accepted application. VARCHAR2(1 CHAR)

COUNTRY_CITIZENSHIP_CODE Prior to Global Campus System updates: The nation/country code of citizenship of the applicant After 2022 Freeze and Global Campus System updates:: Country code of the nation where the person maintains citizenship. Note: In the case of dual citizens, it is the citizenship under which they applied to the university. VARCHAR2(50 CHAR)

COUNTRY_CITIZENSHIP_DESC The nation/country name/description of citizenship of the applicant VARCHAR2(255 CHAR)

DENIED_APPLICATION_IND Counter used for reporting purposes to quickly provide counts of denied applications. NUMBER(1)

DOMESTIC_STUDENT_IND Counter used for reporting purposes to quickly provide counts of domestic applications. NUMBER(1)

EMPLOYER Based on applicant response (not confirmed), name of applicant's employer. VARCHAR2(250 CHAR)

EMPLOYMENT_IND Based on applicant response (not confirmed), indicates if student is currently employed. VARCHAR2(1 CHAR)

FASTTRACK_IND Counter used for reporting purposes to quickly provide counts of applications to fast-track degree completion programs. NUMBER(1)

FREEZE_DATE Date on which data were frozen DATE

GENDER The gender of a person, e.g. Male, Female. VARCHAR2(50 CHAR)

GENDER_DESC Description of applicant's gender VARCHAR2(255 CHAR)

HIGH_SCHOOL_NAME Based on applicant response (not confirmed), indicates name of high school attended. VARCHAR2(250 CHAR)

HOME_CAMPUS_CD HOME CAMPUS CD The approved campus location assigned to a student or employee upon application, enrollment or hiring. VARCHAR2(63)

HOME_CAMPUS_COUNTRY HOME CAMPUS COUNTRY The nation of a student's Home Campus Cd. VARCHAR2(63)

HOME_CAMPUS_COUNTRY_DESC HOME CAMPUS COUNTRY DESC Description of HOME CAMPUS COUNTRY VARCHAR2(255)

HOME_CAMPUS_DESC HOME CAMPUS DESC Description of HOME CAMPUS CD VARCHAR2(255)

INTERNATIONAL_STUDENT_IND Counter used for reporting purposes to quickly provide counts of international applications. NUMBER(1)

INT_ADDRESS_IND International address indicator VARCHAR2(50 CHAR)

IPEDS_ETHNICITY_RACE_CD Race/ethnicity based on requirements from the "Integrated Postsecondary Education Data System (IPEDS)" VARCHAR2(2 CHAR)

IPEDS_ETHNICITY_RACE_NAME Description of IPEDS Ethnicity Race Code VARCHAR2(250 CHAR)

NATION_BIRTH_CODE Country of birth VARCHAR2(50 CHAR)

NATION_BIRTH_DESC Description of country of birth VARCHAR2(255 CHAR)

NEW_ETHNIC_IND Does applicant self-identify as hispanic/ latino VARCHAR2(1 CHAR)

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

PACIFIC_ISLDR_IND Applicant's Pacific Islander ethnicity status VARCHAR2(1 CHAR)

PERM_COUNTRY The country associated with the permanent address of the applicant VARCHAR2(50 CHAR)

PERM_COUNTRY_DESC Name/description of the country associated with the permanent address of the applicant VARCHAR2(255 CHAR)

PERM_STATE_CODE The state associated with the permanent address of the applicant VARCHAR2(50 CHAR)

PERM_ZIP The postal code associated with the permanent address of the applicant VARCHAR2(120 CHAR)

POPULATION_CD_1 The first admissions attribute for the application. VARCHAR2(10 CHAR)

POPULATION_CD_2 The second admissions attribute for the application. VARCHAR2(10 CHAR)

POPULATION_CD_3 The third admissions attribute for the application. VARCHAR2(10 CHAR)

POPULATION_CD_4 The fourth admissions attribute for the application. VARCHAR2(10 CHAR)

POPULATION_CD_5 The fifth admissions attribute for the application. VARCHAR2(10 CHAR)

POPULATION_DESC_1 Description for the first admissions attribute for the application VARCHAR2(50 CHAR)

POPULATION_DESC_2 Description for the second admissions attribute for the application VARCHAR2(50 CHAR)

POPULATION_DESC_3 Description for the third admissions attribute for the application VARCHAR2(50 CHAR)

POPULATION_DESC_4 Description for the fourth admissions attribute for the application VARCHAR2(50 CHAR)

POPULATION_DESC_5 Description for the fifth admissions attribute for the application VARCHAR2(50 CHAR)

PROGRAM_TYPE Degree type, such as Master's, Associate; also used to identify unique program formats such as Fast-Track VARCHAR2(255 CHAR)

REGION US region of the applicant based on their permanent state code VARCHAR2(2 CHAR)

REGION_DESC Description of US region of the applicant VARCHAR2(50 CHAR)

SCHOLARSHIP_TYPE Proposed scholarship to be awarded VARCHAR2(50 CHAR)

SCHOLARSHIP_TYPE_DESC Description of proposed scholarship to be awarded VARCHAR2(255 CHAR)

SECOND_NATION_CITIZENSHIP_CODE SECOND NATION CITIZENSHIP CODE A country code for a nationality that a dual citizen maintains, but did not indicate as the primary nation of citizenship in regards to their Home Campus. VARCHAR2(63)

SECOND_NATION_CITIZENSHIP_DESC SECOND NATION CITIZENSHIP DESC Description of SECOND NATION CITIZENSHIP CODE. VARCHAR2(255)

STUDENT_LEVEL Student level, GP UP VARCHAR2(50 CHAR)

STUDENT_LEVEL_DESC Student level description VARCHAR2(100 CHAR)

SUBMITTED_APPLICATION_IND Counter used for reporting purposes to quickly provide counts of submitted applications. NUMBER(1)

TERM_START_DATE Currently Under Review DATE

TRANSFER_CREDIT_REQUESTED_IND Indicator for whether the applicant has indicated a desire to transfer credit; this does not mean the transfer credit is approved. VARCHAR2(3 CHAR)

VETERAN_IND Applicant's White/Caucasian race status VARCHAR2(1 CHAR)

WHITE_IND Applicant's White/Caucasian race status VARCHAR2(1 CHAR)

Ver: 9.0

Target Column	Business Name	Business Definition	Database Data Type
ACADEMIC_PERIOD_NUFREEZE		Academic term describes when course/class data was frozen corresponding to event in academic calendar (defined by student level).	VARCHAR2(50 CHAR)
ACADEMIC_PERIOD_NUFREEZE_DESC		Description for Academic Term Code	VARCHAR2(255 CHAR)
ACCEPTED_APPLICATION_IND		Counter used for reporting purposes to quickly provide counts of admitted applications.	NUMBER(1)
ACCEPT_TERM		Term applicant has been accepted	VARCHAR2(10 CHAR)
ACCEPT_TERM_DESC		Term description	VARCHAR2(255 CHAR)
ACTIVE_DUTY_MILITARY_IND		Based on applicant response (not confirmed), indicates if student is currently on military active duty .	VARCHAR2(1 CHAR)
ADMISSION_EVENT		Currently Under Review	VARCHAR2(50 CHAR)
AFRICAN_AMERICAN_IND		Applicant's African-American race status	VARCHAR2(1 CHAR)
AGE		Applicant's age at application submission	NUMBER(4,1)
AMERICAN_INDIAN_IND		Applicant's American Indian race status	VARCHAR2(1 CHAR)
APPLICANT_CATEGORY		The admission type of the applicant	VARCHAR2(50 CHAR)
APPLICANT_CATEGORY_DESC		Description of applicant category	VARCHAR2(255 CHAR)
APPLICATION_ID		Unique source system application ID	VARCHAR2(50 CHAR)
APPLICATION_TYPE		The type of student the applicant will become if admitted (freshman vs. transfer).	VARCHAR2(50 CHAR)
APPLICATION_TYPE_DESC		Description of the type of student the applicant will become if admitted.	VARCHAR2(255 CHAR)
APPLIED_CONCENTRATION		Concentration applied to	VARCHAR2(50 CHAR)
APPLIED_CONCENTRATION_DESC		Description of concentration applied to	VARCHAR2(255 CHAR)
APPLIED_DEGREE		Degree applicant is applying to	VARCHAR2(50 CHAR)
APPLIED_DEGREE_DESC		Description of Degree applicant is applying to	VARCHAR2(50 CHAR)
APPLIED_MAJOR		Major applied to	VARCHAR2(50 CHAR)
APPLIED_MAJOR_DESC		Description of major applied to	VARCHAR2(255 CHAR)
APPLIED_MINOR		Minor applied to	VARCHAR2(50 CHAR)
APPLIED_MINOR_DESC		Description of minor applied to	VARCHAR2(255 CHAR)
APPLIED_PROGRAM		Program applicant applied to	VARCHAR2(50 CHAR)
APPLIED_PROGRAM_DESC		Description of Program applicant applied to	VARCHAR2(255 CHAR)
APPLY_FINAID_CODE		Indicates whether the student is interested in financial aid	VARCHAR2(50 CHAR)
APPLY_TERM		Once a decision is rendered, then this term indicates the term for which the applicant intends to enroll. If an applicant is accepted but wishes to enroll for a future term, then this field should be updated to reflect the applicant's intention.	VARCHAR2(50 CHAR)
APPLY_TERM_DESC		Term Description	VARCHAR2(255 CHAR)
ASIAN_IND		Applicant's Asian race status	VARCHAR2(1 CHAR)
BOSTON_RESIDENCE_IND		Indicates whether applicant is a resident of Boston	VARCHAR2(1 CHAR)
CALENDAR_EVENT		Currently Under Review	VARCHAR2(50 CHAR)
CAMPUS_PREFERENCE		The preferred campus of the applicant.	VARCHAR2(255 CHAR)
CITIZENSHIP_STATUS		Citizen Indicator.(Y=US, P = perm resident, N=Non-US Citizen)	VARCHAR2(50 CHAR)
CITIZENSHIP_STATUS_DESC		Citizen Indicator description	VARCHAR2(255 CHAR)
COMPLETED_APPLICATION_IND		Counter used for reporting purposes to quickly provide counts of completed applications.	NUMBER(1)
CONVERT_TO_STUDENT_IND		Indicator that shows whether an applicant has been converted to a student based on an accepted application.	VARCHAR2(1 CHAR)
COUNTRY_CITIZENSHIP_CODE		Prior to Global Campus System updates: The nation/country code of citizenship of the applicant After 2022 Freeze and Global Campus System updates:: Country code of the nation where the person maintains citizenship. Note: In the case of dual citizens, it is the citizenship under which they applied to the university.	VARCHAR2(50 CHAR)
COUNTRY_CITIZENSHIP_DESC		The nation/country name/description of citizenship of the applicant	VARCHAR2(255 CHAR)
DENIED_APPLICATION_IND		Counter used for reporting purposes to quickly provide counts of denied applications.	NUMBER(1)
DOMESTIC_STUDENT_IND		Counter used for reporting purposes to quickly provide counts of domestic applications.	NUMBER(1)
EMPLOYER		Based on applicant response (not confirmed), name of applicant's employer.	VARCHAR2(250 CHAR)
EMPLOYMENT_IND		Based on applicant response (not confirmed), indicates if student is currently employed.	VARCHAR2(1 CHAR)
FASTTRACK_IND		Counter used for reporting purposes to quickly provide counts of applications to fast-track degree completion programs.	NUMBER(1)
FREEZE_DATE		Date on which data were frozen	DATE
GENDER		The gender of a person, e.g. Male, Female.	VARCHAR2(50 CHAR)
GENDER_DESC		Description of applicant's gender	VARCHAR2(255 CHAR)
HIGH_SCHOOL_NAME		Based on applicant response (not confirmed), indicates name of high school attended.	VARCHAR2(250 CHAR)
HOME_CAMPUS_CD	HOME CAMPUS CD	The approved campus location assigned to a student or employee upon application, enrollment or hiring.	VARCHAR2(63)
HOME_CAMPUS_COUNTRY	HOME CAMPUS COUNTRY	The nation of a student's Home Campus Cd.	VARCHAR2(63)
HOME_CAMPUS_COUNTRY_DESC	HOME CAMPUS COUNTRY DESC	Description of HOME CAMPUS COUNTRY	VARCHAR2(255)
HOME_CAMPUS_DESC	HOME CAMPUS DESC	Description of HOME CAMPUS CD	VARCHAR2(255)
INTERNATIONAL_STUDENT_IND		Counter used for reporting purposes to quickly provide counts of international applications.	NUMBER(1)
INT_ADDRESS_IND		International address indicator	VARCHAR2(50 CHAR)
IPEDS_ETHNICITY_RACE_CD		Race/ethnicity based on requirements from the "Integrated Postsecondary Education Data System (IPEDS)"	VARCHAR2(2 CHAR)
IPEDS_ETHNICITY_RACE_NAME		Description of IPEDS Ethnicity Race Code	VARCHAR2(250 CHAR)
NATION_BIRTH_CODE		Country of birth	VARCHAR2(50 CHAR)
NATION_BIRTH_DESC		Description of country of birth	VARCHAR2(255 CHAR)
NEW_ETHNIC_IND		Does applicant self-identify as hispanic/ latino	VARCHAR2(1 CHAR)
NUID		Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(10 CHAR)
PACIFIC_ISLDR_IND		Applicant's Pacific Islander ethnicity status	VARCHAR2(1 CHAR)
PERM_COUNTRY		The country associated with the permanent address of the applicant	VARCHAR2(50 CHAR)
PERM_COUNTRY_DESC		Name/description of the country associated with the permanent address of the applicant	VARCHAR2(255 CHAR)
PERM_STATE_CODE		The state associated with the permanent address of the applicant	VARCHAR2(50 CHAR)
PERM_ZIP		The postal code associated with the permanent address of the applicant	VARCHAR2(120 CHAR)
POPULATION_CD_1		The first admissions attribute for the application.	VARCHAR2(10 CHAR)
POPULATION_CD_2		The second admissions attribute for the application.	VARCHAR2(10 CHAR)
POPULATION_CD_3		The third admissions attribute for the application.	VARCHAR2(10 CHAR)
POPULATION_CD_4		The fourth admissions attribute for the application.	VARCHAR2(10 CHAR)
POPULATION_CD_5		The fifth admissions attribute for the application.	VARCHAR2(10 CHAR)
POPULATION_DESC_1		Description for the first admissions attribute for the application	VARCHAR2(50 CHAR)
POPULATION_DESC_2		Description for the second admissions attribute for the application	VARCHAR2(50 CHAR)
POPULATION_DESC_3		Description for the third admissions attribute for the application	VARCHAR2(50 CHAR)
POPULATION_DESC_4		Description for the fourth admissions attribute for the application	VARCHAR2(50 CHAR)
POPULATION_DESC_5		Description for the fifth admissions attribute for the application	VARCHAR2(50 CHAR)
PROGRAM_TYPE		Degree type, such as Master's, Associate; also used to identify unique program formats such as Fast-Track	VARCHAR2(255 CHAR)
REGION		US region of the applicant based on their permanent state code	VARCHAR2(2 CHAR)
REGION_DESC		Description of US region of the applicant	VARCHAR2(50 CHAR)
SCHOLARSHIP_TYPE		Proposed scholarship to be awarded	VARCHAR2(50 CHAR)
SCHOLARSHIP_TYPE_DESC		Description of proposed scholarship to be awarded	VARCHAR2(255 CHAR)
SECOND_NATION_CITIZENSHIP_CODE	SECOND NATION CITIZENSHIP CODE	A country code for a nationality that a dual citizen maintains, but did not indicate as the primary nation of citizenship in regards to their Home Campus.	VARCHAR2(63)
SECOND_NATION_CITIZENSHIP_DESC	SECOND NATION CITIZENSHIP DESC	Description of SECOND NATION CITIZENSHIP CODE.	VARCHAR2(255)
STUDENT_LEVEL		Student level, GP UP	VARCHAR2(50 CHAR)
STUDENT_LEVEL_DESC		Student level description	VARCHAR2(100 CHAR)
SUBMITTED_APPLICATION_IND		Counter used for reporting purposes to quickly provide counts of submitted applications.	NUMBER(1)
TERM_START_DATE		Currently Under Review	DATE
TRANSFER_CREDIT_REQUESTED_IND		Indicator for whether the applicant has indicated a desire to transfer credit; this does not mean the transfer credit is approved.	VARCHAR2(3 CHAR)
VETERAN_IND		Applicant's White/Caucasian race status	VARCHAR2(1 CHAR)
WHITE_IND		Applicant's White/Caucasian race status	VARCHAR2(1 CHAR)