Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FTVACCT Finance
SGHE Banner Operational Data Store Composite View Source: FTVACCT - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
FTVACCT_ACCT_CLASS_CODE FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY

AF_GRANT_LEDGER

AF_ACCOUNT_HIERARCHY_FISCAL

ACCOUNT_CLASS

ACCOUNT_CLASS

ACCOUNT_CLASS

NA
FTVACCT_ACCT_CODE FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY

ACCOUNT

ACCOUNT

NA
FTVACCT_ATYP_CODE FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY

ACCOUNT_TYPE

ACCOUNT_TYPE

NA
FTVACCT_COAS_CODE FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY

CHART_OF_ACCOUNTS

CHART_OF_ACCOUNTS

NA
FTVACCT_DATA_ENTRY_IND FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY_FISCAL

AF_VALIDATION

AF_ACCOUNT_HIERARCHY

DATA_ENTRY_PERMITTED

DATA_ENTRY_IND

DATA_ENTRY_PERMITTED

NA
FTVACCT_EFF_DATE FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY_FISCAL

EFFECTIVE_DATE

 
FTVACCT_NCHG_DATE FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY_FISCAL

NEXT_CHANGE_DATE

NA
FTVACCT_NORMAL_BAL FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY

NORMAL_BALANCE

NORMAL_BALANCE

NA
FTVACCT_STATUS_IND FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY_FISCAL

ACCOUNT_STATUS

ACCOUNT_STATUS

NA
FTVACCT_TERM_DATE FTMACCT COMPOSITE VIEW

AF_ACCOUNT_HIERARCHY_FISCAL

AF_ACCOUNT_HIERARCHY

TERMINATION_DATE

TERMINATION_DATE

NA
FTVACCT_TITLE FTMACCT COMPOSITE VIEW

AF_ACCOUNT_ATTRIBUTES_ODS

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AN_PERSONNEL_ACTION_LABOR_DIST

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY

AF_ACCOUNT_HIERARCHY_FISCAL

AP_PAYROLL_LABOR_DIST_OVERRIDE

ACCOUNT_DESC

ACCOUNT_DESC

CTRL_ACTUAL_ACTIVITY_DESC

CTRL_ADOPTED_BUDGET_PY_DESC

CTRL_ENCUMBRANCE_DESC

CTRL_ACTUAL_ACTIVITY_PY_DESC

CTRL_BUDGET_RESERVE_PY_DESC

CTRL_TEMPORARY_BUDGET_DESC

CTRL_ENCUMBRANCE_PY_DESC

CTRL_TEMPORARY_BUDGET_PY_DESC

CTRL_BUDGET_RESERVE_DESC

ACCOUNT_DESC

CTRL_BUDGET_ADJUSTMENT_PY_DESC

CTRL_ADOPTED_BUDGET_DESC

CTRL_BUDGET_ADJUSTMENT_DESC

ACCOUNT_DESC

POSITION_ACCOUNT_DESC

NA


Ver: