Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Finance Reporting View Reports

Banner Operational Data Store
Reporting View Target: ORGANIZATION_HIERARCHY

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

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

FTVORGN

FTVORGN_ACTV_CODE_DEF

ACTIVITY_DESC Activity description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

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)

FTVORGN

FTVORGN_COAS_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FTVCOAS

FTVCOAS_STATUS_IND

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

SPRADDR

SPRADDR_CITY

COUNTY County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County name for the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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. VARCHAR2(255)

FUNCTION

CASE WHEN FTVORGN_DATA_ENTRY_IND

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

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 System generated, unique internal identification number assigned to the financial manager associated with this organization. NUMBER

FTVORGN

FTVORGN_FMGR_CODE_PIDM

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

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

FTVORGN

FTVORGN_FUND_CODE_DEF

FUND_DESC Fund description. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

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

FTVORGN

FTVORGN_LOCN_CODE_DEF

LOCATION_DESC Location description. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

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 when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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

SPRADDR

SPRADDR_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

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

FTVORGN

FTVORGN_ORGN_CODE

ORGANIZATION_DESC Organization code description or title. VARCHAR2(255)

FTVORGN

FTVORGN_TITLE

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL Level of the organization within the organization hierarchy. NUMBER

CALCULATION

LEVEL

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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. 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 Current status of the associated organization. VARCHAR2(63)

FTVORGN

FTVORGN_STATUS_IND

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

SPRADDR

SPRADDR_ZIP

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

NA

NA

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

FTVPROG

FTVORGN_PROG_CODE_DEF

PROGRAM_DESC Program description. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

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

SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State/province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE4

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

FTVORGN

FTVORGN_TERM_DATE



Ver: 9.1