Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Accounts Receivable Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AT_ACCOUNT

Description Source composite view contains accounts receivable account information.

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT_BALANCE Sum of the account balance. NUMBER

FUNCTION

F_ACCOUNT_BALANCE

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

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

FUNCTION

F_DEPOSIT_BALANCE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

EXTERNAL_IND External indicator. VARCHAR2(1)

NA

NA

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

FUNCTION

TSKSELS.F_CALC_TBRACCD_AMOUNT_COUNT

OLDEST_EFFECTIVE_DATE Extracts oldest effective date. DATE

FUNCTION

F_OLDEST_EFFECTIVE_DATE

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