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

• GENERATED_FLAG
• ID
• LAST_UPDATE_DATE
• LAST_UPDATED_BY
• LEGACY_FUND
• LEGACY_LEDGER_CODE
• NAC
• NEWTOOLD_FLAG
• 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 22-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 combination of the LEGACY_LEDGER_CODE and LEGACY_FUND mapped to the 22-position Accounting Flexfield during the fiscal year 1996 12th month conversion from SUBLED (the subledger system used at Penn before July 1, 1996) to the present General Ledger accounting structure (in use at Penn since July 1, 1996).

The 22-position Accounting Flexfield is the combination of NAC, Org, BUDGETARY_CONTROL, FUND, Program, and CTR_REF.

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

Values:

Y      Fiscal year 1996 12th month records for this 

       LEGACY_LEDGER_CODE and LEGACY_FUND have this 

       Accounting Flexfield in BEN Financials. 

N      Fiscal year 1996 12th month records for this 

       LEGACY_LEDGER_CODE and LEGACY_FUND do not have

       this Accounting Flexfield in BEN Financials.

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

Indicates whether the combination of the LEGACY_LEDGER_CODE and LEGACY_FUND mapped to the 22-position Accounting Flexfield during the fiscal year 1996 13th month conversion from SUBLED (the subledger system used at Penn before July 1, 1996) to the present General Ledger accounting structure (in use at Penn since July 1, 1996).

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

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

Values:

Y      Fiscal year 1996 13th month records for this 

       LEGACY_LEDGER_CODE and LEGACY_FUND have this 

       Accounting Flexfield in BEN Financials. 

N      Fiscal year 1996 13th month records for this 

       LEGACY_LEDGER_CODE and LEGACY_FUND do not have 

       this Accounting Flexfield in BEN Financials.

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

Indicates whether the combination of the LEGACY_LEDGER_CODE and LEGACY_FUND mapped to the 22-position Accounting Flexfield during the fiscal year 1996 14th month conversion from SUBLED (the subledger system used at Penn before July 1, 1996) to the present General Ledger accounting structure (in use at Penn since July 1, 1996).

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

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

Values:

Y      Fiscal year 1996 14th month records for this 

       LEGACY_LEDGER_CODE and LEGACY_FUND have this

       Accounting Flexfield in BEN Financials. 

N      Fiscal year 1996 14th month records for this 

       LEGACY_LEDGER_CODE and LEGACY_FUND do not have

       this 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_PART_OLD_TO_NEW record. This is meant for use by Information Systems and Computing for debugging data integrity problems.

Example: 2209

Values:

List of values not available.

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

The date this GL_PART_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 sixth and last segment of the 22-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:

Refer to the CTR_REF_CODES table.

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 22-digit Accounting Flexfield is currently valid in BEN Financials.

The Accounting Flexfield is the combination of NAC, ORG, BUDGETARY_CONTROL, FUND, 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 combination of the LEGACY_LEDGER_CODE and LEGACY_FUND maps to the 22-position Accounting Flexfield (NAC, ORG, BUDGETARY_CONTROL, FUND, PROGRAM, and CTR_REF).

The mapping is valid from the START_DATE_ACTIVE through the END_DATE_ACTIVE.

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: 1/1/47 (January 1, 2047)

Values:

List of values not available.

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

The 6-character code identifying the fund.

This is the fourth segment of the 22-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 combination of the LEGACY_LEDGER_CODE and the LEGACY_FUND was generated by an Oracle application.

Generated LEGACY_LEDGER_CODE and LEGACY_FUND values 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 number that uniquely identifies a row in the GL_OLD_PART_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_PART_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 updated this GL_PART_OLD_TO_NEW record. This is meant for use by Information Systems and Computing for debugging data integrity problems.

Example: 2209

Values:

List of values not available.

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

The 5-character code indicating the fund number in SUBLED, the subledger system in use at Penn before July 1, 1996.

The SUBLED account number is the combination of LEGACY_LEDGER_CODE and LEGACY_FUND. In the present General Ledger accounting structure (in use at Penn since July 1, 1996), the counterpart for the SUBLED account is the 22-character Accounting Flexfield (the combination of NAC, ORG, BUDGETARY_CONTROL, FUND, PROGRAM, and CTR_REF).

Example: 90034

Values:

List of values not available.

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

The first character of the account number in SUBLED, the subledger system in use at Penn before July 1, 1996.

LEGACY_LEDGER_CODE identifies the fund group for the account. The SUBLED account number is the combination of LEGACY_LEDGER_CODE and LEGACY_FUND. In the present General Ledger accounting structure (in use at Penn since July 1, 1996), the counterpart for the SUBLED account is the 22-character Accounting Flexfield (the combination of NAC, ORG, BUDGETARY_CONTROL, FUND, PROGRAM, and CTR_REF).

Example: 9

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 22-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:

0     Unrestricted

1     Temporarily Restricted

2     Permanently Restricted

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

Indicates whether the 22-digit Accounting Flexfield in BEN Financials maps back to the combination of LEGACY_LEDGER_CODE and LEGACY_FUND. More than one combination of LEGACY_LEDGER_CODE and LEGACY_FUND may map to a given Accounting Flexfield, but a given Accounting Flexfield maps back to only one combination of LEGACY_LEDGER_CODE and LEGACY_FUND.

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

Examples: Y (the Accounting Flexfield maps back to the combination of LEGACY_LEDGER_CODE and LEGACY_FUND); N (the Accounting Flexfield does not map back to the combination of LEGACY_LEDGER_CODE and LEGACY_FUND)

Values:

N     The Accounting Flexfield does not map back to the 

      combination of LEGACY_LEDGER_CODE and LEGACY_FUND.

Y     The Accounting Flexfield maps back to the 

      combination of LEGACY_LEDGER_CODE and LEGACY_FUND.

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 ORGANIZATION 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 22-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:

Refer to the ORG_CODES table.

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 centers (or across organizations within a school or ccenter).

PROGRAM is the fifth segment of the 22-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:

Refer to the PROGRAM_CODES table.

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

The first date when the combination of the LEGACY_LEDGER_CODE and LEGACY_FUND maps to the 22-position Accounting Flexfield (NAC, ORG, BUDGETARY_CONTROL, FUND, PROGRAM, and CTR_REF).

The mapping is valid from the START_DATE_ACTIVE through the END_DATE_ACTIVE.

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: 5/2/97

Values:

List of values not available.