| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACCOUNT_ACTIVITY_DATE
|
|
DATE
|
|
|
|
ACCOUNT_BALANCE
|
Sum of the account balance.
|
NUMBER
|
|
|
|
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
|
SPRIDEN
|
SPRIDEN_PIDM
|
|
ACCOUNT_USER_ID
|
|
VARCHAR2(30)
|
|
|
|
ACCT_DEFAULT_ADDRESS_NUMBER
|
|
NUMBER
|
|
|
|
ACCT_DEFAULT_ADDRESS_TYPE
|
|
VARCHAR2(2)
|
|
|
|
ACCT_DEFAULT_ADDRESS_TYPE_DESC
|
|
VARCHAR2(30)
|
|
|
|
BILL_HOLD_TYPE
|
|
VARCHAR2(2)
|
|
|
|
BILL_HOLD_TYPE_DESC
|
|
VARCHAR2(30)
|
|
|
|
COLLECTION_AGENCY_UID
|
System generated number that is internally generated to uniquely identify the collection agency.
|
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_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
|
|
VARCHAR2(2)
|
|
|
|
ENTITY_CATEGORY_DESC
|
|
VARCHAR2(30)
|
|
|
|
EXTERNAL_IND
|
External indicator.
|
VARCHAR2(1)
|
NA
|
NA
|
|
FIRST_NAME
|
Person's first or given name.
|
VARCHAR2(60)
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
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 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
|
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
|
|
VARCHAR2(1)
|
|
|
|
REFUND_IND_DESC
|
|
VARCHAR2(4000)
|
|
|
|
SSN
|
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
|