Forum Discussion

aabirached's avatar
aabirached
New Contributor II
7 months ago

UD34, UD56 and UD78 columns in DataRecords

Hello everyone, While checking a DataRecord table in OneStream Application database, the following three columns exists:  UD34, UD56 and UD78. Does anybody know what is the utility of these colum...
Data Integration
Data Management
Import
Henning's avatar
Henning
Valued Contributor II
7 months ago

Hi,

The Data Record Tables use a Clustered Index. The columns you mention are part of that index. This is intended for more specific focus on the record tables for processing.

I am not aware of another use for them other than the index. As for how to calculate the value of each ID in the columns, what would you need that for? I am not sure whether I am actually allowed to share that information. I hope knowing that these columns are used for the Clustered Index suffices ğŸ™‚