ProviderCostValidity

Name: Provider Cost Validity

Type: Ancillary, Application

Modules: Booking, Scheduling, Faring

Description: Definition of what and when a provider contract will pay.
Field Documentation

PCCId

Numeric identifier of the provider costing contract.

ProviderContractId

Numeric identifier the provider contract from the ProviderContract table.

FromDate

Start date from when the provider costing is valid.

ToDate

End date after which provider costing is no longer valid. The same contract ID can used be in multiple records, if the cost of the contract changes over time, within the overall validity of the contract.

WeekTemplate

7-character numeric string representing the days of the week the costing is valid on. (e.g., 0100100 means Monday and Thursday).

TimePayInterval

Used for rounding time up to the next highest even multiple of this interval before applying a time rate. If zero, no rounding occurs. Value is in seconds.

DistancePayInterval

Used for rounding distance up to the next highest even multiple of this interval before applying a distance rate. If zero, no rounding occurs. Value is in meters.

TimePayUnit

Number of seconds that make up a unit of time to which any time pay rates apply (e.g., if the pay rate is $1 per minute, then this value would be 60.

DistancePayUnit

Number of meters that make up a unit of distance to which any distance pay rates apply. (e.g., for a per km rate, this value would be 1000).

GuaranteedTime

Minimum time in seconds for which an escort can be paid, regardless of how long the escort was on board.

GuaranteedTimeRate

Rate at which the escort is guaranteed to be paid, taking into account TimePayUnit, TimePayInterval and the rounding method.

SchedulePeriodId

Numeric identifier of the schedule period from the SchedulePeriod table.

BaseIndex

For Internal Use.

IgnoreSegmentCostForEmptyRuns

For Internal Use.

WeightedIndex

For Internal Use.

TimeIntervalRoundingRule

Numeric identifier of time interval rounding rule.

DistIntervalRoundingRule

Numeric identifier of distance itnerval rounding rule.

DistanceCalcRule

Numeric identifier of distance calculation rule (e.g., Trianglation, direct distance, etc.).

Priority

For Internal Use.

BandedGuaranteedFlatRate

For Internal Use.

BandedMaxEmptyTime

For Internal Use.

VarRateCalcMethod Determines how to calculate banded time/mileage costing (0 = N/A, 1 = single banded, 2 = cumulative banded).