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.
Finding the BEN Financials equivalent for a 6-digit legacy account number, or
||Indexed Data Elements
- 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
- 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.
Questions about this page? Email us at email@example.com
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania