Penn Computing

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

PARENT_ORG_CODES Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data Element Definition
CHILD_ORG

Indexed - yes
Format - char (4)
May be null? no

The 4-character code for the ORGANIZATION associated with the PARENT_ORG (or rollup group). Amounts for the CHILD_ORG will be included when data is summarized by the PARENT_ORG.

A given PARENT_ORG may be associated with more than one CHILD_ORG, and a given CHILD_ORG may have more than one parent. For example, ORGANIZATION 1319 (SEAS COPY CTR) has parents DEAS (SEAS OFFICE OF THE DEAN) and 13XX (School of Engineering and Applied Sciences Parent) An ORGANIZATION is a subdivision of the University created for management purposes.


Values:

Refer to the ORG_CODES Table for values.

PARENT_ORG_DESC

Indexed - yes
Format - varchar2 (240)
May be null? yes

The description that corresponds to the PARENT_ORG, the rollup group for a subdivision of the University created for management purposes. 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."

Examples: SEAS OFFICE OF THE DEAN (DEAS); School of Engineering and Applied Science Parent (13XX)


Values:

List of values not available.

PARENT_ORG

Indexed - yes
Format - char (4)
May be null? no

The 4-character code for the ORGANIZATON that serves as the parent (or rollup group) for one or more other ORGANIZATONS, allowing amounts to be summarized at the parent level. 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.

A given ORGANIZATION may have more than one parent. For example, ORGANIZATION 1319 (SEAS COPY CTR) has parents DEAS (SEAS OFFICE OF THE DEAN) and 13XX (School of Engineering and Applied Sciences Parent). An ORGANIZATION is a subdivision of the University created for management purposes.


Values:

Refer to the ORG_CODES table for values.

 
PARENT_ORG_CODES Table   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