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

SGHE 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 Name Business Definition Database Data Type Domain Value Source Name Source Column
ACCOUNT_ACTIVITY_DATE Account Activity Date   DATE      
ACCOUNT_BALANCE   Sum of the account balance. NUMBER      
ACCOUNT_DATA_ORIGIN 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(8)  

SPRIDEN

SPRIDEN_PIDM

ACCOUNT_USER_ID Account User ID   VARCHAR2(30)      
ACCT_DEFAULT_ADDRESS_NUMBER Account Default Address Number   NUMBER      
ACCT_DEFAULT_ADDRESS_TYPE Account Default Address Type   VARCHAR2(2)      
ACCT_DEFAULT_ADDRESS_TYPE_DESC Account Default Address Type Description   VARCHAR2(30)      
BILL_HOLD_TYPE Bill Hold Type   VARCHAR2(2)      
BILL_HOLD_TYPE_DESC Bill Hold Type Description   VARCHAR2(30)      
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      
DOMAIN_VALUE   Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)  

NA

NA

ENTITY_CATEGORY Entity Category   VARCHAR2(2)      
ENTITY_CATEGORY_DESC Entity Category Description   VARCHAR2(30)      
EXTERNAL_IND External Indicator External indicator. VARCHAR2(1)  

NA

NA

FIRST_NAME 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 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 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 Refund Indicator   VARCHAR2(1)      
REFUND_IND_DESC Refund Indicator Description   VARCHAR2(4000)      
SSN Tax ID 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: