Reporting View Target: Z_NEU_ADM_CPS_CENSUS

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_CENSUS_VW

Description Frozen 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. Data is frozen three times per term at census date, second half and end of term as defined by registrar calendar. 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.

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

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

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

ADMISSION_WEEK_EVENT Value (expressed as week number) representing the number of weeks from the beginning of the CPS Admission analysis cycle. It provides Admission analysis cycle time measurement. 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)

ANTICIPATED_ENRLL_QTR_CODE This term is initially populated with whatever was in [Applied_Term] upon application submission.. In the absence of a decision, this term indicates the term for which the application will be considered. The term here may be updated to rollover the application into a new term only if the applicant indicates interest in completing the application for a future 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(10 CHAR)

ANTICIPATED_ENRLL_QTR_DESC Term description VARCHAR2(255 CHAR)

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

APPLICANT_CATEGORY_DESC Description of applicant category VARCHAR2(50 CHAR)

APPLICATION_DATE The date associated with the most current status of the application. DATE

APPLICATION_ID Unique source system application ID VARCHAR2(50 CHAR)

APPLICATION_NUMBER System generated application tracking number VARCHAR2(50 CHAR)

APPLICATION_STATUS Key stages in an application that are useful to track for reporting purposes, e.g. Incomplete, Complete, Denied, Accepted, Withdrawn VARCHAR2(50 CHAR)

APPLICATION_STATUS_DESC Description of Application Status VARCHAR2(255 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(50 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(10 CHAR)

APPLY_TERM_DESC Term Description VARCHAR2(255 CHAR)

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

BIRTH_DATE Date of birth of person. DATE

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

CALENDAR_WEEK_EVENT Week number of the current calendar year. VARCHAR2(50 CHAR)

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

CITIZENSHIP_TYPE Prior to Global Campus System updates: Indicated whether the person has been identified as a citizen of the United States. After 2022 Freeze and Global Campus System updates: Indicates whether the person is a citizen or permanent resident of their home campus country. VARCHAR2(50 CHAR)

CITIZENSHIP_TYPE_DESC Citizen Indicator description VARCHAR2(255 CHAR)

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

COMPLETION_DATE Date on which the applicant completed their application. VARCHAR2(50 CHAR)

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

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)

DECISION Admission decision VARCHAR2(50 CHAR)

DECISION_DATE The date on which the final admissions decision is posted internally. DATE

DECISION_DESC Description of admission decision 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)

EMAIL Indicates email address for person. VARCHAR2(255 CHAR)

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)

EMPLOYMENT_JOB_TITLE Based on applicant response (not confirmed), applicant's job title. VARCHAR2(250 CHAR)

EVENT a description of the predefined freeze event as one of stat date freeze, degree data freeze, end of term freeze, etc. VARCHAR2(100 CHAR)

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

FIRST_NAME The first name given to a person at birth, baptism, another naming ceremony or through legal change. VARCHAR2(63 CHAR)

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)

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

HOME_CAMPUS_CD HOME CAMPUS CD The approved campus location assigned to a student or employee upon application, enrollment or hiring. Added after 202210 Freeze as part of Global Campus Systems upgrade. VARCHAR2(63)

HOME_CAMPUS_COUNTRY HOME CAMPUS COUNTRY The nation of a student's Home Campus Cd. Added after 202210 Freeze as part of Global Campus Systems upgrade. VARCHAR2(63)

HOME_CAMPUS_COUNTRY_DESC HOME CAMPUS COUNTRY DESC Description of HOME CAMPUS COUNTRY. Added after 202210 Freeze as part of Global Campus Systems upgrade. VARCHAR2(255)

HOME_CAMPUS_DESC HOME CAMPUS DESC Description of HOME CAMPUS CD. Added after 202210 Freeze as part of Global Campus Systems upgrade. VARCHAR2(255)

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

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

INTL_ADDRESS_IND International address indicator VARCHAR2(50 CHAR)

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

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

LAST_NAME The last name by which a person is known. VARCHAR2(63 CHAR)

