Penn Computing

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

PROGRAM_CODES Table - Data Element Index

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



Data Element Definition
CAPITAL_ADVISORY_GROUP_DATE

Indexed - no
Format - date
May be null? yes

The most recent date the project went before the Capital Advisory Group (CAG). Applies to capital project programs only.


Values:

List of values not available.

CAPITAL_COUNCIL_APPROVAL_DATE

Indexed - no
Format - date
May be null? yes

The most recent date Capital Council (CC) approved work on the project. Applies to capital project programs only.


Values:

List of values not available.

CAPITAL_PROJECT_TYPE

Indexed - yes
Format - varchar2 (20)
May be null? yes

Designates the type of work performed. Applies to capital project programs only.


Values:

New Construction

Other (other capital investments to existing 

  facilities)
Renovation (implies occupancy of an existing space)
Renewal (implies work to an existing space, such as a new roof)
Deferred Maintenance (implies infrastructure work in an existing space, such as HV/AC projects)
CAPITAL_PROJECT_YEAR

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

The year, within the University's capital project budget, in which this particular project was approved. Applies to capital project programs only.

Example: 1996


Values:

List of values not available.

CERTIFIED_PROJECT_START_DATE

Indexed - yes
Format - date
May be null? yes

The date of the first certification of the project from (Treasurer's) Construction Finance. Applies to capital project programs only.


Values:

List of values not available.
CHAMPS_PROJECT_ID

Indexed - yes
Format - char (15)
May be null? yes

The code used to identify the project in CHAMPS, the Computerized History and Maintenance Program System.

As of June 1997, this data element is not populated.


Values:

List of values not available.

CURRENT_CONSTRUCT_FINISH_DATE

Indexed - no
Format - date
May be null? yes

The most recent estimate for completion of construction on the project. Applies to capital project programs only.


Values:

List of values not available.
CURRENT_OCCUPANCY_DATE

Indexed - no
Format - date
May be null? yes

The most recent occupancy date for the project. Applies to capital project programs only.


Values:

List of values not available.

CURRENT_PROJ_COMPLETION_DATE

Indexed - no
Format - date
May be null? yes

The most recent estimated completion date for the project. Applies to capital project programs only.


Values:

List of values not available.

ENABLED

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

Indicates whether the PROGRAM_CODE may be used in BEN Financials transactions.

Examples: Y (PROGRAM_CODE may be used in BEN Financials transactions); N (PROGRAM_CODE may not be used in BEN Financials transactions)


Values:

Y   PROGRAM_CODE may be used in 

    BEN Financials transactions.

N   PROGRAM_CODE may not be used in 

    BEN Financials transactions.

FACILITIES_RENEWAL_FUNDED

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

Facilities Renewal Funded projects are handled differently from other capital projects, and will not have values in Capital_Advisory_Group_Date, Capital_Council_Approval_Date, and Trustees_Approval_Date. Applies to capital project programs only.


Values:

Y   Project is Facilities Renewal Funded.

N   Project is not Facilities Renewal Funded.
LAST_UPDATE_DATE

Indexed - yes
Format - date
May be null? yes

The date this program code record was last updated in BEN Financials.


Values:

List of values not available.
LAST_UPDATED_BY

Indexed - yes
Format - varchar2 (50)
May be null?yes

The BEN Financials user name of the user that last updated this program code record. This may be an individual BEN Financials user's user name, or that of an automatic system process.


Values:

List of values not available.
PARENT_PROGRAM_CODE

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

The 4-character code for the program to which the PROGRAM_CODE belongs.

A PROGRAM is an activity or work process commonly defined across the University. Programs track activity across schools and centers (or across organizations within a school or center). A given PARENT_PROGRAM_CODE may be associated with more than one CHILD_PROGRAM.


Values:

List of values not available.
PLANNED_CONSTRUCT_FINISH_DATE

Indexed - no
Format - date
May be null?yes

The original estimated date of completion of construction on the project. Applies to capital project programs only.


Values:

List of values not available.
PLANNED_PROJ_COMPLETION_DATE

Indexed - no
Format - date
May be null?yes

The original estimated completion date for the project. Applies to capital project programs only.


Values:

List of values not available.
PLANNED_PROJECT_START_DATE

Indexed - yes
Format - date
May be null?yes

The original planned start date for the project, as of the time of the request to the Comptroller's Office for the creation of the program. Applies to capital project programs only.


Values:

List of values not available.
PROGRAM_CODE

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

The 4-character program code. This 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_CODE is the sixth segment of the Accounting Flexfield.

Examples: 7311 (ALUMNI RELATIONS); 1672 (COMMUNICATIONS)


Values:

Refer to the PROGRAM_CODES table for values.

PROGRAM_DESC

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

The description that corresponds to the PROGRAM_CODE.

Examples: ALUMNI RELATIONS (7311); COMMUNICATIONS (1672)


Values:

Refer to the PROGAM_CODES table for values.

PROGRAM_LONG_DESC

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

The long description that corresponds to the PROGRAM_CODE.

Example: SMALL BUSINESS DEVELOPMENT (3004)


Values:

Refer to the PROGRAM_CODES table for values.

PROGRAM_NOTE

Indexed - no
Format - varchar2 (240)
May be null?yes

Free-form text area used to document some programs.


Values:

List of values not available.
PROJECT_CLOSEOUT_DATE

Indexed - no
Format - date
May be null? yes

The date the project was declared closed (by Facilities, Comptroller's and Treasurer's offices, in concert). Note: this can be different from the date the program was disabled, given need to re-enable program codes for late charges or system maintenance. Applies to capital project programs only.


Values:

List of values not available.
PROJECT_DFD_NUMBER

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

The 8-character identification number of the project according to the Department of Facilities Development. This code is used only for capital projects.

Example: 97079.00 (Hayden Hall Ecology Renovations)


Values:

List of values not available.

PROJECT_SCOPE_DEFINITION

Indexed - no
Format - varchar2 (240)
May be null? yes

A description of the project, as detailed on program code request form to Comptroller's Office. Applies to capital project programs only.


Values:

List of values not available.

RELATED_PROGRAM_CODE

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

Specifies the building program code associated with a capital project. Applies to capital project programs only.

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

Examples: 9500 (ANN CTR); 9534 (COLL HALL)


Values:

Refer to the PROGRAM_CODES table for values.

SCHOOL_CENTER

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

The School or Center of the University for which the work is being done. Applies to capital project programs only.

Example: 02 (School of Arts & Sciences)


Values:

List of values not available.

SPACE_BUILDING_CODE

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

For building programs, the unique code used to identify the building in the Facilities and Real Estate Services space management system (FacilityCenter).

Example: 0416 (3401 Walnut Street)


Values:

Refer to the BUILDINGS table for values.

  

TRUSTEES_APPROVAL_DATE

Indexed - no
Format - date
May be null? yes

The most recent date the Board of Trustees approved work on the project.


Values:

List of values not available.
 
PROGRAM_CODES 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