• BUDGETARY_CONTROL
• C12
• C13
• C14
• CODE_COMBINATION_ID
• CREATED_BY
• CREATION_DATE
• CTR_REF
• ENABLED_DATE
• ENABLED_FLAG
• END_DATE_ACTIVE
• ENDOW_LINK

• FUND
• GENERATED_FLAG
• ID
• LAST_UPDATE_DATE
• LAST_UPDATED_BY
• LEGACY_ACCOUNT
• NAC
• NEWTOOLD_FLAG
• OBJECT
• ORG
• PROGRAM
• START_DATE_ACTIVE

Indexed - no
Format - char (1)
May be null? no

The budgetary control character that represents the level at which funds availability checking occurs.

BUDGETARY_CONTROL is the third segment of the 26-position Accounting Flexfield in the present General Ledger accounting structure (in use at Penn since July 1, 1996).

Examples: 1 (CNAC/ORG/FUND Year-to-Date); 4 (CNAC/ORG/FUND/CREF Project-to-Date).

Values:

0     Project-to-date for capital projects

1     CNAC/ORG/FUND Year-to-date

2     CNAC/ORG/FUND/CREF Year-to-date

4     CNAC/ORG/FUND/CREF Project-to-date

A     Funds check parent of 1

B     Funds check parent of 2

D     Funds check parent of 4

T     All Funds checks

Indexed - no
Format - char (1)
May be null? no

Indicates whether the LEGACY_ACCOUNT was mapped to the 26-position Accounting Flexfield during the fiscal year 1996 12th month conversion from GENLED (the general ledger system used at Penn before July 1, 1996) to the present General Ledger accounting structure (in use at Penn since July 1, 1996).

The 26-position Accounting Flexfield is the combination of NAC, ORG, BUDGETARY_CONTROL, OBJECT, PROGRAM, and CTR_REF.

Examples: Y (fiscal year 1996 12th month records for this LEGACY_ACCOUNT have this Accounting Flexfield in BEN Financials); N (fiscal year 1996 12th month records for this LEGACY_ACCOUNT do not have the Accounting Flexfield in BEN Financials)

Values:

Y     Fiscal year 1996 12th month records for this 

      LEGACY_ACCOUNT have this Accounting Flexfield in 

      BEN Financials.

N     Fiscal year 1996 12th month records for this 

      LEGACY_ACCOUNT do not have the Accounting Flexfield

      in BEN Financials.

Indexed - no
Format - char (1)
May be null? no

Indicates whether the LEGACY_ACCOUNT was mapped to the 26- position Accounting Flexfield during the fiscal year 1996 13th month conversion from GENLED (the general ledger system used at Penn before July 1, 1996) to the present General Ledger accounting structure (in use at Penn since July 1, 1996).

The 26- position Accounting Flexfield is the combination of NAC, ORG, BUDGETARY_CONTROL, OBJECT, PROGRAM, and CTR_REF.

Examples: Y (fiscal year 1996 13th month records for this LEGACY_ACCOUNT have this Accounting Flexfield in BEN Financials); N (fiscal year 1996 13th month records for this LEGACY_ACCOUNT do not have the Accounting Flexfield in BEN Financials)

Values:

Y     Fiscal year 1996 13th month records for this 

      LEGACY_ACCOUNT have this Accounting Flexfield in 

      BEN Financials.

N     Fiscal year 1996 13th month records for this 

      LEGACY_ACCOUNT do not have the Accounting Flexfield

      in BEN Financials.

Indexed - no
Format - char (1)
May be null? no

Indicates whether the LEGACY_ACCOUNT was mapped to the 26- position Accounting Flexfield during the fiscal year 1996 14th month conversion from GENLED (the general ledger system used at Penn before July 1, 1996) to the present General Ledger accounting structure (in use at Penn since July 1, 1996).

The 26- position Accounting Flexfield is the combination of NAC, ORG, BUDGETARY_CONTROL, OBJECT, PROGRAM, and CTR_REF.

Examples: Y (fiscal year 1996 14th month records for this LEGACY_ACCOUNT have this Accounting Flexfield in BEN Financials); N (fiscal year 1996 14th month records for this LEGACY_ACCOUNT do not have the Accounting Flexfield in BEN Financials)

Values:

Y     Fiscal year 1996 14th month records for this 

      LEGACY_ACCOUNT have this Accounting Flexfield 

      in BEN Financials.

N     Fiscal year 1996 14th month records for this 

      LEGACY_ACCOUNT do not have the Accounting Flexfield

      in BEN Financials.

Indexed - no
Format - number (15,0)
May be null? yes

Values:




List of values not available.

Indexed - no
Format - number (15,0)
May be null? no

