FAMIS Web Services

Sample Javascript usage of webservices

Sample PHP usage of webservices

Generic Web Services

Note:  To use the api/index.php to access FAMIS data a key parameter is required.  Please contact the technical team if you need a key generated for your access.
If you need a named array for your web service response, use the wrap parameter and the resulting json response will have the name specified in that parameter.

 Test call to make sure the basics of the webservice  are working
Method Parameters Example Output Logic
Processed/Summary Data
 HELLO  format=json  {“code”:1, “status”:200, “data”:”Hello World”}

Facilities Related Web Services

Note:  To use the api/index.php to access FAMIS data a key parameter is required.  Please contact the technical team if you need a key generated for your access.
If you need a named array for your web service response, use the wrap parameter and the resulting json response will have the name specified in that parameter.

Method Parameters Example Output Logic
Processed/Summary Data
BACKLOG_BY_CREW format=json
value=HVAC
[{"THIS_MTH_BACK":"635",
"ONE_MTH_AGO_BACK":"625",
"TWO_MTH_AGO_BACK":"1039",
"THREE_MTH_AGO_BACK":"872",
"FOUR_MTH_AGO_BACK":"620",
"FIVE_MTH_AGO_BACK":"346",
"SIX_MTH_AGO_BACK":"2406",
"SEVEN_MTH_AGO_BACK":"2192",
"EIGHT_MTH_AGO_BACK":"2152",
"NINE_MTH_AGO_BACK":"1930",
"TEN_MTH_AGO_BACK":"1809",
"ELEVEN_MTH_AGO_BACK":"1629",
"TWELVE_MTH_AGO_BACK":"1698",
"ERA":"NOW",
"Name":"HVAC"},
{"THIS_MTH_BACK":"1698",
"ONE_MTH_AGO_BACK":"1632",
"TWO_MTH_AGO_BACK":"1392",
"THREE_MTH_AGO_BACK":"1178",
"FOUR_MTH_AGO_BACK":"1086",
"FIVE_MTH_AGO_BACK":"1011",
"SIX_MTH_AGO_BACK":"1225",
"SEVEN_MTH_AGO_BACK":"1298",
"EIGHT_MTH_AGO_BACK":"1161",
"NINE_MTH_AGO_BACK":"874",
"TEN_MTH_AGO_BACK":"800",
"ELEVEN_MTH_AGO_BACK":"643",
"TWELVE_MTH_AGO_BACK":"537",
"ERA":"LAST",
"Name":"HVAC"}]
Finds how many work orders were in a 90+ day state at the first of the specified month grouped by CREW.There are are two ERA’s.  “NOW” is the current year and “LAST” is the previous year.
Detailed Lists
 ACT_ASSIGNED format=json
