• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
    •

    Make Visit Name a consecutive number

    Technical Questions
    #1

    Our legacy system assigns each visit a consecutive number. Is it possible to do this in OpenSpecimen?
    The SYS_UID token will assign a system generated number but will it be consecutive? Is this token used in other places?
    Thanks for any help.

    #2

    Hi @Sarah_H,

    Yes, it is possible to setup consecutive numbers to the visits using the token %SYS_UID%.
    This token is unique to each level - Participant, visit and specimen. When assigning SYS_UID at visit level, it will only generate sequence for all the visits in the system.

    Please refer to the Wiki page for all the tokens available at the visit level.

    Thanks,
    Neha

    #3

    Thanks Neha, this is helpful. I would like to set the visit level %SYS_UID% token to start at the last number from our legacy system. Is this possible?

    #4

    Hi @Sarah_H,

    Yes, it is possible to set the visit sequence to start from a desired number. This needs to be done via database.

    Please refer to the Wiki page https://openspecimen.atlassian.net/wiki/x/kDEQBQ for visit level SYS_UID token row for the SQLs to set the sequence.

    Thanks,
    Neha