Format Definitions for OA IDs and WCAIDs

Ryan Morlok
Ryan Morlok ✭
in TR Internal
Are there published format standards for the format of [WCA][1] IDs and [OA][2] IDs? Informally I've understood WCA IDs to be Novus-style guids (33 characters with the first being 'i') and OA IDs to be integers, but I was wondering if there is documentation that can confirm this will always be true. [1]:
http://techoverflow.int.westgroup.com/questions/816/what-does-wca-stand-for [2]:
http://techoverflow.int.westgroup.com/questions/815/what-does-oa-stand-for
Tagged:

Best Answer

  • Ryan Morlok
    Ryan Morlok ✭
    Answer ✓
    I received confirmation that OA IDS are always numbers (the column in OA DBs has an NUMBER(19) to store the data). WCA IDs are stored in string column, and I haven't been able to get 100% confirmation that their format is guaranteed, but below are examples that seem to indicate that their format is consistent.


    Examples of WCA Company GUIDs: ('I' followed by 32 Hex characters: 0-9,A-F)

    I0000002060FC11E089AC8CE04EA54993
    I00000070647B11E080258F0E01953BF2
    I00000110642611E0B50EDE267DF909C1
    I000001A0622411E080258F0E01953BF2
    I000001A1622411E080258F0E01953BF2
    I0000022060E611E080258F0E01953BF2
    I0000027061F411E089AC8CE04EA54993
    I00000400625811E089AC8CE04EA54993

    Examples of OA IDs: (10 digit numbers that start with 4 or 5)

    5000003493
    5000003557
    5000003673
    4294969119
    4294969466
    4294975368
    4294988683

Answers

  • Ryan Morlok
    Ryan Morlok ✭
    One point of discussion came up is that WCA ID could actually be an ambiguous term. There is the GUIDs for each company internally generated by WCA, and the an internal sequence for companies that acts as the primary key within the database (which is a number). Both are passed on to the data warehouse.

Categories