Domain Type

Description

ID

Well-behaved?

ID/SI Parent

Parent table with INTEGER(4) primary key

32-bits containing the actual primary key

Yes, as long as the primary key is sequentially ascending from 1.

Transparency Parent (TR)

Parent table with a non-INTEGER(4) primary key

32-bits containing a Transparency ID that correlates to the primary key

Yes.

Transparency Parent with Rowid Support (TRR)

Parent table with a non-INTEGER(4) primary key where the underlying DBMS has no native index on the primary key

32-bits containing a Transparency ID that correlates to the primary key and the rowid

Yes.

Detail Record (DR)

Standalone child

32-bits containing a number mapped to the rowid. If the rowid is naturally 32-bits, then the rowid itself is used

Yes, if the native rowid is mostly sequentially ascending from 1.

Pre-joined or Record-Specific Child

Child

64-bits containing two 32-bit components from the choices above: one 32-bit Parent ID and one 32-bit Child ID.

Only the second 32-bits is considered; therefore, yes, if the native rowid is mostly sequentially ascending from 1.