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)
|
|
|
|
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)
|
|
|
|
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)
|
|
|
|
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_NUM
|
|
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)
|
|
|
|
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)
|
|
|
|
BIRTHDAY
|
|
Date of birth of person.
|
DATE
|
|
|
|
BOSTON_RESIDENCE_IND
|
|
Indicates whether applicant is a resident of Boston
|
VARCHAR2(1 CHAR)
|
|
|
|
CAMPUS_PREFERENCE
|
|
The preferred campus of the applicant.
|
VARCHAR2(255 CHAR)
|
|
|
|
CITIZENSHIP_STATUS
|
|
Prior to Global Campus System updates: Citizen Indicator.(Y=US, P = perm resident, N=Non-US Citizen)
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_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)
|
|
|
|
COMPLETION_DATE
|
|
Date on which the applicant completed their application.
|
DATE
|
|
|
|
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(50 CHAR)
|
|
|
|
EMPLOYMENT_JOB_TITLE
|
|
Based on applicant response (not confirmed), applicant's job title.
|
VARCHAR2(250 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)
|
|
|
|
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(50 CHAR)
|
|
|
|
IPEDS_ETHNICITY_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(50 CHAR)
|
|
|
|
LATEST_DECISION_DATE
|
|
Date of Latest Decision
|
DATE
|
|
|
|
LATEST_DECISION_DESC
|
|
Description of Latest Decision
|
VARCHAR2(255 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)
|
|
|
|
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_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(255 CHAR)
|
|
|
|
PUBLISH_DATE
|
|
The date on which applicant's admissions decision was released to the applicant.
|
DATE
|
|
|
|
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)
|
|
|
|
SUBMISSION_DATE
|
|
Date on which the applicant submitted their application.
|
DATE
|
|
|
|
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)
|
|
|
|
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)
|
|
|
|