Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT_BALANCE	Sum of the account balance.	NUMBER	FUNCTION	F_ACCOUNT_BALANCE
ACCOUNT_ENTITY_IND	Indicates whether this is a person or an organization entity.	VARCHAR2(1)	SPRIDEN	SPRIDEN_ENTITY_IND
ACCOUNT_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRACCD	TBRACCD_PIDM
ADDRESS_COUNT	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
COLLECTION_AGENCY_ID	Collection agency identification number of the most recent assignment.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
COLLECTION_AGENCY_NAME	Collection agency name of the most recent assignment.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
COLLECTION_AGENCY_UID	System generated unique internal identification number assigned to this organization entity.	NUMBER	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.	NUMBER	FUNCTION	TOKODSF.F_COUNT_COLLECTIONS
COLLECTION_DATE	Most recent date this account was assigned to a collection agency.	DATE	TBRCOLC	TBRCOLC_COLC_AGENCY_DATE
CREDIT_LIMIT_MAX	Credit limit maximum.	NUMBER	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.	NUMBER	FUNCTION	F_AMOUNT_DUE
DELINQUENCY	Delinquency code associated with the person's account.	VARCHAR2(63)	TBBACCT	TBBACCT_DELI_CODE
DELINQUENCY_DESC	Delinquency description associated with the person's account.	VARCHAR2(255)	TTVDELI	TTVDELI_DESC
DEPOSIT_BALANCE	Calculates remaining deposit balance.	NUMBER	FUNCTION	F_DEPOSIT_BALANCE
EXTERNAL_IND	External indicator.	VARCHAR2(1)	NA	NA
FIRST_NAME	Person's first or given name.	VARCHAR2(255)	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.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_HOLDS
ID	Entity's identification number used to access the records associated with the entity.	VARCHAR2(255)	SPRIDEN	SPRIDEN_ID
LAST_NAME	Last name of a person or a non-person name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME
MEMO_BALANCE	Calculated balance on unexpired memos.	NUMBER	FUNCTION	F_MEMO_BALANCE
MIDDLE_INITIAL	Person's middle name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_MI
MIDDLE_NAME	Person's middle name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_MI
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME
NAME_PREFIX	Prefix used before a person's name.	VARCHAR2(255)	SPBPERS	SPBPERS_NAME_PREFIX
NAME_SUFFIX	Suffix for the person's name.	VARCHAR2(255)	SPBPERS	SPBPERS_NAME_SUFFIX
NSF_COUNTER	Count of non- sufficient fund occurrences.	NUMBER	FUNCTION	TSKSELS.F_CALC_TBRACCD_AMOUNT_COUNT
OLDEST_EFFECTIVE_DATE	Extracts oldest effective date.	DATE	FUNCTION	F_OLDEST_EFFECTIVE_DATE
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(255)	SPBPERS	SPBPERS_SSN
TELEPHONE_COUNT	Count of the number of current active telephone numbers recorded for this account.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES

Ver: 8.1