Reporting View Target: MEMO

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Accounts Receivable Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: MEMO

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

Target Column Business Definition Database Data Type Source Name Source Column

ACADEMIC_PERIOD Academic period or time frame associated with the information on the student record. VARCHAR2(63)
TBRMEMO

TBRMEMO_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)
STVTERM

STVTERM_DESC

ACTIVITY_DATE Date record was inserted or updated DATE
TBRMEMO

TBRMEMO_ACTIVITY_DATE

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

TBRMEMO_ATYP_SEQNO

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

ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

ADMINISTRATIVE_GROUP The institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)
NA

NA

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

TBRMEMO_BILLING_IND

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

TBBDETC_DCAT_CODE

CATEGORY_DESC Category description. VARCHAR2(255)
TTVDCAT

TTVDCAT_DESC

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

TBRMEMO_CREATE_USER

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

TBRMEMO_CROSSREF_DCAT_CODE

CROSSREF_CATEGORY_DESC Cross reference category description. VARCHAR2(255)
TTVDCAT

TTVDCAT_DESC

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

CROSSREF_DETAIL_CODE_DESC Detail code description. VARCHAR2(255)
TBBDETC

TBBDETC_DESC

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

TBRMEMO_CROSSREF_NUMBER

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

TBRMEMO_CROSSREF_SRCE_CODE

CROSSREF_SOURCE_DESC Source Code description. VARCHAR2(255)
TTVSRCE

TTVSRCE_DESC

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

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

TBRMEMO_DATA_ORIGIN

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

TBRMEMO_DETAIL_CODE

DETAIL_CODE_DESC Detail code description. VARCHAR2(255)
TBBDETC

TBBDETC_DESC

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

TBBDETC_TYPE_IND

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

TBRMEMO_EFFECTIVE_DATE

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

TBRMEMO_PIDM

ENTRY_DATE Date the memo was created. DATE
TBRMEMO

TBRMEMO_ENTRY_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

ID Person's or organization's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MEMO_AMOUNT Amount of the memo. NUMBER
TBRMEMO

TBRMEMO_AMOUNT

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

TBRMEMO_DESC

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

TBRMEMO_SRCE_CODE

MEMO_SOURCE_DESC Memo source description. VARCHAR2(255)
TTVSRCE

TTVSRCE_DESC

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

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

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

MGKFUNC.F_GET_PERSON_INFO

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

RELEASE_DATE Release date. DATE
TBRMEMO

TBRMEMO_RELEASE_DATE

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

TBRMEMO_TRAN_NUMBER

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

TBRMEMO_USER

Ver: 8.1

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

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame associated with the information on the student record.	VARCHAR2(63)	TBRMEMO	TBRMEMO_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACTIVITY_DATE	Date record was inserted or updated	DATE	TBRMEMO	TBRMEMO_ACTIVITY_DATE
ADDRESS_SEQ_NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER	TBRMEMO	TBRMEMO_ATYP_SEQNO
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
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADMINISTRATIVE_GROUP	The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(255)	NA	NA
BILLING_IND	Indicates if memo may be included when billing.	VARCHAR2(1)	TBRMEMO	TBRMEMO_BILLING_IND
CATEGORY	Identities category for a receivable detail code. For example, registration, housing, meal, and contract.	VARCHAR2(63)	TBBDETC	TBBDETC_DCAT_CODE
CATEGORY_DESC	Category description.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC
CREATE_USER	User which created the memo.	VARCHAR2(30)	TBRMEMO	TBRMEMO_CREATE_USER
CROSSREF_CATEGORY	Category code that was the basis for a contract or exemption credit.	VARCHAR2(63)	TBRMEMO	TBRMEMO_CROSSREF_DCAT_CODE
CROSSREF_CATEGORY_DESC	Cross reference category description.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC
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
CROSSREF_DETAIL_CODE_DESC	Detail code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
CROSSREF_NUMBER	Number of the deposit, contract, or exemption associated with the transaction.	NUMBER	TBRMEMO	TBRMEMO_CROSSREF_NUMBER
CROSSREF_SOURCE	Source code that was the basis for a contract or exemption credit.	VARCHAR2(63)	TBRMEMO	TBRMEMO_CROSSREF_SRCE_CODE
CROSSREF_SOURCE_DESC	Source Code description.	VARCHAR2(255)	TTVSRCE	TTVSRCE_DESC
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
DATA_ORIGIN	Source system that last created or updated the data.	VARCHAR2(30)	TBRMEMO	TBRMEMO_DATA_ORIGIN
DETAIL_CODE	Code definining type of memo.	VARCHAR2(63)	TBRMEMO	TBRMEMO_DETAIL_CODE
DETAIL_CODE_DESC	Detail code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
DETAIL_CODE_TYPE	Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)	TBBDETC	TBBDETC_TYPE_IND
EFFECTIVE_DATE	Date the memo was created or released onto an account.	DATE	TBRMEMO	TBRMEMO_EFFECTIVE_DATE
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRMEMO	TBRMEMO_PIDM
ENTRY_DATE	Date the memo was created.	DATE	TBRMEMO	TBRMEMO_ENTRY_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
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MEMO_AMOUNT	Amount of the memo.	NUMBER	TBRMEMO	TBRMEMO_AMOUNT
MEMO_INFORMATION	Free-format description associated with the memo. Default value comes from the Detail Code description.	VARCHAR2(30)	TBRMEMO	TBRMEMO_DESC
MEMO_SOURCE	Source of the memo when created, for example financial Aid, contract, exemption or deposit.	VARCHAR2(63)	TBRMEMO	TBRMEMO_SRCE_CODE
MEMO_SOURCE_DESC	Memo source description.	VARCHAR2(255)	TTVSRCE	TTVSRCE_DESC
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
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
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
RELEASE_DATE	Release date.	DATE	TBRMEMO	TBRMEMO_RELEASE_DATE
TRANSACTION_NUMBER	A unique one-up transaction number of the memo.	NUMBER	TBRMEMO	TBRMEMO_TRAN_NUMBER
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	TBRMEMO	TBRMEMO_USER