1. Tables and Views for HCM
  2. HRA_EVAL_PARTICIPANTS_R10

HRA_EVAL_PARTICIPANTS_R10

Details

  • Schema: FUSION

  • Object owner: HRA

  • Object type: VIEW

Columns

Name

EVAL_PARTICIPANT_ID

BUSINESS_GROUP_ID

EVALUATION_ID

PERSON_ID

EVAL_ROLE_ID

QUESTIONNAIRE_ID

ROLE_TYPE_CODE

PARTICIPATION_STATUS_CODE

STATUS_UPDATE_DATE

DUE_DATE

ADDED_BY_PERSON_ID

ADDED_BY_ROLE

NOTIFIED_FLAG

NOTIFIED_BY_ROLE

NOTIFIED_BY_PERSON_ID

FDBACK_STARTED_FLAG

FDBACK_SENT_BACK_FLAG

LOCKED_OUT_FLAG

LOCKED_OUT_DATE

FDBACK_COMPLETION_DATE

PCPN_COMMENTS_FOR_WRK

MATRIX_PARTICIPANT_FLAG

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

PCPN_COMMENT_TEXT_FOR_WRK

Query

SQL_Statement

SELECT

HRA_EVAL_PARTICIPANTS.EVAL_PARTICIPANT_ID EVAL_PARTICIPANT_ID,

HRA_EVAL_PARTICIPANTS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

HRA_EVAL_PARTICIPANTS.EVALUATION_ID EVALUATION_ID,

HRA_EVAL_PARTICIPANTS.PERSON_ID PERSON_ID,

HRA_EVAL_PARTICIPANTS.EVAL_ROLE_ID EVAL_ROLE_ID,

HRA_EVAL_PARTICIPANTS.QUESTIONNAIRE_ID QUESTIONNAIRE_ID,

HRA_EVAL_PARTICIPANTS.ROLE_TYPE_CODE ROLE_TYPE_CODE,

HRA_EVAL_PARTICIPANTS.PARTICIPATION_STATUS_CODE PARTICIPATION_STATUS_CODE,

HRA_EVAL_PARTICIPANTS.STATUS_UPDATE_DATE STATUS_UPDATE_DATE,

HRA_EVAL_PARTICIPANTS.DUE_DATE DUE_DATE,

HRA_EVAL_PARTICIPANTS.ADDED_BY_PERSON_ID ADDED_BY_PERSON_ID,

HRA_EVAL_PARTICIPANTS.ADDED_BY_ROLE ADDED_BY_ROLE,

HRA_EVAL_PARTICIPANTS.NOTIFIED_FLAG NOTIFIED_FLAG,

HRA_EVAL_PARTICIPANTS.NOTIFIED_BY_ROLE NOTIFIED_BY_ROLE,

HRA_EVAL_PARTICIPANTS.NOTIFIED_BY_PERSON_ID NOTIFIED_BY_PERSON_ID,

HRA_EVAL_PARTICIPANTS.FDBACK_STARTED_FLAG FDBACK_STARTED_FLAG,

HRA_EVAL_PARTICIPANTS.FDBACK_SENT_BACK_FLAG FDBACK_SENT_BACK_FLAG,

HRA_EVAL_PARTICIPANTS.LOCKED_OUT_FLAG LOCKED_OUT_FLAG,

HRA_EVAL_PARTICIPANTS.LOCKED_OUT_DATE LOCKED_OUT_DATE,

HRA_EVAL_PARTICIPANTS.FDBACK_COMPLETION_DATE FDBACK_COMPLETION_DATE,

SUBSTR(HRA_EVAL_PARTICIPANTS.PCPN_COMMENT_TEXT_FOR_WRK, 1, 4000) PCPN_COMMENTS_FOR_WRK,

HRA_EVAL_PARTICIPANTS.MATRIX_PARTICIPANT_FLAG MATRIX_PARTICIPANT_FLAG,

HRA_EVAL_PARTICIPANTS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

HRA_EVAL_PARTICIPANTS.CREATED_BY CREATED_BY,

HRA_EVAL_PARTICIPANTS.CREATION_DATE CREATION_DATE,

HRA_EVAL_PARTICIPANTS.LAST_UPDATED_BY LAST_UPDATED_BY,

HRA_EVAL_PARTICIPANTS.LAST_UPDATE_DATE LAST_UPDATE_DATE,

HRA_EVAL_PARTICIPANTS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

HRA_EVAL_PARTICIPANTS.PCPN_COMMENT_TEXT_FOR_WRK PCPN_COMMENT_TEXT_FOR_WRK

FROM

HRA_EVAL_PARTICIPANTS