| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
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
|
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
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
|
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(63)
|
TBRMEMO
|
TBRMEMO_ATYP_CODE
|
|
ADDRESS_TYPE_DESC
|
Address Type Description
|
Address type description.
|
VARCHAR2(255)
|
STVATYP
|
STVATYP_DESC
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
AID_ENROLLMENT_PERIOD
|
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
|
|
AID_ENROLLMENT_PERIOD_DESC
|
Aid Enrollment Period Description
|
Aid enrollment period description.
|
VARCHAR2(255)
|
ROBPRDS
|
ROBPRDS_DESC
|
|
AID_YEAR
|
AID_YEAR
|
Aid year associated with finanical aid memo disbursement.
|
VARCHAR2(16)
|
TBRMEMO TBRMEMO
|
TBRMEMO_AIDY_CODE TBRMEMO_ATYP_CODE
|
|
AID_YEAR_DESC
|
Aid Year Description
|
Aid year description.
|
VARCHAR2(255)
|
ROBINST
|
ROBINST_AIDY_DESC
|
|
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(63)
|
TBBDETC
|
TBBDETC_DCAT_CODE
|
|
CATEGORY_DESC
|
Category Description
|
Category description.
|
VARCHAR2(255)
|
TTVDCAT
|
TTVDCAT_DESC
|
|
CREATE_USER
|
Create User
|
User which created the memo.
|
VARCHAR2(30)
|
TBRMEMO
|
TBRMEMO_CREATE_USER
|
|
CROSSREF_CATEGORY
|
Cross Reference 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
|
Cross reference category description.
|
VARCHAR2(255)
|
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(63)
|
TBRMEMO
|
TBRMEMO_CROSSREF_DETAIL_CODE
|
|
CROSSREF_DETAIL_CODE_DESC
|
Cross Reference Detail Code Description
|
Detail code description.
|
VARCHAR2(255)
|
TBBDETC
|
TBBDETC_DESC
|
|
CROSSREF_NUMBER
|
Cross Reference Number
|
Number of the deposit, contract, or exemption associated with the transaction.
|
NUMBER
|
TBRMEMO
|
TBRMEMO_CROSSREF_NUMBER
|
|
CROSSREF_SOURCE
|
Cross Reference Source
|
Source code that was the basis for a contract or exemption credit.
|
VARCHAR2(63)
|
TBRMEMO
|
TBRMEMO_CROSSREF_SRCE_CODE
|
|
CROSSREF_SOURCE_DESC
|
Cross Reference Source Description
|
Source Code description.
|
VARCHAR2(255)
|
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
|
TBRMEMO
|
TBRMEMO_CROSSREF_PIDM
|
|
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(63)
|
TBRMEMO
|
TBRMEMO_DETAIL_CODE
|
|
DETAIL_CODE_DESC
|
Detail Code Description
|
Detail code description.
|
VARCHAR2(255)
|
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
|
|
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
|
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
|
|
ID
|
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
|
|
MEMO_AMOUNT
|
Memo Amount
|
Amount of the memo.
|
NUMBER
|
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(63)
|
TBRMEMO
|
TBRMEMO_SRCE_CODE
|
|
MEMO_SOURCE_DESC
|
Memo Source Description
|
Memo source description.
|
VARCHAR2(255)
|
TTVSRCE
|
TTVSRCE_DESC
|
|
MULTI_SOURCE
|
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
|
Multi Source Description
|
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
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PROCESS_GROUP
|
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
|
Release date.
|
DATE
|
TBRMEMO
|
TBRMEMO_RELEASE_DATE
|
|
TRANSACTION_NUMBER
|
Transaction Number
|
A unique one-up transaction number of the memo.
|
NUMBER
|
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
|