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)	TBRACCD	TBRACCD_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
ACCOUNT_DETAIL_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	TBRACCD	TBRACCD_ACTIVITY_DATE	NO	NO
ACCOUNT_DETAIL_DATA_ORIGIN	Source system that last created or updated the data.	VARCHAR2(63)	TBRACCD	TBRACCD_DATA_ORIGIN	NO	NO
ACCOUNT_DETAIL_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	TBRACCD	TBRACCD_USER	NO	NO
ACCOUNT_POSTED_AMOUNT	Amount that has been posted.	NUMBER	CALCULATION	DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_AMOUNT)	NO	NO
ACCOUNT_POSTING_STATUS	Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed.	VARCHAR2(1)	TBRACCD	TBRACCD_ACCT_FEED_IND	NO	NO
ACCOUNT_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRACCD	TBRACCD_PIDM	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 disbursement. This period can span multiple student terms.	VARCHAR2(15)	TBRACCD	TBRACCD_PERIOD	NO	NO
AID_ENROLLMENT_PERIOD_DESC	Aid enrollment period description.	VARCHAR2(255)	ROBPRDS	ROBPRDS_DESC	NO	NO
AID_YEAR	Aid year associated with financial aid disbursement.	VARCHAR2(4)	TBRACCD	TBRACCD_AIDY_CODE	NO	NO
AID_YEAR_DESC	Aid year description.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC	NO	NO
AMOUNT	Sum of the amount of each account detail for this receivable account.	NUMBER	TBRACCD	TBRACCD_AMOUNT	NO	NO
BALANCE	Remaining balance for all account detail amounts after application of payments.	NUMBER	TBRACCD	TBRACCD_BALANCE	NO	NO
BILL_AMOUNT	Calculated amount of all the charges and payments on the receivable account that have been billed to the account holder.	NUMBER	CALCULATION	DECODE(TBRACCD_BILL_DATE, NULL, NULL, TBRACCD_AMOUNT)	NO	NO
BILL_DATE	Date that the transaction was billed.	DATE	TBRACCD	TBRACCD_BILL_DATE	NO	NO
BILL_SEQUENCE	Bill sequence.	NUMBER	NA	NA	NO	NO
CASHIER_END_DATE	Ending date of the cashiering session for the transaction.	DATE	TBRACCD	TBRACCD_CSHR_END_DATE	NO	NO
CASHIER_END_TIME	Ending time of the cashiering session for the transaction.	VARCHAR2(255)	CALCULATION	TO_CHAR(TBRACCD_CSHR_END_DATE,'HH24:MM:SS')	NO	NO
CASHIER_SESSION_NUMBER	Session number assigned to each cashier session.	NUMBER	TBRACCD	TBRACCD_SESSION_NUMBER	NO	NO
CATEGORY	Identities category for a receivable transaction type. Examples are registration, housing, meal, contract.	VARCHAR2(63)	TBBDETC	TBBDETC_DCAT_CODE	NO	NO
CATEGORY_DESC	Receivable category description.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC	NO	NO
CONTRACT_PYMT_TRANSACTION_IND	Indicates that contract payment detail is used for application of a payment to contract charges. Valid values are Y = Used or N = Not used.	VARCHAR2(1)	TBRACCD	TBRACCD_CPDT_IND	NO	NO
COURSE_REFERENCE_NUMBER	Course reference number of the course that generated the charge. Tracking by course reference number is used in Fee Assessment.	VARCHAR2(63)	TBRACCD	TBRACCD_CRN	NO	NO
CREDIT_CARD_NUMBER	Credit card number or payment identification.	VARCHAR2(63)	TBRACCD	TBRACCD_PAYMENT_ID	NO	NO
CROSSREF_CATEGORY	Category code that was the basis for a contract or exemption credit.	VARCHAR2(63)	TBRACCD	TBRACCD_CROSSREF_DCAT_CODE	NO	NO
CROSSREF_CATEGORY_DESC	Specifies the category.	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)	TBRACCD	TBRACCD_CROSSREF_DETAIL_CODE	NO	NO
CROSSREF_DETAIL_CODE_DESC	Detail code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC	NO	NO
CROSSREF_ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRACCD	TBRACCD_CROSSREF_PIDM	NO	NO
CROSSREF_NUMBER	Number of the deposit, contract, or exemption associated with the transaction.	NUMBER	TBRACCD	TBRACCD_CROSSREF_NUMBER	NO	NO
CROSSREF_SOURCE	Source code that was the basis for a contract or exemption credit.	VARCHAR2(63)	TBRACCD	TBRACCD_CROSSREF_SRCE_CODE	NO	NO
CROSSREF_SOURCE_DESC	Specifies the charge/payment detail source associated with the source code.	VARCHAR2(255)	TTVSRCE	TTVSRCE_DESC	NO	NO
DESIGNATOR_TYPE	Indicates if the designator used to extract the finance accounting line was an academic period-based designator or a financial aid year-based designator.	VARCHAR2(1)	CALCULATION	CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE =	NO	NO
DESIGNATOR_TYPE_DESC	Designator type description.	VARCHAR2(21)	CALCULATION	CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC =	NO	NO
DETAIL_CODE	Code defining type of transaction in accounts receivable.	VARCHAR2(63)	TBRACCD	TBRACCD_DETAIL_CODE	NO	NO
DETAIL_CODE_DESC	Transaction type 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
DOCUMENT_NUMBER	Document number which identifies a specific charge or payment.	VARCHAR2(63)	TBRACCD	TBRACCD_DOCUMENT_NUMBER	NO	NO
DUE_DATE	Payment due date.	DATE	TBRACCD	TBRACCD_DUE_DATE	NO	NO
EFFECTIVE_DATE	Date the transaction becomes effective. As of this date, the transaction is calculated into amount due and is eligible to be fed to accounting.	DATE	TBRACCD	TBRACCD_EFFECTIVE_DATE	NO	NO
ENTRY_DATE	Date this transaction was entered on the account.	DATE	TBRACCD	TBRACCD_ENTRY_DATE	NO	NO
EXTERNAL_IND	External indicator.	VARCHAR2(255)	NA	NA	NO	NO
FINANCIAL_AID_UPLOAD_FIELD	Links the financial aid fund to the AR transaction.	VARCHAR2(255)	NA	NA	NO	NO
FOREIGN_CURRENCY	Contains the foreign currency code used when making a payment.	VARCHAR2(63)	TBRDEPO	TBRDEPO_CURR_CODE	NO	NO
FOREIGN_CURRENCY_AMOUNT	Amount of the transaction as stated in foreign currency.	NUMBER	TBRDEPO	TBRDEPO_FOREIGN_AMOUNT	NO	NO
FOREIGN_CURRENCY_DESC	Currency code description or title.	VARCHAR2(255)	GTVCURR	GTVCURR_TITLE	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
INVOICE_NUMBER	Invoice number assigned to the transaction.	VARCHAR2(63)	TBRACCD	TBRACCD_INVOICE_NUMBER	NO	NO
JOURNAL_ENTRY	Journal entry.	VARCHAR2(255)	NA	NA	NO	NO
JOURNAL_SOURCE	Journal source.	VARCHAR2(255)	NA	NA	NO	NO
LEDGER_DESIGNATOR	Academic period-based or financial aid year-based designator used when using the current date (today) to reconcile balances in Accounts Receivable to the balances in the Finance general ledger for an account.	VARCHAR2(63)	CALCULATION	CASE WHEN TBBDETC_TBDC_IND	NO	NO
LEDGER_DESIGNATOR_DESC	Term-based (Academic Period based) ledger designator description.	VARCHAR2(255)	TTVABDS TTVTBDS	TTVABDS_DESC TTVTBDS_DESC	NO NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	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
OPERATING_DATE	Date used to extract the accounting line for the initial feed of this transaction to finance.	DATE	CALCULATION	DECODE ( DECODE ( SIGN ( NVL (TBRACCD_TRANS_DATE, TBRACCD_EFFECTIVE_DATE)	NO	NO
OPERATING_DESIGNATOR	Academic period-based or financial aid year-based designator used when using the finance feed date to find the accounting line fed to the Finance ledgers for a charge, payment or application of payments transaction.	VARCHAR2(63)	CALCULATION	CASE WHEN TBBEACT_TBDC_IND = 'Y'	NO	NO
OPERATING_DESIGNATOR_DESC	Term-based (Academic Period based) operating designator description.	VARCHAR2(255)	TTVABDS TTVTBDS	TTVABDS_DESC TTVTBDS_DESC	NO NO	NO
POSTING_DATE	Date the accounting transaction was interfaced to the financial ledgers.	DATE	TBRACCD	TBRACCD_FEED_DATE	NO	NO
POSTING_DOCUMENT	Document code generated to identify and feed this transaction to finance.	VARCHAR2(63)	TBRACCD	TBRACCD_FEED_DOC_CODE	NO	NO
POST_CASHIER	Identification code of the cashier who entered the transaction.	VARCHAR2(63)	TBRACCD	TBRACCD_USER	NO	NO
PRE_BILL_FLAG	Pre bill flag.	VARCHAR2(255)	NA	NA	NO	NO
PRIORITY	Priority of the detail code for use in the application of payments process.	VARCHAR2(63)	TBBDETC	TBBDETC_PRIORITY	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
RECEIPT_NUMBER	Receipt number associated with the transaction if a receipt number was generated when the transaction was entered.	NUMBER	TBRACCD	TBRACCD_RECEIPT_NUMBER	NO	NO
REFUND	Indicates the type of refund if the transaction is determined as a refund.	VARCHAR2(1)	TBBDETC TBRACCD	TBBDETC_REFUND_IND TBRACCD_REFUND_IND	NO NO	NO
REFUND_DESC	Refund description.	VARCHAR2(255)	CALCULATION	CASE WHEN TBBDETC_REFUND_IND	NO	NO
RETURNED_CHECK_IND	Determines if the detail code has been identified as the code to use for returned checks.	VARCHAR2(1)	CALCULATION	DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y')	NO	NO
SOURCE	Identifies the source of how the transaction was entered on the account.	VARCHAR2(63)	TBRACCD	TBRACCD_SRCE_CODE	NO	NO
SOURCE_DESC	Source code extracted description.	VARCHAR2(255)	TTVSRCE	TTVSRCE_DESC	NO	NO
STATEMENT_DATE	Date the statement was generated.	DATE	TBRACCD	TBRACCD_STATEMENT_DATE	NO	NO
STUDY_PATH	Study path key sequence for the course registration.	NUMBER	TBRACCD	TBRACCD_STSP_KEY_SEQUENCE	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	A session, portion or part of the academic period.	VARCHAR2(255)	NA	NA	NO	NO
TAX_AMOUNT	Amount of the transaction reported for 1098-t purposes.	NUMBER	TBRACCD	TBRACCD_TAX_AMOUNT	NO	NO
TAX_DOCUMENT	Tax document.	VARCHAR2(255)	NA	NA	NO	NO
TAX_DOCUMENT_BOX_NUMBER	Box in which amounts are reported for 1098-t purposes.	VARCHAR2(63)	TBRACCD	TBRACCD_TAX_REPT_BOX	NO	NO
TAX_DOCUMENT_BOX_NUMBER_DESC	Box in which amounts are reported for 1098-t purposes.	VARCHAR2(255)	CALCULATION FUNCTION	CASE WHEN TAX_DOCUMENT_BOX SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_DOCUMENT_BOX' AND VALUE = TAX_DOCUMENT_BOX_NUMBER	NO NO	NO
TAX_DOCUMENT_BOX_NUMBER_PR	Tax Report Box in which the transaction was eligible for reporting on the form 1098T. Values (PR) Qualified Payments Received, (AP) Adjustments to Payments Received.	VARCHAR2(63)	TBRACCD	TBRACCD_TAX_REPT_BOX_PR	NO	NO
TAX_DOCUMENT_BOX_NUMBER_PR_DESC	Box in which amounts are reported for 1098-t purposes.	VARCHAR2(255)	CALCULATION FUNCTION	CASE WHEN TAX_DOCUMENT_BOX SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_DOCUMENT_BOX' AND VALUE = TAX_DOCUMENT_BOX_NUMBER_PR	NO NO	NO
TAX_DOCUMENT_BOX_NUMBER_SG	Tax Report Box in which the transaction was reported on the form 1098T. Values (SG) Scholarship or Grant, (AS) Adjustments to Scholarship or Grant.	VARCHAR2(63)	TBRACCD	TBRACCD_TAX_REPT_BOX_SG	NO	NO
TAX_DOCUMENT_BOX_NUMBER_SG_DESC	Box in which amounts are reported for 1098-t purposes.	VARCHAR2(255)	CALCULATION FUNCTION	CASE WHEN TAX_DOCUMENT_BOX SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_DOCUMENT_BOX' AND VALUE = TAX_DOCUMENT_BOX_NUMBER_SG	NO NO	NO
TAX_FUTURE_ITEM	Specifies if the transaction is reported as a academic period beginning in a future tax year.	VARCHAR2(255)	TBRACCD	TBRACCD_TAX_FUTURE_IND	NO	NO
TAX_FUTURE_ITEM_PR	Tax Report Future Indicator is valued with Y if the transaction was reported on form 1098-T as a term beginning in a future tax year for rule PR, or null..	VARCHAR2(255)	TBRACCD	TBRACCD_TAX_FUTURE_IND_PR	NO	NO
TAX_FUTURE_ITEM_SG	Tax Report Future Indicator is valued with Y if the transaction was reported on form 1098-T as a term beginning in a future tax year for rule SG, or null.	VARCHAR2(255)	TBRACCD	TBRACCD_TAX_FUTURE_IND_SG	NO	NO
TAX_YEAR	Tax year the transaction is reported for 1098-t purposes.	NUMBER	TBRACCD	TBRACCD_TAX_REPT_YEAR	NO	NO
TRANSACTION_DATE	Date used by the finance system to control posting to the ledgers.	DATE	TBRACCD	TBRACCD_TRANS_DATE	NO	NO
TRANSACTION_DESC	Accounting transaction description.	VARCHAR2(255)	TBRACCD	TBRACCD_DESC	NO	NO
TRANSACTION_NUMBER	Transaction number.	NUMBER	TBRACCD	TBRACCD_TRAN_NUMBER	NO	NO
TRAN_NUMBER_PAID	Transaction number of a specific application of payment. This transaction was used to directly apply to the transaction number specified here.	NUMBER	TBRACCD	TBRACCD_TRAN_NUMBER_PAID	NO	NO

Ver: 9.2