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
|