Lists legacy account numbers in the 9-digit format used in GENLED (the general
ledger system used at Penn before July 1, 1996) and their counterparts, the 26-
position Accounting Flexfields used in the present General Ledger accounting structure
(in use at Penn since July 1, 1996). Legacy account numbers in the 9-digit format
are still used in some systems.
Finding the BEN Financials equivalent for a 9-digit legacy account number, or
||Indexed Data Elements
- Not all the 9-digit legacy accounts listed in GL_FULL_OLD_TO_NEW were used
before July 1, 1996. Some were generated by an Oracle application so 26-position
Accounting Flexfields that were created after July 1, 1996, could be represented
in systems that still use the 9-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 26-position Accounting Flexfields listed in GL_FULL_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 9-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 firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania