PARENT_PROGRAM_CODES Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

PARENT_PROGRAM_CODES Table

Explanation
Lists program codes that identify activities or work processes commonly defined across the University, with their parent programs (that is, their roll-up groups). A given program may have more that one parent. For example, program 1675 (ETHICS) has parents 16XX (Misc Other Business Programs, Instruction) and 1XXX (Instruction Programs).

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

None

CHILD_PROGRAM

PARENT_PROGRAM

PARENT_PROGRAM_DESC

BALANCES

FUND_CODES

GL_FULL_OLD_TO_NEW

GL_PART_OLD_TO_NEW

ORG_OLD_TO_NEW

PROGRAM_CODES

SUMMARY_BALANCES

Cautions

• The table is only as good as its data. Spurious parent programs 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 programs in use. If a BEN Financials roll-up group range includes a program that does not exist, the table will not have a record for that program.

PARENT_PROGRAM_CODES Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home