
##################################
#
# @file: extraction.properties
# @author: Josh Molina
# @version: 1.0
# @since: February 2012
#
###################################

dmp.qstatementid=Question \/ Statement Identifier
dmp.qstatement=Question/Statement, Educational Content or Vendor Instruction
dmp.response=Response
dmp.alertstatus=Alert Status
dmp.freqquestions=Frequency Of Questions
dmp.fbackeducation=Feedback \/ Educational Content
dmp.lblgoto=GoTo
dmp.vendorinstr=Vendor Instructions
dmp.dmpid=DMP ID
dmp.dmpname=Name
dmp.dmpdesc=Description
dmp.dmpobj=Objective
dmp.dmptag=DMP Tag
dmp.dmpcontentid=DMP Content ID
dmp.dmpcontenttypeid=DMP Content Type ID


#
# QUERY
#
dmp.query = SELECT dc.CONTENT_ORDER as "Question/Statement Identifier", \
	   dc.CONTENT as "QUESTION/STATEMENT", \
	   dr.RESPONSE_CONTENT as "RESPONSE",\
	   at.NAME as "ALERT STATUS",\
	   dc.FREQUENCY as "FREQUENCY OF QUESTION",  \
	   dr.EDU_CONTENT as "FEEDBACK/EDUCATION", \
	   dr.NXT_QUESTION_ID as "GO TO",  \
	   dr.VNDR_I_CONTENT as "VENDOR INSTRUCTIONS", \
	   dmp.DMP_ID,\
	   dmp.NAME, \
	   dmp.DESCRIPTION,\
	   dmp.OBJECTIVE, \
	   dmp.DMP_TAG, \
	   dc.DMP_CONTENT_ID, \
	   dc.CONTENT_TYPE_ID \
  FROM HTIE_dev.dmp.DMP dmp, HTIE_dev.dmp.DMP_CONTENT dc \
	   LEFT OUTER JOIN HTIE_dev.dmp.DMP_RESPONSE dr \
    ON dc.DMP_CONTENT_ID = dr.DMP_CONTENT_ID \
  LEFT OUTER JOIN HTIE_dev.dmp.DMP_ALERT_TYPE at \
    ON dr.ALERT_LEVEL_ID = at.ID \
 WHERE dmp.DMP_ID = dc.DMP_ID \
 ORDER BY dc.CONTENT_TYPE_ID,dc.CONTENT_ORDER \
 