value=PCA03002
[{"WO":"M591983",
"DESCRIPTION":"INSTALL DROP CEILING (TASKS)",
"STATUS":"ASSIGNED",
"ASSIGNED_TO":"PCA03002",
"NAME":"TORREY LIFE SCIENCES BUILDING",
"FLOOR":"03",
"ROOM_BILLING_ID":
"147307",
"ROOM":"303",
"ENTER_DATE":"07-22-2014",
"MAINT_TYPE":"CORRECTIVE"},
{"WO":"M619933",
"DESCRIPTION":"REPAIR CEILING AND\/OR WALL DAMAGE DUE TO LEAK",
"STATUS":"ASSIGNED",
"ASSIGNED_TO":"PCA03002",
"NAME":"HILLTOP APT-H.B.STOWE BLDG#11",
"FLOOR":"03",
"ROOM_BILLING_ID":"163428",
"ROOM":"304",
"ENTER_DATE":"03-15-2015",
"MAINT_TYPE":"CORRECTIVE"}]
LABOR_DETAILS format=json
value=WO_NUMBER,PAY_CODE
range=M630937,REGULAR
[{"CREW":"HVAC","EMPLOYEE":"GSS02003","ENTER_DATE":"30-OCT-15","WORK_DATE":"27-OCT-15","WO_NUMBER":"M630937","DESCRIPTION":"REPAIRED HEAT.","FACTOR":"1","HOURS":"2","LABOR_STATUS":"S APPROVE","PAY_CODE":"REGULAR","SHIFT":"1"},{"CREW":"HVAC","EMPLOEE":"GSS02003","ENTER_DATE":"07-NOV-15","WORK_DATE":"30-OCT-15","WO_NUMBER":"M630937","DESCRIPTION":"REPAIRED HEAT.","FACTOR":"1","HOURS":"1","LABOR_STATUS":"S APPROVE","PAY_CODE":"REGULAR","SHIFT":"1"},{"CREW":"HVAC","EMPLOEE":"GSS02003","ENTER_DATE":"19-NOV-15","WORK_DATE":"16-NOV-15","WO_NUMBER":"M630937","DESCRIPTION":"REPAIRED HEAT","FACTOR":"1","HOURS":"3","LABOR_STATUS":"S APPROVE","PAY_CODE":"REGULAR","SHIFT":"1"},{"CREW":"HVAC","EMPLOEE":"GSS02003","ENTER_DATE":"19-NOV-15","WORK_DATE":"17-NOV-15","WO_NUMBER":"M630937","DESCRIPTION":"REPAIRED HEAT","FACTOR":"1","HOURS":"3","LABOR_STATUS":"S APPROVE","PAY_CODE":"REGULAR","SHIFT":"1"}]
Place the comma separated field name(s) to filter on the value field & the comma separated value(s) in the range field to get matching data
WORK_ORDER_LITE format=json
value=WO_NUMBER
range=M358732
[{"ASSIGNED_TO":"THH04003","BUILDING":"0213","COMPLETE_DATE":"09-JUN-10","CREW":"ZONE 1","DEPARTMENT":"50925AA","DESCRIPTION":"INSTALL CONDENSER LINE IN UNION STREET MARKET","DUE_DATE":"05-FEB-10","EMAIL":"CHUCK.MORRELL@UCONN.EDU","ENTER_DATE":"04-FEB-10","ENTER_USER":"FSSUCON101","MODIFY_DATE":"14-JUN-10","MODIFY_USER":"EYC08001","PRIORITY":"2","REQUESTOR":"MORRELL, CHARLES V","TELEPHONE":"(860) 486-3422","WO_CLOSE_DATE":"11-JUN-10","WO_NUMBER":"M358732","WO_STATUS":"CLOSED","EQUIPMENT":null,"FLOOR":null,"ROOM":null}]
Place the comma separated field name(s) to filter on the value field & the comma separated value(s) in the range field to get matching data
CREWED_EMPS format=json
value=ACTIVE
[{"NETID":"JRG03004","FULL_NAME":"GIACCONE, JULIUS R","JOB_TITLE":"GENERAL TRADES WORKER","REPORTS_TO":"RISTAU, ARISTIDE","CREW":"GEN MNTC","CRAFT":"GEN MNTC","SHIFT":"1","DEPARTMENT":"OFFICE OF RESIDENTIAL LIFE","STATUS":"INACTIVE","TERMINATION_DATE":"03-JUN-15","PAYROLL_NUMBER":"551082","EMAIL":"JULIUS.GIACCONE@UCONN.EDU","TELEPHONE":"(860) 486-5556"},{"NETID":"DEC02006","FULL_NAME":"CHAMBERLAND, DEAN E","JOB_TITLE":"WASTE WATER TREATMENT TECH","REPORTS_TO":"MATTHEWSON, TODD A","CREW":"WPCF","CRAFT":"WPC","SHIFT":"1","DEPARTMENT":"FACILITIES INFRASTRUCTURE SERVICES","STATUS":"INACTIVE","TERMINATION_DATE":"01-AUG-15","PAYROLL_NUMBER":"402865","EMAIL":"DEAN.CHAMBERLAND@UCONN.EDU","TELEPHONE":"(860) 486-7106"},{"NETID":"TLT05003","FULL_NAME":"TUSSING, TIMOTHY L","JOB_TITLE":"MANAGER - UTILITIES","REPORTS_TO":"PACHOLSKI, MICHAEL J","CREW":"ADMIN","CRAFT":null,"SHIFT":"1","DEPARTMENT":"FACILITIES INFRASTRUCTURE SERVICES","STATUS":"INACTIVE","TERMINATION_DATE":"28-MAY-15","PAYROLL_NUMBER":"027040","EMAIL":"TIMOTHY.TUSSING@UCONN.EDU","TELEPHONE":"(860) 486-2608"}]
 In the value field, enter the Employee status and it will return all employees who have crew assignments in FAMIS with that status
 PRINT_WO_FLAG format=json
value=M620851
[{"message":"Success"}]
 REFRESH_PRINT_WO_FLAG  format=json
value=M620851
[{"message":"Success"}]

Space Related Web Services

 Method Parameters Example Output
 NEAREST_BUILDING
(test on production)
(test on test)
(test on dev)
 format=json
lat=41.80631261271258
lon=-72.25148302786354
[{"BUILDING":"BABBIDGE LIBRARY (HOMER)","BLDG_CODE":"0364","DISTANCE_m":".0000293585280815023"},{"BUILDING":"EXIT FOR UNDERGROUND CLASSROOM AREA","BLDG_CODE":null,"DISTANCE_m":".0000910354932557311"},{"BUILDING":"WHETTEN GRADUATE CENTER","BLDG_CODE":"0324","DISTANCE_m":".000314255524926921"},{"BUILDING":"INFORMATION TECHNOLOGY BUILDING","BLDG_CODE":"0434","DISTANCE_m":".00049071690727942"},{"BUILDING":"DODD RESEARCH CENTER (THOMAS J)","BLDG_CODE":"0383","DISTANCE_m":".000652384728709876"},{"BUILDING":"COLCHESTER GRAD DORM","BLDG_CODE":"0333C","DISTANCE_m":".00075614539741764"},{"BUILDING":"DERBY GRAD DORM","BLDG_CODE":"0333D","DISTANCE_m":".000887314362557845"},{"BUILDING":"BRANFORD GRAD DORM","BLDG_CODE":"0332B","DISTANCE_m":".000952355742015243"},{"BUILDING":"OAK HALL","BLDG_CODE":"0486","DISTANCE_m":".00104277710670431"}]
 SPACE_METRICS_UNIT_BY_BLDG
