Stores information about portfolios.
Touchstone Re 2022 Database Reference
tPortfolio Table
| Creation Date | 4/11/2022 6:17 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | PortfolioSID | Unique system-generated sequential identifier for the portfolio. | int | 4 | |||
| PortfolioFilterSID | Unique system-generated sequential identifier for the portfolio filter associated with the portfolio. For a complete list of records, see tPortfolioFilter Table. | int | 4 |  | |||
| PortfolioName | Name of the portfolio. | varchar | 255 | ||||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ||||
| TotalInvestmentAmount | Total amount covered by the portfolio. | float | 9 | ||||
| ReinsuranceLayerCount | Number of reinsurance layers. | int | 4 | ||||
| RiskRatio | Reserved for future use. | float | 9 | | |||
| StatusCode | Code that represents the system-provided status for the portfolio. For a complete list of codes, see tStatus Table. | varchar | 10 | ||||
| Description | User-specified description of the portfolio. | varchar | 4000 | | |||
| EnteredDate | Date and time the portfolio was created. | datetime | 4 | ||||
| EditedDate | Date and time the portfolio was last edited. | datetime | 4 | ||||
| Author | User that created the portfolio. | varchar | 255 | | |||
| PortfolioTypeCode | Code that represents the type of the portfolio. For a complete list of codes, see tPortfolioType Table. | varchar | 10 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tPortfolioReinsuranceTreaty | Table | Stores information about reinsurance treaties or layers included in portfolios. | 2 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tPortfolioFilter | Table | Stores information about portfolio filters. | 2 |