I've been building some reports using the public schema guide and have run into a number of places where the documentation leaves me with questions. In particular, I am interested in the following views and columns:
| View | Column | Question |
|---|---|---|
| USER_ACCOUNT_MAPPING | STATE | What, specifically, do each of the possible values mean? |
| REVIEW_COMPONENT | IS_COMMITTED | What does "committed" mean? |
| REVIEW_COMPONENT | IS_HIDDEN | When would this be true? |
| REVIEW_COMPONENT | IS_LOCKED | When would this be true? |
| REVIEW_COMPONENT | REVIEW_COMP_MAP_ID | Is there something that this joins to in the public schema? |
| REVIEW_COMPONENT | REVIEW_ITEM_ID | Is there something that this joins to in the public schema? |
| REVIEW_COMPONENT | USER_ENT_ID | Is there something that this joins to in the public schema? |
| REVIEW_COMPONENT | IS_COMPONENT_DELETED | When would this be true? |
| REVIEW_COMPONENT | IS_SUB_COMPONENT_DELETED | What is this? |
Does anyone have answers to these?