(test on dev)
  format=json
value=2120
[{"NUM_ROOMS":"171","NASF":"51910","PERCENT":"23","FACILITY_NAME":"INFORMATION TECHNOLOGY BUILDING"},{"NUM_ROOMS":"103","NASF":"37226","PERCENT":"16","FACILITY_NAME":"CASTLEMAN BUILDING (ENG. I)"},{"NUM_ROOMS":"126","NASF":"37771","PERCENT":"16","FACILITY_NAME":"ENGINEERING II"},{"NUM_ROOMS":"98","NASF":"24695","PERCENT":"11","FACILITY_NAME":"UNITED TECHNOLOGIES ENG BLDG"},{"NUM_ROOMS":"60","NASF":"22338","PERCENT":"10","FACILITY_NAME":"DEPOT - LONGLEY SCHOOL"},{"NUM_ROOMS":"56","NASF":"20072","PERCENT":"9","FACILITY_NAME":"BRONWELL BUILDING (ARTHUR B.)"},{"NUM_ROOMS":"36","NASF":"13514","PERCENT":"6","FACILITY_NAME":"BABBIDGE LIBRARY (HOMER)"},{"NUM_ROOMS":"30","NASF":"12052","PERCENT":"5","FACILITY_NAME":"DEPOT- FUEL CELL INSTITUTE BUILDING"},{"NUM_ROOMS":"12","NASF":"7374","PERCENT":"3","FACILITY_NAME":"DEPOT- MERRITT HALL"},{"NUM_ROOMS":"2","NASF":"1285","PERCENT":"1","FACILITY_NAME":"DEPOT- Depot D CT Adv. Pavement Lab"},{"NUM_ROOMS":"3","NASF":"1751","PERCENT":"1","FACILITY_NAME":"HYDRAULIC LAB-ENG,PNK RAV"}]
 SPACE_METRICS_UNIT_BY_DEPT
(test on dev)
 format=json
value=2120
[{"NUM_ROOMS":"119","NASF":"39081","PERCENT":"17","DEPT_NAME":"ELECTRICAL & CPTR ENGR"},{"NUM_ROOMS":"102","NASF":"39060","PERCENT":"17","DEPT_NAME":"ENGINEERING DEAN OFC"},{"NUM_ROOMS":"125","NASF":"35763","PERCENT":"16","DEPT_NAME":"MECHANICAL ENGR"},{"NUM_ROOMS":"84","NASF":"28619","PERCENT":"12","DEPT_NAME":"CIVIL & ENVIRON ENG"},{"NUM_ROOMS":"83","NASF":"24437","PERCENT":"11","DEPT_NAME":"CHEMICAL & BIOMOLECULAR"},{"NUM_ROOMS":"77","NASF":"21854","PERCENT":"10","DEPT_NAME":"COMPUTER SCIENCE & ENGR"},{"NUM_ROOMS":"50","NASF":"21247","PERCENT":"9","DEPT_NAME":"CTR CLEAN ENERGY ENGINEER"},{"NUM_ROOMS":"29","NASF":"10874","PERCENT":"5","DEPT_NAME":"CT TRANSPORTATION INST"},{"NUM_ROOMS":"11","NASF":"4964","PERCENT":"2","DEPT_NAME":"MATERIALS SCI & ENGINEER"},{"NUM_ROOMS":"12","NASF":"3332","PERCENT":"1","DEPT_NAME":"PRECISION MANUFACT CTR"},{"NUM_ROOMS":"2","NASF":"279","PERCENT":"0","DEPT_NAME":"ENGINEERING DIVERSTY PROG"},{"NUM_ROOMS":"2","NASF":"256","PERCENT":"0","DEPT_NAME":"CHEM MAT & BIOMOL ENGR"},{"NUM_ROOMS":"1","NASF":"222","PERCENT":"0","DEPT_NAME":"GRINDING CTR"}]
SPACE_METRICS_UNIT_BY_DEPT_BY_BLDG
(test on dev)
format=json
value=2120
[{"NUM_ROOMS":"20","NASF":"25795.33","BUIDING":"HAWLEY ARMORY","DEPT_NAME":"ALLIED HLTH PT"},{"NUM_ROOMS":"1","NASF":"5.18","BUIDING":"KOONS HALL","DEPT_NAME":"ALLIED HEALTH INSTR & RES"},{"NUM_ROOMS":"1","NASF":"112.97","BUIDING":"TORREY LIFE SCIENCES BUILDING","DEPT_NAME":"ALLIED HLTH PT"}]
 SPACE_METRICS_UNIT_BY_DEPT_BY_TYPE
(test on dev)
 format=json
value=2120
[{"NUM_ROOMS":"21","NASF":"3816.65","PERCENT":"1.1","BUILDING":"Office Facilities","DEPT_NAME":"AGRI & RESOURCE ECONOMICS"},{"NUM_ROOMS":"1","NASF":"1214.9","PERCENT":".35","BUILDING":"Classroom Facilities","DEPT_NAME":"AGRI & RESOURCE ECONOMICS"},{"NUM_ROOMS":"2","NASF":"768.77","PERCENT":".22","BUILDING":"Laboratory Facilities","DEPT_NAME":"AGRI & RESOURCE ECONOMICS"},{"NUM_ROOMS":"5","NASF":"973.32","PERCENT":".28","BUILDING":"Office Facilities","DEPT_NAME":"AGRI EXPERIMENT STATION"},{"NUM_ROOMS":"1","NASF":"168.92","PERCENT":".048","BUILDING":"Office Facilities","DEPT_NAME":"AGRI PUBLICATIONS OFC"},{"NUM_ROOMS":"47","NASF":"10772.87","PERCENT":"3.1","BUILDING":"Office Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"38","NASF":"8625.79","PERCENT":"2.5","BUILDING":"Laboratory Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"5","NASF":"1034.55","PERCENT":".3","BUILDING":"Support Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"5","NASF":"867.3","PERCENT":".25","BUILDING":"Special Use Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"4","NASF":"668.01","PERCENT":".19","BUILDING":"General Use Facilities","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"},{"NUM_ROOMS":"2","NASF":"153.91","PERCENT":".044","BUILDING":"UNCLASSIFIED FACILITIES","DEPT_NAME":"AGRI, HLTH & NAT RCS DEAN"}]
SPACE_UNITS
(test on dev)
format=json
[{"UNIT_NAME":"AG, HEALTH & NAT RCS"},{"UNIT_NAME":"ALLIED HEALTH"},{"UNIT_NAME":"ATHLETICS"},{"UNIT_NAME":"AVERY PT REG CAMPUS"},{"UNIT_NAME":"BUSINESS"},{"UNIT_NAME":"CTR CONTINUING STUD"},{"UNIT_NAME":"DINING SERVICES"},{"UNIT_NAME":"ECONOMIC DEVELOPMENT"},{"UNIT_NAME":"EDUCATION"},{"UNIT_NAME":"ENGINEERING"},{"UNIT_NAME":"ENROLL PLAN & MGMT"},{"UNIT_NAME":"EXEC VPRES HEALTH AF"},{"UNIT_NAME":"EXVP ADMIN & CFO"},{"UNIT_NAME":"FACILITIES OPERATION"},{"UNIT_NAME":"FINE ARTS"},{"UNIT_NAME":"GLOBAL AFFAIRS"},{"UNIT_NAME":"HARTFORD REG CAMPUS"},{"UNIT_NAME":"HEALTH SERVICES"},{"UNIT_NAME":"HR & PAYROLL"},{"UNIT_NAME":"LAW"},{"UNIT_NAME":"LIB ARTS & SCIENCES"},{"UNIT_NAME":"LOGISTICS ADMIN"},{"UNIT_NAME":"NURSING"},{"UNIT_NAME":"OFC OF VP & COO"},{"UNIT_NAME":"OFFICE OF CONTROLLER"},{"UNIT_NAME":"PLAN, ARCH, ENG SVCS"},{"UNIT_NAME":"PRESIDENT"},{"UNIT_NAME":"PROCUREMT & LOG SERV"},{"UNIT_NAME":"PROV & EXVP ACAD AFF"},{"UNIT_NAME":"PUBLIC SAFETY"},{"UNIT_NAME":"RESIDENTIAL LIFE"},{"UNIT_NAME":"SCHOOL OF PHARMACY"},{"UNIT_NAME":"SOCIAL WORK"},{"UNIT_NAME":"STAMFORD REG CAMPUS"},{"UNIT_NAME":"STUDENT ACTIVITIES"},{"UNIT_NAME":"STUDENT UNION"},{"UNIT_NAME":"TORRINGTON REG CAMP"},{"UNIT_NAME":"U-CETL AVP"},{"UNIT_NAME":"U-INFRA & PROJ MGMT"},{"UNIT_NAME":"UNDERGRAD EDUCATION"},{"UNIT_NAME":"UNIV INFO TECH SVCS"},{"UNIT_NAME":"UNIVERSITY COMMUNICA"},{"UNIT_NAME":"UNIVERSITY LIBRARIES"},{"UNIT_NAME":"VP FOR RESEARCH"},{"UNIT_NAME":"VPRES STUDENT AFF"},{"UNIT_NAME":"VPROV MULTICULT AFF"},{"UNIT_NAME":"VPROV RES & GRAD ED"},{"UNIT_NAME":"WATERBURY REG CAMPUS"}]
SPACE_METRICS_UNIT_BY_CATS
(test on dev)
format=json
value=2120
[{"NUM_ROOMS":"115","NASF":"80705","PERCENT":"23","CAT_NAME":"Field Bldg","FICM":"560"},{"NUM_ROOMS":"127","NASF":"52852","PERCENT":"15","CAT_NAME":"RESEARCH LABORATORY","FICM":"250"},{"NUM_ROOMS":"161","NASF":"28163","PERCENT":"8.1","CAT_NAME":"STAFF OFFICE","FICM":"310"},{"NUM_ROOMS":"13","NASF":"23972","PERCENT":"6.9","CAT_NAME":"Animal Quarters","FICM":"570"},{"NUM_ROOMS":"26","NASF":"23081","PERCENT":"6.6","CAT_NAME":"Greenhouse","FICM":"580"},{"NUM_ROOMS":"39","NASF":"19781","PERCENT":"5.7","CAT_NAME":"Class Laboratory","FICM":"210"},{"NUM_ROOMS":"103","NASF":"16094","PERCENT":"4.6","CAT_NAME":"FACULTY OFFICE","FICM":"311"},{"NUM_ROOMS":"2","NASF":"13319","PERCENT":"3.8","CAT_NAME":"Assembly","FICM":"610"},{"NUM_ROOMS":"100","NASF":"9795","PERCENT":"2.8","CAT_NAME":"Office Service","FICM":"315"},{"NUM_ROOMS":"50","NASF":"8729","PERCENT":"2.5","CAT_NAME":"Research Laboratory Service","FICM":"255"},{"NUM_ROOMS":"10","NASF":"7254","PERCENT":"2.1","CAT_NAME":"Food Facilities Service","FICM":"635"},{"NUM_ROOMS":"19","NASF":"6740","PERCENT":"1.9","CAT_NAME":"Grhs Serv","FICM":"585"},{"NUM_ROOMS":"28","NASF":"6496","PERCENT":"1.9","CAT_NAME":"GRAD\/STUDENT OFFICE","FICM":"312"},{"NUM_ROOMS":"10","NASF":"6363","PERCENT":"1.8","CAT_NAME":"Classroom","FICM":"110"},{"NUM_ROOMS":"17","NASF":"6042","PERCENT":"1.7","CAT_NAME":"Conference Room","FICM":"350"},{"NUM_ROOMS":"2","NASF":"5158","PERCENT":"1.5","CAT_NAME":"Other (All Purposes)","FICM":"590"},{"NUM_ROOMS":"4","NASF":"5052","PERCENT":"1.4","CAT_NAME":"Shop","FICM":"720"},{"NUM_ROOMS":"14","NASF":"4469","PERCENT":"1.3","CAT_NAME":"Animal Quarters Service","FICM":"575"},{"NUM_ROOMS":"18","NASF":"4442","PERCENT":"1.3","CAT_NAME":"INACTIVE AREA","FICM":"050"},{"NUM_ROOMS":"13","NASF":"3674","PERCENT":"1.1","CAT_NAME":"Central Storage","FICM":"730"},{"NUM_ROOMS":"26","NASF":"3144","PERCENT":".9","CAT_NAME":"Class Laboratory Service","FICM":"215"},{"NUM_ROOMS":"1","NASF":"2222","PERCENT":".64","CAT_NAME":"Assembly Service","FICM":"615"},{"NUM_ROOMS":"6","NASF":"1500","PERCENT":".43","CAT_NAME":"Lounge","FICM":"650"},{"NUM_ROOMS":"2","NASF":"1103","PERCENT":".32","CAT_NAME":"ALTERATION OR CONVERSION AREA","FICM":"060"},{"NUM_ROOMS":"1","NASF":"1085","PERCENT":".31","CAT_NAME":"Ath\/P.E.","FICM":"520"},{"NUM_ROOMS":"5","NASF":"1077","PERCENT":".31","CAT_NAME":"Mechanical","FICM":"YYY"},{"NUM_ROOMS":"6","NASF":"1003","PERCENT":".29","CAT_NAME":"Cold Room","FICM":"258"},{"NUM_ROOMS":"2","NASF":"725","PERCENT":".21","CAT_NAME":"Meeting Room","FICM":"680"},{"NUM_ROOMS":"2","NASF":"712","PERCENT":".2","CAT_NAME":"Merchandising Service","FICM":"665"},{"NUM_ROOMS":"2","NASF":"680","PERCENT":".19","CAT_NAME":"Food Facilities","FICM":"630"},{"NUM_ROOMS":"1","NASF":"652","PERCENT":".19","CAT_NAME":"Open-Stack Study Room","FICM":"430"},{"NUM_ROOMS":"4","NASF":"638","PERCENT":".18","CAT_NAME":"Shop Service","FICM":"725"},{"NUM_ROOMS":"3","NASF":"590","PERCENT":".17","CAT_NAME":"Study Room","FICM":"410"},{"NUM_ROOMS":"3","NASF":"556","PERCENT":".16","CAT_NAME":"Media Production","FICM":"530"},{"NUM_ROOMS":"1","NASF":"299","PERCENT":".086","CAT_NAME":"Open Laboratory","FICM":"220"},{"NUM_ROOMS":"2","NASF":"271","PERCENT":".078","CAT_NAME":"Central Computer or Telecomm S","FICM":"715"},{"NUM_ROOMS":"2","NASF":"232","PERCENT":".066","CAT_NAME":"Central Computer or Telecommun","FICM":"710"},{"NUM_ROOMS":"1","NASF":"212","PERCENT":".061","CAT_NAME":"Merchandising","FICM":"660"},{"NUM_ROOMS":"1","NASF":"139","PERCENT":".04","CAT_NAME":"Bldg Serv","FICM":"XXX"},{"NUM_ROOMS":"2","NASF":"127","PERCENT":".036","CAT_NAME":"Classroom Service","FICM":"115"},{"NUM_ROOMS":"1","NASF":"114","PERCENT":".033","CAT_NAME":"Hazardous Materials","FICM":"760"},{"NUM_ROOMS":"1","NASF":"112","PERCENT":".032","CAT_NAME":"Hazardous Materials Service","FICM":"765"},{"NUM_ROOMS":"1","NASF":"86","PERCENT":".025","CAT_NAME":"Lounge Service","FICM":"655"},{"NUM_ROOMS":"1","NASF":"59","PERCENT":".017","CAT_NAME":"Locker Rm","FICM":"690"},{"NUM_ROOMS":"2","NASF":"38","PERCENT":".011","CAT_NAME":"Meeting Room Service","FICM":"685"},{"NUM_ROOMS":"1","NASF":"14","PERCENT":".004","CAT_NAME":"Conference Room Service","FICM":"355"}]
BLDG_LITE (test on test) format=json
value=SITE_CODE
range=02
{"SITE_NAME":"HARTFORD REGIONAL CAMPUS","SITE_CODE":"02","FACILITY_CODE":"3201","FACILITY_NAME":"GHC-UNDERGRADUATE BLDG - W.HTFD","ACTIVE_FLAG":"Y","RENO_YEAR":"UNKNOWN","NET_SQFT":"62386.58","GROSS_SQFT":"69474.71","ASSIGNABLE":"37492.39","STREET":"85 LAWLER ROAD","CITY":"HARTFORD","OWNVLEASE":null,"ACQUIRED":null,"BLDG_TYPE":"BUILDING","BLDG_YEAR":"1971","HISTORICAL":null,"JUST_PREV_CT_FY":null,"JUST_REACT_FY":null,"PM_HOURS_FY":"48.5","REACT_HRS_FY":"202.5"},{"SITE_NAME":"HARTFORD REGIONAL CAMPUS","SITE_CODE":"02","FACILITY_CODE":"3202","FACILITY_NAME":"GHC-SCHOOL OF SOCIAL WORK - W HTFD","ACTIVE_FLAG":"Y","RENO_YEAR":"UNKNOWN","NET_SQFT":"33442.61","GROSS_SQFT":"38476.05","ASSIGNABLE":"21451.1","STREET":"1798 ASYLUM AVE","CITY":"HARTFORD","OWNVLEASE":null,"ACQUIRED":null,"BLDG_TYPE":"BUILDING","BLDG_YEAR":"1968","HISTORICAL":null,"JUST_PREV_CT_FY":null,"JUST_REACT_FY":null,"PM_HOURS_FY":"21.5","REACT_HRS_FY":"165.55"}...]
Place the comma separated field name(s) to filter on the value field & the comma separated value(s) in the range field to get matching data
SITES_BY_UCONN (test)  format=json

