Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCOUNT_ACTIVITY_DATE	Account Activity Date		DATE
ACCOUNT_BALANCE		Sum of the account balance.	NUMBER
ACCOUNT_DATA_ORIGIN	Account Data Origin		VARCHAR2(30)
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(8)		SPRIDEN	SPRIDEN_PIDM
ACCOUNT_USER_ID	Account User ID		VARCHAR2(30)
ACCT_DEFAULT_ADDRESS_NUMBER	Account Default Address Number		NUMBER
ACCT_DEFAULT_ADDRESS_TYPE	Account Default Address Type		VARCHAR2(2)
ACCT_DEFAULT_ADDRESS_TYPE_DESC	Account Default Address Type Description		VARCHAR2(30)
BILL_HOLD_TYPE	Bill Hold Type		VARCHAR2(2)
BILL_HOLD_TYPE_DESC	Bill Hold Type Description		VARCHAR2(30)
COLLECTION_AGENCY_UID		System generated number that is internally generated to uniquely identify the collection agency.	NUMBER(8)		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(12, 2)		TBBCPRF	TBBCPRF_CREDIT_LIMIT
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DELINQUENCY		Delinquency code associated with the person's account.	VARCHAR2(2)		TBBACCT	TBBACCT_DELI_CODE
DELINQUENCY_DESC		Delinquency description associated with the person's account.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
DEPOSIT_BALANCE		Calculates remaining deposit balance.	NUMBER
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ENTITY_CATEGORY	Entity Category		VARCHAR2(2)
ENTITY_CATEGORY_DESC	Entity Category Description		VARCHAR2(30)
EXTERNAL_IND	External Indicator	External indicator.	VARCHAR2(1)		NA	NA
FIRST_NAME	First Name	Person's first or given name.	VARCHAR2(60)		SPRIDEN	SPRIDEN_FIRST_NAME
ID		Entity's identification number used to access the records associated with the entity.	VARCHAR2(9)		SPRIDEN	SPRIDEN_ID
LAST_NAME		Last name of a person or a non-person name.	VARCHAR2(60)		SPRIDEN	SPRIDEN_LAST_NAME
MIDDLE_INITIAL		Middle initial of the person.	VARCHAR2(1)		SPRIDEN	SPRIDEN_MI
MIDDLE_NAME	Middle Name	Middle name of the person.	VARCHAR2(60)		SPRIDEN	SPRIDEN_MI
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
NAME	Name	Combination of the person's last name, first name, and middle initial into one value or Organization name.	VARCHAR2(255)		FUNCTION	F_FORMAT_NAME
NAME_PREFIX		Prefix used before a person's name.	VARCHAR2(20)		SPBPERS	SPBPERS_NAME_PREFIX
NAME_SUFFIX		Suffix for the person's name.	VARCHAR2(20)		SPBPERS	SPBPERS_NAME_SUFFIX
NSF_COUNTER		Count of non- sufficient fund occurrences.	NUMBER
OLDEST_EFFECTIVE_DATE		Extracts oldest effective date.	DATE
REFUND_IND	Refund Indicator		VARCHAR2(1)
REFUND_IND_DESC	Refund Indicator Description		VARCHAR2(4000)
SSN	Tax ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(15)		SPBPERS	SPBPERS_SSN
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: