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.			SPRIDEN	SPRIDEN_PIDM
COLLECTION_AGENCY_UID	System generated number that is internally generated to uniquely identify the collection agency.			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_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DELINQUENCY	Delinquency code associated with the person's account.			TBBACCT	TBBACCT_DELI_CODE
DELINQUENCY_DESC	Delinquency description associated with the person's account.			FUNCTION	GOKODSF.F_GET_DESC
DEPOSIT_BALANCE	Calculates remaining deposit balance.			FUNCTION	F_DEPOSIT_BALANCE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
EXTERNAL_IND	External indicator.			NA	NA
FIRST_NAME	Person's first or given name.			SPRIDEN	SPRIDEN_FIRST_NAME
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
MIDDLE_INITIAL	Middle initial of the person.			SPRIDEN	SPRIDEN_MI
MIDDLE_NAME	Middle name of the person.			SPRIDEN	SPRIDEN_MI
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Combination of the person's last name, first name, and middle initial into one value or Organization name.			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
SSN	Person's tax identification number assigned by their home federal government.			SPBPERS	SPBPERS_SSN
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3