Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT_ACTIVITY_DATE	Date the last change were made to this record.	DATE	TBBACCT	TBBACCT_ACTIVITY_DATE
ACCOUNT_BALANCE	Account balance for this receivable account. Sum of the charges and payments on the account regardless of the effective date.	NUMBER	FUNCTION	TOKODSF.F_ACCOUNT_BALANCE
ACCOUNT_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(255)	TBBCPRF	TBBCPRF_DATA_ORIGIN
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
ACCOUNT_USER_ID	User who made the last updated to this record.	VARCHAR2(63)	TBBCPRF	TBBCPRF_USER_ID
ACCT_DEFAULT_ADDRESS_NUMBER	Sequence number used to identify default mailing address within the address type.	NUMBER	TBBCPRF	TBBCPRF_ATYP_SEQNO_DEFAULT
ACCT_DEFAULT_ADDRESS_TYPE	Default mailing address type to use for this account.	VARCHAR2(63)	TBBCPRF	TBBCPRF_ATYP_CODE_DEFAULT
ACCT_DEFAULT_ADDRESS_TYPE_DESC	Default mailing address type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADDRESS_COUNT	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BILL_HOLD_TYPE	Identifies the reason a bill is not being produced for the account.	VARCHAR2(63)	TBBACCT	TBBACCT_BILL_CODE
BILL_HOLD_TYPE_DESC	Bill hold reason description.	VARCHAR2(255)	TTVBILL	TTVBILL_DESC
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	Current amount due for this receivable account. Sum of the charges and payments that have an effective date equal to or earlier than today's date.	NUMBER	FUNCTION	MTKFUNC.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	TOKODSF.F_DEPOSIT_BALANCE
ENTITY_CATEGORY	Institution defined category to group different account types under an entity category. For example, Student, Faculty, Hospital or Third Party accounts would permit reporting to be segmented into these entity categories.	VARCHAR2(63)	TBBCPRF	TBBCPRF_ECAT_CODE
ENTITY_CATEGORY_DESC	Entity category description.	VARCHAR2(255)	TTVECAT	TTVECAT_DESC
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	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	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	MTKFUNC.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	GOKODSF.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	TOKODSF.F_COUNT_NSF
OLDEST_EFFECTIVE_DATE	Extracts oldest effective date.	DATE	FUNCTION	TOKODSF.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
REFUND_IND	Indicates whether the account which has a credit balance is to be automatically refunded. The value of "N" is used to tell the system not to generate a refund for a person.	VARCHAR2(1)	TBBACCT	TBBACCT_REFUND_IND
REFUND_IND_DESC	Refund indicator description.	VARCHAR2(255)	CALCULATION	DECODE(TBBACCT_REFUND_IND)
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: 9.1