Stores information about reinsurance programs.
A reinsurance program includes one or more related reinsurance treaties or layers. Reinsurance coverage applies to locations or treaties and not to reinsurance programs.
| Creation Date | 6/5/2024 11:42 AM |
| 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 | |
|---|---|---|---|---|---|---|---|
 | ProgramSID | Unique system-generated sequential identifier for the program record. | int | 4 | |||
| ProgramID | User-defined identifier for the reinsurance program. | varchar | 100 | ||||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ((1)) | |||
| ProjectSID | Reserved for future use. Unique system-generated sequential identifier for the project record. | int | 4 | ||||
| Description | User-provided description of the reinsurance program. | varchar | 4000 |  | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ('A') | |||
| EnteredDate | Date and time when the reinsurance program was created. | datetime | 4 | (getutcdate()) | |||
| EditedDate | Date and time when the reinsurance program was last modified. | datetime | 4 | (getutcdate()) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tReinsAppliesToGeo | Table | Stores information about the geographic or area filter applied to each reinsurance treaty. Reinsurance treaty geographic filters are optional. | 1 |
| tReinsurance | Table | Stores information about reinsurance treaties. A reinsurance program includes one or more related reinsurance treaties or layers. Reinsurance coverage applies to locations or treaties and not to reinsurance programs. | 1 |