8.1.2 Items Data Table

The table “Items” has the following columns

  1. NO (i): unique number of record

  2. Id (t): Install Id of SAFO program that provided record

  3. GroupNo (i): Unique number of record to which this record belongs

  4. TabNo (i): Selector of weekday group/gen data

  5. AC (t): coded AC name of this record

  6. Data (t) record data

Note: (i) denotes an integer field, (t) a text field

An example may look as follows (extract):


The records are a snapshot of one particular AC taken at a particular time. They are grouped together by the GroupNo, which uses the NO of the first record of this group. Other units get their own GroupNo, even if the snapshot was taken at the same time, and subsequent snapshots get of course their own GroupNo.

A record with the TabNo = 0 acts as a record group closer: it is uploaded as the last record of a group and thus validates the whole record group in the database – without it the record group would not be used in the SAFO programs. Records with other TabNo belong to a particular weekday group – the data key = 0 indicates the header for the weekday group, while the other have the information about intended temperature values including a start time.

The Data field of the record is a collection of several items separated by “:”, with their meaning as follows:

TabNo = 0: wdcutoff:cb:ce:he:hb:repoutside:repinside:disabled:count (2) (1) (3) (4) (5)

TabNo > 0, Data Key = 0: #entries:name:su:mo:tu:wd:th:fr:sa:endtime:disabled (6) (7) (8) (9) (4)

TabNo > 0, Data Key >0: begtime:cb:ce:he:hb (10) (1)

Some more details:

  1. cb, ce, he, hb are temperature values in Fahrenheit for cool begin, cool end, heat end, heat begin, respectively

  2. wdcutoff is the weekday cutoff time in minutes (the time SAFO will consider a start of a new weekday)

  3. repoutside, repinside Frequency in minutes of how often the Temperature File should be checked and the AC adjusted if no particular schedule is active (outside) or if this particular schedule is active (inside)

  4. disabled: flag if the schedule or weekday group is active(Y) or not (N)

  5. count: number of records generated/stored within group including this one

  6. #entries: number of records for the same TabNo, including this one (header)

  7. name: coded name of the weekday group as it appears in the tab of the simplified user interface

  8. su, mo, … weekday for which this weekday group is active(Y) or not (N)

  9. endtime: the end time of the last data entry of the weekday group schedule

  10. begtime: the begin time for this data entry of the weekday group schedule (ends with the begin of the next data entry, or the endtime as indicated in the header

Note: the AC name and the weekday group name are B64-coded which allows free usage of names in strings communicated between the SAFO programs and the database.