This table stores the active environment objects. If users delete an environment, it will be removed from this table. However, the environment object information will be stored in the harAllEnvirs table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| envobjid | integer | not null | Object ID of project |
| environmentname | char(128) | not null | Project name |
| envisactive | char(1) | not null | Project active flag |
| baselineviewid | integer | not null | Baseline view object ID of project |
| creationtime | date | not null | Object creation time |
| creatorid | integer | not null | Object ID of user to create the project |
| modifiedtime | date | not null | Object modification time |
| modifierid | integer | not null | Object ID of user to modify the project |
| note | varchar(2000) | with null | User-defined note |
| isarchive | char(1) | not null | Project has been archived (Y/N) |
| archiveby | integer | not null | User object ID who archived project |
| archivemachine | char(256) | with null | Machine name where project was archived to |
| archivefile | char(256) | with null | Archive file name of project |
| archivetime | date | with null | Time of archive |
Product Name: AllFusion Harvest Change Manager
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| envobjid | harview | envobjid |
| envobjid | harapprovehist | envobjid |
| envobjid | harstate | envobjid |
| envobjid | harpackagegroup | envobjid |
| envobjid | harpackage | envobjid |
| envobjid | harenvironmentaccess | envobjid |