Column Name | Type | Length | Nullable | Description | Relationships | |
Identity | ID | int identity | No | |||
Agency | varchar | 3 | Yes | |||
Funding | varchar | 3 | Yes | |||
Purpose | varchar | 3 | Yes | |||
Tripcode | varchar | 3 | Yes | |||
MileRate | money | Yes | ||||
FlatRate | money | Yes | ||||
PasgHourRate | money | Yes | ||||
Formula | varchar | 1 | Yes | |||
Formdesc | varchar | 25 | Yes | |||
Threshold | numeric | Yes | ||||
Surcharge | money | Yes | ||||
Deductfare | bit | Yes | ||||
Timestamp | datetime | Yes |
Index Name | Index Description | Index Keys |
PK_AgencyRateMappings | clustered, unique, primary key located on PRIMARY | ID |
U_AgencyFundingPurposeTripcode | nonclustered, unique located on PRIMARY | Agency, Funding, Purpose, Tripcode |