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  BldgName  Floor  Room  SF_Room  Capacity  RmCode  RmSummaryType  RmDesc  LocCode  LocDesc  LocType  LocTypeDesc  MaintZone  SOrgUnit  SOrgName  MajorOrgUnit  MajorOrgName  OrgUnit  OrgName  STEM  SystPart  SystPartName  FunctCode  FunctCat  FunctDesc  Prorate  SF  ASF  E&G  Non E&G  Unclass  Gross  Gross E&G  Gross Non E&G  Gross Unclass  Gross %  Gross E&G %  Gross Non E&G %  Gross Unclass %	Add criteria to display Where Show AllYearBldgBldgNameFloorRoomSF_RoomCapacityRmCodeRmSummaryTypeRmDescLocCodeLocDescLocTypeLocTypeDescMaintZoneSOrgUnitSOrgNameMajorOrgUnitMajorOrgNameOrgUnitOrgNameSTEMSystPartSystPartNameFunctCodeFunctCatFunctDescProrateSFASFE&GNon E&GUnclassGrossGross E&GGross Non E&GGross UnclassGross %Gross E&G %Gross Non E&G %Gross Unclass % Condition  containsis equal tois less thanis greater thanstarts withends with Value And/Or   AND OR Where Show AllYearBldgBldgNameFloorRoomSF_RoomCapacityRmCodeRmSummaryTypeRmDescLocCodeLocDescLocTypeLocTypeDescMaintZoneSOrgUnitSOrgNameMajorOrgUnitMajorOrgNameOrgUnitOrgNameSTEMSystPartSystPartNameFunctCodeFunctCatFunctDescProrateSFASFE&GNon E&GUnclassGrossGross E&GGross Non E&GGross UnclassGross %Gross E&G %Gross Non E&G %Gross Unclass % Condition  containsis equal tois less thanis greater thanstarts withends with Value And/Or   AND OR Where Show AllYearBldgBldgNameFloorRoomSF_RoomCapacityRmCodeRmSummaryTypeRmDescLocCodeLocDescLocTypeLocTypeDescMaintZoneSOrgUnitSOrgNameMajorOrgUnitMajorOrgNameOrgUnitOrgNameSTEMSystPartSystPartNameFunctCodeFunctCatFunctDescProrateSFASFE&GNon E&GUnclassGrossGross E&GGross Non E&GGross UnclassGross %Gross E&G %Gross Non E&G %Gross Unclass % Condition  containsis equal tois less thanis greater thanstarts withends with Value
Show SQL SQL = Select * From [Current_RmInv_SystPart_FCode] Order By [Gross E&G] Desc		Export Report EXCEL | CSV | TEXT | XML

---

Showing page 1 of 17085:  Entries 1 - 5 of  85423 Records...

Page Size

Year	Bldg	BldgName	Floor	Room	SF_Room	Capacity	RmCode	RmSummaryType	RmDesc	LocCode	LocDesc	LocType	LocTypeDesc	MaintZone	SOrgUnit	SOrgName	MajorOrgUnit	MajorOrgName	OrgUnit	OrgName	STEM	SystPart	SystPartName	FunctCode	FunctCat	FunctDesc	Prorate	SF	ASF	E&G	Non E&G	Unclass	Gross	Gross E&G	Gross Non E&G	Gross Unclass	Gross %	Gross E&G %	Gross Non E&G %	Gross Unclass %
2024C	0271	Polo Road Garage	01	114	2891	0	730A	Support	CENTRAL STORAGE	A1	East Campus	CS	College Station		2	TAMU - President	19	VP-Operations	01990-002	FAM-To Verify Tier 2	N	02	Texas A&M University	63	ADMINISTRATION	GENERAL ADMINISTRATION AND LOGISTICAL SERVICES	100	2891	2891	2891	0	0	509650.5	509650.5	0	0	0.9313788	0.9313788	0	0
2024C	0468	Sterling C. Evans Library	04	1.401	66760	795	430A	Study	OPEN STACK STUDY ROOM	A1	East Campus	CS	College Station	1	3	Provost, Exec VP Acad Affairs, Chief Acad Officer	10	Provost & Exec VP for Acad Affairs	01040	Evans Library	N	02	Texas A&M University	41	ACAD SUPPT	LIBRARY SERVICES	100	66760	66760	66760	0	0	100157.4	100157.4	0	0	0.1406522	0.1406522	0	0
2024C	0468	Sterling C. Evans Library	03	1.301	66512	800	430A	Study	OPEN STACK STUDY ROOM	A1	East Campus	CS	College Station	1	3	Provost, Exec VP Acad Affairs, Chief Acad Officer	10	Provost & Exec VP for Acad Affairs	01040	Evans Library	N	02	Texas A&M University	41	ACAD SUPPT	LIBRARY SERVICES	100	66512	66512	66512	0	0	99785.38	99785.38	0	0	0.1401297	0.1401297	0	0
2024C	0468	Sterling C. Evans Library	05	1.501	31373	450	430A	Study	OPEN STACK STUDY ROOM	A1	East Campus	CS	College Station	1	3	Provost, Exec VP Acad Affairs, Chief Acad Officer	10	Provost & Exec VP for Acad Affairs	01040	Evans Library	N	02	Texas A&M University	41	ACAD SUPPT	LIBRARY SERVICES	100	31373	31373	31373	0	0	47067.7	47067.7	0	0	6.609768E-02	6.609768E-02	0	0
2024C	0957	Purchasing & Stores	01	WHS	40698	0	730A	Support	CENTRAL STORAGE	C1	Vet School Area	CS	College Station	5	2	TAMU - President	20	Finance & Business Services	02058	Department of Logistics	N	02	Texas A&M University	63	ADMINISTRATION	GENERAL ADMINISTRATION AND LOGISTICAL SERVICES	100	40698	40698	40698	0	0	46467.59	46467.59	0	0	0.5631616	0.5631616	0	0

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

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