LATEST_DECISION The date of the most recent decision for an application and academic term. VARCHAR2(255 CHAR)

LATEST_DECISION_DATE Date of Latest Decision VARCHAR2(50 CHAR)

LATEST_DECISION_DESC Description of Latest Decision VARCHAR2(50 CHAR)

LOCAL_CITY The city associated with the local address of the applicant VARCHAR2(200 CHAR)

LOCAL_COUNTRY The country associated with the local address of the applicant VARCHAR2(50 CHAR)

LOCAL_COUNTRY_DESC Name/description of the country associated with the local address of the applicant VARCHAR2(255 CHAR)

LOCAL_STATE_CODE The state associated with the local address of the applicant VARCHAR2(50 CHAR)

LOCAL_STREET1 The first address line associated with the local address of the applicant VARCHAR2(300 CHAR)

LOCAL_STREET2 The second address line associated with the local address of the applicant VARCHAR2(300 CHAR)

LOCAL_ZIP The postal code associated with the local address of the applicant VARCHAR2(120 CHAR)

MIDDLE_NAME A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change. VARCHAR2(63 CHAR)

NATION_BIRTH_CODE Country of birth VARCHAR2(50 CHAR)

NATION_BIRTH_DESC Description of country of birth VARCHAR2(255 CHAR)

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

