Penn Computing

University of Pennsylvania
Penn Computing << go backback
ORG_OLD_TO_NEW Table   Tables and Data Elements   General Ledger Home   Data Warehouse Home

ORG_OLD_TO_NEW Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data Element Definition
CREATED_BY_APP

Index - no
Format - char (30)
May be null? yes

The name of the application sysem that created the ORG_OLD_TO_NEW record. This is meant for Information Systems and Computing for debugging data integrity problems.

Example: GQL

Values:

List of values not available. 

CREATED_BY_LOGIN

Index - no
Format - char (8)
May be null? yes

The Oracle login identification for thre person or batch job that created the ORG_OLD_TO_NEW record.

This is meant for use by Information Systems and Computing for debugging data integrity problems.

Example: BPADMIN

Values:

List of values not available. 

CREATED_BY_Program

Index - no
Format - char (8)
May be null? yes

The name of the program that created the ORG_OLD_TO_NEW record. This program is part of the application system specified in the CREATED_BY_APPLICATION.

This is meant for use by Information Systems and Computing for debugging data integrity problems.

Example: JFJ

Values:

List of values not available. 

CREATED_DATE_TIME

Index - no
Format - date (7)
May be null? yes

The date and time when the ORG_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. The desktop date display options do not allow the time portion of CREATED_DATE_TIME to be displayed.

Example: 6/20/96

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 ORG_OLD_TO_NEW table. For internal use by the GQL application that updates rows in the table.

Example: 26288

Values:

List of values not available. 

LAST_UPD_BY_APP

Index - no
Format - char (30)
May be null? yes

The name of the application that last updated the ORG_OLD_TO_NEW record.

This is meant for use by Information Systems and Computing for debugging data integrity problems.

Example: GQL

Values:

List of values not available. 

LAST_UPD_BY_LOGIN

Index - no
Format - char (8)
May be null? yes

The Oracle login identification for the person or batch job that last updated the ORG_OLD_TO_NEW record.

This is meant for use by Information Systems and Computing for debugging data integrity problems.

Example: BPADMIN

Values:

List of values not available. 

LAST_UPD_BY_PROGRAM

Index - no
Format - char (8)
May be null? yes

The name of the batch program that last updated the ORG_OLD_TO_NEW record. This program is part of the application system specified in LAST_UPD_BY_APP.

This is meant for use by Information Systems and Computing for debugging data integrity problems.

Example: JFJ

Values:

List of values not available. 

LAST_UPD_DATE_TIME

Index - no
Format - date (7)
May be null? yes

The date and time the OLD_ORG_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. The desktop date display options do not allow the time portion of LAST_UPD_DATE_TIME to be displayed.

Example: 6/29/96

Values:

List of values not available. 

LEGACY_ORG_APP

Index - yes
Format - char (8)
May be null? yes

The name of the system or application that uses the LEGACY_ORG_CODE.

Example: PAY (Payroll)

Values:

FIMS    Facilities Information Management System

FIN     The financial system used at Penn before 

        July 1, 1996.

PAY     Payroll

Legacy_ORG_CODE

Index - yes
Format - char (8)
May be null? no

The code used in the LEGACY_ORG_APP to identify the School, Center, or Department. See also LEGACY_ORG_TYPE.

Example: 17101 (the Payroll code for Data Administration)

Values:

List of values not available. 

LEGACY_ORG_TYPE

Index - yes
Format - char (2)
May be null? yes

Indicates whether the LEGACY_ORG_CODE identifies a Department or Unit (UN), or a School or Center (SC).

Values:

UN     Unit or Department

SC     School or Center
ORGANIZATION_CODE

Index - yes
Format - char (4)
May be null? yes

The 4-character code for the Organization that is the counterpart for the LEGACY_ORG_APP's LEGACY_ORG_CODE.

An ORGANIZATION 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 ORGANIZATOINs 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). Note: The counterpart for the LEGACY_ORG_APP's LEGACY_ORG_CODE may be the PROGRAM_CODE rather than the ORGANIZATION_CODE.

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

Values:

List of values not available. 

PROGRAM_CODE

Index - yes
Format - char (4)
May be null? yes

The 4-character code for the program that is the counterpart for the LEGACY_ORG_APP's LEGACY_ORG_CODE.

A PROGRAM is 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 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). Note: The counterpart for the LEGACY_ORG_APP's LEGACY_ORG_CODE may be the ORGANIZATION_CODE rather than the PROGRAM_CODE.

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

Values:

List of values not available. 
 
ORG_OLD_TO_NEW Table   Tables and Data Elements   General Ledger Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania