| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Academic Period
|
Academic period representing the accounts receivable term for disbursement from the applicant award schedule table.
|
VARCHAR2(63)
|
|
RPRATRM
|
RPRATRM_TERM_CODE
|
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
|
STVTERM
|
STVTERM_ACYR_CODE
|
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACCEPT_AMOUNT
|
Accept Amount
|
Amount accepted by the student for the indicated financial aid fund for this aid year.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_ACCEPT_AMT
|
|
ACTIVITY1
|
Activity 1
|
Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ACTC_CODE
|
|
ACTIVITY2
|
Activity 2
|
Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ACTC_CODE
|
|
ACTIVITY3
|
Activity 3
|
Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ACTC_CODE
|
|
ACTIVITY4
|
Activity 4
|
Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ACTC_CODE
|
|
ACTIVITY5
|
Activity 5
|
Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ACTC_CODE
|
|
ACTIVITY_DESC1
|
Activity Description 1
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACTIVITY_DESC2
|
Activity Description 2
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACTIVITY_DESC3
|
Activity Description 3
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACTIVITY_DESC4
|
Activity Description 4
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACTIVITY_DESC5
|
Activity Description 5
|
Activity code that represents the sport participation.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
AGE
|
Age
|
Calculated age (subtract the birth date from the current system date).
|
NUMBER
|
|
FUNCTION
|
F_CALCULATE_AGE
|
|
AID_ENROLLMENT_PERIOD
|
Aid Enrollment Period
|
Aid enrollment period associated with the award schedule. This period can span multiple student terms.
|
VARCHAR2(63)
|
|
RPRATRM
|
RPRATRM_PERIOD
|
|
AID_ENROLLMENT_PERIOD_DESC
|
Aid Enrollment Period Description
|
Aid enrollment period description.
|
VARCHAR2(255)
|
|
ROBPRDS
|
ROBPRDS_DESC
|
|
AID_PERIOD
|
Aid Period
|
Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.
|
VARCHAR2(63)
|
|
RPRATRM
|
RPRATRM_AIDY_CODE
|
|
AID_PERIOD_DESC
|
Aid Period Description
|
Financial Aid period description.
|
VARCHAR2(255)
|
|
RTVAPRD
|
RTVAPRD_DESC
|
|
AID_YEAR
|
Aid Year
|
Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).
|
VARCHAR2(63)
|
|
RPRAWRD
|
RPRAWRD_AIDY_CODE
|
|
AID_YEAR_DESC
|
Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
|
ROBINST
|
ROBINST_AIDY_DESC
|
|
ATHLETIC_AID_IND1
|
Athletic Aid Indicator 1
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
VARCHAR2(1)
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
ATHLETIC_AID_IND2
|
Athletic Aid Indicator 2
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
VARCHAR2(1)
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
ATHLETIC_AID_IND3
|
Athletic Aid Indicator 3
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
VARCHAR2(1)
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
ATHLETIC_AID_IND4
|
Athletic Aid Indicator 4
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
VARCHAR2(1)
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
ATHLETIC_AID_IND5
|
Athletic Aid Indicator 5
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
VARCHAR2(1)
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
BIRTH_DATE
|
Birth Date
|
Date of birth for the person.
|
DATE
|
|
SPBPERS
|
SPBPERS_BIRTH_DATE
|
|
COHORT1
|
Cohort 1
|
Cohort tracking group assigned to the person through the Administrative UI display rules.
|
VARCHAR2(63)
|
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
|
COHORT2
|
Cohort 2
|
Cohort tracking group assigned to the person through the Administrative UI display rules.
|
VARCHAR2(63)
|
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
|
COHORT3
|
Cohort 3
|
Cohort tracking group assigned to the person through the Administrative UI display rules.
|
VARCHAR2(63)
|
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
|
COHORT_DESC1
|
Cohort Description 1
|
Cohort tracking group description assigned to the person.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
COHORT_DESC2
|
Cohort Description 2
|
Cohort tracking group description assigned to the person.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
COHORT_DESC3
|
Cohort Description 3
|
Cohort tracking group description assigned to the person.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
COHORT_RULE
|
Cohort Rule
|
Display rule set up in MGRSDAX that determines which cohort values are displayed for this person. Institution defined.
|
VARCHAR2(63)
|
|
MGRSDAX
|
MGRSDAX_INTERNAL_CODE
|
|
DECLINE_AMOUNT
|
Decline Amount
|
Total amount of this fund declined by the student's for this aid year.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_DECLINE_AMT
|
|
DISBURSED_AMT
|
Disbursed Amount
|
Financial aid award sum disbursed for the time frame with a fund source type indicator equal to federal, and a fund type indicator equal to grant.
|
NUMBER
|
|
FUNCTION FUNCTION
|
ROKODSF.F_CALCULATE_DISB_AMTS ROKODSF.F_GET_TOTAL_DISBURSED
|
|
ELIGIBILITY1
|
Eligibility 1
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
ELIGIBILITY2
|
Eligibility 2
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
ELIGIBILITY3
|
Eligibility 3
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
ELIGIBILITY4
|
Eligibility 4
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
ELIGIBILITY5
|
Eligibility 5
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
FINANCIAL_AID_TYPE
|
Financial Aid Type
|
Aid fund type code defined as one of the following grant, loan, scholarship or grant for the aid fund.
|
VARCHAR2(63)
|
|
RTVFTYP
|
RTVFTYP_ATYP_IND
|
|
FINANCIAL_AID_TYPE_DESC
|
Financial Aid Type Description
|
Financial aid type description.
|
VARCHAR2(255)
|
|
RTVFTYP
|
RTVFTYP_DESC
|
|
FIRST_NAME
|
First Name
|
The first name given to a person at birth, baptism, another naming ceremony or through legal change.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
|
FUND
|
Fund
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
|
RPRADSB
|
RPRADSB_FUND_CODE
|
|
FUND_SOURCE_TYPE
|
Fund Source Type
|
Identifies the source of the financial assistance.
|
VARCHAR2(63)
|
|
RFRBASE
|
RFRBASE_FSRC_CODE
|
|
FUND_SOURCE_TYPE_DESC
|
Fund Source Type Description
|
Financial assistance sources descriptions. For example, External, Federal, Institutional, State or Other.
|
VARCHAR2(255)
|
|
RTVFSRC
|
RTVFSRC_DESC
|
|
FUND_TITLE
|
Fund Title
|
Descriptive title for the fund.
|
VARCHAR2(255)
|
|
RFRBASE
|
RFRBASE_FUND_TITLE
|
|
GENDER
|
Gender
|
Person's gender. Values are Male, Female or Not reported to the institution.
|
VARCHAR2(63)
|
|
SPBPERS
|
SPBPERS_SEX
|
|
GENDER_DESC
|
Gender Description
|
Identify as Male, Female or Not reported.
|
VARCHAR2(63)
|
|
CALCULATION
|
DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')
|
|
HISPANIC_LATINO_ETHNICITY_IND
|
Hispanic Latino Ethinicity Indicator
|
Indicates if person's ethnicity is Latino or Hispanic. Due to mandated changes to the collection of race and ethnicity, these classifications were changed to separate Race and Ethnicity. Ethnicity can now be defined as either Hispanic or Latino, or Not Hispanic or Latino.
|
VARCHAR2(1)
|
|
SPBPERS
|
SPBPERS_ETHN_CDE
|
|
ID
|
ID
|
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to eachuniversity constituent.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_ID
|
|
LAST_ACADEMIC_PERIOD
|
Last Academic Period
|
Last academic period the student attended the institution.
|
VARCHAR2(63)
|
|
FUNCTION
|
MSKFUNC.F_GET_LAST_ACADEMIC_PERIOD
|
|
LAST_NAME
|
Last Name
|
The last name by which a person is known.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
MIDDLE_NAME
|
Middle Name
|
A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_MI
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
OFFER_AMOUNT
|
Offer Amount
|
Maintains the current amount of the award fund offered.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_OFFER_AMT
|
|
PAID_AMOUNT
|
Paid Amount
|
Total amount offered and then paid from this fund.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_PAID_AMT
|
|
PERSON_UID
|
Person UID
|
System generated Banner unique ID which gets assigned to all person and non-person records within Banner.
|
NUMBER
|
|
SGBSTDN
|
SGBSTDN_PIDM
|
|
PRIMARY_ETHNICITY
|
Primary Ethnicity
|
Person's reported ethnicity.
|
VARCHAR2(63)
|
|
SPBPERS
|
SPBPERS_ETHN_CODE
|
|
PRIMARY_ETHNICITY_DESC
|
Primary Ethnicity Description
|
Ethnic code description.
|
VARCHAR2(255)
|
|
STVETHN
|
STVETHN_DESC
|
|
PRIM_ETHNICITY_CATEGORY
|
Primary Ethnicity
|
Person's reported ethnicity.
|
VARCHAR2(63)
|
|
SPBPERS
|
SPBPERS_ETHN_CODE
|
|
PRIM_ETHNICITY_CATEGORY_DESC
|
Primary Ethnicity Description
|
Ethnic Code Description
|
VARCHAR2(255)
|
|
STVETHN
|
STVETHN_DESC
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
RACE_CATEGORY_COUNT
|
Race Category Count
|
Number of unique regulatory races selected by this person.
|
NUMBER
|
|
FUNCTION
|
MGKFUNC.F_COUNT_RACE_CATEGORY
|
|
RACE_COUNT
|
Race Count
|
Number of races selected by this person.
|
NUMBER
|
|
FUNCTION
|
MGKFUNC.F_COUNT_RACE
|
|
RACE_ETHNICITY_CONFIRM_DATE
|
Race Ethnicity Confirm Date
|
Race and ethnicity self confirmed date.
|
DATE
|
|
SPBPERS
|
SPBPERS_CONFIRMED_RE_DATE
|
|
RACE_ETHNICITY_CONFIRM_IND
|
Race Ethnicity Confirm Indicator
|
Indicates if the person's race and ethnicity have been self-identified.
|
VARCHAR2(1)
|
|
SPBPERS
|
SPBPERS_CONFIRMED_RE_CDE
|
|
SPORT_STATUS1
|
Sport Status 1
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
SPORT_STATUS2
|
Sport Status 2
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
SPORT_STATUS3
|
Sport Status 3
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
SPORT_STATUS4
|
Sport Status 4
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
SPORT_STATUS5
|
Sport Status 5
|
Current status for the sport participation for the sport selected in the display rules.
|
VARCHAR2(63)
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
SPORT_STATUS_DESC1
|
Sport Status Description 1
|
Student participation status description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SPORT_STATUS_DESC2
|
Sport Status Description 2
|
Student participation status description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SPORT_STATUS_DESC3
|
Sport Status Description 3
|
Student participation status description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SPORT_STATUS_DESC4
|
Sport Status Description 4
|
Student participation status description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SPORT_STATUS_DESC5
|
Sport Status Description 5
|
Student participation status description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STUDENT_ACADEMIC_PERIOD
|
Academic Period
|
Academic period representing the term to pull the student data used for the aid enrollment period. As an example, student classification, or student.
|
VARCHAR2(63)
|
|
RORPRDS
|
RORPRDS_TERM_CODE
|
|
STUDENT_ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
|
STVTERM
|
STVTERM_DESC
|
|
STUDENT_LEVEL
|
Student Level
|
Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.
|
VARCHAR2(63)
|
|
SGBSTDN SORLCUR
|
SGBSTDN_LEVL_CODE SORLCUR_LEVL_CODE
|
|
STUDENT_LEVEL_DESC
|
Student Level Description
|
Level name associated with the academic study for which the student applied. For example, undergraduate, graduate, etc.
|
VARCHAR2(255)
|
|
STVLEVL
|
STVLEVL_DESC
|
|
TAX_ID
|
Tax ID
|
Tax Identification Number (TIN) is a number which gets assigned by the government to companies (vendors) in the United States of America, for purposes of the IRS and Department of Revenue. Each company is assigned a unique TIN.
|
VARCHAR2(63)
|
|
SPBPERS
|
SPBPERS_SSN
|
|
TOTAL_CREDITS
|
Total Credits
|
Total credits for the student for this academic period.
|
NUMBER
|
|
FUNCTION
|
F_CALC_REGISTRATION_HOURS
|