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(6)	TBRACCD	TBRACCD_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC
ACCOUNT_DETAIL_ACTIVITY_DATE	The last date this row was created or updated.	DATE	TBRACCD	TBRACCD_ACTIVITY_DATE
ACCOUNT_DETAIL_DATA_ORIGIN		VARCHAR2(30)
ACCOUNT_DETAIL_USER_ID		VARCHAR2(30)
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
AID YEAR	Aid year associated with financial aid disbursement.	VARCHAR2(4)	TBRACCD	TBRACCD_AIDY_CODE
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_YEAR		VARCHAR2(4)
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(8)	TBRACCD	TBRACCD_CSHR_END_DATE
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(3)	TBBDETC	TBBDETC_DCAT_CODE
CATEGORY_DESC	Receivable category description.	VARCHAR2(30)	TTVDCAT	TTVDCAT_DESC
CONTRACT_PYMT_TRANSACTION_IND		VARCHAR2(1)
COURSE_REFERENCE_NUMBER	Course Reference Number of the course which generated the charge, when Track by CRN is used in Fee Assessment.	VARCHAR2(5)	TBRACCD	TBRACCD_CRN
CREDIT_CARD_NUMBER	Credit card number or payment identification.	VARCHAR2(20)	TBRACCD	TBRACCD_PAYMENT_ID
CROSSREF_CATEGORY	Category code that was the basis for a contract or exemption credit.	VARCHAR2(3)	TBRACCD	TBRACCD_CROSSREF_DCAT_CODE
CROSSREF_CATEGORY_DESC	Specifies the category.	VARCHAR2(30)	TTVDCAT	TTVDCAT_DESC
CROSSREF_DETAIL_CODE	Detail code of the charge that is offset by a third party or exemption credit.	VARCHAR2(4)	TBRACCD	TBRACCD_CROSSREF_DETAIL_CODE
CROSSREF_DETAIL_CODE_DESC	Detail code description.	VARCHAR2(30)	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(1)	TBRACCD	TBRACCD_CROSSREF_SRCE_CODE
CROSSREF_SOURCE_DESC	Specifies the charge/payment detail source associated with the source code.	VARCHAR2(30)	TTVSRCE	TTVSRCE_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
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.	CHAR(1)
DESIGNATOR_TYPE_DESC	Designator type description.	VARCHAR2(21)
DETAIL_CODE	Code defining type of transaction in accounts receivable.	VARCHAR2(4)	TBRACCD	TBRACCD_DETAIL_CODE
DETAIL_CODE_DESC	Transaction type description.	VARCHAR2(30)	TBBDETC	TBBDETC_DESC
DETAIL_CODE_TYPE	Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)	TBRACCD	TBRACCD_DOCUMENT_NUMBER
DOCUMENT_NUMBER	Document number which identifies a specific charge or payment.	VARCHAR2(8)	TBRACCD	TBRACCD_DUE_DATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
DUE_DATE	Payment due date.	DATE	TBRACCD	TBRACCD_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_ENTRY_DATE
ENTRY_DATE	Date this transaction was entered on the account.	DATE	TRRACCD	TRRACCD_ENTRY_DATE
EXTERNAL_IND	External indicator.	VARCHAR2(0)	NA	NA
FINANCIAL_AID_UPLOAD_FIELD	Links the financial aid fund to the AR transaction.	VARCHAR2(0)	NA	NA
FOREIGN_CURRENCY	Contains the foreign currency code used when making a payment.	VARCHAR2(4)	TBRACCD	TBRACCD_CURR_CODE
FOREIGN_CURRENCY_AMOUNT	Amount of the transaction as stated in foreign currency.	NUMBER	TBRACCD	TBRACCD_FOREIGN_AMOUNT
FOREIGN_CURRENCY_DESC	Currency code description or title.	VARCHAR2(35)	GTVCURR	GTVCURR_TITLE
INVOICE_NUMBER	Invoice number assigned to the transaction.	VARCHAR2(8)	TBRACCD	TBRACCD_INVOICE_NUMBER
JOURNAL_ENTRY	Journal entry.	VARCHAR2(0)	NA	NA
JOURNAL_SOURCE	Journal source.	VARCHAR2(0)	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(2)
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
OPERATING_DATE	Date used to extract the accounting line for the initial feed of this transaction to finance.	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(2)
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(8)	TBRACCD	TBRACCD_FEED_DOC_CODE
POST_CASHIER	Identification code of the cashier who entered the transaction.	VARCHAR2(30)	TBRACCD	TBRACCD_USER
PRE_BILL_FLAG	Pre bill flag.	VARCHAR2(0)	NA	NA
PRIORITY	Priority of the detail code for use in the application of payments process.	VARCHAR2(3)	TBBDETC	TBBDETC_PRIORITY
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	TBBDETC_REFUND_IND
REFUND_DESC	Refund description.	VARCHAR2(18)	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(1)	TBRACCD	TBRACCD_SRCE_CODE
SOURCE_DESC	Source code extracted description.	VARCHAR2(30)	TTVSRCE	TTVSRCE_DESC
STATEMENT_DATE	The date a 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(0)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	A session, portion or part of the academic period.	VARCHAR2(0)	NA	NA
TAX_AMOUNT	Amount of the transaction reported for 1098-t purposes.	NUMBER	TBRACCD	TBRACCD_TAX_AMOUNT
TAX_DOCUMENT	Tax document.	VARCHAR2(0)	NA	NA
TAX_DOCUMENT_BOX_NUMBER	Box in which amounts are reported for 1098-t purposes.	VARCHAR2(2)	TBRACCD	TBRACCD_TAX_REPT_BOX
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(2)	TBRACCD	TBRACCD_TAX_REPT_BOX_PR
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(2)	TBRACCD	TBRACCD_TAX_REPT_BOX_SG
TAX_FUTURE_ITEM	Specifies if the transaction is reported as a academic period beginning in a future tax year.	VARCHAR2(1)	TBRACCD	TBRACCD_TAX_FUTURE_IND
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(1)	TBRACCD	TBRACCD_TAX_FUTURE_IND_PR
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(1)	TBRACCD	TBRACCD_TAX_FUTURE_IND_SG
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(30)	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
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: