RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Accounts Receivable Reporting View Reports

SGHE Operational Data Store
Reporting View Target: RECEIVABLE_ACCOUNT

Description Contains general account information for each person or non person including name, tax ID, 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_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

TBRACCD

TBRACCD_PIDM

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

FUNCTION

MSKFUNC.F_COUNT_ADDRESSES

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

NA

NA

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(94)

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 Extracted current amount due for this receivable account. Includes a sum of the charges and payments that have an effective date equal to or earlier than today's date. NUMBER

FUNCTION

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

F_DEPOSIT_BALANCE

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 Entity's identification number used to access the records associated with the entity. 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

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

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

TSKSELS.F_CALC_TBRACCD_AMOUNT_COUNT

OLDEST_EFFECTIVE_DATE Extracts oldest effective date. DATE

FUNCTION

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

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