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)	TBRACCD	TBRACCD_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ACCOUNT_DETAIL_ACTIVITY_DATE	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	Account Detail Data Origin	Source system that last created or updated the data.	VARCHAR2(63)	TBRACCD	TBRACCD_DATA_ORIGIN
ACCOUNT_DETAIL_USER_ID	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	Account Posted Amount	Amount that has been posted.	NUMBER	CALCULATION	DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_AMOUNT)
ACCOUNT_POSTING_STATUS	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	Account UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRACCD	TBRACCD_PIDM
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 disbursement. This period can span multiple student terms.	VARCHAR2(15)	TBRACCD	TBRACCD_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 financial aid disbursement.	VARCHAR2(4)	TBRACCD	TBRACCD_AIDY_CODE
AID_YEAR_DESC	Aid Year Description	Aid year description.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
AMOUNT	Amount	Sum of the amount of each account detail for this receivable account.	NUMBER	TBRACCD	TBRACCD_AMOUNT
BALANCE	Balance	Remaining balance for all account detail amounts after application of payments.	NUMBER	TBRACCD	TBRACCD_BALANCE
BILL_AMOUNT	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	Bill Date	Date that the transaction was billed.	DATE	TBRACCD	TBRACCD_BILL_DATE
BILL_SEQUENCE	Bill Sequence	Bill sequence.	NUMBER	NA	NA
CASHIER_END_DATE	Cashier End Date	Ending date of the cashiering session for the transaction.	DATE	TBRACCD	TBRACCD_CSHR_END_DATE
CASHIER_END_TIME	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	Cashier Session Number	Session number assigned to each cashier session.	NUMBER	TBRACCD	TBRACCD_SESSION_NUMBER
CATEGORY	Category	Identities category for a receivable transaction type. Examples are registration, housing, meal, contract.	VARCHAR2(63)	TBBDETC	TBBDETC_DCAT_CODE
CATEGORY_DESC	Category Description	Receivable category description.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC
CONTRACT_PYMT_TRANSACTION_IND	Contract Pymt Transaction Indicator	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	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	Credit card number or payment identification.	VARCHAR2(63)	TBRACCD	TBRACCD_PAYMENT_ID
CROSSREF_CATEGORY	Crossref Category	Category code that was the basis for a contract or exemption credit.	VARCHAR2(63)	TBRACCD	TBRACCD_CROSSREF_DCAT_CODE
CROSSREF_CATEGORY_DESC	Crossref Category Description	Specifies the category.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC
CROSSREF_DETAIL_CODE	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	Crossref Detail Code Description	Detail code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
CROSSREF_ENTITY_UID	Crossref Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRACCD	TBRACCD_CROSSREF_PIDM
CROSSREF_NUMBER	Crossref Number	Number of the deposit, contract, or exemption associated with the transaction.	NUMBER	TBRACCD	TBRACCD_CROSSREF_NUMBER
CROSSREF_SOURCE	Crossref Source	Source code that was the basis for a contract or exemption credit.	VARCHAR2(63)	TBRACCD	TBRACCD_CROSSREF_SRCE_CODE
CROSSREF_SOURCE_DESC	Crossref Source Description	Specifies the charge/payment detail source associated with the source code.	VARCHAR2(255)	TTVSRCE	TTVSRCE_DESC
DESIGNATOR_TYPE	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	Designator type description.	VARCHAR2(21)	CALCULATION	CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC =
DETAIL_CODE	Detail Code	Code defining type of transaction in accounts receivable.	VARCHAR2(63)	TBRACCD	TBRACCD_DETAIL_CODE
DETAIL_CODE_DESC	Detail Code Description	Transaction type 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
DOCUMENT_NUMBER	Document Number	Document number which identifies a specific charge or payment.	VARCHAR2(63)	TBRACCD	TBRACCD_DOCUMENT_NUMBER
DUE_DATE	Due Date	Payment due date.	DATE	TBRACCD	TBRACCD_DUE_DATE
EFFECTIVE_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	Entry Date	Date this transaction was entered on the account.	DATE	TBRACCD	TBRACCD_ENTRY_DATE
EXTERNAL_IND	External Indicator	External indicator.	VARCHAR2(255)	NA	NA
FINANCIAL_AID_UPLOAD_FIELD	Financial Aid Upload Field	Links the financial aid fund to the AR transaction.	VARCHAR2(255)	NA	NA
FOREIGN_CURRENCY	Foreign Currency	Contains the foreign currency code used when making a payment.	VARCHAR2(63)	TBRDEPO	TBRDEPO_CURR_CODE
FOREIGN_CURRENCY_AMOUNT	Foreign Currency Amount	Amount of the transaction as stated in foreign currency.	NUMBER	TBRDEPO	TBRDEPO_FOREIGN_AMOUNT
FOREIGN_CURRENCY_DESC	Foreign Currency Description	Currency code description or title.	VARCHAR2(255)	GTVCURR	GTVCURR_TITLE
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
INVOICE_NUMBER	Invoice Number	Invoice number assigned to the transaction.	VARCHAR2(63)	TBRACCD	TBRACCD_INVOICE_NUMBER
JOURNAL_ENTRY	Journal Entry	Journal entry.	VARCHAR2(255)	NA	NA
JOURNAL_SOURCE	Journal Source	Journal source.	VARCHAR2(255)	NA	NA
LEDGER_DESIGNATOR	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	Ledger Designator Description	Term-based (Academic Period based) ledger designator description.	VARCHAR2(255)	TTVABDS TTVTBDS	TTVABDS_DESC TTVTBDS_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	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
OPERATING_DATE	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	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	Operating Designator Description	Term-based (Academic Period based) operating designator description.	VARCHAR2(255)	TTVABDS TTVTBDS	TTVABDS_DESC TTVTBDS_DESC
POSTING_DATE	Posting Date	Date the accounting transaction was interfaced to the financial ledgers.	DATE	TBRACCD	TBRACCD_FEED_DATE
POSTING_DOCUMENT	Posting Document	Document code generated to identify and feed this transaction to finance.	VARCHAR2(63)	TBRACCD	TBRACCD_FEED_DOC_CODE
POST_CASHIER	Post Cashier	Identification code of the cashier who entered the transaction.	VARCHAR2(63)	TBRACCD	TBRACCD_USER
PRE_BILL_FLAG	Pre Bill Indicator	Pre bill flag.	VARCHAR2(255)	NA	NA
PRIORITY	Priority	Priority of the detail code for use in the application of payments process.	VARCHAR2(63)	TBBDETC	TBBDETC_PRIORITY
PROCESS_GROUP	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	Receipt number associated with the transaction if a receipt number was generated when the transaction was entered.	NUMBER	TBRACCD	TBRACCD_RECEIPT_NUMBER
REFUND	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	Refund description.	VARCHAR2(255)	CALCULATION	CASE WHEN TBBDETC_REFUND_IND
RETURNED_CHECK_IND	Returned Check Indicator	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	Source	Identifies the source of how the transaction was entered on the account.	VARCHAR2(63)	TBRACCD	TBRACCD_SRCE_CODE
SOURCE_DESC	Source Description	Source code extracted description.	VARCHAR2(255)	TTVSRCE	TTVSRCE_DESC
STATEMENT_DATE	Statement Date	Date the statement was generated.	DATE	TBRACCD	TBRACCD_STATEMENT_DATE
STUDY_PATH	Study Path	Study path key sequence for the course registration.	NUMBER	TBRACCD	TBRACCD_STSP_KEY_SEQUENCE
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	A session, portion or part of the academic period.	VARCHAR2(255)	NA	NA
TAX_AMOUNT	Tax Amount	Amount of the transaction reported for 1098-t purposes.	NUMBER	TBRACCD	TBRACCD_TAX_AMOUNT
TAX_DOCUMENT	Tax Document	Tax document.	VARCHAR2(255)	NA	NA
TAX_DOCUMENT_BOX_NUMBER	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	Tax Document Box Number Description	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_DOCUMENT_BOX_NUMBER_PR	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
TAX_DOCUMENT_BOX_NUMBER_PR_DESC	Tax Document Box Number Desc PR	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
TAX_DOCUMENT_BOX_NUMBER_SG	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
TAX_DOCUMENT_BOX_NUMBER_SG_DESC	Tax Document Box Number Desc SG	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
TAX_FUTURE_ITEM	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_FUTURE_ITEM_PR	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
TAX_FUTURE_ITEM_SG	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
TAX_YEAR	Tax Year	Tax year the transaction is reported for 1098-t purposes.	NUMBER	TBRACCD	TBRACCD_TAX_REPT_YEAR
TRANSACTION_DATE	Transaction Date	Date used by the finance system to control posting to the ledgers.	DATE	TBRACCD	TBRACCD_TRANS_DATE
TRANSACTION_DESC	Transaction Description	Accounting transaction description.	VARCHAR2(255)	TBRACCD	TBRACCD_DESC
TRANSACTION_NUMBER	Transaction Number	Transaction number.	NUMBER	TBRACCD	TBRACCD_TRAN_NUMBER
TRAN_NUMBER_PAID	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.2