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(63)
|
TBRMEMO
|
TBRMEMO_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
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(63)
|
TBRMEMO
|
TBRMEMO_ATYP_CODE
|
NO
|
NO
|
ADDRESS_TYPE_DESC
|
Address type description.
|
VARCHAR2(255)
|
STVATYP
|
STVATYP_DESC
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
AID_ENROLLMENT_PERIOD_DESC
|
Aid enrollment period description.
|
VARCHAR2(255)
|
ROBPRDS
|
ROBPRDS_DESC
|
NO
|
NO
|
AID_YEAR
|
Aid year associated with finanical aid memo disbursement.
|
VARCHAR2(16)
|
TBRMEMO TBRMEMO
|
TBRMEMO_AIDY_CODE TBRMEMO_ATYP_CODE
|
NO NO
|
NO
|
AID_YEAR_DESC
|
Aid year description.
|
VARCHAR2(255)
|
ROBINST
|
ROBINST_AIDY_DESC
|
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(63)
|
TBBDETC
|
TBBDETC_DCAT_CODE
|
NO
|
NO
|
CATEGORY_DESC
|
Category description.
|
VARCHAR2(255)
|
TTVDCAT
|
TTVDCAT_DESC
|
NO
|
NO
|
CREATE_USER
|
User which created the memo.
|
VARCHAR2(30)
|
TBRMEMO
|
TBRMEMO_CREATE_USER
|
NO
|
NO
|
CROSSREF_CATEGORY
|
Category code that was the basis for a contract or exemption credit.
|
VARCHAR2(63)
|
TBRMEMO
|
TBRMEMO_CROSSREF_DCAT_CODE
|
NO
|
NO
|
CROSSREF_CATEGORY_DESC
|
Cross reference category description.
|
VARCHAR2(255)
|
TTVDCAT
|
TTVDCAT_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
CROSSREF_DETAIL_CODE_DESC
|
Detail code description.
|
VARCHAR2(255)
|
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(63)
|
TBRMEMO
|
TBRMEMO_CROSSREF_SRCE_CODE
|
NO
|
NO
|
CROSSREF_SOURCE_DESC
|
Source Code description.
|
VARCHAR2(255)
|
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
|
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(63)
|
TBRMEMO
|
TBRMEMO_DETAIL_CODE
|
NO
|
NO
|
DETAIL_CODE_DESC
|
Detail code description.
|
VARCHAR2(255)
|
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
|
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
|
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
|
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(63)
|
TBRMEMO
|
TBRMEMO_SRCE_CODE
|
NO
|
NO
|
MEMO_SOURCE_DESC
|
Memo source description.
|
VARCHAR2(255)
|
TTVSRCE
|
TTVSRCE_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
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
|