Forum Discussion

T_Kress's avatar
T_Kress
Valued Contributor
3 years ago

Storage Type Codes / Data Record Status Fields

In the data record tables in the database, there are status code columns.

For example.

Here are what those status codes mean:

Status (Stored Bits)

Existence Type

Storage Type

16

NoData

StoredButNoActivity

17

IsRealData

StoredButNoActivity

18

IsDerivedData

StoredButNoActivity

32

NoData

Input

33

IsRealData

Input

34

IsDerivedData

Input

37

IsDerivedData

StoredButNoActivity

48

NoData

Journals

49

IsRealData

Journals

50

IsDerivedData

Journals

64

NoData

Calculation

65

IsRealData

Calculation

66

IsDerivedData

Calculation

80

NoData

Translation

81

IsRealData

Translation

82

IsDerivedData

Translation

96

NoData

Consolidation

97

IsRealData

Consolidation

98

IsDerivedData

Consolidation

113

IsRealData

DataCellDetail

144

NoData

DurableCalculation

145

IsRealData

DurableCalculation

146

IsDerivedData

DurableCalculation
Infrastructure
  • WernerN's avatar
    WernerN
    Contributor
    3 years ago

    Thank you Teresa!
    One question: Is there a way to tell the difference whether IsRealData at O#Import came from Stage or from a Rule or Form (assuming that one wrote to O#Import instead of O#Form).

    • T_Kress's avatar
      T_Kress
      Valued Contributor
      3 years ago

      I would think perhaps by the Storage Type column in combination with the Status so for example if something was from a calc it would be 64-66 or 144-146 vs 32-34.  

       

       

      • WernerN's avatar
        WernerN
        Contributor
        3 years ago

        Thanks as always Teresa. You are the Best!

  • ericklewis's avatar
    ericklewis
    New Contributor III
    2 months ago

    Hi Teresa, are there additional records to this reference chart that you can share? I am coming across a status code of 2, and I am not sure what kind of data it is. 

    Any help would be greatly appreciated. 

    Thanks!

    • T_Kress's avatar
      T_Kress
      Valued Contributor
      2 months ago

      I checked both knowledge base articles and prior cases and I cannot find any updates nor saw a status code of 2 in any lists.  Perhaps open a support ticket to get clarification if no one else responds.