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(63)
|
FTVACCI
|
FTVACCI_ACCT_CODE
|
ACCOUNT_DESC
|
Account code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
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(63)
|
FTVACCI
|
FTVACCI_ACCI_CODE
|
ACCOUNT_INDEX_DESC
|
Account index description.
|
VARCHAR2(255)
|
FTVACCI
|
FTVACCI_TITLE
|
ACCOUNT_INDEX_STATUS
|
Current status of the associated account index.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_STATUS_IND
|
ACCOUNT_OVERRIDE
|
Specifies whether the user may choose the defaulted account index or override it at data entry.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_ACCT_OVERRIDE
|
ACCOUNT_STATUS
|
Current status of the associated account.
|
VARCHAR2(63)
|
FUNCTION
|
F_GET_FINANCE_STATUS
|
ACTIVITY
|
Code used to identify accounting data by activity.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_ACTV_CODE
|
ACTIVITY_DESC
|
Activity code title or description.
|
VARCHAR2(255)
|
FTVACTV
|
FTVACTV_TITLE
|
ACTIVITY_OVERRIDE
|
Indicator to allow the user to choose the default activity from the account index or data enter another value.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_ACTV_OVERRIDE
|
ACTIVITY_STATUS
|
Extracted current status of the associated activity.
|
VARCHAR2(63)
|
FTVACTV
|
FTVACTV_STATUS_IND
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
CHART_OF_ACCOUNTS
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_COAS_CODE
|
CHART_OF_ACCOUNTS_DESC
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FTVCOAS
|
FTVCOAS_TITLE
|
CHART_OF_ACCOUNTS_STATUS
|
Extracted current status of the associated chart of accounts.
|
VARCHAR2(63)
|
FTVCOAS
|
FTVCOAS_STATUS_IND
|
EFFECTIVE_DATE
|
Record effective date.
|
DATE
|
FTVACCI
|
FTVACCI_EFF_DATE
|
FUND
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_FUND_CODE
|
FUND_DESC
|
Description or title of the associated fund.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
FUND_OVERRIDE
|
Allows users to choose the defaulted account index or another value.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_FUND_OVERRIDE
|
FUND_STATUS
|
Extracted current status of the associated fund.
|
VARCHAR2(63)
|
FUNCTION
|
F_GET_FINANCE_STATUS
|
LOCATION
|
Accounting identification code of the physical location to which the grant has been assigned.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_LOCN_CODE
|
LOCATION_DESC
|
Extracted description or title of the associated location.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
LOCATION_OVERRIDE
|
Allows users to choose the defaulted account index or another value.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_LOCN_OVERRIDE
|
LOCATION_STATUS
|
Extracted current status of the associated location.
|
VARCHAR2(63)
|
FUNCTION
|
F_GET_FINANCE_STATUS
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Institution description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NEXT_CHANGE_DATE
|
The date this record was changed, reflecting the effective date of the next record.
|
DATE
|
FTVACCI
|
FTVACCI_NCHG_DATE
|
ORGANIZATION_CODE
|
Identification accounting code used for the department.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_ORGN_CODE
|
ORGANIZATION_DESC
|
Extracted description or title associated with the organization code.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
ORGANIZATION_OVERRIDE
|
Allows users to choose the defaulted account index or another value.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_ORGN_OVERRIDE
|
ORGANIZATION_STATUS
|
Extracted current status of the associated organization.
|
VARCHAR2(63)
|
FUNCTION
|
F_GET_FINANCE_STATUS
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
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(63)
|
FTVACCI
|
FTVACCI_PROG_CODE
|
PROGRAM_DESC
|
Extracted description or title of the associated program.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
PROGRAM_OVERRIDE
|
Allows users to choose the defaulted account index or another value.
|
VARCHAR2(63)
|
FTVACCI
|
FTVACCI_PROG_OVERRIDE
|
PROGRAM_STATUS
|
Extracted current status of the associated program.
|
VARCHAR2(63)
|
FUNCTION
|
F_GET_FINANCE_STATUS
|