Storage Type Codes / Data Record Status Fields

Forum|Forum|3 years ago
August 4, 2022
3 replies
0 views

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

L

LeeB

Really useful, thanks!

W

WernerN

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

T_KressAuthor

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.

W

WernerN

Thanks as always Teresa. You are the Best!

E

ericklewis

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

T_KressAuthor

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded