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