| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACADEMIC_YEAR_OVERRIDE
|
Academic Year Override
|
Academic year to use for ACG and SMART Grant eligibility.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_OVERRIDE_YR_IN_COLL
|
|
ACADEMIC_YEAR_OVERRIDE_DESC
|
Academic Year Override Description
|
Year in college override description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACTIVE_FINAID_HOLD_IND
|
Active Financial Aid Hold Indicator
|
Indicates that the applicant has a hold.
|
VARCHAR2(1)
|
|
FUNCTION
|
MRKFUNC.F_CHECK_FOR_ACTIVE_HOLD
|
|
ACTIVITY_DATE
|
Activity Date
|
Date record was inserted or updated
|
DATE
|
|
RPRAWRD
|
RPRAWRD_ACTIVITY_DATE
|
|
ADDITIONAL_PELL_AWARDS
|
Additional Pell Awards
|
Indicates whether student is receiving a second Pell award for the aid year.
|
VARCHAR2(1)
|
|
RORSTAT
|
RORSTAT_PELL_ORIG_IND
|
|
ADDITIONAL_PELL_AWARDS_DESC
|
Award By Aid Year
|
Additional Pell award description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ADDITIONAL_STAFFORD_AWARDS
|
Additional Stafford Awards
|
Indicates if the applicant is eligible for additional Stafford awards.
|
VARCHAR2(1)
|
|
RORSTAT
|
RORSTAT_ADDL_STFD_ELIG_IND
|
|
ADDITIONAL_STAFFORD_AWRDS_DESC
|
Additional Stafford Awards Description
|
Additional Stafford awards description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
AID_PERIOD
|
Financial 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)
|
|
RORSTAT
|
RORSTAT_APRD_CODE
|
|
AID_PERIOD_DESC
|
Financial Aid Period Description
|
Financial Aid period description.
|
VARCHAR2(255)
|
|
RTVAPRD
|
RTVAPRD_DESC
|
|
AID_YEAR
|
Financial 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
|
Financial Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
|
ROBINST
|
ROBINST_AIDY_DESC
|
|
ANNUAL_AWARD_ACCESS_IND
|
Annual Award Access Indicator
|
Allows information for this award to be accessed via Banner Web, Voice Response and similar methods.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_INFO_ACCESS_IND
|
|
ANNUAL_AWARD_AUTHORIZE_AMOUNT
|
Annual Award Authorize Amount
|
Authorized amount of financial aid for this fund.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_AUTHORIZE_AMT
|
|
ANNUAL_AWARD_AUTHORIZE_DATE
|
Annual Award Authorize Date
|
Date of the award authorization.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_AUTHORIZE_DATE
|
|
ANNUAL_AWARD_CANCEL_AMOUNT
|
Annual Award Cancel Amount
|
Total amount of this fund that was offered and or accepted by the students and then canceled.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_CANCEL_AMT
|
|
ANNUAL_AWARD_CANCEL_DATE
|
Annual Award Cancel Date
|
Date that the award was cancelled.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_CANCEL_DATE
|
|
ANNUAL_AWARD_LAST_WEB_UPDATE
|
Annual Award Last Web Update
|
Date the award was last updated by web activity.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_LAST_WEB_UPDATE
|
|
ANNUAL_AWARD_LOCKED
|
Annual Award Locked
|
Aid year based lock code.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_LOCK_IND
|
|
ANNUAL_AWARD_LOCKED_DESC
|
Annual Award Locked Description
|
Annual award locked description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ANNUAL_AWARD_MEMO_AMOUNT
|
Annual Award Memo Amount
|
Displays the amount of the memo'd or authorized award.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_MEMO_AMT
|
|
ANNUAL_AWARD_MEMO_DATE
|
Annual Award Memo Date
|
Date of the memo'd award.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_MEMO_DATE
|
|
AWARD_OFFER_EXPIRATION_DATE
|
Award Offer Expiration Date
|
Expiration date of the award offer.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_OFFER_EXP_DATE
|
|
AWARD_STATUS
|
Award Status
|
Current status for the financial aid award.
|
VARCHAR2(63)
|
|
RPRAWRD
|
RPRAWRD_AWST_CODE
|
|
AWARD_STATUS_DATE
|
Award Status Date
|
Date that the financial aid award status was changed.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_AWST_DATE
|
|
FEDERAL_LIMIT_OVERRIDE_IND
|
Federal Limit Override Indicator
|
Used to override a federal limit on a fund when manually entering the award.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_FED_LIMIT_OVRDE_IND
|
|
FUND
|
Fund
|
Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
|
RPRAWRD
|
RPRAWRD_FUND_CODE
|
|
FUND_LIMIT_OVERRIDE_IND
|
Fund Limit Override Indicator
|
Used to override the fund limit when manually entering the fund on the students' award record.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_FUND_LIMIT_OVRDE_IND
|
|
FUND_TITLE
|
Fund Title
|
Fund code description or title.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
GROSS_NEED
|
Gross Need
|
Applicant's gross need defined as budget minus EFC, minus resources.
|
NUMBER
|
|
RORSTAT
|
RORSTAT_GRS_NEED
|
|
HEALTH_PROGRAM_IND
|
Health Program Indicator
|
Indicates if applicant qualifies for additional stafford due to enrollment in a health profession program.
|
VARCHAR2(1)
|
|
RORSTAT
|
RORSTAT_FORMER_HEAL_IND
|
|
ID
|
ID
|
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
|
VARCHAR2(63)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
MULTI_SOURCE
|
Multi Source
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
NAME
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
NO_PELL_OVERRIDE_IND
|
Number Pell Override Indicator
|
Indicates if the Pell award validation rule has been overridden for the ACG or SMART Grant award.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_OVERRIDE_NO_PELL
|
|
OFFER_AMOUNT
|
Offer Amount
|
Maintains the current amount of the award fund offered.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_OFFER_AMT
|
|
OFFER_DATE
|
Offer Date
|
Date the award was offered.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_OFFER_DATE
|
|
PACKAGE_COMPLETE_DATE
|
Package Completion Date
|
Date the student's financial aid package was complete.
|
DATE
|
|
RORSTAT
|
RORSTAT_PCKG_COMP_DATE
|
|
PACKAGE_REQUIRE_COMPLETE_DATE
|
Package Requirements Completion Date
|
Date that tracking requirements were satisfied for packaging.
|
DATE
|
|
RORSTAT
|
RORSTAT_PCKG_REQ_COMP_DATE
|
|
PACKAGING_GROUP
|
Packaging Group
|
Assigned packaging group for this financial aid applicant.
|
VARCHAR2(6)
|
|
RORSTAT
|
RORSTAT_PGRP_CODE
|
|
PACKAGING_GROUP_DESC
|
Packaging Group Description
|
Code description assigned to the packaging group.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PELL_ORIGINATION_IND
|
Pell Origination Indicator
|
Indicates an updated Pell origination record is to be created.
|
VARCHAR2(1)
|
|
RORSTAT
|
RORSTAT_PELL_ORIG_IND
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_PIDM
|
|
POST_BACHELORS_DEGREE_IND
|
Post Bachelors Degree Indicator
|
Indicates applicant is eligible to receive Pell Grant even though applicant has earned a Bachelor's degree.
|
VARCHAR2(1)
|
|
RORSTAT
|
RORSTAT_POST_BA_PELL_OVRD
|
|
PREP_TEACHER_ENROLLMENT
|
Prep Teacher Enrollment
|
Indicates if loan limits should be different due to teacher certification enrollment.
|
VARCHAR2(1)
|
|
RORSTAT
|
RORSTAT_PREP_OR_TEACH_IND
|
|
PREP_TEACHER_ENROLLMENT_DESC
|
Prep Teacher Enrollment Description
|
Describes teacher certification enrollment.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PROCESS_GROUP
|
Process Group
|
The institution value of the process-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
REPLACE_TFC_OVERRIDE_IND
|
Replace Total Family Contribution Override Indicator
|
Used to override the rule to replace Expected Family Contribution when manually adding the award to the students' record.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_REPLACE_TFC_OVRDE_IND
|
|
SUBSIDIZED_LOAN_EXCLUSION_AMT
|
Subsidized Loan Exclusion Amount
|
VA Chapter 30 or Americorp amount that should be excluded from subsidized loan eligibility.
|
NUMBER
|
|
RORSTAT
|
RORSTAT_SUB_LOAN_EXCL_AMT
|
|
SYSTEM_IND
|
System Indicator
|
Specifies whether the award was system or manually generated.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_SYS_IND
|
|
SYSTEM_IND_DESC
|
System Indicator Description
|
System description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
TOTAL_ACCEPT_AMOUNT
|
Total Accept Amount
|
Total amount accepted for this fund.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_ACCEPT_AMT
|
|
TOTAL_ACCEPT_DATE
|
Total Accept Date
|
Date the award was accepted.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_ACCEPT_DATE
|
|
TOTAL_DECLINE_AMOUNT
|
Total Decline Amount
|
Total amount offered and then declined for this fund.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_DECLINE_AMT
|
|
TOTAL_DECLINE_DATE
|
Total Decline Date
|
Date that the award was declined.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_DECLINE_DATE
|
|
TOTAL_OFFER_AMOUNT
|
Total Offer Amount
|
Total amount offered for this fund.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_ORIG_OFFER_AMT
|
|
TOTAL_ORIGINAL_OFFER_DATE
|
Total Original Offer Date
|
Date that the original offer of the award was made.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_ORIG_OFFER_DATE
|
|
TOTAL_PAID_AMOUNT
|
Total Paid Amount
|
Total amount offered and then paid from this fund.
|
NUMBER
|
|
RPRAWRD
|
RPRAWRD_PAID_AMT
|
|
TOTAL_PAID_DATE
|
Total Paid Date
|
Date that the award was paid.
|
DATE
|
|
RPRAWRD
|
RPRAWRD_PAID_DATE
|
|
TRACKING_REQ_OVERRIDE_IND
|
Tracking Requirements Override Indicator
|
Used to override the rule that all tracking requirements must be satisfied when manually adding the fund to the students' award record.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_TREQ_OVRDE_IND
|
|
UNMET_NEED_OVERRIDE
|
Unmet Need Override
|
Used to override the unmet need rule when manually adding an award to the students' record.
|
VARCHAR2(1)
|
|
RPRAWRD
|
RPRAWRD_UNMET_NEED_OVRDE_IND
|
|
UNMET_NEED_OVERRIDE_DESC
|
Unmet Need Override Description
|
Unmet need override description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
USER_ID
|
User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
|
RPRAWRD
|
RPRAWRD_USER_ID
|