Receiver Table Reference

---

SatTracker stores the following information about receivers:

• CustomerId: The number that uniquely identifies a customer. This number is used to link Receiver Records to Customer Records. A CustomerId of 0 means the receiver is in inventory. See changed out for more information. Stored as a long integer.
  
  
• Date Installed: This field lets you track when the receiver was installed at the customer site. Stored as a date.
  
  
• Receiver Serial: The receiver serial number is stored here. For dish network systems, it generally starts with a set of several letters, followed by digits, e.g. RDACAJ00118A. Stored as a text field containing up to 20 characters.
  
  
• Receiver Id: The receiver id number is stored here. For dish network systems, it starts with R00, followed by digits, e.g. R0021086995. NOTE: the Receiver ID corresponds to CANum in the Dish Data commission download. Stored as a text field containing up to 20 characters.
  
  
• Smart Card: The smart card number is stored here. For dish network systems, it starts with S00, followed by digits, e.g. S0000483962. Stored as a text field containing up to 20 characters.
  
  
• Model: The model number is stored here. The Model is the vendor name of the dish system. The list of model names and costs are stored in the ModelInfo table. Stored as a text field containing up to 20 characters.
  
  
• SysType: The system type is stored here. The system type is the vendor of the dish system. The list of system type names is kept in the SysTypeNames table. Stored as a text field containing up to 20 characters.
  
  
• Primary: This field indicates if the receiver is the primary receiver for a customer. SatTracker uses the primary receiver for purchase agreements. The primary attribute is not rigidly enforced, so take care to mark the receivers properly. Stored as a yes/no field.
  
  
• SalesPerson: This field isn't used. The sales person is recorded in the OrdersTable. Stored as a text field containing up to 32 characters.
  
  
• Installer: This field isn't used. The sales person is recorded in the OrdersTable. Stored as a text field containing up to 32 characters.
  
  
• Cost: The cost the receiver was sold for is stored here. This is used to calculate the total cost of an Order. Stored as a double precision real number.
  
  
• ChangedOut: This field indicates if the receiver has been changed out. A receiver can only be changed out if it is owned by a customer. You change out the receiver by clicking on the change out button in the Receiver form. The change out field lets you keep track of the entire set of customers that have ever owned the receiver. A scenario where you would change out a receiver is: The customer reports the receiver has failed. You mark the receiver as changed out for the customer, add a new receiver from inventory to the customer, and send out the technicians to effect the switch. The receiver is repaired, and later sold to another customer. When you press the change out button, SatTracker marks changed out as true in the receiver record with the customer id of the original customer, and sets the changed out date to today's date. It then makes a new receiver record with a CustomerId of 0 (indicating the receiver is in inventory) for the same receiver. The receiver is now considered available for another customer. If you elect to discard the receiver, simply delete the receiver from the customer's receiver list. Stored as a yes/no field.
  
  
• Disqualified: This field is not currently used. Stored as a yes/no field.
  
  
• DateDisqualified: This field is not currently used. Stored as a date.
  
  
• DateChangedOut: The date the receiver was changed out. This is set automatically when you click on the change out button in the Receiver form. Stored as a date.
  
  
• DateInventoried: The date the receiver was added to inventory. This is set automatically when you click on the change out button in the Receiver form on the new copy of the receiver record with a customer ID of 0. It is also set automatically when you use the Add Receiver To Inventory form. Stored as a date.
  
  
• Ours: This field is used to distinguish between receivers that you sold against receivers that you serviced. Stored as a yes/no field.
  
  
• OrderDate: This field is used to tie the receiver to an order. It is automatically set to the latest order date of the customer; if there is no such date then today's date is used. If no order is found containing the order date and the customer id, a new order is automatically created. Stored as a date.
  
  
• Inventory Location: The Inventory Location is stored here. Sat Tracker uses "Warehouse" for receivers you add to inventory using the Add Receiver To Inventory form. When you assign the receiver to a customer using the Receiver form, the inventory location is set to "Customer". Stored as a text field containing up to 30 characters.