Stores information about the deductible types used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 deductible types to Touchstone deductible types.
Stores information about the deductible types used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 deductible types to Touchstone deductible types.
| Creation Date | 9/1/2011 2:17 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object | ![]() |
| Published for Replication | ![]() |
| Rows | 42 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| OldConditionTypeCode | Code that represent the CLASIC/2 contract (condition) type to which the deductible was applied.
| varchar | 10 | |||
| OldDeductibleTypeCode | Code that represents the CLASIC/2 deductible type.
| varchar | 10 | |||
| OldDeductibleType | Name for the CLASIC/2 deductible type. Corresponds to the code in OldDeductibleTypeCode. | varchar | 40 | ||||
| UPXDeductibleType | Code for the deductible type as used in a UPX record. Corresponds to the code in OldDeductibleTypeCode. | varchar | 10 | ![]() | |||
| NewTable | Touchstone database table where this deductible type is saved. | sysname | 128 | ![]() | |||
| NewColumn | Name of the column in the Touchstone database table where this deductible type is saved. | sysname | 128 | ![]() | |||
| NewCode | Code that represents the deductible type in Touchstone. For a complete list of codes, see tDeductibleType Table. | varchar | 10 | ![]() | |||
| Description | Description if the deductible type. | varchar | 1024 | ![]() |