Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACCOUNT_ACTIVITY_DATE		DATE				NO
ACCOUNT_BALANCE	Sum of the account balance.	NUMBER				NO
ACCOUNT_DATA_ORIGIN		VARCHAR2(30)				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	SPRIDEN	SPRIDEN_PIDM	NO	NO
ACCOUNT_USER_ID		VARCHAR2(30)				NO
ACCT_DEFAULT_ADDRESS_NUMBER		NUMBER				NO
ACCT_DEFAULT_ADDRESS_TYPE		VARCHAR2(2)				NO
ACCT_DEFAULT_ADDRESS_TYPE_DESC		VARCHAR2(30)				NO
BILL_HOLD_TYPE		VARCHAR2(2)				NO
BILL_HOLD_TYPE_DESC		VARCHAR2(30)				NO
COLLECTION_AGENCY_UID	System generated number that is internally generated to uniquely identify the collection agency.	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_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DELINQUENCY	Delinquency code associated with the person's account.	VARCHAR2(2)	TBBACCT	TBBACCT_DELI_CODE	NO	NO
DELINQUENCY_DESC	Delinquency description associated with the person's account.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DEPOSIT_BALANCE	Calculates remaining deposit balance.	NUMBER				NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
ENTITY_CATEGORY		VARCHAR2(2)				NO
ENTITY_CATEGORY_DESC		VARCHAR2(30)				NO
EXTERNAL_IND	External indicator.	VARCHAR2(1)	NA	NA	NO	NO
FIRST_NAME	Person's first or given name.	VARCHAR2(60)	SPRIDEN	SPRIDEN_FIRST_NAME	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(9)	SPRIDEN	SPRIDEN_ID	NO	NO
LAST_NAME	Last name of a person or a non-person name.	VARCHAR2(60)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
MIDDLE_INITIAL	Middle initial of the person.	VARCHAR2(1)	SPRIDEN	SPRIDEN_MI	NO	NO
MIDDLE_NAME	Middle name of the person.	VARCHAR2(60)	SPRIDEN	SPRIDEN_MI	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
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	NO	NO
NAME_PREFIX	Prefix used before a person's name.	VARCHAR2(20)	SPBPERS	SPBPERS_NAME_PREFIX	NO	NO
NAME_SUFFIX	Suffix for the person's name.	VARCHAR2(20)	SPBPERS	SPBPERS_NAME_SUFFIX	NO	NO
NSF_COUNTER	Count of non- sufficient fund occurrences.	NUMBER				NO
OLDEST_EFFECTIVE_DATE	Extracts oldest effective date.	DATE				NO
REFUND_IND		VARCHAR2(1)				NO
REFUND_IND_DESC		VARCHAR2(4000)				NO
SSN	Person's tax identification number assigned by their home federal government.	VARCHAR2(15)	SPBPERS	SPBPERS_SSN	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: