Mapping and Space Information webREPORTS v7

Select tables Archive_Inv_Bldgs Archive_Inv_OrgUnits Archive_Inv_Rooms Archive_RmInv_SystPart_FCode Archive_Space_Bldg Archive_Space_Bldg_Flr Archive_Space_Bldg_Flr_Rm Archive_Space_Bldg_OrgUnit Archive_Space_Bldg_OrgUnit_SystPart Archive_Space_Bldg_SystPart Archive_Space_SystPart_LocType Current_Inv_Bldgs Current_Inv_OrgUnits CURRENT_INV_ROOMS Current_RmInv_SystPart_FCode Current_Space_Bldg Current_Space_Bldg_Flr Current_Space_Bldg_Flr_Rm Current_Space_Bldg_OrgUnit Current_Space_Bldg_OrgUnit_SystPart Current_Space_Bldg_SystPart Current_Space_SystPart_LocType	Select fields you wish to display  Year  Bldg  BldgAbbr  BldgName  Floor  Room  LocCode  LocDesc  LocType  LocTypeDesc  SF  RmCode  RmSummaryType  RmDesc  STEM  SOrgUnit  SOrgName  MajorOrgUnit  MajorOrgName  OrgUnit  OrgName  FamisAcctCode1  FamisAcctCode2  FamisAcctCode3  FunctCode1  FunctCat1  FunctDesc1  FunctCode2  FunctCat2  FunctDesc2  FunctCode3  FunctCat3  FunctDesc3  SystPart1  SystPartName1  SystPart2  SystPartName2  SystPart3  SystPartName3  Prorate1  Prorate2  Prorate3  Capacity	Add criteria to display Where Show AllYearBldgBldgAbbrBldgNameFloorRoomLocCodeLocDescLocTypeLocTypeDescSFRmCodeRmSummaryTypeRmDescSTEMSOrgUnitSOrgNameMajorOrgUnitMajorOrgNameOrgUnitOrgNameFamisAcctCode1FamisAcctCode2FamisAcctCode3FunctCode1FunctCat1FunctDesc1FunctCode2FunctCat2FunctDesc2FunctCode3FunctCat3FunctDesc3SystPart1SystPartName1SystPart2SystPartName2SystPart3SystPartName3Prorate1Prorate2Prorate3Capacity Condition  containsis equal tois less thanis greater thanstarts withends with Value And/Or   AND OR Where Show AllYearBldgBldgAbbrBldgNameFloorRoomLocCodeLocDescLocTypeLocTypeDescSFRmCodeRmSummaryTypeRmDescSTEMSOrgUnitSOrgNameMajorOrgUnitMajorOrgNameOrgUnitOrgNameFamisAcctCode1FamisAcctCode2FamisAcctCode3FunctCode1FunctCat1FunctDesc1FunctCode2FunctCat2FunctDesc2FunctCode3FunctCat3FunctDesc3SystPart1SystPartName1SystPart2SystPartName2SystPart3SystPartName3Prorate1Prorate2Prorate3Capacity Condition  containsis equal tois less thanis greater thanstarts withends with Value And/Or   AND OR Where Show AllYearBldgBldgAbbrBldgNameFloorRoomLocCodeLocDescLocTypeLocTypeDescSFRmCodeRmSummaryTypeRmDescSTEMSOrgUnitSOrgNameMajorOrgUnitMajorOrgNameOrgUnitOrgNameFamisAcctCode1FamisAcctCode2FamisAcctCode3FunctCode1FunctCat1FunctDesc1FunctCode2FunctCat2FunctDesc2FunctCode3FunctCat3FunctDesc3SystPart1SystPartName1SystPart2SystPartName2SystPart3SystPartName3Prorate1Prorate2Prorate3Capacity Condition  containsis equal tois less thanis greater thanstarts withends with Value
Show SQL SQL = Select * From [Current_Inv_Rooms] Order By [SystPartName2]		Export Report EXCEL | CSV | TEXT | XML

---

Showing page 1 of 15694:  Entries 1 - 5 of  78467 Records...

Page Size

