Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACCOUNT
|
Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.
|
VARCHAR2(6)
|
FTCRACTG
|
ACCT_CODE
|
ACCOUNTING_KEY
|
Unique internal identification number of the accounting record.
|
NUMBER
|
FTCRACTG
|
ID
|
ACCOUNT_INDEX
|
Account Index used to default an accounting distribution.
|
VARCHAR2(6)
|
FTCRACTG
|
ACCI_CODE
|
ACCOUNT_INDEX_DESC
|
Account index description.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
ACTIVITY
|
Code used to identify accounting data by activity.
|
VARCHAR2(6)
|
FTCRACTG
|
ACTV_CODE
|
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
|
BANK
|
Official banking institution.
|
VARCHAR2(2)
|
FTCRACTG
|
BANK_CODE
|
BANK_DESC
|
Official banking institution name.
|
VARCHAR2(35)
|
GXVBANK
|
GXVBANK_ACCT_NAME
|
BANK_UID
|
Internal identification number of the bank used at the time the transaction occurred.
|
NUMBER
|
GXVBANK
|
GXVBANK_BANK_CODE_PIDM
|
CALCULATED_AMOUNT_NO_TAX
|
|
NUMBER
|
|
|
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
|
CHART_OF_ACCOUNTS_DESC
|
Chart of accounts description.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
CURRENT_DATE
|
SYSDATE.
|
DATE
|
FUNCTION
|
SYSDATE
|
DISTRIBUTION_PERCENT
|
Percentage of the transaction total amount assigned to this accounting distribution.
|
NUMBER
|
FTCRACTG
|
PERCENT_OF_TOTAL
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
EXPENSE_ITEM_KEY
|
Unique internal identification number of the expense item record.
|
NUMBER
|
FTCRACTG
|
FTPREXPS_ID
|
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
|
FUND
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(6)
|
FTCRACTG
|
FUND_CODE
|
FUNDING_ACTIVITY_DATE
|
Date information for this record in the table was entered or last updated.
|
DATE
|
FTCRACTG
|
ACTIVITY_DATE
|
FUNDING_CREATE_DATE
|
Date and time when the new expense detail record was created.
|
DATE
|
FTCRACTG
|
CREATE_DATE
|
FUNDING_CREATE_SOURCE
|
Source system that created the data.
|
VARCHAR2(30)
|
FTCRACTG
|
CREATE_SOURCE
|
FUNDING_CREATE_USER
|
Banner ID of the person who created this new record.
|
VARCHAR2(30)
|
FTCRACTG
|
CREATE_USER
|
FUNDING_DATA_ORIGIN
|
Source system that created or updated the data.
|
VARCHAR2(30)
|
FTCRACTG
|
DATA_ORIGIN
|
FUNDING_USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
FTCRACTG
|
USER_ID
|
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
|
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
|
ORGANIZATION_CODE
|
Identification accounting code designating a department within the institution.
|
VARCHAR2(6)
|
FTCRACTG
|
ORGN_CODE
|
PAY_CURRENCY_AMOUNT
|
|
NUMBER
|
|
|
PAY_CURRENCY_AMOUNT_NO_TAX
|
|
NUMBER
|
|
|
PORTFOLIO_KEY
|
Unique internal identification number of the portfolio record.
|
NUMBER
|
FTCRACTG
|
FTPBPORT_ID
|
PROFILE_KEY
|
Unique internal identification number of the profile record.
|
NUMBER
|
FTCRACTG
|
FTOBPROF_ID
|
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
|
PROJECT
|
Identification code for a project defined in cost accounting.
|
VARCHAR2(8)
|
FTCRACTG
|
PROJ_CODE
|
PROJECT_DESC
|
Project description.
|
VARCHAR2(35)
|
FUNCTION
|
FOKODSF.F_GET_FINANCE_DESC
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|