<-Previous || Table of Contents – Asbestos || Next->
Project Restarted
– Functional Requirement Document (PDF,Word)
– Entity-Relationship Diagram (ZIP,PDF)
– Table FAMIS_ASBESTOS_ASSESSMENT
Fields added to use by the Asbestos Management System to identify an item
ASSESSMENT_ID: Each building has an Assessment ID
ITEM_ID: Each item in an assessment has an Item ID
VERSION: Each item in an assessment has multiple versions
Fields added to use by the Asbestos Management System
DELETED (1 if deleted)
Fields from Excel workbook properties
XLS_AUTHOR
XLS_LAST_AUTHOR
XLS_CREATE_DATE
XLS_LAST_SAVE_DATE
XLS_LAST_PRINT_DATE
XLS_WORKBOOK_NAME
Fields from Excel workbook content
XLS_ROOM
XLS_FLOOR
XLS_BUILDING
XLS_SITE
XLS_ROOM_NAME
XLS_HOMOGENEOUS_AREA
XLS_MATERIAL_DESCRIPTION
XLS_ASBESTOS_CONTENT
XLS_CONDITION
XLS_FLOORING_SF
XLS_CEILING_SF
XLS_WALLS_SF
XLS_PIPE_INSULLATION_LF
XLS_PIPE_INSULLATION_EA
XLS_DUCT_INSULLATION_SF
XLS_EQUIPMENT_INSULLATION_SF
XLS_MISCELLANEOUS_SF
XLS_MISCELLANEOUS_LF
XLS_MISCELLANEOUS_EA
XLS_REMARKS
XLS_TITLE
Fields that the asbestos standardizing software used (should not use otherwise)
XLS_ROOM_NOTE
XLS_LOOKUP_ROOM
Fields used by the Asbestos Management System to track changes
CREATE_DATE: date when the Excel workbook containing the item was first created. If the item is newly created in the Asbestos Management System, it is the date when the item was created
MODIFY_DATE: date when the item was modified (version >1); null if first loaded from Excel workbook (version 1). It is the same as CREATE_DATE if the item is newly created in the Asbestos Management System
MODIFY_USER: NETID that modified the item (version >1); null if first loaded from Excel workbook (version 1). It is the NETID if the item is newly created in the Asbestos Management System
CREATE_USER: SYSTEM if previously loaded from Excel workbook (all versions). It is the NETID if the item is newly created in the Asbestos Management System
Fields after standardization (data from FAMIS tables)
SITE
BUILDING
FLOOR
ROOM
Fields added not used yet
VENDOR
– Table FAMIS_ASBESTOS_STATUS
ASSESSMENT_ID
BUILDING
CHECKED_OUT: 1 if checked out
CHECKED_OUT_USER: NETID of the user who checked out
CHECKED_OUT_DATE: date of being checked out
CHECKED_IN_USER: NETID of the user who checked in
CHECKED_IN_DATE: date of being checked in
<-Previous || Table of Contents – Asbestos || Next->