The BEN Financials user ID for the user who created this GL_FULL_OLD_TO_NEW record. This is meant for use by Information Sysems and Computing for debugging data integrity problems.

Example: 1046

Values:




List of values not available.

Indexed - no
Format - date (7)
May be null? no

The date this GL_FULL_OLD_TO_NEW record was created.

This information is stored in the Warehouse in date format and is displayed as specified in the International option of the Control Panel in Windows (or in the Date & Time Control Panel on the Macintosh). Usually, this option has been set to MDY format with a slash (/) separator.

Example: 11/6/95

Values:

List of values not available.

Indexed - yes
Format - char (4)
May be null? no

The 4-character center reference code, the seventh and last segment of the 26-position Accounting Flexfield in the present General Ledger accounting structure (in use at Penn since July 1, 1996).

CTR_REF is a unique identifier defined by each school or center. CTR_REF is used to record information important to a school or center but inappropriate for any other segment of the Accounting Flexfield.

Examples: 4045 (Graduate Programs); 4091 (SAS Newsletter)

Values:

List of values not available.

Indexed - no
Format - date (7)
May be null? no

The date the ENABLED_FLAG was last updated.

This information is stored in the Warehouse in date format and is displayed as specified in the International option of the Control Panel in Windows (or in the Date & Time Control Panel on the Macintosh). Usually, this option has been set to MDY format with a slash (/) separator. Example: 11/6/95.

Values:

List of values not available.

Indexed - no
Format - char (1)
May be null? no

Indicates whether the 26-position Accounting Flexfield is currently valid in BEN Financials. The Accounting Flexfield is the combination of NAC, ORG, BUDGETARY_CONTROL, FUND, OBJECT, PROGRAM, and CTR_REF.

Examples: Y (the Accounting Flexfield is currently valid in BEN Financials); N (the Accounting Flexfield is not currently valid in BEN Financials)

Values:

Y     The Accounting Flexfield is currently valid in 

      BEN Financials.

N     The Accounting Flexfield is not currently valid in 

      BEN Financials.

Indexed - no
Format - date (7)
May be null? no

The last date when the LEGACY_ACCOUNT maps to the BEN Financials 26- position Accounting Flexfield (NAC, ORG, BUDGETARY_CONTROL, FUND, OBJECT, PROGRAM, and CTR_REF). The mapping is valid from the START_DATE_ACTIVE through the END_DATE_ACTIVE.

END_DATE_ACTIVE is stored in the Warehouse in date format and is displayed as specified in the International option of the Control Panel in Windows (or in the Date & Time Control Panel on the Macintosh). Usually, the option has been set to MDY format with a slash (/) indicator.

Example: 1/1/47 (January 1, 2047)

Values:

List of values not available.

Indexed - no
Format - char (1)
May be null? no

Indicates whether a relationship exists between LEGACY_ACCOUNT endowment '04' and '06' funds under the GENLED and SUBLED systems (part of the financial system used at Penn before July 1, 1996). When such a relationship exists, '04' records (records in GENLED beginning with '04' followed by characters 3 through 6 in the LEGACY_ACCOUNT) are related to '06' records (records in SUBLED beginning with '06' followed by characters 3 through 6 in the LEGACY_ACCOUNT). The related '06' record includes the spending rule. (Under the financial system in use at Penn since July 1, 1996, the same FUND is used for what were related '04' and '06' funds, though more than one NAC may be used).

Examples: Y ('04' and '06' LEGACY_ACCOUNTs are related); N (LEGACY_ACCOUNTs are not related)

Values:

Y   '04' and '06' LEGACY_ACCOUNTs are related.

N   LEGACY_ACCOUNTs are not related.

Indexed - yes
Format - char (6)
May be null? no

The 6-character code identifying the fund.

This is the fourth segment of the 26-position Accounting Flexfield in the present General Ledger accounting structure (in use at Penn since July 1, 1996).

A fund uniquely identifies a specific set of financial resources that needs tracking or management.

Example: 000000 (General Unrestricted Fund); 010201 (SAS: GEN FUND 1)

Values:

List of values not available.

Indexed - no
Format - char (1)
May be null? yes

Indicates whether the LEGACY_ACCOUNT value was generated by an Oracle application.

Generated LEGACY_ACCOUNTs do not exist in the financial system used at Penn before July 1, 1996.

Examples: Y (generated by an Oracle application); N (not generated by an Oracle application)

Values:

Y     Generated by an Oracle application; does 

      not exist in the financial system used at

      Penn before July 1, 1996.

N     Not generated by an Oracle application; 

      exists in the financial system used at 

      Penn before July 1, 1996.

Indexed - yes
Format - number (15,0)
May be null? no

A sequence numer that uniquely identifies a row in the GL_FULL_OLD_TO_NEW table. For internal use by the GQL application that updates rows in the table.

