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)	FTCRACTG	ACCT_CODE	NO	NO
ACCOUNTING_KEY	Unique internal identification number of the accounting record.	NUMBER	FTCRACTG	ID	NO	NO
ACCOUNT_INDEX	Account Index used to default an accounting distribution.	VARCHAR2(6)	FTCRACTG	ACCI_CODE	NO	NO
ACCOUNT_INDEX_DESC	Account index description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC	NO	NO
ACTIVITY	Code used to identify accounting data by activity.	VARCHAR2(6)	FTCRACTG	ACTV_CODE	NO	NO
AMOUNT	Amount entered on the funding source to be used for the expense. The total of amount and percent (if any) must be equal to 100 percent for the expense item at final approval.	NUMBER	FTCRACTG	AMOUNT	NO	NO
BANK	Official banking institution.	VARCHAR2(2)	FTCRACTG	BANK_CODE	NO	NO
BANK_DESC	Official banking institution name.	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
CALCULATED_AMOUNT_NO_TAX		NUMBER				NO
CHART_OF_ACCOUNTS	Represents a systematic classification of accounts. Identifies a separate and distinct entity-accounting relationship within a multi-chart environment.	VARCHAR2(1)	FTCRACTG	COAS_CODE	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC	NO	NO
CURRENT_DATE	SYSDATE.	DATE	FUNCTION	SYSDATE	NO	NO
DISTRIBUTION_PERCENT	Percentage of the transaction total amount assigned to this accounting distribution.	NUMBER	FTCRACTG	PERCENT_OF_TOTAL	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EXPENSE_ITEM_KEY	Unique internal identification number of the expense item record.	NUMBER	FTCRACTG	FTPREXPS_ID	NO	NO
FINANCE_SECURITY_ID	Oracle user ID linked to the expense owner PIDM when it is available. Used for fund organization security checking in the event a finance profile exists for the expense owner.	VARCHAR2(30)	FTCRACTG	ORACLE_ID	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	FTCRACTG	FUND_CODE	NO	NO
FUNDING_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FTCRACTG	ACTIVITY_DATE	NO	NO
FUNDING_CREATE_DATE	Date and time when the new expense detail record was created.	DATE	FTCRACTG	CREATE_DATE	NO	NO
FUNDING_CREATE_SOURCE	Source system that created the data.	VARCHAR2(30)	FTCRACTG	CREATE_SOURCE	NO	NO
FUNDING_CREATE_USER	Banner ID of the person who created this new record.	VARCHAR2(30)	FTCRACTG	CREATE_USER	NO	NO
FUNDING_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	FTCRACTG	DATA_ORIGIN	NO	NO
FUNDING_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTCRACTG	USER_ID	NO	NO
LOCATION	Identification accounting code of a physical location, used in fixed assets to define the location a fixed asset has been assigned to.	VARCHAR2(6)	FTCRACTG	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 designating a department within the institution.	VARCHAR2(6)	FTCRACTG	ORGN_CODE	NO	NO
PAY_CURRENCY_AMOUNT		NUMBER				NO
PAY_CURRENCY_AMOUNT_NO_TAX		NUMBER				NO
PORTFOLIO_KEY	Unique internal identification number of the portfolio record.	NUMBER	FTCRACTG	FTPBPORT_ID	NO	NO
PROFILE_KEY	Unique internal identification number of the profile record.	NUMBER	FTCRACTG	FTOBPROF_ID	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)	FTCRACTG	PROG_CODE	NO	NO
PROJECT	Identification code for a project defined in cost accounting.	VARCHAR2(8)	FTCRACTG	PROJ_CODE	NO	NO
PROJECT_DESC	Project description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC	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: