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