Announcement

Collapse
No announcement yet.

What are the Query and Document ID value's?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • What are the Query and Document ID value's?

    What are the Query and Document ID value's?

    Question:
    Is there a meaning to the 13 digit number of Query ID and Document ID values in the system.

    Answer:
    Yes, the query and document ID's are actually SAS Datetime values to the thousandth of a second, which are then formatted to a consistent length of digits with the decimal removed. The queryid is derived from the recordid value. The documentid is generated when a query is printed.

    For example...

    A datetime value of 1468240158.831 would be 1468240158831.

    If the values happen to exactly be on the even second (1468240158) or less than 3 decimal places we pad the end of the value with 0's to make it a consistent length.

    So 1468240158 would be 1468240158000 and 1468240158.83 would be 1468240158.830 and so on.

    We chose to do this in this manner in order to guarantee a unique value as SAS does not have an identity value such as SQL or Oracle.

    All record identifiers in the system are datetime stamps to the thousandth of a second. The tables all have unique indexes on the recordids so that the values cannot be duplicated.


    Last edited by Ronni Rubenstein; 01-05-2007, 01:58 PM.
Working...
X