Oracle Fusion · Data dictionary
HRA_EVAL_PARTICIPANTS
SharedUsed in 0 subject areas32 reporting columnsBICC incremental-ready
Talent Review (HRA).
Likely primary key: EVAL_PARTICIPANT_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): EVALUATION_ID → HRA_EVALUATIONS · EVAL_ROLE_ID → HRA_EVAL_ROLES · QUESTIONNAIRE_ID → HRQ_QUESTIONNAIRES_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_CODE | ● | Code identifying the action. | |
| ACTION_PERFORMED_BY | ● | Action performed by. | |
| ACTION_PERFORMED_DATE | ● | Action performed date. | |
| ACTION_REASON | ● | Action reason. | |
| ADDED_BY_PERSON_ID | ● | Identifier for the added by person. | |
| ADDED_BY_ROLE | ● | Added by role. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DUE_DATE | ● | Due date. | |
| EVALUATION_ID | ● | Identifier for the evaluation. | |
| EVAL_PARTICIPANT_ID | PK? | ● | Identifier for the eval participant. |
| EVAL_ROLE_ID | ● | Identifier for the eval role. | |
| FDBACK_COMPLETION_DATE | ● | Fdback completion date. | |
| FDBACK_SENT_BACK_FLAG | ● | Indicator (Y/N) for the fdback sent back. | |
| FDBACK_STARTED_FLAG | ● | Indicator (Y/N) for the fdback started. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LOCKED_OUT_DATE | ● | Locked out date. | |
| LOCKED_OUT_FLAG | ● | Indicator (Y/N) for the locked out. | |
| NOTIFIED_BY_PERSON_ID | ● | Identifier for the notified by person. | |
| NOTIFIED_BY_ROLE | ● | Notified by role. | |
| NOTIFIED_FLAG | ● | Indicator (Y/N) for the notified. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PARTICIPATION_STATUS_CODE | ● | Code identifying the participation status. | |
| PCPN_COMMENTS_FOR_WRK | ● | Pcpn comments for wrk. | |
| PCPN_COMMENT_TEXT_FOR_WRK | ● | Pcpn comment text for wrk. | |
| PERSON_ID | ● | Identifier for the person. | |
| QUESTIONNAIRE_ID | ● | Identifier for the questionnaire. | |
| ROLE_TYPE_CODE | ● | Code identifying the role type. | |
| STATUS_UPDATE_DATE | ● | Status update date. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Subject areas
- ,
Need the extract + dbt staging for HRA_EVAL_PARTICIPANTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table