FCM_USERS, the join every readable report makes
IDs become names here, and one small flag answers a close-week question that matters: which open reconciliations are sitting with someone who is out of office.
Note: ARCS, Oracle's account reconciliation module, tracks who prepares and who reviews. This common table holds the people, and every workflow query joins it for names.
All ARCS table references hang off Tables & views.
◆ The columns, the five that matter.
| Column | What it holds |
|---|---|
| USER_ID | Primary key. What every workflow table points at. |
| FIRST_NAME / LAST_NAME | The names your status report prints instead of IDs. |
| STATUS_FLAG | A = Available, U = Unavailable, out of office. Availability, not workflow status; the two are unrelated and confusing them mis-reads a report. |
| EXTERNAL_USER | Whether the user is external. Worth a column in any access review. |
| who columns | CREATED_BY, LAST_UPDATED_BY, dates. On this table like every other. |
◆ The two uses, names, and the out-of-office join.
Two uses earn this common table its page. Names: the close-day status export joins here so preparers and reviewers appear as people. And close-week staffing: STATUS_FLAG = U is the out-of-office list, per the reference, and joining it against who currently holds open reconciliations answers the Tuesday question nobody enjoys discovering late: whose work is sitting with someone who is away.
The problem: Open work sits with people who are out of office, and it surfaces late.
What we build: Current holders join to availability nightly.
What you get: Tuesday morning flags parked work before it costs a day.
- STATUS_FLAG
- A Available · U Unavailable, out of office. Not workflow.
- the join
- USER_ID to the workflow tables. IDs become names.
- EXTERNAL_USER
- Flagged externals. An access-review column for free.
- the Tuesday question
- Whose open work sits with someone away.