Configure Project User Defined Fields

Standard Operating Procedures

Configure Maintenance Project User Defined Fields

 

PURPOSE:

The Maintenance Project User Defined Fields track UConn specifid data elements and their acceptable values when there is one and only one value for the particular element at any given time.

BACKGROUND:

All User Defined Fields for Projects are located in the ae_j_prj_e_udf table found in the User Defined Fields Manager in the System Administration Module

Current UConn Maintenance Project UDFs:

Column Name
Label Field Type
Field Length
Required List of Values
custom001 Work Type Sub Category String 60 No ASBESTOS HAZMAT – ASBESTOS
BATHROOM RENOVATION – BATHROOM
BUILDING SECURITY PHYSICAL SECURITY – BUILDING SECURITY
CAMERAS PHYSICAL SECURITY – CAMERAS
CARPET REFURBISHMENT – CARPET
CEILING TILE REFURBISHMENT – CEILING TILE
CLASSROOM RENOVATION – CLASSROOM
CONDENSATE INFRASTRUCTURE – CONDENSATE
DAMS INFRASTRUCTURE – DAMS
DOORS ENVELOPE – DOORS
ELECTRICAL MEP OR ENERGY CONSERVATION – ELECTRICAL
ELEVATOR ELEVATOR – ELEVATOR
EMS MEP – EMS
FACADES ENVELOPE – FACADES
FIRE PANELS LIFE SAFETY – FIRE PANELS
FLOORING REFURBISHMENT – FLOORING
FURNITURE REFURBISHMENT – FURNITURE
GARAGES PARKING – GARAGES
GREENSCAPE LANDSCAPE – GREENSCAPE
HARDSCAPE LANDSCAPE – HARDSCAPE
HVAC MEP OR ENERGY CONSERVATION – HVAC
KITCHEN OR DINING RENOVATION – KITCHEN OR DINING
LAB RENOVATION – LAB
LEAD HAZMAT – LEAD
LOCKS PHYSICAL SECURITY – LOCKS
MOLD HAZMAT – MOLD
OFFICE RENOVATION – OFFICE
OTHER RENOVATION OR ENERGY CONSERVATION – OTHER
PAINT REFURBISHMENT – PAINT
PCB HAZMAT – PCB
PLUMBING MEP – PLUMBING
RECLAIMED WATER INFRASTRUCTURE – RECLAIMED WATER
ROOF ENVELOPE – ROOF
SEWAGE INFRASTRUCTURE – SEWAGE
SIDING ENVELOPE – SIDING
SILICA DUST HAZMAT – SILICA DUST
SPRINKLER SYSTEMS LIFE SAFETY – SPRINKLER SYSTEMS
STEAM INFRASTRUCTURE OR ENERGY CONSERVATION – STEAM
STORM INFRASTRUCTURE – STORM
SURFACE LOT PARKING – SURFACE LOT
WATER INFRASTRUCTURE OR ENERGY CONSERVATION – WATER
WINDOWS ENVELOPE – WINDOWS
custom002 Funding Source String 60 No BOND FUNDED BY ANY UCONN 2000/NEXT GEN BOND ACCOUNT
BOND/DEPT FUNDED BY A COMBINATION OF DEPT AND BOND
DEPT FUNDED BY ANY ACCOUNT PROVIDED BY A DEPARTMENT BESIDES FO
DEPT/REC FUNDED BY A COMBINATION OF DEPT AND REC
FO FUNDED BY FACILITIES OPERATING ACCOUNTS
FO/DEPT FUNDED BY A COMBINATION OF FO AND DEPT
FO/DEPT/BOND FUNDED BY A COMBINATION OF FO, DEPT AND BOND
FO/DEPT/REC FUNDED BY A COMBINATION OF FO, DEPT AND REC
FO/REC FUNDED BY A COMBINATION OF FO AND REC
IMF FUNDED BY FO IMF ACCOUNTS
IMF/PF FUNDED BY A COMBINATION OF IMF AND PF
PF FUNDED BY FO PLANT FUND ACCOUNTS
REC FUNDED BY THE REC (RENEWABLE ENERGY CREDITS) ACCOUNT
TBD FUNDING METHOD IS TO BE DETERMINED IN THE FUTURE
custom003 Building Permit String 60 No YES

No

N/A

custom004 Construction Percent Complete Number 60 No
custom005 Building Permit Open Closed String 60 No CLOSED

OPENED

N/A

custom006 Project Coverage Area (PCA) Number 60 No
custom007 PCA Unit of Measure String 60 No
custom0020 Planned Schedule WO String 60 No
custom0021 Schedule Cost Estimate WO String 60 No
custom0022 Labor Cost Estimate String 60 No

 

 


ROLES USED:

 

The System Administrator is responsible for managing and overseeing the Project Management module its configuration and functionality.

 

 

Return to Project Management Module SOP