System reference table used to determine the step functions that are associated with a location.
CEDE 9.0 Database Reference
tLocStepFunctionXref Table
| Creation Date | 4/12/2021 11:26 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 | |
|---|---|---|---|---|---|---|---|
 | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | |||
| | StepFunctionSID | Unique system-generated sequential identifier for the step function record. For a complete list of records, see tStepFunction Table. | int | 4 | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tContract | Table | Stores records for primary insurance policies. | 2 |
| tLocation | Table | Stores geographical attributes and primary risk characteristics for each location. The table serves as a reference point between Location and Contract entities.You can identify each location by the location sequential identifier (SID). | 1 |
| tStepFunction | Table | Stores general information about step functions, including the contract associated with each step function. | 1 |