| Data Element |
Definition |
| CENTER_CODE
Indexed - no
Format - char (2)
May be null? yes
|
The two character code that represents the specific school or center to which the ORGANIZATION_CODE belongs. The
code set is from the University's General Ledger, and has been in use
since July 1, 1996.
Example: 40 (School of Medicine)
Values:
Refer to the CNAC_CODES Table for values. The code for a
school or center is the same as the first 2 characters
of the CNAC.
|
| CENTER_NAME
Indexed - no
Format - varchar (70)
May be null? yes
|
The name of the school or center to which the ORGANIZATION_CODE belongs. The code set is from the University's General Ledger, and has been in use since July 1, 1996.
Example: School of Medicine (40)
Values:
Refer to the CNAC_CODES Table for values. The code for a
school or center is the same as the first 2 characters
of the CNAC.
|
| CREATED_BY_APP
Indexed - no
Format - char (30)
May be null? yes
|
Name of the application that created the ORG_CODES record. This is meant
for use by the Information Systems and Computing for debugging data integrity
problems.
Example: GQL (General Query Language)
Values:
List of values not available.
|
|
CREATED_BY_LOGIN
Indexed - no
Format - char (8)
May be null? yes
|
Oracle login identification (ID) for the person or batch job that created
the ORG_CODES record. This is meant for use by Information Systems and
Computing for debugging data integrity problems.
Example: ORG_PROG
Values:
List of values not available.
|
|
CREATED_BY_PROGRAM
Indexed - no
Format - char (8)
May be null? yes
|
Name of the program that created the ORG_CODES record. This
program is part of the application system specified in CREATED_BY_APPLICATION.
This is meant for use by Information Systems and Computing for debugging
data integrity problems.
Values:
List of values not available.
|
|
CREATED_DATE_TIME
Indexed - no
Format - date (7)
May be null? yes
|
The date and time when the ORG_CODES 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_TIMEto
be displayed.
Example: 3/19/97
Values:
List of values not available.
|
DESCRIPTION
Indexed - no
Format - char (60)
May be null? no |
The description that corresponds to the ORGANIZATION_CODE from the
EFFECTIVE_DATE through the EXPIRATION_DATE.
Examples: Chemistry (0104); General University Surrogate (0001)
Values:
Refer to the ORG_CODES Table for values.
|
|
ENABLED
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the ORG_CODE may be used in BEN Financials transactions.
Examples: Y (ORG_CODE may be used in BEN Financials transactions);
N (ORG_CODE may not be used in BEN Financials transactions)
Values:
Y ORG_CODE may be used in BEN Financials
transactions.
N ORG_CODE may not be used in BEN Financials
transactions. |
| EFFECTIVE_DATE
Indexed - no
Format - date (7)
May be null? no
|
The first date when the data for the ORG_CODES record is in effect.
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: 3/3/97 (March 3, 1997)
Values:
List of values not available.
|
|
EXPIRATION_DATE
Indexed - no
Format - date (7)
May be null? no
|
The last date when the data for the ORG_CODES record is in effect.
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
Indexed - no
Format - number (15)
May be null? no
|
A sequence number that uniquely identifies a row in the ORG_CODES table.
For internal use by the GQL application that updates rows in the table.
Values:
List of values not available.
|
|
INTERNAL_EXTERNAL_FLAG
Indexed - no
Format - char (1)
May be null? no
|
Indicates whether the organization is a part of Penn (I) or is affiliated
with Center 99 (E), for which Penn performs certain transactions.
The INTERNAL_EXTERNAL_FLAG is in effect for the ORGANIZATION_CODE from
the EFFECTIVE_DATE through the EXPIRATION_DATE.
Examples: E (External); I (Internal)
Values:
I Internal
E External
|
| LAST_UPD_BY_APP
Indexed - no
Format - char (3)
May be null? yes
|
Name of the application that last updated the ORG_CODES 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
Indexed - no
Format - char (8)
May be null? yes
|
The Oracle login identification (ID) for the person or batch job that
last updated the ORG_CODES 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
Indexed - no
Format - char (8)
May be null? yes
|
Name of the program that last updated the ORG_CODES 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.
Values:
List of values not available.
|
|
LAST_UPD_DATE_TIME
Indexed - no
Format - date (7)
May be null? yes
|
The date and time when the ORG_CODES 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: 3/19/97
Values:
List of values not available.
|
|
LEDGER_ALIAS_CODE
Indexed - no
Format - char (2)
May be null? yes
|
The BEN Financials code for the school or center associated with the
ORGANIZATION_CODE from the EFFECTIVE_DATE through the EXPIRATION_DATE.
Used only for organization codes at the school or center level --the value
will be null for other organization types (units, subunits, and sub-subunits).
Examples: 02 (School of Arts and Sciences); 40 (School of Medicine)
Values:
00
02 School of Arts and Sciences
04 Provost Interdisciplinary
06 Nursing School
07 Wharton
13 School of Engineering and Applied Sciences
19 Annenberg Center
21 HUP Medical Center
24 Athletics
26 Museum
32 Graduate School of Education
33 School of Design
35 School of Social Policy & Practice
36 Annenberg School for Communication
40 School of Medicine
50 Library
51 Dental School
56 Law School
58 School of Veterinary Medicine
60 Morris Arboretum
61 Institute of Contemporary Art
62 International Programs
63 Fels Center for Government
78 Internal Audit
79 Public Safety
80 General University
81 President
83 Provost
85 University Life
87 Finance
88 Medical Center
90 Development and Alumni Relations
91 Computing
92 Human Resources
93 Auxiliary Enterprise
95 Residences
96 Facilities Management
98 Executive Vice President
99 External Organizations
|
| ORG_CATEGORY
Indexed - no
Format - char (8)
May be null? yes
|
Indicates the functional type of the organization from the EFFECTIVE_DATE
through the EXPIRATION_DATE.
Examples: SCHOOL, ADMIN
Values:
ACADDEPT
ACADPROG
ADMIN
AUXIL
CENTINST
EXTERNAL
ISC
PUBSERV
SCHOOL
SERVCENT
STUDSERV
STUDSEV
|
| ORG_NOTE
Indexed - no
Format - varchar2 (2000)
May be null? yes
|
Free-form text area used to document some organizations.
The ORG_NOTE applies to the ORGANIZATION_CODE from the EFFECTIVE_DATE
through the EXPIRATION_DATE.
For ORGANIZATION_CODE PATV (Pathology (Vet) Parent) from November 21,
1996, through January 1, 2047, the note reads "Be careful not to confuse
this with PATH in the Medical School."
Values:
List of values not available.
|
| ORG_SHORT_NAME
Indexed - no
Format - varchar2 (20)
May be null? yes
|
The abbreviated name that corresponds to the ORGANIZATION_CODE from the
EFFECTIVE_DATE through the EXPIRATION_DATE.
Example: PUB POL & MGMT (0710) is the abbreviated name for Public
Policy and Management
Values:
List of values not available.
|
|
ORGANIZATON_CODE
Indexed - no
Format - char (4)
May be null? no
|
The 4-character code that represents the organization from the EFFECTIVE_DATE
through the EXPIRATION_DATE.
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 organizations will have
the same value for ORGANIZATION_CODE.
ORGANIZATION_CODE is the second segment of the Accounting_Flexfield.
Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies)
Values:
Refer to the ORG_CODES table for values.
|
| ORGANIZATION_TYPE
Indexed - no
Format - char (2)
May be null? no
|
The hierarchical type for the ORGANIZATION_CODE from the EFFECTIVE_DATE
through the EXPIRATION_DATE.
From the top of the hierarchy on down, the possible values for ORGANIZATION_TYPE
are SC (school or center -- for example, 40XX, School of Medicine Parent);
UN (Unit -- for example, SOM, School of Medicine Parent); SU (Subunit
-- for example, CANC, CC-Cancer Center Parent); and SS (Sub-subunit --
for example, 4752, CC-Imaging Facility).
Values:
SC School or Center
SS Sub-Subunit
SU Subunit
UN Unit
|
| PARENT_ORG_CODE
Indexed - no
Format - char (4)
May be null? no
|
The 4-character code for the organization to which the ORGANIZATION_CODE
belongs from the EFFECTIVE_DATE through the EXPIRATION_DATE.
An organization is a subdivision of the University created for management
purposes. The ORGANIZATION_CODE represents an organization at one level
of the subdivision hierarchy, and the PARENT_ORG_CODE represents the organization
at the next level up in the subdivision hierarchy. A given PARENT_ORG_CODE
may be associated with more than one ORGANIZATION_CODE. For example, PARENT_ORG_CODE
DEAS (SEAS OFFICE OF THE DEAN) includes 1319 (SEAS Copy Center) and 1322
(Moore Business Offices), among other organizations.
Values:
Refer to the ORG_CODES Table for values.
|
| PAYROLL_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the ORG_CODE is used in the Payroll system. |
| PURPOSE_CODE
Indexed - yes
Format - char (2)
May be null? yes
|
The 2-character code indicating the primary purpose of expenditures for
the ORGANIZATION_CODE from the EFFECTIVE_DATE through the EXPIRATION_DATE.
Examples: 01 (Instruction), NA (Not applicable)
Values:
01 Instruction (for example, School Specific
"Dean's Fund")
10 Sponsored Research
11 Other, Separately Budgeted Research (for example,
URF {University Research Foundation}, RFDF
{Research Facilities Development Fund},
Technology Transfer, Research Matching
Program, Insurance Fund)
20 Libraries
30 Student Aid (for example, University Fellowship)
40 Student Services
50 Extension & Public Service
60 Auxiliary Enterprise: Dormitories
61 Auxiliary Enterprise: Bookstore
62 Auxiliary Enterprise: Dining Services
63 Auxiliary Enterprise: Intercollegiate Athletics
64 Auxiliary Enterprise: Other
70 Hospitals & Clinics: Medical
71 Hospitals & Clinics: Dental
72 Hospitals & Clinics: Veterinary
73 Hospitals & Clinics: Nursing
80 Independent Operations
90 Management and General (for example, Debt
Service, Employee Benefit Pool)
92 Fundraising
93 Maintenance & Operation of Facilities (for
example, Deferred Maintenance)
NA not applicable (for example, General
Unrestricted, Anticipated revenue &
expense, Capital Construction Fund,
other 02XXXX funds, Loan funds,
annuities, capital gifts funds, agency)
NA is used for "parent" funds and other
funds where purpose does not really apply
(for example, capital gifts, annuities)
UN unknown, to be assigned later; UN is the default.
|
| SPACE_FLAG
Indexed - no
Format - char (1)
May be null? yes |
Indicates whether the ORG_CODE is used in FacilityCenter, the source
system for managing space at Penn. |
| SURROGATE_ORG
Indexed - no
Format - char (1)
May be null? yes
|
Indicates whether the ORGANIZATION_CODE represents a surrogate organization
from the EFFECTIVE_DATE through the EXPIRATION_DATE.
A surrogate organization is used to summarize data for organizations
related to the surrogate. Financial Transactions are not posted to surrogate
organizations.
Examples: Y (A surrogate); N (Not a surrogate)
Values:
N No
Y Yes
[null] Unknown
|
