Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACCOUNT_ACTIVITY_DATE	Date the last change were made to this record.	DATE	TBBACCT	TBBACCT_ACTIVITY_DATE	NO	NO
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	NO	NO
ACCOUNT_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(255)	TBBCPRF	TBBCPRF_DATA_ORIGIN	NO	NO
ACCOUNT_ENTITY_IND	Indicates whether this is a person or an organization entity.	VARCHAR2(1)	SPRIDEN	SPRIDEN_ENTITY_IND	NO	NO
ACCOUNT_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRACCD	TBRACCD_PIDM	NO	NO
ACCOUNT_USER_ID	User who made the last updated to this record.	VARCHAR2(63)	TBBCPRF	TBBCPRF_USER_ID	NO	NO
ACCT_DEFAULT_ADDRESS_NUMBER	Sequence number used to identify default mailing address within the address type.	NUMBER	TBBCPRF	TBBCPRF_ATYP_SEQNO_DEFAULT	NO	NO
ACCT_DEFAULT_ADDRESS_TYPE	Default mailing address type to use for this account.	VARCHAR2(63)	TBBCPRF	TBBCPRF_ATYP_CODE_DEFAULT	NO	NO
ACCT_DEFAULT_ADDRESS_TYPE_DESC	Default mailing address type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ADDRESS_COUNT	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
BILL_HOLD_TYPE	Identifies the reason a bill is not being produced for the account.	VARCHAR2(63)	TBBACCT	TBBACCT_BILL_CODE	NO	NO
BILL_HOLD_TYPE_DESC	Bill hold reason description.	VARCHAR2(255)	TTVBILL	TTVBILL_DESC	NO	NO
COLLECTION_AGENCY_ID	Collection agency identification number of the most recent assignment.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
COLLECTION_AGENCY_NAME	Collection agency name of the most recent assignment.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
COLLECTION_AGENCY_UID	System generated unique internal identification number assigned to this organization entity.	NUMBER	TBRCOLC	TBRCOLC_COLC_AGENCY_PIDM	NO	NO
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	NO	NO
COLLECTION_DATE	Most recent date this account was assigned to a collection agency.	DATE	TBRCOLC	TBRCOLC_COLC_AGENCY_DATE	NO	NO
CREDIT_LIMIT_MAX	Credit limit maximum.	NUMBER	TBBCPRF	TBBCPRF_CREDIT_LIMIT	NO	NO
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	NO	NO
DELINQUENCY	Delinquency code associated with the person's account.	VARCHAR2(63)	TBBACCT	TBBACCT_DELI_CODE	NO	NO
DELINQUENCY_DESC	Delinquency description associated with the person's account.	VARCHAR2(255)	TTVDELI	TTVDELI_DESC	NO	NO
DEPOSIT_BALANCE	Calculates remaining deposit balance.	NUMBER	FUNCTION	TOKODSF.F_DEPOSIT_BALANCE	NO	NO
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	NO	NO
ENTITY_CATEGORY_DESC	Entity category description.	VARCHAR2(255)	TTVECAT	TTVECAT_DESC	NO	NO
EXTERNAL_IND	External indicator.	VARCHAR2(1)	NA	NA	NO	NO
FIRST_NAME	Person's first or given name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_FIRST_NAME	NO	NO
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	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(255)	SPRIDEN	SPRIDEN_ID	NO	NO
LAST_NAME	Last name of a person or a non-person name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
MEMO_BALANCE	Calculated balance on unexpired memos.	NUMBER	FUNCTION	MTKFUNC.F_MEMO_BALANCE	NO	NO
MIDDLE_INITIAL	Person's middle name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_MI	NO	NO
MIDDLE_NAME	Person's middle name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_MI	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_NAME	NO	NO
NAME_PREFIX	Prefix used before a person's name.	VARCHAR2(255)	SPBPERS	SPBPERS_NAME_PREFIX	NO	NO
NAME_SUFFIX	Suffix for the person's name.	VARCHAR2(255)	SPBPERS	SPBPERS_NAME_SUFFIX	NO	NO
NSF_COUNTER	Count of non- sufficient fund occurrences.	NUMBER	FUNCTION	TOKODSF.F_COUNT_NSF	NO	NO
OLDEST_EFFECTIVE_DATE	Extracts oldest effective date.	DATE	FUNCTION	TOKODSF.F_OLDEST_EFFECTIVE_DATE	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
REFUND_IND_DESC	Refund indicator description.	VARCHAR2(255)	CALCULATION	DECODE(TBBACCT_REFUND_IND)	NO	NO
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(255)	SPBPERS	SPBPERS_SSN	NO	NO
TELEPHONE_COUNT	Count of the number of current active telephone numbers recorded for this account.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES	NO	NO

Ver: 9.2