| 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.
|
