1. Tables and Views for HCM
  2. HHR_VLTR_TEAM_BASIC_INFO_VL

HHR_VLTR_TEAM_BASIC_INFO_VL

Details

  • Schema: FUSION

  • Object owner: HHR

  • Object type: VIEW

Columns

Name

TEAM_ID

TEAM_NAME

DESCRIPTION

TEAM_MEMBERS

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT TEAM.TEAM_ID,

TEAM.TEAM_NAME,

TEAM.DESCRIPTION,

TEAM_MEMBERS.TEAM_MEMBERS,

TEAM.CREATED_BY,

TEAM.CREATION_DATE,

TEAM.LAST_UPDATE_DATE,

TEAM.LAST_UPDATED_BY,

TEAM.LAST_UPDATE_LOGIN

FROM HWR_TEAM TEAM,

(SELECT TEAM.TEAM_ID, COUNT(TEAM_MEMBER.PERSON_ID) TEAM_MEMBERS

FROM HWR_TEAM TEAM, HWR_TEAM_MEMBER TEAM_MEMBER

WHERE TEAM.STATUS = 'ACTIVE'

AND TEAM.TEAM_ID = TEAM_MEMBER.TEAM_ID

AND TEAM_MEMBER.IS_DELETED = 0

AND TEAM_MEMBER.STATUS = 'ACTIVE'

GROUP BY TEAM.TEAM_ID) TEAM_MEMBERS

WHERE TEAM.TEAM_ID = TEAM_MEMBERS.TEAM_ID