GL_FULL_OLD_TO_NEW Table
Explanation
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.
Common Uses
Finding the BEN Financials equivalent for a 9-digit legacy account number, or
vice versa.
| Primary Key |
Indexed Data Elements |
Related Tables |
None
|
CTR_REF
FUND
ID
LEGACY_ACCOUNT
NAC
OBJECT
ORG
PROGRAM
|
BALANCES
CENTER_REF_CODES
CNAC_CODES
FUND_CODES
OBJECT_CODES
ORG_CODES
ORG_OLD_TO_NEW
PARENT_CNAC_CODES
PARENT_FUND_CODES
PARENT_OBJECT_CODES
PARENT_ORG_CODES
PARENT_PROGRAM_CODES
PROGRAM_CODES
SUMMARY_BALANCES
|
Cautions
- 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
was updated.
- 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 da-staff@isc.upenn.edu
|
