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 Name Business Definition Database Data Type Source Name Source Column
ACTIVITY_DEFAULT Activity Default Default activity primarily associated with this department. VARCHAR2(63)

FTVORGN

FTVORGN_ACTV_CODE_DEF

ACTIVITY_DEFAULT_DESC Activity Default Description Activity default description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

ADMINISTRATIVE_GROUP 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 Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FTVORGN

FTVORGN_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Status of the chart of accounts. VARCHAR2(63)

FTVCOAS

FTVCOAS_STATUS_IND

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

SPRADDR

SPRADDR_CITY

COUNTY County County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

DATA_ENTRY_PERMITTED 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

DATA_ENTRY_PERMITTED_DESC Data Entry Permitted Description Data entry permitted description. VARCHAR2(255)

FUNCTION

CASE WHEN FTVORGN_DATA_ENTRY_IND

EFFECTIVE_DATE Effective Date Date this code is in effect. DATE

FTVORGN

FTVORGN_EFF_DATE

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

FINANCIAL_MANAGER_NAME 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

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

FTVORGN

FTVORGN_FMGR_CODE_PIDM

FISCAL_PERIOD 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

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

FUNCTION

FOFYCNV

FMGR_FIRST_NAME Financial Manager First Name Financial manager's first or given name. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

FMGR_LAST_NAME Financial Manager Last Name Fund manager's last name or surname. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

FMGR_MIDDLE_NAME Financial Manager Middle Name Financial manager's middle name. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FTVORGN

FTVORGN_FUND_CODE_DEF

FUND_DEFAULT_DESC Fund Default Description Fund default description. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

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

FTVORGN

FTVORGN_LOCN_CODE_DEF

LOCATION_DEFAULT_DESC Location Default Description Location default description. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

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

NA

NA

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

NA

NA

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

SPRADDR

SPRADDR_NATN_CODE

NATION_DESC Nation Description Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

NEXT_CHANGE_DATE 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

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

FTVORGN

FTVORGN_ORGN_CODE

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

FTVORGN

FTVORGN_TITLE

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

CALCULATION

LEVEL

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_POOL 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)

ORGANIZATION_POOL_DESC Organization Pool Description 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

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

FTVORGN

FTVORGN_STATUS_IND

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FTVFSPD

FTVFSPD_PRD_END_DATE

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

SPRADDR

SPRADDR_ZIP

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

NA

NA

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

FTVPROG

FTVORGN_PROG_CODE_DEF

PROGRAM_DEFAULT_DESC Program Default Description Program default description. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

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

SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State Province Description State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

STREET_LINE1 Street Line 1 First line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2 Street Line 2 Second line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3 Street Line 3 Third line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4 Street Line 4 Fourth line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE4

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

FTVORGN

FTVORGN_TERM_DATE



Ver: 9.2