Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACCOUNT	Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)	FGBTRND	FGBTRND_ACCT_CODE	NO	NO
ACCOUNT_INDEX	Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)	FGBTRND	FGBTRND_ACCI_CODE	NO	NO
ACCRUAL_IND	Indicator used during the accrual period to determine if the system automatically generates transactions for both current and prior fiscal years.	VARCHAR2(1)	FGBTRNH	FGBTRNH_ACCRUAL_IND	NO	NO
ACTIVITY	Code used to identify accounting data by activity.	VARCHAR2(6)	FGBTRND	FGBTRND_ACTV_CODE	NO	NO
ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FGBTRND	FGBTRND_ACTIVITY_DATE	NO	NO
ACTIVITY_DESC	Activity code title or description.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
ACTIVITY_STATUS	Extracted current status of the associated activity.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
AMOUNT_IND	Indicates the amount was posted.	VARCHAR2(1)	FGBTRND	FGBTRND_AMT_IND	NO	NO
AUTO_JOURNAL_ID	User-defined value providing unique identification for a recurring journal voucher.	VARCHAR2(3)	FGBTRNH	FGBTRNH_AUTO_JRNL_ID	NO	NO
AVAILABLE_BUDGET_OVERRIDE	Indicates if available fund checking was overridden when a lack of funds condition existed.	VARCHAR2(1)	FGBTRNH	FGBTRNH_ABAL_OVERRIDE	NO	NO
BANK	Code used to identify the bank account on all cash transactions.	VARCHAR2(2)	FGBTRNH	FGBTRNH_BANK_CODE	NO	NO
BANK_DESC	Name of the bank where the institution has accounts.	VARCHAR2(35)	GXVBANK	GXVBANK_ACCT_NAME	NO	NO
BANK_UID	Internal identification number of the bank used at the time the transaction occurred.	NUMBER	GXVBANK	GXVBANK_BANK_CODE_PIDM	NO	NO
BUDGET_DISPOSITION	Indicator that determines the year-end processing or budget requested encumbrance amounts.	VARCHAR2(1)	FGBTRNH	FGBTRNH_BUD_DISPN	NO	NO
BUDGET_ID	User-defined unique identification of the budget identifier. Generally Fiscal year for which the budget is being prepared.	VARCHAR2(6)	FGBTRND	FGBTRND_BUD_ID	NO	NO
BUDGET_PERIOD	Numeric value of the budget period being entered if this is a budget journal.	VARCHAR2(2)	FGBTRNH	FGBTRNH_BUDGET_PERIOD	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FGBTRND	FGBTRND_COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CHART_OF_ACCOUNTS_POOL	Code that denotes the pool chart of account that the investment fund code is participating.	VARCHAR2(1)	FGBTRNH	FGBTRNH_COAS_CODE_POOL	NO	NO
CHART_OF_ACCOUNTS_POOL_DESC	Retrieved description or title of the associated chart of accounts.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CHART_OF_ACCOUNTS_POOL_STATUS	Retrieved current status of the associated chart of accounts.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
CHART_OF_ACCOUNTS_STATUS	Extracted current status of the associated chart of accounts.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
COMMIT_PERCENT	Percentage of budget to be rolled into the next fiscal year as committed funds.	NUMBER	FGBTRND	FGBTRND_CMT_PCT	NO	NO
COMMIT_TYPE	Indicates whether a line item represents funds committed from the prior year budget. U=uncommitted or C=committed.	VARCHAR2(1)	FGBTRND	FGBTRND_CMT_TYPE	NO	NO
CONVERT_AMOUNT	Base currency amount calculated for this accounting record.	NUMBER	FGBTRNH	FGBTRNH_CONVERT_AMT	NO	NO
COST_SHARE_RATE	Cost share rate for this grant.	NUMBER	FGBTRND	FGBTRND_CS_RATE_PERCENT	NO	NO
CURRENCY	Type of currency represented in the amount field.	VARCHAR2(4)	FGBTRNH	FGBTRNH_CURR_CODE	NO	NO
CURRENCY_DESC	Currency code description or title.	VARCHAR2(35)	GTVCURR	GTVCURR_TITLE	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DEBIT_CREDIT_IND	Determines a debit or credit effect on the ledgers; plus or minus, debit or credit.	VARCHAR2(1)	FGBTRND	FGBTRND_DR_CR_IND	NO	NO
DEPOSIT_NUMBER	Deposit number assigned to this transaction.	VARCHAR2(8)	FGBTRNH	FGBTRNH_DEP_NUM	NO	NO
DETAIL_BUDGET_PERIOD	Numeric value of the budget period used if this is a budget journal.	VARCHAR2(2)	FGBTRND	FGBTRND_BUDGET_PERIOD	NO	NO
DETAIL_POSTING_PROCESS	Code that identifies what accounting actions are to be taken with the ledgers.	VARCHAR2(4)	FGBTRND	FGBTRND_PROC_CODE	NO	NO
DETAIL_POSTING_PROCESS_DESC	Retrieves description for posting process.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
DETAIL_PROJECT	Work order code associated with the transaction.	VARCHAR2(8)	FGBTRND	FGBTRND_PRJD_CODE	NO	NO
DETAIL_REVERSAL_IND	Indicates if a document was canceled or reversed.	VARCHAR2(1)	FGBTRND	FGBTRND_REVERSAL_IND	NO	NO
DETAIL_SERIAL_NUMBER	Unique system assigned number to control unique creation of transaction source history records.	NUMBER	FGBTRND	FGBTRND_SERIAL_NUM	NO	NO
DETAIL_SUM_POST_DOC_CODE	Document number generated in a given posting run to facilitate summary general ledger postings. Format is MMDDHHMM.	VARCHAR2(8)	FGBTRND	FGBTRND_SUM_POST_DOC_CODE	NO	NO
DETAIL_USER_ID	Unique identification code of the user who entered the transaction.	VARCHAR2(30)	FGBTRND	FGBTRND_USER_ID	NO	NO
DIRECT_INDIRECT_IND	This field specifies the direct/indirect indicator.	VARCHAR2(1)	NA	NA	NO	NO
DISTRIBUTION_PERCENT	Percentage of the of the transaction total amount assigned to this accounting distribution.	NUMBER	FGBTRNH	FGBTRNH_DIST_PCT	NO	NO
DOCUMENT	User-defined or system generated document number.	VARCHAR2(8)	FGBTRNH	FGBTRNH_DOC_CODE	NO	NO
DOCUMENT_DATE	Document date.	DATE	NA	NA	NO	NO
DOCUMENT_TYPE	Unique identifier that internally defines document types or entities associated to this text.	NUMBER	FGBTRNH	FGBTRNH_DOC_SEQ_CODE	NO	NO
DOCUMENT_TYPE_DESC	Document/entity type description.	VARCHAR2(35)	FTVDTYP	FTVDTYP_DESC	NO	NO
DOC_REFERENCE_NUMBER	User-defined number providing additional identification for the transaction.	VARCHAR2(8)	FGBTRNH	FGBTRNH_DOC_REF_NUM	NO	NO
DOC_REFERENCE_NUMBER2	The second user-defined number providing additional identification for the transaction.	VARCHAR2(1)	NA	NA	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
ENCUMBRANCE_ACTION_IND	Liquidation action on encumbrances as partial, total, adjustment or original.	VARCHAR2(1)	FGBTRNH	FGBTRNH_ENCD_ACTION_IND	NO	NO
ENCUMBRANCE_ITEM_NUMBER	Number associated with each individual commodity on the encumbering document.	NUMBER	FGBTRND	FGBTRND_ENCD_ITEM_NUM	NO	NO
ENCUMBRANCE_NUMBER	Unique encumbrance code of a document.	VARCHAR2(8)	FGBTRND	FGBTRND_ENCD_NUM	NO	NO
ENCUMBRANCE_SEQ_NUMBER	Number associated with each accounting distribution on an encumbering document.	NUMBER	FGBTRND	FGBTRND_ENCD_SEQ_NUM	NO	NO
ENCUMBRANCE_TYPE	Indicates the type of encumbrance as either general encumbrance, labor, purchase order or requisition.	VARCHAR2(1)	FGBTRNH	FGBTRNH_ENCB_TYPE	NO	NO
EXCHANGE_AMOUNT	Exchange amount is the difference between the input transaction amount and the converted amount. Is used to balance the exchange accounts associated to each currency code.	NUMBER	FGBTRNH	FGBTRNH_EXCHANGE_AMT	NO	NO
EXCHANGE_DIFFERENCE	Difference between the exchange amounts from when the invoice is recorded to when the check is written. Is also used to balance the exchange accounts associated to each currency code.	NUMBER	FGBTRNH	FGBTRNH_EXCHANGE_DIFF	NO	NO
FIELD_CODE	Two-digit code that represents the specific ledger bucket being updated.	VARCHAR2(2)	FGBTRND	FGBTRND_FIELD_CODE	NO	NO
FISCAL_PERIOD_HEADER		VARCHAR2(2)				NO
FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(4)	CALCULATION	TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'),'YYYY')	NO	NO
FISCAL_YEAR_HEADER	A unique identifier code for the fiscal year being defined. Function fofyncv returns a four-digit year when supplied a two-digit year. This field is from the Transaction History table.	VARCHAR2(4)	CALCULATION	TO_CHAR(TO_DATE(FGBTRNH_FSYR_CODE,'RR'),'YYYY')	NO	NO
FISCAL_YEAR_TWO_CHAR	A unique identifier code for the fiscal year being defined. This field is from the Transaction History table and is not expanded.	VARCHAR2(2)	FGBTRNH	FGBTRNH_FSYR_CODE	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	FGBTRND	FGBTRND_FUND_CODE	NO	NO
FUND_POOL	Code that denotes the pool fund that the investment fund code is participating.	VARCHAR2(6)	FGBTRNH	FGBTRNH_FUND_CODE_POOL	NO	NO
FUND_POOL_DESC	Transaction fund description.	VARCHAR2(35)	FTVFUND	FTVFUND_TITLE	NO	NO
FUND_POOL_STATUS	Extracted current status of the associated fund.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
INDIRECT_COST_MEMO_RATE	Indirect cost memo rate percentage.	NUMBER	FGBTRND	FGBTRND_IC_MEMO_RATE_PERCENT	NO	NO
INDIRECT_COST_RATE	Indirect cost rate percentage for the grant fund.	NUMBER	FGBTRND	FGBTRND_IC_RATE_PERCENT	NO	NO
ITEM	System-generated line item number that identifies each commodity line item for procurement documents.	NUMBER	FGBTRNH	FGBTRNH_ITEM_NUM	NO	NO
LEDGER_IND	One-position field that indicates if the ledger updated by this transaction was the encumbrance, general or operating (subsidiary) ledger.	VARCHAR2(1)	FGBTRND	FGBTRND_LEDGER_IND	NO	NO
LIQUIDATION_AMOUNT	Liquidation amount.	NUMBER	NA	NA	NO	NO
LOCATION	Identification accounting code of the physical location of the financial manager.	VARCHAR2(6)	FGBTRND	FGBTRND_LOCN_CODE	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
ORGANIZATION_CODE	Identification accounting code used for the department.	VARCHAR2(6)	FGBTRND	FGBTRND_ORGN_CODE	NO	NO
OTHER_DATA	User-defined free-form description.	VARCHAR2(30)	FGBTRND	FGBTRND_OTHER_DATA	NO	NO
POSTING_PERIOD	Unique two-digit identifier of a period posted to with amounts within a fiscal year. Generally this contains values between 00 and 14.	VARCHAR2(2)	FGBTRND	FGBTRND_POSTING_PERIOD	NO	NO
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(6)	FGBTRND	FGBTRND_PROG_CODE	NO	NO
PROJECT	Work order code used within cost accounting module.	VARCHAR2(8)	FGBTRNH	FGBTRNH_PRJD_CODE	NO	NO
RECONCILIATION_IND	Indicates if a deposit has been reconciled.	VARCHAR2(1)	FGBTRND	FGBTRND_RECON_IND	NO	NO
REVERSAL_IND	Indicates if a document was canceled or reversed.	VARCHAR2(1)	FGBTRNH	FGBTRNH_REVERSAL_IND	NO	NO
RULE_CLASS	Accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)	FGBTRND	FGBTRND_RUCL_CODE	NO	NO
RULE_CLASS_DESC	Unique title assigned to a rule class.	VARCHAR2(35)	FTVRUCL	FTVRUCL_CLASS_TITLE	NO	NO
RULE_PROCESS	Four-digit field that is an assigned sequence number to each process within a rule code.	VARCHAR2(4)	FGBTRND	FGBTRND_RULP_CODE	NO	NO
SEQUENCE_NUMBER	System-generated one-up number to support split accounting within a document.	NUMBER	FGBTRNH	FGBTRNH_SEQ_NUM	NO	NO
SERIAL_NUMBER	Unique system assigned number to control unique creation of transaction source history records.	NUMBER	FGBTRNH	FGBTRNH_SERIAL_NUM	NO	NO
SUBMISSION_NUMBER	Submission number used for documents that utilized resubmission features.	NUMBER	FGBTRNH	FGBTRNH_SUBMISSION_NUMBER	NO	NO
SUM_POSTING_DOCUMENT_CODE	Document number generated in a given posting run to facilitate summary general ledger postings. Format is MMDDHHMM.	VARCHAR2(8)	FGBTRNH	FGBTRNH_SUM_POST_DOC_CODE	NO	NO
TRANSACTION_AMOUNT	Amount of the transaction associated with this particular account distribution.	NUMBER	FGBTRND	FGBTRND_TRANS_AMT	NO	NO
TRANSACTION_DATE	Date used by the finance system to control posting to the ledgers.	DATE	FGBTRNH	FGBTRNH_TRANS_DATE	NO	NO
TRANSACTION_DESC	Accounting transaction description.	VARCHAR2(35)	FGBTRNH	FGBTRNH_TRANS_DESC	NO	NO
USER_ID	Unique identification code of the user who entered the transaction.	VARCHAR2(30)	FGBTRNH	FGBTRNH_USER_ID	NO	NO
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FGBTRNH	FGBTRNH_VENDOR_PIDM	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: