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

GL_PART_OLD_TO_NEW Table

Explanation
Lists legacy account numbers in the 6-digit format used in SUBLED (the subledger system used at Penn before July 1, 1996) and their counterparts, the 22-position Accounting Flexfields used in the present General Ledger accounting structure (in use at Penn since July 1, 1996). Legacy accounts in the 6-digit format are still used for grants and contracts in some systems.

Common Uses
Finding the BEN Financials equivalent for a 6-digit legacy account number, or vice versa.

None

CTR_REF

FUND

ID 

LEGACY_FUND

LEGACY_LEDGER_CODE

CNAC

ORG

PROGRAM

BALANCES

CENTER_REF_CODES

CNAC_CODES

FUND_CODES

ORG_CODES

ORG_OLD_TO_NEW

PARENT_CNAC_CODES

PARENT_FUND_CODES

PARENT_ORG_CODES

PARENT_PROGRAM_CODES

PROGRAM_CODES

SUMMARY_BALANCES

Cautions

• Note that Fund is the 6-character code identifying the fund in the present General Ledger accounting structure (in use at Penn since July 1, 1996). In the system used before then, the LEGACY_LEDGER_CODE is the 1-character code identifying the fund group for the account, and the LEGACY_FUND is the 5-character code indicating the fund.
• Not all the 6-digit legacy accounts listed in GL_PART_OLD_TO_NEW were used before July 1, 1996. Some were generated by an Oracle application so 22-position Accounting Flexfields that were created after July 1, 1996, could be represented in systems that still use the 6-digit format for account numbers. To distinguish the legacy accounts used in the legacy financial system (before July 1, 1996) from those that were not, use the GENERATED_FLAG.
• Not all the 22-position Accounting Flexfields listed in GL_PART_OLD_TO_NEW are currently active in BEN Financials. Use the ENABLED_FLAG in a record selection condition to retrieve only the records with Accounting Flexfields currently active in BEN Financials. The ENABLED_DATE indicates the last time the ENABLED_FLAG was updated.
• The 6-digit legacy account number may map to different Accounting Flexfields 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.
• More than one legacy account number may map to a given Accounting Flexfield, but a given Accounting Flexfield maps back to only one legacy account. When querying to determine the legacy account equivalents for Accounting Flexfields, be sure to check the NEWTOOLD_FLAG.

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