Year	Bldg	BldgAbbr	BldgName	Floor	Room	LocCode	LocDesc	LocType	LocTypeDesc	SF	RmCode	RmSummaryType	RmDesc	STEM	SOrgUnit	SOrgName	MajorOrgUnit	MajorOrgName	OrgUnit	OrgName	FamisAcctCode1	FamisAcctCode2	FamisAcctCode3	FunctCode1	FunctCat1	FunctDesc1	FunctCode2	FunctCat2	FunctDesc2	FunctCode3	FunctCat3	FunctDesc3	SystPart1	SystPartName1	SystPart2	SystPartName2	SystPart3	SystPartName3	Prorate1	Prorate2	Prorate3	Capacity
2024C	0507	VMS	Veterinary Medical Sciences Building	02	203	C1	Vet School Area	CS	College Station	460	250A	Research Lab	RESEARCH LABORATORY	N	3	Provost, VP Acad Affairs, Chief Acad Officer	90	School of Veterinary Medicine/Biomedical Sciences	09030	VMBS-Veterinary Pathobiology				21	RESEARCH	INSTITUTES AND RESEARCH CENTERS	11	INSTRUCTION	GENERAL ACADEMIC INSTRUCTION (DEGREE RELATED)	00			06	Texas A&M AgriLife Research	97	College of Veterinary Medicine	00	NULL	70	30	0	0
2024C	0507	VMS	Veterinary Medical Sciences Building	02	203A	C1	Vet School Area	CS	College Station	102	255A	Research Lab Service	RESEARCH LAB SERVICE	N	3	Provost, VP Acad Affairs, Chief Acad Officer	90	School of Veterinary Medicine/Biomedical Sciences	09030	VMBS-Veterinary Pathobiology				21	RESEARCH	INSTITUTES AND RESEARCH CENTERS	11	INSTRUCTION	GENERAL ACADEMIC INSTRUCTION (DEGREE RELATED)	00			06	Texas A&M AgriLife Research	97	College of Veterinary Medicine	00	NULL	70	30	0	0
2024C	0507	VMS	Veterinary Medical Sciences Building	02	206B	C1	Vet School Area	CS	College Station	190	310B	Office	FACULTY OFFICE	N	3	Provost, VP Acad Affairs, Chief Acad Officer	90	School of Veterinary Medicine/Biomedical Sciences	09005	Dean-School of Vet Med & Biomedical Sciences				21	RESEARCH	INSTITUTES AND RESEARCH CENTERS	11	INSTRUCTION	GENERAL ACADEMIC INSTRUCTION (DEGREE RELATED)	00			06	Texas A&M AgriLife Research	97	College of Veterinary Medicine	00	NULL	75	25	0	0
2024C	0507	VMS	Veterinary Medical Sciences Building	02	208	C1	Vet School Area	CS	College Station	270	310D	Office	GRADUATE ASSISTANT OFFICE	N	3	Provost, VP Acad Affairs, Chief Acad Officer	90	School of Veterinary Medicine/Biomedical Sciences	09030	VMBS-Veterinary Pathobiology				21	RESEARCH	INSTITUTES AND RESEARCH CENTERS	11	INSTRUCTION	GENERAL ACADEMIC INSTRUCTION (DEGREE RELATED)	00			06	Texas A&M AgriLife Research	97	College of Veterinary Medicine	00	NULL	80	20	0	4
2024C	0507	VMS	Veterinary Medical Sciences Building	02	209	C1	Vet School Area	CS	College Station	323	310B	Office	FACULTY OFFICE	N	3	Provost, VP Acad Affairs, Chief Acad Officer	90	School of Veterinary Medicine/Biomedical Sciences	09005	Dean-School of Vet Med & Biomedical Sciences				21	RESEARCH	INSTITUTES AND RESEARCH CENTERS	11	INSTRUCTION	GENERAL ACADEMIC INSTRUCTION (DEGREE RELATED)	00			06	Texas A&M AgriLife Research	97	College of Veterinary Medicine	00	NULL	80	20	0	0

Result Page: 1  2  3  4  5  6  7  8  9  10  ... 15694  Next

Records to be used as unofficial reference only. Not official records.