Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Accounts Receivable Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: RECEIVABLE_ACCOUNT

Description Contains general account information for each person or organization including name, tax ID, entity category, account balance, current amount due, deposit balance, hold counts, delinquency, collection information, and credit limit.
Key & Frequency One row per account.
Recommended Search Columns ACCOUNT_UID
COLLECTION_AGENCY_UID

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT_ACTIVITY_DATE Date the last change were made to this record. DATE

TBBACCT

TBBACCT_ACTIVITY_DATE

ACCOUNT_BALANCE Account balance for this receivable account. Sum of the charges and payments on the account regardless of the effective date. NUMBER

FUNCTION

TOKODSF.F_ACCOUNT_BALANCE

ACCOUNT_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(255)

TBBCPRF

TBBCPRF_DATA_ORIGIN

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

TBRACCD

TBRACCD_PIDM

ACCOUNT_USER_ID User who made the last updated to this record. VARCHAR2(63)

TBBCPRF

TBBCPRF_USER_ID

ACCT_DEFAULT_ADDRESS_NUMBER Sequence number used to identify default mailing address within the address type. NUMBER

TBBCPRF

TBBCPRF_ATYP_SEQNO_DEFAULT

ACCT_DEFAULT_ADDRESS_TYPE Default mailing address type to use for this account. VARCHAR2(63)

TBBCPRF

TBBCPRF_ATYP_CODE_DEFAULT

ACCT_DEFAULT_ADDRESS_TYPE_DESC Default mailing address type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ADDRESS_COUNT Count of current active addresses for this person or entity. NUMBER

FUNCTION

MSKFUNC.F_COUNT_ADDRESSES

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BILL_HOLD_TYPE Identifies the reason a bill is not being produced for the account. VARCHAR2(63)

TBBACCT

TBBACCT_BILL_CODE

BILL_HOLD_TYPE_DESC Bill hold reason description. VARCHAR2(255)

TTVBILL

TTVBILL_DESC

COLLECTION_AGENCY_ID Collection agency identification number of the most recent assignment. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

COLLECTION_AGENCY_NAME Collection agency name of the most recent assignment. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

COLLECTION_AGENCY_UID System generated unique internal identification number assigned to this organization entity. 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_AMOUNT_DUE Current amount due for this receivable account. Sum of the charges and payments that have an effective date equal to or earlier than today's date. NUMBER

FUNCTION

MTKFUNC.F_AMOUNT_DUE

DELINQUENCY Delinquency code associated with the person's account. VARCHAR2(63)

TBBACCT

TBBACCT_DELI_CODE

DELINQUENCY_DESC Delinquency description associated with the person's account. VARCHAR2(255)

TTVDELI

TTVDELI_DESC

DEPOSIT_BALANCE Calculates remaining deposit balance. NUMBER

FUNCTION

TOKODSF.F_DEPOSIT_BALANCE

ENTITY_CATEGORY Institution defined category to group different account types under an entity category. For example, Student, Faculty, Hospital or Third Party accounts would permit reporting to be segmented into these entity categories. VARCHAR2(63)

TBBCPRF

TBBCPRF_ECAT_CODE

ENTITY_CATEGORY_DESC Entity category description. VARCHAR2(255)

TTVECAT

TTVECAT_DESC

EXTERNAL_IND External indicator. VARCHAR2(1)

NA

NA

FIRST_NAME Person's first or given name. VARCHAR2(255)

SPRIDEN

SPRIDEN_FIRST_NAME

HOLD_COUNT Count of the number of holds or restrictions to institution activities recorded for this person. Included may be stop of registration, receipt of a transcript or processing of graduation, etc. NUMBER

FUNCTION

MSKFUNC.F_COUNT_HOLDS

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(255)

SPRIDEN

SPRIDEN_ID

LAST_NAME Last name of a person or a non-person name. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

MEMO_BALANCE Calculated balance on unexpired memos. NUMBER

FUNCTION

MTKFUNC.F_MEMO_BALANCE

MIDDLE_INITIAL Person's middle name. VARCHAR2(255)

SPRIDEN

SPRIDEN_MI

MIDDLE_NAME Person's middle name. VARCHAR2(255)

SPRIDEN

SPRIDEN_MI

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Combination of the person's first, middle initial, and last name into one value. VARCHAR2(255)

FUNCTION

GOKODSF.F_FORMAT_NAME

NAME_PREFIX Prefix used before a person's name. VARCHAR2(255)

SPBPERS

SPBPERS_NAME_PREFIX

NAME_SUFFIX Suffix for the person's name. VARCHAR2(255)

SPBPERS

SPBPERS_NAME_SUFFIX

NSF_COUNTER Count of non- sufficient fund occurrences. NUMBER

FUNCTION

TOKODSF.F_COUNT_NSF

OLDEST_EFFECTIVE_DATE Extracts oldest effective date. DATE

FUNCTION

TOKODSF.F_OLDEST_EFFECTIVE_DATE

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

REFUND_IND Indicates whether the account which has a credit balance is to be automatically refunded. The value of "N" is used to tell the system not to generate a refund for a person. VARCHAR2(1)

TBBACCT

TBBACCT_REFUND_IND

REFUND_IND_DESC Refund indicator description. VARCHAR2(255)

CALCULATION

DECODE(TBBACCT_REFUND_IND)

TAX_ID Person's tax identification number assigned by their home federal government. VARCHAR2(255)

SPBPERS

SPBPERS_SSN

TELEPHONE_COUNT Count of the number of current active telephone numbers recorded for this account. NUMBER

FUNCTION

MSKFUNC.F_COUNT_TELEPHONES



Ver: 8.5