ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACCOUNT_BALANCE	Sum of the account balance.			FUNCTION	F_ACCOUNT_BALANCE
ACCOUNT_ENTITY_IND	Indicates whether this is a person or an organization entity.			SPRIDEN	SPRIDEN_ENTITY_IND
ACCOUNT_UID	System generated, unique, internal identification number assigned to this person or organization entity.			TBRACCD	TBRACCD_PIDM
ADDRESS_COUNT	Count of current active addresses for this person or entity.			FUNCTION	MSKFUNC.F_COUNT_ADDRESSES
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
COLLECTION_AGENCY_ID	Collection agency identification number of the most recent assignment.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
COLLECTION_AGENCY_NAME	Collection agency name of the most recent assignment.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
COLLECTION_AGENCY_UID	System generated unique internal identification number assigned to this organization entity.			TBRCOLC	TBRCOLC_COLC_AGENCY_PIDM
COLLECTION_COUNT	Extracted number of collection agencies that this account has been assigned to over the life of the account.			FUNCTION	TOKODSF.F_COUNT_COLLECTIONS
COLLECTION_DATE	Most recent date this account was assigned to a collection agency.			TBRCOLC	TBRCOLC_COLC_AGENCY_DATE
CREDIT_LIMIT_MAX	Credit limit maximum.			TBBCPRF	TBBCPRF_CREDIT_LIMIT
CURRENT_AMOUNT_DUE	Extracted current amount due for this receivable account. Includes a sum of the charges and payments that have an effective date equal to or earlier than today's date.			FUNCTION	F_AMOUNT_DUE
DELINQUENCY	Delinquency code associated with the person's account.			TBBACCT	TBBACCT_DELI_CODE
DELINQUENCY_DESC	Delinquency description associated with the person's account.			TTVDELI	TTVDELI_DESC
DEPOSIT_BALANCE	Calculates remaining deposit balance.			FUNCTION	F_DEPOSIT_BALANCE
EXTERNAL_IND	External indicator.			NA	NA
FIRST_NAME	Person's first or given name.			SPRIDEN	SPRIDEN_FIRST_NAME
HOLD_COUNT	Count of the number of holds or restrictions to institution activities recorded for this person. Included may be stop of registration, receipt of a transcript or processing of graduation, etc.			FUNCTION	MSKFUNC.F_COUNT_HOLDS
ID	Entity's identification number used to access the records associated with the entity.			SPRIDEN	SPRIDEN_ID
LAST_NAME	Last name of a person or a non-person name.			SPRIDEN	SPRIDEN_LAST_NAME
MEMO_BALANCE	Calculated balance on unexpired memos.			FUNCTION	F_MEMO_BALANCE
MIDDLE_INITIAL	Person's middle name.			SPRIDEN	SPRIDEN_MI
MIDDLE_NAME	Person's middle name.			SPRIDEN	SPRIDEN_MI
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Combination of the person's first, middle initial, and last name into one value.			FUNCTION	F_FORMAT_NAME
NAME_PREFIX	Prefix used before a person's name.			SPBPERS	SPBPERS_NAME_PREFIX
NAME_SUFFIX	Suffix for the person's name.			SPBPERS	SPBPERS_NAME_SUFFIX
NSF_COUNTER	Count of non- sufficient fund occurrences.			FUNCTION	TSKSELS.F_CALC_TBRACCD_AMOUNT_COUNT
OLDEST_EFFECTIVE_DATE	Extracts oldest effective date.			FUNCTION	F_OLDEST_EFFECTIVE_DATE
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
TAX_ID	Person's tax identification number assigned by their home federal government.			SPBPERS	SPBPERS_SSN
TELEPHONE_COUNT	Count of the number of current active telephone numbers recorded for this account.			FUNCTION	MSKFUNC.F_COUNT_TELEPHONES

Ver: 8.3