Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
|
Transaction academic period code.
|
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
|
Account Detail Activity Date
|
The last date this row was created or updated.
|
DATE
|
|
TBRACCD
|
TBRACCD_ACTIVITY_DATE
|
ACCOUNT_DETAIL_DATA_ORIGIN
|
Account Detail Data Origin
|
|
VARCHAR2(30)
|
|
|
|
ACCOUNT_DETAIL_USER_ID
|
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(8)
|
|
TBRACCD
|
TBRACCD_PIDM
|
AID YEAR
|
Aid Year
|
Aid year associated with financial aid disbursement.
|
VARCHAR2(4)
|
|
TBRACCD
|
TBRACCD_AIDY_CODE
|
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_YEAR
|
Financial 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(5)
|
|
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
|
Contract Pymt Transaction Indicator
|
|
VARCHAR2(1)
|
|
|
|
COURSE_REFERENCE_NUMBER
|
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(8)
|
|
TBRACCD
|
TBRACCD_CROSSREF_PIDM
|
CROSSREF_NUMBER
|
|
Number of the deposit, contract, or exemption associated with the transaction.
|
NUMBER(8)
|
|
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
|
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
|
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(12, 2)
|
|
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
|
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
|
Operating Date
|
Date used to extract the accounting line for the initial feed of this transaction to finance.
|
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(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(8)
|
|
TBRACCD
|
TBRACCD_RECEIPT_NUMBER
|
REFUND
|
Refund
|
Indicates the type of refund if the transaction is determined as a refund.
|
VARCHAR2(1)
|
|
TBBDETC
|
TBBDETC_REFUND_IND
|
REFUND_DESC
|
Refund Description
|
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
|
Statement Date
|
The date a 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
|
|
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(12, 2)
|
|
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_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_YEAR
|
|
Tax year the transaction is reported for 1098-t purposes.
|
NUMBER(4)
|
|
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(8)
|
|
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(8)
|
|
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
|