| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACADEMIC_DIVISION
|
ACADEMIC_DIVISION
|
Financial Aid Equivalent of Student Level.
|
NUMBER(5)
|
|
|
|
|
ACADEMIC_DIVISION_DESC
|
ACADEMIC_DIVISION_DESC
|
Student Level Description
|
VARCHAR2(100 BYTE)
|
|
|
|
|
ACTUAL_AMT
|
ACTUAL_AMT
|
Total amount awarded for the award year of the fund.
|
NUMBER(10)
|
|
|
|
|
ADMIT_STATUS
|
ADMIT_STATUS
|
Financial Aid Equivalent of Admission Decision
|
VARCHAR2(3 BYTE)
|
|
|
|
|
ADMIT_STATUS_DESC
|
ADMIT_STATUS_DESC
|
Admission Decision Description
|
VARCHAR2(100 BYTE)
|
|
|
|
|
ALTERNATE_ID
|
|
NUID of student.
|
VARCHAR2(30 BYTE)
|
|
|
|
|
AWARD_YEAR_NAME
|
AWARD_YEAR_NAME
|
The award year data being referenced by the report. The Award Year terminology in Financial Aid refers to a year associated with the application for financial aid of a student. Typically this follows the traditional Northeastern academic calendar (Fall through Summer), but deviates from that schedule based upon certain academic requirements. The Summer terms start the award year for CPS and second- and third-year students in the School of Law. Their award year therefore runs Summer through Spring.
|
VARCHAR2(100 BYTE)
|
|
|
|
|
AWARD_YEAR_TOKEN
|
AWARD_YEAR_TOKEN
|
Abbreviated award year value.
|
NUMBER(10)
|
|
|
|
|
DISBURSED_AMT
|
DISBURSED_AMT
|
Total amount disbursed for the award year of the fund.
|
NUMBER(10)
|
|
|
|
|
FIRST_NAME
|
FIRST_NAME
|
The first name given to a person at birth, baptism, another naming ceremony or through legal change.
|
VARCHAR2(45 BYTE)
|
|
|
|
|
FUND_LEDGER_NUMBER
|
FUND_LEDGER_NUMBER
|
The Detail Code associated with the fund. Some funds may not have a detail code. Older funds (award years 2001-2002 through 2003-2004) will still reference the older BRS Subcode.
|
VARCHAR2(20 BYTE)
|
|
|
|
|
FUND_LONG_NAME
|
FUND_LONG_NAME
|
Full (display) name of the fund awarded to the student.
|
VARCHAR2(200 BYTE)
|
|
|
|
|
FUND_SHORT_NAME
|
FUND_SHORT_NAME
|
Short name of the fund awarded to the student.
|
VARCHAR2(50 BYTE)
|
|
|
|
|
FUND_SOURCE
|
FUND_SOURCE
|
Indicates whether the fund is either Federal, Institutional, Other, Private, State.
|
CHAR(3 BYTE)
|
|
|
|
|
FUND_SOURCE_DESC
|
FUND_SOURCE_DESC
|
Fund Source Description
|
VARCHAR2(100 BYTE)
|
|
|
|
|
FUND_TYPE
|
FUND_TYPE
|
Identifies the fund as one of the following: G(Grant), L(Loan), J(Job).
|
VARCHAR2(3 BYTE)
|
|
|
|
|
FUND_TYPE_DESC
|
FUND_TYPE_DESC
|
Fund Type Description
|
VARCHAR2(100 BYTE)
|
|
|
|
|
LAST_NAME
|
LAST_NAME
|
The last name by which a person is known.
|
VARCHAR2(48 BYTE)
|
|
|
|
|
MIDDLE_INIT
|
|
Middle initial of the student.
|
VARCHAR2(3 BYTE)
|
|
|
|
|
POE_DCYCLE_SEQN
|
|
Disbursement cycle sequence number. Determines whether disbursement is the primary or alternate for a particular term. Most awards are disbursed in POE cycle 1.
|
NUMBER(5)
|
|
|
|
|
POE_TOKEN
|
|
Period of enrollment assigned to student.
|
NUMBER(10)
|
|
|
|
|
SCHEDULED_AMOUNT
|
|
Scheduled disbursement amount for a certain date within the given term.
|
NUMBER(10)
|
|
|
|
|
SCHEDULED_DATE
|
|
Date the amount is scheduled to be disbursed to the student account.
|
DATE
|
|
|
|
|
STATUS
|
STATUS
|
Status of the fund. Every fund awarded to students in this view should have a value of A(Accepted).
|
VARCHAR2(3 BYTE)
|
|
|
|
|
STATUS_DESC
|
STATUS_DESC
|
Status description.
|
VARCHAR2(100 BYTE)
|
|
|
|
|
TRACKING_STATUS
|
TRACKING_STATUS
|
Where the student stands in the financial aid application/awarding/disbursing process.
|
VARCHAR2(6 BYTE)
|
|
|
|
|
TRACKING_STATUS_DESC
|
TRACKING_STATUS_DESC
|
Tracking Status Description.
|
VARCHAR2(100 BYTE)
|
|
|
|