CSU, Chico facility information can be found in 7 separate systems. Below you will find a brief description of each system and why we store facilities information in that system. In addition, a visual representation of each database and how it relates to others is also provided.
- The Local Space and Facilities Master file (LSFM) was created many years ago when it became apparent that the default records and fields found in SIS+ (CSU, Chico's first full fledged student information system) and the Chancellor's Office SFDB (below) were lacking in their ability to store daily operational information regarding space and facilities. It grew to become the database of record for every single space on campus (including things like recreational spaces, stairwells, elevators and closets). It is a local homegrown database/application, but all-inclusive. It is still in use today as no other system has proven to be as extensive and comprehensive (including PeopleSoft (PS) and Ad Astra). This database also holds more local detail in it than is provided by the Space and Facilities Database (SFDB) - a database provided by the CSU, Chancellor's Office (below). The LSFM is intended to be the campus master file which houses all record IDs to the various other databases for facilities information on campus including Ad Astra, SFDB, Peoplesoft (both Finance and Human Resources Student Administration databases), FacilitiesLink and TMA. As described below, the LSFM is THE database of record used in our annual maintenance of the Chancellor Offices' SFDB. The data in the LSFM database is used in many reports.
- FacilitesLink is a 3rd party program purchased by CSU, Chico. It's primary sponsor is the FMS Design department. Its ultimate goal involves electronically mapping every space on campus through the use of new surveying technology provided by the FacilitiesLink company, Digicality. FacilitiesLink is not to be considered a replacement for LSFM, at least not yet, due to its inability to provide reports (i.e. SFDB transaction file) to the Chancellor's Office. FacilitiesLink data is not currently used in campus-wide reports. FacilitiesLink follows the facility ID found in LSFM closely and should be aligned over time.
- TMA (Workgroup Edition) is a 3rd party program used by our local Facilities, Maintenance and Services department (FMS) in order to track work requests. TMA uses mostly identical facility IDs in order to link to LSFM and its records are a subset of LSFM. TMA closely mirrors the LSFM in it's attempt to catalog all spaces on campus as FMS may be asked to provide assistance in any area within campus boundaries despite its affiliation with the campus (state-owned properties, auxilliary, AS, etc..) In addition, TMA houses a small set of areas not catalogued in other databases. Its database is not used in campus-wide reports.
- The Peoplesoft Finance (PS FIN) facilities database consists of records used to track purchase and catalog equipment per room/building. It is used by campus purchasing and property. Its room count is large due to the need for equipment tracked by the previously mentioned entities to exist in a variety of spaces. PS FIN uses the LSFM building and room name as it's guide for its 'location' field which is the concatenation of the building and room number. The name of the table housing these records is PS_LOCATION_TBL. The records found in this database are not normally used in campus-wide reporting.
- The Space and Facilities Database (SFDB) is a database subset of the LSFM. The SFDB is the Chancellors Office 'official record' of space and facilities on our campus. As a an official record, it is a very simplistic model of our campus. It includes only those buildings and rooms deemed 'official capacity space' to the C.O. in it's calculations regarding local and CSU wide reporting of space. Each year CSU, Chico produces the annual SFDB update to the C.O.. All proposed changes, deletes and inserts for this annual submission are maintained, continually, in the LSFM and extracted to a specified file format before being submitted by Facilities Planning. A few months later, we load that small campus specific set of data into our LSFM tables in order to compare 'what they have' with 'what we have', which unsurprisingly to those of you who have been here for a few years, can differ dramatically. The SFDB is a subset of LSFM and is linked to it through identical facility IDs. The SFDB official information is used in all official reports, but to a limited degree in our local campus reports.
- Peoplesoft is the mandated student information system that is supported and provided by the CSU Chancellor's office. It was purchased in order to align all CSU campuses under one data system. Peoplesoft must have building room information in it in order to properly function in it's role as our student information system and to communicate with Ad Astra, our 3rd party room booking software. Ad Astra is used to book rooms, rather than PS, due to it's more robust room conflict checking. In addition, the building and room fields in Peoplesoft are used to generate our local portion of the SFDB (Space and Facilities Database) that is provided by the CSU, Chancellor's Office. Peoplesoft HRSA facilities are a subset of LSFM records and it is linked to the LSFM through identical facility IDs. The actual table name is PS_FACILITY_TBL. PS building/room information is used in few reports (Ad Astra should be used).
- Ad Astra is a 3rd party program (not affiliated with the CSU) used in scheduling both academic (classes) and public/private events (i.e. meetings and conferences). The major extent of it's use is found in the scheduling of classes and events for the campus. It was purchased by CSU, Chico because Peoplesoft was found to be lacking in the area of room conflict checking (PS does not check for class vs regular event conflicts). As such, it must have the set of rooms that are schedulable (for event or class) in order to function correctly and provide the conflict checking we need. Ad Astra feeds its data into Peoplesoft (below) in order to provide classroom information. Ad Astra is a subset of the LSFM records and its facilities are linked to the LSFM through identical facility IDs. Ad Astra Building/room information is used in a few campus-wide reports.