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

GL_SUBCD_OLD_TO_NEW Table

Explanation
Lists legacy subcodes in the 3-digit format (used in the financial system used at Penn before July 1, 1996) and their counterparts, the 4-position OBJECT codes (used in the present General Ledger accounting structure in use at Penn since July 1, 1996). Subcodes are still used in some systems.

Common Uses
Finding the BEN Financials equivalent for a legacy subcode, or vice versa.

None

ID

OBJECT

SUBCODE

BALANCES 

FUND_CODES

OBJECT_CODES

PARENT_OBJECT_CODES

SUMMARY_BALANCES

• Not all the OBJECTS listed in GL_SUBCD_OLD_TO_NEW are currently active in BEN Financials. Use the ENABLED_FLAG in a record selection condition to retrieve only the records with Objects currently active in BEN Financials. The ENABLED_DATE indicates the last time the ENABLED_FLAG was updated.
• The SUBCODE may map to different Objects at different times. Check START_DATE_ACTIVE and END_DATE_ACTIVE to ensure that the query returns records that are valid for the desired time frame.

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