RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Finance Reporting View Reports

SGHE 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
ADMINISTRATIVE_GROUP Organization-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(1)

FTVORGN

FTVORGN_COAS_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

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

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(94)

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(15)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

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

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

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 Retrieves description or title level 1 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_LEVEL Level of the organization within the organization hierarchy. NUMBER

CALCULATION

LEVEL

ORGANIZATION_LEVEL_1 Retrieves level 1 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_LEVEL_2 Retrieves level 2 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_LEVEL_3 Retrieves level 3 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_LEVEL_4 Retrieves level 4 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_LEVEL_5 Retrieves level 5 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_LEVEL_6 Retrieves level 6 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_LEVEL_7 Retrieves level 7 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_LEVEL_8 Retrieves level 8 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_POOL Extracts organization pool and if not found, replaces with organization for available balance checking. VARCHAR2(63)

CALCULATION

NVL(FTVORGN_ORGN_CODE_NSF,FTVORGN_ORGN_CODE)

ORGANIZATION_POOL_DESC Obtains organization pool description and if pool not found, replaces it 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 Retrieves status of level 1 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

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

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(30)

SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(30)

SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(30)

SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA



Ver: 3.1