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  SOrgUnit  SOrgName  MajorOrgUnit  MajorOrgName  OrgUnit  OrgName  STEM  LocCode  LocDesc  LocType  LocTypeDesc  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 %  A	Add criteria to display Where Show AllYearBldgBldgNameSOrgUnitSOrgNameMajorOrgUnitMajorOrgNameOrgUnitOrgNameSTEMLocCodeLocDescLocTypeLocTypeDescASFE&GNon E&GUnclassGrossGross E&GGross Non E&GGross UnclassGross %Gross E&G %Gross Non E&G %Gross Unclass %A Condition  containsis equal tois less thanis greater thanstarts withends with Value And/Or   AND OR Where Show AllYearBldgBldgNameSOrgUnitSOrgNameMajorOrgUnitMajorOrgNameOrgUnitOrgNameSTEMLocCodeLocDescLocTypeLocTypeDescASFE&GNon E&GUnclassGrossGross E&GGross Non E&GGross UnclassGross %Gross E&G %Gross Non E&G %Gross Unclass %A Condition  containsis equal tois less thanis greater thanstarts withends with Value And/Or   AND OR Where Show AllYearBldgBldgNameSOrgUnitSOrgNameMajorOrgUnitMajorOrgNameOrgUnitOrgNameSTEMLocCodeLocDescLocTypeLocTypeDescASFE&GNon E&GUnclassGrossGross E&GGross Non E&GGross UnclassGross %Gross E&G %Gross Non E&G %Gross Unclass %A Condition  containsis equal tois less thanis greater thanstarts withends with Value
Show SQL SQL = Select * From [Archive_Space_Bldg_OrgUnit] Order By [STEM] Desc		Export Report EXCEL | CSV | TEXT | XML

---

Showing page 1 of 18616:  Entries 1 - 5 of  93076 Records...

Page Size

Year	Bldg	BldgName	SOrgUnit	SOrgName	MajorOrgUnit	MajorOrgName	OrgUnit	OrgName	STEM	LocCode	LocDesc	LocType	LocTypeDesc	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 %	A
2008A	0518	ZACHRY ENGINEERING CENTER			70	Dean-Engineering	07000	DEAN-COLLEGE OF ENGINEERING	Y	A1	Main Campus	CS	College Station	21225	19649	1576	0	33355.25	30878.55	2476.696	0	0.1028214	9.518665E-02	7.634697E-03	0
2008A	0518	ZACHRY ENGINEERING CENTER			70	Dean-Engineering	07003	BIOMEDICAL ENGINEERING	Y	A1	Main Campus	CS	College Station	18046	18046	0	0	28359.42	28359.42	0	0	8.742116E-02	8.742116E-02	0	0
2008A	0518	ZACHRY ENGINEERING CENTER			70	Dean-Engineering	07008	ELECTRICAL ENGINEERING	Y	A1	Main Campus	CS	College Station	56294	55933	361	0	88466.44	87899.13	567.3142	0	0.2727079	0.2709591	1.748811E-03	0
2008A	0521	HELDENFELS HALL			85	Dean-Science	08500	DEAN-COLLEGE OF SCIENCE	Y	A1	Main Campus	CS	College Station	1620	1620	0	0	2517.881	2517.881	0	0	2.399147E-02	2.399147E-02	0	0
2008A	0521	HELDENFELS HALL			85	Dean-Science	08530	CHEMISTRY	Y	A1	Main Campus	CS	College Station	18507	18507	0	0	28764.46	28764.46	0	0	0.2740803	0.2740803	0	0

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

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