Database Tables
The following is a list of database tables and their contents used in the submittals process:
Table | Description |
---|---|
awdm_submit_obj_file_rslts | Submittal object file level
validation results
Populated by the SSIS Package used for validation |
awdm_submit_obj_files | Stores the Submittal object file metadata for each object |
awdm_submit_obj_rslts | Submittal object level validation
results
Populated by the SSIS package used for validation |
awdm_submit_objs | Stores the Submittal object metadata for each run |
awdm_submit_rslts | Submittal level validation
results
Populated by the SSIS package used for validation |
awdm_submittals | Stores the Submittal validation run metadata |
awdm_submit_obj_rslts
awdm_submit_obj_files
awdm_submit_rslts
awdm_submittals
Attribute | Description |
---|---|
submittal_id | Unique Identifier (auto-generated) |
context_id | Context Id from SSIS package |
timestamp | Time stamp of submittal validation |
object_id | Object Id of Submittal Object |
object_type | Object Type of Submittal Object |
awdm_submit_objs
Attribute | Description |
---|---|
submit_obj_id | Unique Identifier (auto-generated) |
submittal_id | Id of parent Submittal (awdm_submittals) |
context_id | Context Id from SSIS package |
object_id | Storage of the resultant object
id
This not required and for information only |
object_type | Object Type of the resultant object |
code | Code/prefix of the object to be added to AssetWise (optional) |
middle | Middle of object to be added to AssetWise (optional) |
revision | Revision of object to be added to AssetWise (optional) |
title | Title/Description of object to be added to AssetWise (required) |
awdm_submit_obj_file_rslts