HWR_VLTR_LAST10_PRJ_REGN

Details

Schema: FUSION
Object owner: HHR
Object type: VIEW

Columns

Name
VOLUNTEERSPERPROJECT PROJECTID ORGANIZATIONID

Name

VOLUNTEERSPERPROJECT

PROJECTID

ORGANIZATIONID

Query

SQL_Statement
select count(distinct(B.HCM_PERSON_ID)) as VOLUNTEERSPERPROJECT, B.PROJECT_ID as PROJECTID, A.ORGANIZATIONID as ORGANIZATIONID from HWR_VLTR_VOL_PROJ_REL_VL B, (select PROJECT_ID, ORGANIZATION_ID as ORGANIZATIONID from HWR_VLTR_PROJECT_VL where TO_TIMESTAMP(END_DATE) < CURRENT_TIMESTAMP and rownum < 11 order by END_DATE DESC) A where B.PROJECT_ID = A.PROJECT_ID and B.STATUS = 'VOLUNTEERED' and A.ORGANIZATIONID in (select ENTITY_ID from HWR_VLTR_ADDRESS_VL where ENTITY_TYPE='Organization' ) group by B.PROJECT_ID, A.ORGANIZATIONID

SQL_Statement

select count(distinct(B.HCM_PERSON_ID)) as VOLUNTEERSPERPROJECT, B.PROJECT_ID as PROJECTID, A.ORGANIZATIONID as ORGANIZATIONID from HWR_VLTR_VOL_PROJ_REL_VL B,

(select PROJECT_ID, ORGANIZATION_ID as ORGANIZATIONID from HWR_VLTR_PROJECT_VL

where

TO_TIMESTAMP(END_DATE) < CURRENT_TIMESTAMP

and

rownum < 11

order by END_DATE DESC) A

where B.PROJECT_ID = A.PROJECT_ID

and B.STATUS = 'VOLUNTEERED'

and A.ORGANIZATIONID

in (select ENTITY_ID from HWR_VLTR_ADDRESS_VL

where ENTITY_TYPE='Organization'

)

group by B.PROJECT_ID, A.ORGANIZATIONID