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

Banner Operational Data Store
Reporting View Target: MEMO

Description Contains Charge/Payment Detail Memo information.
Key & Frequency One row per pidm per transaction number.
Recommended Search Columns ENTITY_UID, TRANSACTION_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)

TBRMEMO

TBRMEMO_TERM_CODE

NO

NO
ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

NO

NO
ACTIVITY_DATE Date record was inserted or updated. DATE

TBRMEMO

TBRMEMO_ACTIVITY_DATE

NO

NO
ADDRESS_SEQ_NUMBER Sequence used to identify different addresses within the same address type. NUMBER

TBRMEMO

TBRMEMO_ATYP_SEQNO

NO

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

TBRMEMO

TBRMEMO_ATYP_CODE

NO

NO
ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)

STVATYP

STVATYP_DESC

NO

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

NA

NA

NO

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

TBRMEMO

TBRMEMO_PERIOD

NO

NO
AID_ENROLLMENT_PERIOD_DESC Aid enrollment period description. VARCHAR2(255)

ROBPRDS

ROBPRDS_DESC

NO

NO
AID_YEAR Aid year associated with finanical aid memo disbursement. VARCHAR2(16)

TBRMEMO

TBRMEMO

TBRMEMO_AIDY_CODE

TBRMEMO_ATYP_CODE

NO

NO

NO
AID_YEAR_DESC Aid year description. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

NO

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

TBRMEMO

TBRMEMO_BILLING_IND

NO

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

TBBDETC

TBBDETC_DCAT_CODE

NO

NO
CATEGORY_DESC Category description. VARCHAR2(255)

TTVDCAT

TTVDCAT_DESC

NO

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

TBRMEMO

TBRMEMO_CREATE_USER

NO

NO
CROSSREF_CATEGORY Category code that was the basis for a contract or exemption credit. VARCHAR2(63)

TBRMEMO

TBRMEMO_CROSSREF_DCAT_CODE

NO

NO
CROSSREF_CATEGORY_DESC Cross reference category description. VARCHAR2(255)

TTVDCAT

TTVDCAT_DESC

NO

NO
CROSSREF_DETAIL_CODE Detail code of the charge that is offset by a third party or exemption credit. VARCHAR2(63)

TBRMEMO

TBRMEMO_CROSSREF_DETAIL_CODE

NO

NO
CROSSREF_DETAIL_CODE_DESC Detail code description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

NO

NO
CROSSREF_NUMBER Number of the deposit, contract, or exemption associated with the transaction. NUMBER

TBRMEMO

TBRMEMO_CROSSREF_NUMBER

NO

NO
CROSSREF_SOURCE Source code that was the basis for a contract or exemption credit. VARCHAR2(63)

TBRMEMO

TBRMEMO_CROSSREF_SRCE_CODE

NO

NO
CROSSREF_SOURCE_DESC Source Code description. VARCHAR2(255)

TTVSRCE

TTVSRCE_DESC

NO

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

TBRMEMO

TBRMEMO_CROSSREF_PIDM

NO

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

TBRMEMO

TBRMEMO_DATA_ORIGIN

NO

NO
DETAIL_CODE Code definining type of memo. VARCHAR2(63)

TBRMEMO

TBRMEMO_DETAIL_CODE

NO

NO
DETAIL_CODE_DESC Detail code description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

NO

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

TBBDETC

TBBDETC_TYPE_IND

NO

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

TBRMEMO

TBRMEMO_EFFECTIVE_DATE

NO

NO
ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

TBRMEMO

TBRMEMO_PIDM

NO

NO
ENTRY_DATE Date the memo was created. DATE

TBRMEMO

TBRMEMO_ENTRY_DATE

NO

NO
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

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
MEMO_AMOUNT Amount of the memo. NUMBER

TBRMEMO

TBRMEMO_AMOUNT

NO

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

TBRMEMO

TBRMEMO_DESC

NO

NO
MEMO_SOURCE Source of the memo when created, for example Financial Aid, Contract, Exemption or Deposit. VARCHAR2(63)

TBRMEMO

TBRMEMO_SRCE_CODE

NO

NO
MEMO_SOURCE_DESC Memo source description. VARCHAR2(255)

TTVSRCE

TTVSRCE_DESC

NO

NO
MULTI_SOURCE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(255)

NA

NA

NO

NO
NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
PROCESS_GROUP The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

NO

NO
RELEASE_DATE Release date. DATE

TBRMEMO

TBRMEMO_RELEASE_DATE

NO

NO
TRANSACTION_NUMBER A unique one-up transaction number of the memo. NUMBER

TBRMEMO

TBRMEMO_TRAN_NUMBER

NO

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

TBRMEMO

TBRMEMO_USER

NO

NO


Ver: 9.2