Stores information about the catalogs available in Touchstone.
Information regarding catalogs that contain custom, user-defined event footprints is available in tCatalogDetail Table.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 548 |
| Data Space Used | 80.00 KB |
| Index Space Used | 80.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CatalogSID | Unique system-generated sequential identifier for the catalog record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit. | int | 4 | ||||
| CatalogTypeCode | Code that represents the catalog type. For a complete list of codes, see tCatalogType Table. | varchar | 10 | ||||
| Catalog | Name of the catalog. | varchar | 255 | ||||
| Version | Version number of the catalog. | varchar | 20 | ||||
| ModelCode | Code that represents the model in Touchstone. For a complete list of codes, see tModel Table. | smallint | 2 | ||||
| ModelVersion | Version number of the model. | varchar | 20 | ||||
| YearMax | Maximum number of years in the catalog. | int | 4 | ||||
| YearCount | Total number of simulated years in the catalog. Note that "year" in this context represent simulation years only and do not represent an actual date | int | 4 | ||||
| EventMax | Maximum number of simulated events in the catalog. | int | 4 | ||||
| EventCount | Total number of simulated events in the catalog. | int | 4 | ||||
| BaseName | Formatted name of the catalog. | varchar | 255 |  | |||
| EnteredDate | Date and time when the catalog was created. | date | 8 | (getutcdate()) | |||
| EditedDate | Date and time when the catalog was last modified. | date | 8 | (getutcdate()) | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see dbo.tStatus Table. | varchar | 10 | ('A') | |||
| IsPreviousVersionModel | Indicates whether the catalog includes the current or previous version of the AIR model.
| bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCatalogDetail | Table | Stores information about the catalogs that contain custom, user-defined events. For more information about the AIR-provided catalogs, see tCatalog Table. | 1 |
| tEventSetCatalogXref | Table | System reference table used to identify the events sets that are associated with specific catalogs. | 1 |