Example: 6932

Values:

List of values not available.

Indexed - no
Format - date (7)
May be null? no

The date the GL_FULL_OLD_TO_NEW record was last updated.

This information is stored in the Warehouse in date format and is displayed as specified in the International option of the Control Panel in Windows (or in the Date & Time Control Panel on the Macintosh). Usually, this option has been set to MDY format with a slash (/) separator.

Example: 6/30/96

Values:

List of values not available.

Indexed - no
Format - number (15,0)
May be null? no

The BEN Financials user ID for the user who last updatd the GL_FULL_OLD_TO_NEW record. This is meant for use by Information Systems and Computing for debugging data integrity problems.

Example: 1046

Values:

List of values not available.

Indexed - yes
Format - char (9)
May be null? no

The 9-digit account number in the form used under GENLED, the legacy general ledger system that preceded the present General Ledger.

LEGACY_ACCOUNT consists of a one-digit ledger code, followed by a 5-digit fund code and a 3-digit subcode. From START_DATE_ACTIVE through END_DATE_ACTIVE, LEGACY_ACCOUNT's counterpart is the 26-position Accounting Flexfield, which is the combination of NAC, ORG, BUDGETARY_CONTROL, FUND, OBJECT, PROGRAM, and CTR_REF.

Example: 011046125.

Values:

List of values not available.

Indexed - yes
Format - char (3)
May be null? no

The 3-character Center Net Asset Class code. This is the first segment of the 26-digit Accounting Flexfield in the present General Ledger accounting structure (in use at Penn since July 1, 1996). The first two digits of the NAC identify the School or Center. The last position identifies the net asset class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted).

Examples: 880 (Medical Center, Unrestricted); 921 (Human Resources, Temporarily Restricted)

Values:

List of values not available.

Indexed - no
Format - char (1)
May be null? yes

Indicates whether the 26-digit Accounting_Flexfield in the present General Ledger accounting structure (in use at Penn since July 1, 1996) maps back to the LEGACY_ACCOUNT. More than one LEGACY_ACCOUNT may map to a given Accounting Flexfield, but a given Accounting Flexfield maps back to only one LEGACY_ACCOUNT.

The Accounting Flexfield is the combination of NAC, ORG, BUDGETARY_CONTROL, FUND, OBJECT, PROGRAM, and CTR_REF.

Examples: Y (the Accounting Flexfield maps back to the LEGACY_ACCOUNT); N (the Accounting Flexfield does not map back to the LEGACY_ACCOUNT)

Values:

N     The Accounting Flexfield does not map back to the 

      LEGACY_ACCOUNT.

Y     The Accounting Flexfield maps back to the 

      LEGACY_ACCOUNT.

Indexed - yes
Format - char (4)
May be null? no

The 4-character OBJECT code. Identifies the asset, liability, revenue, or expense.

OBJECT is the fifth segment of the 26-position Accounting Flexfield in the present General Ledger accounting structure (in use at Penn since July 1, 1996).

Examples: 5220 (EXTERNAL OFFICE SUPPLIES); 1149 (CASH SUSPENSE)

Values:

List of values not available.

ORG

Indexed - yes
Format - char (4)
May be null? no

The 4-character code for the ORGANIZATION. This is a subdivision of the University created for management purposes.

An ORGANIZATON belongs to only one responsibility center, and its ORGANIZATION code is unique. That is, no two ORGANIZATIONs have the same value for ORG.

ORG is the second segment of the 26-position Accounting Flexfield in the present General Ledger accounting structure (in use at Penn since July 1, 1996).

Examples: 0102 (Wharton Finance); 0705 (Wharton Legal Studies)

Values:

List of values not available.

Indexed - yes
Format - char (4)
May be null? no

The 4-character code for the PROGRAM, an activity or work process commonly defined across the University for tracking a PROGRAM's activity across schools and cnters (or across organizations within a school or center).

PROGRAM is the sixth segment of the 26-position Accounting Flexfield in the present General Ledger accounting structure (in use at Penn since July 1, 1996).

Examples: 7311 (Alumni Relations); 0001 (Discretionary)

Values:

List of values not available.

Indexed - no
Format - date (7)
May be null? no

The first date when the LEGACY_ACCOUNT maps to the 26-position Accounting Flexfield (NAC, ORG, BUDGETARY_CONTROL, FUND, OBJECT, PROGRAM, and CTR_REF). The mapping is valid from the START_DATE_ACTIVE through the END_DATE_ACTIVE.

START_DATE_ACTIVE is stored in the Warehouse in date format and is displayed as specified in the International option of the Control Panel in Windows (or in the Date & Time Control Panel on the Macintosh). Usually, the option has been set to MDY format with a slash (/) indicator.

Example: 7/1/95

Values:

List of values not available.