Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT_ACTIVITY_DATE	Account Activity Date	Date the last change were made to this record.	DATE	TBBACCT	TBBACCT_ACTIVITY_DATE
ACCOUNT_BALANCE	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	Account Data Origin	Source system that created or updated the data.	VARCHAR2(255)	TBBCPRF	TBBCPRF_DATA_ORIGIN
ACCOUNT_ENTITY_IND	Entity Indicator	Indicates whether this is a person or an organization entity.	VARCHAR2(1)	SPRIDEN	SPRIDEN_ENTITY_IND
ACCOUNT_UID	Account UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRACCD	TBRACCD_PIDM
ACCOUNT_USER_ID	Account User ID	User who made the last updated to this record.	VARCHAR2(63)	TBBCPRF	TBBCPRF_USER_ID
ACCT_DEFAULT_ADDRESS_NUMBER	Account 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	Account Default Address Type	Default mailing address type to use for this account.	VARCHAR2(63)	TBBCPRF	TBBCPRF_ATYP_CODE_DEFAULT
ACCT_DEFAULT_ADDRESS_TYPE_DESC	Account Default Address Type Description	Default mailing address type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADDRESS_COUNT	Address Count	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES
ADMINISTRATIVE_GROUP	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	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 Type Description	Bill hold reason description.	VARCHAR2(255)	TTVBILL	TTVBILL_DESC
COLLECTION_AGENCY_ID	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	Collection agency name of the most recent assignment.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
COLLECTION_AGENCY_UID	Collection Agency UID	System generated unique internal identification number assigned to this organization entity.	NUMBER	TBRCOLC	TBRCOLC_COLC_AGENCY_PIDM
COLLECTION_COUNT	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	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	Credit limit maximum.	NUMBER	TBBCPRF	TBBCPRF_CREDIT_LIMIT
CURRENT_AMOUNT_DUE	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	Delinquency code associated with the person's account.	VARCHAR2(63)	TBBACCT	TBBACCT_DELI_CODE
DELINQUENCY_DESC	Delinquency Description	Delinquency description associated with the person's account.	VARCHAR2(255)	TTVDELI	TTVDELI_DESC
DEPOSIT_BALANCE	Deposit Balance	Calculates remaining deposit balance.	NUMBER	FUNCTION	TOKODSF.F_DEPOSIT_BALANCE
ENTITY_CATEGORY	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	Entity category description.	VARCHAR2(255)	TTVECAT	TTVECAT_DESC
EXTERNAL_IND	External Indicator	External indicator.	VARCHAR2(1)	NA	NA
FIRST_NAME	First Name	Person's first or given name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_FIRST_NAME
HOLD_COUNT	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	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	Last name of a person or a non-person name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME
MEMO_BALANCE	Memo Balance	Calculated balance on unexpired memos.	NUMBER	FUNCTION	MTKFUNC.F_MEMO_BALANCE
MIDDLE_INITIAL	Middle Initial	Person's middle name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_MI
MIDDLE_NAME	Middle Name	Person's middle name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_MI
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_NAME
NAME_PREFIX	Name Prefix	Prefix used before a person's name.	VARCHAR2(255)	SPBPERS	SPBPERS_NAME_PREFIX
NAME_SUFFIX	Name Suffix	Suffix for the person's name.	VARCHAR2(255)	SPBPERS	SPBPERS_NAME_SUFFIX
NSF_COUNTER	Nsf Counter	Count of non- sufficient fund occurrences.	NUMBER	FUNCTION	TOKODSF.F_COUNT_NSF
OLDEST_EFFECTIVE_DATE	Oldest Effective Date	Extracts oldest effective date.	DATE	FUNCTION	TOKODSF.F_OLDEST_EFFECTIVE_DATE
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REFUND_IND	Refund Indicator	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	Refund indicator description.	VARCHAR2(255)	CALCULATION	DECODE(TBBACCT_REFUND_IND)
TAX_ID	Tax ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(255)	SPBPERS	SPBPERS_SSN
TELEPHONE_COUNT	Telephone Count	Count of the number of current active telephone numbers recorded for this account.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES

Ver: 9.2