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 [FunctCode]		Export Report EXCEL | CSV | TEXT | XML

---

Showing page 8 of 17192:  Entries 36 - 40 of  85959 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	A735	Mesquite	01	122	28	0	010A	Non-assignable	CUSTODIAL ROOM	MQ	Mesquite	NBC	Non Brazos County		1	TAMUS - Chancellor	08N	VC-Engineering	12075-040	TEEX NBC Non-Assignable Space-Mesquite/Dallas	N	09	Texas A&M Engineering Extension Service	01	NON ASSIGNABLE	CUSTODIAL ROOM	100	28	0	0	0	0	0	0	0	0	0	0	0	0
2024C	A735	Mesquite	02	214	42	0	010A	Non-assignable	CUSTODIAL ROOM	MQ	Mesquite	NBC	Non Brazos County		1	TAMUS - Chancellor	08N	VC-Engineering	12075-040	TEEX NBC Non-Assignable Space-Mesquite/Dallas	N	09	Texas A&M Engineering Extension Service	01	NON ASSIGNABLE	CUSTODIAL ROOM	100	42	0	0	0	0	0	0	0	0	0	0	0	0
2024C	A778	TVMDL-Gonzales Laboratory	01	103	30	0	010A	Non-assignable	CUSTODIAL ROOM	GZ	Gonzales	NBC	Non Brazos County		1	TAMUS - Chancellor	89	Texas Veterinary Medical Diagnostic Lab	08909-099	TVMDL Non-Assignable Space-NBC	N	20	Texas A&M Veterinary Medical Diagnostic Lab	01	NON ASSIGNABLE	CUSTODIAL ROOM	100	30	0	0	0	0	0	0	0	0	0	0	0	0
2024C	0375	Williams Alumni Center	01	A109	56	0	010A	Non-assignable	CUSTODIAL ROOM	A1	East Campus	CS	College Station	3	8	Non-System	91	Non-System Nonassignable	09199	NTAMU Non-Assignable Space	N	99	Non TAMU System Organization Units	01	NON ASSIGNABLE	CUSTODIAL ROOM	100	56	0	0	0	0	0	0	0	0	0	0	0	0
2024C	0375	Williams Alumni Center	01	B107	100	0	010A	Non-assignable	CUSTODIAL ROOM	A1	East Campus	CS	College Station	3	8	Non-System	91	Non-System Nonassignable	09199	NTAMU Non-Assignable Space	N	99	Non TAMU System Organization Units	01	NON ASSIGNABLE	CUSTODIAL ROOM	100	100	0	0	0	0	0	0	0	0	0	0	0	0

Result Page: Previous  1 ... 4  5  6  7  8  9  10  11  12  13  ... 17192  Next

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