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 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: