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_MEMO

Description Contains Charge/Payment Detail Memo information.
Key & Frequency One row per pidm per transaction number.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD Academic Period Academic period or time frame associated with the information on the student record. VARCHAR2(6)  

TBRMEMO

TBRMEMO_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(30)  

STVTERM

STVTERM_DESC

ACTIVITY_DATE Activity Date Date record was inserted or updated DATE  

TBRMEMO

TBRMEMO_ACTIVITY_DATE

ADDRESS_SEQ_NUMBER Address Sequence Number Sequence used to identify different addresses within the same address type. NUMBER(2)  

TBRMEMO

TBRMEMO_ATYP_SEQNO

ADDRESS_TYPE Address Type Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(2)  

TBRMEMO

TBRMEMO_ATYP_CODE

ADDRESS_TYPE_DESC Address Type Description Address type description. VARCHAR2(30)  

STVATYP

STVATYP_DESC

AID_ENROLLMENT_PERIOD Aid Enrollment Period Aid enrollment period associated with the financial aid memo disbursement. This period can span multiple student terms. VARCHAR2(15)  

TBRACCD

TBRACCD_PERIOD

AID_YEAR Aid Year Aid year associated with finanical aid memo disbursement. VARCHAR2(4)  

TBRACCD

TBRACCD_AIDY_CODE

BILLING_IND Billing Indicator Indicates if memo may be included when billing. VARCHAR2(1)  

TBRMEMO

TBRMEMO_BILLING_IND

CATEGORY Category Identities category for a receivable detail code. For example, registration, housing, meal, and contract. VARCHAR2(3)  

TBBDETC

TBBDETC_DCAT_CODE

CATEGORY_DESC Category Description Category description. VARCHAR2(30)  

TTVDCAT

TTVDCAT_DESC

CREATE_USER Create User User which created the memo. VARCHAR2(30)  

TBRMEMO

TBRMEMO_CREATE_USER

CROSSREF_CATEGORY Cross Reference Category Cross Reference Category Code for contract or exemption credits calculated based on category code rules, valid in TTVDCAT. VARCHAR2(3)  

TBRMEMO

TBRMEMO_CROSSREF_DCAT_CODE

CROSSREF_CATEGORY_DESC Cross Reference Category Description Category code that was the basis for a contract or exemption credit. VARCHAR2(30)  

TTVDCAT

TTVDCAT_DESC

CROSSREF_DETAIL_CODE Cross Reference Detail Code Detail code of the charge that is offset by a third party or exemption credit. VARCHAR2(4)  

TBRMEMO

TBRMEMO_CROSSREF_DETAIL_CODE

CROSSREF_DETAIL_CODE_DESC Cross Reference Detail Code Description Detail code description. VARCHAR2(30)  

TBBDETC

TBBDETC_DESC

CROSSREF_NUMBER Cross Reference Number Number of the deposit, contract, or exemption associated with the transaction. NUMBER(8)  

TBRMEMO

TBRMEMO_CROSSREF_NUMBER

CROSSREF_SOURCE Cross Reference Source Source code that was the basis for a contract or exemption credit. VARCHAR2(1)  

TBRMEMO

TBRMEMO_CROSSREF_SRCE_CODE

CROSSREF_SOURCE_DESC Cross Reference Source Description Source Code description. VARCHAR2(30)  

TTVSRCE

TTVSRCE_DESC

CROSSREF_UID Cross Reference UID Cross Reference internal identification number for third party memos. For the third party account, refers to the associated student. For the student account, refers to the third party. NUMBER(8)  

TBRMEMO

TBRMEMO_CROSSREF_PIDM

CURRENT_DATE Current Date System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

DATA_ORIGIN Data Origin Source system that last created or updated the data. VARCHAR2(30)  

TBRMEMO

TBRMEMO_DATA_ORIGIN

DETAIL_CODE Detail Code Code definining type of memo. VARCHAR2(4)  

TBRMEMO

TBRMEMO_DETAIL_CODE

DETAIL_CODE_DESC Detail Code Description Detail code description. VARCHAR2(30)  

TBBDETC

TBBDETC_DESC

DETAIL_CODE_TYPE Detail Code Type Determines if the detail code is being used as a charge or a payment. VARCHAR2(1)  

TBBDETC

TBBDETC_TYPE_IND

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

NA

NA

EFFECTIVE_DATE Effective Date Date the memo was created or released onto an account. DATE  

TBRMEMO

TBRMEMO_EFFECTIVE_DATE

ENTITY_UID Entity UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER(8)  

TBRMEMO

TBRMEMO_PIDM

ENTRY_DATE Entry Date Date the memo was created. DATE  

TBRMEMO

TBRMEMO_ENTRY_DATE

EXPIRATION_DATE Expiration Date Date the memo item expires, will no longer appear on bill, and may not be released onto an account. DATE  

TBRMEMO

TBRMEMO_EXPIRATION_DATE

MEMO_AMOUNT Memo Amount Amount of the memo. NUMBER(7,2)  

TBRMEMO

TBRMEMO_AMOUNT

MEMO_INFORMATION Memo Information Free-format description associated with the memo. Default value comes from the Detail Code description. VARCHAR2(30)  

TBRMEMO

TBRMEMO_DESC

MEMO_SOURCE Memo Source Source of the memo when created, for example financial Aid, contract, exemption or deposit. VARCHAR2(1)  

TBRMEMO

TBRMEMO_SRCE_CODE

MEMO_SOURCE_DESC Memo Source Description Memo source description. VARCHAR2(30)  

TTVSRCE

TTVSRCE_DESC

MIF_DESC MIF Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)  

NA

NA

MIF_VALUE MIF Value Cross reference category description. VARCHAR2(6)  

NA

NA

RELEASE_DATE Release Date Release date. DATE  

TBRMEMO

TBRMEMO_RELEASE_DATE

TRANSACTION_NUMBER Transaction Number A unique one-up transaction number of the memo. NUMBER(8)  

TBRMEMO

TBRMEMO_TRAN_NUMBER

USER_ID User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)  

TBRMEMO

TBRMEMO_USER

ZONE_VALUE Zone Value Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA



Ver: