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(63)	TBRACCD	TBRACCD_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ACCOUNT_DETAIL_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	TBRACCD	TBRACCD_ACTIVITY_DATE
ACCOUNT_DETAIL_DATA_ORIGIN	Source system that last created or updated the data.	VARCHAR2(63)	TBRACCD	TBRACCD_DATA_ORIGIN
ACCOUNT_DETAIL_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	TBRACCD	TBRACCD_USER
ACCOUNT_POSTED_AMOUNT	Amount that has been posted.	NUMBER	CALCULATION	DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_AMOUNT)
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
ACCOUNT_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRACCD	TBRACCD_PIDM
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 associated with the financial aid disbursement. This period can span multiple student terms.	VARCHAR2(15)	TBRACCD	TBRACCD_PERIOD
AID_ENROLLMENT_PERIOD_DESC	Aid enrollment period description.	VARCHAR2(255)	ROBPRDS	ROBPRDS_DESC
AID_YEAR	Aid year associated with financial aid disbursement.	VARCHAR2(4)	TBRACCD	TBRACCD_AIDY_CODE
AID_YEAR_DESC	Aid year description.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
AMOUNT	Sum of the amount of each account detail for this receivable account.	NUMBER	TBRACCD	TBRACCD_AMOUNT
BALANCE	Remaining balance for all account detail amounts after application of payments.	NUMBER	TBRACCD	TBRACCD_BALANCE
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)
BILL_DATE	Date that the transaction was billed.	DATE	TBRACCD	TBRACCD_BILL_DATE
BILL_SEQUENCE	Bill sequence.	NUMBER	NA	NA
CASHIER_END_DATE	Ending date of the cashiering session for the transaction.	DATE	TBRACCD	TBRACCD_CSHR_END_DATE
CASHIER_END_TIME	Ending time of the cashiering session for the transaction.	VARCHAR2(255)	CALCULATION	TO_CHAR(TBRACCD_CSHR_END_DATE,'HH24:MM:SS')
CASHIER_SESSION_NUMBER	Session number assigned to each cashier session.	NUMBER	TBRACCD	TBRACCD_SESSION_NUMBER
CATEGORY	Identities category for a receivable transaction type. Examples are registration, housing, meal, contract.	VARCHAR2(63)	TBBDETC	TBBDETC_DCAT_CODE
CATEGORY_DESC	Receivable category description.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC
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
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
CREDIT_CARD_NUMBER	Credit card number or payment identification.	VARCHAR2(63)	TBRACCD	TBRACCD_PAYMENT_ID
CROSSREF_CATEGORY	Category code that was the basis for a contract or exemption credit.	VARCHAR2(63)	TBRACCD	TBRACCD_CROSSREF_DCAT_CODE
CROSSREF_CATEGORY_DESC	Specifies the category.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC
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
CROSSREF_DETAIL_CODE_DESC	Detail code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
CROSSREF_ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRACCD	TBRACCD_CROSSREF_PIDM
CROSSREF_NUMBER	Number of the deposit, contract, or exemption associated with the transaction.	NUMBER	TBRACCD	TBRACCD_CROSSREF_NUMBER
CROSSREF_SOURCE	Source code that was the basis for a contract or exemption credit.	VARCHAR2(63)	TBRACCD	TBRACCD_CROSSREF_SRCE_CODE
CROSSREF_SOURCE_DESC	Specifies the charge/payment detail source associated with the source code.	VARCHAR2(255)	TTVSRCE	TTVSRCE_DESC
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 =
DESIGNATOR_TYPE_DESC	Designator type description.	VARCHAR2(21)	CALCULATION	CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC =
DETAIL_CODE	Code defining type of transaction in accounts receivable.	VARCHAR2(63)	TBRACCD	TBRACCD_DETAIL_CODE
DETAIL_CODE_DESC	Transaction type description.	VARCHAR2(255)	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
DOCUMENT_NUMBER	Document number which identifies a specific charge or payment.	VARCHAR2(63)	TBRACCD	TBRACCD_DOCUMENT_NUMBER
DUE_DATE	Payment due date.	DATE	TBRACCD	TBRACCD_DUE_DATE
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
ENTRY_DATE	Date this transaction was entered on the account.	DATE	TBRACCD	TBRACCD_ENTRY_DATE
EXTERNAL_IND	External indicator.	VARCHAR2(255)	NA	NA
FINANCIAL_AID_UPLOAD_FIELD	Links the financial aid fund to the AR transaction.	VARCHAR2(255)	NA	NA
FOREIGN_CURRENCY	Contains the foreign currency code used when making a payment.	VARCHAR2(63)	TBRDEPO	TBRDEPO_CURR_CODE
FOREIGN_CURRENCY_AMOUNT	Amount of the transaction as stated in foreign currency.	NUMBER	TBRDEPO	TBRDEPO_FOREIGN_AMOUNT
FOREIGN_CURRENCY_DESC	Currency code description or title.	VARCHAR2(255)	GTVCURR	GTVCURR_TITLE
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
INVOICE_NUMBER	Invoice number assigned to the transaction.	VARCHAR2(63)	TBRACCD	TBRACCD_INVOICE_NUMBER
JOURNAL_ENTRY	Journal entry.	VARCHAR2(255)	NA	NA
JOURNAL_SOURCE	Journal source.	VARCHAR2(255)	NA	NA
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
LEDGER_DESIGNATOR_DESC	Term-based (Academic Period based) ledger designator description.	VARCHAR2(255)	TTVABDS TTVTBDS	TTVABDS_DESC TTVTBDS_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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)
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'
OPERATING_DESIGNATOR_DESC	Term-based (Academic Period based) operating designator description.	VARCHAR2(255)	TTVABDS TTVTBDS	TTVABDS_DESC TTVTBDS_DESC
POSTING_DATE	Date the accounting transaction was interfaced to the financial ledgers.	DATE	TBRACCD	TBRACCD_FEED_DATE
POSTING_DOCUMENT	Document code generated to identify and feed this transaction to finance.	VARCHAR2(63)	TBRACCD	TBRACCD_FEED_DOC_CODE
POST_CASHIER	Identification code of the cashier who entered the transaction.	VARCHAR2(63)	TBRACCD	TBRACCD_USER
PRE_BILL_FLAG	Pre bill flag.	VARCHAR2(255)	NA	NA
PRIORITY	Priority of the detail code for use in the application of payments process.	VARCHAR2(63)	TBBDETC	TBBDETC_PRIORITY
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RECEIPT_NUMBER	Receipt number associated with the transaction if a receipt number was generated when the transaction was entered.	NUMBER	TBRACCD	TBRACCD_RECEIPT_NUMBER
REFUND	Indicates the type of refund if the transaction is determined as a refund.	VARCHAR2(1)	TBBDETC TBRACCD	TBBDETC_REFUND_IND TBRACCD_REFUND_IND
REFUND_DESC	Refund description.	VARCHAR2(255)	CALCULATION	CASE WHEN TBBDETC_REFUND_IND
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')
SOURCE	Identifies the source of how the transaction was entered on the account.	VARCHAR2(63)	TBRACCD	TBRACCD_SRCE_CODE
SOURCE_DESC	Source code extracted description.	VARCHAR2(255)	TTVSRCE	TTVSRCE_DESC
STATEMENT_DATE	Date the statement was generated.	DATE	TBRACCD	TBRACCD_STATEMENT_DATE
STUDY_PATH	Study path key sequence for the course registration.	NUMBER	TBRACCD	TBRACCD_STSP_KEY_SEQUENCE
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	A session, portion or part of the academic period.	VARCHAR2(255)	NA	NA
TAX_AMOUNT	Amount of the transaction reported for 1098-t purposes.	NUMBER	TBRACCD	TBRACCD_TAX_AMOUNT
TAX_DOCUMENT	Tax document.	VARCHAR2(255)	NA	NA
TAX_DOCUMENT_BOX_NUMBER	Box in which amounts are reported for 1098-t purposes.	VARCHAR2(63)	TBRACCD	TBRACCD_TAX_REPT_BOX
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
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
TAX_YEAR	Tax year the transaction is reported for 1098-t purposes.	NUMBER	TBRACCD	TBRACCD_TAX_REPT_YEAR
TRANSACTION_DATE	Date used by the finance system to control posting to the ledgers.	DATE	TBRACCD	TBRACCD_TRANS_DATE
TRANSACTION_DESC	Accounting transaction description.	VARCHAR2(255)	TBRACCD	TBRACCD_DESC
TRANSACTION_NUMBER	Transaction number.	NUMBER	TBRACCD	TBRACCD_TRAN_NUMBER
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

Ver: 9.1