[{“SITE_CODE”:”01″,”DESCRIPTION”:”STORRS CAMPUS”},
{“SITE_CODE”:”02″,”DESCRIPTION”:”HARTFORD REGIONAL CAMPUS”},
{“SITE_CODE”:”03″,”DESCRIPTION”:”STAMFORD REGIONAL  CAMPUS”},
{“SITE_CODE”:”04″,”DESCRIPTION”:”TORRINGTON REGIONAL  CAMPUS”},
{“SITE_CODE”:”05″,”DESCRIPTION”:”WATERBURY REGIONAL  CAMPUS”},
{“SITE_CODE”:”06″,”DESCRIPTION”:”AVERY POINT REGIONAL  CAMPUS”},
{“SITE_CODE”:”07″,”DESCRIPTION”:”UCONN HEALTH CENTER”},
{“SITE_CODE”:”08″,”DESCRIPTION”:”COOPERATIVE EXTENSIONS”}]

BLDGS_BY_SITE (test) format=json
value=02

[{“SITE”:”02″,”BLDG_CODE”:”7327″,”BLDG_NAME”:”125 Signourney St”},
{“SITE”:”02″,”BLDG_CODE”:”3401″,”BLDG_NAME”:”Downtown Hartford”},
{“SITE”:”02″,”BLDG_CODE”:”3402″,”BLDG_NAME”:”Downtown Hartford”},
{“SITE”:”02″,”BLDG_CODE”:”3221″,”BLDG_NAME”:”Downtown Hartford – Prospect St”},
{“SITE”:”02″,”BLDG_CODE”:”3205″,”BLDG_NAME”:”Ghc-Computer Ctr & Classroom Bldg”},
{“SITE”:”02″,”BLDG_CODE”:”3204A”,”BLDG_NAME”:”Ghc-Fac\/Landscape Garage Add. – Wh”},
{“SITE”:”02″,”BLDG_CODE”:”3204″,”BLDG_NAME”:”Ghc-Facilities Garage – W Htfd”},
{“SITE”:”02″,”BLDG_CODE”:”3203″,”BLDG_NAME”:”Ghc-Harleigh B Trecker Library”},
{“SITE”:”02″,”BLDG_CODE”:”3202″,”BLDG_NAME”:”Ghc-School Of Social Work – W Htfd”},
{“SITE”:”02″,”BLDG_CODE”:”3201″,”BLDG_NAME”:”Ghc-Undergraduate Bldg – W.Htfd”},
{“SITE”:”02″,”BLDG_CODE”:”3220″,”BLDG_NAME”:”Hartford Times Building”},
{“SITE”:”02″,”BLDG_CODE”:”3314″,”BLDG_NAME”:”Htfd Law School-Cheryl A Chase Hall”},
{“SITE”:”02″,”BLDG_CODE”:”3313″,”BLDG_NAME”:”Htfd Law School-Hosmer Hall”},
{“SITE”:”02″,”BLDG_CODE”:”3315″,”BLDG_NAME”:”Htfd Law School-Knight Hall”},
{“SITE”:”02″,”BLDG_CODE”:”3317″,”BLDG_NAME”:”Htfd Law School-Law Library”},
{“SITE”:”02″,”BLDG_CODE”:”3316″,”BLDG_NAME”:”Htfd Law School-Starr Hall”},
{“SITE”:”02″,”BLDG_CODE”:”7324″,”BLDG_NAME”:”Mba Program”},
{“SITE”:”02″,”BLDG_CODE”:”7325″,”BLDG_NAME”:”Rudd Center”},
{“SITE”:”02″,”BLDG_CODE”:”7326″,”BLDG_NAME”:”Uconn Chatter Hartford”}]