PERM_CITY The city associated with the permanent address of the applicant VARCHAR2(200 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_STREET1 The first address line associated with the permanent address of the applicant VARCHAR2(300 CHAR)

PERM_STREET2 The second address line associated with the permanent address of the applicant VARCHAR2(300 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)

PREFIX An appellation used to connote rank, placement or status. A title that precedes person name. VARCHAR2(63 CHAR)

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

PUBLISH_DATE Date on which applicant's admission decision was released 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. Added after 202210 Freeze as part of Global Campus Systems upgrade. VARCHAR2(63)

SECOND_NATION_CITIZENSHIP_DESC SECOND NATION CITIZENSHIP DESC Description for SECOND NATION CITIZENSHIP CODE. Added after 202210 Freeze as part of Global Campus Systems upgrade. VARCHAR2(255)

SPECIAL_STUDENT_STATUS_IND Indicator that shows whether an applicant was designated as a special student at any point during the application process. VARCHAR2(1)

STUDENT_LEVEL Student level, GP UP VARCHAR2(50 CHAR)

STUDENT_LEVEL_DESC Student level description VARCHAR2(100 CHAR)

SUBMISSION_DATE Date on which the applicant submitted their application. VARCHAR2(50 CHAR)

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

SUFFIX A name suffix, in the western naming tradition, follows a person's full name and provides additional information about the person. There are academic, honorary, professional and inherited (social) name suffixes. VARCHAR2(63 CHAR)

TERM_START_DATE First day of the ACADEMIC_PERIOD_NUFREEZE term. 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(1 CHAR)

VETERAN_IND Based on applicant response (not confirmed), indicates if student is a veteran. 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
ACCEPTED_APPLICATION_IND		Counter used for reporting purposes to quickly provide counts of admitted applications.	NUMBER(1)
ACTIVE_DUTY_MILITARY_IND		Based on applicant response (not confirmed), indicates if student is currently on military active duty .	VARCHAR2(1 CHAR)
ADMISSION_WEEK_EVENT		Value (expressed as week number) representing the number of weeks from the beginning of the CPS Admission analysis cycle. It provides Admission analysis cycle time measurement.	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)
ANTICIPATED_ENRLL_QTR_CODE		This term is initially populated with whatever was in [Applied_Term] upon application submission.. In the absence of a decision, this term indicates the term for which the application will be considered. The term here may be updated to rollover the application into a new term only if the applicant indicates interest in completing the application for a future 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(10 CHAR)
ANTICIPATED_ENRLL_QTR_DESC		Term description	VARCHAR2(255 CHAR)
APPLICANT_CATEGORY		The admission type of the applicant	VARCHAR2(255 CHAR)
APPLICANT_CATEGORY_DESC		Description of applicant category	VARCHAR2(50 CHAR)
APPLICATION_DATE		The date associated with the most current status of the application.	DATE
APPLICATION_ID		Unique source system application ID	VARCHAR2(50 CHAR)
APPLICATION_NUMBER		System generated application tracking number	VARCHAR2(50 CHAR)
APPLICATION_STATUS		Key stages in an application that are useful to track for reporting purposes, e.g. Incomplete, Complete, Denied, Accepted, Withdrawn	VARCHAR2(50 CHAR)
APPLICATION_STATUS_DESC		Description of Application Status	VARCHAR2(255 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(50 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(10 CHAR)
APPLY_TERM_DESC		Term Description	VARCHAR2(255 CHAR)
ASIAN_IND		Applicant's Asian race status	VARCHAR2(1 CHAR)
BIRTH_DATE		Date of birth of person.	DATE
BOSTON_RESIDENCE_IND		Indicates whether applicant is a resident of Boston	VARCHAR2(1 CHAR)
CALENDAR_WEEK_EVENT		Week number of the current calendar year.	VARCHAR2(50 CHAR)
CAMPUS_PREFERENCE		The preferred campus of the applicant.	VARCHAR2(50 CHAR)
CITIZENSHIP_TYPE		Prior to Global Campus System updates: Indicated whether the person has been identified as a citizen of the United States. After 2022 Freeze and Global Campus System updates: Indicates whether the person is a citizen or permanent resident of their home campus country.	VARCHAR2(50 CHAR)
CITIZENSHIP_TYPE_DESC		Citizen Indicator description	VARCHAR2(255 CHAR)
COMPLETED_APPLICATION_IND		Counter used for reporting purposes to quickly provide counts of completed applications.	NUMBER(1)
COMPLETION_DATE		Date on which the applicant completed their application.	VARCHAR2(50 CHAR)
CONVERT_TO_STUDENT_IND		Indicator that shows whether an applicant has been converted to a student based on an accepted application.	VARCHAR2(1)
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)
DECISION		Admission decision	VARCHAR2(50 CHAR)
DECISION_DATE		The date on which the final admissions decision is posted internally.	DATE
DECISION_DESC		Description of admission decision	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)
EMAIL		Indicates email address for person.	VARCHAR2(255 CHAR)
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)
EMPLOYMENT_JOB_TITLE		Based on applicant response (not confirmed), applicant's job title.	VARCHAR2(250 CHAR)
EVENT		a description of the predefined freeze event as one of stat date freeze, degree data freeze, end of term freeze, etc.	VARCHAR2(100 CHAR)
FASTTRACK_IND		Counter used for reporting purposes to quickly provide counts of applications to fast-track degree completion programs.	NUMBER(1)
FIRST_NAME		The first name given to a person at birth, baptism, another naming ceremony or through legal change.	VARCHAR2(63 CHAR)
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)
HISPANIC_LATINO_IND		Does applicant self-identify as hispanic/ latino	VARCHAR2(1 CHAR)
HOME_CAMPUS_CD	HOME CAMPUS CD	The approved campus location assigned to a student or employee upon application, enrollment or hiring. Added after 202210 Freeze as part of Global Campus Systems upgrade.	VARCHAR2(63)
HOME_CAMPUS_COUNTRY	HOME CAMPUS COUNTRY	The nation of a student's Home Campus Cd. Added after 202210 Freeze as part of Global Campus Systems upgrade.	VARCHAR2(63)
HOME_CAMPUS_COUNTRY_DESC	HOME CAMPUS COUNTRY DESC	Description of HOME CAMPUS COUNTRY. Added after 202210 Freeze as part of Global Campus Systems upgrade.	VARCHAR2(255)
HOME_CAMPUS_DESC	HOME CAMPUS DESC	Description of HOME CAMPUS CD. Added after 202210 Freeze as part of Global Campus Systems upgrade.	VARCHAR2(255)
ID		Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(10 CHAR)
INTERNATIONAL_STUDENT_IND		Counter used for reporting purposes to quickly provide counts of international applications.	NUMBER(1)
INTL_ADDRESS_IND		International address indicator	VARCHAR2(50 CHAR)
IPEDS_RACE_CD		Race/ethnicity based on requirements from the "Integrated Postsecondary Education Data System (IPEDS)"	VARCHAR2(50 CHAR)
IPEDS_RACE_NAME		Description of IPEDS Ethnicity Race Code	VARCHAR2(250 CHAR)
LAST_NAME		The last name by which a person is known.	VARCHAR2(63 CHAR)
LATEST_DECISION		The date of the most recent decision for an application and academic term.	VARCHAR2(255 CHAR)
LATEST_DECISION_DATE		Date of Latest Decision	VARCHAR2(50 CHAR)
LATEST_DECISION_DESC		Description of Latest Decision	VARCHAR2(50 CHAR)
LOCAL_CITY		The city associated with the local address of the applicant	VARCHAR2(200 CHAR)
LOCAL_COUNTRY		The country associated with the local address of the applicant	VARCHAR2(50 CHAR)
LOCAL_COUNTRY_DESC		Name/description of the country associated with the local address of the applicant	VARCHAR2(255 CHAR)
LOCAL_STATE_CODE		The state associated with the local address of the applicant	VARCHAR2(50 CHAR)
LOCAL_STREET1		The first address line associated with the local address of the applicant	VARCHAR2(300 CHAR)
LOCAL_STREET2		The second address line associated with the local address of the applicant	VARCHAR2(300 CHAR)
LOCAL_ZIP		The postal code associated with the local address of the applicant	VARCHAR2(120 CHAR)
MIDDLE_NAME		A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change.	VARCHAR2(63 CHAR)
NATION_BIRTH_CODE		Country of birth	VARCHAR2(50 CHAR)
NATION_BIRTH_DESC		Description of country of birth	VARCHAR2(255 CHAR)
PACIFIC_ISLDR_IND		Applicant's Pacific Islander ethnicity status	VARCHAR2(1 CHAR)
PERM_CITY		The city associated with the permanent address of the applicant	VARCHAR2(200 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_STREET1		The first address line associated with the permanent address of the applicant	VARCHAR2(300 CHAR)
PERM_STREET2		The second address line associated with the permanent address of the applicant	VARCHAR2(300 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)
PREFIX		An appellation used to connote rank, placement or status. A title that precedes person name.	VARCHAR2(63 CHAR)
PROGRAM_TYPE		Degree type, such as Master's, Associate; also used to identify unique program formats such as Fast-Track	VARCHAR2(50 CHAR)
PUBLISH_DATE		Date on which applicant's admission decision was released	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. Added after 202210 Freeze as part of Global Campus Systems upgrade.	VARCHAR2(63)
SECOND_NATION_CITIZENSHIP_DESC	SECOND NATION CITIZENSHIP DESC	Description for SECOND NATION CITIZENSHIP CODE. Added after 202210 Freeze as part of Global Campus Systems upgrade.	VARCHAR2(255)
SPECIAL_STUDENT_STATUS_IND		Indicator that shows whether an applicant was designated as a special student at any point during the application process.	VARCHAR2(1)
STUDENT_LEVEL		Student level, GP UP	VARCHAR2(50 CHAR)
STUDENT_LEVEL_DESC		Student level description	VARCHAR2(100 CHAR)
SUBMISSION_DATE		Date on which the applicant submitted their application.	VARCHAR2(50 CHAR)
SUBMITTED_APPLICATION_IND		Counter used for reporting purposes to quickly provide counts of submitted applications.	NUMBER(1)
SUFFIX		A name suffix, in the western naming tradition, follows a person's full name and provides additional information about the person. There are academic, honorary, professional and inherited (social) name suffixes.	VARCHAR2(63 CHAR)
TERM_START_DATE		First day of the ACADEMIC_PERIOD_NUFREEZE term.	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(1 CHAR)
VETERAN_IND		Based on applicant response (not confirmed), indicates if student is a veteran.	VARCHAR2(1 CHAR)
WHITE_IND		Applicant's White/Caucasian race status	VARCHAR2(1 CHAR)