PARENT_OBJECT_CODES Table
Explanation
Lists object codes that identify assets, liabilities, revenues, or expenses,
with their parent object codes (that is, their roll-up groups). A given object
may have more than one parent. For example, some of the parents of object 5304
(INT TRAINING) are C070 (SERVICES), C074 (NET CURRENT EXPENSE), and 5XXX (OBJECT
VALUES 5000-5999).
Common Uses
Generating reports using object roll-up groups that show amounts summarized
at different levels.
| Primary Key |
Indexed Data Elements |
Related Tables |
None
|
CHILD_OBJECT
PARENT_OBJECT
PARENT_OBJECT_DESC
|
BALANCES
FUND_CODES
GL_FULL_OLD_TO_NEW
GL_REPORT_TEMPLATE
GL_SUBCD_OLD_TO_NEW
OBJECT_CODES
RCM_OBJECT_TREE
SUMMARY_BALANCES
|
Cautions
- Parent object codes exist for many reasons, including (but not exclusively)
the support of custom processes and operational reporting templates. Spurious
parent objects 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 object codes in use. If a BEN Financials roll-up group's
range includes an object that does not exist, the table will not have a record
on that object.
Questions about this page? Email us at da-staff@isc.upenn.edu
|
