| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
FINANCIAL_HOLDS
|
|
A Y/N flag field saying if a student has active financial holds, aside from the 'F0 - Financial No Hold' hold.
|
VARCHAR2(1)
|
|
|
|
|
FIRST_NAME
|
|
The first name given to a person at birth, baptism, another naming ceremony or through legal change.
|
VARCHAR2(63)
|
|
|
|
|
LAST_NAME
|
|
The last name by which a person is known.
|
VARCHAR2(63)
|
|
|
|
|
MIDDLE_NAME
|
|
A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change.
|
VARCHAR2(63)
|
|
|
|
|
NET_AMOUNT_DUE
|
|
A calculated field: ‘Total Account Balance’ minus the ‘Total Memo Balance’
|
NUMBER(12,2)
|
|
|
|
|
NUID
|
|
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
|
VARCHAR2(9)
|
|
|
|
|
OLDEST_EFFECTIVE_DATE
|
|
The date of oldest effective charge record in the account; e.g. if a Level GR student registered for classes two days ago and has not had any changes in registration or account since that time, then this field will have a date from two days ago.
|
DATE
|
|
|
|
|
PIDM
|
|
System generated Banner unique ID which gets assigned to all person and non-person records within Banner.
|
NUMBER(8)
|
|
|
|
|
TOTAL_ACCOUNT_BALANCE
|
|
Calculation made from the TBRACCD table in Banner. The field value is derived by adding all amounts billed on an account and then subtracting all amounts paid on that same account.
|
NUMBER(12,2)
|
|
|
|
|
TOTAL_AMOUNT_DUE
|
|
Calculation made from the TBRACCD table in Banner. The field value is derived by adding all amounts billed that have a due date assigned on them on an account and then subtracting all amounts paid on that same account.
|
NUMBER(12,2)
|
|
|
|
|
TOTAL_AMOUNT_PAST_DUE
|
|
A calculated field that sums all charges that are balance unpaid after their due date(s)
|
NUMBER(12,2)
|
|
|
|
|
TOTAL_FUTURE_TERM_CHARGES
|
|
A sum of all charges for academic terms that have not been activated yet in Banner
|
NUMBER(12,2)
|
|
|
|
|
TOTAL_MEMO_BALANCE
|
|
This is the sum of “anticipated credits” (from the Memo Table in Banner) that are due to be credited on account later, such as via a Tuition Payment Plan, Loan Disbursements, Aid, etc.
|
NUMBER(12,2)
|
|
|
|
|
TOTAL_UNBILLED_CHARGES
|
|
The sum of all charges that have not yet been assessed to an account as a due date has yet to be assigned
|
NUMBER(12,2)
|
|
|
|