| Data Element |
Definition |
| C12
Indexed - no
Format - char (1)
May be null? no
|
Indicates whether the SUBCODE mapped to the OBJECT during the fiscal
year 1996 12th month conversion from the legacy financial system (used
at Penn before July 1, 1996) to the present General Ledger accounting
structure (in use at Penn since July 1, 1996).
Examples: Y (fiscal year 1996 12th month records for this SUBCODE have
this OBJECT in BEN Financials); N (Fiscal year 1996 12th month records
for this SUBCODE do not have this OBJECT in BEN Financials)
|
| C13
Index - no
Format - char (1)
May be null? no
|
Indicates whether the SUBCODE mapped to the OBJECT during the fiscal
year 1996 13th month conversion from the legacy financial system (used
at Penn before July 1, 1996) to the present General Ledger accounting
structure (in use at Penn since July 1, 1996).
Examples: Y (fiscal year 1996 13th month records for this Subcode have
this Object in BEN Financials); N (Fiscal year 1996 13th month records
for this SUBCODE do not have this Object in BEN Financials)
Values:
Y Fiscal year 1996 13th month records for this
SUBCODE have this OBJECT in BEN Financials.
N Fiscal year 1996 13th month records for this
SUBCODE do not have OBJECT in BEN Financials.
|
| C14
Index - no
Format - char (1)
May be null? no
|
Indicates whether the SUBCODE mapped to the OBJECT during the fiscal
year 1996 14th month conversion from the legacy financial system (used
at Penn before July 1, 1996) to the present General Ledger accounting
structure (in use at Penn since July 1, 1996).
Examples: Y (fiscal year 1996 14th month records for this SUBCODE have
this OBJECT in BEN Financials); N (Fiscal year 1996 14th month records
for this SUBCODE do not have this OBJECT in BEN Financials)
Values:
Y Fiscal year 1996 14th month records for this
SUBCODE have this OBJECT in BEN Financials.
N Fiscal year 1996 14th month records for this
SUBCODE do not have OBJECT in BEN Financials.
|
| CREATED_BY
Index - no
Format - number (15,0)
May be null? no
|
The BEN Financials user ID for the user who created this GL_SUBCD_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.
|
|
CREATION_DATE
Index - no
Format - date (7)
May be null? no
|
The date this GL_SUBCD_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/21/95
Values:
List of values not available.
|
| ENABLED_DATE
Index - 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.
|
| ENABLED_FLAG
Index - no
Format - char (1)
May be null? no
|
Indicates whether the OBJECT is currently valid in the present General
Ledger accounting structure (in use at Penn since July 1, 1996).
Examples: Y (the OBJECT is currently valid in BEN Financials); N (the
OBJECT is not currently valid in BEN Financials)
Values:
Y The OBJECT is currently valid in
BEN Financials.
N The OBJECT is not currently valid in
BEN Financials.
|
| END_DATE_ACTIVE
Index - no
Format - date (7)
May be null? no
|
The last date when the SUBCODE maps to the OBJECT. 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.
|
|
ID
Index - yes
Format - number (15,0)
May be null? no
|
A sequence number that uniquely identifies a row in the GL_SUBCD_OLD_TO_NEW
table. For internal use by the GQL applicaton that updates rows in the
table.
Example: 6932
Values:
List of values not available.
|
| LAST_UPDATE_DATE
Index - no
Format - date (7)
May be null? no
|
The date the GL_SUBCD_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: 5/23/96
Values:
List of values not available.
|
|
LAST_UPDATED_BY
Index - no
Format - number (15,0)
May be null? no
|
The BEN Financials user ID for the user who last updated this GL_SUBCD_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.
|
|
OBJECT
Index - 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:
Refer to the OBJECT_CODES table.
|
| START_DATE_ACTIVE
Index - no
Format - date (7)
May be null? no
|
The first when the SUBCODE maps to the OBJECT. 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: 7/1/95
Values:
List of values not available.
|
|
SUBCODE
Index - yes
Format - char (3)
May be null? no
|
The 3-character subcode in the financial system used at Penn before July
1, 1996. Identified the asset, liability, revenue, or expense.
SUBCODE's counterpart in the BEN Financials system is OBJECT. BEN Financials
is the financial system in use at Penn since July 1, 1996.
Example: 691
Values:
List of values not available.
|