FLOORS_BY_BLDG (test)  format=json
value=3201

[{“BLDG_CODE”:”3201″,”FLOOR”:”00″},
{“BLDG_CODE”:”3201″,”FLOOR”:”01″},
{“BLDG_CODE”:”3201″,”FLOOR”:”02″},
{“BLDG_CODE”:”3201″,”FLOOR”:”03″}]

ROOMS_BY_FLOOR (test) format=json
value=0505
range=08

[{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”801″,”ROOM_DESC”:”CUSTODIAL CLOSET”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”802″,”ROOM_DESC”:”POSTDOC APPARTMENT”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”802A”,”ROOM_DESC”:null},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”803″,”ROOM_DESC”:”POSTDOC APARTMENT”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”803A”,”ROOM_DESC”:null},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”840″,”ROOM_DESC”:”LOUNGE”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”841″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”842″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”843″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”844″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”845″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”846″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”847″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”848″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”849″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”850″,”ROOM_DESC”:”DORM ROOM”},
{“BLDG”:”0505″,”FLOOR”:”08″,”ROOM”:”851″,”ROOM_DESC”:”DORM ROOM”},…]

ACTIVE_ROOMS (dev) format=json
value=BUILDING,FLOOR
range=0001,01
[{"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"105","SQR_FEET":"124.47","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Faculty Office","FICM":"311","ROOM_BILLING_ID":"156779"},
{"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"110","SQR_FEET":"117.96","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Faculty Office","FICM":"311","ROOM_BILLING_ID":"156788"},
{"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"111","SQR_FEET":"101.38","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Faculty Office","FICM":"311","ROOM_BILLING_ID":"156789"},
{"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"109","SQR_FEET":"125.46","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Faculty Office","FICM":"311","ROOM_BILLING_ID":"156787"},
{"SITE":null,"CAMPUS":"STORRS CAMPUS","BLDG_NAME":"Storrs Hall","BUILDING":"0001","FLOOR":"01","ROOM":"118","SQR_FEET":"348.13","SUB_DEPT":"Nursing Instr & Res","GROUP_CODE":"22320AA","SPACE_TYPE":"Conference Room","FICM":"350","ROOM_BILLING_ID":"156782"},

BLDG_ALIASES (test)  format=json
value=NULL
range=01
[{"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"SWG STA - WPCF OPERATIONS  BUILDING","F_CODE":"0388","A_TYPE":"PRIMARY","A_CODE":null,"A_DESCRIPTON":"SWG STA - CONTROL BUILDING","LATITUDE":"41.81187805","LONGITUDE":"-72.26477373"},
{"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"ARCH AND ENG SVCS","F_CODE":"0387","A_TYPE":"Communications","A_CODE":"AES","A_DESCRIPTON":"Architectural and Engineering Services","LATITUDE":"41.81115976","LONGITUDE":"-72.26289799"},
{"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"AVIAN RESEARCH BUILDING","F_CODE":"1124","A_TYPE":"Communications","A_CODE":"ARF","A_DESCRIPTON":"Avian Research Facility","LATITUDE":"41.81553083","LONGITUDE":"-72.2412705"},
{"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"DAIRY BARN & SILO","F_CODE":"0005","A_TYPE":"Communications","A_CODE":"BARN","A_DESCRIPTON":"Dairy Barn","LATITUDE":"41.81370409","LONGITUDE":"-72.25163274"},
{"CAMPUS":"01","CAMPUS_NAME":"STORRS CAMPUS","NAME":"BURTON FOOTBALL COMPLEX & SHENKMAN","F_CODE":"0480","A_TYPE":"Communications","A_CODE":"BFFC","A_DESCRIPTON":"Burton Family Football Complex","LATITUDE":"41.80286081","LONGITUDE":"-72.25486441"},

EMPLOYEE Related Web Services

EMP_REPORTS_TO
(test on dev)
 format=json
value=LAB10002
[{"EMPLOYEE":"LAB10002","NAME":"JUENGER, LARA","SUBDEPARTMENT":"24204AA","SUB_DEPT_NAME":"ENTERPRISE ADMIN SYSTE GENERAL","DEPARTMENT":"24204","DEPT_NAME":"ENTERPRISE ADMIN SYSTEMS","UNIT":"2039","UNIT_NAME":"UNIVERSITY INFO TECH SERVICES"}]

OTHER Web Services

Method Parameters Example Output
GOODBYE
CREWS
ZONES
ZONE_ASSIGN
LIST_CREWS
LIST_CREWS_DETAIL
LIST_ZONE_DETAIL
ASSIGNMENTS
ZONEASSIGNMENTS
ACT_PRIORITY ‘R’ ‘PM’
ACT_PRIORITY_ZONE ‘R’ ‘PM’ ACT_NEW ‘R’ ‘PM’
ACT_NEW_ZONE ‘R’ ‘PM’
ACT_PARTS ‘R’ ‘PM’
ACT_PARTS_ZONE ‘R’ ‘PM’
ACT_UNASSIGNED ‘R’ ‘PM’
ACT_UNASSIGNED_ZONE ‘R’ ‘PM’
ACT_AGING ‘R’ ‘PM’ 1 2 3 4 5
ACT_AGING_ZONE ‘R’ ‘PM’ 1 2 3 4 5
REC_OPEN ‘R’ ‘PM’
REC_CLOSE ‘R’ ‘PM’
REC_COMPLETE ‘R’ ‘PM’
REC_OPEN_ZONE ‘R’ ‘PM’
REC_CLOSE_ZONE ‘R’ ‘PM’
REC_COMPLETE_ZONE ‘R’ ‘PM’
ACT_ASSIGNED_ZONE
ACT_ASSIGNED
ACT_BUILDING
ACT_BUILDING_ZONE
ACT_BUILDING_SUBZONE
BLDG_WOS
BLDG_ALIASES
WEATHER
CURRENT_WEATHER
COMP_ASSIGN
ACT_BY_MAINT
BACKLOG_BY_CREW
CLOSED_BY_CREW
OPENED_BY_CREW
SITES_BY_UCONN
BLDGS_BY_SITE
FLOORS_BY_BLDG
FLOORS_BY_BLDG_BY_ROOM
ROOMS_BY_FLOOR
MY_CREW
THE_BULLETIN
FAC_BLDG_HRS_WT_FY
FAC_BLDG_HRS_FY
FAC_BLDG_CT_FY
FAC_BLDG_CT_WEEK
FAC_BLDG_COST_FY
FAC_BLDG_COST_LAST_MONTH
NEAREST_BUILDING
CENTER_OF_BUILDING
SPACE_DEPTS_IN_BLDG
SPACE_FICMS_IN_BLDG
SPACE_FICMS
SPACE_METRICS_IN_BLDG
SPACE_METRICS_UNIT_BY_BLDG
SPACE_METRICS_UNIT_BY_DEPT
SPACE_METRICS_UNIT_BY_DEPT_BY_BLDG
SPACE_METRICS_UNIT_BY_DEPT_BY_TYPE
SPACE_UNITS
SPACE_PERSONNEL
SPACE_PERSONNEL_FORMAT
SPACE_PERSONNEL_IN_UNIT
SPACE_INACTIVE_PEOPLE_IN_UNIT
SPACE_PERSONNEL_BY_BLDG
SPACE_ROOM_DETAIL_BY_UNIT
SPACE_ROOM_DETAIL_BY_BLDG
SPACE_ROOM_DETAIL_BY_FICM
SPACE_CLASSROOMS
SPACE_RESIDENTIAL
SPACE_BLDG_CONTACTS
SPACE_ROOM_CONTACTS
SPACE_PIS
SPACE_BLDG_EQUIP
SPACE_CPS
FLOORPLAN_AVAIL
SPACE_BLDG_IMGS
EMP_REPORTS_TO
SPACE_METRICS_UNIT_BY_CATS
SPACE_METRICS_BLDGS_BY_CATS
SPACE_ASBESTOS
LIST_ASBESTOS_ASSESSMENTS
FAMIS_REQUESTOR
FAMIS_REQUESTOR_TEST
PRINT_WO_FLAG
REFRESH_PRINT_WO_FLAG
MOBILE_SR_LIST
METRICS_RECENT_SR_CREATE
CHECK_PERMS
METRICS_SR_CREATE_COMPLEX
CP_BUDGETS
CP_POS
MART_UPDATE_STATUS
ALL_METRICS
OTHER_METRICS
SS_METRICS
MOBILE_METRICS
FAC_HEATMAPS
FAC_CREW_HEATMAPS
FAC_CREW_HEATMAPS_R
FAC_CREW_HEAT_FY_R
FAC_CREW_HEAT_FY
FELIX
FELIX_BLDGS
FELIX_CAT
FELIX_SUBCAT
FAC_OPS_WEEKS
CREWED_EMPS
LABOR_DETAILS
WORK_ORDER_LITE
BLDG_LITE
GET_WO_STATUSES
GET_ONE_WO
MP_PROJ_SUMMARY
MP_PROJ_DETAILS