Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Accounts Receivable Composite View Reports

Banner Operational Data Store
Composite View Target: AT_ACCOUNT

Description Source composite view contains account level or overall information for the person or organization for this account id.

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



Ver: