Understand the Batch Schedule (BatchSchedule) table

msrepl_tran_version

Uniqueidentifier

Unique record identifier.

schedule_code*

Char(9)

schedule_sequence_number*

Int

schedule_ticket_number

Int

Unique ticket number.

revision_number

Int

Ticket revision number.

company_code*

Char(32)

available*

Char(1)

batchXfer_name

Char(32)

RealTime database (RTDB) name of batch transfer to which the ticket belongs.

begin_date

Datetime

Date and time ticket is scheduled to begin.

billable_movement_indicator*

Char(1)

california_gasoline_indicator*

Char(1)

consignee*

Char(32)

contract_item*

Char(8)

custody_point*

Char(32)

customer_integrity_indicator*

Char(1)

customer_movement_code*

Char(32)

end_date

Datetime

Date and time ticket is scheduled to end.

issue_date*

Datetime

lease_code*

Char(32)

location*

Char(4)

message

Varchar(254)

Text message with information about the ticket.

movement_code*

Char(32)

The character length is restricted to 31 characters because the last character is reserved for a null terminator.

Note: If updated manually to 32 characters by other means, it is truncated to 31 characters when syncing to the RealTime database.

movement_type*

Char(2)

offset

Int

Greenwich Mean Time (GMT) Offset.

origin_tax_indicator*

Char(1)

packwash_indicator*

Char(1)

percent_allocation_indicator*

Char(1)

pipe_line_system_id*

Int

product_type

Char(32)

Name used in RTDB to indicate the product type that the ticket is moving.

pump_through_indicator*

Char(1)

actionSequenceName

Char(32)

The Action Sequence name to execute on ticket start.

scheduler*

Char(32)

shipper*

Char(32)

tank_code*

Char(32)

time

Int

This provides the time the ticket was created, using GMT.

transmix_indicator*

Char(1)

Indicates if the ticket is a transmix indicator ticket.

vessel_code*

Char(32)

waived_measurement_indicator*

Char(1)

audit

Char(1)

Indicates that the ticket was modified by a Controller.

maintenance

Char(1)

Indicates that this is a maintenance ticket.

contam

Char(1)

Indicates that the batch has been contaminated.

csw

Float

Provides the sediment and water percent.

opcomment

Char(80)

Enter Controller comments on the ticket record.

The character length is restricted to 79 characters because the last character is reserved for a null terminator.

Note: If updated manually to 80 characters by other means, it is truncated to 79 characters when syncing to the RealTime database.

scheTemp

Float

Scheduled temperature for the ticket.

scheDens

Float

Scheduled density for the ticket.

schePres

Float

Scheduled pressure for the ticket.

scheVol

Float

Scheduled volume for the ticket.

scheRate

Float

Scheduled flow rate for the ticket.

tempUnit

Varchar(15)

Units in which the temperature information is stored.

densUnit

Varchar(15)

Units in which the density information is stored.

presUnit

Varchar(15)

Units in which the pressure information is stored.

volUnit

Varchar(15)

Units in which the volume information is stored.

sequenceno

Float

Internal sequence number used to order ticket within the batchSchedule table. This should never be manually modified.

state

Char(1)

Internal indicator for current state of the record.

ownSysId

Int

ID of the system to which the ticket belongs.

datasetId

Int

Dataset to which the ticket belongs.

user

Varchar(32)

The name of the user that made the modification.

revisionTime

GMTTime(int)

The time that the modification was made.

isBatmtr

Char(1)

Determines whether the batch schedule entry record is a Batmtr or not.

Note: The use of this field has been discontinued. It will be set to ‘N’ for all records.

cutType

char(4)

This defines the cut type that is being used.

schedule_source

varchar(80)

This is primarily used to indicate that that the scheduling information is coming from an external source. If the scheduling information is supplied by the Controller, the schedule_source will be NULL.