| 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? no
|
The date this program code record was last updated in BEN Financials.
Values:
List of values not available.
|
| LAST_UPDATED_BY
Indexed - no
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.
|
