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(6)	TBRMEMO	TBRMEMO_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	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(2)	TBRMEMO	TBRMEMO_ATYP_CODE	NO	NO
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(30)	STVATYP	STVATYP_DESC	NO	NO
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	NO	NO
AID_YEAR	Aid year associated with finanical aid memo disbursement.	VARCHAR2(4)	TBRACCD	TBRACCD_AIDY_CODE	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(3)	TBBDETC	TBBDETC_DCAT_CODE	NO	NO
CATEGORY_DESC	Category description.	VARCHAR2(30)	TTVDCAT	TTVDCAT_DESC	NO	NO
CREATE_USER	User which created the memo.	VARCHAR2(30)	TBRMEMO	TBRMEMO_CREATE_USER	NO	NO
CROSSREF_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	NO	NO
CROSSREF_CATEGORY_DESC	Category code that was the basis for a contract or exemption credit.	VARCHAR2(30)	TTVDCAT	TTVDCAT_DESC	NO	NO
CROSSREF_DETAIL_CODE	Detail code of the charge that is offset by a third party or exemption credit.	VARCHAR2(4)	TBRMEMO	TBRMEMO_CROSSREF_DETAIL_CODE	NO	NO
CROSSREF_DETAIL_CODE_DESC	Detail code description.	VARCHAR2(30)	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(1)	TBRMEMO	TBRMEMO_CROSSREF_SRCE_CODE	NO	NO
CROSSREF_SOURCE_DESC	Source Code description.	VARCHAR2(30)	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
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	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(4)	TBRMEMO	TBRMEMO_DETAIL_CODE	NO	NO
DETAIL_CODE_DESC	Detail code description.	VARCHAR2(30)	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
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	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
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(1)	TBRMEMO	TBRMEMO_SRCE_CODE	NO	NO
MEMO_SOURCE_DESC	Memo source description.	VARCHAR2(30)	TTVSRCE	TTVSRCE_DESC	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Cross reference category description.	VARCHAR2(6)	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
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: