Equipment, Facilities & Assets Data Warehouse Tables

Sybase IQ View Name / WebFOCUS Reporting Object Name	Records	Data Included	Known Problems
EFA_Buildings EFA_Buildings_FOCUS	One record for each combination of fiscal year, campus, functional affiliation code, and CAAN, from fiscal year 2001 onward. EFA_Buildings_FOCUS view contains same data as EFA_Buildings, but under old VM FOCUS data names.	Building name, date constructed, assigned square footage, non-assignable square footage, etc.
EFA_Buildings_Rooms EFA_Buildings_Rooms_FOCUS	One record for each combination of fiscal year, campus, functional affiliation code, CAAN, and room number, from fiscal year 2001 onward. EFA_Buildings_Rooms_FOCUS view contains same data as EFA_Buildings_Rooms, but under old VM FOCUS data names.	Information in building view, plus room specific information: room name, use code, CIP code, etc. Note that building square footage data is duplicated for each room in a building. Do not sum building square footage while using the room view.
EFA_Equipment EFA_Equipment_FOCUS	One record for each combination of fiscal year, campus, and property number, from fiscal year 2001 onward. EFA_Equipment_FOCUS view contains same data as EFA_Equipment, but under old VM FOCUS data names.	Equipment class, description, acquisition value, useful life, CAAN, fund source, etc.
CAAN_All_Years_Depreciation (WebFocus only)	May contain multiple records for each combination of fiscal year, campus, and CAAN, corresponding to each part of a building that is depreciated separately. Data from fiscal year 1999 onward.	Asset Type, fund source, original value (in INCREMENT_AMT), cumulative and fiscal year depreciation, etc.