1. Tables and Views for HCM
  2. HWM_TM_REP_XFR_QUERY_4PYR_V

HWM_TM_REP_XFR_QUERY_4PYR_V

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: VIEW

Columns

Name

TM_REC_GRP_ID

TM_REC_GRP_VERSION

PERSON_ID

ASSIGNMENT_ID

XFR_READY_REC_GRP_ID

MARK_FOR_TRANSFER

START_TIME

STOP_TIME

Query

SQL_Statement

SELECT CALC_REC_GRP_ID TM_REC_GRP_ID,

CALC_REC_GRP_VERSION TM_REC_GRP_VERSION,

RESOURCE_ID PERSON_ID,

SUBRESOURCE_ID ASSIGNMENT_ID,

XFR_READY_REC_GRP_ID,

MARK_FOR_TRANSFER,

START_TIME,

STOP_TIME

FROM HWM_XFR_READY_REC_GRP

WHERE TCSMRS_ID =

(SELECT TCSMRS_ID FROM HWM_TCSMRS_B WHERE TCSMRS_CODE = 'PYR'

)

AND XFR_STATUS = 1