Touchstone 11.0 API Reference
ExposureView and Contract Filters
The following table details the filters that you can use to retrieve an existing Exposure View or a list of Contracts:
Table: ExposureView and Contract Filters
| Category | UI Display Name | API Property Name | Applied Entity | Type | UI Operator | API Operator Equivalent | List |
|---|---|---|---|---|---|---|---|
| Geography | |||||||
| Country Code | CountryCode | Locations | String | Is contained in | IsContainedIn | Yes | |
| Is not contained in | IsNotContainedIn | Yes | |||||
| Area Code (e.g. State) | AreaCode | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Sub Area Name (e.g. County) | SubareaName | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| City | City | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Postal Code | PostalCode | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| CRESTA | CrestaCode | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Location | |||||||
| Construction Building | ConstructionCode | Locations | String | Is contained in | IsContainedIn | Yes | |
| Is not contained in | IsNotContainedIn | Yes | |||||
| Occupancy Code | OccupancyCode | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Geocode Match Level | GeographyMatchLevelCode | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Geocode Source | String | Is contained in | IsContainedIn | Yes | |||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Gross Area | GrossArea | Int32 | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Building Height | BuildingHeight | Int32 | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Stories | Stories | SByte | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Territory | Territory | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Year Built | YearBuilt | Int16 | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Peril | Perils | LocTerms | String | Is contained in | IsContainedIn | Yes | |
| Is not contained in | IsNotContainedIn | Yes | |||||
| Total Replacement Value | TotalReplacementValue | Locations | Double | Is equal to | IsEqualTo | No | |
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Replacement Value Building (A) | ReplacementValueA | Double | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Replacement Value Other (B) | ReplacementValueB | Double | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Replacement Value Contents (C) | ReplacementValueC | Double | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Replacement Value Time (D) | ReplacementValueD | Double | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Premium | Premium | Double | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Inception Date | InceptionDate | DateTime | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Expiration Date | ExpirationDate | DateTime | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| In-Force Date | DateTime | Is equal to | IsEqualTo | No | |||
| Contract | |||||||
| Contract ID | ContractID | Contracts | String | Is equal to | IsEqualTo | No | |
| Is not equal to | IsNotEqualTo | No | |||||
| Starts with | StartsWith | No | |||||
| Ends with | EndsWith | No | |||||
| Contains | Contains | No | |||||
| Does not contain | DoesNotContain | No | |||||
| Is contained in | IsContainedIn | Yes | |||||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Expiration Date | ExpirationDate | DateTime | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| Inception Date | InceptionDate | DateTime | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Is less than | IsLessThan | No | |||||
| Is less than or equal to | IsLessThanOrEqualTo | No | |||||
| Is greater than or equal to | IsGreaterThanOrEqualTo | No | |||||
| Is greater than | IsGreaterThan | No | |||||
| In-Force Date | DateTime | Is equal to | IsEqualTo | No | |||
| Line of Business | UserLineOfBusiness | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Peril | Perils | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Policy Form | PolicyForm | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Status | StatusCode | String | Is contained in | IsContainedIn | Yes | ||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Producer | ProducerName | String | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Starts with | StartsWith | No | |||||
| Ends with | EndsWith | No | |||||
| Contains | Contains | No | |||||
| Does not contain | DoesNotContain | No | |||||
| Is contained in | IsContainedIn | Yes | |||||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Underwriter | Underwriter | String | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Starts with | StartsWith | No | |||||
| Ends with | EndsWith | No | |||||
| Contains | Contains | No | |||||
| Does not contain | DoesNotContain | No | |||||
| Is contained in | IsContainedIn | Yes | |||||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Insured Name | InsuredName | String | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Starts with | StartsWith | No | |||||
| Ends with | EndsWith | No | |||||
| Contains | Contains | No | |||||
| Does not contain | DoesNotContain | No | |||||
| Is contained in | IsContainedIn | Yes | |||||
| Is not contained in | IsNotContainedIn | Yes | |||||
| User Defined Field 1 (UDF 1) | UserDefined1 | String | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Starts with | StartsWith | No | |||||
| Ends with | EndsWith | No | |||||
| Contains | Contains | No | |||||
| Does not contain | DoesNotContain | No | |||||
| Is contained in | IsContainedIn | Yes | |||||
| Is not contained in | IsNotContainedIn | Yes | |||||
| User Defined Field 2 (UDF 2) | UserDefined2 | String | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Starts with | StartsWith | No | |||||
| Ends with | EndsWith | No | |||||
| Contains | Contains | No | |||||
| Does not contain | DoesNotContain | No | |||||
| Is contained in | IsContainedIn | Yes | |||||
| Is not contained in | IsNotContainedIn | Yes | |||||
| User Defined Field 3 (UDF 3) | UserDefined3 | String | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Starts with | StartsWith | No | |||||
| Ends with | EndsWith | No | |||||
| Contains | Contains | No | |||||
| Does not contain | DoesNotContain | No | |||||
| Is contained in | IsContainedIn | Yes | |||||
| Is not contained in | IsNotContainedIn | Yes | |||||
| User Defined Field 4 (UDF 4) | UserDefined4 | String | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Starts with | StartsWith | No | |||||
| Ends with | EndsWith | No | |||||
| Contains | Contains | No | |||||
| Does not contain | DoesNotContain | No | |||||
| Is contained in | IsContainedIn | Yes | |||||
| Is not contained in | IsNotContainedIn | Yes | |||||
| User Defined Field 5 (UDF 5) | UserDefined5 | String | Is equal to | IsEqualTo | No | ||
| Is not equal to | IsNotEqualTo | No | |||||
| Starts with | StartsWith | No | |||||
| Ends with | EndsWith | No | |||||
| Contains | Contains | No | |||||
| Does not contain | DoesNotContain | No | |||||
| Is contained in | IsContainedIn | Yes | |||||
| Is not contained in | IsNotContainedIn | Yes | |||||
| Contract Filter | |
|---|---|
<Filters xmlns:d2p1="AIR.Services.Common.Filter.Data"> <d2p1:Filter> <d2p1:Created i:nil="true" /> <d2p1:Expression i:type="d2p1:CompositeExpression"> <d2p1:Tag i:nil="true" /> <d2p1:FilterExpressions> <d2p1:FilterExpression i:type="d2p1:SimpleExpression"> <d2p1:Tag i:nil="true" /> <d2p1:AppliedEntity>Contracts</d2p1:AppliedEntity> <d2p1:Operator>Contains</d2p1:Operator> <d2p1:PropertyName>InsuredName</d2p1:PropertyName> <d2p1:Value xmlns:d7p1="http://www.w3.org/2001/XMLSchema" i:type="d7p1:string">Acme Industries</d2p1:Value> </d2p1:FilterExpression> <d2p1:FilterExpression i:type="d2p1:SimpleExpression"> <d2p1:Tag i:nil="true" /> <d2p1:AppliedEntity>Contracts</d2p1:AppliedEntity> <d2p1:Operator>IsEqualTo</d2p1:Operator> <d2p1:PropertyName>ContractID</d2p1:PropertyName> <d2p1:Value xmlns:d7p1="http://www.w3.org/2001/XMLSchema" i:type="d7p1:string">414243</d2p1:Value> </d2p1:FilterExpression> <d2p1:FilterExpression i:type="d2p1:CompositeExpression"> <d2p1:Tag i:nil="true" /> <d2p1:FilterExpressions> <d2p1:FilterExpression i:type="d2p1:SimpleExpression"> <d2p1:Tag i:nil="true" /> <d2p1:AppliedEntity>Locations</d2p1:AppliedEntity> <d2p1:Operator>IsEqualTo</d2p1:Operator> <d2p1:PropertyName>LocationID</d2p1:PropertyName> <d2p1:Value xmlns:d9p1="http://www.w3.org/2001/XMLSchema" i:type="d9p1:string">1</d2p1:Value> </d2p1:FilterExpression> <d2p1:FilterExpression i:type="d2p1:SimpleExpression"> <d2p1:Tag i:nil="true" /> <d2p1:AppliedEntity>Locations</d2p1:AppliedEntity> <d2p1:Operator>IsEqualTo</d2p1:Operator> <d2p1:PropertyName>LocationName</d2p1:PropertyName> <d2p1:Value xmlns:d9p1="http://www.w3.org/2001/XMLSchema" i:type="d9p1:string">1</d2p1:Value> </d2p1:FilterExpression> </d2p1:FilterExpressions> <d2p1:LogicalOperator>And</d2p1:LogicalOperator> </d2p1:FilterExpression> </d2p1:FilterExpressions> <d2p1:LogicalOperator>And</d2p1:LogicalOperator> </d2p1:Expression> <d2p1:ExpressionSQL i:nil="true" /> <d2p1:FilterType i:nil="true" /> <d2p1:ID i:nil="true" /> <d2p1:Intent>0</d2p1:Intent> <d2p1:Modified i:nil="true" /> <d2p1:Name i:nil="true" /> </d2p1:Filter> </Filters> | |