Method for generating object ids in ARM
As part of migrating historical data from a Blackline application into ARM, the associated questions, answers, comments, instructions and associated documents (references) related to Reconciliations will need to be migrated into ARM. There does not seem to be any facility to bring this type of existing data into ARM so it appears that the records will need to be directly inserted into ARM_QUESTIONS, ARM_ANSWERS, ARM_COMMENTS, ARM_INSTRUCTIONS and ARM_REFERENCES.
For example in the ARM_REFERENCES table if the associated ARM Reconcliation_ID is defined as the object_id, the row should point to the correct Reconcilation but how should the record ids be generated? It appeared like the various ids were all being generated from a single sequence regardless of the type of id (e.g. answer_id, question_id, comment_id, instruction_id, reference_id). How can we duplicate the record id generation so that we can directly insert rows into those tables for historical data?