Penn Computing

University of Pennsylvania
Penn Computing << go backback
PARENT_ORG_CODES Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

PARENT_ORG_CODES Table

Explanation
Lists organizations (subdivisions of the University created for management purposes) with their parent organizations (that is, their roll-up groups). A given organization may have more than one parent. For example, organization 1319 (SEAS COPY CTR) has parents DEAS (SEAS Office of the Dean Parent) and 13XX (School Of Engineering and Applied Sciences Parent).

Common Uses
Generating reports using organization roll-up groups, showing amounts summarized at different levels.

Primary Key Indexed Data Elements Related Tables

None


CHILD_ORG

PARENT_ORG

PARENT_ORG_DESC







BALANCES

FUND_CODES

GL_FULL_OLD_TO_NEW

GL_PART_OLD_TO_NEW

ORG_CODES

ORG_OLD_TO_NEW

SUMMARY_BALANCES

Cautions

  • The table is only as good as its data. Spurious parent organizations may not have been removed from the table, and some parents may have yet to be added to the table.
  • To create a hierarchy, use a self-join. Connect by prior may work but is not recommended.
  • Data is kept only for organization codes in use. If a BEN Financials roll-up group range includes an organization code that does not exist, the table will not have a record for that organization.
  • There may be records for ORGs that do not play a role in the organization hierarchy. These ORGs exist in the Ledger for particular operational purposes, and may not have parents.
  • Data is kept only for the latest mapping of the organizations and their parents. Information on the parent of an organization is available only if the organization's expiration date (in the ORG_CODES table) has not passed.
PARENT_ORG_CODES Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania