Table naming conventions

---

Cognos Planning – Contributor Administration Console



We use different table naming conventions for storing, loading, error statuses.

im_ this is used to store import data.
ie_ this is used to store errors occurred.
et_ this is used to store user entered data.
it_ system tables- used to manage items of d-lists/e-list
cy_ system tables- used to manage hierarchy of various d-lists/e-list.
sy_ system tables- used to manage hierarchy of various d-lists/e-list.

cy and sy both tables are different only in one aspect. sy contains 'leaf code' column also.