Planning a Conversion > Conversion Methods > OID Generator Code
  
OID Generator Code
One important step required of all conversions is the entry of an OID generator code. This code is used to create the OID values that uniquely identify each record in the database.
You can choose any numeric code you want. The OID generator code you enter is used as the registration ID of the full OID value written to database records as they are created. The generator code is stored and displayed in Database Control (36.24) and can be modified later, if necessary.
Once the OID generator code has been specified, OID fields in the database are populated using an algorithm that ensures uniqueness across all records, tables, and databases within the company. The value stored in the OID field for each record has the following decimal format:
<date><seq_value>.<registration_id>
Where:
<date> is the server date with format yyyymmdd.
<seq_value> is obtained from a Progress database sequence.
<registration_id> identifies the origin of the OID value.
The registration ID is derived from the OID generator code by reversing the digits of the generator code.