You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Performance Document Query Issue

Received Response
88
Views
1
Comments
edited May 5, 2016 11:46AM in Reporting and Analytics for HCM 1 comment

Content

Hi All,

 

As per the attached screen shot 2150 workers processed under mentioned performance document. When I linked BIP Data base tables to fetch the exact data getting few records only.

 

Below are the tables I am using to fetch the data,

 

SELECT

count(EvaluationEO.worker_id) cnt

from HRA_TMPL_PERIODS_VL htp

,HRA_TMPL_DEFNS_B  htd

,HRA_DOC_TYPES_TL hdt

,HRA_EVALUATIONS EvaluationEO

where 1=1

and htp.CUSTOMARY_NAME='FY2016 Nursing Demographic Questionnaire'

and htp.TEMPLATE_DEFN_ID=htd.TEMPLATE_DEFN_ID

and hdt.DOC_TYPE_ID=htd.DOC_TYPE_ID

and htd.TEMPLATE_DEFN_ID = EvaluationEO.TEMPLATE_DEFN_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!