Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

Banner Operational Data Store
Reporting View Target: ORGANIZATION_HIERARCHY_FISCAL

Description Contains a list of all organization codes with associated hierarchy levels, organization pool, and financial manager. Used to support roll up reporting by fiscal year and fiscal period.
Key & Frequency One row per chart of accounts per organization code per fiscal year per fiscal period.
Recommended Search Columns CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, ORGANIZATION_CODE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACTIVITY_DEFAULT Default activity primarily associated with this department. VARCHAR2(63)

FTVORGN

FTVORGN_ACTV_CODE_DEF

NO

NO
ACTIVITY_DEFAULT_DESC Activity default description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

NO

NO
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVORGN

FTVORGN_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_STATUS Status of the chart of accounts. VARCHAR2(63)

FTVCOAS

FTVCOAS_STATUS_IND

NO

NO
CITY Address city, town or municipality. VARCHAR2(63)

SPRADDR

SPRADDR_CITY

NO

NO
COUNTY County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

NO

NO
COUNTY_DESC County name for the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
DATA_ENTRY_PERMITTED Determines if the code is used for data entry (Y)es data entry permitted, or used for reporting (N)o data entry not permitted. VARCHAR2(63)

FTVORGN

FTVORGN_DATA_ENTRY_IND

NO

NO
DATA_ENTRY_PERMITTED_DESC Data entry permitted description. VARCHAR2(255)

FUNCTION

CASE WHEN FTVORGN_DATA_ENTRY_IND

NO

NO
EFFECTIVE_DATE Date this code is in effect. DATE

FTVORGN

FTVORGN_EFF_DATE

NO

NO
FINANCIAL_MANAGER_ID System generated or manually assigned ID that uniquely identifies the financial manager. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
FINANCIAL_MANAGER_NAME Combination of the person's last name, first name, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
FINANCIAL_MANAGER_UID System generated, unique internal identification number assigned to the financial manager associated with this organization. NUMBER

FTVORGN

FTVORGN_FMGR_CODE_PIDM

NO

NO
FISCAL_PERIOD Unique identifier for a period within a fiscal year. Generally, a fiscal period would be a value between 00 and 14. VARCHAR2(63)

FTVFSPD

FTVFSPD_FSPD_CODE

NO

NO
FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(63)

FUNCTION

FOFYCNV

NO

NO
FMGR_FIRST_NAME Financial manager's first or given name. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
FMGR_LAST_NAME Fund manager's last name or surname. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
FMGR_MIDDLE_NAME Financial manager's middle name. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
FUND_DEFAULT Default fiscal entity primarily assocated with this department. VARCHAR2(63)

FTVORGN

FTVORGN_FUND_CODE_DEF

NO

NO
FUND_DEFAULT_DESC Fund default description. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

NO

NO
LOCATION_DEFAULT Default physical location primarily associated with this department. VARCHAR2(63)

FTVORGN

FTVORGN_LOCN_CODE_DEF

NO

NO
LOCATION_DEFAULT_DESC Location default description. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

NO

NO
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
NATION Nation/country code associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_NATN_CODE

NO

NO
NATION_DESC Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

NO

NO
NEXT_CHANGE_DATE Date this information changes. For example, if the record included a termination date, the next change date would reflect the date that the termination date was entered. Requires a future change record. DATE

FTVORGN

FTVORGN_NCHG_DATE

NO

NO
ORGANIZATION_CODE Identification accounting code used for the department. VARCHAR2(63)

FTVORGN

FTVORGN_ORGN_CODE

NO

NO
ORGANIZATION_DESC Organization code description or title. VARCHAR2(255)

FTVORGN

FTVORGN_TITLE

NO

NO
ORGANIZATION_DESC_1 Description or title level 1 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_DESC_2 Description or title level 2 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_DESC_3 Description or title level 3 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_DESC_4 Description or title level 4 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_DESC_5 Description or title level 5 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_DESC_6 Description or title level 6 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_DESC_7 Description or title level 7 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_DESC_8 Description or title level 8 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_LEVEL Level of the organization within the organization hierarchy. NUMBER

CALCULATION

LEVEL

NO

NO
ORGANIZATION_LEVEL_1 Level 1 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_LEVEL_2 Level 2 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_LEVEL_3 Level 3 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_LEVEL_4 Level 4 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_LEVEL_5 Level 5 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_LEVEL_6 Level 6 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_LEVEL_7 Level 7 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_LEVEL_8 Level 8 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_POOL Organization used for budgeting purposes. If the organization pool does not exist, it is replaced with organization for available balance checking. VARCHAR2(63)

CALCULATION

NVL(FTVORGN_ORGN_CODE_NSF,FTVORGN_ORGN_CODE)

NO

NO
ORGANIZATION_POOL_DESC Organization pool description. If the organization pool is not found, then its description is replaced with organization description for available balance checking. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
ORGANIZATION_STATUS Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

NO

NO
ORGANIZATION_STATUS_1 Status of level 1 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_STATUS_2 Status of level 2 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_STATUS_3 Status of level 3 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_STATUS_4 Status of level 4 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_STATUS_5 Status of level 5 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_STATUS_6 Status of level 6 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_STATUS_7 Status of level 7 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGANIZATION_STATUS_8 Status of level 8 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
PERIOD_END_DATE Date used to determine the last day of an accounting period. DATE

FTVFSPD

FTVFSPD_PRD_END_DATE

NO

NO
POSTAL_CODE Postal code associated with the financial manager address. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

NO

NO
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
PROGRAM_DEFAULT Default program classification primarily associated with this department. VARCHAR2(63)

FTVPROG

FTVORGN_PROG_CODE_DEF

NO

NO
PROGRAM_DEFAULT_DESC Program default description. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

NO

NO
STATE_PROVINCE State or province associated with this address. VARCHAR2(63)

SPRADDR

SPRADDR_STAT_CODE

NO

NO
STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
STREET_LINE1 First line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

NO

NO
STREET_LINE2 Second line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE2

NO

NO
STREET_LINE3 Third line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE3

NO

NO
STREET_LINE4 Fourth line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE4

NO

NO
TERMINATION_DATE Date when this organization is no longer in effect. DATE

FTVORGN

FTVORGN_TERM_DATE

NO

NO


Ver: 9.2